Dictionary Export Returns Page not Found and ORA-1858 in TMS Form

(Doc ID 278446.1)

Last updated on AUGUST 17, 2017

Applies to:

Oracle Thesaurus Management System - Version: and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 20-Nov-2008***

***Checked for relevance on 26-Mar-2010***


When executing the Dictionary Export report the following error is returned:

Not Found
The requested URL /pls/clindb/TMS_USER_XMLREPORTS.DICTEXPORT was not found
on this server.

TMS forms window shows the following error:

"in exception ORA-1858: a non-numeric character was found where a numeric was expected."

Navigation: TMS > Repository > Dictionary Export.

URL:  http://hostname/pls/clindb/TMS_USER_XMLREPORTS.DICTEXPORT?rRptType=XML.......

Apache error_log file shows the following error :

[Wed Jun 23 15:47:15 2004] [warn] mod_plsql: Stale Connection due to Oracle
error 20000
[Wed Jun 23 15:47:15 2004] [error] mod_plsql:
ORA-20000: 245700-Record is locked by another session.
ORA-06512: at "OPA.OPA_USER_MSG", line 227
ORA-06512: at "OPA.OPA_USER_MSG", line 303
ORA-06512: at "OPA.OPA_RXC_BATCH_JOBS_M", line 162
ORA-06512: at "OPA.OPA_USER_JOB", line 196
ORA-06512: at "TMS.TMS_USER_XMLREPORTS", line 233
ORA-06512: at "TMS.TMS_USER_XMLREPORTS", line 941
ORA-06512: at line 7


Problem generated after After apply ipatch TMS (<>)


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms