Link to home
Start Free TrialLog in
Avatar of sparksolutions
sparksolutions

asked on

could not retrieve Enterprise Global Template Project Server 2010

Hi I get the above error when trying to access Project Server 2010 via Project Professional 2010.

I can access PWA using the same account without any issues
Avatar of hrishikeshd
hrishikeshd
Flag of India image

Using ViewEffectiveRights tool check the Global Permission - Log on to Project Server From Project professional for user

http://technet.microsoft.com/en-us/library/cc197476(office.12).aspx
Avatar of sparksolutions
sparksolutions

ASKER

this tool is for 2007 is there a similar one for 2010?
yes it works with 2010
It shows me as being allowed as an adminsitrator.
the message it is giving when attempting to logon is:
Could not refrieve Enterprise global template.
There seems to be a problem with the database, please contact your server administrator.
 
E-Global is corrupt
Do you have the backup of E-Global?
Restore it if you have one
If you do not have a backup, you can re-create the global from scratch. WARNING:
This will delete all customizations the csutomer has made to their old global
template
Run eglobal.sql from following location

C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033

If you want you can take the backup of 4 DBs, provision another PWA and test the action plan

I ran the script, but I'm still getting the same problem.
It's a brand new installation. I managed to log in once, but not since
Could you please provide me the complete error message.

that is the complete one

Could not refrieve Enterprise global template.
There seems to be a problem with the database, please contact your server administrator.
 
Enterprise Global may have become inactive. To check this, run this query on
the ProjectServer_Published database:

SELECT PROJ_NAME, PROJ_TYPE FROM MSP_PROJECTS
WHERE PROJ_NAME LIKE '%eglobal%'


Let me know the result
EGlobal 2
Type 2 indicates its E-global, try to reproduce the issue on server its self and different system
ASKER CERTIFIED SOLUTION
Avatar of Bembi
Bembi
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial