Hello,
I am getting a error while running a query in dremio :
The JDBC storage plugin failed while trying setup the SQL query.
This is what I see in the logs :
2018-11-01 16:44:57,048 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,050 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,050 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,050 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,052 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,058 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,058 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,059 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,059 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,064 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,064 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms
2018-11-01 16:44:57,274 [FABRIC-rpc-event-queue] INFO c.d.exec.work.foreman.QueryManager - Fragment 242542f6-df5d-f33b-be11-e56486290700:1:0 failed, cancelling remaining fragments.
2018-11-01 16:44:57,278 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A node query status message arrived post query termination, dropping. Query [242542f6-df5d-f33b-be11-e56486290700] from node address: “csl-svr-hdp04.ad.capricorn.com.au”
user_port: -1
fabric_port: 46011
roles {
sql_query: false
java_executor: true
master: false
}
startTime: 1541044862445
provision_id: “container_1541044626271_0001_01_000005”
max_direct_memory: 25769803776
available_cores: 6
.
2018-11-01 16:44:57,279 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [3:0] reported a state of FAILED.
2018-11-01 16:44:57,279 [out-of-band-observer] INFO query.logger - {“queryId”:“242542f6-df5d-f33b-be11-e56486290700”,“schema”:"[Trusted]",“queryText”:“select * From trusted.da.Integration.Epicor.APTransaction As CH \r\n Inner Join trusted.da.Base.Epicor.EpicorERP.dbo.Vendor As V --Fin Supplier\r\n On CH.Company = V.Company\r\n And CH.VendorNum = V.VendorNum\r\n LeftJoin trusted.da.Base.Epicor.EpicorERP.dbo.Customer As C --CRM Supplier\r\n On C.SyncId = V.SyncID\r\n And C.SyncID <> 0\r\n And C.Company = ‘CAPCRM’\r\n Left Join trusted.da.Base.Epicor.EpicorERP.dbo.Customer As M --Fin Memberr\r\n On M.Company = C.Company\r\n And M.CustID = CH.MemberCustId”,“start”:1541061896181,“finish”:1541061897275,“outcome”:“FAILED”,“username”:“rashmi.palat”}
2018-11-01 16:44:57,281 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [4:0] reported a state of CANCELLED.
2018-11-01 16:44:57,281 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [0:0] reported a state of CANCELLED.
2018-11-01 16:44:57,281 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [5:0] reported a state of FAILED.
2018-11-01 16:44:57,281 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A node query status message arrived post query termination, dropping. Query [242542f6-df5d-f33b-be11-e56486290700] from node address: “csl-svr-hdp05.ad.capricorn.com.au”
user_port: -1
fabric_port: 46012
roles {
sql_query: false
java_executor: true
master: false
}
startTime: 1541044886061
provision_id: “container_1541044626271_0001_01_000012”
max_direct_memory: 25769803776
available_cores: 6
.
2018-11-01 16:44:57,282 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [2:0] reported a state of FAILED.
Please help!
Thanks and regards,
Rashmi