Troubleshooting Digital Analytics integration - Error 11528

Symptoms: This topic explains what to do if Error 11528 occurs during a Select process run when Digital Analytics segments are used as input.

Cause: Error 11528 occurs during a Select process run in an Unica Campaign flowchart. The error states that the SQL call failed and mentions a data type mismatch.

Resolution:This error can occur if the data type of the registrationid in the translation table does not match the data type that is defined in IBM Digital Analytics. The data type of the registrationid in the translation table does not match the data type that is defined for the registrationID in IBM Digital Analytics. For example, one might be NUMERIC but the other is VARCHAR.

If Digital Analytics segments are being used as input to the Select process, then you can resolve Error 11528 by changing the data type of the registrationid in the translation table so that it matches the data type that is defined in IBM Digital Analytics. For example, set them both to VARCHAR. For more information, read about creating and populating the translation table.