ERROR:Database error text. "ORA-01438: value larger than specified precis

[Former Member]

Hi Experts

could you please tell me the why this error is coming when i run the program RFBIBL00 program

ERROR :Database error text........: "ORA-01438: value larger than specified precision.

is their any data base problem.

Thanks.

[Former Member]

Hi Experts

could you please tell me the why this error is coming when i run the program RFBIBL00 program

ERROR :Database error text........: "ORA-01438: value larger than specified precision.

is their any data base problem.

Thanks.

[GauthamV]

Check the data that you are passing in the file for the program RFBIBL00.

This error may come in scenarios where you are giving wrong data.

[former_member188827]

check your file

[Former Member]

i checked the data but it seems fine , we have tried running the same job in TST environment with the same file(data) and there the job went through fine.

Kindly, help us analyse and resolve this runtime error that we are getting.

Here is the complete dump analysis:

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Date and Time 13.05.2009 02:40:01

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "UPD_ADD_GLT3" "(FORM)", nor was it propagated by a RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

The problem has arisen because, within the database interface,

one of the data buffers made available for the INSERT (UPDATE)

is longer than the maximum defined in the database.

On the other hand, it may be that the length in the NAMETAB

does not match the maximum length defined in the database.

(In this case, the length in the NAMETAB is longer.)

Database error text........: "ORA-01438: value larger than specified precision

allowed for this column"

Internal call code.........: "[RSQL/UPDT/GLT3 ]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"SAPLGLIU" or "LGLIUF0A"

"UPD_ADD_GLT3"

If you cannot solve the problem yourself and want to send an error

notification to SAP, include the following information:

1. The description of the current problem (short dump)

To save the description, choose "System->List->Save->Local File

(Unconverted)".

2. Corresponding system log

Display the system log by calling transaction SM21.

Restrict the time interval to 10 minutes before and five minutes

after the short dump. Then choose "System->List->Save->Local File

(Unconverted)".

3. If the problem occurs in a problem of your own or a modified SAP

program: The source code of the program

In the editor, choose "Utilities->More

Utilities->Upload/Download->Download".

Thanks.

[Former Member]

Hi

The dump occurs when the system try to update the table GLT3 (for consolidation) so I can suppose there is a very large amount.

Max

[Former Member]

Thanks Max

but i didn't get any code like GLT3 or collect statement in program RFBIBL00.

unable to understand the logic. please help me.

Thanks

[Former Member]

Hi

The problem is not in RFBIBL00, but in include LGLIUF0A and I suppose that include is called as soon as the document is post, in that moment that table should be updated too.

Try to check your file, perhaps there's a line (type record BBSEG) with a too big amount.

Max

[christine_evans]

Have you made any custom modifications to RFBIBL00? Are your test and development systems at the same support pack level? Have you searched for SAP notes that describe your problem?

[Former Member]

Hi

The routine (like UPD_ADD_GLT3) defined in include LGLIUF0A are generated dynamically, perhaps that action has to be done again:

u need to run the program RGZZGLUX, but it should be better you read the note 377053.

Max

[Former Member]

Hi Max,

We had already the file being used as the dump also suggested amount length problem.

But, in the file none of the amounts exceeds 12 characters (i.e. 10 integer places and 2 decimal places).

Now, if anywhere the amounts are getting added up then only it could be amount overflow.

We are very sure the file does not have any problem amount. We have checked the entries in GLT3 table, for a few parameters like company code, profit centre, year and the accounting number, there were amounts in transaction currency already, now if there is any logic for addind up of these amounts, there could be a problem. But, we are not aware of such a logic in the program and use of the table GLT3.

Kindly throw some light on it and help us.

Thanks

[Former Member]

Hi

The table GLT3 is a table for consolidation data for FI-SL (Special Ledger), this table has to be updated everytime FI document is posted.

U can't and don't must to avoid to update it.

Just as I said try to check the note 377053, perhaps some modifcations in FI-SL customizing were done and the routines in include LGLIUF0A weren't correctly generated.

I think you should obtein that dump if you try to post the document online, using FI transaction like FB01 instead of BDC program: have you tried to do it?

Max