Skip to main content
Kofax

Markview Export Connector - ORA-20361: Structural errors appear in the MV Import database objects. Run MV_IMPORT_OBJ.VerifyObjects for details.

20417
20417
304219

Question / Problem: 

  • When attempting to export items into Markview from Kofax Capture, items are going into the Quality Control queue
  • The following error is seen in the Document Notes

Export Error: Script #1 (MarkView Beta) [0 MVImportAPI.MVImportException: ORA-20361: Structural errors appear in the MV Import database objects. Run MV_IMPORT_OBJ.VerifyObjects for details.
 ORA-06512: at "MARKVIEW.MV_IMPORT", line 1046
 ORA-06512: at line 4 ---> Oracle.DataAccess.Client.OracleException: ORA-20361: Structural errors appear in the MV Import database objects. Run MV_IMPORT_OBJ.VerifyObjects for details.
 ORA-06512: at "MARKVIEW.MV_IMPORT", line 1046
 ORA-06512: at line 4

  • This error may be seen after a database upgrade

Answer / Solution: 

  • Run the attached script VerifyObjects.sql and see if there is an error
  • If an error is reported, please try to run the VerifyAndFixObjects.sql which is also attached to this article. In order to run this script you will need to know the names of the Markview Data tablespace and the MarkView Index tablespace. The following query can show you your table space names. You will want to run this query in the MarkView schema:
    • select * from user_tablespaces;
  • Run the script and enter the data and index table space when prompted. Once the script finishes, you should run VerifyObjects.sql again to confirm that all errors have been fixed. If they have not been fixed please log a support case and attach the spooled output, which is contained in VerifyObjects.txt and is located in the same directory that you ran the script from.
  • If there are no longer any errors, restart the Capture Export Service, and attempt to export an item

 

Applies to:  

Product Version Category
MarkView 6.5+ Troubleshooting

 

Author:  Aidan Sullivan

8/6/2019 : Copied from CRM

Keywords: MVImportAPI, MVImportException