Server ODBC Error. Contact Your System Administrator
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > Microsoft Content Management Server > Server ODBC Error. Contact Your System Administrator




Pages (2): [1] 2 »   Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    Server ODBC Error. Contact Your System Administrator  
yakamoz


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-20-04 10:48 PM

Hi Everyone,

I am currently trying to finalize a mcms project. We have several serious
problems.I am not sure code is written correctly since I started at the and
of the project from a friend mine...:-(

1. System is getting so slow after 2 or 3 hours and each time cpu usage goes
99% and asp.net process is consuming >%60 then this process is restarted.

2. We got "Server ODBC Error Contact the site Administrator" message
frequntly. With "ComException 0x80041b67" &
Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne
lItemIsVi.."

3. I am trying to relase .NET managed memory if its exceed %50 percent of
total system memory. To do is I am checcking memory status when a session is
started and if it neccessary I am freeing .NET managed heap. But still
significant amount of memory is not released with respect to pure .NET
applications and my test applications.

4. Which points I must be carefull when wroking with CMS API? For which
objects can I use such a method Dispose() or Finalize() to realase CMS API
used memory which are COM based memory allocations..

Thank You...





[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
Stefan [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-20-04 10:48 PM

Hi Yakamoz,

please check if your application uses CmsApplicationContext.
The ODBC error is often seen if the CmsApplicationContext in a web
application is not correctly disposed:
http://download.microsoft.com/downl...>
MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6

Cheers,
Stefan.


"yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
news:B365CEA1-D5FE-4744-8BF3-FFFBEE8C4A32@microsoft.com...
> Hi Everyone,
>
> I am currently trying to finalize a mcms project. We have several serious
> problems.I am not sure code is written correctly since I started at the
and
> of the project from a friend mine...:-(
>
> 1. System is getting so slow after 2 or 3 hours and each time cpu usage
goes
> 99% and asp.net process is consuming >%60 then this process is restarted.
>
> 2. We got "Server ODBC Error Contact the site Administrator" message
> frequntly. With "ComException 0x80041b67" &
>
Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne
lItemIsVi.."
>
> 3. I am trying to relase .NET managed memory if its exceed %50 percent of
> total system memory. To do is I am checcking memory status when a session
is
> started and if it neccessary I am freeing .NET managed heap. But still
> significant amount of memory is not released with respect to pure .NET
> applications and my test applications.
>
> 4. Which points I must be carefull when wroking with CMS API? For which
> objects can I use such a method Dispose() or Finalize() to realase CMS API
> used memory which are COM based memory allocations..
>
> Thank You...







[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
yakamoz


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-20-04 10:48 PM

Ok I will try to fix that class related problems.


"Stefan [MSFT]" wrote:

> Hi Yakamoz,
>
> please check if your application uses CmsApplicationContext.
> The ODBC error is often seen if the CmsApplicationContext in a web
> application is not correctly disposed:
> http://download.microsoft.com/downl...
a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6
>
> Cheers,
> Stefan.
>
>
> "yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
> news:B365CEA1-D5FE-4744-8BF3-FFFBEE8C4A32@microsoft.com... 
> and 
> goes 
> Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChan
ne
> lItemIsVi.." 
> is 
>
>
>





[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
yakamoz


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-20-04 10:48 PM

Hi Stefan,

I searched Dispose() method. I found those classses have Dispose() moethod
in CMS API:

-> CMSHttpContext
-> CmsContext
-> CMSHttpApplication..

and some more. My question is how to / where to call Dispose method ( or any
toher )? I saw that, in code, objects are created by CmsContext or
CMShttpContext.Current class. So Where sould I use it? Can u give me some
code sample? For instance When I am listing all the postings of a channel ho
w
can I use Dispose() or any cleanup method?

Thank you..


"Stefan [MSFT]" wrote:

> Hi Yakamoz,
>
> please check if your application uses CmsApplicationContext.
> The ODBC error is often seen if the CmsApplicationContext in a web
> application is not correctly disposed:
> http://download.microsoft.com/downl...
a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6
>
> Cheers,
> Stefan.
>
>
> "yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
> news:B365CEA1-D5FE-4744-8BF3-FFFBEE8C4A32@microsoft.com... 
> and 
> goes 
> Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChan
ne
> lItemIsVi.." 
> is 
>
>
>





[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
Stefan [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-20-04 10:48 PM

Hi Yakamoz,

please search for CmsApplicationContext and ensure that all instances of
this object are disposed.
Other objects should not be affected by the ODBC error.

Cheers,
Stefan.

"yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
news:E6D66605-403B-4A29-9447-B2B9C0E631A0@microsoft.com...
> Hi Stefan,
>
> I searched Dispose() method. I found those classses have Dispose() moethod
> in CMS API:
>
>  -> CMSHttpContext
>  -> CmsContext
>  -> CMSHttpApplication..
>
> and some more. My question is how to / where to call Dispose method ( or
any
> toher )? I saw that, in code, objects are created by CmsContext or
> CMShttpContext.Current class. So Where sould I use it? Can u give me some
> code sample? For instance When I am listing all the postings of a channel
how[vbcol=seagreen]
> can I use Dispose() or any cleanup method?
>
> Thank you..
>
>
> "Stefan [MSFT]" wrote:
> 
[url]http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+[/ur
l](complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6[vbcol=seagreen] 
serious[vbcol=seagreen] 
the[vbcol=seagreen] 
usage[vbcol=seagreen] 
restarted.[vbcol=seagreen] 
Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne[vbcol=seagreen]
 
of[vbcol=seagreen] 
session[vbcol=seagreen] 
which[vbcol=seagreen] 
API[vbcol=seagreen] 







[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
yakamoz


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-20-04 10:48 PM

Non of its instance created. But some objects are created by using it.. So
what should I use in order to release memory..?


"Stefan [MSFT]" wrote:

> Hi Yakamoz,
>
> please search for CmsApplicationContext and ensure that all instances of
> this object are disposed.
> Other objects should not be affected by the ODBC error.
>
> Cheers,
> Stefan.
>
> "yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
> news:E6D66605-403B-4A29-9447-B2B9C0E631A0@microsoft.com... 
> any 
> how 
> http://download.microsoft.com/downl...
a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6 
> serious 
> the 
> usage 
> restarted. 
> Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChan
ne 
> of 
> session 
> which 
> API 
>
>
>





[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
Stefan [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-20-04 10:48 PM

hi,

you need to adjust these components.
The dispose method needs to be called in the module that create this
context.

Cheers,
Stefan.

"yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
news:B53D4348-4063-4AE0-9B04-81509E1F31A9@microsoft.com...[vbcol=seagreen]
> Non of its instance created. But some objects are created by using it.. So
> what should I use in order to release memory..?
>
>
> "Stefan [MSFT]" wrote:
> 
moethod[vbcol=seagreen] 
( or[vbcol=seagreen] 
some[vbcol=seagreen] 
channel[vbcol=seagreen] 
[url]http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+[/ur
l](complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6[vbcol=seagreen] 
at[vbcol=seagreen] 
message[vbcol=seagreen] 
Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne[vbcol=seagreen]
 
percent[vbcol=seagreen] 
still[vbcol=seagreen] 
.NET[vbcol=seagreen] 
CMS[vbcol=seagreen] 







[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
yakamoz


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-22-04 10:52 PM

Hi Stefan,

1. In order to get better performance should we use CmsHttpContext.Dispose
metohod?

2. When I added CmsHttpContext.Dispose() to each controls in 2 places

a. Methods which creates objects wtih CmsHttpContext.Current
b. Added new event & related event handler for OnUnload() and call
Dispose method of CmsHttpContext inside OnUnload event handler.

Those modifications works well in live mode. But If we try to edit a posting
( each posting consists of atl east 2-3 custom controls written by us) it
give error. Thus should we clear Dispose related codes in controls and add
Unload event to templates with CmsHttpContext.Dispose()? Or what is ur
suggesstions?

3. where can I find cms caching related documents / articles or sample codes
espacially ASP.NEt out cahce part...?

Thank You alot ...


"Stefan [MSFT]" wrote:

> hi,
>
> you need to adjust these components.
> The dispose method needs to be called in the module that create this
> context.
>
> Cheers,
> Stefan.
>
> "yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
> news:B53D4348-4063-4AE0-9B04-81509E1F31A9@microsoft.com... 
> moethod 
> ( or 
> some 
> channel 
> http://download.microsoft.com/downl...
a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6 
> at 
> message 
> Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChan
ne 
> percent 
> still 
> ..NET 
> CMS 
>
>
>





[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
Stefan [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-22-04 10:52 PM

Hi,

1) you should not dispose CmsHttpContext. Only CmsApplicationContext.
Also not for performance reasons but to avoid the ODBC error.

2) don't dispose CmsHttpContext!

3) the MCMS docs contain a chapter for this.
http://msdn.microsoft.com/library/d...aching_gind.asp

Cheers,
Stefan.


"yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
news:D3D33835-F029-420D-985E-30FC37E3A810@microsoft.com...
> Hi Stefan,
>
> 1. In order to get better performance should we use CmsHttpContext.Dispose
> metohod?
>
> 2. When I added CmsHttpContext.Dispose() to each controls in 2 places
>
>     a. Methods which creates objects wtih CmsHttpContext.Current
>     b. Added new event & related event handler for OnUnload() and call
> Dispose method of CmsHttpContext inside OnUnload event handler.
>
> Those modifications works well in live mode. But If we try to edit a
posting
> ( each posting consists of atl east 2-3 custom controls written by us) it
> give error. Thus should we clear Dispose related codes in controls and add
> Unload event to templates with CmsHttpContext.Dispose()? Or what is ur
> suggesstions?
>
> 3. where can I find cms caching related documents / articles or sample
codes[vbcol=seagreen]
> espacially ASP.NEt out cahce part...?
>
> Thank You alot ...
>
>
> "Stefan [MSFT]" wrote:
> 
it.. So[vbcol=seagreen] 
instances of[vbcol=seagreen] 
method[vbcol=seagreen] 
me[vbcol=seagreen] 
web[vbcol=seagreen] 
[url]http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+[/ur
l](complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6[vbcol=seagreen] 
several[vbcol=seagreen] 
started[vbcol=seagreen] 
cpu[vbcol=seagreen] 
Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne[vbcol=seagreen]
 
when a[vbcol=seagreen] 
But[vbcol=seagreen] 
pure[vbcol=seagreen] 
For[vbcol=seagreen] 
realase[vbcol=seagreen] 







[ Post a follow-up to this message ]



    Re: Server ODBC Error. Contact Your System Administrator  
yakamoz


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
12-23-04 12:47 PM

So how can we be sure that our objects are realased resources those are
created by CmsHttpContext.Current ?

"Stefan [MSFT]" wrote:

> Hi,
>
> 1) you should not dispose CmsHttpContext. Only CmsApplicationContext.
> Also not for performance reasons but to avoid the ODBC error.
>
> 2) don't dispose CmsHttpContext!
>
> 3) the MCMS docs contain a chapter for this.
> http://msdn.microsoft.com/library/d...aching_gind.asp
>
> Cheers,
> Stefan.
>
>
> "yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
> news:D3D33835-F029-420D-985E-30FC37E3A810@microsoft.com... 
> posting 
> codes 
> it.. So 
> instances of 
> method 
> me 
> web 
> http://download.microsoft.com/downl...
a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6 
> several 
> started 
> cpu 
> Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChan
ne 
> when a 
> But 
> pure 
> For 
> realase 
>
>
>





[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 01:07 PM.      Post New Thread    Post A Reply      
Pages (2): [1] 2 »   Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register