Trying to opening a filer getting "Invalid time value" error #2050

sureshramakrishnan · 2024-05-13T20:55:17Z

👉🏻I defined a simple filter for source in a library in protected with object explorer as this is production code/source...when I click to open the filter to see the list of source. I am getting an "Invalid time value"

⚠️ REMOVE THIS LINE AND ANY SENSITIVE INFORMATION BELOW! ⚠️

Context	Version
Code for IBM i version	2.10.1
Visual Studio Code version	1.89.1
Operating System	win32_x64

Active extensions

COBOL (cobol): 10.4.11
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.5.0
Db2 for IBM i (vscode-db2i): 1.0.0
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.17.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
IBM i Debug (ibmidebug): 1.0.0
JSON Language Features (json-language-features): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
Node Debug Auto-attach (debug-auto-launch): 1.0.0
TODO Highlight (vscode-todo-highlight): 1.0.5
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0

Remote system

Setting	Value
IBM i OS	V7R3M0
Tech Refresh	13
CCSID Origin	system
Runtime CCSID	65535
Default CCSID	37
SQL	Enabled
Source dates	Disabled

Enabled features

/usr/bin	/QOpenSys/pkgs/bin	/QSYS.lib/ILEDITOR.lib		/QSYS.LIB	/QIBM/ProdData/IBMiDebugService/bin
attr	bash	GETNEWLIBL.PGM	ILEDITOR.GETMBRINFO	QZDFMDB2.PGM	startDebugService.sh
iconv
ls
setccsid
tar

Shell env

Variants

{
  "american": "#@$",
  "local": "#@$"
}

Errors

[
  {
    "command": "export BUILDLIB=\"QGPL\" && export CURLIB=\"QGPL\" && export USERNAME=\"sramakrish\" && export HOST=\"192.168.9.10\" && export HOME=\"/home/SRAMAKRISH\" && export WORKDIR=\"/home/SRAMAKRISH\" && export LIBLS=\"ESEND DBU11 IPTSUTL IPTSPGM SEQUEL SEQUELWI QTEMP QGPL\" && env",
    "code": 1,
    "stderr": "bsh: BUILDLIB=QGPL: is not an identifier",
    "cwd": "/home/SRAMAKRISH"
  },
  {
    "command": "export BUILDLIB=\"QGPL\" && export CURLIB=\"QGPL\" && export USERNAME=\"sramakrish\" && export HOST=\"192.168.9.10\" && export HOME=\"/home/SRAMAKRISH\" && export WORKDIR=\"/home/SRAMAKRISH\" && export LIBLS=\"ESEND DBU11 IPTSUTL IPTSPGM SEQUEL SEQUELWI QTEMP QGPL\" && env",
    "code": 1,
    "stderr": "bsh: BUILDLIB=QGPL: is not an identifier",
    "cwd": "/home/SRAMAKRISH"
  },
  {
    "command": "export BUILDLIB=\"QGPL\" && export CURLIB=\"QGPL\" && export USERNAME=\"sramakrish\" && export HOST=\"192.168.9.10\" && export HOME=\"/home/SRAMAKRISH\" && export WORKDIR=\"/home/SRAMAKRISH\" && export LIBLS=\"ESEND DBU11 IPTSUTL IPTSPGM SEQUEL SEQUELWI QTEMP QGPL\" && env",
    "code": 1,
    "stderr": "bsh: BUILDLIB=QGPL: is not an identifier",
    "cwd": "/home/SRAMAKRISH"
  }
]

The text was updated successfully, but these errors were encountered:

worksofliam · 2024-05-13T21:01:47Z

Please share the contents of your Code for IBM i output channel after you see the error.

I believe this might be a possible dupe of #1813

sureshramakrishnan · 2024-05-13T22:03:14Z

The output is empty...Please see the attached. I will check the issue 1813.

sureshramakrishnan · 2024-05-13T22:24:50Z

Please see the attached recording...
https://github.com/codefori/vscode-ibmi/assets/74662197/bd423385-6bd6-4861-a04f-2f1b6e757937

SJLennon · 2024-05-14T00:18:11Z

@sureshramakrishnan
To populate the output, you need to select Code for IBM i in the dropdown.

sureshramakrishnan · 2024-05-14T03:23:05Z

Thanks for the note...Please see the below from OUTPUT...

