Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
lashari1 Trusted Contributor.
Trusted Contributor.
4869 views

SSC Report generation Error - SQLServerException: Incorrect syntax near 'DESIGN'

I use:
* Fortify 18.20
* SQL Server 2016
* Java 1.8
* JDBC: sqljdbc42.jar

After starting the report generation, I get the error:
2018-12-17 15: 31: 12,963 [ERROR] com.fortify.birtrunner.Main - savedReportId = 3 Report generation failed
com.fortify.birtrunner.exception.BirtReportGenerationException: Unable to generate the report
                at com.fortify.birtrunner.BirtRunner.renderReport (BirtRunner.java:92) ~ [birtrunner-18.20.1071.jar :?]
                at com.fortify.birtrunner.Main.main (Main.java:93) [birtrunner-18.20.1071.jar :?]
Caused by: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'DESIGN'. Query: select data from reportexecblob WHERE savedReport_id =? and blobType = 'DESIGN' Parameters: [3]
                at org.apache.commons.dbutils.AbstractQueryRunner.rethrow (AbstractQueryRunner.javaUE92) ~ [commons-dbutils-1.6.jar: 1.6]
                at org.apache.commons.dbutils.QueryRunner.query (QueryRunner.java:3751) ~ [commons-dbutils-1.6.jar: 1.6]
                at org.apache.commons.dbutils.QueryRunner.query (QueryRunner.java:212) ~ [commons-dbutils-1.6.jar: 1.6]
                at com.fortify.birtrunner.IOUtils.downloadBlob (IOUtils.java:61) ~ [birtrunner-18.20.1071.jar :?]
                at com.fortify.birtrunner.BirtRunner.getReportDesign (BirtRunner.java:127) ~ [birtrunner-18.20.1071.jar :?]
                at com.fortify.birtrunner.BirtRunner.renderReport (BirtRunner.java:69) ~ [birtrunner-18.20.1071.jar :?]
                ... 1 more

How can I fix this?
Thank!

Labels (1)
0 Likes
2 Replies
Micro Focus Expert
Micro Focus Expert

Re: SSC Report generation Error - SQLServerException: Incorrect syntax near 'DESIGN'

Hi,

Couple of quick questons to get some more information. Is this problem seen for default reports or custom reports? Any more information in the ssc_birtrunner.log file?

 

Regards,
Tejesh Chandra K H

0 Likes
lashari1 Trusted Contributor.
Trusted Contributor.

Re: SSC Report generation Error - SQLServerException: Incorrect syntax near 'DESIGN'

Hi!

"Is this problem seen for default reports or custom reports?"

The same error for diferent types of reports.

 

Here is the ssc_birtrunner.log file

 

2018-12-11 17:41:57,435 [INFO] com.fortify.birtrunner.Main - savedReportId=1 Report generation started enhancedSecurity=false java_version=1.8.0_191
2018-12-11 17:41:58,745 [ERROR] com.fortify.birtrunner.Main - savedReportId=1 Report generation failed
com.fortify.birtrunner.exception.BirtReportGenerationException: Unable to generate the report
at com.fortify.birtrunner.BirtRunner.renderReport(BirtRunner.java:92) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.Main.main(Main.java:93) [birtrunner-18.20.1071.jar:?]
Caused by: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'DESIGN'. Query: select data from reportexecblob WHERE savedReport_id = ? and blobType = 'DESIGN' Parameters: [1]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:351) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:212) ~[commons-dbutils-1.6.jar:1.6]
at com.fortify.birtrunner.IOUtils.downloadBlob(IOUtils.java:61) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.BirtRunner.getReportDesign(BirtRunner.java:127) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.BirtRunner.renderReport(BirtRunner.java:69) ~[birtrunner-18.20.1071.jar:?]
... 1 more
2018-12-12 09:33:44,154 [INFO] com.fortify.birtrunner.Main - savedReportId=2 Report generation started enhancedSecurity=false java_version=1.8.0_191
2018-12-12 09:33:45,470 [ERROR] com.fortify.birtrunner.Main - savedReportId=2 Report generation failed
com.fortify.birtrunner.exception.BirtReportGenerationException: Unable to generate the report
at com.fortify.birtrunner.BirtRunner.renderReport(BirtRunner.java:92) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.Main.main(Main.java:93) [birtrunner-18.20.1071.jar:?]
Caused by: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'DESIGN'. Query: select data from reportexecblob WHERE savedReport_id = ? and blobType = 'DESIGN' Parameters: [2]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:351) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:212) ~[commons-dbutils-1.6.jar:1.6]
at com.fortify.birtrunner.IOUtils.downloadBlob(IOUtils.java:61) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.BirtRunner.getReportDesign(BirtRunner.java:127) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.BirtRunner.renderReport(BirtRunner.java:69) ~[birtrunner-18.20.1071.jar:?]
... 1 more
2018-12-17 15:31:11,338 [INFO] com.fortify.birtrunner.Main - savedReportId=3 Report generation started enhancedSecurity=false java_version=1.8.0_191
2018-12-17 15:31:12,963 [ERROR] com.fortify.birtrunner.Main - savedReportId=3 Report generation failed
com.fortify.birtrunner.exception.BirtReportGenerationException: Unable to generate the report
at com.fortify.birtrunner.BirtRunner.renderReport(BirtRunner.java:92) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.Main.main(Main.java:93) [birtrunner-18.20.1071.jar:?]
Caused by: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'DESIGN'. Query: select data from reportexecblob WHERE savedReport_id = ? and blobType = 'DESIGN' Parameters: [3]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:351) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:212) ~[commons-dbutils-1.6.jar:1.6]
at com.fortify.birtrunner.IOUtils.downloadBlob(IOUtils.java:61) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.BirtRunner.getReportDesign(BirtRunner.java:127) ~[birtrunner-18.20.1071.jar:?]
at com.fortify.birtrunner.BirtRunner.renderReport(BirtRunner.java:69) ~[birtrunner-18.20.1071.jar:?]
... 1 more

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.