Unable to open planogram from the database in Space Planning

For Error 1:

1. To fix the issue for existing planograms:
   1. Check column DBUSER in table IX_SPC_PLANOGRAM
   2. If DBUSER column has a NULL or blank value, update it to a valid database user
   3. Sample UPDATE statement
      1. UPDATE ix_spc_planogram
         SET dbuser = <valid database user>
         WHERE dbkey = <dbkey of problematic planogram>
   4. Commit the change if needed
2. To prevent the issue from happening:
   1. Ensure trigger ix_trui_spc_planogram is enabled 

For Error 2:

• Validate the data associated with planograms giving error, for example:
  • Date format
  • Data as per data type 

Error 1:
An error occurred while loading this project/planogram from the database.
Function : LoadDBObjects()
Error Number : 80020005
Error Message: Type mismatch

or

Error 2:
Code = 80040e4b 
Code meaning = IDispatch error #3147 
Source = OraOLEDB 
Description = The system cannot find message text for message number 0x80040e4b in the message file for OraOLEDB.

• A NULL/blank value in DBUSER column in table IX_SPC_PLANOGRAM
• Trigger ix_trui_spc_planogram may be disabled

• The same error might be occurring even DBUSER is not NULL or blank
• Other columns that may not be updated correctly are: DBTIME, LIVEDATE, DATEEFFECTIVE, FINISHEDDATE, DATEFINISHED, PENDINGDATE, STATUS1