View previous topic :: View next topic
|
Author |
Message |
kitts
New User
Joined: 29 Jan 2006 Posts: 19
|
|
|
|
Hi,
I am facing a problem with a job which executes an Easytrieve program and it is trying to open a cursor which is failing with an error A046 and an internal SQL error 9048.
Can anyone help me with it. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi there,
Would u please paste the code as well as spool message |
|
Back to top |
|
|
kitts
New User
Joined: 29 Jan 2006 Posts: 19
|
|
|
|
Hi Ekta,
Below is the code:
320 SQL OPEN HAKOM
321 DO UNTIL SQLCODE NE 0
And here is the spool message.
for the job
320 *******A046 SQL - INTRNL ERR 9048
*******A014 PREMATURE TERMINATION DUE TO PREVIOUS ERROR(S)
Hope this helps you and in turn me! |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi there,
Have u define the cursor HAKOM befor opning this? |
|
Back to top |
|
|
kitts
New User
Joined: 29 Jan 2006 Posts: 19
|
|
|
|
I have defined it earlier.
It was working fine till today and suddenly there happened some problem and the DBA has confirmed that there is no problem with the tables on which the cursor was defined. |
|
Back to top |
|
|
gbkyadav
New User
Joined: 05 May 2005 Posts: 3
|
|
|
|
I am also having similar error. If anyone has a solution, pls share |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Sorry, Ekta has quit chasing the problem and kitts is no longer concerned....
I'll look into it in the (my) morning....
In the mean time, feel free to post any additional information you can provide. |
|
Back to top |
|
|
gbkyadav
New User
Joined: 05 May 2005 Posts: 3
|
|
|
|
William, Dir you get through this?
It is failing while opening a cursor. We dont have any sqlcode's returned other than the error. |
|
Back to top |
|
|
kitts
New User
Joined: 29 Jan 2006 Posts: 19
|
|
|
|
Sorry William, I wasnt concerned as I was able to later find out the problem with the code, it was due to overflow of the internal arrays defined.
For gbkyadav my only advice would be to check if the array size is reached if you are receiving similar error. |
|
Back to top |
|
|
petwir
New User
Joined: 09 Jul 2007 Posts: 1 Location: Salem Oregon
|
|
|
|
Had the same problem here on 02/19/2010, and ours was also caused by an overflow'd table. This thread helped me to diagnose it very quickly.
Thanks! Pete |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Glad to hear and nice to know that people are searching before posting now... |
|
Back to top |
|
|
|