Skip to main content
Kofax

MarkView Installer - no data found when executing the seed_fnd_document_datatypes.sql script.

  1. Last updated
  2. Save as PDF

Summary

4928

When running the MarkView Installer I receive a no data found error message when the seed_fnd_document_datatypes.sql script is being executed.

Applies To

  • ERP System: Oracle, SAP
  • MarkView Version: 7.0 and above

Behavior

  • When running the MarkView Installer the Installer may fail when processing the seed_fnd_document_datatypes.sql script. An error similar to the following will be report 
    2011-02-22 16:31:05,977 ERROR com.markview.common.db.SqlPlusEmulator Unexpected error while executing sql script. java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_DOC_CATEGORIES_PKG", line 345
ORA-06512: at line 68
ORA-06510: PL/SQL: unhandled user-defined exception

Known Causes

  • This issue can occur as a result of a mis-match between the locale settings on the machine where the Installer is being executed, and the locale settings of the MarkView Database.

Resolution

In order to resolve this issue please ensure the locale setting of the following environment variables is the same between the machine where the Installer is running and the MarkView database.

For example if the database is set to en_US locale then the following environment variables should also be set to en_US on the machine where the Installer is being executed.

  • LC_MONETARY
  • LC_NUMERIC
  • LC_MESSAGES
  • LC_COLLATE
  • LC_CTYPE
  • LC_TIME
  • NLS_LANG
  • LANG

Keywords: locale