ODBC Server Error wen Attempting to create connected posting
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
ODBC Server Error wen Attempting to create connected posting

 
Post new topic   Reply to topic    Windows Server Forum Index -> CMS Server
Author Message
Charly
Guest





Posted: Wed Nov 09, 2005 5:51 pm    Post subject: ODBC Server Error wen Attempting to create connected posting Reply with quote

I am trying to use CmsApplicationContext to create a connected Posting
And I am getting System.Runtime.InteropServices.COMException
(0x80041B67)

I have seen other posts on this forum where it was recommended that the
poster create a Microsoft Ticket... Does this mean the problem might be
a Database Inconsistency ? This CMS Sytem is in Development, and we
could load a back up from several weeks ago if that might eliminate the
issue... Is That Possible ?

//Relevant Lines of code are as follows:
// cAC is CmsApplicationContext

Posting sourcePosting = (Posting) cAC.Searches.GetByGuid(guid);
Channel tgtChannel = (Channel)cAC.Searches.GetByGuid(newChanGuid);
Template connTemplate = (Template)cAC.Searches.GetByGuid(tempGuid);
Posting NewPosting = (Posting) tgtChannel.CreateConnectedPosting(
connTemplate ,
sourcePosting);

The error occurs on the last line... And is ...
{"Server ODBC error. Contact the site administrator." }

With following Stack Trace:
***************************************************************************
Microsoft.ContentManagement.Publishing.CmsServerException: Server ODBC
error. Contact the site administrator. --->
System.Runtime.InteropServices.COMException (0x80041B67): Server ODBC
error. Contact the site administrator.
at
Microsoft.ContentManagement.Interop.Publishing.IRcwPosting.__BeginWrite(Boolean
ignoreMarkedForActions)
at Microsoft.ContentManagement.Publishing.Posting.BeginWrite(Boolean
ignoreMarkForActions)
--- End of inner exception stack trace ---
at
Microsoft.ContentManagement.Publishing.Channel.CreateConnectedPosting(Template
sourceTemplate, Posting existingPosting)
at Vss.HS.Sys.CMS.Templates.Article.CreateConnectedArticle(String
guid, String newChanGuid, String newArticleNm) in
c:\inetpub\wwwroot\hscms\templates\article.aspx.cs:line 979
at Vss.HS.Sys.CMS.Templates.Article.AddConnectedChannel(String
sData) in c:\inetpub\wwwroot\hscms\templates\article.aspx.cs:line 925
at Vss.HS.Sys.CMS.Templates.Article.Page_Load(Object sender,
EventArgs e) in c:\inetpub\wwwroot\hscms\templates\article.aspx.cs:line
202
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()
***************************************************************************
Back to top
Stefan [MSFT]
Guest





Posted: Thu Nov 10, 2005 9:51 am    Post subject: Re: ODBC Server Error wen Attempting to create connected pos Reply with quote

Hi Charly,

if the problem occurs in a SearchByGuid then the reason is usually that the
GUID passed into the search is not identifying a MCMS object.

As you are using the CmsApplicationContext please also have a look here:
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6

and here:
http://blogs.technet.com/stefan_gossner/archive/2005/03/07/386526.aspx

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
----------------------


"Charly" <cbretana@areteind.com> wrote in message
news:1131556930.528984.260340@z14g2000cwz.googlegroups.com...
Quote:
I am trying to use CmsApplicationContext to create a connected Posting
And I am getting System.Runtime.InteropServices.COMException
(0x80041B67)

I have seen other posts on this forum where it was recommended that the
poster create a Microsoft Ticket... Does this mean the problem might be
a Database Inconsistency ? This CMS Sytem is in Development, and we
could load a back up from several weeks ago if that might eliminate the
issue... Is That Possible ?

//Relevant Lines of code are as follows:
// cAC is CmsApplicationContext

Posting sourcePosting = (Posting) cAC.Searches.GetByGuid(guid);
Channel tgtChannel = (Channel)cAC.Searches.GetByGuid(newChanGuid);
Template connTemplate = (Template)cAC.Searches.GetByGuid(tempGuid);
Posting NewPosting = (Posting) tgtChannel.CreateConnectedPosting(
connTemplate ,
sourcePosting);

The error occurs on the last line... And is ...
{"Server ODBC error. Contact the site administrator." }

With following Stack Trace:
***************************************************************************
Microsoft.ContentManagement.Publishing.CmsServerException: Server ODBC
error. Contact the site administrator. ---
System.Runtime.InteropServices.COMException (0x80041B67): Server ODBC
error. Contact the site administrator.
at
Microsoft.ContentManagement.Interop.Publishing.IRcwPosting.__BeginWrite(Boolean
ignoreMarkedForActions)
at Microsoft.ContentManagement.Publishing.Posting.BeginWrite(Boolean
ignoreMarkForActions)
--- End of inner exception stack trace ---
at
Microsoft.ContentManagement.Publishing.Channel.CreateConnectedPosting(Template
sourceTemplate, Posting existingPosting)
at Vss.HS.Sys.CMS.Templates.Article.CreateConnectedArticle(String
guid, String newChanGuid, String newArticleNm) in
c:\inetpub\wwwroot\hscms\templates\article.aspx.cs:line 979
at Vss.HS.Sys.CMS.Templates.Article.AddConnectedChannel(String
sData) in c:\inetpub\wwwroot\hscms\templates\article.aspx.cs:line 925
at Vss.HS.Sys.CMS.Templates.Article.Page_Load(Object sender,
EventArgs e) in c:\inetpub\wwwroot\hscms\templates\article.aspx.cs:line
202
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()
***************************************************************************
Back to top
Charly
Guest





Posted: Thu Nov 10, 2005 5:51 pm    Post subject: Re: ODBC Server Error wen Attempting to create connected pos Reply with quote

Stefan,

As usual, right on point out of the box... That fixed it !

Thanks again !

Charly
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> CMS Server All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB