Assignment problem with lookup table

54 Views

Hi All,

I have a problem when executing "Assignment" operation for the data in lookup table.

The assignment itself is a very simple operation - UPPER(fieldname). I can manually mofidy the field to uppercase successfully.

There is no data in related main table.

The assigned field is a very normal field - not a keyword, not a DF, not a UF.

"Database Command execution error" comes when do assignment and I get detail error information from MDM log:

OLEDB error on PVGN50048584A/Businesspartner_m000 from statement: DELETE FROM A2i_49_CO_AddMembs WHERE CheckOut_Id=?

ErrorRecord->HResult/NativeErr: 0x80040e37/0

Description: Invalid object name 'A2i_49_CO_AddMembs'.

Source/File/Line: Microsoft OLE DB Provider for SQL Server/.\OLEDB_DBConnection.cpp/3331

can anyone help me to explain this problem?

Thanks in advance,

Bin