Friday, March 30, 2007
SQL Server 2005 Performance Dashboards Error: "the 'version_string' parameter is missing an attribute"
So I'm trying to get the SQL Server 2005 Performance Dashboard reports installed on my SQL Server 2005 Developer Edition and I'm not getting anywhere...
I successfully run SETUP.SQL so that it adds the necessary support objects into the MSDB but I cannot get a single report to run :(
I get a variety of errors:
I've tried this on two separate machines, one S.E. and one D.E. edition. Both are running 9.0.3050 (so don't ask if I have installed kb933508, cuz I have!).
Help! Anyone know why I'm getting these failures? I've googled/yahoo'ed and the only site I came up with was something in Russian and it didn't offer any solution (that I could tell).
I successfully run SETUP.SQL so that it adds the necessary support objects into the MSDB but I cannot get a single report to run :(
I get a variety of errors:
- Report parameter 'session_id' was not found
- The 'version_string' parameter is missing a value
- Report parameter 'include_system_processes' is missing a value
I've tried this on two separate machines, one S.E. and one D.E. edition. Both are running 9.0.3050 (so don't ask if I have installed kb933508, cuz I have!).
Help! Anyone know why I'm getting these failures? I've googled/yahoo'ed and the only site I came up with was something in Russian and it didn't offer any solution (that I could tell).
Labels: sql 2005, sql server, sql server 2005
Comments:
Links to this post:
<< Home
Open the performance_dashboard_main.rdl file. All other reports are accessed as drill throughs off of that main page, which passes through the necessary parameters.
# posted by 
: 8:59 PM
: 8:59 PM
You RULE - thank you. I should've RTFM a little closer (which I did do BTW but not close enough!). In the docs, it says, " The first time you choose the Custom Report option you will be prompted to choose the report to run. Browse to this share and select the performance_dashboard_main.rdl report file. Future access to the dashboard can be done using the recent file list..." I just missed that part.
Suggestion for the docs: make that part, since it is so critical, a little more obvious.
Thank you, Mr/Mrs Anonymous :)
Suggestion for the docs: make that part, since it is so critical, a little more obvious.
Thank you, Mr/Mrs Anonymous :)
When attempting to view performance_dashboard_main.rdl in SSMS, I get the error "Difference of two datetime columns caused overflow at runtime".
# posted by : 9:49 AM
: 9:49 AM
To fix the "Difference of two datetime columns caused overflow at runtime" error, in the setup.sql file replace the line:
sum(convert(bigint, datediff(ms, Login_time, getdate()))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,
with:
sum(convert(bigint, CAST ( DATEDIFF ( minute, Login_time, getdate()) AS BIGINT)*60000 + DATEDIFF ( millisecond, DATEADD ( minute, DATEDIFF ( minute, Login_time, getdate() ), Login_time ),getdate() ))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,
That should fix the error that you're seeing.
Post a Comment
sum(convert(bigint, datediff(ms, Login_time, getdate()))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,
with:
sum(convert(bigint, CAST ( DATEDIFF ( minute, Login_time, getdate()) AS BIGINT)*60000 + DATEDIFF ( millisecond, DATEADD ( minute, DATEDIFF ( minute, Login_time, getdate() ), Login_time ),getdate() ))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,
That should fix the error that you're seeing.
Links to this post:
<< Home
