DBIF_RSQL_SQL_ERROR

[Former Member]

Hi

I am trying to run a very standard process in QPF, but I get a fatal error. It returns DBIF_RSQL_SQL_ERROR

I am trying to run YMFP_DEMAND_HISTORY_1 program.

It can be found by looking at all job from 8/22 with FQ_730* in the job name – any one of the three attempts has the same error.

Any idea please tell me the reason behined this error and solution for this issue?

Thanks in advance

Regards

Srinivas.

[Former Member]

The dump will give you more information. What does it say?

Rob

[Former Member]

Hi ,

This is SQL error 1555 . please follwo this link which willexplain you why and in what circumsrances the error arises .

<a href="http://www.fors.com/orasupp/rdbms/dba/40689_1.HTM">SQL error 1555</a>

Regards,

varun .

[Former Member]

Hi Srinivas,

This error is caused when ORACLE needs additional storage space in a rollback segment.

If you are updating the database using the program and if you don't commit the work often, everything is stored for rollback and it will throw this error or If your program is running simultaneously with other programs , then also the storage space might get exceeded.

Hope this helps.

Regards,

Vivek

PS: Award points if helpful

[Former Member]

Thanks for your valuable information. In ST22 there was large no.of DBIF_RSQL_SQL_ERROR errors with different descriptions like

SQL Error " " occurred when accessing table ""

SQL Error 3114 occurred when accessing table "SNAP_BEG"

SQL Error 603 occurred when accessing table YMIFC_DHREFRESH

Regards

Srinivas

[Former Member]

Are these all for your program?

Rob

[Former Member]

No Rob for my program I am getting

SQL Error " " occurred when accessing table "" in ST22.

I checked other DBIF_RSQL_SQL_ERROR errors in ST22.There was large no.of DBIF_RSQL_SQL_ERROR errors.

[Former Member]

Well, look further down in the dump for your program. It should give some more information.

Rob

[Former Member]

Hi Srinivas,

As Rob said, search in the dump for "What happened" , "Error analysis" and "Information on where terminated". This should tell you why and where the dump is occuring. Or atleast paste that error analysis so that some one can tell you why it is happening.

Regards,

Vivek