Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Error in DTAEngine

Author  Topic 

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2008-04-21 : 11:56:14
just wondering what causes an error in the Database Engine Tuning advisor.


TITLE: DTAEngine
------------------------------

Error: Failed to parse input XML. Could not parse Workload type

------------------------------
BUTTONS:

OK
------------------------------



any advice?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-21 : 22:32:31
How did you generate work load file?
Go to Top of Page

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2008-04-22 : 02:04:10
just a working query in the management studio. query runs fine, but wont when you click the analyze query in database tuning advisor after it loads and start to process it, it kicks the error on the first step
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-22 : 21:55:39
Do you use xml in the query?
Go to Top of Page

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2008-04-22 : 22:02:45
negative. just a normal select statement. i'm not "Cool" enough to use xml :p not quite that advanced. it's actually a batch of probably about 10 quries, i can post it if you'd like.
Go to Top of Page
   

- Advertisement -