/home/SRAMAKRISH: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
Call QSYS2.QCMDEXC('CHGJOB CCSID(37)');
select 
  t.SYSTEM_TABLE_NAME as NAME,
  '*FILE'             as TYPE,
  'PF'                as ATTRIBUTE,
  t.TABLE_TEXT        as TEXT,
  1                   as IS_SOURCE,
  t.ROW_LENGTH        as SOURCE_LENGTH
from QSYS2.SYSTABLES as t
where t.table_schema = 'IPTSPCH191' and t.file_type = 'S';
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n\nNAME       TYPE  ATTRIBUTE  TEXT                                               IS_SOURCE   SOURCE_LENGTH \n---------- ----- ---------- -------------------------------------------------- ----------- --------------\nQCLSRC     *FILE PF         19.1 CLP/CLLE Source, �Island Pacific                        1             92\nQCMDSRC    *FILE PF         19.1 CMD Source, �Island Pacific                             1             92\nQSRVSRC    *FILE PF         19.1 SRV Source, �Island Pacific                             1             92\nQSQLSRC    *FILE PF         19.1 SQL Source, �Island Pacific                             1             92\nQRPGSRC    *FILE PF         19.1 RPG Source, �Island Pacific                             1             92\nQCSRC      *FILE PF         19.1 C Source, �Island Pacific                               1            112\nQDDSSRC    *FILE PF         19.1 DDS Source, �Island Pacific                             1             92\nQFMTSRC    *FILE PF         19.1 FMT Source, �Island Pacific                             1             92\nQPNLSRC    *FILE PF         19.1 PNLGRP Source, �Island Pacific                          1            112\nQRPGLESRC  *FILE PF         19.1 RPGLE Source, �Island Pacific                           1            112\n\n 10 RECORD(S) SELECTED.\n\nDB2>",
    "stderr": ""
}

worksofliam · 2024-05-14T12:49:02Z

@sureshramakrishnan We need the entire output. Please share the other content you didn't before.

sureshramakrishnan · 2024-05-14T14:25:47Z

Hi Please see all output produced since I started the session today morning.

.: echo "This should be the only text!"
{
    "code": 0,
    "signal": null,
    "stdout": "This should be the only text!",
    "stderr": ""
}

.: echo $HOME && cd && test -w $HOME
{
    "code": 0,
    "signal": null,
    "stdout": "/home/SRAMAKRISH",
    "stderr": ""
}

/home/SRAMAKRISH: /QOpenSys/usr/bin/qsh
liblist
{
    "code": 0,
    "signal": null,
    "stdout": "RBTSYSLIB   SYS\nIPSYSMOD    SYS\nQSYS        SYS\nQSYS2       SYS\nQUSRSYS     SYS\nIP400       SYS\nIPSAVE      SYS\nIPSS38      SYS\nNETSRVCMD   SYS\nQHLPSYS     SYS\nQSHELL      PRD\nQGPL        USR\nQTEMP       USR\nSEQUELWI    USR\nSEQUEL      USR\nIPTSPGM     USR\nIPTSUTL     USR\nDBU11       USR\nESEND       USR",
    "stderr": ""
}

/home/SRAMAKRISH: /QOpenSys/usr/bin/qsh
system  "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": "CPF2111:  Library ILEDITOR already exists.\nCPC2206:  Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/SRAMAKRISH: [ -d "/tmp" ]
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/SRAMAKRISH: echo $SHELL
{
    "code": 0,
    "signal": null,
    "stdout": "/QOpenSys/usr/bin/bsh",
    "stderr": ""
}

/home/SRAMAKRISH: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
Call QSYS2.QCMDEXC('CHGJOB CCSID(37)');
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/SRAMAKRISH: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
Call QSYS2.QCMDEXC('CHGJOB CCSID(37)');
select OS_VERSION concat '.' concat OS_RELEASE as VERSION from sysibmadm.env_sys_info
/home/SRAMAKRISH: test -r /QIBM/ProdData/IBMiDebugService/package.json
/home/SRAMAKRISH: test -r /QIBM/ProdData/IBMiDebugService/package.json
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/SRAMAKRISH: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
Call QSYS2.QCMDEXC('CHGJOB CCSID(37)');
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": "",
    "stderr": ""
}

{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n  ?>\n\nVERSION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n7.3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              \n\n  1 RECORD(S) SELECTED.",
    "stderr": ""
}

