While testing a new installation of BPC, I encounter an error processing an Application:
Cannot find the object “ApShellExtra.dbo.AuditActivityHdrApShell” because it does not exist or you do not have permissions.
Sure enough SQL Server Management Studio shows the table is not there. On a whim I restart the Admin client and try processing the Application again; it works!?
Turns out, after the install I always modify security to allow the BPCSysAdmin account to have full control over ApShell. Apparently those security changes weren’t completely applied until I restarted.