Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Error on updating data postgres gateway

I've got an issue with updating my data from postgres with an enterprise gateway. The gateway is online and functioning. The user has the required rights. What can be the issue? See error below.

 

Laatste poging voor vernieuwen is mislukt: Wed Nov 15 2017 10:20:22 GMT+0100
Er is een fout opgetreden in de data gateway.Details verbergen
URI cluster:    WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activiteits-id:    942798a1-7ae1-4384-ac48-bd501c3699c6
Aanvraag-id:    d4aa3567-e29d-489d-94ef-ede9268f3c3f
Tijd:    2017-11-15 09:20:22Z

Status: New
Comments
v-jiascu-msft
Employee

Hi @Cobra,

 

1. Please upgrade the Gateway to the latest version 14.16.6480.1. 

2. What is error message exactly? Can you share the gateway log?

3. Can you refresh it in the Desktop?

 

Best Regards!

Dale 

Cobra
New Member

1. I updated to the latest version, altough I do not think this will make a difference since I updated the gateway about 2 weeks ago.

2. What is the easiest way to share the log for you? I copied a part of the log below, but I'm not sure if this is what you need. I'm also not sure if this is the correct part of the log since I tested may things last few days.

3. In the desktop version I can refresh the data when using the direct postgres database connection source type.

 

DM.EnterpriseGateway Information: 0 : 2017-11-14T12:22:09.4824943Z DM.EnterpriseGateway    a56bd771-161b-4117-984c-224bdd56fbdd    a39a97d5-a7f1-4d2e-b58b-074a91407120    MGCC    6454a4af-37c8-422f-a8aa-8fc428a9d97d    BACC283B [DataMovement.PipeLine.GatewayDataAccess] EncryptedConnection state = False for datasource {"kind":"PostgreSQL","path":"dccobapp02;deenk"}

Cobra
New Member

@v-jiascu-msft: do you know a solution for this problem? Would be great if you can help us with this. If neccessary I can send you a wetransfer link with the latest complete logfile.

v-jiascu-msft
Employee

Hi @Cobra,

 

The best choice is creating a support ticket here.

You still can troubleshoot the issue as this documentation guides.

If you can share you logs, I will try my best to help. You can send me the download link using Private message.

 

Best Regards,

Dale