Cannot execute the required database operation. Attempted to save a record with an invalid type. Import Products in AX2012

(0) Share

Report

Posted on by CBNestor

Hi Guys,

I've got something interesting while importing products using DIXF;

An error with "Attempted to save a record with an invalid type" pops up without too much track. When I look into the EcoResProduct table I can see that item was really added but not released.

and then I see that another item with a different product type with the same ItemId was there, Then I realized that the same I imported long to ago from a different company as a "Product Mater", and here in the actual case from a different company I am importing it as a just product type: "Product".

So my question is... since there are many many items with the same case.. and a im still missing to import from few more companies.. I would like to change the products table as a not Shared table.

SaveDataPerCompany = Yes.

If I change the system will automatycally assign the Product to the initial company it was created/imported to?, or I have to assing manually or will it make more problems/inconsistencies?

thanks a lot for your time, I really appreciated

I have the same question (0)

All responses (7)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Nestor C,

I don't think you should change the EcoReProduct table to have "SaveDataPerCompany" property set as "Yes". This may cause issues for you as it is used across the application. If a product already exists in the system with the same Id, you could probably detect it before writing to target and change the Id to something like <dataAreaId> - <ProductId>.

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report
Copy link

Link copied!

Hi Gunjan,

thanks for your reply

I still need to migrate open sales and purchases ... and each companies is creating new item every day.

the old system (Axapta 3.0) is already working like that.. every company has his own item. And we name them acording to our clients Id number from their purchases so is easier for us to track them since we have more than 30.000 items...

by know I would like to test it out with SaveDataPerCompany = Yes.

Do you know if Ax automatically segregate them to their original DataAreaId?

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Nestor,

Axapta 3.0 would have had Item Ids only and the concept of Product Ids wasn't present. I am suggesting you keep the same Item Id (since InventTable is a DataAreaId specific table) and change the Product number. For an example, you are importing an Item with Id "A-001", but the product number already exists and has a different product type than the one you are importing, you can rename the Product number to "A-001-USMF" (USMF being the DataAreaId here). The itemId remains the same i.e. "A-001".

This way when you migrate the orders, you won't face any issues.

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report
Copy link

Link copied!

Hi Gunjan,

I thinking very seriously about your solution. So you mean Leaving the same ItemId for all the global items but importing with a Company specific sufix for the DisplayProductNumber.

would it work like that when importing?.. I will give it a try

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Nestor,

We have faced such situations while upgrading from AX 2009 when the system automatically assigned '-##" characters for the product number since they were conflicting. I believe appending the Product number with the DataAreaId would make more sense as you would be able to identify the legal entity for which the product number is different.

Please give it a try and see if the import goes through without issues.

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report
Copy link

Link copied!

Actually I have imported one and it works. It went automatically into the Released table with Item Id as the global and Product name with the sufix. I will Try with the rest And give you feedback :)

thanks a lot before hand

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Sure. I believe it will work without any issues. Please try with all products and check if they go through.

Was this reply helpful? Yes No