Valence 5.2 Nitro Query Grid Excel Download

[Zach]

Hello,

We are having issues with the download functionality from a Nitro Query grid to an Excel file in Valence 5.2. We can download to a PDF just fine but the Excel file download doesn't work, any suggestions?

Thanks!

[robert.swanson]

Hi Zach,

Is this an issue across all your NAB apps of just one specific app? i.e., if you launch the Warehouse Dashboard example app, are you able to download the Excel file from that app's grid?

If not, do you see any exception messages in the Errors app?

-Rob

[Zach]

So far it has been an issue for all of our Nitro Query Grid apps in 5.2. The Warehouse Dashboard example app DOES download successfully to Excel.

[Zach]

It looks like there is an error in the errors app after I try to download to Excel. Below is what it shows.

Error ID 262

REMOVE

Program:	VVSRVPGM	Statement:
Module:	VVOUT	Message ID:	VV00007

Procedure:
VVOUT_SSSQLRows
Message Text:
SQL statement prep failure (SQLSTT=42601)
Help Text:
The value of the statement is: SELECT TRIM(F2.LTRMO1) || '/' || F2.LTRDY1 || '/' || F2.LTRYR1 AS LASTDATE, F1.PLAN AS PLAN2, F1.PLAN AS PLAN3, F1.PLAN AS PLAN4, F1.CERT AS F1_CERT, F1.PLAN AS F1_PLAN, F1.AMTINS AS F1_AMTINS, F1.RGYEAR AS F1_RGYEAR, F1.RGMTH AS F1_RGMTH, F1.REGAGE AS F1_REGAGE, F1.CASHV1 AS F1_CASHV1, F1.NETCV1 AS F1_NETCV1, F1.LNBAL1 AS F1_LNBAL1, F1.CRTTYP AS F1_CRTTYP, F2.PLNPRM AS F2_PLNPRM, F2.LTRYR1 AS F2_LTRYR1, F2.LTRMO1 AS F2_LTRMO1, F2.LTRDY1 AS F2_LTRDY1, F2.MODE AS F2_MODE, F2.MONPX AS F2_MONPX, F2.QTRPX AS F2_QTRPX, F2.SANPX AS F2_SANPX, F2.ANNPX AS F2_ANNPX, F3.SUBSTD AS F3_SUBSTD, F3.RENREC AS F3_RENREC, RRN(F1) AS RRN1, RRN(F2) AS RRN2, RRN(F3) AS RRN3 FROM WORK/"SSA220P1" AS F1 Inner Join MAST/"INS036P1" AS F2 ON F2.CERT = F1.CERT Inner Join MAST/"INS020P1" AS F3 ON F3.CERT = F1.CERT WHERE ( F1.CRTTYP = 'UL') order by []
Valence Login ID:
DP7
IBM i User:
DP7
Timestamp:
2020-02-13-14.02.37.082000
Job Number:
434699
Calling Program:
VVSRVPGM
Call Stack:
VVCALL[VVCALL]-->VVDATASRC[VVDATASRC]-->VVDATASRC[GETDATAEXCEL]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOSS]-->VVSRVPGM{VVOUT}[VVOUT_SSSQLROWS]

[Johnny Major]

Zach,

Can you email support@cnxcorp.com I would like to get on an online meeting to look into this?

Thanks

[robert.swanson]

Looks like a syntax error in the ORDER BY clause. Question is: what kind of configuration do you have there that would cause that to happen? An online meeting would be helpful.