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]

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