Command line Emcli Discover_ggma fails to discover targets from agent. (Doc ID 2850424.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Problem Summary
---------------------------------------------------
OEM Goldengate plugin 13.4.2 : emcli discover_ggma issues

Problem Description
---------------------------------------------------
Unable to discover targets from agent.
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
  at oracle.sysman.emdrep.target.EntityUtil.handleAddNYMException(EntityUtil.java:2672)
  at oracle.sysman.emdrep.target.EntityUtil.createNYMEntities(EntityUtil.java:2502)
  at oracle.sysman.emdrep.target.EntityUtil.createNYMEntities(EntityUtil.java:2387)
  at oracle.sysman.emdrep.target.EntityUtil.createEntities(EntityUtil.java:3712)
  at oracle.sysman.emdrep.target.EntityUtil.createEntities(EntityUtil.java:3682)
  at oracle.sysman.emSDK.core.target.EntityManager.createEntities(EntityManager.java:320)
  at com.oracle.sysman.goldengate.emcli.GoldenGateTargetsVerb.saveTargetViaEntityManager(GoldenGateTargetsVerb.java:479)
  at com.oracle.sysman.goldengate.emcli.GoldenGateTargetsVerb.addTargets(GoldenGateTargetsVerb.java:302)
  at com.oracle.sysman.goldengate.emcli.GoldenGateTargetsVerb.execute(GoldenGateTargetsVerb.java:135)
  at com.oracle.sysman.goldengate.emcli.GoldenGateMicroservicesTargetsVerb.execute(GoldenGateMicroservicesTargetsVerb.java:99)
  at oracle.sysman.emSDK.emCLI.CLIPageHandler.executeCommand(CLIPageHandler.java:2157)
  at oracle.sysman.emSDK.emCLI.CLIPageHandler.access$2000(CLIPageHandler.java:170)
  at oracle.sysman.emSDK.emCLI.CLIPageHandler$CLIExecutor.executeRequest(CLIPageHandler.java:1466)
  at oracle.sysman.emSDK.emCLI.CLIPageHandler$CLIExecutor.doWork(CLIPageHandler.java:1443)
  at oracle.sysman.core.common.workmanager.Work.call(Work.java:274)
  at oracle.sysman.core.common.workmanager.Work.call(Work.java:50)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)
GoldenGate disco

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.