I had been doing an upgrade from GP 10.0 SP2 to SP3. There was one weird error that happened and I thought I would share it and its resolution.
When I completed my GP SP3 installation and started GP Utilities to complete the upgrade and configuration, I was prompted to enter and confirm a password for the user DYNSA, as shown below:
Firstly, this should not have prompted because we would have already created a User called DYNSA, when we installed GP for the first time. I was quite a bit surprised, but continued with the wizard’s instructions to enter the password. The next wizard screen (screenshot below) was quite baffling:
If you see the screenshot clearly, you could see the Database Size 0MB and stuffs like that. This is something which clearly frustrated me. It should have ideally continued with SQL Objects upgrade and configuration.
I had to think a bit to finally link the DYNSA screenshot and the second one. I just guessed it right to check the Database Security Logins once, to confirm whether the DYNSA was actually created (or exist at all). And I was right, it never existed.
I created the DYNSA user as follows:
Then I relaunched GP Utilities. It went thru’ as expected.
Just one thing which never got clarified: Why in the world the DYNSA user was not created when I installed GP 10.0 on my laptop for the first time? And if it actually did, why and when did it get deleted from my Database Logins?
Well, I am still searching for an answer.