| Author |
Server ODBC Error. Contact Your System Administrator
|
|
| yakamoz 2004-12-20, 5: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.getChannelItemIsVi.."
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...
| |
| Stefan [MSFT] 2004-12-20, 5: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...6a/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...
| |
| yakamoz 2004-12-20, 5: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...6a/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.getChanne
> lItemIsVi.."
> is
>
>
>
| |
| yakamoz 2004-12-20, 5: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 how
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...6a/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.getChanne
> lItemIsVi.."
> is
>
>
>
| |
| Stefan [MSFT] 2004-12-20, 5: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:
>
http://download.microsoft.com/downl...6a/MCMS+2002+-+(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]
| |
| yakamoz 2004-12-20, 5: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...6a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6
> serious
> the
> usage
> restarted.
> Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne
> of
> session
> which
> API
>
>
>
| |
| Stefan [MSFT] 2004-12-20, 5: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]
http://download.microsoft.com/downl...6a/MCMS+2002+-+(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]
| |
| yakamoz 2004-12-22, 5: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...6a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6
> at
> message
> Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne
> percent
> still
> ..NET
> CMS
>
>
>
| |
| Stefan [MSFT] 2004-12-22, 5: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]
http://download.microsoft.com/downl...6a/MCMS+2002+-+(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]
| |
| yakamoz 2004-12-23, 7:47 am |
| 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...6a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6
> several
> started
> cpu
> Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne
> when a
> But
> pure
> For
> realase
>
>
>
| |
| Stefan [MSFT] 2004-12-23, 5:51 pm |
| MCMS itself takes care of this in the
Microsoft.ContentManagement.Web.CmsEndRequestModule
which is included in the web.config file.
Cheers,
Stefan.
"yakamoz" <yakamoz@discussions.microsoft.com> wrote in message
news:690627C2-56FF-4C38-883F-9D6CF8ADBD9D@microsoft.com...[vbcol=seagreen]
> So how can we be sure that our objects are realased resources those are
> created by CmsHttpContext.Current ?
>
> "Stefan [MSFT]" wrote:
>
http://msdn.microsoft.com/library/d...aching_gind.asp[vbcol=seagreen]
CmsHttpContext.Dispose[vbcol=seagreen]
it[vbcol=seagreen]
add[vbcol=seagreen]
Dispose()[vbcol=seagreen]
CmsContext or[vbcol=seagreen]
give[vbcol=seagreen]
of a[vbcol=seagreen]
a[vbcol=seagreen]
http://download.microsoft.com/downl...6a/MCMS+2002+-+(complete)+FAQ.htm#3989EF0D-D31B-481C-97F2-32FCF425C1F6[vbcol=seagreen]
message[vbcol=seagreen]
time[vbcol=seagreen]
process is[vbcol=seagreen]
Administrator"[vbcol=seagreen]
Microsoft.ContentManagement.Interop.Publishing.CmsHttpContextClass.getChanne[vbcol=seagreen]
%50[vbcol=seagreen]
heap.[vbcol=seagreen]
to[vbcol=seagreen]
API?[vbcol=seagreen]
|
|
|
|