Solved

could not retrieve Enterprise Global Template Project Server 2010

Posted on 2010-08-26
12
2,805 Views
Last Modified: 2013-11-15
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
0
Comment
Question by:sparksolutions
  • 6
  • 5
12 Comments
 
LVL 2

Expert Comment

by:hrishikeshd
ID: 33603371
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
0
 

Author Comment

by:sparksolutions
ID: 33604197
this tool is for 2007 is there a similar one for 2010?
0
 
LVL 2

Expert Comment

by:hrishikeshd
ID: 33604211
yes it works with 2010
0
 

Author Comment

by:sparksolutions
ID: 33604275
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.
 
0
 
LVL 2

Expert Comment

by:hrishikeshd
ID: 33604292
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

0
 

Author Comment

by:sparksolutions
ID: 33604338
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
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 2

Expert Comment

by:hrishikeshd
ID: 33604347
Could you please provide me the complete error message.

0
 

Author Comment

by:sparksolutions
ID: 33604358
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.
 
0
 
LVL 2

Expert Comment

by:hrishikeshd
ID: 33604361
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
0
 

Author Comment

by:sparksolutions
ID: 33605603
EGlobal 2
0
 
LVL 2

Expert Comment

by:hrishikeshd
ID: 33624904
Type 2 indicates its E-global, try to reproduce the issue on server its self and different system
0
 
LVL 35

Accepted Solution

by:
Bembi earned 500 total points
ID: 33704218
As I remember, I had the same error after confirming to take over the global settings from project 2007

I deleted the MS Project profile from my user profile directory.
(C:\Users\[username]\AppData\Roaming\Microsoft\MS Project\14 or corresponding in XP)
MS Project asks again to take over settings.
Deny this.
And it worked fine.

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now