Failure while attempting to read from database

1

Hello everyone, I am connecting my elasticsearch cluster and an oracle database to make queries between both datasets. When I run a preview query, it runs smoothly and shows me some results, but when I do it in run mode it drops and shows me the following message:

Failure while attempting to read from database.

The query is as follows:

SELECT
	SSO."id_usuario",
	TRF."srcmac",
	TRF."srcip",
	TRF."timestamp",
	SSO."accion_logsso",
	SSO."fecha_logsso",
	SSO."mensaje_logsso",
	SSO."user_login",
	TRF."srcname"
FROM 
	"logs_uls".sso_logs AS SSO
INNER JOIN
	"logs_uls".fw_traffic AS TRF
ON 
	SSO."ip_logsso" = TRF."srcip" AND 
	SSO."ip_logsso" LIKE '10.%'

And the dremio log that is generated is the following:

2019-10-17 14:29:43,307 [e0 - 22575af8-eb1a-a7a7-72bd-58c0d0083600:frag:2:0] INFO  c.d.exec.store.jdbc.JdbcRecordReader - User Error Occurred [ErrorId: aa9b499f-38ea-4ec2-b4e4-4b083c7deaa4]
com.dremio.common.exceptions.UserException: Failure while attempting to read from database.
	at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:773) ~[dremio-common-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.exec.store.jdbc.JdbcRecordReader.next(JdbcRecordReader.java:252) [dremio-ce-jdbc-plugin-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.exec.store.CoercionReader.next(CoercionReader.java:212) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.op.scan.ScanOperator.outputData(ScanOperator.java:240) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.driver.SmartOp$SmartProducer.outputData(SmartOp.java:516) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.driver.StraightPipe.pump(StraightPipe.java:56) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.driver.Pipeline.doPump(Pipeline.java:109) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.driver.Pipeline.pumpOnce(Pipeline.java:99) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.exec.fragment.FragmentExecutor$DoAsPumper.run(FragmentExecutor.java:307) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.exec.fragment.FragmentExecutor$DoAsPumper.run(FragmentExecutor.java:303) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_111]
	at javax.security.auth.Subject.doAs(Subject.java:422) [na:1.8.0_111]
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1836) [hadoop-common-2.8.3.jar:na]
	at com.dremio.sabot.exec.fragment.FragmentExecutor.run(FragmentExecutor.java:260) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.exec.fragment.FragmentExecutor.access$1200(FragmentExecutor.java:92) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run(FragmentExecutor.java:632) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.task.AsyncTaskWrapper.run(AsyncTaskWrapper.java:104) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop(SlicingThread.java:226) [dremio-ce-sabot-scheduler-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.sabot.task.slicing.SlicingThread.run(SlicingThread.java:156) [dremio-ce-sabot-scheduler-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
Caused by: java.sql.SQLException: Fallo al convertir a representaci󮠩nterna
	at oracle.jdbc.driver.CharCommonAccessor.getDouble(CharCommonAccessor.java:285) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
	at oracle.jdbc.driver.T4CVarcharAccessor.getDouble(T4CVarcharAccessor.java:571) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
	at oracle.jdbc.driver.GeneratedStatement.getDouble(GeneratedStatement.java:179) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
	at oracle.jdbc.driver.GeneratedScrollableResultSet.getDouble(GeneratedScrollableResultSet.java:214) ~[oracle-ojdbc8-12.2.0.1.jar:12.2.0.1.0]
	at com.dremio.exec.store.jdbc.JdbcRecordReader$Float8Copier.copy(JdbcRecordReader.java:449) ~[dremio-ce-jdbc-plugin-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.exec.store.jdbc.JdbcRecordReader.next(JdbcRecordReader.java:242) [dremio-ce-jdbc-plugin-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	... 17 common frames omitted
2019-10-17 14:29:43,326 [out-of-band-observer] ERROR c.d.service.jobs.QueryProfileParser - Failed to parse physical plan for query 22575af8-eb1a-a7a7-72bd-58c0d0083600, plan {
  "\"00-00\"": {
    "\"op\"": "com.dremio.exec.planner.physical.ScreenPrel",
    "\"values\"": {},
    "\"inputs\"": [
      "00-01"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{3.5119386631E9 rows, 1.4875027238129925E10 cpu, 4.8696336E8 io, 1.06393934964288E13 network, 2678298.4800000004 memory}"
  },
  "\"00-01\"": {
    "\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
    "\"values\"": {
      "\"fields\"": "[Fragment, Records, Path, Metadata, Partition, FileSize]",
      "\"exprs\"": "[$0, $1, $2, $3, $4, $5]"
    },
    "\"inputs\"": [
      "00-02"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{3.4686640592E9 rows, 1.4831752634229925E10 cpu, 4.8696336E8 io, 1.06393934964288E13 network, 2678298.4800000004 memory}"
  },
  "\"00-02\"": {
    "\"op\"": "com.dremio.exec.planner.physical.WriterCommitterPrel",
    "\"values\"": {
      "\"final\"": "C:/Users/Propietario/AppData/Local/Dremio/pdfs/results/22575af8-eb1a-a7a7-72bd-58c0d0083600"
    },
    "\"inputs\"": [
      "00-03"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{3.0359180202E9 rows, 1.4831726669467585E10 cpu, 4.8696336E8 io, 1.06393934964288E13 network, 2678298.4800000004 memory}"
  },
  "\"00-03\"": {
    "\"op\"": "com.dremio.exec.planner.physical.UnionExchangePrel",
    "\"values\"": {},
    "\"inputs\"": [
      "01-01"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{2.6031719812E9 rows, 1.4398980630467585E10 cpu, 4.8696336E8 io, 1.06393934964288E13 network, 2678298.4800000004 memory}"
  },
  "\"01-01\"": {
    "\"op\"": "com.dremio.exec.planner.physical.WriterPrel",
    "\"values\"": {},
    "\"inputs\"": [
      "01-02"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{2.1704259422E9 rows, 1.0937012318467585E10 cpu, 4.8696336E8 io, 4.2268419648E9 network, 2678298.4800000004 memory}"
  },
  "\"01-02\"": {
    "\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
    "\"values\"": {
      "\"fields\"": "[id_usuario, srcmac, srcip, timestamp, accion_logsso, fecha_logsso, mensaje_logsso, user_login, srcname]",
      "\"exprs\"": "[$0, $1, $2, $3, $4, $5, $6, $7, $8]"
    },
    "\"inputs\"": [
      "01-03"
    ],
    "\"rowType\"": "RecordType(DOUBLE id_usuario, VARCHAR(65536) srcmac, VARCHAR(65536) srcip, VARCHAR(65536) timestamp, VARCHAR(65536) accion_logsso, DATE fecha_logsso, VARCHAR(65536) mensaje_logsso, VARCHAR(65536) user_login, VARCHAR(65536) srcname)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{1.7376799031999998E9 rows, 1.0504266279467585E10 cpu, 4.8696336E8 io, 4.2268419648E9 network, 2678298.4800000004 memory}"
  },
  "\"01-03\"": {
    "\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
    "\"values\"": {
      "\"fields\"": "[id_usuario, srcmac, srcip, timestamp, accion_logsso, fecha_logsso, mensaje_logsso, user_login, srcname]",
      "\"exprs\"": "[$6, $1, $0, $2, $4, $8, $5, $7, $3]"
    },
    "\"inputs\"": [
      "01-04"
    ],
    "\"rowType\"": "RecordType(DOUBLE id_usuario, VARCHAR(65536) srcmac, VARCHAR(65536) srcip, VARCHAR(65536) timestamp, VARCHAR(65536) accion_logsso, DATE fecha_logsso, VARCHAR(65536) mensaje_logsso, VARCHAR(65536) user_login, VARCHAR(65536) srcname)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{1.3049338641999998E9 rows, 1.0504227332324074E10 cpu, 4.8696336E8 io, 4.2268419648E9 network, 2678298.4800000004 memory}"
  },
  "\"01-04\"": {
    "\"op\"": "com.dremio.exec.planner.physical.HashJoinPrel",
    "\"values\"": {
      "\"condition\"": "=($0, $9)",
      "\"joinType\"": "inner"
    },
    "\"inputs\"": [
      "01-06",
      "01-05"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) srcip, VARCHAR(65536) srcmac, VARCHAR(65536) timestamp, VARCHAR(65536) srcname, VARCHAR(65536) accion_logsso, VARCHAR(65536) mensaje_logsso, DOUBLE id_usuario, VARCHAR(65536) user_login, DATE fecha_logsso, VARCHAR(65536) ip_logsso)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{8.721878251999999E8 rows, 1.0504188385180563E10 cpu, 4.8696336E8 io, 4.2268419648E9 network, 2678298.4800000004 memory}"
  },
  "\"01-06\"": {
    "\"op\"": "com.dremio.plugins.elastic.planning.rels.ElasticScanPrel",
    "\"values\"": {
      "\"table\"": "[data-1, fw_traffic, doc]",
      "\"resource\"": "fw_traffic/doc",
      "\"columns\"": "[`srcip`, `srcmac`, `timestamp`, `srcname`]",
      "\"pushdown\n \"": "{\n  \"from\" : 0,\n  \"size\" : 4000,\n  \"query\" : {\n    \"match_all\" : {\n      \"boost\" : 1.0\n    }\n  }\n}"
    },
    "\"inputs\"": [],
    "\"rowType\"": "RecordType(VARCHAR(65536) srcip, VARCHAR(65536) srcmac, VARCHAR(65536) timestamp, VARCHAR(65536) srcname)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{4.32746039E8 rows, 4.3274604E8 cpu, 0.0 io, 0.0 network, 0.0 memory}"
  },
  "\"01-05\"": {
    "\"op\"": "com.dremio.exec.planner.physical.BroadcastExchangePrel",
    "\"values\"": {},
    "\"inputs\"": [
      "02-01"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) accion_logsso, VARCHAR(65536) mensaje_logsso, DOUBLE id_usuario, VARCHAR(65536) user_login, DATE fecha_logsso, VARCHAR(65536) ip_logsso)",
    "\"rowCount\"": 152176.05000000002,
    "\"cumulativeCost\"": "{6543571.149999999 rows, 5.49812078780563E8 cpu, 4.8696336E8 io, 4.2268419648E9 network, 0.0 memory}"
  },
  "\"02-01\"": {
    "\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
    "\"values\"": {
      "\"fields\"": "[accion_logsso, mensaje_logsso, id_usuario, user_login, fecha_logsso, ip_logsso]",
      "\"exprs\"": "[$3, $5, $6, $7, $9, $10]"
    },
    "\"inputs\"": [
      "02-02"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) accion_logsso, VARCHAR(65536) mensaje_logsso, DOUBLE id_usuario, VARCHAR(65536) user_login, DATE fecha_logsso, VARCHAR(65536) ip_logsso)",
    "\"rowCount\"": 152176.05000000002,
    "\"cumulativeCost\"": "{6391395.1 rows, 5.48594670380563E8 cpu, 4.8696336E8 io, 4.8696336E8 network, 0.0 memory}"
  },
  "\"02-02\"": {
    "\"op\"": "com.dremio.exec.planner.physical.SelectionVectorRemoverPrel",
    "\"values\"": {},
    "\"inputs\"": [
      "02-03"
    ],
    "\"rowType\"": "RecordType(DOUBLE id_logsso, DOUBLE id_serviciosso, VARCHAR(65536) ruta_modulo, VARCHAR(65536) accion_logsso, VARCHAR(65536) origen_accion_logsso, VARCHAR(65536) mensaje_logsso, DOUBLE id_usuario, VARCHAR(65536) user_login, DOUBLE id_dominiosso, DATE fecha_logsso, VARCHAR(65536) ip_logsso, DOUBLE id_usuario_rel, DOUBLE tipo_msg_logsso, VARCHAR(65536) user_agent_logsso, VARCHAR(65536) id_session_logsso, VARCHAR(65536) ip_server_logsso)",
    "\"rowCount\"": 152176.05000000002,
    "\"cumulativeCost\"": "{6239219.05 rows, 5.4859466125E8 cpu, 4.8696336E8 io, 4.8696336E8 network, 0.0 memory}"
  },
  "\"02-03\"": {
    "\"op\"": "com.dremio.exec.planner.physical.FilterPrel",
    "\"values\"": {
      "\"condition\"": "LIKE($10, '10.%')"
    },
    "\"inputs\"": [
      "02-04"
    ],
    "\"rowType\"": "RecordType(DOUBLE id_logsso, DOUBLE id_serviciosso, VARCHAR(65536) ruta_modulo, VARCHAR(65536) accion_logsso, VARCHAR(65536) origen_accion_logsso, VARCHAR(65536) mensaje_logsso, DOUBLE id_usuario, VARCHAR(65536) user_login, DOUBLE id_dominiosso, DATE fecha_logsso, VARCHAR(65536) ip_logsso, DOUBLE id_usuario_rel, DOUBLE tipo_msg_logsso, VARCHAR(65536) user_agent_logsso, VARCHAR(65536) id_session_logsso, VARCHAR(65536) ip_server_logsso)",
    "\"rowCount\"": 152176.05000000002,
    "\"cumulativeCost\"": "{6087043.0 rows, 5.484424852E8 cpu, 4.8696336E8 io, 4.8696336E8 network, 0.0 memory}"
  },
  "\"02-04\"": {
    "\"op\"": "com.dremio.exec.store.jdbc.rel.JdbcPrel",
    "\"values\"": {
      "\"sql\"": "SELECT *
\nFROM \"PTDI_SSO\".\"sso_logs\""
    },
    "\"inputs\"": [],
    "\"rowType\"": "RecordType(DOUBLE id_logsso, DOUBLE id_serviciosso, VARCHAR(65536) ruta_modulo, VARCHAR(65536) accion_logsso, VARCHAR(65536) origen_accion_logsso, VARCHAR(65536) mensaje_logsso, DOUBLE id_usuario, VARCHAR(65536) user_login, DOUBLE id_dominiosso, DATE fecha_logsso, VARCHAR(65536) ip_logsso, DOUBLE id_usuario_rel, DOUBLE tipo_msg_logsso, VARCHAR(65536) user_agent_logsso, VARCHAR(65536) id_session_logsso, VARCHAR(65536) ip_server_logsso)",
    "\"rowCount\"": 3043521.0,
    "\"cumulativeCost\"": "{3043522.0 rows, 4.86963361E8 cpu, 4.8696336E8 io, 4.8696336E8 network, 0.0 memory}"
  }
}
com.fasterxml.jackson.core.JsonParseException: Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value
 at [Source: (String)"{
  "\"00-00\"": {
    "\"op\"": "com.dremio.exec.planner.physical.ScreenPrel",
    "\"values\"": {},
    "\"inputs\"": [
      "00-01"
    ],
    "\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)",
    "\"rowCount\"": 4.32746039E8,
    "\"cumulativeCost\"": "{3.5119386631E9 rows, 1.4875027238129925E10 cpu, 4.8696336E8 io, 1.06393934964288E13 network, 2678298.4800000004 memory}"
  },
  "\"00-01\"[truncated 8688 chars]; line: 158, column: 28]
	at com.fasterxml.jackson.core.JsonParser._constructError(JsonParser.java:1804) ~[jackson-core-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(ParserMinimalBase.java:693) ~[jackson-core-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.core.base.ParserMinimalBase._throwUnquotedSpace(ParserMinimalBase.java:657) ~[jackson-core-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.core.json.ReaderBasedJsonParser._finishString2(ReaderBasedJsonParser.java:2053) ~[jackson-core-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.core.json.ReaderBasedJsonParser._finishString(ReaderBasedJsonParser.java:2024) ~[jackson-core-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.getText(ReaderBasedJsonParser.java:278) ~[jackson-core-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:672) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.mapObject(UntypedObjectDeserializer.java:871) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:654) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.mapObject(UntypedObjectDeserializer.java:880) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:654) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.deser.std.MapDeserializer._readAndBindStringKeyMap(MapDeserializer.java:527) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:364) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:29) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:4013) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3004) ~[jackson-databind-2.9.8.jar:2.9.8]
	at com.dremio.service.jobs.QueryProfileParser.parsePhysicalPlan(QueryProfileParser.java:312) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.service.jobs.QueryProfileParser.parse(QueryProfileParser.java:343) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.service.jobs.QueryProfileParser.<init>(QueryProfileParser.java:98) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.service.jobs.LocalJobsService.addAttemptToJob(LocalJobsService.java:1555) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.service.jobs.LocalJobsService.access$1200(LocalJobsService.java:199) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.service.jobs.LocalJobsService$QueryListener.execCompletion(LocalJobsService.java:1044) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.exec.planner.observer.OutOfBandQueryObserver$1.run(OutOfBandQueryObserver.java:49) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at com.dremio.common.SerializedExecutor$RunnableProcessor.run(SerializedExecutor.java:96) [dremio-services-base-rpc-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_111]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_111]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_111]
2019-10-17 14:29:43,332 [out-of-band-observer] INFO  query.logger - {"queryId":"22575af8-eb1a-a7a7-72bd-58c0d0083600","schema":"[logs_uls]","queryText":"SELECT\r\n\tSSO.\"id_usuario\",\r\n\tTRF.\"srcmac\",\r\n\tTRF.\"srcip\",\r\n\tTRF.\"timestamp\",\r\n\tSSO.\"accion_logsso\",\r\n\tSSO.\"fecha_logsso\",\r\n\tSSO.\"mensaje_logsso\",\r\n\tSSO.\"user_login\",\r\n\tTRF.\"srcname\"\r\nFROM \r\n\t\"logs_uls\".sso_logs AS SSO\r\nINNER JOIN\r\n\t\"logs_uls\".fw_traffic AS TRF\r\nON \r\n\tSSO.\"ip_logsso\" = TRF.\"srcip\" AND \r\n\tSSO.\"ip_logsso\" LIKE '10.%'","start":1571333383005,"finish":1571333383324,"outcome":"FAILED","username":"gaston"}
2019-10-17 14:29:43,426 [e0 - 22575af8-eb1a-a7a7-72bd-58c0d0083600:frag:0:0] INFO  c.d.s.e.f.FragmentStatusReporter - 22575af8-eb1a-a7a7-72bd-58c0d0083600:0:0: State to report: CANCELLED
2019-10-17 14:29:43,871 [e0 - 22575af8-eb1a-a7a7-72bd-58c0d0083600:frag:1:1] INFO  c.d.s.e.f.FragmentStatusReporter - 22575af8-eb1a-a7a7-72bd-58c0d0083600:1:1: State to report: CANCELLED
2019-10-17 14:29:43,882 [e0 - 22575af8-eb1a-a7a7-72bd-58c0d0083600:frag:1:2] INFO  c.d.s.e.f.FragmentStatusReporter - 22575af8-eb1a-a7a7-72bd-58c0d0083600:1:2: State to report: CANCELLED
2019-10-17 14:29:43,948 [e0 - 22575af8-eb1a-a7a7-72bd-58c0d0083600:frag:1:0] INFO  c.d.s.e.f.FragmentStatusReporter - 22575af8-eb1a-a7a7-72bd-58c0d0083600:1:0: State to report: CANCELLED

Can someone help me understand what happens? I would greatly appreciate it!
Thanks in advance

2

@gaston_guerra

Kindly provide us the job profile

Share a Query Profile

3

Hi Balaji, thanks for your response! This is the job profile, it’s ok?

37bbfb2e-c2cd-4499-8b8f-d3e4b7ff7cb5.zip (13,6 KB)

4

Trying to find the error, i think the problem is when I try to see my Oracle table. One of the message shown is: Fail to convert to internal representation

Perhaps that is the problem? I don’t know if there will be any configuration that I am overlooking or have to install something. If anyone out there knows how to solve this, I would be very grateful, regards!

5

@gaston_guerra

Would you be able to provide us with the 2 Oracle create table DDL’s?

Thanks
@balaji.ramaswamy

6 
CREATE TABLE "sso_logs" (
	"id_logsso" NUMBER(22,0),
	"id_serviciosso" NUMBER(22,0),
	"ruta_modulo" VARCHAR2(200),
	"accion_logsso" VARCHAR2(200),
	"origen_accion_logsso" VARCHAR2(200),
	"mensaje_logsso" VARCHAR2(200),
	"mensaje_lob_logsso" CLOB,
	"id_usuario" NUMBER(22,0),
	"user_login" VARCHAR2(200),
	"id_dominiosso" NUMBER(22,0),
	"fecha_logsso" DATE,
	"ip_logsso" VARCHAR2(20),
	"id_usuario_rel" NUMBER(22,0),
	"tipo_msg_logsso" NUMBER(22,0),
	"user_agent_logsso" VARCHAR2(300),
	"id_session_logsso" VARCHAR2(100),
	"ip_server_logsso" VARCHAR2(20),
	CONSTRAINT SYS_C00285905 CHECK ("id_logsso"),
	CONSTRAINT "sso_logs_PK" PRIMARY KEY ("id_logsso")
);
CREATE UNIQUE INDEX "sso_logs_PK" ON PTDI_SSO."sso_logs" ("id_logsso");