Error While Running B1.SYNC_CONTEXT Job
(Doc ID 3050971.1)
Last updated on OCTOBER 14, 2024
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.8.0.1.0 and laterInformation in this document applies to any platform.
Goal
On: 2.8.0.1.0 version, Install / Upgrade
Q1)Error While running B1.SYNC_CONTEXT job
We are experiencing the below error while executing the B1_SYNC_TABLE. It's a new installation.
ODI-1226: Step B1_SYNC_TABLE fails after 1 attempt(s).
ODI-1232: Procedure B1_SYNC_TABLE execution fails.
ODI-1228: Task Procedure-B1_SYNC_TABLE-Load data into replica (HIST, OVD, KEY) fails on the target connection B1.
Caused By: java.sql.SQLException: ORA-28110: policy function or package MDM1IMP.X1_INSTALLED_PRODUCT_POLICY has error
ORA-06512: at line 10
------------------------
Q2)
1- We cannot run B1_SYNC_CONTEXT for the whole product now as B1_SYNC_TABLE has failed for few tables only.
2- Please suggest steps to run initial load for individual affected tables only
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! |
In this Document
| Goal |
| Solution |
| References |