Skip to Content
0
Former Member
May 10, 2016 at 06:28 PM

The data type of a column in the query is not valid. (IES 10811) - Epic Universe

450 Views

We are working with WEBIs that have been released from a Universe modified from the Epic released universe and have to make a few small changes to the SQL code behind the WEBIs

The fields joined are still the same data type and none of the fields in the SELECT or WHERE clause have changed. Anyone have advice on what else I can troubleshoot?

Thanks in advance, code is below:

Modified Code

INNER JOIN CLARITY_SER_2 X_CLARITY_SER_800 ON (V_LOG_BASED.PRIMARY_PHYSICIAN_ID=X_CLARITY_SER_800.PROV_ID)

LEFT OUTER JOIN ZC_PAT_SERVICE ON (X_CLARITY_SER_800.SERVICE_DEFAULT_C=ZC_PAT_SERVICE.HOSP_SERV_C)

Original Code

INNER JOIN X_CLARITY_SER_800 ON (V_LOG_BASED.PRIMARY_PHYSICIAN_ID=X_CLARITY_SER_800.PROV_ID)

INNER JOIN ZC_PAT_SERVICE ON (X_CLARITY_SER_800.SERVICE_DEFAULT_C=ZC_PAT_SERVICE.HOSP_SERV_C)