ReportServer Forum

electron36

Member

Registered: 2014-03-18

Error when executing SQL Query on dymamic List datasource

I got this error message when I try to execute SQL Query in Dynamic List datasource against H2 database

Error
Query could not be prepared: Error preparing statement for executing the report query :
SELECT * FROM (SELECT * FROM (SELECT * FROM T_AGG_CUSTOMER) wrappedQry) limitQry WHERE 0 = 1
/* user: 3 */ /* report: 10 */ /* token: 3833c19f-a2f2-485c-b137-609097988a71 */ /* currentuser: 3 */

It don't tell me so much.

Could someone help me to solve this error, please.

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Error when executing SQL Query on dymamic List datasource

Hi,

can you provide some further context? The query is valid H2 SQL. Can you check that the driver selected in the datasource config is indeed H2. Also, please have a look at
the log files for a stacktrace. That should help understand what is going on.

Cheers
-Arno

electron36

Member

Registered: 2014-03-18

Re: Error when executing SQL Query on dymamic List datasource

If you mean which Database driver is selected in Datasource i have selected H2 as Database.
The Query is a simple SQL string that could work on all types of SQL databases.

Where do i find the Log file? Do you mean the logfile for Tomcat? localhost.log or catalina.log

Last edited by electron36 (2015-03-06 11:22:19)

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Error when executing SQL Query on dymamic List datasource

Usually catalina.log but depending on your tomcat it could also be a different one. There should be a stacktrace somewhere.