nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem with SQL message: ARITHABORT

birtprofi

Hi guys I need your help. If I run the SQL Script below I get the following error within BIRT Report Designer: 
 
 
<blockquote class='ipsBlockquote' >Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata. 
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. 
SQL error #1:SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. 
; 
com.microsoft.sqlserver.jdbc.SQLServerException: SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. 
)</blockquote>
 
But this error-message is only within the BIRT-Designer. I tried to run the SQL Script on MSSQL Server 2008 and there I get no error. 
 
This is a test-script: 
<pre class='_prettyXprint _lang-auto _linenums:0'>create table tmp (col1 varchar(100), col2 varchar(100));
insert into tmp values ('1121', 'abc');
insert into tmp values ('1123', 'aee');
insert into tmp values ('1335', 'afg');
insert into tmp values ('1121', 'def');
insert into tmp values ('1121', 'abc');

SELECT
distinct r.col1,
STUFF((SELECT distinct ','+ a.col2
FROM tmp a
WHERE r.col1 = a.col1
FOR XML PATH(''), TYPE).value('.','VARCHAR(max)'), 1, 1, ''),
(select COUNT(*) cnt from tmp a where r.col1 = a.col1) cnt
FROM tmp r</pre>
 
If you run this script or something like this in the management console of SQL Server you got this result: 
1121 abc,def 3 
1123 aee 1 
1335 afg 1 
 
But if you run the same script in the Report Designer in a Dataset you get the error message as shown above. Please give me your advice what I can do. 
 
Best Regards 
Rafael

Find more posts tagged with

Comments

birtprofi

Hi, any idea?

Tubal

Is STUFF a stored procedure?

This may be relevant: http://stackoverflow.com/questions/1100098/why-do-i-have-to-set-arithabort-on-when-using-xml-in-sql-server-2005

birtprofi

Hi, 
 
"STUFF" is not a stored procedure, it is a MSSQL-Syntax. 
See my first posting: 
<blockquote class='ipsBlockquote' >But this error-message is only within the BIRT-Designer. I tried to run the SQL Script on MSSQL Server 2008 and there I get no error</blockquote>