Skip to Content
0
Sep 08, 2016 at 01:42 PM

UDT is defined but does not exist

810 Views


I am planing to upgrade SAP Business One from 9.1 to 9.2 but I am getting an error in the preupgrade test for one of the databases.

Test result: Not completed due to SBOErr -2004 in function CDagCheckUTBRecordInconsistence::DoCheck(), error text: Open user defined table @BCENOTE failed. # #

I ran the scripts in 1076082 - UDT & UDF related issues

All the scripts returned no result except

1) UDT is defined but does not exist

***
select TableName from OUTB
where not exists (
select 1 from sysobjects where xtype='U' and [name]='@'+TableName
)
***

returned

TableName
BCENOTE

I am sure that there is no query performed directly on the database except SELECT queries and the User-Defined Tables were removed from the User-Defined Tables Setup form.

I detected the problem as mentioned but what is the solution?