Getting a script error with the list box in TRIRIGA BIRT reports


I am working on a TRIRIGA BIRT report using the Multi Value Listbox input parameter. After selecting the value from Listbox, when I try to preview the report, I’m getting the script error. It looks like the selected value is not getting passed to the IN clause of the SELECT statement correctly. ([Ljava.lang.Object;@bb981f25 is passed as input instead of the Company Name). Any help to resolve the error or any other inputs are greatly appreciated.

Script Error:

Caused by: com.tririga.platform.persistence.PersistenceException: Error executing sql: Sql[SQL=SELECT T1.cstCompanyNameTX AS T1_1039, T1.cstCompanyIDTX AS T1_1040, T1.cstLocationIDTX AS T1_1038, T1.Sys_LocationName AS T1_110, T1.Sys_LocationNameObjId AS T1_110_OBJID, T1.SYS_TYPE1 AS T1_SYS_TYPE1, T1.SYS_GUIID AS T1_SYS_GUIID, T1.SPEC_ID AS T1_SPEC_ID FROM T_CSTCOMPANYIDCL T1 WHERE T1.SYS_GUIID = 10044697 AND T1.SYS_PROJECTID = 1 AND T1.cstCompanyNameTX IN ([Ljava.lang.Object;@bb981f25) AND T1.SYS_OBJECTID > 0 ORDER BY UPPER(T1.cstCompanyNameTX), UPPER(T1.cstLocationIDTX),DB transaction ID=(None)]


Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s