i'm trying some of the examples in the new v5.2
when launching the IBM i dashboard, i receive an error
seems like your using some aliases that are not found on my system..
(i'm on v7.2)
Server Error
An unexpected error occurred on the server. See Valence error log for further details.
Description: SQL statement prep failure (SQLSTT=42704) - SQL0204 - JOB_QUEUE_INFO in QSYS2 type *FILE is niet gevonden.
Error Log ID: 13
Procedure:
VVOUT_EXECSQLTOJSON
Message Text:
SQL statement prep failure (SQLSTT=42704) - SQL0204 - JOB_QUEUE_INFO in QSYS2 type *FILE is niet gevonden.
Help Text:
The value of the statement is: SELECT jobq , jobq_lib , status , jobs , max_jobs , act_jobs , held_jobs , rls_jobs , sched_jobs , text FROM qsys2.job_queue_info
Valence Login ID:
TCO
IBM i User:
TCO
Timestamp:
2018-06-18-11.09.54.539000
Job Number:
106566
Calling Program:
VVSRVPGM
Call Stack:
VVCALL[VVCALL]-->VVDATASRC[VVDATASRC]-->VVDATASRC[GETDATA]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOJSON]
when launching the IBM i dashboard, i receive an error
seems like your using some aliases that are not found on my system..
(i'm on v7.2)
Server Error
An unexpected error occurred on the server. See Valence error log for further details.
Description: SQL statement prep failure (SQLSTT=42704) - SQL0204 - JOB_QUEUE_INFO in QSYS2 type *FILE is niet gevonden.
Error Log ID: 13
Error ID 13 | REMOVE |
Program: | VVSRVPGM | Statement: | |
Module: | VVOUT | Message ID: | VV00007 |
VVOUT_EXECSQLTOJSON
Message Text:
SQL statement prep failure (SQLSTT=42704) - SQL0204 - JOB_QUEUE_INFO in QSYS2 type *FILE is niet gevonden.
Help Text:
The value of the statement is: SELECT jobq , jobq_lib , status , jobs , max_jobs , act_jobs , held_jobs , rls_jobs , sched_jobs , text FROM qsys2.job_queue_info
Valence Login ID:
TCO
IBM i User:
TCO
Timestamp:
2018-06-18-11.09.54.539000
Job Number:
106566
Calling Program:
VVSRVPGM
Call Stack:
VVCALL[VVCALL]-->VVDATASRC[VVDATASRC]-->VVDATASRC[GETDATA]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOJSON]
Comment