• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Excel extract cannot find template

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Excel extract cannot find template

    Valence Web Application Framework
    Version 3.2.20131204.0

    Operating System V7R1M0

    Using new excel functionality I am getting the following errors, which seem to indicate that the excel template cannot be accessed when attempting to create the extract:

    SS with zero bytes.jpg

    The extract uses its own template, the template name seems to be correctly passed, it only fails sometimes.

    Would appreciate any suggestions to fix this issue. I have a couple of dumps corresponding to the errors appearing in the Valence log which I can provide but could not attach because the file sizes exceed the forum limit. If you need any further information please let me know.

    TIA
    Tags: None
  • #2
    Must be something causing it to fail to see the IFS in certain cases. Perhaps an authority issue? If you can make it happen again, check for any pertinent messages in the job log of the CGI job referenced in the error log.

    Comment

    • #3
      Robert,

      There were no messages in the job log of the CGI job referenced in the error log. The security officer looked into journal QAUDJRN and found that even though everyone was authorised to the template file, not everybody was authorised to folder "portal" which was part of the path where the template file was located. Everyone was given authority to "portal" and the authority problem dissappeared.

      I still have an issue with the excel extract that I haven't been able to resolve. The extract is normally run from a front-end screen by pressing a button. The request goes to the server, the spreadsheet is created in the IFS and then it is emailed to the requester using VVMAIL.

      This process works fine most of the time from the front-end screen, but sometimes fails. When I try to run it from the "Test RPG Call" screen it always fails.

      Failure data is as follows:

      Code:
      Valence error log:
-----------------
Field    
VVSTAMP        2014-10-29-10.10.28.490000 
VVJOB          597022
VVALIAS        C801097
VVCALPGM       R0019
VVMSGTXT       Named Column DCRESC                         not found.
VVID           100
VVPGM          VVSRVPGM
VVMODULE       VVOUT
VVPROC         VVOUT_WRITESS
VVMSGID        vv9999
VVMSGSEV       0
VVSTMT   
VVHLPTXT        Column with name DCRESC                        not found provided statement/data structure
VVUSER         C801097
VVCALSTK       VVCALL[VVCALL]-->R0019[R0019]-->R0019[EXCELDOWNLOAD]-->R0019[GETPRICEVARDETAIL]-->VVSRVPGM{VVOUT}[VVOUT_SSDSROWS]-->VVSRVPGM{VVOUT}[WRITESS]
VVACTTAKEN 

RPG statement that fails:
------------------------
doneOK = vvOut_ssDSrows(vvOut:%addr(pvdetailsX):1:%addr(col):colsToDisplay);

Dump values:
-----------
DONEOK                INDICATOR(1)         '0'

