vscode-ibmi
vscode-ibmi copied to clipboard
codefori
Trying to opening a filer getting "Invalid time value" error
👉🏻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"
}
]
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
The output is empty...Please see the attached. I will check the issue 1813.
Please see the attached recording... https://github.com/codefori/vscode-ibmi/assets/74662197/bd423385-6bd6-4861-a04f-2f1b6e757937
@sureshramakrishnan
To populate the output, you need to select Code for IBM i in the dropdown.
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": ""
}
@sureshramakrishnan We need the entire output. Please share the other content you didn't before.
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": ""
}
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: @.***>
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
@sureshramakrishnan you can change your PF filter object type to *SRCPF
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: @.***>
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: @.***>
@sureshramakrishnan If you would like, I can help you troubleshoot the issue. We can connect over a zoom call.
@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")
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: @.***>
@sureshramakrishnan Please enter any findings / solution here in the issue - for others to learn about how this was resolved. 🙏
