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

[pralin_01]

Hi Anderson,

Please find the attached log files and screenshots.

In a regard to the SAP customer checkout Manager, we haven't integrated with SCC.

If you need any further details, Please let me know.

BR,

Pralin khanacco-errortxt.txtcco-standardtxt.txt

[anderson_schmitt]

Hello Pralin,

Is there any information in the CCO log files?

Regards,
Anderson

[pralin_01]

Hi Anderson,

The lastest CCO log file has following error:

ThreadPoolTaskExecutor-10] ERROR com.sap.scco.ap.pos.async.worker.PosWorkerCallable - Error while executing worker for entry with uuid d5fe0446-1f49-498c-a8cb-1e007dec0601

java.lang.NullPointerException: null

at com.sap.scco.ap.pos.i14y.central.retrofit.AuthInterceptor.authenticate(AuthInterceptor.java:88) ~[env.jar:?]

at com.sap.scco.ap.pos.i14y.central.retrofit.AuthInterceptor.intercept(AuthInterceptor.java:45) ~[env.jar:?]

at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142) ~[env.jar:?]

at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117) ~[env.jar:?]

at okhttp3.RealCall.getResponseWithInterceptorChain(RealCall.java:229) ~[env.jar:?]

at okhttp3.RealCall.execute(RealCall.java:81) ~[env.jar:?]

at retrofit2.OkHttpCall.execute(OkHttpCall.java:190) ~[env.jar:?]

at com.sap.scco.ap.pos.communication.impl.LicenseCommunicatorImpl.checkLicense(LicenseCommunicatorImpl.java:33) ~[env.jar:?]

at com.sap.scco.ap.pos.service.impl.LicensePosServiceImpl.performLicenseCheck_aroundBody0(LicensePosServiceImpl.java:85) ~[env.jar:?]

at com.sap.scco.ap.pos.service.impl.LicensePosServiceImpl.performLicenseCheck_aroundBody1$advice(LicensePosServiceImpl.java:33) ~[env.jar:?]

at com.sap.scco.ap.pos.service.impl.LicensePosServiceImpl.performLicenseCheck(LicensePosServiceImpl.java:1) ~[env.jar:?]

at com.sap.scco.ap.pos.service.workers.license.LicenseCheckPosWorker.execute(LicenseCheckPosWorker.java:24) ~[env.jar:?]

at com.sap.scco.ap.pos.service.workers.license.LicenseCheckPosWorker.execute(LicenseCheckPosWorker.java:1) ~[env.jar:?]

at com.sap.scco.ap.pos.async.worker.PosWorkerCallable.call(PosWorkerCallable.java:80) [env.jar:?]

at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]

at java.lang.Thread.run(Thread.java:834) [?:?]

2021-12-21 23:57:28,110 [http-nio-127.0.0.1-9999-exec-5] ERROR com.sap.scco.ap.services.CCOErrorValve - Uncaught throwable was thrown: Invalid character found in method name [0xf00x010x000x00T0xe90xf30xfbC0xd5A0x93m0xca.0xd10xb20x14(R0xcb0xc40x0a0xbb0xacA=f-0xdf0xa50x0dk0xae0xea60xd0[D0x0d0xd10xd50x080xdf0x81#0x1b0xdd0xb4Q0xb30x8f0xb4Q0xb30xbdZu0x070xeaZu0x070xfc0xb80xa90xfdm0xcb0x89\0x99`~0x080x94k0x9a0xf9s0xc60xbes"0xc60xbes0x9f0xc60x0crd0xcen0xcd0xc90xcen0xcd0xbdh0xfc0xc70xa30xb50xc8o0xb4.0x04i0xda@0x8c0xa60xa2`0x04_0xbeZu`_0x860xdc0xf40xf20xcen0xbcs0xa20xd10xd4Y&0x150x150xda==0x100xd00xb2/0xfa^0xcc,k0x8a(s]8k0xaf0xdauZ0x840xeeE0xc30x0e0x0020xb000xb70xe60xc00xe6v@;0x940x1a0xc20xca0xf5s0xf60x170x1b#0xdae0x8d0x8c0x0eT0x070xa70x890xb50xc80xc70x0c0x170xe6B0x8aP0xe6Nt0xc60xbes0x81r(_0x110xcd0xa90xab50xc60xbeV0x0d0x880xf30x980xf00x8a0xe60x9cH_0x0f0xa10x9d0x8e0x0b-0xdcS0xe5,0x1e0xcen0xbc0x1e`~&0xa760x960xd30xfb0xa30x12p0x8a0xa20xd10xd40x8b0xc90x070xaa*0xcf0xcf)c0xc30xa40x820x880xc6i0x8c0xae0xad0xe80xca&B0xf20x8f0xa00xce0xfd^0xba0xb9z0xc80x910xc30xc9k90xc90xbb0xcc0x02_C0xa1:"0xd60xde20x9a0xd20xe10x150xbeh0x0d{1j0xbe0xfb0xb1i$0xb52uiZ0xd40x030xd10x1dZu0x100xcc%0xfb0xfa0x0a0x8a0xe60x9b0xf90x880x000xfd0xef%OQ0x1c0x860xdcBDgw10x7f0x1f0xa30xb3;0xa20xd10xd4b1j^0x9f0xc30xa40x820x8e&0x150x150xf60xbaA0xfa0xa80xbaA0xfa0xbf0x0c0x920x0b0xa20xd9o0x09R0xd80xf50xd8V0xac0xf70x000xf20xad0xe80xca0x8d%0xc6+0x070xc3M_0xb7VE0x120x1f0xd80xads0xb80xd80xads0xd20xb50xee0xea=zu0x860xf20xacA=m-0xdf0xa40xc4Y&0xfdh1j0xbe0x9bZu0x081Zu0x080x1eE0xc4{<0xd20xd30x140x9aW0xbe0xff0x9e0xd80xdf0x900xda\0xb40x910xf00xbc0xa6Y&0x860xdc0xd00x8f0x180x9f0x80#0xc60xbes...]. HTTP method names must be tokens

java.lang.IllegalArgumentException: Invalid character found in method name [0xf00x010x000x00T0xe90xf30xfbC0xd5A0x93m0xca.0xd10xb20x14(R0xcb0xc40x0a0xbb0xacA=f-0xdf0xa50x0dk0xae0xea60xd0[D0x0d0xd10xd50x080xdf0x81#0x1b0xdd0xb4Q0xb30x8f0xb4Q0xb30xbdZu0x070xeaZu0x070xfc0xb80xa90xfdm0xcb0x89\0x99`~0x080x94k0x9a0xf9s0xc60xbes"0xc60xbes0x9f0xc60x0crd0xcen0xcd0xc90xcen0xcd0xbdh0xfc0xc70xa30xb50xc8o0xb4.0x04i0xda@0x8c0xa60xa2`0x04_0xbeZu`_0x860xdc0xf40xf20xcen0xbcs0xa20xd10xd4Y&0x150x150xda==0x100xd00xb2/0xfa^0xcc,k0x8a(s]8k0xaf0xdauZ0x840xeeE0xc30x0e0x0020xb000xb70xe60xc00xe6v@;0x940x1a0xc20xca0xf5s0xf60x170x1b#0xdae0x8d0x8c0x0eT0x070xa70x890xb50xc80xc70x0c0x170xe6B0x8aP0xe6Nt0xc60xbes0x81r(_0x110xcd0xa90xab50xc60xbeV0x0d0x880xf30x980xf00x8a0xe60x9cH_0x0f0xa10x9d0x8e0x0b-0xdcS0xe5,0x1e0xcen0xbc0x1e`~&0xa760x960xd30xfb0xa30x12p0x8a0xa20xd10xd40x8b0xc90x070xaa*0xcf0xcf)c0xc30xa40x820x880xc6i0x8c0xae0xad0xe80xca&B0xf20x8f0xa00xce0xfd^0xba0xb9z0xc80x910xc30xc9k90xc90xbb0xcc0x02_C0xa1:"0xd60xde20x9a0xd20xe10x150xbeh0x0d{1j0xbe0xfb0xb1i$0xb52uiZ0xd40x030xd10x1dZu0x100xcc%0xfb0xfa0x0a0x8a0xe60x9b0xf90x880x000xfd0xef%OQ0x1c0x860xdcBDgw10x7f0x1f0xa30xb3;0xa20xd10xd4b1j^0x9f0xc30xa40x820x8e&0x150x150xf60xbaA0xfa0xa80xbaA0xfa0xbf0x0c0x920x0b0xa20xd9o0x09R0xd80xf50xd8V0xac0xf70x000xf20xad0xe80xca0x8d%0xc6+0x070xc3M_0xb7VE0x120x1f0xd80xads0xb80xd80xads0xd20xb50xee0xea=zu0x860xf20xacA=m-0xdf0xa40xc4Y&0xfdh1j0xbe0x9bZu0x081Zu0x080x1eE0xc4{<0xd20xd30x140x9aW0xbe0xff0x9e0xd80xdf0x900xda\0xb40x910xf00xbc0xa6Y&0x860xdc0xd00x8f0x180x9f0x80#0xc60xbes...]. HTTP method names must be tokens

at org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:417) ~[env.jar:?]

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:261) [env.jar:?]

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [env.jar:?]

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) [env.jar:?]

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) [env.jar:?]

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [env.jar:?]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [env.jar:?]

at java.lang.Thread.run(Thread.java:834) [?:?]

Best Regards,

Pralin

[anderson_schmitt]

Hello Pralin,

Try to run again the article synchronization and attach the complete log files, please
also provide some screenshot of the settings under Configuration > Integration > SAP Business One and Configuration > Integration > SAP Customer Checkout manager

Regards,
Anderson