vscode-ibmi icon indicating copy to clipboard operation
vscode-ibmi copied to clipboard

Filters returning nothing in object browser

Open RobMKH opened this issue 2 years ago • 13 comments

Hi

Using 2.6.0 to 2.6.5 results in not being able to see source file members in the filters - they try to expand and I see nothing. Rolled back to 2.5 and it works fine (hence why below it says we are using 2.5.0) - hope that helps isolate when the issue started.

I have enableSQL off in both versions.

OUTPUT from 2.5:

/home/HORTONR: system "DSPFD FILE(HORTONR/*ALL) TYPE(*ATR) FILEATR(*PF) OUTPUT(*OUTFILE) OUTFILE(ILEDITOR/O_5fAtfa9J)"
{
    "code": 0,
    "signal": null,
    "stdout": "CPF9861: Output file O_5FATFA9J created in library ILEDITOR.\nCPF9862: Member O_5FATFA9J added to output file O_5FATFA9J in library ILEDITOR.\nCPF3030: 41 records added to member O_5FATFA9J in file O_5FATFA9J in ILEDITOR.",
    "stderr": ""
}

/home/HORTONR: system "QSYS/CPYTOIMPF FROMFILE(ILEDITOR/O_5fAtfa9J O_5fAtfa9J) TOSTMF('/tmp/vscodetemp-O_Ri3XMcxl') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM(',') DECPNT(*PERIOD)"
{
    "code": 0,
    "signal": null,
    "stdout": "CPC2958: All records copied from file O_5FATFA9J in ILEDITOR.",
    "stderr": ""
}

OUTPUT from 2.6.5

/home/HORTONR: /QOpenSys/usr/bin/qsh
system  "CHKOBJ OBJ(QSYS/HORTONR) OBJTYPE(*LIB) AUT()"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/HORTONR: /QOpenSys/usr/bin/qsh
system  "DSPFD FILE(HORTONR/*ALL) TYPE(*ATR) FILEATR(*PF) OUTPUT(*OUTFILE) OUTFILE(ILEDITOR/O_LOmvQmsN)"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/HORTONR: /QOpenSys/usr/bin/qsh
system  "QSYS/CPYTOIMPF FROMFILE(ILEDITOR/O_LOmvQmsN O_LOmvQmsN) TOSTMF('/tmp/vscodetemp-O_ulOS4Zrl') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM(',') DECPNT(*PERIOD)"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

Context Version
Code for IBM i version 2.5.0
Visual Studio Code version 1.85.2
Operating System win32_x64
Active extensions
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.4.0
Emmet (emmet): 1.0.0
Extension Authoring (extension-editing): 1.0.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
JSON Language Features (json-language-features): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
NPM support for VS Code (npm): 1.0.1
Node Debug Auto-attach (debug-auto-launch): 1.0.0
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0

Remote system
Setting Value
IBM i OS n/a
Tech Refresh n/a
CCSID ?
SQL Disabled
Source dates Disabled

Enabled features

/QOpenSys/pkgs/bin /usr/bin /QSYS.lib/ILEDITOR.lib /QSYS.LIB /QIBM/ProdData/IBMiDebugService/bin
bash attr GETNEWLIBL.PGM QZDFMDB2.PGM startDebugService.sh
chsh iconv
git setccsid
grep tar
ls
md5sum
sort
stat
Shell env
BUILDLIB=HORTONR
CURLIB=HORTONR
HOME=/home/HORTONR
HOST=as400dvp
LIBLS=
LOGIN=hortonr
LOGNAME=hortonr
MAIL=/var/spool/mail/hortonr
OLDPWD=/home/HORTONR
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PWD=/home/HORTONR
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=10.255.67.37 58332 22
SSH_CONNECTION=10.255.67.37 58332 10.113.65.20 22
TZ=<GMT>0<BST>,M3.5.0/03:00:00,M10.5.0/03:00:00
USER=hortonr
USERNAME=hortonr
_=/QOpenSys/pkgs/bin/env
Variants
{
  "american": "#@$",
  "local": "#@$"
}
Errors
[
  {
    "command": "system \"CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')\"",
    "code": 255,
    "stderr": "CPF2111: Library ILEDITOR already exists.",
    "cwd": "/home/HORTONR"
  }
]

RobMKH avatar Jan 26 '24 16:01 RobMKH

Please share the entire contents of your Code for IBM i output channel after the list doesn't appear in the version that does not work.

image

worksofliam avatar Jan 26 '24 16:01 worksofliam

Cheers Liam

image

