Data Integration

Data Integration

Connect with experts and peers to elevate technical expertise, solve problems and share insights.

 View Only

Unable to create subscriptions

  • 1.  Unable to create subscriptions

    Posted an hour ago

    access server and instances are running

    [cdc@m3cdc1-0 bin]$ ./dmaccessserver &

    [3] 113169

    [cdc@m3cdc1-0 bin]$ ps -fx

        PID TTY      STAT   TIME COMMAND

     112734 pts/1    S      0:00 -bash

     113026 pts/1    SLl    0:11  \_ /opt/cdc/ReplicationEngineforOracle/jre64/jre/bin/dmts64-java -cp lib/bootstrap-11.4.0.5-5788.jar:lib/icu4j-charset-76.1.jar:lib/icu4j-localespi-76.1.jar:li

     113070 pts/1    SLl    0:10  \_ /opt/cdc/ReplicationEngineforOracle/jre64/jre/bin/dmts64-java -cp lib/bootstrap-11.4.0.5-5788.jar:lib/icu4j-charset-76.1.jar:lib/icu4j-localespi-76.1.jar:li

     113169 pts/1    SLl    0:00  \_ /opt/cdc/accessServer/jre64/jre/bin/dmaccessserver-java -Duser.folder=/opt/cdc/accessServer -server -Xmx512m -jar lib/server.jar 9009

     113200 pts/1    R+     0:00  \_ ps -fx

    [cdc@m3cdc1-0 bin]$ 

    Repl > add subscription sourceid "DEVICE_U" name "DEVICE_USER_SUBSCRIPTION";

    [CDC1301]: Subscription DEVICE_USER_SUBSCRIPTION from datastore stvpn2 to stedw was added.

    Repl > add table mapping targetSchema "SCHEMA0" targetTable "DEVICE_USER_DETAILS" sourceTable "DEVICE" sourceSchema "SCHEMA0";

    Verifying source table exists...

    Verifying target table exists...

    Adding DEVICE to the datastore...

    [ERR2001]: An error has occurred.  Possible recovery steps: Please try again.  

    If the error persists, if possible restart the IBM InfoSphere Data Replication 

    instance and try again.   Internal error information: Agent Message 

    'Message2005' Exception Text 'Cannot read field "uv" because "this.connection" 

    is null'.



    ------------------------------
    Anuragh Ravindran
    ------------------------------