logo

Previous Thread:   -2147319779 Automation error

5/26/2006 5:12:20 AM    Adding Resources ODBC error
Hi  
  
I'm having problems where when I try to use the standard Single  
  
Attachment Placeholder in a template to add an attachment I get the  
  
error "Server ODBC Error.  Contact the Site Administrator"  The  
  
template is basic, there's no added code and it has worked fine in the  
  
past.  
  
When I try to drag a file straight to the resource gallery I get the  
  
error "The file has caused an error and cannot be imported into the  
  
database. Error description: The underlying connection was closed.  An  
  
unexpected error occured on a receive."  
  
When we try using the resource manager we get the error:  
  
Failures occurred during the multi-object rollback. The session  
  
transaction was rolled back. Contact the site administrator.  
  
Description: An unhandled exception occurred during the execution of  
  
the current web request. Please review the stack trace for more  
  
information about the error and where it originated in the code.  
  
Exception Details: System.Runtime.InteropServices.COMException:  
  
Failures occurred during the multi-object rollback. The session  
  
transaction was rolled back. Contact the site administrator.  
  
Source Error:  
  
An unhandled exception was generated during the execution of the  
  
current web request. Information regarding the origin and location of  
  
the exception can be identified using the exception stack trace below.  
  
Stack Trace:  
  
[COMException (0x80041bd2): Failures occurred during the multi-object  
  
rollback.  The session transaction was rolled back. Contact the site  
  
administrator.]  
  
Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.RollbackAll()  
  
+0  
  
Microsoft.ContentManagement.Publishing.CmsContext.RollbackAll() +38  
  
[CmsConcurrentWriteException: Failures occurred during the multi-object  
  
rollback.  The session transaction was rolled back. Contact the site  
  
administrator.]  
  
Microsoft.ContentManagement.Publishing.CmsContext.RollbackAll() +57  
  
Microsoft.ContentManagement.WebAuthor.ResourceCreate.OnResourceCreate(Object  
  
sender, EventArgs e) +336  
  
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108  
  
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String  
  
eventArgument) +57  
  
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler  
  
sourceControl, String eventArgument) +18  
  
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)  
  
+33  
  
System.Web.UI.Page.ProcessRequestMain() +1292  
  
I tried with a few very tiny txt and rtf files and they seemed to  
  
upload just fine, the errors start kicking in with .doc and .pdf files  
  
Any ideas?



5/26/2006 2:24:47 PM    Re: Adding Resources ODBC error
Hi Cidge,  
  
I have seen such errors when the transaction log was full.  
  
Please have a look in the event log on SQL server to see if any problems are  
  
noted there.  
  
Cheers,  
  
Stefan  
  
--  
  
This posting is provided "AS IS" with no warranties, and confers no rights  
  
New to MCMS?  
  
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44  
  
Check out the new book as well: Advanced MCMS development:  
  
http://tinyurl.com/8ugwj  
  
----------------------  
  
"Cidge" <celine.kavanagh@gmail.com> wrote in message  
  
news:1148645540.688912.124280@u72g2000cwu.googlegroups.com...

5/29/2006 4:12:54 AM    Re: Adding Resources ODBC error
Hi Stefan  
  
Thanks for that, wasn't the problem but put me on the right track.  
  
Problem manifested itself after we set up replication - noticed lots of  
  
errors with "Length of text, ntext, or image data  to be replicated  
  
exceeds configured maximum 65536. "  
  
Fixed it with  
  
sp_configure 'max_text_repl_size' , size  
  
(where size is an integer specifying the maximum row size to be  
  
replicated. )  
  
Thanks for your help!  
  
C

5/29/2006 1:21:46 PM    Re: Adding Resources ODBC error
Hi Cidge,  
  
are you using database replication on SQL?  
  
This can lead to database inconsistancies when using with MCMS and is not  
  
supported!  
  
See here for an official statement:  
  
http://support.microsoft.com/default.aspx?id=315532  
  
Cheers,  
  
Stefan  
  
--  
  
This posting is provided "AS IS" with no warranties, and confers no rights  
  
New to MCMS?  
  
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44  
  
Check out the new book as well: Advanced MCMS development:  
  
http://tinyurl.com/8ugwj  
  
----------------------  
  
"Cidge" <celine.kavanagh@gmail.com> wrote in message  
  
news:1148901174.746068.94600@j33g2000cwa.googlegroups.com...

5/31/2006 2:25:33 PM    Re: Adding Resources ODBC error
Hi Stefan  
  
It was done for backup purposes but we've changed the backup method so  
  
we've removed the replication - thanks for letting us know!!  
  
Celine  
  
Stefan [MSFT] wrote: