Hi,
I am quite new to Cognos. I have a package in Report Studio which has Stored Procedures Tables and View Tables. While creating a report which has some columns from the Tables in Stored Procedures and other columns from Tables in Views, I get this error:
XQE-DAT-0001
Data source adapter error: com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosUnrecoverableConnectionException: [jcc][t4][10120][10898][4.16.53] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null - when processing query: CALL "DBO"."XYZ_REPORT" (
DATE('2015-05-01'),
DATE('2015-05-01')
)
FOR FETCH ONLY.
I have been struggling to get this running and really don't know what causes this. Please advice me on how to get this error solved.
Thanks
acn
Quote from: nac on 06 Jul 2015 01:35:11 PM
Hi,
I am quite new to Cognos. I have a package in Report Studio which has Stored Procedures Tables and View Tables. While creating a report which has some columns from the Tables in Stored Procedures and other columns from Tables in Views, I get this error:
XQE-DAT-0001
Data source adapter error: com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosUnrecoverableConnectionException: [jcc][t4][10120][10898][4.16.53] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null - when processing query: CALL "DBO"."XYZ_REPORT" (
DATE('2015-05-01'),
DATE('2015-05-01')
)
FOR FETCH ONLY.
I have been struggling to get this running and really don't know what causes this. Please advice me on how to get this error solved.
Thanks
acn
Hmmm. Sounds a lot like this:
https://www-304.ibm.com/support/docview.wss?uid=swg21461670
I think you need to do some further testing to see if a specific view or procedure triggers the error. You can then look more closely at the code for the view or procedure to see what's going on.
Cheers!
MF.
Hi,
Thanks, but I did a lot of testing and this happens in all views. I tried it with individual views and SP but same error always.
XQE-DAT-0001
Data source adapter error: com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosUnrecoverableConnectionException: [jcc][t4][10120][10898][4.16.53] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null - when processing query: CALL "DBO"."XYZ_REPORT" (
DATE('2015-05-01'),
DATE('2015-05-01')
)
FOR FETCH ONLY.
Please suggest me a way to resolve this. :(
Thanks,
acn
Quote from: nac on 07 Jul 2015 08:45:19 AM
Hi,
Thanks, but I did a lot of testing and this happens in all views. I tried it with individual views and SP but same error always.
XQE-DAT-0001
Data source adapter error: com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosUnrecoverableConnectionException: [jcc][t4][10120][10898][4.16.53] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null - when processing query: CALL "DBO"."XYZ_REPORT" (
DATE('2015-05-01'),
DATE('2015-05-01')
)
FOR FETCH ONLY.
Please suggest me a way to resolve this. :(
Thanks,
acn
So you're saying the error occurs every time - even with a single view and no procedure (or vice versa)?
How is your data source defined? What is the underlying database?
MF.
hi,
The database is DB2. I have a package in Report Studio which has 'Stored Procedures' Tables and 'View' Tables. While creating a report which has some columns from the Tables in Stored Procedures and other columns from Tables in Views, I get this error.
XQE-DAT-0001
Data source adapter error: com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosUnrecoverableConnectionException: [jcc][t4][10120][10898][4.16.53] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null - when processing query: CALL "DBO"."XYZ_REPORT" (
DATE('2015-05-01'),
DATE('2015-05-01')
)
FOR FETCH ONLY.
acn
Quote from: nac on 07 Jul 2015 12:32:34 PM
hi,
The database is DB2. I have a package in Report Studio which has 'Stored Procedures' Tables and 'View' Tables. While creating a report which has some columns from the Tables in Stored Procedures and other columns from Tables in Views, I get this error.
XQE-DAT-0001
Data source adapter error: com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosUnrecoverableConnectionException: [jcc][t4][10120][10898][4.16.53] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null - when processing query: CALL "DBO"."XYZ_REPORT" (
DATE('2015-05-01'),
DATE('2015-05-01')
)
FOR FETCH ONLY.
acn
Hi,
Sorry - it's still not clear if you get the error in every circumstance or not. What happens if you bring in data from one table? What happens if you bring in data from one procedure? What happens if you bring in data from one view? Do they all work in isolation?
Ok - so you are using DB2. How is your connection defined? Are you using native client? ODBC? JDBC?
MF.
Hi,
Yes it works in isolation. If there is data only from SP or If it is data only from View it works. A mix of both gives the error.
Yes its DB2 with JDBC.
Thanks,
acn
Quote from: nac on 08 Jul 2015 09:27:52 AM
Hi,
Yes it works in isolation. If there is data only from SP or If it is data only from View it works. A mix of both gives the error.
Yes its DB2 with JDBC.
Thanks,
acn
How are the relationships defined between these objects in your Framework Manager model?
MF.