Lost data by changing extended data type

(0) Share

Report

Posted on by Shabir Ahmad

3,110

Dear Experts,

I wanted to change a field size, the field extended data type was "Notes".The "Notes" Extended data type String Size property was "Memo" I just change it to 100 instead "Memo". when i checked some of the fields lost the data by this changing. What i did i delete Notes extended data type and sync the db but still the data is not being recovered with this act. Any idea thanks in advance for your valuable suggestions.

Best Regards,

Shabir Ahmad

I have the same question (0)

All responses (10)

Answers (2)

Shabir Ahmad 3,110 on at

Like (0)

Report

RE: Lost data by changing extended data type

Dear Both,

First, i delete that extended data type note and sync db, but didn't work. I just simply made a job for that table and field to update all vendor detail:

static void DataDic_SetTmp123(Args _args)

{

VendTable vendtable;

;

ttsBegin;

select forUpdate vendtable

where vendtable.AccountNum == '10029'; // Account Number

vendtable.mod3VendBankNotes =" ABC the missig data for the above account"; //missing info

vendtable.update();

ttsCommit;

}

Further, I think it can be done using the" Data import export Framework" Module, or writing code for importing all data from an excel sheet or XML but i didn't take any risk.

Specially thanks to both of you again.

Best Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Verified answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

RE: Lost data by changing extended data type

Hi Shabir,

Please let us know if you have any further questions on this thread. If not, can you please review and help verify responses that helped you.

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

RE: Lost data by changing extended data type

I wouldn't recommend restore on production as there may be other transactions. What you can do is, get the production backup copy that has good data restored on some other environment. Then extract addresses from both environments, compare and then do update in production via data entities. If very few address to update, even do that manually.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

RE: Lost data by changing extended data type

Dear Satish Panwar,

The issue is on the production server environment, not on test environment .

Best Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

RE: Lost data by changing extended data type

Thank Shabir. If Dev environment, shouldn't be an issue.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

RE: Lost data by changing extended data type

Dear Satish Panwar,

Yes, it is only one column issue some of vendor addresses are missing it is showing half address. For example if a vendor address is less than 100 character it will show all and above than 100 will show only 100 characters.

Best Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

RE: Lost data by changing extended data type

If it's just a column issue and you can pull data from other table, you can just restore the table column data. If you are not comfortable with column copying/update, then you can just proceed with DB copying.

Assuming this is related to DEV - Another question to think about is - Do you need that column data in your DEV environment? If not, let data be truncated if it doesn't bother you.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

RE: Lost data by changing extended data type

Dear Both,

Thanks for your valuable suggestions.Should i restore full db??

Best Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (2)

Report

RE: Lost data by changing extended data type

I assume you did it in a dev system, and tested already there, and found the issue? Or, latest found it in test system. So, no valuable prod data is lost. Anyway you can restore from backup to get your data back.

You should not make such change because you will lose data. Instead introduce a new field, and change your app o use the new field. Then migrate existing data to the new field with a job. Finally, you can delete the old field in the next update.

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

RE: Lost data by changing extended data type

When you change data type and sync the data does gets lost (E.g. String 20 to String 10). If you have a backup, try recovering data from there now.

Was this reply helpful? Yes No

Community site session details

Lost data by changing extended data type

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Lost data by changing extended data type

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates