‎2008 Apr 22 12:47 PM
Hi All.
Iam fetching values from table J_1IEXCDTL,but it occured dump.i pasted dump anlaysis also with here.pls guide me how to fixe this issue.
already i used BREAK-POINT as per dump anlysis,but its not working properlly.
*******
An exception occurred. This exception is dealt with in more detail below
. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was
neither
caught nor passed along using a RAISING clause, in the procedure
"FORM_TITLE_PRINT" "(FORM)"
.
Since the caller of the procedure could not have expected this exception
to occur, the running program was terminated.
The reason for the exception is:
One of the database selections included a database commit.
The selection was then supposed to continue. Before a
database commit, however, all outstanding database selections must be
concluded.
.
Possible causes in the application program:
Within a loop (SELECT/LOOP/EXEC SQL), one of the following
statements is used:
- MESSAGE (apart from MESSAGE S...)
- COMMIT WORK
- ROLLBACK WORK
- CALL SCREEN
- CALL DIALOG
- CALL TRANSACTION
- SUBMIT
- BREAK-POINT
- WAIT
*****
<REMOVED BY MODERATOR>
Regards.
Jay
Edited by: Alvaro Tejada Galindo on Apr 22, 2008 4:40 PM
‎2008 Apr 22 12:53 PM
Hi
The thing is that, u can not use these
MESSAGE (apart from MESSAGE S...)
COMMIT WORK
ROLLBACK WORK
CALL SCREEN
CALL DIALOG
CALL TRANSACTION
SUBMIT
BREAK-POINT
WAIT
in a loop
loop at or do while..
check the code, and let me know if issue
<REMOVED BY MODERATOR>
Edited by: Alvaro Tejada Galindo on Apr 22, 2008 4:41 PM
‎2008 Apr 22 12:57 PM
Hi,
May be select statement was used with in a loop where the huge amount was stored in the internal table,
Regards,
Kumar.
‎2008 Apr 22 1:00 PM
hi Jay.,
if you have used any of the following commands with in a loop/Select stmt,
then please remove them to avoid dump.
MESSAGE (apart from MESSAGE S...)
COMMIT WORK
ROLLBACK WORK
CALL SCREEN
CALL DIALOG
CALL TRANSACTION
SUBMIT
BREAK-POINT
WAIT
<REMOVED BY MODERATOR>
Chandra
Edited by: Alvaro Tejada Galindo on Apr 22, 2008 4:41 PM
‎2008 Apr 22 1:00 PM
Hi Jay,
remove BREAK-POINT in the SELECT statement.
<REMOVED BY MODERATOR>
raam
Edited by: Alvaro Tejada Galindo on Apr 22, 2008 4:42 PM
‎2008 Apr 22 1:02 PM
hi.............
just compare field in type declaration and in select queiry............
<REMOVED BY MODERATOR>
have nice day......
Edited by: Alvaro Tejada Galindo on Apr 22, 2008 4:44 PM
‎2008 Sep 18 7:57 AM