SAP CCO TO SAP B1 RECIPTS AND INVOICE SYNCING

[former_member658729]

Dear All,

We implemented Customer Checkout to one of our customer. Its working fine .I am trying to sync the data receipts & Invoices from CCO to SAP B1 ,data is not syncing and below error is appearing.

Error :Error while sending receipt data: javax.xml.ws.soap.SOAPFaultException: Server Error

So please Help us to get it done.

[former_member658729]

Dear Joerg Aldinger,

Thanks for your continuous support, As you suggested we modified the xml Edition and i reproduced the Createupdate tab. we posted entries in CCO & we Received the successful message from CCO with 0 receipts posted .As well integration monitoring message log but still entries not posted into the SAP but in integration frame work i could see receiver system.

please help me to get it done.

Kindly find the below screen shot for your referancereciver-system.png

[JoergAldinger]

Hello jeelan_jaan ,

Thanks for the screenshots. The specific error you are getting is this one:

This happens if the database structure of the "CustomerCheckout" database on B1i is not up to date (the CreateCreditMemo column is missing). Running step 9 of the scenario note should fix this. However, I have noticed that recently the "CreateUpdateTab" step is failing (without actually telling you so).

I have this same issue on a new server we installed recently and I am currently debugging this issue. The "correct" way to fix this would be to raise a support incident, though, so SAP can fix it. It may be a "regression bug", because this has been working in earlier scenarios. It could also be that it only happens on HANA.

My suggestion is to raise the support incident. Either way, I will post back when I know the reason the CreateUpdateTab step is failing.

Best regards,

Joerg.

[JoergAldinger]

So I have debugged the CreateUpdateTab step and found that the SELECT queries checking for existing tables and columns are using the restricted schema name "SYS" instead of "PUBLIC". So in order to correct the scenario, essentially all references to "SYS"."COLUMNS" (which is not accessible to restricted database users) should be replaced by a reference to "PUBLIC"."TABLE_COLUMNS" (which is accessible to regular database users).

I will try to correct the scenario and test again. If it works, I will raise an incident and request to have the scenario corrected.

I guess you are using HANA, too? If so, you could try granting privilege to your DB user (B1ADMIN in my case) like so:

GRANT SELECT ON SCHEMA SYS TO B1ADMIN;

Then run the "CreateUpdateTab" step again. After everything is working you can revoke the privilege again:

REVOKE SELECT ON SCHEMA SYS FROM B1ADMIN;

Let me know if it helped in your case.

Best regards,

Joerg.

[JoergAldinger]

Here is another way to fix this issue (if you are on HANA and are not using SYSTEM as the database user, which is the recommended way of installation):

1. Log into the Integration Framework 1.0
2. Go to Tools... XML Editor
3. Select (you cannot copy and paste, unfortunately) and open the following document to edit: /com.sap.b1i.vplatform.scenarios.design/vPac.sap.CustomerCheckout/CommonTemplate.xsl
4. Replace all 8 (eight) instances of:

with:

1. Save the document
2. Run the "CreateUpdateTab" step again

I have tested this solution and it works correctly. bikash.bansal , can we get this fixed in the next version of the scenarios? 🙂

Best regards,

Joerg.

[former_member658729]

Dear joerg.ceo,

Thank you for you reply ,here i have attached the error log for your perusal. Kindly check and do the needfulsysc1.pngsysc2.pngsysc3.pngsysc4.pngsysc5.pngsysc6.pngsysc7.pngsysc8.png

[former_member658729]

Dear joerg.ceo,

shall we connect the online , i will show the issue now itself.because of system is in live

[JoergAldinger]

I'm sorry, but if you need urgent support you should contact SAP. I'm just a fellow consultant and try to help where I can, with the primary goal of benefitting everyone participating in the community.

Best regards,

Joerg.

[former_member658729]

Dear joerg.ceo

Thank you for your reply .As per last reply same scenario i tried earlier and now also after following the above scenario also same error is coming. Kindly find the below attachment's for your referencedata-sync-error1-command1.pngdata-sync-error1-command2.pngdata-sync-error1-command3.pngdata-sync-error.png

[JoergAldinger]

Hello jeelan_jaan ,

I can't see the error message from the screenshots you posted. I believe you should be able to see some detail above the first screenshot you posted. The SOAP envelope should hold some additional information on what is happening, but I can only see the end of it.

Best regards,

Joerg.

[JoergAldinger]

Hello jeelan_jaan ,

Please share the full error message, since there are multiple possible reasons for the Server Error you mention. Anyway, here are a few points to check:

1. Make sure your B1i connection test from CCO is successful
2. Make sure you use the latest version of the SAP Customer Checkout scenarios from note 2163033
3. Make sure the scenarios are active
4. Make sure you have run step 9 of the note 2163033 (also mentioned right at the top under "Important")

If still unsuccessful, please post the full error message.

Hope this helps.

Best regards,

Joerg.