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