3,090
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
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
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.
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.
Dear Satish Panwar,
The issue is on the production server environment, not on test environment .
Best Regards,
Shabir Ahmad
Thank Shabir. If Dev environment, shouldn't be an issue.
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
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.
Dear Both,
Thanks for your valuable suggestions.Should i restore full db??
Best Regards,
Shabir Ahmad
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.
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.
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
