My Oracle Support Banner

"Maintain Multi-Lingual Tables" process fails when executing JTFNLINS.sql: ORA-1652: unable to extend temp segment by 16 in tablespace APPS_TS_TX_DATA (Doc ID 3022149.1)

Last updated on MAY 10, 2024

Applies to:

Oracle Common Applications - Version 12.2 and later
Information in this document applies to any platform.


When trying to run Adadmin process "Maintain Multi-lingual Tables", the worker running the JTFNLINS.sql script fails with the following errors:

From adadmin.log file:

FAILED: file JTFNLINS.sql on worker x for product jtf username JTF.

ATTENTION: All workers either have failed or are waiting:

FAILED: file JTFNLINS.sql on worker x.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.


From adworkxxx.log file:

sqlplus -s APPS/***** @/xxxx/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/xxxx/appl/jtf/12.0.0/sql/JTFNLINS.sql '

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

SQLERRM=ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

select to_date('ERROR')
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected


From database alert log file

ORA-1652: unable to extend temp segment by 16 in tablespace APPS_TS_TX_DATA


Steps to reproduce:

1. Run Adadmin utility

2. Choose option: Maintain Multi-lingual Tables


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.