topic Re: Open SQL Error in Application Development and Automation Discussions

Open SQL Error

Former Member — Fri, 05 Sep 2008 06:23:46 GMT

Hi,

Please help me out for the below issue.

Problem:

Cause: A database error occurred.

Runtime error: DBIF_RSQL_SQL_ERROR

Scenario:

Two servers NSA and NDA.

The same piece of code is executing fine in NSA but in NDA

it throws up the above problem

Investigation result:

No database table or field mismatch found.

No datatype mismatch found

So cause is so far unknown

Solution:

Not found, please help me out

Re: Open SQL Error

RaymondGiuseppi — Fri, 05 Sep 2008 06:29:25 GMT

Look at your Dumps (ST22) or Syslog (SM21), you should read an error like "SQL error -913 occurred when accessing table TSP02 ." which give the SQL error code (here 913 in the sample) and the database table/view impacted (here TSP02).

Which SQL error code (numeric 3) did you get?
Which table is accessed

Regards

Re: Open SQL Error

Former Member — Fri, 05 Sep 2008 06:34:02 GMT

Hello

Check table, address to which causes mistake.

Possible, in NSA it was modified and changes was not transported into NDA.

In any event this table must be absolutely alike for both servers.

Re: Open SQL Error

Former Member — Fri, 05 Sep 2008 06:44:55 GMT

Thanks for your prompt reply Raymond.

Yes, the system log displays the following error

"Database error 12899 at INS access to table ZBAICAL_ORD_HEAD"

and it point out the field also "PRINT_FLAG".

but the above field is 100% identical in both the servers.

I have thoroughly investigated this part.

Fieldname,Datatype and length matches perfectly.

But system log comments on the length as "(actual : 6 maximum : 3 )" which is not true in both the servers.

still lost in the problem:(

Re: Open SQL Error

Former Member — Fri, 05 Sep 2008 06:49:56 GMT

Hi Dzed,

I have invertigated thoroughly all that, everything is fine but still getting the dump in NDA server.

Re: Open SQL Error

Former Member — Fri, 05 Sep 2008 07:03:27 GMT

Hello

There is else several thoughts on this cause:

1. table must be activated

2. all data elements (fields) must be similar also.

Re: Open SQL Error

former_member282823 — Fri, 05 Sep 2008 07:13:06 GMT

Hi,

This error we will get when there is no connection between the two servers. so check properly if the connections are working fine...

Regards,

Ramesh.

Re: Open SQL Error

RaymondGiuseppi — Fri, 05 Sep 2008 07:25:00 GMT

The ORA-12899 error occurs when the database field is shorter that the data used in the SQL statement. (look at [ Note 591600 - Error due to inappropriate column values|https://service.sap.com/sap/support/notes/591600])

When you say the field has the correct length, i suppose you refer to the length in the Abap Dictionnary ?

Maybe there is a gap between dictionnary and physical database. try to adjust the table via transaction [SE14|https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=se14&adv=false&sortby=cm_rnd_rankvalue] or call transaction [DB02|https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=db02&adv=false&sortby=cm_rnd_rankvalue] to check dictionnary vs database.

Regards