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

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