MarkView Installer - no data found when executing the seed_fnd_document_datatypes.sql script.
4928
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