May 12, 2008 at 3:07 pm
This is a two-part plea for help ... Im trying to debug some errors with a Cube processing job, the AS instance is on the same box as the SQL instance where the job runs.
I'm currently capturing SQL Trace data and Perfmon counters, but I need to capture AS Trace data as well. As this is a production SQL box, I am starting and stopping all the data collection in job steps, so they only run when the Cube is processing.
(1) I have scripted the default AS Profiler Trace in XMLA, but I'm getting an error, and I dont know enough about XMLA to debug ...
Error:
Executing the query ...
XML parsing failed at line 7, column 53: A text/xml declaration may occur only at the very beginning of input.
.
Execution complete
XMLA (I removed all the Events / Columns except one, so it would be shorter, the result is the same though):
<?xml version="1.0" encoding="utf-8"?>
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ObjectDefinition>
<Trace>
<ID>OLAP_Errors_OLAP_Trace</ID>
<Name>OLAP_Errors_OLAP_Trace</Name>
<Events>
<Event>
<EventID>15</EventID>
<Columns>
<ColumnID>28</ColumnID>
</Columns>
</Event>
</Events>
<Filter>
<NotLike>
<ColumnID>37</ColumnID>
<Value>SQL Server Profiler - 54043a84-7877-4b36-b048-e70f72bf42cf</Value>
</NotLike>
</Filter>
</Trace>
</ObjectDefinition>
</Create>
</Batch>
(2) How can I turn the AS Trace off after the Cube has processed?
TIA ...
May 15, 2008 at 4:14 pm
I found the information - I did a complete write-up, and I'm going to submit it as an article.
August 28, 2013 at 11:27 am
Hi,
How did you solved your issue?
Best,
Duarte
August 28, 2013 at 11:58 am
I'm sorry, but I don't have that information any more.
August 28, 2013 at 2:16 pm
Ok, thanks!
But do you use other tool to do that stuff?
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply