Finance | Project Operations, Human Resources, ...

Answered

Update Product Dimension Size in Released Product Variant in AX2012 through X++

(0) Share

Report

Posted on by Rhushikesh R

758

Hi Everyone,

Recently I have restored Database from AX2012 Prod Environment to AX2012 DEV environment.

However, for one of the Released Products, required Sizes are missing from Size Master in AX2012 DEV. Please refer below screenshots..

Can anyone please tell me the root-cause of same? What workaround should be done to reflect the Sizes in all Released Product Variants forms.

I am still guessing how those sizes have been removed from Size Master, as we cannot delete Size when the Variant is created for same.

Could the corrupted database BAK file be the reason behind this? Or had someone deleted the sizes from SQL server?

For all remaining released products I can see the Size in Size master.

Below are the Production Ax2012 screenshots,

3513.PR01.png

5670.PR02.png

Below are the DEV Ax2012 screenshots,

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

RE: Update Product Dimension Size in Released Product Variant in AX2012 through X++

Hi Rhushikesh,

I would suggest you try restoring the DB again and check if you can replicate the issue. Without anyone deleting the records, they shouldn't be missing.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

RE: Update Product Dimension Size in Released Product Variant in AX2012 through X++

When you restored the database, did you take only the business database or also the model database? Normally you need to copy both. The only exception is if you have the same element ID values in both systems - and this can only happen if you have done modelstore deliveries from dev -> test -> prod.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

RE: Update Product Dimension Size in Released Product Variant in AX2012 through X++

Hi Nikolaos,

Thank you. But we only restored Business database. As we are having some customization on DEV which has not been moved to Test and Prod.

To resolve the issue, restoring the database is the only option we are left with, correct?

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

RE: Update Product Dimension Size in Released Product Variant in AX2012 through X++

Yes, you should restore your dev database from a backup.

Next time, you can copy prod db to dev like this:

1) Export your customization model from Dev

2) Export version control data, if you're using MorhpX version control

3) Restore prod databases to dev

4) Import version control data

5) Import the model that was exported in step 1

6) Full build, CIL, sync

And, of course you might need to change some setup in the database or your batches, SSRS etc will not work, and you might have integration issues, but that's another story.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Update Product Dimension Size in Released Product Variant in AX2012 through X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Update Product Dimension Size in Released Product Variant in AX2012 through X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates