Staging Service Produces Access Database Error

#1 12-30-2007, 09:41 AM

Hello All,

I saw that my staging operations aborted unexpectedly, when i inspected
the errorLog i saw that Access database connection issue is present.
Below is the eventLog entry for this error:

<Error>
Error occurred with the database StagingLog.mdb. Error is:
System.Data.OleDb.OleDbException: System resource exceeded.
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader()
at
Microsoft.CommerceServer.Staging.Internal.ProjectD eploymentLog.GetStatusForReplication(String
replicationId).
</Error>

When i restarted the commerce server staging service the problem is
solved however i don't want to face this issue again, what is the permenent
resolution?

Regards,
Ziver MALHASOGLU

#2 02-21-2008, 08:37 AM

I have found an article however i cannot find wich projects use the same
directory as source and destination. The following is the article's url:
http://support.microsoft.com/kb/940028

How may i make the CSS application log the events so that i may find the
source of the problem?

"Ziver MALHASOGLU" <zam@zam.web.tr>, haber iletisinde þunlarý
yazdý:%23bp3LIvSIHA.5288@TK2MSFTNGP04.phx.gbl...
> Hello All,
>
> I saw that my staging operations aborted unexpectedly, when i inspected
> the errorLog i saw that Access database connection issue is present.
> Below is the eventLog entry for this error:
>
> <Error>
> Error occurred with the database StagingLog.mdb. Error is:
> System.Data.OleDb.OleDbException: System resource exceeded.
> at
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
> dbParams, Object& executeResult)
> at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&
> executeResult)
> at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
> Object& executeResult)
> at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
> behavior, String method)
> at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
> at System.Data.OleDb.OleDbCommand.ExecuteReader()
> at
> Microsoft.CommerceServer.Staging.Internal.ProjectD eploymentLog.GetStatusForReplication(String
> replicationId).
> </Error>
>
> When i restarted the commerce server staging service the problem is
> solved however i don't want to face this issue again, what is the
> permenent resolution?
>
> Regards,
> Ziver MALHASOGLU
>

#3 02-21-2008, 08:52 AM

Following article may help enabling the CSS logging feature

http://support.microsoft.com/kb/918312

"Ziver MALHASOGLU" <zam@zam.web.tr>, haber iletisinde þunlarý
yazdý:uP3FL6IdIHA.5712@TK2MSFTNGP04.phx.gbl...
>I have found an article however i cannot find wich projects use the same
>directory as source and destination. The following is the article's url:
> http://support.microsoft.com/kb/940028
>
> How may i make the CSS application log the events so that i may find
> the source of the problem?
>
> "Ziver MALHASOGLU" <zam@zam.web.tr>, haber iletisinde þunlarý
> yazdý:%23bp3LIvSIHA.5288@TK2MSFTNGP04.phx.gbl...
>> Hello All,
>>
>> I saw that my staging operations aborted unexpectedly, when i
>> inspected the errorLog i saw that Access database connection issue is
>> present.
>> Below is the eventLog entry for this error:
>>
>> <Error>
>> Error occurred with the database StagingLog.mdb. Error is:
>> System.Data.OleDb.OleDbException: System resource exceeded.
>> at
>> System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
>> dbParams, Object& executeResult)
>> at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&
>> executeResult)
>> at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
>> behavior, Object& executeResult)
>> at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
>> behavior, String method)
>> at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
>> at System.Data.OleDb.OleDbCommand.ExecuteReader()
>> at
>> Microsoft.CommerceServer.Staging.Internal.ProjectD eploymentLog.GetStatusForReplication(String
>> replicationId).
>> </Error>
>>
>> When i restarted the commerce server staging service the problem is
>> solved however i don't want to face this issue again, what is the
>> permenent resolution?
>>
>> Regards,
>> Ziver MALHASOGLU
>>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode