Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
Error running report
Migrateduser
<p>I'm getting the below error while running a report in the management console. It works fine through the designer so I'm not really sure what is going on.</p><p> </p><p><strong>Failed to Execute the Report!</strong></p><p><strong>Error Description : Status No: 1 :
Basic Error: 1011
Module: afcdb.bas
Line: 187</strong></p><p><strong>Database Error
2: Error generated by the connected data source ...
1934: [SQL State] 37000: [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.</strong></p><p> </p><p>I used SQL profiler and saw that the following command is executed by Actuate prior to my stored procedure running.</p><p> </p><p><strong> set ansi_nulls off set ansi_padding off set ansi_warnings off set concat_null_yields_null off set quoted_identifier off</strong></p><p> </p><p>I do not see the command above executed when I am running the report through the designer. Any help would be appreciated.</p>
Find more posts tagged with
Comments
There are no comments yet