08-03-2010 5:53 AM
Dear All,
I am getting a following run time error ' ABAP runtime errors DBIF_RSQL_SQL_ERROR' when I am trying to insert a record.
Can any help me out to solve this issue.
Thanks,
Parvez
08-03-2010 9:23 AM
What is your Database, is it Oracle, if yes, check free space on tablespace (Transa(tion DB02 or via Oracle Administration)
You can also use transaction SM21 to get more information on the actual error message raised by database.
Regards,
Raymond
08-03-2010 6:04 AM
Please don't post Duplicate posts.
SEARCH for OSS notes related to SQL error 1653.
08-03-2010 7:14 AM
Dear Gautham,
I am not sure how to look the OSS notes, and how to resolve this issue. If anything you can helpme, I would really appreciated.
Thanks,
Fed
08-03-2010 7:41 AM
Hi,
This dump refers to the sequence of the fields in the ITAB or WA with table field sequence.
Please ensure that the sequence of the ITAB should be same as the strcture of the table
Regards
Shiva
08-03-2010 7:55 AM
Dear Shiva,
But I declared the itab
DATA : itab LIKE zcat3_mov OCCURS 0 WITH HEADER LINE,
itab1 LIKE zcat3_mov OCCURS 0 WITH HEADER LINE,
So no point of missing sequence, any other option.
Thanks,
Fed
08-03-2010 9:07 AM
08-03-2010 9:23 AM
What is your Database, is it Oracle, if yes, check free space on tablespace (Transa(tion DB02 or via Oracle Administration)
You can also use transaction SM21 to get more information on the actual error message raised by database.
Regards,
Raymond
08-03-2010 9:54 AM
Dear Rayond,
Thanks for your Answer, yes our database is ORACLE.
Thank,
Fed
08-03-2010 10:00 AM
Dear Raymond,
Everything is fine in Quality server, but when it comes to Production this error is happening at the INSERT statement?
Fed
08-03-2010 10:20 AM
- Check the tablespace free spaces in both systems, there should be more data in production system. ([Tablespace Analysis (Oracle)|http://help.sap.com/saphelp_bw30b/helpdata/en/c4/3a71c8505211d189550000e829fbbd/frameset.htm]) The definition of tablespaces can differ (in fact it should) between system.
- Check if your program can loop indefinitely (or at least a very large number of times)
Regards,
Raymond
08-03-2010 10:42 AM
08-03-2010 10:45 AM
Hi Yog,
pls find the code below.,
Process for Inovoice Update entry
PERFORM processupdate.
MOVE 'V1' TO itab-status.
MOVE 'Verfication 1' TO itab-procese.
MOVE zcat3_mov-usnam TO itab-usnam.
MOVE zcat3_mov-fieldgrp TO itab-fieldgrp.
MOVE sy-datum TO itab-appdate.
*Process for Dispute amount
IF NOT zcat3_mov-disputeamount IS INITIAL.
itab-disputeamount = zcat3_mov-disputeamount.
itab-amounttopay = lw_invmov-dmbtr - zcat3_mov-disputeamount.
ENDIF.
APPEND itab.
APPEND itab_temp.
INSERT INTO zcat3_mov VALUES itab.
UPDATE zcat3_mov FROM itab_temp.
Thanks,
Fed
08-03-2010 10:54 AM
Dear Yog,
I dont think it is wrong in the code, as today morning everything was running fine.
Any suggetions.
Thanks,
Fed
08-03-2010 11:04 AM
08-03-2010 11:14 AM
Hi Raymond,
I have asked the Basis to check the table space, he havent turned up. I will update you once he updates, thanks for your concern.
Thanks,
Fed
08-04-2010 8:27 AM
Hi Raymond,
Problem has been solved by extending the table space.
Thanks,
Fed