We use valence excel functions to generate spreadsheets:-
vvOut_SSOpenWorkbook(vvOut) and
vvOut_SSOpenWorksheet(vvOut: %addr(Col): %elem(Col))
addcells...
vvOut_SSCloseWorksheet(vvOut);
vvOut_SSCloseWorkbook(vvOut);
It works fine if you run it once but if you run it again (interactively) the call crashes with job log as follows:-
1200 - CALL PGM(PSR205D)
Directory created.
Ownership of object VVUTILITY in QTEMP type *USRSPC changed.
Object VV067329I type *DTAQ already exists in library VALENCE6P.
Function check. CPF9870 unmonitored by VVSRVPGM at statement 0000657600,
instruction X'0000'.
The call to SUBMITBATC ended in error (C G D F).
The call to SUBMITBATC ended in error (C G D F).
Checking the VALENCE6P library it shows two dtaq's as follows:-
VV067329I *DTAQ VALENCE6P 067329/PS/QPADEV001B
VV067329O *DTAQ VALENCE6P 067329/PS/QPADEV001B
It seems the data queues are being built but not removed on second run for the same job. Our temporary workaround is to submit the excel jobs for the moment.
Peter
vvOut_SSOpenWorkbook(vvOut) and
vvOut_SSOpenWorksheet(vvOut: %addr(Col): %elem(Col))
addcells...
vvOut_SSCloseWorksheet(vvOut);
vvOut_SSCloseWorkbook(vvOut);
It works fine if you run it once but if you run it again (interactively) the call crashes with job log as follows:-
1200 - CALL PGM(PSR205D)
Directory created.
Ownership of object VVUTILITY in QTEMP type *USRSPC changed.
Object VV067329I type *DTAQ already exists in library VALENCE6P.
Function check. CPF9870 unmonitored by VVSRVPGM at statement 0000657600,
instruction X'0000'.
The call to SUBMITBATC ended in error (C G D F).
The call to SUBMITBATC ended in error (C G D F).
Checking the VALENCE6P library it shows two dtaq's as follows:-
VV067329I *DTAQ VALENCE6P 067329/PS/QPADEV001B
VV067329O *DTAQ VALENCE6P 067329/PS/QPADEV001B
It seems the data queues are being built but not removed on second run for the same job. Our temporary workaround is to submit the excel jobs for the moment.
Peter