Skip to main content
Kofax

MarkView Installer – Installer fails while processing seed_fnd_document_datatypes.sql

Summary

13171

Applies To

  • ERP System: All
  • MarkView Version: 7.x and later

Behavior

  • The MarkView Installer fails while attempting to process the following file: seed_fnd_document_datatypes.sql
  • Installer-error log contains an error similar to:
    FATAL com.markview.common.db.SqlPlusEmulator Unplanned exception while processing file [/markview/install/modules/erp- 
    integration-oracle-dist-8.2.0/erp-integration-oracle-db/schema/seed_data/seed_fnd_document_datatypes.sql].
    java.sql.SQLException: ORA-01403: no data found
    ORA-06512: at line 29
  • Installer-error log contains an error similar to:
    ​​​​​​​FATAL com.markview.installer.ant.SeedDataUpdate Data Seed Task Failed: java.sql.SQLIntegrityConstraintViolationException: 
    ​​​​​​​ORA-01400:
    cannot insert NULL into ("MARKVIEW"."MVCN_OPERATION_PARAMETER"."ELEMENT_TYPE_ID"

Known Causes

The installer is being run in a shell which on which NLS_LANG is not set to ‘US’

Resolution

  • Set the NLS_LANG environment variable within the installer to US
  • Re-run the Installer

Keywords: Installer, fail, seed_fnd_document_datatypes.sql, ORA-01403: no data found,MVCN_OPERATION_PARAMETER, OPERATION PARAMETER