Can't synchronize receipts

[Former Member]

Hey there,

i wanted to connect CCO to a fresh database in SBO. I created the database, did the basic configuration etc, changed the system ID in CCO to the new database entry in the SLD, and every synchronization works fine - with the exception of sales receipts (invoices). I receive the following warnings (in the CCO background console, see below), the warning list in the synchronization module just shows "javax.xml.ws.soap.SOAPFaultException: Server Error".

I already checked the B1i scenarios, everything seems fine. The B1i connection test inside CCO is also fine, no errors

The CCO Monitor is also broken, the receipt list shows some old receipts, but all the receipt details are empty.

ID: 22 Response-Code: 500 Encoding: ISO-8859-1 Content-Type: text/xml Headers: {connection=[close], Content-Length=[7533], content-type=[text/xml], Date=[Thu, 27 Sep 2018 13:09:20 GMT], Expires=[Thu, 01 Jan 1970 00:00:00 GMT], Server=[], Set-Cookie=[JSESSIONID=3572A15A4CF4B9005B8EC12963A531CE; Path=/B1iXcellerator; HttpOnly], X-FRAME-OPTIONS=[SAMEORIGIN]} Payload: <?xml version='1.0' encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Server</faultcode><faultstring>Server Error</faultstring><detail><xci:reason xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc">Msg 207, State S0001: Ungültiger Spaltenname "AutomaticBSFinding".</xci:reason><xci:tid xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc">180927104053412358970A0A0318EA2A</xci:tid><xci:exception xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc">com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception: com.sap.b1i.utilities.UtilException: UTE001 Nested exception: com.sap.engine.lib.xml.util.NestedException: Msg 207, State S0001: Ungültiger Spaltenname "AutomaticBSFinding".</xci:exception><xci:callStack xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc">com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception: com.sap.b1i.utilities.UtilException: UTE001 Nested exception: com.sap.engine.lib.xml.util.NestedException: Msg 207, State S0001: Ungültiger Spaltenname "AutomaticBSFinding". at com.sap.b1i.xcellerator.IPOWorkResource.execute(IPOWorkResource.java:527) at com.sap.b1i.xcellerator.IPOStepInstance.executeInner(IPOStepInstance.java:696) at com.sap.b1i.xcellerator.IPOStepInstance.executeOuter(IPOStepInstance.java:531) at com.sap.b1i.xcellerator.Xcellerator.trigger(Xcellerator.java:1449) at com.sap.b1i.xcellerator.SingleAdapterPool.trigger(SingleAdapterPool.java:462) at com.sap.b1i.xcellerator.ActiveListenerInteractor.trigger2(ActiveListenerInteractor.java:191) at com.sap.b1i.xcl_wsar.WSARListener.executeWSAx(WSARListener.java:219) at com.sap.b1i.xcl_wsar.WSARListener.handleWS(WSARListener.java:156) at com.sap.b1i.xcl_http.HTTPListener._doXxx(HTTPListener.java:1504) at com.sap.b1i.xcl_http.HTTPListener._doPost(HTTPListener.java:1405) at com.sap.b1i.xcl_http.HTTPListener.service(HTTPListener.java:805) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503) at java.lang.Thread.run(Thread.java:805) Caused by: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception: com.sap.b1i.utilities.UtilException: UTE001 Nested exception: com.sap.engine.lib.xml.util.NestedException: Msg 207, State S0001: Ungültiger Spaltenname "AutomaticBSFinding". at com.sap.b1i.bizprocessor.AtomScheduler.process(AtomScheduler.java:189) at com.sap.b1i.bizprocessor.IncludeAtom.process(IncludeAtom.java:200) at com.sap.b1i.bizprocessor.IncludeAtom.processOuter(IncludeAtom.java:171) at com.sap.b1i.bizprocessor.BizProcessor.process(BizProcessor.java:452) at com.sap.b1i.xcellerator.IPOStepInstance.executeTransaction(IPOStepInstance.java:1107) at com.sap.b1i.xcellerator.IPOWorkResource.execute(IPOWorkResource.java:425) ... 24 more Caused by: com.sap.b1i.utilities.UtilException: UTE001 Nested exception: com.sap.engine.lib.xml.util.NestedException: Msg 207, State S0001: Ungültiger Spaltenname "AutomaticBSFinding". at com.sap.b1i.utilities.XMLHandler$DocumentManipulator.transformSource2Result(XMLHandler.java:272) at com.sap.b1i.utilities.XMLHandler$DocumentManipulator.transformDocument2Stream(XMLHandler.java:251) at com.sap.b1i.utilities.XMLHandler$DocumentManipulator.transformDocument2Array(XMLHandler.java:239) at com.sap.b1i.bizprocessor.XformAtom.performPayloadXform(XformAtom.java:636) at com.sap.b1i.bizprocessor.XformAtom.execXslt(XformAtom.java:550) at com.sap.b1i.bizprocessor.XformAtom.run(XformAtom.java:510) Caused by: com.sap.engine.lib.xml.util.NestedException: Msg 207, State S0001: Ungültiger Spaltenname "AutomaticBSFinding". at com.sap.engine.lib.xsl.xslt.XSLMessage.process(XSLMessage.java:44) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLWhen.process(XSLWhen.java:66) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLChoose.process(XSLChoose.java:46) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLOtherwise.process(XSLOtherwise.java:45) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLChoose.process(XSLChoose.java:46) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLElement.process(XSLElement.java:248) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLElement.process(XSLElement.java:248) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLElement.process(XSLElement.java:248) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLTemplate.process(XSLTemplate.java:272) at com.sap.engine.lib.xsl.xslt.XSLStylesheet.callTemplate(XSLStylesheet.java:1341) at com.sap.engine.lib.xsl.xslt.XSLCallTemplate.process(XSLCallTemplate.java:111) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLElement.process(XSLElement.java:248) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLElement.process(XSLElement.java:248) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLElement.process(XSLElement.java:248) at com.sap.engine.lib.xsl.xslt.XSLNode.processFromFirst(XSLNode.java:293) at com.sap.engine.lib.xsl.xslt.XSLTemplate.process(XSLTemplate.java:272) at com.sap.engine.lib.xsl.xslt.XSLStylesheet.process(XSLStylesheet.java:457) at com.sap.engine.lib.xsl.xslt.XSLStylesheet.process(XSLStylesheet.java:391) at com.sap.engine.lib.jaxp.TransformerImpl.transformWithStylesheet(TransformerImpl.java:392) at com.sap.engine.lib.jaxp.TransformerImpl.transform(TransformerImpl.java:234) at com.sap.b1i.utilities.XMLHandler$DocumentManipulator.transformSource2Result(XMLHandler.java:264) ... 5 more </xci:callStack><xci:retryLater xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc">false</xci:retryLater></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> -------------------------------------- 2018-09-27 15:09:20,624 [postToDTOExternalSystem] WARN com.sap.scco.ap.pos.i14y.util.AbstractDTOService - an exception came up while posting ReceiptDTO to ERP (BusinessOne) com.sap.scco.util.exception.XState: javax.xml.ws.soap.SOAPFaultException: Server Error at com.sap.scco.ap.pos.i14y.b1.wrapper.BusinessOneServiceWrapper.postInvoice(BusinessOneServiceWrapper.java:2521) at com.sap.scco.ap.pos.i14y.b1.ReceiptDTO_B1WebserviceImpl.runPost(ReceiptDTO_B1WebserviceImpl.java:52) at com.sap.scco.ap.pos.i14y.b1.ReceiptDTO_B1WebserviceImpl.runPost(ReceiptDTO_B1WebserviceImpl.java:1) at com.sap.scco.ap.pos.i14y.util.AbstractDTOService$1.run(AbstractDTOService.java:232) at java.lang.Thread.run(Thread.java:808) Caused by: javax.xml.ws.soap.SOAPFaultException: Server Error at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:160) at com.sun.proxy.$Proxy67.sapPOSPOSTInvoice(Unknown Source) at com.sap.scco.ap.pos.i14y.b1.wrapper.BusinessOneServiceWrapper.postInvoice(BusinessOneServiceWrapper.java:2515) ... 4 more Caused by: org.apache.cxf.binding.soap.SoapFault: Server Error at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.unmarshalFault(Soap11FaultInInterceptor.java:86) at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.handleMessage(Soap11FaultInInterceptor.java:52) at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.handleMessage(Soap11FaultInInterceptor.java:41) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) at org.apache.cxf.interceptor.AbstractFaultChainInitiatorObserver.onMessage(AbstractFaultChainInitiatorObserver.java:113) at org.apache.cxf.binding.soap.interceptor.CheckFaultInterceptor.handleMessage(CheckFaultInterceptor.java:69) at org.apache.cxf.binding.soap.interceptor.CheckFaultInterceptor.handleMessage(CheckFaultInterceptor.java:34) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) at org.apache.cxf.endpoint.ClientImpl.onMessage(ClientImpl.java:802) at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponseInternal(HTTPConduit.java:1674) at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponse(HTTPConduit.java:1551) at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1348) at org.apache.cxf.io.CacheAndWriteOutputStream.postClose(CacheAndWriteOutputStream.java:56) at org.apache.cxf.io.CachedOutputStream.close(CachedOutputStream.java:215) at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:56) at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:651) at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:62) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:516) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:425) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:326) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:279) at org.apache.cxf.frontend.ClientProxy.invokeSync(ClientProxy.java:96) at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:138) ... 6 more 2018-09-27 15:09:20,631 [BYD_SCHEDULER_Worker-4] INFO com.sap.scco.ap.pos.i14y.util.callback.impl.ReceiptDTO_PostListCallback - XState=ListXState [BusinessOne: No Element was transferred successfully ,collectedErrors={1100001075=com.sap.scco.util.exception.XState: javax.xml.ws.soap.SOAPFaultException: Server Error, 1100001086=com.sap.scco.util.exception.XState: javax.xml.ws.soap.SOAPFaultException: Server Error, 1100001085=com.sap.scco.util.exception.XState: javax.xml.ws.soap.SOAPFaultException: Server Error, 1100001072=com.sap.scco.util.exception.XState: javax.xml.ws.soap.SOAPFaultException: Server Error, 1100001071=com.sap.scco.util.exception.XState: javax.xml.ws.soap.SOAPFaultException: Server Error, 1100001079=com.sap.scco.util.exception.XState: javax.xml.ws.soap.SOAPFaultException: Server Error, 1100001078=com.sap.scco.util.exception.XState: javax.xml.ws.soap.SOAPFaultException: Server Error}, collectedWarningMessages={}],stopSubsequentAttempts=true 2018-09-27 15:09:20,648 [BYD_SCHEDULER_Worker-4] INFO com.sap.scco.ap.pos.job.ReceiptJob - Sending receipts to external System finished! 2018-09-27 15:09:20,649 [BYD_SCHEDULER_Worker-4] INFO com.sap.scco.ap.pos.job.ReceiptJob - Sending day-end closing data to BusinessOne... 2018-09-27 15:09:20,652 [BYD_SCHEDULER_Worker-4] INFO com.sap.scco.ap.pos.i14y.util.callback.impl.CashDeskClosingDTO_PostListCallback - WarningMessages=[] 2018-09-27 15:09:20,665 [BYD_SCHEDULER_Worker-4] INFO com.sap.scco.ap.pos.job.ReceiptJob - Sending day-end closing as receipt data to External System finished!

