My Oracle Support Banner

STG_SI_PRODUCT_JOB Failure (E.g., ORA-01400: cannot insert NULL) (Doc ID 2956079.1)

Last updated on NOVEMBER 15, 2024

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 23.1 and later
Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Goal

STG_SI_PRODUCT_JOB fails and log shows:

Invocation 1, Job has failed, due to ORA-20000: ORA-01400: cannot insert NULL into (\"RADM01\".\"W_PRODUCT_DTS\".\"ITEM\")\nORA-06512: at \"C##CLOUD$SERVICE.DBMS_CLOUD\", line 1561\nORA-06512: at \"C##CLOUD$SERVICE.DBMS_CLOUD\", line 7895\nORA-06512: at \"C##CLOUD$SERVICE.DBMS_CLOUD\", line 7918\nORA-06512: at line 1\n\n\tat oracle.retail.apps.poam.agent.engine.executor.AbstractJobExecutor.throwRuntimeException(AbstractJobExecutor.java:385)\n\tat oracle.retail.apps.poam.agent.engine.executor.AbstractAsyncReSTJobExecutor.doWork(AbstractAsyncReSTJobExecutor.java:83)\n\tat oracle.retail.apps.poam.agent.engine.executor.AbstractJobExecutor.call(AbstractJobExecutor.java:141)\n\tat oracle.retail.apps.poam.agent.engine.executor.AbstractJobExecutor.call(AbstractJobExecutor.java:37)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe","notification":null}

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.