cancel
Showing results for 
Search instead for 
Did you mean: 

Having problems at retreiving articles data from SAP Business One to SAP Customer Checkout

deicyh
Discoverer
0 Kudos

When we were executing a first time integration process from SAP Customer Checkout to SAP Business One (CCC instance) we were able to get the business partners (clients) data, however we were not able to retreive any articles data form SAP Business One.

The message error we are getting is the following: "an SQL data change is not permitted for a read-only connection, user or database".

Any guidance in how to solve this problem will be gratelly appreciated.

Accepted Solutions (0)

Answers (2)

Answers (2)

Harish_Vatsa
Active Contributor

Dear deicyh,

The error message suggests that the user or database connection utilized for integrating SAP Customer Checkout with SAP Business One (CCC instance) lacks the required permissions to make changes to the data within the SAP Business One database.

Kindly verify the permissions once and the DB connection settings.

--

Regards,

H.V.

deicyh
Discoverer
0 Kudos

Dear Harish, thanks for the advice. Based on your suggestion we have given all DB access permission to the Service Layer user, however it did not work, any other idea?

Harish_Vatsa
Active Contributor

Can you please confirm if the DB connection settings have also been checked once?

e.g.: DB server and port, DB name and credentials, authentication method, Read/Write permissions, Firewall and network access etc.

--

Regards,

H.V.

0 Kudos

Dear deicyh,

Review the KBA #2814533. It might help you to solve the issue.

If this answers your question, kindly select "Right Answer". This helps others to follow and easily locate correct answers.

Regards,

Gunther