Error when running scheduled refresh data after new windows patches

[micen]

Hi After installing August Windows patches we have trouble with on SQL server, I updated to the SQL 2016 SP2 CU2 refresh patch but the error still remains. We also upgraded the Datagateway to Version August 2018.

The error is that Scheduled uppdates doesn't work on this datasource in the gateway, but we are able to manually refresh?

The error is: something went wrong A time limit was reached when you sent or received a request. Please try again later or contact support. If you contact the support, provide the following information.
Kluster-URI: WABI-US-EAST2-redirect.analysis.windows.net
Aktivitets-ID: eafd8c6e-fbb2-455d-a87c-2bc602ed1639
Begär ID: 0b53ebfc-a450-4f7b-abbc-d9dd5db71ea6
Tid: 2018-09-03 21:11:31Z

All other datasources in the datagateway works without a problem and are able to use scheduled updates, so it seems to be an error with this SQL server only. Has someone else experienced this issue?

Many Thanks

Micael Carlsson

Some of the log:

DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:35.4229112Z DM.EnterpriseGateway c6d52dfe-eed0-48d0-8ab6-ebaeae3cc1e9 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:35.4229112Z DM.EnterpriseGateway 6ea8dd89-8f2e-42c9-99d4-a730aa64e32b 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGPS 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:35.5948287Z DM.EnterpriseGateway c6d52dfe-eed0-48d0-8ab6-ebaeae3cc1e9 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:35.7666726Z DM.EnterpriseGateway 6ea8dd89-8f2e-42c9-99d4-a730aa64e32b 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGPS 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:35.9229055Z DM.EnterpriseGateway c6d52dfe-eed0-48d0-8ab6-ebaeae3cc1e9 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:36.0791486Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:36.2823137Z DM.EnterpriseGateway c6d52dfe-eed0-48d0-8ab6-ebaeae3cc1e9 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 9BE2A3E3 [DataMovement.PipeLine.MashupCommon] Setting mashup connection test connection properties
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:36.4385289Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:36.5322799Z DM.EnterpriseGateway 9d087a7e-c274-4b1f-a7c7-6cd60f9a3f0e 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGAA 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E8B7F0C0 [DM.GatewayCore] Evicting async operation c4324f55-a9a1-4400-82a4-9c953731b78b. The status of the operation is Closed.
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:36.6104070Z DM.EnterpriseGateway c6d52dfe-eed0-48d0-8ab6-ebaeae3cc1e9 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 488F6D1B [DataMovement.PipeLine.GatewayDataAccess] EncryptedConnection state = False for datasource <pi>{"kind":"SQL","path":"semotec-c1490;MISOnline"}</pi>
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:36.7510309Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:37.0791687Z DM.EnterpriseGateway 530147fd-a2e8-4ce8-a5e3-f5a46dc6bbee 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:37.0791687Z DM.EnterpriseGateway d6a4fb54-a49f-4981-b4ef-afea34664db5 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:37.0791687Z DM.EnterpriseGateway 626f40d3-4e86-4bce-8c7d-f1ecf40a41aa 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:37.2197858Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:37.3916825Z DM.EnterpriseGateway 530147fd-a2e8-4ce8-a5e3-f5a46dc6bbee 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:37.5635610Z DM.EnterpriseGateway d6a4fb54-a49f-4981-b4ef-afea34664db5 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:37.7041821Z DM.EnterpriseGateway 626f40d3-4e86-4bce-8c7d-f1ecf40a41aa 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Warning: 0 : 2018-09-01T12:11:37.8448182Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e D14EA466 [DM.Pipeline.Common] Failed to read GatewayCore property: EnableFastCombine, Ex: Object reference not set to an instance of an object.
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:37.9854219Z DM.EnterpriseGateway 530147fd-a2e8-4ce8-a5e3-f5a46dc6bbee 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:38.1573556Z DM.EnterpriseGateway d6a4fb54-a49f-4981-b4ef-afea34664db5 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:38.2979696Z DM.EnterpriseGateway 626f40d3-4e86-4bce-8c7d-f1ecf40a41aa 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:38.4542257Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:38.5948260Z DM.EnterpriseGateway 530147fd-a2e8-4ce8-a5e3-f5a46dc6bbee 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 9BE2A3E3 [DataMovement.PipeLine.MashupCommon] Setting mashup connection test connection properties
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:38.7823045Z DM.EnterpriseGateway d6a4fb54-a49f-4981-b4ef-afea34664db5 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 9BE2A3E3 [DataMovement.PipeLine.MashupCommon] Setting mashup connection test connection properties
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:38.9229547Z DM.EnterpriseGateway 626f40d3-4e86-4bce-8c7d-f1ecf40a41aa 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 9BE2A3E3 [DataMovement.PipeLine.MashupCommon] Setting mashup connection test connection properties
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:39.0635726Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:39.2510547Z DM.EnterpriseGateway 530147fd-a2e8-4ce8-a5e3-f5a46dc6bbee 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 488F6D1B [DataMovement.PipeLine.GatewayDataAccess] EncryptedConnection state = False for datasource <pi>{"kind":"SQL","path":"semotec-c1490;MISOnline"}</pi>
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:39.3916782Z DM.EnterpriseGateway d6a4fb54-a49f-4981-b4ef-afea34664db5 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 488F6D1B [DataMovement.PipeLine.GatewayDataAccess] EncryptedConnection state = False for datasource <pi>{"kind":"SQL","path":"semotec-c1490;MISOnline"}</pi>
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:39.5479303Z DM.EnterpriseGateway 626f40d3-4e86-4bce-8c7d-f1ecf40a41aa 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 488F6D1B [DataMovement.PipeLine.GatewayDataAccess] EncryptedConnection state = False for datasource <pi>{"kind":"SQL","path":"semotec-c1490;MISOnline"}</pi>
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:39.6729589Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:40.2980157Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:40.4541907Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:40.5948374Z DM.EnterpriseGateway de8054b1-853d-46e7-aafc-157e3e0ee2c1 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:40.7666911Z DM.EnterpriseGateway 4520d7ef-6ac2-42d9-8df7-4e88f61f219d 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGPS 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:40.7666911Z DM.EnterpriseGateway 75e2c555-6553-48bb-bcab-819c9dc35f91 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:40.9229441Z DM.EnterpriseGateway 4520d7ef-6ac2-42d9-8df7-4e88f61f219d 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGPS 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:40.9854625Z DM.EnterpriseGateway 48ce19a6-ff20-4c05-9f15-df7407652eaf 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGPP 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 790DCB0B [DM.GatewayCore] Cleaning up 0 outstanding packets for spooled job ada4c2b6-f991-41bb-84e9-4204eee09041 for state transition to Closed
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:41.0948187Z DM.EnterpriseGateway 75e2c555-6553-48bb-bcab-819c9dc35f91 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:41.2666952Z DM.EnterpriseGateway bcc84da7-24bd-4d00-99bc-dc5f19b2d59a 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGOC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:41.5480209Z DM.EnterpriseGateway 75e2c555-6553-48bb-bcab-819c9dc35f91 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:41.7042376Z DM.EnterpriseGateway bcc84da7-24bd-4d00-99bc-dc5f19b2d59a 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGOC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:41.8448398Z DM.EnterpriseGateway 75e2c555-6553-48bb-bcab-819c9dc35f91 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 9BE2A3E3 [DataMovement.PipeLine.MashupCommon] Setting mashup connection test connection properties
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.0010837Z DM.EnterpriseGateway bcc84da7-24bd-4d00-99bc-dc5f19b2d59a 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGOC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.1573288Z DM.EnterpriseGateway 75e2c555-6553-48bb-bcab-819c9dc35f91 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 488F6D1B [DataMovement.PipeLine.GatewayDataAccess] EncryptedConnection state = False for datasource <pi>{"kind":"SQL","path":"semotec-c1490;MISOnline"}</pi>
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.2823594Z DM.EnterpriseGateway bcc84da7-24bd-4d00-99bc-dc5f19b2d59a 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGOC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.4229813Z DM.EnterpriseGateway a291dcf7-0cb1-4e5c-b0da-bea5d9e9353f 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.4229813Z DM.EnterpriseGateway 55366ee2-0f96-46de-b85b-f3280b2e07ae 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.4229813Z DM.EnterpriseGateway 6ceff720-a3e8-44a9-ad7f-1dc3114cf88a 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.5635831Z DM.EnterpriseGateway 3eb3036e-bc48-4353-aa61-29f40f29c36c 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGGC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.6885825Z DM.EnterpriseGateway 038f632c-b414-4e14-beef-ad89f93083a6 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGPP 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e 21D28673 [DM.GatewayCore] Deserialized ExecuteQueryRequest, executing
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.6885825Z DM.EnterpriseGateway a291dcf7-0cb1-4e5c-b0da-bea5d9e9353f 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2018-09-01T12:11:42.8292119Z DM.EnterpriseGateway 55366ee2-0f96-46de-b85b-f3280b2e07ae 5868ba4b-6fda-4d71-b8a4-b13e3631e76e MGCC 46ed5d50-72b2-41d3-8ea8-5280ce56bb5e B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull

