If you have to report a support ticket for a virtual schema, Exasol needs some additional logs to check the problem. This section talks about how you can
- Start netcat in listen-mode on a free TCP port on a machine reachable for an Exasol cluster.
nc -lkp 3000
- Run the following command to find your IP address.
ip -br address
- Create or alter your virtual schema and add the properties DEBUG_ADDRESS and LOG_LEVEL. For more details, see CREATE SCHEMA or ALTER SCHEMA. Replace the IP Address and Port with the values
from the previous steps.
CREATE VIRTUAL SCHEMA VIRTUAL_EXASOL
USING SCHEMA_FOR_VS_SCRIPT.ADAPTER_SCRIPT_EXASOL WITH
CONNECTION_NAME = 'JDBC_CONNECTION'
SCHEMA_NAME = '<schema name>'
IMPORT_FROM_EXA = 'true'
EXA_CONNECTION = 'EXA_CONNECTION'
DEBUG_ADDRESS = '<IP Address>:<Port>'
LOG_LEVEL = 'ALL';
The parameter LOG_LEVEL specifies log level defined in Java Utility Logging Levels.
- The following message is shown in case of a successful connection.
Attached to output service