RUN TIME ERROR DBIF_RSQL_SQL_ERROR

[former_member339060]

Hi There,

We are facing this issue in our ECC 6.0 EHP5 system. Kindly help me how to resolve this issue.

Category	Installation Errors
Runtime Errors	DBIF_RSQL_SQL_ERROR
Except.	CX_SY_OPEN_SQL_DB
Date and Time	27.02.2014 14:12:51

Short text

SQL error 904 when accessing table "BUT000".

What happened?

Error Text of the Database: "ORA-00904: "ZZ_TNC_DATE": invalid identifier"

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

Thanks,

Pavan.

[former_member182657 · Accepted solution]

Hi,

Please check  1034607 - SAP BP: Report to remove inconsistent entries in BUT000

  893900 - Report for inconsistencies b/w BUT000 & relationships

Thanks

[former_member339060]

Thanks lot for all your replies. Issue is sorted out after BUT000 export and import from another system.

Thanks and have a great day.

Pavan.

[Former Member]

Hi Pavan,

Kindly check this note

1179178 - Table is deactivated - Sources are not new

Hope this may help

BR Vaibhav

[former_member339060]

HI All,

BP transaction is giving below dump. Kindly help me.

Category	Internal Kernel Error
Runtime Errors	DDIC_TYPE_INCONSISTENCY

Application Component  BC-ABA-LA

Date and Time

04.03.2014 11:02:41

Short text

Inconsistency in the dictionary for the structure "BUS000___I".

What happened?

Error in the SAP kernel.

	The current ABAP "SAPLBUPA_DIALOG_JOEL" program had to be terminated because
	the
	ABAP processor detected an internal system error.

Error analysis

	There is an internal system error.
	eliminated with ABAP/4.

	There is an inconsisteny for the DDIC structure "BUS000___I", the corresponding
	Dictionary runtime object (NAMETAB) is incorrect.

	The number of components of the structure (NAMETAB component "fldcnt")
	is specified as 127. If all the substructures are resolved and the
	actual total number of components is calculated recursively, a different
	value is returned.

Trigger Location of Runtime Error

	Program	SAPLBUPA_DIALOG_JOEL
	Include	LBUPA_DIALOG_JOELTO1
	Row	351

Thanks,

Pavan.

[Former Member]

Hi Pavan,

Please check note 1167784  - Runtime error DDIC_TYPE_INCONSISTENCY   , for above error.

Regards,

Archana

[former_member339060]

Hi All,

The above table BUT000 inconsistency issue is resolved and its shown the same in SE14 as well. But there is another issue with another table..

Category	Internal Kernel Error
Runtime Errors	DDIC_TYPE_INCONSISTENCY

Application Component  BC-ABA-LA

Date and Time

03.03.2014 12:22:27

Short text

Inconsistency in the dictionary for the structure "BUS000___I".

What happened?

Error in the SAP kernel.

	The current ABAP "SAPLBUDA" program had to be terminated because the
	ABAP processor detected an internal system error.

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.

Error analysis

	There is an internal system error.
	eliminated with ABAP/4.

	There is an inconsisteny for the DDIC structure "BUS000___I", the correspond
	Dictionary runtime object (NAMETAB) is incorrect.

	The number of components of the structure (NAMETAB component "fldcnt")
	is specified as 127. If all the substructures are resolved and the As I understood there are lot of tables were inconsistency. Kindly let me know how to check the inconsistency tables list. Thanks, Pavan.

[Sriram2009]

Hi Pavan

Kindly refer the SAP Note

1653615 - D0322: "End phase & *" or dump: "DDIC_TYPE_INCONSISTENCY"

  1338583 - MVNTAB: Invalidation of the type loads

Regards

Sriram

[farkathulla_cikkanther]

Hello Pavan,

   Please refer the below note

534729 - Oracle errors due to network problems

Regards,

Farkath C

[former_member182657]

Hi Pavan,

