IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2 - ODI
Description::
This error we will get when there is multiple entries in SNP_LOC_REP table.
Solution: Delete latest entry and make sure only one entry will be there in the same table.
Error msg looks like below::
In my case there 2 entries in SNP_LOC_REP table, deleted entry from the same.
After deleting one entry from the SNP_LOC_REP table
Now ODI logged in successfully.
Thanks,
Mady
