INVALID PARAMETER NAME: P_DEVICE_CONFIG_ID
(Doc ID 2752493.1)
Last updated on JUNE 03, 2024
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
On : 2.7.0.1.3 version, System Wide
The following error is faced when customer executes the Configure Source process for MDM:
2020-08-10T08:54:20.983+0300 ERROR OGG-00350 Oracle GoldenGate Delivery
for Oracle, MDM1AA.prm: Error in SQLEXEC clause, id
MDM1REP.B1_MDM1AA_HISTORIZE.D1_DVC_CFG: Invalid parameter name:
P_DEVICE_CONFIG_ID.
This issue is faced for D1_DVC_CFG table after applying OUA 2.7.0.1.3 patchset
This is an impact issue resulting out of the fix provided for custom replication
of table CI_SA_REL of CCB.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. After applying the patchset OUA 2.7.0.1.3, run the Configure Source process
2. Notice that the replicat abends with the mentioned error message
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |