Forum Discussion
Need Help Dataset Stuck, Scheduled Refresh in progress...
Hi Bi Support Team, We have issue below, Report can't update new data because dataset stuck on step refresh data. I has: - Restart services gateway. - Reboot OS. - Reinstall software BI Gatew...
sirlanceohlott
Yes, we have Power BI Data Gateway on my system, hots on GCP.
Pls note, affter firt time reboot Server or Restart services, refresh is OK. But, second time, not OK 😞
I have multi data, BigQuery, Oracle, Dremio. Connect to data source via internal connect, it's stable --> I think connect not is problem.
---
Queries log:
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,fffde11c-67f3-0157-3a5a-6f608b8e391d,"[""{\""kind\"":\""Oracle\"",\""path\"":\""10.255.xxxx.xxxxx:1522/xxxxxxxxxxx\""}""]",20469f44-bd2a-43c7-ab09-8387c97648f5,2021-10-05T07:01:42.7559841Z,1,DirectQuery,3,,,,,,Y,
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,f2a1bd21-57d7-432c-a1b8-5d91a53bc70f,"[""{\""kind\"":\""Odbc\"",\""path\"":\""dsn=xxxxxx-datalake-prod\""}""]",c8d665c0-553d-4274-b272-bc84ad455b27,2021-10-05T07:01:39.6519820Z,5070228,Refresh,0,60.8079,1.9522,49349,2021-10-05T07:01:40.6571168Z,5071259,Y,
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,f2a1bd21-57d7-432c-a1b8-5d91a53bc70f,"[""{\""kind\"":\""Odbc\"",\""path\"":\""dsn=xxxxxx-datalake-prod\""}""]",8cb3e952-1ad7-41bf-9925-8e4e799df974,2021-10-05T07:01:31.1622341Z,5062843,Refresh,0,64.4524,93.8382,3847879,2021-10-05T07:01:39.8258019Z,5071549,Y,
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,28bbc196-d586-7a78-982f-fd8557a993b5,"[""{\""kind\"":\""Oracle\"",\""path\"":\""10.255.xxxx.xxxxx:1522/xxxxxxxxxxx\""}""]",30a234d4-236a-43e7-97d8-a7f653635ed8,2021-10-05T07:01:49.7188639Z,111,DirectQuery,1,,,,,,Y,
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,b47b5e19-8dca-af5a-98a6-2a22cacd54f4,"[""{\""kind\"":\""Oracle\"",\""path\"":\""10.255.xxxx.xxxxx:1522/xxxxxxxxxxx\""}""]",3e82c8fa-a74c-4c84-bb38-5de80c6d26a7,2021-10-05T07:01:51.1226696Z,1,DirectQuery,1,,,,,,Y,
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,610b39de-e87a-5f42-3824-3a1f94ea4414,"[""{\""kind\"":\""Odbc\"",\""path\"":\""dsn=xxxxxx-datalake-prod\""}""]",0a255c30-1df2-42af-aa03-d19e5df869ed,2021-10-05T07:01:33.2662336Z,27005,Refresh,,,,,,,N,Timeout expired. The timeout period elapsed prior to completion of the operation.
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,610b39de-e87a-5f42-3824-3a1f94ea4414,"[""{\""kind\"":\""Odbc\"",\""path\"":\""dsn=xxxxxx-datalake-prod\""}""]",0a255c30-1df2-42af-aa03-d19e5df869ed,2021-10-05T07:02:00.3389683Z,26997,Refresh,,,,,,,N,Timeout expired. The timeout period elapsed prior to completion of the operation.
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,c18648aa-7578-cd0e-b6fa-a6edafe9ff92,"[""{\""kind\"":\""Oracle\"",\""path\"":\""10.255.xxxx.xxxxx:1522/xxxxxxxxxxx\""}""]",a354f243-80ef-42ad-9026-33ed42989524,2021-10-05T07:02:04.8433611Z,3,DirectQuery,1,,,,,,Y,
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,9cb33e75-ae42-0ce9-f431-7af8619fe685,"[""{\""kind\"":\""Oracle\"",\""path\"":\""10.255.xxxx.xxxxx:1522/xxxxxxxxxxx\""}""]",697c49d6-f42c-4226-bd98-74441706766e,2021-10-05T07:02:05.2574116Z,2922,DirectQuery,3,,,,,,Y,
ddb4f46d-cc15-4a37-b969-f7e2c0d153c3,9700a655-8079-6539-be08-d1b1cffeeec8,"[""{\""kind\"":\""Dremio\"",\""path\"":\""10.255.yyy.yyy:31010\""}""]",130cca4e-1d3e-4291-b487-5ea737c48360,2021-10-05T07:02:02.3946338Z,4786697,Refresh,0,3.9356,0,383563,2021-10-05T07:02:03.6544475Z,63769014123654,Y,