Error running report

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. Failed to Execute the Report!Error Description : Status No: 1 :
Basic Error: 1011
Module: afcdb.bas
Line: 187Database 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. I used SQL profiler and saw that the following command is executed by Actuate prior to my stored procedure running. set ansi_nulls off set ansi_padding off set ansi_warnings off set concat_null_yields_null off set quoted_identifier off I do not see the command above executed when I am running the report through the designer. Any help would be appreciated.

Find more posts tagged with

Comments

mwilliams

I've not heard of anyone having an issue like this before. I'll have to try to set something up with MySQL or something to test, as I don't have MS SQL Server. When you create the dataset, you select the "stored procedure query" from the drop down, right. Not sure that would solve anything, but I just wanted to make sure. Can you attach a sample of data similar to yours and a stored procedure similar to what you're using, so I know I've got an accurate test case? Thanks.