/home/SRAMAKRISH: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
Call QSYS2.QCMDEXC('CHGJOB CCSID(37)');
select max(ptf_group_level) as HIGHEST_DB2_PTF_GROUP_LEVEL from qsys2.group_ptf_info where PTF_GROUP_DESCRIPTION like 'DB2 FOR IBM I%' and ptf_group_status = 'INSTALLED';
/home/SRAMAKRISH: test -f /QIBM/UserData/IBMiDebugService/certs/debug_service.pfx
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/SRAMAKRISH: test -f /QIBM/UserData/IBMiDebugService/certs/debug_service.crt
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/SRAMAKRISH: test -f /QIBM/UserData/IBMiDebugService/.code4i.debug
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n\nHIGHEST_DB2_PTF_GROUP_LEVEL \n----------------------------\n                          32\n\n  1 RECORD(S) SELECTED.\n\nDB2>",
    "stderr": ""
}

/home/SRAMAKRISH: ls $HOME/.vscode/codeforiserver-1.4.9.jar
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/SRAMAKRISH: test -f /QIBM/ProdData/IBMiDebugService/bin/certs/debug_service.pfx
{
    "code": 0,
    "signal": null,
    "stdout": "/home/SRAMAKRISH/.vscode/codeforiserver-1.4.9.jar",
    "stderr": ""
}

/home/SRAMAKRISH: echo $SHELL
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

{
    "code": 0,
    "signal": null,
    "stdout": "/QOpenSys/usr/bin/bsh",
    "stderr": ""
}

/home/SRAMAKRISH: /QOpenSys/usr/bin/qsh
system  "CHKOBJ OBJ(QSYS/IPTSPCH191) OBJTYPE(*LIB) AUT(*NONE)"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": "CPC2206:  Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/SRAMAKRISH: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
Call QSYS2.QCMDEXC('CHGJOB CCSID(37)');
select 
  t.SYSTEM_TABLE_NAME as NAME,
  '*FILE'             as TYPE,
  'PF'                as ATTRIBUTE,
  t.TABLE_TEXT        as TEXT,
  1                   as IS_SOURCE,
  t.ROW_LENGTH        as SOURCE_LENGTH
from QSYS2.SYSTABLES as t
where t.table_schema = 'IPTSPCH191' and t.file_type = 'S';
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n\nNAME       TYPE  ATTRIBUTE  TEXT                                               IS_SOURCE   SOURCE_LENGTH \n---------- ----- ---------- -------------------------------------------------- ----------- --------------\nQCLSRC     *FILE PF         19.1 CLP/CLLE Source, �Island Pacific                        1             92\nQCMDSRC    *FILE PF         19.1 CMD Source, �Island Pacific                             1             92\nQSRVSRC    *FILE PF         19.1 SRV Source, �Island Pacific                             1             92\nQSQLSRC    *FILE PF         19.1 SQL Source, �Island Pacific                             1             92\nQRPGSRC    *FILE PF         19.1 RPG Source, �Island Pacific                             1             92\nQCSRC      *FILE PF         19.1 C Source, �Island Pacific                               1            112\nQDDSSRC    *FILE PF         19.1 DDS Source, �Island Pacific                             1             92\nQFMTSRC    *FILE PF         19.1 FMT Source, �Island Pacific                             1             92\nQPNLSRC    *FILE PF         19.1 PNLGRP Source, �Island Pacific                          1            112\nQRPGLESRC  *FILE PF         19.1 RPGLE Source, �Island Pacific                           1            112\n\n 10 RECORD(S) SELECTED.\n\nDB2>",
    "stderr": ""
}

{
    "code": 1,
    "signal": null,
    "stdout": "DB2>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n\n  0 RECORD(S) SELECTED.",
    "stderr": ""
}

{
    "code": 1,
    "signal": null,
    "stdout": "DB2>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n\n  0 RECORD(S) SELECTED.",
    "stderr": ""
}

sureshramakrishnan · 2024-05-15T16:37:30Z

Hi,This partition is V7R3 and I do see CHANGE_TIMESTAMP in QSYS2.OBJECT_STATISTICS On Wednesday, May 15, 2024 at 02:38:43 AM PDT, Augusto Dunensis ***@***.***> wrote: I also face this issue on V7R2M0. The problem is occurring since 2.10.1 and is connected with change in api/IBMiContent.ts Since, up to R2, QSYS2.OBJECT_STATISTICS has no column named CHANGE_TIMESTAMP, the sql query returns an error. The other problem is - when date is incorrect, there is also no escaping, so it also leads to an error. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***>

sureshramakrishnan · 2024-05-16T20:28:36Z

Object browser bring list when type is *ALL. Setting ALL and name as Q get the list of Source file but they are showing up as PF's

worksofliam · 2024-05-22T13:33:31Z

@sureshramakrishnan you can change your PF filter object type to *SRCPF

