In order to resolve the issue you can try two options:
First Option:
1.
delete the bad records from the following tables where it shows the label id instead of the text:
delete from dirnamesequencetranslation where description like '@sys%'
delete from LOGISTICSLOCATIONROLETRANSLATION where description like '@sys%'
delete from LOGISTICSLOCATIONROLE where name like '@sys%'
delete from LOGISTICSADDRESSCOUNTRYREGIONTRANSLATION where longname like '@sys%'
2. restart the AOS to avoid a AOS caching issue when running the next X++ jobs
3. Create an X++ job with the following method calls
SysTranslationData::populateData(resourceStr(LogisticsLocationRoleData));
SysTranslationData::populateData(resourceStr(LogisticsAddressCountryRegionData));
SysTranslationData::populateData(resourceStr(DirNameSequenceData));
Second Option (if the first doesn't work) :
Use the following SQL scripts to address the data issues.
DELETE LOGISTICSLOCATIONROLE WHERE NAME LIKE '@SYS%'
DELETE LOGISTICSLOCATIONROLETRANSLATION WHERE LOCATIONROLE NOT IN (SELECT RECID FROM LOGISTICSLOCATIONROLE) AND LANGUAGEID = 'en-us'
update LOGISTICSLOCATIONROLETRANSLATION set DESCRIPTION = (select name from LOGISTICSLOCATIONROLE where LOGISTICSLOCATIONROLETRANSLATION.LOCATIONROLE = LOGISTICSLOCATIONROLE.RECID) where LANGUAGEID = 'en-us'
No comments:
Post a Comment