Error when synchronizing Receipts

[HectorSantos]

Hello

I am trying to synchronize receipts between Customer Checkout 2.0 FP08 PL10 in SQL and SBO 9.3 PL10 with CCO Scenarios version 4.0.04. I succes. I could succesfully sincrhonize Customers and Articles.

When I try to synchronice receipts i get the next error :

19 6/01/2020 02:47:22 PM: Error while sending receipt data: POS1100000016 :javax.xml.ws.soap.SOAPFaultException: Server Error

I check the message log in the Bif and see some diffrente messages

exceptionmsg="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: Invalid column name 'CreateCreditMemo'." msglogexcl="false" handover2CentralSrv="" MessageLog="true" msglogdbop="insert">
<Header>

and

exceptionmsg="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: 005 - SQL Error Invalid column name 'BPLId'."

I had succesfull test in the integratio

and success in all test in the Bif SLD

i followed notes https://launchpad.support.sap.com/#/notes/2202185 and https://launchpad.support.sap.com/#/notes/2694514 but not find that error message.

Any suggestions ?

Regards

Hector Santos

[anderson_schmitt · Accepted solution]

Hello Hector,

It seems that the columns "CreateCreditMemo" and "BPLId" were not created in the "PointOfSaleReceipt" table.

Did you execute the step #9 of the SAP Note #2163033?
If not, please execute this step and try again.

If your question in answered, kindly select the answer as "Right Answer". This helps other member of the community to follow and easily locate answers.

Regards,
Anderson