IRIS SQL LOAD DATA <ERROR #5023: Remote Gateway Error: Connection cannot be established>
Hi,
I'm trying to load some data into IRIS using LOAD DATA in the IRIS terminal however I am getting blocked by this error. I have read the documentation on this page trying to set up a gateway connection but get the same Connection cannot be established error.
This is what is in the %Java Server activity log
ID Date Time Record Type Job Text
8132022-07-1810:37:09 Info 28048Job command successful, started monitor process '6404'
8112022-07-1810:37:09 Info 28048 Starting background process to monitor the Gateway Server
8102022-07-1810:37:09 Info 28048 Gateway Server start-up confirmation skipped
8092022-07-1810:37:09 Info 28048 Execution returned: 'Exception in thread "main" java.io.FileNotFoundException: Invalid file path at java.base/java.io.FileOutputStream.<init>(FileOutputStream.java:231) at com.intersystems.jdbc.LogFileStream.<init>(LogFileStream.java:86) at com.intersystems.gateway.JavaGateway.getLogFile(JavaGateway.java:332) at com.intersystems.gateway.JavaGateway.main(JavaGateway.java:237) '
8082022-07-1810:37:08 Info 28048 Executing O.S. command: java.exe -Xrs -Djava.system.class.loader=com.intersystems.gateway.ClassLoader -classpath {removed filepath}"""{removed user}:IRIS:%Java Server"127.0.0.1 ""8072022-07-1810:37:08 Info 28048 Starting Java Gateway Server '%Java Server'I can connect find through ODBC but JDBC refuses to connect for the "Connection cannot be established" error. I am using a database manager called DBeaver that connection through JDBC fine.
Is anyone able to provide some help to get rid of this error?
EDIT: I found the audit log and ran the OS command which returned this error
Error: Could not find or load main class .system.class.loader=com.intersystems.gateway.ClassLoader
Caused by: java.lang.ClassNotFoundException: /system/class/loader=com/intersystems/gateway/ClassLoader
E2: I cleared out the initial error by adding the log file but there is now even less of an error with a generic [SQLCODE: <-400>:<Fatal error occurred>]
E3: Got it working found the xDBC errors page which told me the exact problem with the query
Comments
The error seems to occur when it's trying to access the log file. Under you advanced settings, have you checked where it's trying to find or create your log file and made sure it's valid?
It was missing the log file entirely. I've now added the log file however I am not getting even less info out of the error message.
[SQLCODE: <-400>:<Fatal error occurred>]The log files and audit files don't contain any information. It looks like it just stops.