Amazon JDSI 20260 Cannot access file to use for logging

[MattE]

I've started to get this when i run a job in Studio 7.3.1. I've made no configuration changes.

[Amazon][JDSI](20260) Cannot access file to use for logging: String index out of range: -1. Switching to default logging output.

Anyone any idea what it's on about?

[Anonymous · Accepted solution]

Hi

It was a known issue, a simple workaround is to set the "LogPath" property in JDBC URL. e.g "jdbc:redshift://redshift.company.us-west- 1.redshift.amazonaws.com:9000/Default;DSILogLevel=3; LogPath=C:\temp"

cf: https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-configuring-logging.html

Regards

Shong