Four Stars

[resolved] Cursor Error

Hi,
I am getting the below when tried to run a job. 
connecting to socket on port 3634
connected
disconnected
Exception in component tAS400Input_1
java.sql.SQLException: Cursor CRSR0001 not open.
    at java.lang.Throwable.<init>(Throwable.java:196)
    at java.lang.Exception.<init>(Exception.java:41)
    at java.sql.SQLException.<init>(SQLException.java:52)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
    at com.ibm.as400.access.JDServerRowCache.fetch(JDServerRowCache.java:357)
    at com.ibm.as400.access.JDServerRowCache.fetch(JDServerRowCache.java:268)
    at com.ibm.as400.access.JDServerRowCache.next(JDServerRowCache.java:778)
    at com.ibm.as400.access.AS400JDBCResultSet.next(AS400JDBCResultSet.java:1793)
    at prod.job_stg_to_f_yln_0_2.job_STG_TO_F_YLN.tAS400Input_1Process(job_STG_TO_F_YLN.java:3298)
    at prod.job_stg_to_f_yln_0_2.job_stg_to_f_yln.runJobInTOS(job_STG_TO_F_YLN.java:7909)
    at prod.job_stg_to_f_yln_0_2.job_stg_to_f_yln.main(job_STG_TO_F_YLN.java:7756)
Job job_STG_TO_F_YLN ended at 11:34 16/12/2014.
Any thoughts on what is causing the error and how this can be fixed?
Thanks in advance.
1 REPLY
Moderator

Re: [resolved] Cursor Error

Hi,
Could you please take a look at article about:http://stackoverflow.com/questions/10312659/selecting-from-db2-gives-sql0501-cursor-crsr0001-not-ope....
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.