Question
· 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:

LOAD DATA FROM FILE 'D:\dev\openflights_dataset\data\countries.csv' 
INTO dc_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
Discussion (1)1
Log in or sign up to continue