Matching record with key 'Product': for the data source 'EcoResProductCategory' does not exist

(0) Share

Report

Posted on by DAX Dev

Hello,

I try to create Released product and its attributes with the below code, using data entities. (Runnable class).

Product is created and released sucesfully.

When the line "ecoResProductAttributeValueEntity.insert();" is executed I'm getting the error message "Matching record with key 'Product': 68719519121 for the data source 'EcoResProductCategory' does not exist".

After it I tried to create value in EcoResProductCategory too. It is also created sucesfully, but at the end I still get the same error from EcoResProductAttributeValueEntity.insert();

I'm trying to do it now in job, but later I have to develop the csv file import, which should create Released products, create / assign Attributes to it, etc...

What am I doing wrong?

EcoResReleasedProductCreationV2Entity ecoResReleasedProductCreationV2Entity;

ecoResReleasedProductCreationV2Entity.clear();
ecoResReleasedProductCreationV2Entity.initValue();
ecoResReleasedProductCreationV2Entity.ItemNumber = 'AAA_Item';
ecoResReleasedProductCreationV2Entity.ItemModelGroupId = 'GDD';
ecoResReleasedProductCreationV2Entity.InventoryUnitSymbol = 'ea';
ecoResReleasedProductCreationV2Entity.ProductGroupId = 'FG';
ecoResReleasedProductCreationV2Entity.ProductType = EcoResProductType::Item;
ecoResReleasedProductCreationV2Entity.ProductNumber = 'AAA_Item';
ecoResReleasedProductCreationV2Entity.ProductSearchName = 'AAA_Item';
ecoResReleasedProductCreationV2Entity.ProductName = 'AAA_Item';
ecoResReleasedProductCreationV2Entity.TrackingDimensionGroupName = 'None';
ecoResReleasedProductCreationV2Entity.ProductSubType = EcoResProductSubtype::Product;
ecoResReleasedProductCreationV2Entity.SearchName = 'AAA_Item';
ecoResReleasedProductCreationV2Entity.SalesUnitSymbol = 'ea';
ecoResReleasedProductCreationV2Entity.StorageDimensionGroupName = 'SiteWH';
ecoResReleasedProductCreationV2Entity.PurchaseUnitSymbol = 'ea';
ecoResReleasedProductCreationV2Entity.insert();

EcoResProductCategory ecoResProductCategory;
ecoResProductCategory.clear();
ecoResProductCategory.initValue();
ecoResProductCategory.Product = EcoResProduct::findByProductNumber(ecoResReleasedProductCreationV2Entity.ProductNumber).RecId;
ecoResProductCategory.Category = 68719484036;
ecoResProductCategory.CategoryHierarchy = 68719479747;
ecoResProductCategory.insert();

EcoResProductAttributeValueEntity ecoResProductAttributeValueEntity;
ecoResProductAttributeValueEntity.clear();
ecoResProductAttributeValueEntity.initValue();
ecoResProductAttributeValueEntity.ProductNumber = ecoResReleasedProductCreationV2Entity.ProductNumber;
ecoResProductAttributeValueEntity.AttributeName = "xxx";
ecoResProductAttributeValueEntity.BooleanValue = NoYes::Yes;

ecoResProductAttributeValueEntity.insert();

I have the same question (0)

All responses (9)

Answers (0)

André Arnaud de Cal... 301,156 Super User 2025 Season 2 on at

Like (0)

Report

Hi DaxDev,

Is the Attribute name 'xxx' a valid attribute in the environment? It might be checking a table relation here.

Was this reply helpful? Yes No
DAX Dev on at

Like (0)

Report

Hi Andre,

Yes, I have validated that. There is the record in EcoResAttribute table for that attribute name

Was this reply helpful? Yes No
DAX Dev on at

Like (0)

Report

Strange thing is that the record is created in EcoResProductCategory table with the correct "Product", but still receiving the error

Was this reply helpful? Yes No
André Arnaud de Cal... 301,156 Super User 2025 Season 2 on at

Like (0)

Report

Have you tried using these entities in a data management import project from a source file to see if that works with inserts?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Dax Dev,

Were you able to find a solution to this? I'm struggling with the same error when trying to insert attribute values via Logic Apps. Inserting exactly the same attribute value data on the same product through DMF works without any issues, but doing it from Logic Apps gives the error "Matching record with key 'Product': XXXX for the data source 'EcoResProductCategory' does not exist".

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Dax Dev,

Are you using oData to push data to D365 for Logic Apps?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sergei,

I'm using the built in D365 connector in Logic Apps, but I assume the connector is using odata.

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Espen,

Have you tried to get a record first to check if exists (get record by the same key or get list (to list all records) action)?

Have you checked that the user associated with the application in D365 has the correct default company?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for pointing me in the right direction, Sergei!

I did a check to see if the record existed, and indeed it did - although with an empty attribute value. So the solution was to update the record instead of creating a new one.

Guess I was confused by the error message and did not see the obvious solution. Thanks again!

Was this reply helpful? Yes No