https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/694870#M37392 <P>I have an EG project with around 250 query builders (or other blocks) and noticed quite recently that the file size of the project started increasing rapidly with each version. With just small changes the size changed from 2 MB -&gt; 5 MB -&gt; 8 MB -&gt; 12 MB -&gt; . On the last 2 saves nothing was actually even changed but the project just was just saved without changes for testing purposes. By changing to file to .zip I was able to find out that EG had started generating up to 200 000 character long&nbsp;ExplicitPassthroughDBPassword-element in project.xml. This caused the bloated file size which in turn caused project opening time to increase into several minutes and prevented anyone but person who actually saved it from using it. I was able to fix this by extracting the project.xml file and erasing all&nbsp;ExplicitPassthroughDBPassword-values. The project worked as usually even though all these values were deleted. Saving the project again generated these values again, but now only as around 50 characters long. Apparently EG generates longer and longer values on each save so I suspect this will eventually happen again. Does anyone know how to prevent this?</P> Wed, 28 Oct 2020 14:14:56 GMT JoonaH 2020-10-28T14:14:56Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/694870#M37392 <P>I have an EG project with around 250 query builders (or other blocks) and noticed quite recently that the file size of the project started increasing rapidly with each version. With just small changes the size changed from 2 MB -&gt; 5 MB -&gt; 8 MB -&gt; 12 MB -&gt; . On the last 2 saves nothing was actually even changed but the project just was just saved without changes for testing purposes. By changing to file to .zip I was able to find out that EG had started generating up to 200 000 character long&nbsp;ExplicitPassthroughDBPassword-element in project.xml. This caused the bloated file size which in turn caused project opening time to increase into several minutes and prevented anyone but person who actually saved it from using it. I was able to fix this by extracting the project.xml file and erasing all&nbsp;ExplicitPassthroughDBPassword-values. The project worked as usually even though all these values were deleted. Saving the project again generated these values again, but now only as around 50 characters long. Apparently EG generates longer and longer values on each save so I suspect this will eventually happen again. Does anyone know how to prevent this?</P> Wed, 28 Oct 2020 14:14:56 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/694870#M37392 JoonaH 2020-10-28T14:14:56Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/694882#M37393 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/345701">@JoonaH</a>&nbsp;-- impressive sleuthing on your part!</P> <P>&nbsp;</P> <P>Have you reported this to SAS Tech Support? I think this should be tracked as a bug.</P> Wed, 28 Oct 2020 14:32:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/694882#M37393 ChrisHemedinger 2020-10-28T14:32:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/694996#M37398 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/345701">@JoonaH</a>&nbsp;- I'm curious to know which version of EG this is happening in. The latest is EG 8.2 Update 5.</P> Wed, 28 Oct 2020 19:21:48 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/694996#M37398 SASKiwi 2020-10-28T19:21:48Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/695102#M37405 Haven't done that yet, but yeah gotta do that Thu, 29 Oct 2020 06:28:05 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/695102#M37405 JoonaH 2020-10-29T06:28:05Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/695103#M37406 We are using version 8.1 Update 1 (8.1.1.4580) (64-bit) Thu, 29 Oct 2020 06:28:43 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/695103#M37406 JoonaH 2020-10-29T06:28:43Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/695123#M37408 Support was aware of this issue and it is fixed in EG 8.2.<BR />They also confirmed that editing project.xml by deleting ExplicitPassthroughDBPassword-values is the workaround for older versions Thu, 29 Oct 2020 09:53:48 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-generates-super-long-ExplicitPassthroughDBPassword/m-p/695123#M37408 JoonaH 2020-10-29T09:53:48Z