Problem connecting to IBM i host - Error message "The SQL runner is not available."

[Allenhlavacek]

To whom it may concern.
I am unable to connect to an IBM i partition using VS Code for i. I get error "The SQL runner is not available." Can someone please advise to what i should be looking for?

Regards,
AL

[sebjulliand]

Hi, look for the Code for IBM i output under VS Code output tab and paste it's whole content here.

[Allenhlavacek]

One more thing to add. This all works fine to other IBM i hosts. It's just this one that's not connecting.

[Allenhlavacek]

Hi sebjulliand.
My colleague uninstalled Code for IBM i V3.0.12 and installed older version v2.17.2 and that fixed it. He pointed me to Issue #3243. I am not going to do that just yet. I would like to hear what you have to say first. I can live with the problem for a while, but my developer can't, so I asked him to downlevel as well.

Regards,
AL

[Allenhlavacek]

Hi sebjulliand
My colleague uninstalled v2.17.2 and installed v2.18.0 and he is not encountering the problem.

Regards,
AL

[sebjulliand]

Hi,
Code for IBM i v3 introduced big changes, one of them being the introduction of Mapepire as the DB access layer.
Downgrading to v2 works because of that.

According to your logs, it seems that your problem may be the same as in #3243: the JTOpen library on your system may be outdated.
You can confirm this running this command in a shell session:

java -cp /QIBM/ProdData/OS400/jt400/lib/jt400.jar com.ibm.as400.util.AboutToolbox

You can also try to start Mapepire in server mode, to see the whole error output - again, from a shell:

QIBM_JAVA_STDIO_CONVERT=N QIBM_PASE_DESCRIPTOR_STDIO=B QIBM_USE_DESCRIPTOR_STDIO=Y QIBM_MULTI_THREADED=Y java -Dos400.stdio.convert=N -jar "/home/E0020707/.vscode/mapepire-server-2.3.5.jar"

Havong the whole Java exception may pinpoint the issue.

But so far, I'd say that JTopen being outdated is the issue here.

[Allenhlavacek]

Thanks much sebjulliand. I think we can consider this issue closed. Thanks again for the asisstance.

[sebjulliand]

Anytime 👍🏻