Exceptional error in CRM - KWS

(0) Share

Report

Posted on by Community Member

Hi Team,

Can you help me to resolve this below error?

Error:

An error occurred with the following error message: "KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: The product cannot be added because it is not active (Error Code: -2147220203, Detail Message: The product cannot be added because it is not active) (SSIS Integration Toolkit for Microsoft Dynamics 365, v10.2.0.6982 - ISServerExec, v11.0.5058.0)System.ServiceModel.FaultException<KingswaySoft.DynamicsCrmServices.Soap2011.OrganizationService.OrganizationServiceFault> : The product cannot be added because it is not active".

I am trying to insert products into ‘optyproduct’ entity. Here productid field using lookup to find the productid from ‘product’ entity.

Looks like this error indicates that product id is not available in ‘product’? Correct me if am wrong.

But when I have checked the source products in product entity and found products available in ‘product’ entity.

Example, 79 is the product number which is available in ‘Product’ entity as well. But it throws an error when try to insert into ‘optyproduct’ entity.

Can you have any clue about this issue?

Thanks for your support!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Sreevalli 3,256 on at

Like (1)

Report

Hi,

What is the product status and status reason, we cannot do such operations on inactive products. if it is in inactive state then active it and do the rest. you may deactivate it back, but check your business criticality and impacts ons reactivating and deactivating scenarios.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Thanks for your response.

Those products are in 'ACTIVE' and 'Valid' status.

Was this reply helpful? Yes No
Sreevalli 3,256 on at

Like (0)

Report

but the error clearly says product is not active, what is the behaviour when you try to do it manually? any background jobs?

Was this reply helpful? Yes No
Suggested answer

Charles Abi Khirs 3,569 on at

Like (0)

Report

Hello,

It looks like you are programmatically adding a product that is not published to an opportunity.

You have to open the product record (from the product catalog) that you are willing to add to the opportunity and then click on Publish button in the ribbon.

Was this reply helpful? Yes No