[R_Zieschang · Accepted solution]

Hi Arne,

can you see the request from CCO in the B1i Message Log (Monitoring -> MessageLog)?

In your exception is stated:

Ungültiger Spaltenname "AutomaticBSFinding"

So there seems to be a missing database column in any of the databases (B1i or CCOCS Database?). Did you upgraded the existing B1i CCO Scenarios? Did you run the Schema Update procedure?

Kind regards

Robert

[Former Member · Accepted solution]

Hi Robert,

thanks for the answer! Yes i did update the scenarios to the latest version and yes i forgot(skipped) to run the Schema Update Procedure. Now it's working again! Thank you 🙂

Kind regards

Arne

[fish5185 · Accepted solution]

I have encountered the same error , and i forgot(skipped) to run the Schema Update Procedure. How do i ran the schema update procedure?

[anderson_schmitt · Accepted solution]

Hi fish5185,

Refer to the SAP Note #2163033 for additional information

Regards,
Anderson

[stephan_best]

Hi MANU,

in SAP Note 2163033 all steps are explained very well and you will find the latest Services.

Important is the CreateUpdateTable step, which is also mentioned in the SAP Note.

kind regards

Stephan

[anderson_schmitt]

Hello Manu,

Please take a look in the KBA #2163033 that explains the steps.