VVOUT                 DS                                                                                                     
  APPLYPAGING         CHAR(1)              ' '                                                                         
  APPLYSORTERS        CHAR(1)              ' '                                                                          
  BINARY              CHAR(1)              ' '                                                                          
  BUFFER              CHAR(1)              ' '                                                                          
  CACHE               CHAR(1)              ' '                                                                          
  CACHEEXPIRE         TIMESTAMP(26)        '0001-01-01-00.00.00.000000'                                                      
  CACHEKEY            CHAR(30)             '                              '                                                  
  COLUMNDATA          CHAR(1)              ' '                                                                          
  CONTENTTYPE         CHAR(30)             '                              '                                                  
  CSVSEPARATOR        CHAR(1)              ' '                                                                          
  DOWNLOAD            CHAR(1)              'F'                                                                          
  EMBED               CHAR(4096)           '                                                                                '
  ENCODEUTF16         CHAR(1)              ' '                                                                          
  ERROR               CHAR(100)            'writeSS failed for SS file.Download failed                                      '
  FIELDDECIMALS       CHAR(1)              ' '                                                                          
  FIELDLENGTH         ZONED(3,0)           000.                                                                     
  FIELDNAME           CHAR(10)             '          '                                               
  FIELDTYPE           ZONED(1,0)           0.                                                                           
  FILE                CHAR(500)            '/tmp/20141029101025_597022_C801097_60_PV 2001 Form 300.xls                      '
  FILEHANDLE          ZONED(10,0)          0000000000.       
  FILL                CHAR(678)            '                                        
  FORMRESPONSE        CHAR(1)              ' '                                 
  JSONP               CHAR(1)              ' '                                 
  LIBRARY             CHAR(10)             '          '      
  LONGSQLNAMES        CHAR(1)              ' '                                 
  MAXRESULTS          ZONED(6,0)           000000.                   
  METADATA            CHAR(1)              ' '                                 
  NONULLCHILDREN      CHAR(1)              ' '                                 
  OBJECT              CHAR(10)             '          '      
  PREFIX              CHAR(5)              '     '                     
  RECORDFORMAT        CHAR(10)             '          '      
  RETURNLENGTH        ZONED(10,0)          0000000000.       
  REVERSE             CHAR(1)              ' '                                                       
  ROOTNAME            CHAR(30)             '                              '                               
  SKIPCOUNTCALC       CHAR(1)              ' '                                                       
  SSFILTERROW         ZONED(7,0)           0000000.                                      
  SSOMITHEADING       CHAR(1)              '1'                                                       
  SSROWS              INT(10)              0                                                   
  SSSHEETNAME         CHAR(30)             'PV 2001 Form 300              '                               
  SSTEMPLATE          CHAR(200)            '/ashdev/portal/PriceVarDisp/PriceVarDisp.xls                  
  STARTFROM           ZONED(9,0)           000000000.                                
  SUCCESS             CHAR(1)              ' '                                                       
  TOTALPROPERTY       CHAR(20)             '                    '
  TREATASCONFIG       CHAR(1)              ' '              
  TREEMISC1OVERRIDE   CHAR(20)             '                    '
  USEASENSITIVECURSOR CHAR(1)              ' '                      

PVDETAILSX            DS                                                 
  CPPRUM              CHAR(2)              'E '                   
  DCANVL              PACKED(9,0)          000000060.       
  DCBRKQ              PACKED(5,0)          00001.               
  DCCBPR              PACKED(15,6)         000000030.660000              
  DCCDIS              PACKED(15,6)         000000000.000000              
  DCCNPR              PACKED(15,6)         000000030.660000              
  DCCOMM              CHAR(3000)           'One-off over 3000            
  DCCPCK              CHAR(10)             '          '     
  DCCPRD              CHAR(15)             '               '                       
  DCCSUP              CHAR(3)              '   '                          
  DCDIFF              CHAR(4)              'SAME'                       
  DCERR               CHAR(100)            '                              
  DCGP                PACKED(6,3)          000.000             
  DCNDIS              PACKED(15,6)         000000030.660000               
  DCNPRC              PACKED(15,6)         000000000.000000               
  DCPVNO              PACKED(7,0)          0000300.            
  DCRESC              CHAR(15)             'VBP1379        '              
  DCSPRC              PACKED(7,2)          00000.00            
  DCSPRCD             CHAR(10)             '          '     
  DC1OFF              CHAR(3)              'Yes'                 
  DVCSPN              CHAR(30)             '                              
  LSDLST              CHAR(70)             '                              
  RMDESC              CHAR(30)             'BRAKE PAD 1379                '
  TMACNO              PACKED(8,0)          00029281.          
  TMAPDT              TIMESTAMP(26)        '2014-05-20-16.01.33.590000'    
  TMAPID              CHAR(10)             'C893162   '     
  TMAPNM              CHAR(50)             'Glen Clarke                    
  TMRAIS              TIMESTAMP(26)        '2014-05-20-15.40.19.993000'    
  TMRQD               TIMESTAMP(26)        '0001-01-01-00.00.00.000000'    
  TMRQID              CHAR(10)             'C893162   '     
  TMRQNM              CHAR(50)             'Glen Clarke                    
  TMSTAT              CHAR(10)             'REJECTED  '     

