11-27-2018 02:58 PM
I get an error in our test system when trying to import a bio information autofill file with this message for each primary key (emplID):
Unable to update record with primary key = <id> because multiple records exist with same primary key
I have compared this configuration to Production and don't see any differences. When the Production system runs the same file, it doesn't give me any errors.
Settings used for import from Verification Reports (OnBase 17 TEST system):
The separator for this process is set to '|'
The delimiter for this process is set to ''
[ ] Update all documents with data from file
[ ] Only update documents for changed AutoFill Keyword sets
[ ] Auto-folder updated documents
[ ] Log document keyword modification
[ ] Add to Workflow for changed Keyword
All I want it to do is replace autofill records in OnBase Test with the new set and delete old ones if they don't exist in the new file.
11-28-2018 06:50 AM
Hi Alexander,
The error you are getting is stating is there are multiple AutoFill records with the same emplID value that's noted in the error, so it's refusing to update both. I believe we do this since you would end up with two Key Sets in the AutoFill that are exactly the same if the update did occur.
You can search existing Keyword Set instances in Thick Client | Admin | AutoFill Keyword Sets | Management | <Select AutoFill> | View Search. I am expecting to find at least 2 Keyword Set instances for the emplID in question. You could right click and delete one of them, but you may run into this same situation continuously.
A better option for you may be to just process a completely blank text file with only the "Remove all AutoFill Keyword sets not found in file" option selected. This will delete all of the Keyword Sets currently stored in the AutoFill, and you could then process your good Index file to re-populate the AutoFill.
Please let me know if you have any questions!
Best,
Joel
11-28-2018 06:50 AM
Hi Alexander,
The error you are getting is stating is there are multiple AutoFill records with the same emplID value that's noted in the error, so it's refusing to update both. I believe we do this since you would end up with two Key Sets in the AutoFill that are exactly the same if the update did occur.
You can search existing Keyword Set instances in Thick Client | Admin | AutoFill Keyword Sets | Management | <Select AutoFill> | View Search. I am expecting to find at least 2 Keyword Set instances for the emplID in question. You could right click and delete one of them, but you may run into this same situation continuously.
A better option for you may be to just process a completely blank text file with only the "Remove all AutoFill Keyword sets not found in file" option selected. This will delete all of the Keyword Sets currently stored in the AutoFill, and you could then process your good Index file to re-populate the AutoFill.
Please let me know if you have any questions!
Best,
Joel
05-10-2022 12:32 PM
HI
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.