Home » RDBMS Server » Server Utilities » ORA-39014: One or more workers have prematurely exited. ORA-31671: Worker process DW00 had an unhand (Oracle 12c)
ORA-39014: One or more workers have prematurely exited. ORA-31671: Worker process DW00 had an unhand [message #671370] Sat, 25 August 2018 08:17 Go to next message
sran
Messages: 1
Registered: August 2018
Junior Member
Hi All,

I getting below error while importing DMP file.

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-00600: internal error code, arguments: [kdtdelrow-2], [12], [12], [], [], [], [], [], [], [], [], []
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "ARGUS_APP.F_ULRZTRIM", line 23
ORA-06512: at "SYS.DBMS_SQL", line 1707
ORA-06512: at "SYS.KUPD$DATA", line 2495
ORA-06512: at "SYS.KUPD$DATA", line 3513
ORA-06512: at "SYS.KUPD$DATA", line 3764
ORA-06512: at "SYS.KUPW$WORKER", line 19307
ORA-06512: at "SYS.KUPW$WORKER", line 4989
ORA-06512: at "SYS.KUPW$WORKER", line 12077
ORA-06512: at "SYS.KUPW$WORKER", line 2081
ORA-06512: at line 2
ORA-39014:

Regards,
Rajasekhar

Re: ORA-39014: One or more workers have prematurely exited. ORA-31671: Worker process DW00 had an unhand [message #671371 is a reply to message #671370] Sat, 25 August 2018 09:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

At a minimum we need Oracle version to 4 decimal places & complete command line that produced the error.

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Re: ORA-39014: One or more workers have prematurely exited. ORA-31671: Worker process DW00 had an unhand [message #671372 is a reply to message #671370] Sat, 25 August 2018 09:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.
And MOS notes:
ORA-600/ORA-7445/ORA-700 Error Look-up Tool (Doc ID 153788.1)
Master Note for Diagnosing ORA-600 (Doc ID 1092832.1)

Re: ORA-39014: One or more workers have prematurely exited. ORA-31671: Worker process DW00 had an unhand [message #671373 is a reply to message #671370] Sat, 25 August 2018 09:48 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "ARGUS_APP.F_ULRZTRIM", line 23

What is at line 23 of procedure?

Previous Topic: SQL Loader Error
Next Topic: expdp slow, delays in QUEUE_INT.SEND
Goto Forum:
  


Current Time: Thu Mar 28 05:07:17 CDT 2024