topic Re: dbsql_table_unknown in DevOps and System Administration Forum

dbsql_table_unknown

former_member624966 — Sat, 18 Jan 2020 01:31:06 GMT

Dear Expert,

I install an IDES 1610 S/4HANA, My colleagues the FICO consultant want to add new entries in Chart of Account and it is throwing this error. "dbsql_table_unknown" Please i need help on how to fix this error message.

Regards

Kanayo

Re: dbsql_table_unknown

S_Sriram — Sat, 18 Jan 2020 04:28:40 GMT

Hi Ezeh.

Could you share the full dumps

Regards

Re: dbsql_table_unknown

former_member624966 — Sat, 18 Jan 2020 14:11:20 GMT

Hello Sriram

Attached is the dump

dumps.jpg

Re: dbsql_table_unknown

Reagan — Sat, 18 Jan 2020 17:22:21 GMT

Supply the full dump. You can export the full dump as a text file and attach it here.

Re: dbsql_table_unknown

S_Sriram — Sat, 18 Jan 2020 17:55:26 GMT

Hi Ezeh.

Is this any correction in the database? check the dbacockpt any error in the database level?

Regards

Re: dbsql_table_unknown

former_member624966 — Sun, 19 Jan 2020 14:13:59 GMT

Hello Reagan Benjamin

See the attach is the error am getting trying to export dump file

export-error.jpg

Regards

Kanayo

Re: dbsql_table_unknown

S_Sriram — Mon, 20 Jan 2020 04:52:45 GMT

Hi Ezeh.

Check this SAP note it may help you.

https://launchpad.support.sap.com/#/notes/2565383

Regards

Re: dbsql_table_unknown

Reagan — Mon, 20 Jan 2020 10:42:43 GMT

Based on the dump you've supplied it appears to be view is missing.

Follow note 2421686 - CDS view(DDL SQL View) cannot be activated with RUTDDLSACT and use the report RUTDDLSACT to create the missing views.

Re: dbsql_table_unknown

former_member624966 — Sun, 26 Jan 2020 14:44:06 GMT

Hello Reagan,

Thanks for all your support but my challenge is that i try to use the report RUTDDLSACT which i generated using SE38 but to do mass upload is the challenge i have. the issue is still not resolved. Thanks

Reagrds

Kanayochukwu

Re: dbsql_table_unknown

Reagan — Sun, 26 Jan 2020 21:02:18 GMT

Kanayo,

First run the report with couple of views and again check DB02 - Missing Indexes and Tables. You need to click the refresh option to let the system perform a new check. Once the check has been completed, check if the ones you've activated using the report has gone or not. If the list is big then you should consider the mass processing option after you select the "Create on DB" icon under the Action field. Unfortunately you need to do it for all the entries. The note 2418979 has all the details.

This time, there is nothing much I can advice you here. If the creation of views fail then raise an OSS message with SAP and open the remote connection to the system.

Good luck and take care.

Re: dbsql_table_unknown

former_member624966 — Mon, 03 Feb 2020 08:17:25 GMT

Hello reagan.benjamin

Thanks i was able to do mass upload and all the missing view where created successfully issues resolved. Thanks

Regards

Kanayochukwu