Regards,
Anderson Schmitt

[former_member484827]

Hi Arne,

I do have the same above issue .Could you please tell me the steps to upgrade CCO database tables and B1if.

Regards,

Manu

[former_member484827]

Heloo Arne,

Thank you so much .I followed the steps as per above and the issue has been fixed.Really helpful links.

Regards,

Manu

[former_member484827]

Heloo Anderson and Stephan,

Thank you so much for the support. We are using sap customer checkout 2.0 FP06 .Please find th eattched scenario package screen when i checked sapposecreateupdatetab, its greyed out am not able to click.Please guide me how to activate it.

regrds,

Manucco.png

[Former Member]

Hello Manu,

I think you are looking at the wrong place. Please read steps 1-9 of this SAP Note: https://launchpad.support.sap.com/#/notes/2163033

Step 9 is the most important one for the table update: "Go to “Scenarios“ and then select “Step Design”. In the scenario step Identifier select ‘sap.CustomerCheckout - sap.POS.CreateUpdateTab’. Click on processing. A pop-up will open which shows the design of the scenario step. Click on the Test. A new pop-up will open with several options like ‘Run’, ‘Analysis’, ‘Debug’….. . Click on Run. Wait for a while (few seconds to 1 minute). Click on Close. And close the pop-up which shows the design of the scenario step."

[gunther_sandtner2]

Hello Arne,

Please check the following in the B1i framework:

1. In SLD select the database CustomerCheckoutDb and make sure the "Test Connection" returns a success message

2. In Scenarios -> Control find the line sap.CustomerCheckout and click on the cog wheel (Open Scenario Package Administration) and make sure that the same user and the same system ID as in the Customer Checkout integration settings is maintained

Kind regards,

Gunther

[Former Member]

Thank you Gunther for the advice! I checked these settings several times, everything was working/correct. Robert pointed me in the right direction, i forgot to update the CCO database tables after I updated the B1i scenarios. Now everything is working fine.

Kind regards,

Arne