Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

12c Data Pump Import Fails With ORA-39126: Worker Unexpected Fatal Error In KUPW$WORKER

User_8KB49Aug 7 2019 — edited Aug 13 2019

Has anyone come across this error during an import. I found a bug with exports but not sure if its related to imports as well.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=226287901367280&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&…

Here is the error I got in specifics:

. . imported
"SYSADM"."PTGRANTTBL"
0 KB 0 rows

. . imported
"SYSADM"."SQL_PROF_STGTAB"
0 KB 0 rows

ORA-39126: Worker unexpected fatal error in
KUPW$WORKER.CHANGE_ARCHIVE_LOGGING
[TABLE_DATA:"SYSADM"."PS_UC_R289_RPT_STG"]

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 11252

----- PL/SQL Call Stack -----

object line
object

handle number name

0x2d40df628 27109 package body
SYS.KUPW$WORKER

0x2d40df628 11279 package body
SYS.KUPW$WORKER

0x2d40df628 7338 package
body SYS.KUPW$WORKER

0x2d40df628 5377 package
body SYS.KUPW$WORKER

0x2d40df628 12169 package body
SYS.KUPW$WORKER

0x2d40df628 2081 package
body SYS.KUPW$WORKER

0x2e5778e90
2 anonymous block

In SET_DDL_TRANSFORM with index 3 and object type TABLE

DBMS_METADATA.SET_TRANSFORM_PARAM

ORA-39126: Worker unexpected fatal error in
KUPW$WORKER.CHANGE_ARCHIVE_LOGGING
[TABLE_DATA:"SYSADM"."PS_XX_ACA_AET"]

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 11252

----- PL/SQL Call Stack -----

object line
object

handle number name

0x2d40df628 27109 package body
SYS.KUPW$WORKER

0x2d40df628 11279 package body
SYS.KUPW$WORKER

0x2d40df628 7338 package
body SYS.KUPW$WORKER

0x2d40df628 5377 package
body SYS.KUPW$WORKER

0x2d40df628 12169 package body
SYS.KUPW$WORKER

0x2d40df628 2081 package
body SYS.KUPW$WORKER

0x2e5778e90
2 anonymous block

In SET_DDL_TRANSFORM with index 3 and object type TABLE

DBMS_METADATA.SET_TRANSFORM_PARAM

Job "SYS"."SYS_IMPORT_SCHEMA_02" stopped
due to fatal error at Mon Aug 5 12:53:31 2019 elapsed 0 02:18:23

syntax used :

nohup impdp \"/ as sysdba\" schemas=xxxx parallel=8 directory=export
dumpfile=xxx.dmp
logfile=xxx.log table_exists_action=skip transform=disable_archive_logging:y
exclude=statistics &

Cvele_new_account

try to set Disabled property for that fourth SOC, to be false _only if first three SOC attributes are set to non-null values...

OR, make 4.th SOC ;disabled property to be false only if 3.-th SOC value are set, then the same for 3. SOC (depends on 2. SOC), then the same for 2. SOC, etc... got a point?

Jose Aróstegui

Excellent idea!

Can you help me please a bit to build the expression?

I don't know how to reference the fields as they are inside a Query Panel based on a View Critera.

Ashish Awasthi

This 4th Lov is dependent on all 3 lovs?

If you are using view cirteria then uncheck "Ignore Null Values" Check box in criteria to not show any data in case of no value is selected in other 3 lovs

Ashish

Jose Aróstegui

Thanks a lot for your help Ashish.

This 4th Lov is dependent on all 3 lovs?

2nd Lov depends on 1st

3rd Lov depends on 2nd

4th Lov depends on 3rd

If you are using view cirteria then uncheck "Ignore Null Values" Check box in ...

Ignore null values is not editable:

I've tried your solution Igonre null values in viewCriteria -Jdeveloper 12c (Not a bug but a change) – Ashish Awasthi's Blog (Jdev/ADF) but It didn't activate the checkbox either.

Regards,

Jose.

Ashish Awasthi

Answer

Hi Jose

It'll not activate checkbox , you just need to add GenerateIsNullClauseForBindVars="false" under viecriteriItem tag like this and then check

<ViewCriteriaItem

    Name="DepartmentId"

    ViewAttribute="DepartmentId"

    Operator="="

    Conjunction="AND"

    Value=":BindDeptId"

    IsBindVarValue="true"

    Required="Optional"

    **GenerateIsNullClauseForBindVars="false"**/>

After this 4th lov will not show any data untill 3rd one is selected

Ashish

Marked as Answer by Jose Aróstegui · Sep 27 2020

Jose Aróstegui

It works fine. I was confused and was setting the value to true:

Thanks a lot!

1 person found this helpful

Ashish Awasthi

Jose that post was not about this problem , It was about chnaging it's value only

Anyway you solved it

1 - 7

Added on Aug 7 2019

#database-key-features, #export-import-sql-loader-external-tables

6 comments

3,452 views

Database Software

12c Data Pump Import Fails With ORA-39126: Worker Unexpected Fatal Error In KUPW$WORKER

Comments

Post Details