Getting this error in the BTP Variant Configurator

[DieterLorenz]

Hello community,

we getting this error in the variant configurator replication status.

Failed to resume CDC replication error while trying to invoke the method com.sap.hana.dp:oraclelogreaderadapter.triggerbased.systeminformation.getmetadataversion of a null object loaded from local variable systeminformation

We have this landscape: ERP EHP 6 running Oracle 19 <=> SDI / DPAdapter <=> BTP Variant Configurator

The DP Adapter is not so old - same version as at the QAS Adapter but this runs well:

#Data Provisioning component versions

dpagent.version=2.7.0.1

lcmsdk.version=2.7.40

repagent.syb.version=15.7.1SP210

repagent.sybfilter.version=15.7.1SP214

ms.vcredist.2015.version=14.34.31938.0

ocs.version=16.0.03.10

dataservices.engine.version=14.3.2.419

dpagent.build.version=2.7.0.1

build.time=2023-05-23T13:37:44-0700

In the log of the dpagent we have this error messages:

2024-01-12 09:47:37,772 [ERROR] [14f0bb36-2138-42b7-925f-7ab3c89b4b6110645] ErpTriggerBasedAdapter | StatefulAdapterCDC$CDCOpened.start [] - [RS_COMPANY_PROD] Failed to resume CDC replication. SubscriptionSpecification [header=remoteTableId=2109, remoteTriggerId=199924, subscription="SAPSR3"."COMM_CFGVTABLE", customId=, seqID=0x020000000000000000000000000003478d000000000016a1f300000000000000, isLastSubscription=false, withSchemaChanges=1, firstSubscriptionOnTable=true, lastSubscriptionOnTable=true]Subscription SQL=SELECT "T1"."MANDT", "T1"."KBID", "T1"."OBJID", "T1"."ACTIVE", "T1"."COUNTER", "T1"."EXT_NAME", "T1"."DB_NAME", "T1"."TYPE", "T1"."AC", "T1"."ECM", "T1"."TRANSPORT" FROM "COMM_CFGVTABLE" "T1" java.lang.NullPointerException: while trying to invoke the method com.sap.hana.dp.oraclelogreaderadapter.triggerbased.SystemInformation.getMetadataVersion() of a null object loaded from local variable 'systemInformation' at com.sap.hana.dp.oraclelogreaderadapter.triggerbased.OracleTriggerBasedManager.cdcUpgrade(OracleTriggerBasedManager.java:413) at com.sap.hana.dp.cdcadaptercommons.BaseAdapterCDC.start(BaseAdapterCDC.java:340) at com.sap.hana.dp.oracleeccadapter.triggerbased.ErpTriggerBasedAdapter.resumeSubscription(ErpTriggerBasedAdapter.java:94) at com.sap.hana.dp.cdcadaptercommons.StatefulAdapterCDC$CDCOpened.start(StatefulAdapterCDC.java:908) at com.sap.hana.dp.cdcadaptercommons.StatefulAdapterCDC.start(StatefulAdapterCDC.java:382) at com.sap.hana.dp.cdcadaptercommons.logreader.AdapterCDCMDCDelegate.start(AdapterCDCMDCDelegate.java:156) at com.sap.hana.dp.cdcadaptercommons.logreader.SeparateClassloaderAdapterCDC.start(SeparateClassloaderAdapterCDC.java:108) at com.sap.hana.dp.adapter.sdk.logical.ErpLogicalRowAdapter.start(ErpLogicalRowAdapter.java:856)

...2024-01-12 09:47:37,773 [ERROR] [14f0bb36-2138-42b7-925f-7ab3c89b4b6110645] ErpTriggerBasedAdapter | ExceptionUtil.newAdapterException [] - Failed to resume CDC replication. Error: while trying to invoke the method com.sap.hana.dp.oraclelogreaderadapter.triggerbased.SystemInformation.getMetadataVersion() of a null object loaded from local variable 'systemInformation' java.lang.NullPointerException: while trying to invoke the method com.sap.hana.dp.oraclelogreaderadapter.triggerbased.SystemInformation.getMetadataVersion() of a null object loaded from local variable 'systemInformation' at com.sap.hana.dp.oraclelogreaderadapter.triggerbased.OracleTriggerBasedManager.cdcUpgrade(OracleTriggerBasedManager.java:413) at com.sap.hana.dp.cdcadaptercommons.BaseAdapterCDC.start(BaseAdapterCDC.java:340) at com.sap.hana.dp.oracleeccadapter.triggerbased.ErpTriggerBasedAdapter.resumeSubscription(ErpTriggerBasedAdapter.java:94) at com.sap.hana.dp.cdcadaptercommons.StatefulAdapterCDC$CDCOpened.start(StatefulAdapterCDC.java:908) at com.sap.hana.dp.cdcadaptercommons.StatefulAdapterCDC.start(StatefulAdapterCDC.java:382)

