When running the MarkView Installer I receive a no data found error message when the seed_fnd_document_datatypes.sql script is being executed.
- ERP System: Oracle, SAP
- MarkView Version: 7.0 and above
- 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
- 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.
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.