topic Re: SQL error 1653 occurred when accessing table in Application Development and Automation Discussions

SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 04:53:55 GMT

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

Re: SQL error 1653 occurred when accessing table

GauthamV — Tue, 03 Aug 2010 05:04:21 GMT

Please don't post Duplicate posts.

SEARCH for OSS notes related to SQL error 1653.

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 06:14:39 GMT

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

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 06:41:25 GMT

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

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 06:55:33 GMT

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

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 08:07:54 GMT

Any Idea Shiva?

Re: SQL error 1653 occurred when accessing table

RaymondGiuseppi — Tue, 03 Aug 2010 08:23:51 GMT

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

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 08:54:53 GMT

Dear Rayond,

Thanks for your Answer, yes our database is ORACLE.

Thank,

Fed

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 09:00:17 GMT

Dear Raymond,

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

Fed

Re: SQL error 1653 occurred when accessing table

RaymondGiuseppi — Tue, 03 Aug 2010 09:20:15 GMT

- 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

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 09:42:22 GMT

code u please past your code which inserts the table?

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 09:45:07 GMT

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

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 09:54:58 GMT

Dear Yog,

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

Any suggetions.

Thanks,

Fed

Re: SQL error 1653 occurred when accessing table

RaymondGiuseppi — Tue, 03 Aug 2010 10:04:12 GMT

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

Re: SQL error 1653 occurred when accessing table

Former Member — Tue, 03 Aug 2010 10:14:47 GMT

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

Re: SQL error 1653 occurred when accessing table

Former Member — Wed, 04 Aug 2010 07:27:54 GMT

Hi Raymond,

Problem has been solved by extending the table space.

Thanks,

Fed