Veridata_Import.sh With Update With Existing Group Fails With java.lang.NullPointerException (Doc ID 2535513.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

While updating an existing group with veridata import fails with the following errors:

[oracle] ]$
$DOMAIN_HOME/veridata/bin/veridata_import.sh -wluser veridata -update
exported.xml
2019-04-13 10:42:25.364 NOTIFICATION Oracle GoldenGate Veridata Scripting -
Version 12.2.1.2.180615 OGGVDT_MAIN_PLATFORMS_180601.0601
[OGGV-50007: Enter WebLogic user password :]
2019-04-13 10:42:50.808 ERROR java.lang.NullPointerException

Here is the sample exported.xml:

[oracle]$ cat exported.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE configuration SYSTEM "configuration.dtd">
<configuration operation="update" validation="required">
<connection name="DBNAME" host="xxxx-testxxxx.xa.xxxxxx.com"
port="7864" user="TEST\TEST" password="xxxxxx{ds"
truncate-spaces="true" use-ssl="true" use-source-target-keys="true"
use-all-columns="true"/>
<connection name="TESTFIN" host="uoggxxx4v.xxxxxxx.co.xa" port="7850"
user="ggs" password="xxxxx#1" truncate-spaces="true" use-ssl="true"
use-source-target-keys="true" use-all-columns="true"/>
<group name="BUG1004" source-conn="TESTFIN" target-conn="DBNAME">
  <compare-pair name="TABLE_NAME"
source-table="TABLE_NAME" target-table="TABLE_NAME"
source-schema="TEST1" target-schema="TESTFIN"
target-catalog="targetcatalogname" use-source-keys="true"
use-target-keys="true" use-all-columns="true">
    <sql-partition name="TEST_ID" default="true" side="source">
      <![CDATA[FORACID='XXXXX8004014' OR FORACID='XXXXXXXXX8004014' OR
FORACID='XXXXXXXXX8021008' OR FORACID='XXXXXXXX5119016' AND BXXX_ID='LS']]>
    </sql-partition>
    <sql-partition name="BXXX_ID" default="true" side="target">
      <![CDATA[FORACID='XXXXX8004014' OR FORACID='XXXXXXXXX8004014' OR
FORACID='XXXXXXXXX8021008' OR FORACID='XXXXXXXXX5119016' AND TEST_ID='LS']]>
    </sql-partition>
    <column source-name="AXXX_NAME" target-name="AXXX_NAME" format="blob"
type="hash"/>
    <column source-name="LCXX_TIME" target-name="LCXX_TIME"
format="timestamp" type="hash"/>
  </compare-pair>
</group>
<job name="BUG1004">
  <group name="BUG1004"/>
</job>
</configuration>

Changes

Cause

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