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
Article # 304219 - Page views: 116

20417
20417
304219

Question / Problem: 

  • When attempting to export batches from Kofax Capture to MarkView, batches 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 a batch.
  • NOTE: You may need to bounce the Capture and MV Application Server. 

 

Applies to:  

Product Version Category
MarkView for Oracle 6.5+ Troubleshooting

 

enhanced_bar_code_Internal-Icon.png

Author:  Aidan Sullivan

8/6/2019 : Copied from CRM

Keywords: MVImportAPI, MVImportException