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