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

All responses (4)

Answers (0)

Suggested answer

Charles Abi Khirs 3,569 on at

Like (0)

Report

RE: Exceptional error in CRM - KWS

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.
Sreevalli 3,256 on at

Like (0)

Report

RE: Exceptional error in CRM - KWS

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

Like (0)

Report

RE: Exceptional error in CRM - KWS

Hi,

Thanks for your response.

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

Sreevalli 3,256 on at

Like (1)

Report

RE: Exceptional error in CRM - KWS

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.