COL DS DIM(16)
(1)
COLWIDTH              PACKED(5,0)          00070. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Resource '
HSTYLEID              CHAR(15)             ' '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCRESC '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(2)
COLWIDTH              PACKED(5,0)          00170. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Resource Description '
HSTYLEID              CHAR(15)             ' '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'RMDESC '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(3)
COLWIDTH              PACKED(5,0)          00020. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'U/M '
HSTYLEID              CHAR(15)             ' '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'CPPRUM '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(4)
COLWIDTH              PACKED(5,0)          00025. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'One Off '
HSTYLEID              CHAR(15)             ' '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DC1OFF '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(5)
COLWIDTH              PACKED(5,0)          00050. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Break Qty '
HSTYLEID              CHAR(15)             'charHR '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCBRKQ '
STYLEID               CHAR(15)             'num0 '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(6)
COLWIDTH              PACKED(5,0)          00060. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Ann Vol or One Off Qty '
HSTYLEID              CHAR(15)             'charHR '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCANVL '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(7)
COLWIDTH              PACKED(5,0)          00050. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Base Price '
HSTYLEID              CHAR(15)             'charHR '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCCBPR '
STYLEID               CHAR(15)             'num4 '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(8)
COLWIDTH              PACKED(5,0)          00055. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Cur Disc (Rounded) '
HSTYLEID              CHAR(15)             'charHR '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCCDIS '
STYLEID               CHAR(15)             'num2 '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(9)
COLWIDTH              PACKED(5,0)          00055. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Cur Price (Rounded) '
HSTYLEID              CHAR(15)             'charHR '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCCNPR '
STYLEID               CHAR(15)             'num2 '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(10)
COLWIDTH              PACKED(5,0)          00045. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'New Disc '
HSTYLEID              CHAR(15)             'charHR '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCNDIS '
STYLEID               CHAR(15)             'num4 '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(11)
COLWIDTH              PACKED(5,0)          00050. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'New Price '
HSTYLEID              CHAR(15)             'charHR '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCNPRC '
STYLEID               CHAR(15)             'num4 '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(12)
COLWIDTH              PACKED(5,0)          00060. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Supplier Name '
HSTYLEID              CHAR(15)             ' '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DVCSPN '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(13)
COLWIDTH              PACKED(5,0)          00055. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Supplier Product '
HSTYLEID              CHAR(15)             ' '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCCPRD '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(14)
COLWIDTH              PACKED(5,0)          00045. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Supplier Pack '
HSTYLEID              CHAR(15)             ' '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCCPCK '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(15)
COLWIDTH              PACKED(5,0)          00050. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             'Supplier Price '
HSTYLEID              CHAR(15)             'charHR '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             'DCSPRCD '
STYLEID               CHAR(15)             'charR '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 
(16)
COLWIDTH              PACKED(5,0)          00000. 
FILL                  CHAR(339)            ' '
FORMULA               CHAR(256)            ' '
GROUPBY               CHAR(1)              ' ' 
HEADING               CHAR(80)             ' '
HSTYLEID              CHAR(15)             ' '
OMIT                  CHAR(1)              ' ' 
PREFIX                CHAR(5)              ' ' 
SQLNAME               CHAR(30)             ' '
STYLEID               CHAR(15)             ' '
SUFFIX                CHAR(20)             ' '
TOTAL                 CHAR(1)              ' ' 

COLSTODISPLAY         PACKED(2,0)          15.
      It looks like the "vvOut_ssDsrows" procedure somehow loses the pointer to the data.

      I haven't been able to find what is wrong and I would appreciate any help you can provide.

      TIA
      Last edited by gzambrano; 10-28-2014, 10:58 PM.

      Comment

      • #4
        Glad to hear you got the authority issue resolved. As for your other issue, nothing stands out to me in the code that would cause it to fail. Would it be possible to send us a save file of the RPG source (and any file objects necessary to compile it) so we can try to replicate the problem on our end?

        Comment

        • #5
          Hi Robert,
          I have the save file ready. How do I go about sending it to you?

          Comment

          • #6
            Go ahead and email it to support (at cnxcorp.com) and we'll have a look at it in the morning.

            Comment

            Previous template Next
            Working...
            X