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

[lashari1]

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!

[Tejesh Chandra]

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

[lashari1]

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