Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
etrot
New Contributor

Upgraded to 12.2 and now application will not load on server

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:

2 Replies
Partner
Partner

Re: Upgraded to 12.2 and now application will not load on server

Are you 100% sure it is the same application? You are fetching different amount of lines in the two versions.

Do you have an prj folder in where you are opening application in the desktop version?

In which version did the script run without trouble? Did you upgrade from a QV 11.2 version or QV 12.2?
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

Re: Upgraded to 12.2 and now application will not load on server

Hi,

If you are facing the error: 2019-04-08 06:48:24 Error: Unexpected token: '(', expected one of: ',', ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', ...

means you have the BNF mode enabled that was introduced in QlikView 12.20. Kindly check: https://support.qlik.com/articles/000045823

Kind regards
Please, remember to mark the thread as solved once getting the correct answer