Skip to main content
Kofax

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

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