MarkView Installer – Installer fails while processing seed_fnd_document_datatypes.sql

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