Question Andreas Schneider · Dec 25, 2022

External Language Server failed to Start -> LOAD DATA FROM FILE no longer works

Hi! 've installed a fresh IRIS on Windows 10: "InterSystems IRIS Version 2022.2.0.368 xDBC Protocol Version 65"

I've tried to create an older demo database that I've build some days ago... it didn't work anymore :-(

If I execute this SQL:

LOADDATAFROMFILE'D:\dev\openflights_dataset\data\countries.csv'INTOdc_data_flights.countries(id,code,name,continent,wikipedia_link,keywords)VALUES(id,code,name,continent,wikipedia_link,keywords)USING{"from":{"file":{"header":true,"columnseparator":","}}}

It is incredible slow (a tiny file with  ~ 250 rows) and stops with this error (sorry it is in german ;-)):

 Error: [SQLCODE: <-400>:<Es ist ein nicht behebbarer Fehler aufgetreten >]
[Location: <ServerLoop>]
[%msg: <Fehler #5023: Java-Gateway-Fehler: Connection cannot be established>]

After some research I found that the External Language Server %JDBC Server
can't be started:

Start External Language Server %JDBC Server:
Please wait...result will show below:
2022-12-25 11:36:30  Starting JDBC Gateway Server '%JDBC Server'
2022-12-25 11:36:42  An error occurred while trying to start the Gateway Server
External Language Server failed to Start:
ERROR #5023: Remote Gateway Error: Connection cannot be established > ERROR #5001: External Language Server: invalid ping response

I've NO idea whats going on... any help is appreciated
Thanks!

Andreas

... and Merry Christmas!

Product version: IRIS 2022.2
$ZV: IRIS for Windows (x86-64) 2022.2 (Build 368U) Fri Oct 21 2022 16:44:33 EDT

Comments

Andreas Schneider · Dec 25, 2022

As a test i created an iris instance in a docker container. Nicely the problem doesn't exist there. Maybe I'll just try a reinstallation of IRIS under win10 the next days...

0