Need to resolve Data source adapter error

[nimishabrahamc]

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

[MFGF]

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.

[nimishabrahamc]

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

[MFGF]

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.

[nimishabrahamc]

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

[MFGF]

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.

[nimishabrahamc]

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

[MFGF]

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.