dbTalk Databases Forums  

Error message in scheduled job: cannot write a log to table

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Error message in scheduled job: cannot write a log to table in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Renato
 
Posts: n/a

Default Error message in scheduled job: cannot write a log to table - 08-24-2006 , 12:25 AM






Has anyone got this error when scheduling xmla cube via SQL agent??

Executed as user: APAC\SRVWRY-DEVSQL. Warning: cannot write a log to
table. The
step failed.

This is a repeatable error that occurs when processing xmla via SQL
2005 (Job type=SQL Server Analysis Services Command). The problem only
occurs when "Include step output in history" is checked on the advanced
tab of the agent job step editor.

An example xmla that can cause the problem is below:

<Batch
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
<DimensionID>Dim Customer</DimensionID>
</Object>
<Type>ProcessUpdate</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.