Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Actuate 8 designer SQL data source connection error

From: hcmjo (2012-08-31 12:52)

Using actuate epro designer, modifying a report that currently runs in Production. It is using a basic SQL statement with NO ORDER clause.
The build process completes but when the report is run, there is a problem with the data source connecting on a SQL error with the ORDER clause which does not exist in the report query.

I've tried comparing down to the finite detail of other reports and their database connections, libraries, global parameters, etc and there is no difference.
I'm also able to run other reports successfully with the same ODBC connection.
Any suggestions?
Here is the bad return:
Basic Error: 1011 Module: C:\Actuate8\eRDPro\afc\db.bas Line: 193
Database Error 2: Error generated by the connected data source ... 156: [SQL State] 37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'ORDER'.


From: wwilliams (2012-08-31 06:29)

Check you obtainselectstatement() method of your datastream
 
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: hcmjo <joanne_waddell@hcm.honda.com>
To: MAXIMO@yahoogroups.com
Sent: Friday, August 31, 2012 7:52 AM
Subject: [MAXIMO List] Actuate 8 designer SQL data source connection error

 
Using actuate epro designer, modifying a report that currently runs in Production. It is using a basic SQL statement with NO ORDER clause.
The build process completes but when the report is run, there is a problem with the data source connecting on a SQL error with the ORDER clause which does not exist in the report query.
I've tried comparing down to the finite detail of other reports and their database connections, libraries, global parameters, etc and there is no difference.
I'm also able to run other reports successfully with the same ODBC connection.
Any suggestions?
Here is the bad return:
Basic Error: 1011 Module: C:\Actuate8\eRDPro\afc\db.bas Line: 193
Database Error 2: Error generated by the connected data source ... 156: [SQL State] 37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'ORDER'.