Please share the result of these two reports Z_CORR_BUT000 from SAP Note 1034607 & ZBPREL_RELATIONS_CORRECT from SAP Note 893900 (The database requires cleaning up) which i recommended earlier.

Also follow   836353 - Correction Report for inconsistencies in BUT052/ADCP tables

Thanks

[former_member339060]

Hi Benjamin,

I have tried that method from SE14. still the same issue is occurring.

Thanks,

Pavan.

[Sriram2009]

Hi Pavan

Could you attach or paste the full dump?

Regards

Sriram

[Former Member]

Hello Pavan,

Check if this helps:

https://scn.sap.com/thread/1623961

Best Regards,

Anita

[former_member339060]

Hi Gaurav

As far as i understood is that table entrie which is missing not existing in database. If we ran the program which is mentioned . It wont be helpful as it is written as no database changes.

Am having on idea as import and export of table. I mean take a export of BUT000 table from another system and we can import in our system to remove the inconsistency.

Please share your views. Btw I required the entire data in the table..

Thanks,

Pavan.

[former_member187565]

Hi Pavan,

Yes , you can do that. That's the other way to resolve this issue. Before doing that take care of your current table by exporting it.

Regards,

Rafikul

[Reagan]

If I have understood you correctly there is an inconsistency with the ABAP and Database.

As far as i understood is that table entrie which is missing not existing in database. If we ran the program which is mentioned . It wont be helpful as it is written as no database changes.

What I have understood from your above reply is that the table is not present at the DB level. Am I correct ?

Have you tried to adjust the database table using the database utility ? - Tx SE14

There is an option called "Activate and adjust database"

Regards

RB

[former_member182657]

Hi Pavan,

Table BUT000 : BP: General data - Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

As said by Rafikul,you can perform this export import of table entries(strongly recommend to take backup of that table) before doing any procedure.

Thanks

[former_member339060]

Hi Rafi,

I have checked this note and applied the procedure as mentioned. below is the output and still the same issue.

Differences between DB and nametab for table BUT000 :

he following active nametab columns do not exist in the DB

Column     Type       Lngth

Z_TNC_DAT DATS 0010

he following generated nametab and associated DB

                   Database                 Nametab

Column     Type       Lngth KeyPos. Type       Lngth KeyPos

Thanks,

Pavan.

[Sriram2009]

Hi Pavan

Kindly check this SAP Note 633914 - Error when executing DBMS_STATS

Regards

Ram

[former_member339060]

Hi All,

Thank you very much for your replies. I found there is one database table inconsistency that is BUT000.

Database object for BUT000 is inconsistent: (Fields)

Fields: Inconsistent with the runtime object

ZZ_TNC_DATE ZZ_TNC_DATE does not exist 54 VARCHAR2 24 U '0000000'

Kindly help me how to bring this table as consistence.

Thanks,

Pavn.

[former_member187565]

Hi Pavan,

Have you checked the SAP note 1248769 - Inconsistency between database and ABAP Dictionary

Regards,

Rafikul

[former_member187565]

Hi Pavan,

Assume that this is not a fresh system and you have already applied the required SAP bundle patch with the help of oracle tool MOpatch as per note 1027012.

If the above is true please check the steps mentioned in SAP Note 1248769 - Inconsistency between database and ABAP Dictionary.

Regards,

Rafikul

[former_member182657]

Hi Pavan,

Will you please check this with the below utility.

SE11 -> <Tabname> -> Execute -> Utilities -> Runtime Object -> Check"

and activate the tables.

Regarding the issue you are getting I would also suggest you to

check SAP Notes:

731  Collective note: ORA-00904 and

648203     Database objects with INVALID status

Thanks,

Gaurav

[former_member188883]

Hi Pavan,

ORA-00904 string: invalid identifier

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #.

If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.

Can you activate the table in SE14 and check the results.

Hope this helps.

Regards,

Deepak Kori