topic Re: On-prem data GW keeps creating junk files on C-drive in Report Server

On-prem data GW keeps creating junk files on C-drive

henrik_nordling — Mon, 08 Jan 2018 06:47:51 GMT

After installing a new PBI On-prem data GW 14.16.6549.2 junk files and folder a created on the C-drive

Example of folders names:

+360YjLX+XPUzmDSeJ+tr8t3XOXDiJvuh0OYpY69Bw=

+LdWMP+iqbr+5doyd1DZiiFYd1OknhyH6F1m4YyHoo=

+LtLM+aswqVWoa85K8onvUPgm78aexj4gx9VzlwGCM=

and so on.

About 10-20 new folders are created every day, and I really have to concentrate when cleaning them out so that the windows folder among others do not get removed!

Within the folders, I find the exact same structure:

Index - empty folder

Temp - empty folder

Cache.Key - file

I have two other gateway installations NOT doing this, and I cant find anything in the logs explaining why those folders are created. I know it is the GW creating them because file owner is local account "PBIEgwService".

Fist step would of course be to reinstall the gw but it runs a bounch data sources in a global company with a number of credentials, so the task of re-installing is quite excensive. And so I dont really like to do it if unnessesary.

Re: On-prem data GW keeps creating junk files on C-drive

karlstrom — Tue, 02 Jan 2018 16:32:09 GMT

I'm experiencing the exact same problem, this started 20/12 for me. I'm running Windows Server 2012 R2 and Gateway version 14.16.6524.1

Re: On-prem data GW keeps creating junk files on C-drive

v-qiuyu-msft — Wed, 03 Jan 2018 09:47:57 GMT

@henrik_nordling @karlstrom Would you please share the path of these "junk" folders? I didn't find them in this path C:\Program Files\On-premises data gateway. Thanks.

Best Regards,
Qiuyun Yu

Re: On-prem data GW keeps creating junk files on C-drive

karlstrom — Wed, 03 Jan 2018 09:53:44 GMT

@v-qiuyu-msft The folders are located at the root of C:-drive. Here's a pitcure from the server.

Re: On-prem data GW keeps creating junk files on C-drive

MarcinBajda — Mon, 08 Jan 2018 16:13:03 GMT

I have faced the same problem.

On both servers where I have Gateways installed.
The same version as Yours (last one I thing).

Creating the gateway from scratch does not helped.

Changing service account to AD account either.

It looks very bad, IT departmet was warried that we have ransomware... 😞

I think that maybe post should be in "Service" part of forum not here...

Re: On-prem data GW keeps creating junk files on C-drive

MarcinBajda — Tue, 09 Jan 2018 07:38:27 GMT

I have found in Windows log Error Events appeared at the same time that the folders ware created:

A fatal alert was generated and sent to the remote endpoint. This may result in termination of the connection. The TLS protocol defined fatal error code is 48. The Windows SChannel error state is 552.

Next after this:
The certificate received from the remote server was issued by an untrusted certificate authority. Because of this, none of the data contained in the certificate can be validated. The SSL connection request has failed. The attached data contains the server certificate.

There is a lot of errors like that in System Log and not all of them correspond to created folders but MAYBE it is connected with SSL/TLS topic?

Re: On-prem data GW keeps creating junk files on C-drive

henrik_nordling — Tue, 09 Jan 2018 08:46:19 GMT

MarcinBajda, I have a lot of Schannel, event id 36882 messages on the server too.

I totally agree, it could be related to the problem... not really sure how to fix that though. I have sent the info to a collegue that has more knowledget about the certs.

Re: On-prem data GW keeps creating junk files on C-drive

karlstrom — Tue, 09 Jan 2018 08:58:46 GMT

My event log looks the same. A bunch of Event ID

36888: "A fatal alert was generated and sent to the remote endpoint. This may result in termination of the connection. The TLS protocol defined fatal error code is 48. The Windows SChannel error state is 552."

36882: "The certificate received from the remote server was issued by an untrusted certificate authority. Because of this, none of the data contained in the certificate can be validated. The SSL connection request has failed. The attached data contains the server certificate."

Re: On-prem data GW keeps creating junk files on C-drive

MarcinBajda — Tue, 09 Jan 2018 08:59:21 GMT

Thanks for confirmation 😉

I hope someone from Microsoft (especially "Gateway Team") would get intrested in the topic...

I think that better place for the topic is:
Integrations with Files and Services

Re: On-prem data GW keeps creating junk files on C-drive

henrik_nordling — Tue, 09 Jan 2018 09:06:10 GMT

Do you have a post there @MarcinBajda? If so, we can help to create some activity around the topic...

Re: On-prem data GW keeps creating junk files on C-drive

MarcinBajda — Tue, 09 Jan 2018 09:24:32 GMT

No, normally it is not a good idea to duplicate conversations.
Maybe Admin/Moderator can move this topic...?

Re: On-prem data GW keeps creating junk files on C-drive

karlstrom — Tue, 09 Jan 2018 09:32:44 GMT

It would be nice to have some sort of life sign from a admin/moderator to know they are working on the problem!

Re: On-prem data GW keeps creating junk files on C-drive

henrik_nordling — Fri, 12 Jan 2018 07:02:52 GMT

No sign of of life from any one on the MS-team... time for a bump is think.

Re: On-prem data GW keeps creating junk files on C-drive

karlstrom — Tue, 16 Jan 2018 12:17:56 GMT

Can a moderator PLEASE respond to this thread as it's still a problem for us.

Re: On-prem data GW keeps creating junk files on C-drive

MarcinBajda — Tue, 16 Jan 2018 13:33:11 GMT

I have created "New Idea" in issues, please support it 🙂
Idea to SUPPORT 🙂

Re: On-prem data GW keeps creating junk files on C-drive

jhills — Tue, 16 Jan 2018 17:19:44 GMT

I am experiencing the same issue.

I checked and PBIEgwSerice has permissions to create but not to delete in the root of the C drive. I think that is why folders are being created and not cleaned up. But should it be using the root of C to store refresh cache data? Does anyone know where the path for storing refresh cache data is at? Registry entry? Config file? Wondering if that was corrupted during the install maybe.

Are others with this issue running the service under PBIEgwService or a different user? And does that user have permission to delete in the root of the C drive?

Re: On-prem data GW keeps creating junk files on C-drive

karlstrom — Wed, 17 Jan 2018 07:15:19 GMT

That sounds like a good insight because this started for me some days after I upgraded the gateway on the server and changed from a AD-user to PBIEgwService on the service.

I'm going to move the gateway to a new server, not sure whether I'm going to run it as the PBIEgwService or an AD-user. I'll let you know the result anyway.

Re: On-prem data GW keeps creating junk files on C-drive

MarcinBajda — Wed, 17 Jan 2018 10:32:59 GMT

When I first saw that happened I reset the password for PBIEgwService and next decided to change default account.
I have created new AD account and setup the service to use it.

It changed anything 😞
Folders are still created on C drive.

Re: On-prem data GW keeps creating junk files on C-drive

henrik_nordling — Wed, 17 Jan 2018 11:18:11 GMT

Ok, that´s god information. Have to tried also granting the active directory account full permission on C-drive to see if it deletes the folders?

Dont think that is a good solution, but would be really good to know...

Re: On-prem data GW keeps creating junk files on C-drive

powerbishiiiit — Wed, 17 Jan 2018 12:41:23 GMT

We have same issue. Is there a option to set different cache folder and not C directly ?