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!
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...