You’re offline. This is a read only version of the page.
I currently work on upgrading NAV from 2009r2 to 2015
Everything going great unitl I try to update data.
I ran "Data update" and process stoped by error "Choose a valid field in the Contact table" for one of 7 companies.
I try to continue updating and ignore this error, then other companies all error "The source Code already exists. Identification fields and values : Code = 'PAYNTRECON' ".
So sad I couldnt debug the update code (At least I didnt know how.)
Stucked in this error several days, any one has clue what problem this is and how i can fix it.
*This post is locked for comments
Dear Experts,
I will appreciate your help on this issue of mine.
I'm currently working on upgrading NAV from 2009R2 to 2015. Everything is going great though with few challenges which I've been able to cope with but I'm now stuck with this particular one, on which I need your help.
My Data upgrade is being stopped at 87% by error "The definition of the WIP Method field has changed; old type: Code, new type: Option. Start your activity again'
I have made several attempts but couldn't resolve the error.
Thank you
If I remember correctly then in UpdateOutlookSynchFilter and UpdateOutlookSynchField functions there is a validation on modify trigger and one of the fields so you can change the validation to False and try again
Thank you, it seems like you have pointed me into the right functions.
I've exported all Objects as text earlier, but still couldn't sort this out to find anything with "Attendee Type". But it uses recordref and it is in the UpdateOutlookSynchField function where it fails. Because in the table 5304 "Outlook Synch. Field" some of the records have a value in the condition Field as string/text based on Norwegian as you suggested. And it seems that even if the environement, Client and Development is running with Norwegian the "Start Upgrade" using Powershell in the background seems to run under other Language. That is probably also why I didn't get any errors when I started the codeunits myself, because than it understood the OptionCaptionML. This is actually a "issue" that Microsoft should describe or find a solution for if they haven't.
Since I've now already run the test data upgrade codeunits manually I will not be able to re-run this until I've got some more time to restore the backup. But I believe the solution for me would be to skip this UpdateOutlookSynchField function and run that piece of code separately. I will try that when going live.
Hi
The UPG6080Main.UpgradeMethods, UPGDIM6080.UpdateDimensionTables are the functions used to upgrade the data from the Tables, the error you are receiving is from the UpgradeMethods, you have to look at the functions inside this function, the upgrade toolkit gives us the main function where the error occurs but it is not user friendly when we ran into these type of issues, we have to spent more time to find what caused this issue as in 2015 we don't have the option to debug during the upgrade.
Regarding "Attendee Type" error it seems to be the business using outlook sync, have a look at below functions in the UpgradeMethods() of the codeunit 104051
UpdateOutlookSynchFilter;
UpdateOutlookSynchField;
and check the OptionCaptionML of the Attendee Type, if any other languages specified other than Norwegian, Try by specifying the Values of Norwegian
Regards
Rajasekhar.Y
Hi there,
I also ran into the 'PAYNTRECON' issue. Deleting the record from all companies apparently does NOT resolve the issue. As it looks, it is a follow-up error from another error (for example, a dimension entry mismatch), and when you resume the upgrade, you get the 'PAYNTRECON' error. All in all, the upgrade functions don't do the right thing in this case, you end up with a probably botched-up database. Better to go back, and run the upgrade (after handling the data errors, preferably in 2009 already) again on a fresh database.
Overall, I see the intent of the data upgrade functionality, but it does not work. It's a pity, really.
with best regards
Jens
I found your subject very appropiate so I tag along here if it is okey? We are also doing a 2009 R2 to 2015 data Upgrade (Norwegian database). And I can't seem to find the reason for this error:
SessionId : 33
CodeunitId : 104055
FunctionName : StartUpgrade
CompanyName : XXXXXXXXXXXXXX
StartTime : 20.04.2015 15:20:57
Duration :
State : FailedPendingResume
Error : This is not a valid option for the Attendee Type field. The possible options are: 'Contact,Salesperson'.
The only table containing "Attendee Type" is the "Attendee" table 5199. And in none of the Upgrade codeunits I seem to find anything related to this. I've spent pretty much time on this so I finally run the upgrade codeunits manually from NAV, for each Company and removed the "Upgrade" Properties from the codeunits, don't know if that is safe or not but this didn't give me any errors at least :(
So two question:
1.) How to solve the "Attendee Type" Field issue so I can continue With the described data Upgrade?
2.) Is it safe to run the codeunits manually for each Company and just running the delete Objects in the end? I did run it as follow:
UPG6080Main.UpgradeMethods;
UPGDIM6080.UpdateDimensionTables;
//MarkUpgradeToolkit.MarkTablesForDeletion;
Thank you.
Welcome :)
Regards
Rajasekhar.Y
Hei
It works and need to fix record manually.
Thank you for you help
Hi
Delete the Source Code "PAYNTRECON" in the Source Codes
Regards
Rajasekhar.Y
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (