iBO error after calling getcontactbyid and editing member type and category fields. AFter submit changs the following error is received. I've droped all custom triggers. Any ideas on where else I should look.
Error Index=1 ErrorNumber=1000 ErrorLocation=Source: (Microsoft OLE DB Provider for SQL Server - iboDataServer.CExecSQL.ExecWriteSQL) ErrorCategory=1 ErrorMessage=Unknown error. Description: Tables or functions 'Name' and 'Name' have the same exposed names. Use correlation names to distinguish them.
Resolved
If you have a field that is both an Name_Index and in the UD Company Flowdown you will get this malformed update. Since I doubt you would have Name.COUNTRY in the UD Company Flowdown my guess is that since it is part of the normal Company Flowdown and may probably cause the same issue.
But make sure you don't actually have Name.COUNTRY in the UD setup. Beyond, that the only option is to remove the Name.COUNTRY index.