Skip to main content

Error Merge Person fails with "ora-01722 invalid number" or "50000: Conversion failed when converting the varchar value"

In this article, we explain why merge table errors like ORA-0172 and varchar conversion failures occur and how to resolve them.

Y
Written by Yusef Abulaynain
Updated over a month ago

This is caused by a known bug in the merge procedure where the forms answers to be merged contain answers prepopulated using the person id uri.
​

πŸ“ŒNote: To open the link, you'll need to log in to the Customer Success Portal.


The fix for this bug is available from Mosaic 22.2.3.0.
​
If a customer is not able to upgrade to 22.2.3.0 and urgently needs the fix, the updated merge package can be provided as a hotfix. Please see the notes on the linked ADO case for scripts and instructions.

Did this answer your question?