Hi,

When i log into Application architect, system throws the error "Invalid column name FEDERATEDIDENTITY" and "Invalid column name UNameLF" with a query that cannot execute.  This error is raised by a query and when i execute the query without the above said columns, it returns a row. These columns are missing in the table USERSECURITY and USERINFO. Please help me to fix the issue. Thanks.

RDs, KVG

Hi KVG,

The FEDERATEDIDENTITY field is added to the USERSECURITY table in the "Infor CRM v8.3.0.sxb". The UNameLF is a calculated field within Infor CRM so isn't available directly in SQL. The SQL statment to perform the same calculation is as follows: SELECT LASTNAME + ', ' + FIRSTNAME AS UNameLF FROM USERINFO.

If you install the Infor CRM v8.3.0.sxb in administrator you will get the FEDERATEDIDENTITY column added to the USERSECURITY table.

Check the documentation folder on the Infor_CRM_v8.3 iso for the Infor CRM Implementation Guide.pdf or the Upgrading to Infor CRM v8.3.pdf for information on the steps required to get the system to 8.3.

Steve

Thanks Steve. The resolution helps me to fix the issue.