[v-qiuyu-msft]

Hi @micen,

Please share the whole gateway log files around the time issue occurs and share them with us: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting

Best Regards,
Qiuyun Yu 

[micen]

Hi.

I dont see any button to be able to share the logs here so I mailed you them with a replymail, did you get the logs?

Many Thanks

Micael

[micen]

How could I upload the logs to you?

Best Regards

Micael

[v-qiuyu-msft]

Hi @micen,

You can upload log files to your OneDirve and send the link to me via private message. 

Best Regards,
Qiuyun Yu 

[micen]

Hi Quiyun Yu.

I have now sent you private message with onedrive link to our log-files.

Many thanks

Micael

[micen]

Hi Quiyun Yu.

I have now sent you private message with onedrive link new logfiles and one picture from GDW.

Many thanks

Micael

[v-qiuyu-msft]

Hi @micen,

After looking into the log with RequestID 0b53ebfc-a450-4f7b-abbc-d9dd5db71ea6, I found this error: 

Failed to read GatewayCore property: EnableFastCombine, Ex: Object reference not set to an instance of an object. As you are using the on-premise data gateway, I would suggest you set the same privacy level for all data sources used in the dataset in data gateway. 

If the issue persists, I would suggest you create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu 

[micen]

Hi Quiyun Yu.

Many thanks, we havn't changed anything but for the 3 last days the refresh by schedule works perfekt again, aganinst this datasource.

many thanks

Micael Carlsson

[v-qiuyu-msft]

Hi @micen,

Glad to hear the issue is gone. If the same issue occurs next time, please create a support ticket as suggested to get support. 

Best Regards,
Qiuyun Yu