SAP HANA database synchronization to customer checkout

[pralin_01]

Hi,

I have been facing issues in synchronizing customer data from the HANA database to SAP customer checkout.

Regarding our local environment hardware and server configuration please find the following details:

• Window server 2012 R2 where SAP customer checkout is installed.
• RAM -16 GB
• SAP Customer checkout Release--- 2.0 FP 11 PL06
• JAVA Runtime Environment:11.0.13+10-LTS-370
• Integration Framework---1.22.34
• SAP customer checkout package version-4.0.41
• Action executed successfully in web point SAP customer checkout.
• B1DI connection is successful in the integration framework for the Demo database.
• JDBC connection is successful in Integration Framework is successfully for Demo database.

But still, the issue is not able to reflect the customer information in SAP customer checkout.

Please help to rectify this issue.

BR,

Pralin Khanal

[pralin_01]

Also all these connection steps are successful but still not able to reflect SAP HANA database data to SCC.

1. SLD -> Select the Business One database which is integrated with CCO -> hit the Test Connection button for B1DI and JDBC -> they must return a success message
2. SLD -> CustomerCheckoutDb -> hit the Test Connection button for JDBC -> it must return a success message
3. MAINTENANCE -> User Administration -> hit the Runtime Users button -> find the user that you used for integration with CCO (often in OnPrem installations this is the B1iadmin user) -> it must be Active = true
4. SCENARIOS -> Control -> sap.CustomerCheckout -> must be ticked = Active in the first column
5. TOOLS -> Control Center -> Monitoring -> TID Panel -> Execution Status = INCOMMIT or INROLLBACK -> Submit -> if there are any transactions you have to delete them

waiting for valuable input on this.

BR,

Pralin

[anderson_schmitt]

Hi Pralin,

Is the System ID correct?

In the log files, the error below happens when you trigger the Article synchronization

WARN com.sap.scco.ap.pos.i14y.util.AbstractDTOService - an exception came up while retrieving all MaterialDTO from ERP (BusinessOne)

com.sap.scco.util.exception.XState: com.sap.scco.util.exception.XState: SAP DBTech JDBC: [259] (at 137): invalid table name: Could not find table/view OUOM in schema SYSTEM: line 1 col 138 (at pos 137)

If you configuration is correct, I suggest you to open an incident for the SAP Support for a deeper analyze.

Regards,
Anderson