SQL error 947 when accessing table "KNA1".

[former_member410257]

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"

[former_member612175]

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