RobMKH avatar Jan 26 '24 16:01 RobMKH

@RobMKH So you're able to switch between these versions on the same system and it's easy to recreate that one version works and one doesn't?

worksofliam avatar Jan 26 '24 16:01 worksofliam

@worksofliam

Yep - If I have 2.6.5 installed it doesn't work, roll back to 2.5.0 in the extensions, re-load and it works.

RobMKH avatar Jan 26 '24 16:01 RobMKH

Okay. Can you get us full output (not screenshots) from both 2.6.5 and 2.5.0?

worksofliam avatar Jan 26 '24 17:01 worksofliam

@worksofliam

Apologies - I'm probably being a bit dense here. The complete output was in the 2 code sections in the original post. If I'm missing anything or a way to make it more verbose the please advise and I'll do it.

RobMKH avatar Jan 26 '24 17:01 RobMKH

@RobMKH Yes, we also need all the initial logs from when the connection is made. Simply selecting all and copying will grab it all.

worksofliam avatar Jan 26 '24 18:01 worksofliam

@worksofliam

output 2.5.0.txt output 2.6.5.txt

RobMKH avatar Jan 26 '24 18:01 RobMKH

@RobMKH With 2.6.5, before connecting, would you mind right clicking on your connection and selecting 'Reload and Connect'? Please also collect all the output again. Thanks!

worksofliam avatar Jan 26 '24 18:01 worksofliam

@worksofliam

output 2.6.5 reload and connect.txt

RobMKH avatar Jan 26 '24 19:01 RobMKH

@RobMKH After connecting with 2.6.5, any chance you can copy+paste your developer console log?

To get to this:

  1. Go to help
  2. Select Toggle Developer Console
  3. New panel opens up to the side
  4. Select the Console tab
  5. Copy and paste everything in the console

worksofliam avatar Jan 29 '24 19:01 worksofliam

@worksofliam

WARN Via 'product.json#extensionEnabledApiProposals' extension 'ms-python.python' wants API proposal 'registerIssueDataProvider' but that proposal DOES NOT EXIST. Likely, the proposal has been finalized (check 'vscode.d.ts') or was abandoned. log.ts:421 INFO Started local extension host with pid 107308. log.ts:431 WARN [cmake-tools]: Couldn't find message for key cmake-tools.configuration.cmake.options.advanced.statusBarVisibility.variant.description. log.ts:431 WARN [redhat.vscode-xml]: Cannot register 'redhat.telemetry.enabled'. This property is already registered. log.ts:431 WARN [twxs.cmake]: Cannot register 'cmake.cmakePath'. This property is already registered. console.ts:137 [Extension Host] Git installation not found. w @ console.ts:137 console.ts:137 [Extension Host] Congratulations, your extension "vscode-ibmi-walkthroughs" is now active! console.ts:137 [Extension Host] Congratulations, your extension "code-for-ibmi" is now active! console.ts:137 [Extension Host] Developer environment: false log.ts:421 INFO [perf] Render performance baseline is 48ms DevTools failed to load source map: Could not load content for https://ticino.blob.core.windows.net/sourcemaps/8b3775030ed1a69b13e4f4c628c612102e30a681/node_modules/@vscode/vscode-languagedetection/dist/lib/index.js.map: Fetch through target failed: Target not supported; Fallback: Unknown error

RobMKH avatar Jan 29 '24 20:01 RobMKH

Hi @worksofliam

Hope you're well.

Did you manage to discover anything with regards to this issue?

RobMKH avatar Feb 28 '24 09:02 RobMKH

Hey @worksofliam

I think I finally got to the bottom of this and it might help someone else with a similar issue.

Our SSHD server was running under a different user profile to QSECOFR and it would appear that profile didn't have enough auth to do all the things required by the commands VSC/Code for i issues, even down to reporting a bad QCCSID which wasn't correct.

However, when I restarted it "correctly" using STRTCPSVR *SSHD it still didn't work. More digging lead me to the system profile QSSHD being disabled. It needs to be enabled if you're going to run SSHD under QSECOFR (and maybe generally).

So the long and short of it is check your SSHD server is running properly - which I now have done.

Liam - feel free to mark this as closed and thanks for your help. I wonder if there's a mod you could consider including that would verify the SSHD service is running/auth'ing as expected?

RobMKH avatar Jul 02 '24 08:07 RobMKH

@RobMKH What method would you use the check to see if the SSHD is running/auth'ing as expected? Some SQL method perhaps?

worksofliam avatar Jul 02 '24 13:07 worksofliam