Qlik error finding column in database

[jvdb]

Hi All,

I am trying to get some data out of an database. However, the load script does give an error in Qlik. When I run the SQL statement in the database, there occurs no error.

See below the error and the SQL statement.

Select
a.FK_BUDGETORDERINTAKEYEAR,
a.BUDGET,
a.MARGE,
a.BUDGETPRODUCTION,
a.PK_U_BUDGETORDERCATEGORY,
a.FK_BUDGETORDERCATEGORY,
a.FK_BUDGETSERVICECONTRACTTYPE,
a.INVOICEORDERINTAKE,
b.PK_R_ORDER,
b.FK_ORDERCATEGORY,
c.PK_R_SALESORDERDETAILMISC,
c.NETSALESAMOUNT,
c.ORDERDATE,
//c.FK_SALESPERSON,
d.FK_FINANCIALYEAR,
d.PRODUCTIONPERCENTAGE

FROM U_BUDGETORDERCATEGORY a
LEFT JOIN R_ORDER b ON a.FK_BUDGETORDERCATEGORY = b.FK_ORDERCATEGORY
LEFT JOIN V_R_SALESORDERDETAILMISC c ON b.PK_R_ORDER = c.FK_ORDER
LEFT JOIN U_PRODUCTION d ON c.PK_R_SALESORDERDETAILMISC = d.FK_SALESORDERDETAILMISC;

[mpc]

Hi, 

In your screenshot, FK_ORDERCATEGORY comes from c (U_BUDGETORDERCATEGORY maybe, cannot see because truncate) table, but in the SQL request you've shared, it's come from R_ORDER b. 
Maybe the problem is here ? 

Regards

[jvdb]

Hi,

Qlik messes up the truncate columns, as you can see in the screenshot and the SQL statement. I did try to copy the data in a new app, but then I get a simular error. Now, how to fix this?

Regards en help is much appreciated

[marcus_sommer]

Your screenshot and the shown sql-script are not the same - make sure that you don't mix up things.

Beside this your error isn't caused from Qlik else it's an error-message from the data-base.