SQL error 1653 occurred when accessing table

[Former Member]

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

[GauthamV]

Please don't post Duplicate posts.

SEARCH for OSS notes related to SQL error 1653.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Any Idea Shiva?

[RaymondGiuseppi]

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

[Former Member]

Dear Rayond,

Thanks for your Answer, yes our database is ORACLE.

Thank,

Fed

[Former Member]

Dear Raymond,

Everything is fine in Quality server, but when it comes to Production this error is happening at the INSERT statement?

Fed

[RaymondGiuseppi]

- 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

[Former Member]

code u please past your code which inserts the table?

[Former Member]

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

[Former Member]

Dear Yog,

I dont think it is wrong in the code, as today morning everything was running fine.

Any suggetions.

Thanks,

Fed

[RaymondGiuseppi]

Did you or your BC/ORA team check the tablespace ?

[Former Member]

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

[Former Member]

Hi Raymond,

Problem has been solved by extending the table space.

Thanks,

Fed