SAP B1 - Inventory Audit Report - Table not found (ODBC -2004) [Message 131-183]

[Private_Member_370152]

Hi,

I am using SAP B1 8.82 PL 7.

I have tried to run the Inventory Audit Report for a certain warehouse but get the error Table not found (ODBC -2004)  [Message 131-183].

I tried to follow http://scn.sap.com/thread/381080, and ran the select count(*) from information_schema.tables for my current database and another one from Aug backup. I found that the current database has 1 more table than the Aug backup.

This 'extra table' is actually a view called SNB_51c90a25a4054d2d849fe69ac6aa.

I tried to delete this table but I still hit the error.

So I don't have any missing tables, yet I am getting this error.

Anyone encountered this error before?

Thanks.

Ivan

Hi , andT

[kothandaraman_nagarajan]

Hi,

Please upgrade to next PL to fix this issue. Refer SAP note:

1717804 - Error message "Table not found (ODBC -2004) [Message
131-183]" appears when running Invent...

Thanks & Regards,

Nagarajan