topic Re: DBIF_RSQL_SQL_ERROR in Application Development and Automation Discussions

DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 15:43:53 GMT

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.

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 15:48:48 GMT

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

Rob

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 15:50:38 GMT

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 .

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 15:55:25 GMT

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

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 16:13:51 GMT

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

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 16:25:01 GMT

Are these all for your program?

Rob

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 16:55:02 GMT

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.

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 17:00:04 GMT

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

Rob

Re: DBIF_RSQL_SQL_ERROR

Former Member — Wed, 23 Aug 2006 17:18:07 GMT

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