PSDBOWNER and Why I Can't Login to my New Database

We copied our upgrade database to our development backup database this morning. I had to apply about 13 bundles to the upgrade database to get it current on maintenance.

The next step is to copy the customizations from our dev database into our dev backup database. But this morning after the dev backup database was created, I couldn't login to it using App Designer, even though I could login using the same userid and password to the upgrade database (from which dev backup was a copy).

Does anyone know where this is going? Well, I'm sort of new to PeopleSoft, so I was bordering on the verge of panic, but I found someone else on our staff who has been doing PeopleSoft for a long time.

He said, "Did you update the DBOWNER table?"

And that's all it was. The PS.PSDBOWNER.DBNAME still had the name of the upgrade database in it. Once I updated that, I was able to login and do a compare between the dev and dev backup databases.

To perform a full database compare

1. In App Designer, select Tools->Compare and Report->To Database
   
2. Specify the database in the login dialog and wait for all the permission lists, etc. to load.
   
3. When the Compare and Report Dialog comes up, click the Options button.
   
4. When the Upgrade Options dialog comes up, click on the Compare Options tab.
   
5. In the Compare Type area of the Compare Options tab, click the Database radio button.

A full database compare takes a long time.

Now I'm just waiting for my compare report to run...