Announcement

Collapse
No announcement yet.

Valence 5.2 Nitro Query Grid Excel Download

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Valence 5.2 Nitro Query Grid Excel Download

    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!

  • #2
    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

    Comment


    • #3
      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.

      Comment


      • #4
        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]

        Comment


        • #5
          Zach,

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

          Thanks

          Comment


          • #6
            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.

            Comment

            Working...
            X