How to force check in of "Enterprise Global" object?

J

jpa

Hi,
I really need your help!

I use MS Project Server 2007.
"Enterprise Global" has been checked out in the past and seems that it has
not been cheked in.
When I or the Administrator tries to open "Enterprise Global" from Project
Pro (Tools->Enterprise Options->Open Enterprise Global" we have following
error message
<The enterprise global file cannot be checked out.
You cannot check out the enterprise global as it is already checked out to .>
This is my first problem.
Note that NO USER NAME is precised! How this can be possible?

Then after searching within present discussion group, I found out that
Administrator can force Check In Enterprise Objects thru "Server
Setting->Force Check-in Enterprise Objects" but here comes my second problem:
I have the following Error message:
<System.Web.Services.Protocols.SoapException: ProjectServerError(s)
LastError=GeneralUnhandledException Instructions: Pass this into
PSClientError constructor to access all error information at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects()
Troubleshoot issues with Windows SharePoint Services.>
I suspect wrong configuration of SharePoint Services...
From "SharePoint 3.0 Central Administration" following services are running:
- Central Administration
- Project Application Service
- Windows SharePoint Services Database
- Windows SharePoint Services Incoming E-Mail
- Windows SharePoint Services Search
- Windows SharePoint Services Web Application
Any ideas?

Thanks for your help regarding above 2 problems.
jpa
 
O

Owe Evans

Don't know the reason for you not beeing able to force checkin Enterprise
Global but you could go ahead and check for
AdminReadCheckedOutEnterpriseProjects() in ULS logs (c:\program files\common
files\Microsoft shared\Web server extensions\12\LOGS) and of course if there
are something useful in Server Settings - Manage Queue.
Good luck!
/Owe
 
A

Aparna Raj

As Owe has mentioned, Manage Queue is the best place. I had similar case but
not the exact problem where my project was stuck in queue and it would not
let me force check in and sent a SoapException.

Try the following for each selection of filter type and you will spot the
exact process which is failing.

Job Types: Select All Jobs
Job Completion States: Select all except Success
Advanced Options: Select both of them

Click Refresh Status.
If you spot the right Job Type Select all and click Cancel Jobs.

Now open another window and force check in the process/project.
Open the Manage Queue screen with default settings and try to find your job
and see if it is checked in successfully.

Hope this helps.
 
J

jpa

Thanks for your answers

Manage Queue doesn't give fruitfull information since there is only jobs
finished with sucess status. But as "Cleanup Age Limit For Non-Successful
Jobs" is set to 168 hours (ie 7 days) I am quite sure that jobs which creates
the problem had been is older than 7 days and it has been purged!

So how to proceed further?

As suggested by Owe I indeed found some information within ULS logs, here is
the sequence I extracted (sorry for long text but it may be useful to have
completes logs to better understand)
<
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
Project Server Project Server - General 0 Exception
Exception occurred in method PWA.AdminReadCheckedOutEnterpriseProjects
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.Office.Project.Server.BusinessLayer.Admin.ReadCheckedOutEnterpriseProjects()
at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects() 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pbe High
reporting Exception for tag 0000, level:
3 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service
8pat Monitorable
Watson collection started: Office SharePoint Server, ULSException12,
w3wp.exe, 6.0.3790.3959, 45d6968e, Microsoft.Office.Project.Server,
12.0.4518.0, 454185f3, 2426, 359, IndexOutOfRangeException,
0000 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pav High
Begin collecting minidump 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8paw High
Done collecting minidump 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pax High
Begin collecting heap 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb9 High
No heap data collected 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb1 High
Begin collecting CVR 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb2 High
Done collecting CVR 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb3 High
Begin collecting trace log 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x131C) 0x13D0
Project Server Project Server - General 8mqg Exception
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: ProjectServerError(s)
LastError=GeneralUnhandledException Instructions: Pass this into
PSClientError constructor to access all error information at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects()
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
Microsoft.Office.Project.Server.WebServiceProxy.PSIProxyBase.InvokePSI(String
serviceName, String methodName, Object[] parameters)
03/06/2008 13:42:19.31 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb4 High
Done collecting trace log 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.31 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb7 High
About to launch Watson client 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb8 High
Watson collection complete. 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x1548) 0x15F4
Project Server Project Server - General 0 Medium
PWA:http://myServer/PWA, SSP:SharedServices1,
User:MYSERVER\myAdmininistrator, PSI:
PWA.AdminReadCheckedOutEnterpriseProjects Undefined Attributes: PSError:
GeneralUnhandledException Undefined attributes list:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.Office.Project.Server.BusinessLayer.Admin.ReadCheckedOutEnterpriseProjects()
at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects() 8d0c6ba1-e48d-4022-816a-50a319402bda
It seems to me that there is corrupted data ("Index was outside the bounds
of the array").
This may also explained why there is NO USER NAME within error message when
trying to access "Enterprise Global" object...

I really wait for your expert advice to recover from this situation.
Would it be possible to look at some table somewhere to check data integrity?
Thanks in advance for your replies.
jpa
 
O

Owe Evans

Jpa! Since the Queue log is lost I see the problem to get to the root cause.
Have you tried to open eGlobal in Project Pro (inspite the error message)
and re-checkin it (save)? Will this give any useful information in queue log?

Found a post with this errormessage at:
http://www.eggheadcafe.com/software/aspnet/30815644/error--force-checkin-en.aspx
Unfortunately I cannot help you on how the proposed solution.

FYI - the "Force-checkin" command is not a "brute force" - just a "please
try to checkin". It wouldn't get past an underlying error ...

/Owe

jpa said:
Thanks for your answers

Manage Queue doesn't give fruitfull information since there is only jobs
finished with sucess status. But as "Cleanup Age Limit For Non-Successful
Jobs" is set to 168 hours (ie 7 days) I am quite sure that jobs which creates
the problem had been is older than 7 days and it has been purged!

So how to proceed further?

As suggested by Owe I indeed found some information within ULS logs, here is
the sequence I extracted (sorry for long text but it may be useful to have
completes logs to better understand)
<
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
Project Server Project Server - General 0 Exception
Exception occurred in method PWA.AdminReadCheckedOutEnterpriseProjects
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.Office.Project.Server.BusinessLayer.Admin.ReadCheckedOutEnterpriseProjects()
at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects() 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pbe High
reporting Exception for tag 0000, level:
3 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service
8pat Monitorable
Watson collection started: Office SharePoint Server, ULSException12,
w3wp.exe, 6.0.3790.3959, 45d6968e, Microsoft.Office.Project.Server,
12.0.4518.0, 454185f3, 2426, 359, IndexOutOfRangeException,
0000 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pav High
Begin collecting minidump 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8paw High
Done collecting minidump 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pax High
Begin collecting heap 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb9 High
No heap data collected 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb1 High
Begin collecting CVR 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb2 High
Done collecting CVR 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb3 High
Begin collecting trace log 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x131C) 0x13D0
Project Server Project Server - General 8mqg Exception
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: ProjectServerError(s)
LastError=GeneralUnhandledException Instructions: Pass this into
PSClientError constructor to access all error information at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects()
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
Microsoft.Office.Project.Server.WebServiceProxy.PSIProxyBase.InvokePSI(String
serviceName, String methodName, Object[] parameters)
03/06/2008 13:42:19.31 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb4 High
Done collecting trace log 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.31 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb7 High
About to launch Watson client 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb8 High
Watson collection complete. 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x1548) 0x15F4
Project Server Project Server - General 0 Medium
PWA:http://myServer/PWA, SSP:SharedServices1,
User:MYSERVER\myAdmininistrator, PSI:
PWA.AdminReadCheckedOutEnterpriseProjects Undefined Attributes: PSError:
GeneralUnhandledException Undefined attributes list:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.Office.Project.Server.BusinessLayer.Admin.ReadCheckedOutEnterpriseProjects()
at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects() 8d0c6ba1-e48d-4022-816a-50a319402bda
It seems to me that there is corrupted data ("Index was outside the bounds
of the array").
This may also explained why there is NO USER NAME within error message when
trying to access "Enterprise Global" object...

I really wait for your expert advice to recover from this situation.
Would it be possible to look at some table somewhere to check data integrity?
Thanks in advance for your replies.
jpa

Aparna Raj said:
As Owe has mentioned, Manage Queue is the best place. I had similar case but
not the exact problem where my project was stuck in queue and it would not
let me force check in and sent a SoapException.

Try the following for each selection of filter type and you will spot the
exact process which is failing.

Job Types: Select All Jobs
Job Completion States: Select all except Success
Advanced Options: Select both of them

Click Refresh Status.
If you spot the right Job Type Select all and click Cancel Jobs.

Now open another window and force check in the process/project.
Open the Manage Queue screen with default settings and try to find your job
and see if it is checked in successfully.

Hope this helps.
 
J

jpa

Thanks Owe for your help

Each time I try to open Enterprise global I got the error message
<The enterprise global file cannot be checked out.
You cannot check out the enterprise global as it is already checked out to .>
and then open operation aborts... (ie comes back to project pro).

In the link you posted the guy indicates
<Turns out that the eGlobal template was stuck in checked out "state"
Checking in the template (deleting the checked out field in the database
table) solved the problem.....>
So seems that it is feasible to directly modify "database table".
Is there anybody who knows
- in which database table?
- or how to find said database table?

Thanks again for your helpful indications
jpa


Owe Evans said:
Jpa! Since the Queue log is lost I see the problem to get to the root cause.
Have you tried to open eGlobal in Project Pro (inspite the error message)
and re-checkin it (save)? Will this give any useful information in queue log?

Found a post with this errormessage at:
http://www.eggheadcafe.com/software/aspnet/30815644/error--force-checkin-en.aspx
Unfortunately I cannot help you on how the proposed solution.

FYI - the "Force-checkin" command is not a "brute force" - just a "please
try to checkin". It wouldn't get past an underlying error ...

/Owe

jpa said:
Thanks for your answers

Manage Queue doesn't give fruitfull information since there is only jobs
finished with sucess status. But as "Cleanup Age Limit For Non-Successful
Jobs" is set to 168 hours (ie 7 days) I am quite sure that jobs which creates
the problem had been is older than 7 days and it has been purged!

So how to proceed further?

As suggested by Owe I indeed found some information within ULS logs, here is
the sequence I extracted (sorry for long text but it may be useful to have
completes logs to better understand)
<
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
Project Server Project Server - General 0 Exception
Exception occurred in method PWA.AdminReadCheckedOutEnterpriseProjects
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.Office.Project.Server.BusinessLayer.Admin.ReadCheckedOutEnterpriseProjects()
at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects() 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pbe High
reporting Exception for tag 0000, level:
3 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service
8pat Monitorable
Watson collection started: Office SharePoint Server, ULSException12,
w3wp.exe, 6.0.3790.3959, 45d6968e, Microsoft.Office.Project.Server,
12.0.4518.0, 454185f3, 2426, 359, IndexOutOfRangeException,
0000 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:16.24 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pav High
Begin collecting minidump 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8paw High
Done collecting minidump 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pax High
Begin collecting heap 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb9 High
No heap data collected 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb1 High
Begin collecting CVR 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb2 High
Done collecting CVR 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.28 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb3 High
Begin collecting trace log 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x131C) 0x13D0
Project Server Project Server - General 8mqg Exception
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: ProjectServerError(s)
LastError=GeneralUnhandledException Instructions: Pass this into
PSClientError constructor to access all error information at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects()
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
Microsoft.Office.Project.Server.WebServiceProxy.PSIProxyBase.InvokePSI(String
serviceName, String methodName, Object[] parameters)
03/06/2008 13:42:19.31 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb4 High
Done collecting trace log 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.31 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb7 High
About to launch Watson client 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x1548) 0x15F4
ULS Logging Unified Logging Service 8pb8 High
Watson collection complete. 8d0c6ba1-e48d-4022-816a-50a319402bda
03/06/2008 13:42:19.40 w3wp.exe (0x1548) 0x15F4
Project Server Project Server - General 0 Medium
PWA:http://myServer/PWA, SSP:SharedServices1,
User:MYSERVER\myAdmininistrator, PSI:
PWA.AdminReadCheckedOutEnterpriseProjects Undefined Attributes: PSError:
GeneralUnhandledException Undefined attributes list:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.Office.Project.Server.BusinessLayer.Admin.ReadCheckedOutEnterpriseProjects()
at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects() 8d0c6ba1-e48d-4022-816a-50a319402bda
It seems to me that there is corrupted data ("Index was outside the bounds
of the array").
This may also explained why there is NO USER NAME within error message when
trying to access "Enterprise Global" object...

I really wait for your expert advice to recover from this situation.
Would it be possible to look at some table somewhere to check data integrity?
Thanks in advance for your replies.
jpa

Aparna Raj said:
As Owe has mentioned, Manage Queue is the best place. I had similar case but
not the exact problem where my project was stuck in queue and it would not
let me force check in and sent a SoapException.

Try the following for each selection of filter type and you will spot the
exact process which is failing.

Job Types: Select All Jobs
Job Completion States: Select all except Success
Advanced Options: Select both of them

Click Refresh Status.
If you spot the right Job Type Select all and click Cancel Jobs.

Now open another window and force check in the process/project.
Open the Manage Queue screen with default settings and try to find your job
and see if it is checked in successfully.

Hope this helps.



:

Don't know the reason for you not beeing able to force checkin Enterprise
Global but you could go ahead and check for
AdminReadCheckedOutEnterpriseProjects() in ULS logs (c:\program files\common
files\Microsoft shared\Web server extensions\12\LOGS) and of course if there
are something useful in Server Settings - Manage Queue.
Good luck!
/Owe

:

Hi,
I really need your help!

I use MS Project Server 2007.
"Enterprise Global" has been checked out in the past and seems that it has
not been cheked in.
When I or the Administrator tries to open "Enterprise Global" from Project
Pro (Tools->Enterprise Options->Open Enterprise Global" we have following
error message
<The enterprise global file cannot be checked out.
You cannot check out the enterprise global as it is already checked out to .>
This is my first problem.
Note that NO USER NAME is precised! How this can be possible?

Then after searching within present discussion group, I found out that
Administrator can force Check In Enterprise Objects thru "Server
Setting->Force Check-in Enterprise Objects" but here comes my second problem:
I have the following Error message:
<System.Web.Services.Protocols.SoapException: ProjectServerError(s)
LastError=GeneralUnhandledException Instructions: Pass this into
PSClientError constructor to access all error information at
Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects()
Troubleshoot issues with Windows SharePoint Services.>
I suspect wrong configuration of SharePoint Services...
From "SharePoint 3.0 Central Administration" following services are running:
- Central Administration
- Project Application Service
- Windows SharePoint Services Database
- Windows SharePoint Services Incoming E-Mail
- Windows SharePoint Services Search
- Windows SharePoint Services Web Application
Any ideas?

Thanks for your help regarding above 2 problems.
jpa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top