Dataset refresh failure for Impala database

[Anonymous]

I have been getting an error trying to refresh data from Impala on daily basis with underlying error message of ERROR [08S01] 

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>ODBC: ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Runtime Error: Admission for query exceeded timeout 900000ms in pool root.svcpbigateway. Queued reason: Not enough aggregate memory available in pool root.svcpbigateway with max mem resources 1024.00 GB (configured statically). Needed 232.00 GB but only 68.00 GB was available.\n</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon>dsn=Impala PROD</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: RSA Bill Payments.

Is there anyone received the same error and how do you fix it?

Thanks

[Anonymous]

Hi @Anonymous 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster?

If not, please provide more detailed description, that could be more helpful to solve the issue.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hello @Anonymous 
We have reached out to Impala admin team to troubleshoot the refresh issue.

[Anonymous]

Hi @Anonymous 

Please check if the gateway was intercepted by a firewall.

Open the on-premise data gateway, and make sure the HTTPS mode is closed, sometimes the https mode may cause the connection issue.

If it does not help, feel free to let me know.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.