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: 4.5.0.2 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***

Symptoms

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:
/pls/tms1/TMS_USER_XMLREPORTS.DICTEXPORT ORA-20000
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

Changes

Problem generated after After apply ipatch TMS 4.5.0.2 (<<Patch 3610117>>)

Cause

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