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

UDT is defined but does not exist


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



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?