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=?
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,