USER LIBRARY LIST is not displayed correctly with error ‘Invalid time value’

[macogawa]

In v2.12.0 and above, the USER LIBRARY LIST may not be displayed correctly in some cases.

Initial display

When the library list is displayed correctly, clicking the + sign to add a library hides the list.

Log immediately after adding a library

/home/OGAWA: /QOpenSys/usr/bin/qsh
liblist -d QGPL QTEMP; liblist -a TELIB
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/OGAWA: /QOpenSys/usr/bin/qsh
liblist -d QGPL QTEMP; liblist -a QGPL; liblist -a QTEMP; liblist -a TELIB
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/OGAWA: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
select job_name, local_port from qsys2.netstat_job_info where cast(local_port_name as VarChar(14) CCSID 37) = 'is-debug-ile' fetch first row only
/home/OGAWA: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
/home/OGAWA: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"

        SELECT
          os.OBJNAME AS NAME,
          os.OBJTYPE AS TYPE,
          os.OBJATTRIBUTE AS ATTRIBUTE,
          OBJTEXT AS TEXT,
          os.IASP_NUMBER AS IASP_NUMBER,
          os.OBJSIZE AS SIZE,
          EXTRACT(EPOCH FROM (os.OBJCREATED)) * 1000 AS CREATED,
          EXTRACT(EPOCH FROM (os.CHANGE_TIMESTAMP)) * 1000 AS CHANGED,
          os.OBJOWNER AS OWNER,
          os.OBJDEFINER AS CREATED_BY
        from table( SYSTOOLS.SPLIT( INPUT_LIST => 'OGAWA,QGPL,QTEMP,TELIB', DELIMITER => ',' ) ) libs,
        table( QSYS2.OBJECT_STATISTICS( OBJECT_SCHEMA => 'QSYS', OBJTYPELIST => '*LIB', OBJECT_NAME => libs.ELEMENT ) ) os
      
{
    "code": 1,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n\n  0 RECORD(S) SELECTED.",
    "stderr": ""
}

{
    "code": 1,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n\n  0 RECORD(S) SELECTED.",
    "stderr": ""
}

{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n\nNAME       TYPE     ATTRIBUTE  TEXT                                               IASP_NUMBER  SIZE              CREATED              CHANGED              OWNER      CREATED_BY \n---------- -------- ---------- -------------------------------------------------- ------------ ----------------- -------------------- -------------------- ---------- -----------\nOGAWA      *LIB     PROD       -                                                             0            73728         1722962083000        1726146537000 OGAWA      OGAWA      \nQGPL       *LIB     PROD       GENERAL PURPOSE LIBRARY                                       0          7032832         1443641964000        1726581732000 QSYS       *IBM       \nQTEMP      *LIB     TEST       -                                                             0            65536         1726581702000        1726589007000 QSYS       QSYS       \nTELIB      *LIB     PROD       マスターライブラリー                                        0            90112         1696339908000        1725552728000 QDFTOWN    IKU        \n\n  4 RECORD(S) SELECTED.",
    "stderr": ""
}

---

In V2.11.0, it is added and displayed correctly.

Log immediately after addition when displayed correctly

/home/OGAWA: /QOpenSys/usr/bin/qsh
liblist -d QGPL QTEMP; liblist -a TELIB
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/OGAWA: /QOpenSys/usr/bin/qsh
liblist -d QGPL QTEMP; liblist -a QGPL; liblist -a QTEMP; liblist -a TELIB
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/OGAWA: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
select job_name, local_port from qsys2.netstat_job_info where cast(local_port_name as VarChar(14) CCSID 37) = 'is-debug-ile' fetch first row only
{
    "code": 1,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n\n  0 RECORD(S) SELECTED.",
    "stderr": ""
}

Environment:

• MacOS Sonoma 14.6.1
• Visual Studio Code version 1.93
• IBM i 7.3
• CumPTF C3257730

Please let us know if there are any checks to ensure that the USER LIBRARY LIST is displayed correctly in the latest version.