at com.sap.hana.dp.cdcadaptercommons.logreader.AdapterCDCMDCDelegate.start(AdapterCDCMDCDelegate.java:156) at com.sap.hana.dp.cdcadaptercommons.logreader.SeparateClassloaderAdapterCDC.start(SeparateClassloaderAdapterCDC.java:108) at com.sap.hana.dp.adapter.sdk.logical.ErpLogicalRowAdapter.start(ErpLogicalRowAdapter.java:856) at com.sap.hana.dp.adapter.framework.core.AdapterCDCAlreadySentFilterDelegate.start(AdapterCDCAlreadySentFilterDelegate.java:35) at com.sap.hana.dp.adapter.framework.core.WorkerThread.processCDCStart(WorkerThread.java:1237)

at com.sap.hana.dp.adapte...

2024-01-12 09:47:37,773 [ERROR] [14f0bb36-2138-42b7-925f-7ab3c89b4b6110645] DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: Failed to resume CDC replication. Error: while trying to invoke the method com.sap.hana.dp.oraclelogreaderadapter.triggerbased.SystemInformation.getMetadataVersion() of a null object loaded from local variable 'systemInformation' Context: java.lang.NullPointerException: while trying to invoke the method com.sap.hana.dp.oraclelogreaderadapter.triggerbased.SystemInformation.getMetadataVersion() of a null object loaded from local variable 'systemInformation' at com.sap.hana.dp.oraclelogreaderadapter.triggerbased.OracleTriggerBasedManager.cdcUpgrade(OracleTriggerBasedManager.java:413) at com.sap.hana.dp.cdcadaptercommons.BaseAdapterCDC.start(BaseAdapterCDC.java:340) at com.sap.hana.dp.oracleeccadapter.triggerbased.ErpTriggerBasedAdapter.resumeSubscription(ErpTriggerBasedAdapter.java:94) at com.sap.hana.dp.cdcadaptercommons.StatefulAdapterCDC$CDCOpened.start(StatefulAdapterCDC.java:908) at com.sap.hana.dp.cdcadaptercommons.StatefulAdapterCDC.start(StatefulAdapterCDC.java:382) at com.sap.hana.dp.cdcadaptercommons.logreader.AdapterCDCMDCDelegate.start(AdapterCDCMDCDelegate.java:156) at com.sap.hana.dp.cdcadaptercommons.logreader.SeparateClassloaderAdapterCDC.start(SeparateClassloaderAdapterCDC.java:108) at com.sap.hana.dp.adapter.sdk.logical.ErpLogicalRowAdapter.start(ErpLogicalRowAdapter.java:856) at com.sap.hana.dp.adapter.framework.core.AdapterCDCAlreadySentFilterDelegate.start(AdapterCDCAlreadySentFilterDelegate.java:35) at com.sap.hana.dp.adapter.framework.core.WorkerThread.processCDCStart(WorkerThread.java:1237)

=> We have the same triggers ( three of them) in the QAS System and this works fine !Please help !thanks a lot

[DieterLorenz · Accepted solution]

We have solved the problem after disconntecting the dpagent from the BTP and make a connect again (credentials are saved). It takes 2-3 h to sync all tables.

You should also disconnect before a system copy and connect after a system copy.

[yogananda]

dieterlorenz

can you also edit your question and assign it to SAP Variant Configuration & Pricing tag to get maximum attention.

Step 1 and Step 2 - you can take help from below blog

https://blogs.sap.com/2022/05/22/sap-cpq-sap-variant-configuration-pricing-setup/

Also you can take a look at this blog for quick help to setup
https://blogs.sap.com/2024/01/12/sap-variant-configuration-and-pricing-overview-and-key-resources-fo...