DevOps and System Administration Discussions
Dive into SAP DevOps and system administration. Join discussions to collaborate on optimizing workflows, share knowledge, and leverage resources effectively.
cancel
Showing results for 
Search instead for 
Did you mean: 

dbsql_table_unknown

former_member624966
Participant
0 Kudos

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

1 ACCEPTED SOLUTION

Reagan
Advisor
Advisor
0 Kudos

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.

View solution in original post

10 REPLIES 10

sriramsbg
Active Contributor
0 Kudos

Hi Ezeh.

Could you share the full dumps

Regards

SS

former_member624966
Participant
0 Kudos

Hello Sriram

Attached is the dump

dumps.jpg

0 Kudos

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

0 Kudos

Hi Ezeh.

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

Regards

SS

former_member624966
Participant
0 Kudos

Hello Reagan Benjamin

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

export-error.jpg

Regards

Kanayo

sriramsbg
Active Contributor

Hi Ezeh.

Check this SAP note it may help you.

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

Regards

SS

Reagan
Advisor
Advisor
0 Kudos

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.

0 Kudos

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

0 Kudos

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.

RB

0 Kudos

Hello reagan.benjamin

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

Regards

Kanayochukwu