Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
We recently upgraded to 12.2 SR6 on our server and one of our major dashboards fails to load. It loads just fine on the desktop version, but has not been able to finish on the server since the upgrade. Our desktop versions are also 12.2 SR6. Is this a bug? How should I go about troubleshooting if it runs in desktop?
Thanks!
Server Log
-04-08 06:43:37 0385 Concatenate(TableX)
2019-04-08 06:43:37 0386 LOAD
2019-04-08 06:43:37 0387 lower(Item) as Item,
2019-04-08 06:43:37 0388 upper(ADICID) as ADICID,
2019-04-08 06:43:37 0389 Date#(Date,'MMM DD, YYYY') as Date,
2019-04-08 06:43:37 0390
2019-04-08 06:43:37 0391 [Company Name],
2019-04-08 06:43:37 0392
2019-04-08 06:43:37 0393 [GeoSegmentation Countries],
2019-04-08 06:43:37 0394
2019-04-08 06:43:37 0395 Company_annual_sales,
2019-04-08 06:43:37 0396 Demandbase_Industry,
2019-04-08 06:43:37 0397 Demandbase_SubIndustry,
2019-04-08 06:43:37 0398 employee_count as Company_employee_size,
2019-04-08 06:43:37 0399 Worldhq_company_name,
2019-04-08 06:43:37 0400
2019-04-08 06:43:37 0401 Visitor_ID,
2019-04-08 06:43:37 0402 [Email (evar45)],
2019-04-08 06:43:37 0403 [Page Views],
2019-04-08 06:43:37 0404 type_views,
2019-04-08 06:43:37 0405 'BigFile' as factType
2019-04-08 06:43:37 0406
2019-04-08 06:43:37 0407 FROM [.\New_SAS_adobeQVDs\bigfile.qvd](qvd)
2019-04-08 06:43:37 0408 where Date >=42833
2019-04-08 06:48:24 15 fields found: Item, ADICID, Date, Company Name, GeoSegmentation Countries, Company_annual_sales, Demandbase_Industry, Demandbase_SubIndustry, Company_employee_size, Worldhq_company_name, Visitor_ID, Email (evar45), Page Views, type_views, factType,
2019-04-08 06:48:24 87,800,409 lines fetched
2019-04-08 06:48:24 Error: Unexpected token: '(', expected one of: ',', ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', ...
2019-04-08 06:48:25 Execution Failed
2019-04-08 06:48:25 Execution finished.
Desktop Log:
2019-04-04 14:45:48 0385 Concatenate(TableX)
2019-04-04 14:45:48 0386 LOAD
2019-04-04 14:45:48 0387 lower(Item) as Item,
2019-04-04 14:45:48 0388 upper(ADICID) as ADICID,
2019-04-04 14:45:48 0389 Date#(Date,'MMM DD, YYYY') as Date,
2019-04-04 14:45:48 0390
2019-04-04 14:45:48 0391 [Company Name],
2019-04-04 14:45:48 0392
2019-04-04 14:45:48 0393 [GeoSegmentation Countries],
2019-04-04 14:45:48 0394
2019-04-04 14:45:48 0395 Company_annual_sales,
2019-04-04 14:45:48 0396 Demandbase_Industry,
2019-04-04 14:45:48 0397 Demandbase_SubIndustry,
2019-04-04 14:45:48 0398 employee_count as Company_employee_size,
2019-04-04 14:45:48 0399 Worldhq_company_name,
2019-04-04 14:45:48 0400
2019-04-04 14:45:48 0401 Visitor_ID,
2019-04-04 14:45:48 0402 [Email (evar45)],
2019-04-04 14:45:48 0403 [Page Views],
2019-04-04 14:45:48 0404 type_views,
2019-04-04 14:45:48 0405 'BigFile' as factType
2019-04-04 14:45:48 0406
2019-04-04 14:45:48 0407 FROM [.\New_SAS_adobeQVDs\bigfile.qvd](qvd)
2019-04-04 14:45:48 0408 where Date >=42829
2019-04-04 14:51:08 15 fields found: Item, ADICID, Date, Company Name, GeoSegmentation Countries, Company_annual_sales, Demandbase_Industry, Demandbase_SubIndustry, Company_employee_size, Worldhq_company_name, Visitor_ID, Email (evar45), Page Views, type_views, factType,
2019-04-04 14:51:08 87,900,674 lines fetched
2019-04-04 14:51:08 0411 reverse: