Skip to Content

SQL error 947 when accessing table "KNA1".

Hi Sapians,

We are getting below dump by update termination when we create a customer with XD01;

Category Installation Errors
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 02.05.2019 10:58:59
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short text |
| SQL error 947 when accessing table "KNA1". |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What happened? |
| Error Text of the Database: "ORA-00947: not enough values" |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What can you do? |
| 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. |
| |
| 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 "CUSTOMER_INSERT" "(FUNCTION)", 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: |
| Error Text of the Database: "ORA-00947: not enough values" |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|How to correct the error |
| Internal call code.........: "[RSQL/INSR/KNA1 ]" |
| 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" |
| "SAPLF02D" or "LF02DU02"

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 15, 2019 at 12:12 PM

    Hi Dattaram,

    I had a similar issue some time back which was resolved by disabling the parameter STAR_TRANSFORMATION_ENABLED on oracle. Better if you can do a full parameter check on the database. please follow SAP Note 1171650 - Automated Oracle DB parameter check.

    Regards,

    Prateek

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.