sureshramakrishnan · 2024-05-23T17:25:57Z

I have set it as *SRCPF please see the screen print On Wednesday, May 22, 2024 at 06:33:54 AM PDT, LJ ***@***.***> wrote: @sureshramakrishnan you can change your PF filter object type to *SRCPF — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***>

onlysumitg · 2024-05-23T19:34:43Z

Try removing any special character from the source file description.

sureshramakrishnan · 2024-05-24T04:37:30Z

Hi I have tried the same but still getting errors... On Thursday, May 23, 2024 at 12:35:06 PM PDT, Sumit goyal ***@***.***> wrote: Try removing any special character from the source file description. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***>

onlysumitg · 2024-05-24T15:02:55Z

@sureshramakrishnan
If you would like, I can help you troubleshoot the issue. We can connect over a zoom call.

SJLennon · 2024-05-24T15:36:44Z

@sureshramakrishnan

For what it's worth, just in case any of this helps...

You said:

I have set it as *SRCPF please see the screen print

Your screen shot shows differently:

You might want to change the "Object types" to *SRCPF.

Of course, if the screen shot was wrong and you have *SRCPF set, then you might want to look at the CCSID section in the documentation, since it does seem like there are some "odd" characters showing up:

And actually, from reading all the comments, and the issue title, I'm not sure if you now have one issue ("Invalid time error") or also a second issue, ("list of Source file but they are showing up as PF's")

sureshramakrishnan · 2024-05-24T17:08:49Z

Hi Sumit, Yes that will be helpful. I am in Pacific Time zone but can extend to try and work with you. Today I can meet between 12 to 2.00 PM PST. I can also meet from 6.00 PM till 10 PM PST. If this does not work can you please provide couple of time slots either this week or next week I will try and make it work. Thanks for your help Regards,Suresh On Friday, May 24, 2024 at 08:03:19 AM PDT, Sumit goyal ***@***.***> wrote: @sureshramakrishnan If you would like, I can help you troubleshoot the issue. We can connect over a zoom call. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***>

chrjorgensen · 2024-05-29T07:23:21Z

@sureshramakrishnan Please enter any findings / solution here in the issue - for others to learn about how this was resolved. 🙏

worksofliam added the info-needed More information is requied from the issuer label May 13, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Trying to opening a filer getting "Invalid time value" error #2050

Trying to opening a filer getting "Invalid time value" error #2050

sureshramakrishnan commented May 13, 2024

Enabled features

worksofliam commented May 13, 2024

sureshramakrishnan commented May 13, 2024

sureshramakrishnan commented May 13, 2024

SJLennon commented May 14, 2024

sureshramakrishnan commented May 14, 2024 •

edited by worksofliam

Loading

worksofliam commented May 14, 2024

sureshramakrishnan commented May 14, 2024 •

edited by worksofliam

Loading

sureshramakrishnan commented May 15, 2024 via email

sureshramakrishnan commented May 16, 2024

worksofliam commented May 22, 2024

sureshramakrishnan commented May 23, 2024 via email

onlysumitg commented May 23, 2024

sureshramakrishnan commented May 24, 2024 via email

onlysumitg commented May 24, 2024

SJLennon commented May 24, 2024

sureshramakrishnan commented May 24, 2024 via email

chrjorgensen commented May 29, 2024

Trying to opening a filer getting "Invalid time value" error #2050

Trying to opening a filer getting "Invalid time value" error #2050

Comments

sureshramakrishnan commented May 13, 2024

Enabled features

worksofliam commented May 13, 2024

sureshramakrishnan commented May 13, 2024

sureshramakrishnan commented May 13, 2024

SJLennon commented May 14, 2024

sureshramakrishnan commented May 14, 2024 • edited by worksofliam Loading

worksofliam commented May 14, 2024

sureshramakrishnan commented May 14, 2024 • edited by worksofliam Loading

sureshramakrishnan commented May 15, 2024 via email

sureshramakrishnan commented May 16, 2024

worksofliam commented May 22, 2024

sureshramakrishnan commented May 23, 2024 via email

onlysumitg commented May 23, 2024

sureshramakrishnan commented May 24, 2024 via email

onlysumitg commented May 24, 2024

SJLennon commented May 24, 2024

sureshramakrishnan commented May 24, 2024 via email

chrjorgensen commented May 29, 2024

sureshramakrishnan commented May 14, 2024 •

edited by worksofliam

Loading

sureshramakrishnan commented May 14, 2024 •

edited by worksofliam

Loading