Skip to Content
0
Nov 07, 2014 at 04:04 AM

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

331 Views

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