Ted JohnstonJune 6, 2023 at 2:57 pmPost count: 5
I’m trying to import customers exported from NAV.
The field validation is helpful as a few field names have changed. I updated my file.
Now, when I try to import to table 18 with all the options set to yes, I receive the following error (copied details from BC).
If requesting support, please provide the following details to help troubleshooting:
An item with the same key has already been added.
Internal session ID:
Application Insights session ID:
Client activity id:
Time stamp on error:
AL call stack:
“IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).getFieldNames line 62 – Import Export PowerTool by Insight Works
“IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).doAfterImportRecord line 8 – Import Export PowerTool by Insight Works
“IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).”Integer – OnBeforeInsertRecord”(Trigger) line 10 – Import Export PowerTool by Insight Works
“IWX IEPT Universal Imp. Exp.”(Page 23067856).doImport line 17 – Import Export PowerTool by Insight Works
“IWX IEPT Universal Imp. Exp.”(Page 23067856).”acImport – OnAction”(Trigger) line 2 – Import Export PowerTool by Insight WorksTed JohnstonJune 7, 2023 at 11:46 amPost count: 5
More info- Company is in a sandbox in current SaaS BC.
Cut the import down to just two records, same error so I know there is not a duplicate in the data.
Turned off Do Two step, same error.
Turned off the RunOnModify trigger, same error.Insight WorksJune 7, 2023 at 4:15 pmPost count: 6
It may be a sub-table with duplicate data. If the validation triggers are enabled (field and record), it’s possible BC is trying to create new, conflicting data. You can try disabling that to see if it helps. If not, if you can provide a sample of the data, either here or to our support department we can have a look at the possible cause.Ted JohnstonJune 8, 2023 at 7:41 amPost count: 5
This is a new sandbox with a new company so the likelihood of a duplicate is small.
Who do I send a data sample to? I would rather not post it here.
- You must be logged in to reply to this topic.