Unable to access to the "Force Check-in Enterprise Objects

R

Ricardo Caldas

Hi,

I'm using Project Server 2007 integrated with MOSS 2007, and after a
front-end server migration, I was unable to access to the "Force Check-in
Enterprise Objects ".

That was the error that appears to me:
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()

In the event log is this the error text:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 01-04-2009
Time: 17:41:16
User: N/A
Computer: <SERVER NAME>
Description:
Standard Information:ponto de Entrada de PSI:
PWA.AdminReadCheckedOutEnterpriseProjects
Utilizador do Project: <domain\account>
ID de Correlação: 7643c5e1-3b81-489a-865e-2ec630da54c4
URL do Site de PWA: http://<site name>/PWA
Nome de SSP: SSPGeral
PSErro: Success (0)
Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Procedure
or function 'MSP_ProjQ_Get_Status_Of_Jobs_List' expects parameter
'@wantJobsQLS', which was not supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand)
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet
typedDataSet, String[] tables, String storedProcedureName, SqlParameter[]
parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.GetStatusOfJobsList(String
prefix, String jobUIDList, String TrackingIDList, String jobInfoUIDList,
String resUIDList, String correlationUIDList, String msgTypeList, String
groupStateList, Boolean wantErrorInfo, Nullable`1 history, Nullable`1
startDate, Nullable`1 endDate, Nullable`1 rowLimit, Nullable`1 sortColumn,
Nullable`1 sortOrder)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.GetStatusOfJobsListSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Can anyone help me?

Thank you.
 
S

Sharath

Hi Ricardo,

Did you find any solution for this error? I am also facing the same problem.

Let me know

Thank you

Regards
Sharath

Ricardo Caldas said:
Hi,

I'm using Project Server 2007 integrated with MOSS 2007, and after a
front-end server migration, I was unable to access to the "Force Check-in
Enterprise Objects ".

That was the error that appears to me:
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()

In the event log is this the error text:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 01-04-2009
Time: 17:41:16
User: N/A
Computer: <SERVER NAME>
Description:
Standard Information:ponto de Entrada de PSI:
PWA.AdminReadCheckedOutEnterpriseProjects
Utilizador do Project: <domain\account>
ID de Correlação: 7643c5e1-3b81-489a-865e-2ec630da54c4
URL do Site de PWA: http://<site name>/PWA
Nome de SSP: SSPGeral
PSErro: Success (0)
Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Procedure
or function 'MSP_ProjQ_Get_Status_Of_Jobs_List' expects parameter
'@wantJobsQLS', which was not supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand)
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet
typedDataSet, String[] tables, String storedProcedureName, SqlParameter[]
parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.GetStatusOfJobsList(String
prefix, String jobUIDList, String TrackingIDList, String jobInfoUIDList,
String resUIDList, String correlationUIDList, String msgTypeList, String
groupStateList, Boolean wantErrorInfo, Nullable`1 history, Nullable`1
startDate, Nullable`1 endDate, Nullable`1 rowLimit, Nullable`1 sortColumn,
Nullable`1 sortOrder)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.GetStatusOfJobsListSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Can anyone help me?

Thank you.
Click to expand...
 
R

Ricardo Caldas

Untill now nothing. I will try to update the Wss and MOSS 2007 to SP2 and see
if it recovers from the problem.

Regards
 
R

Ricardo Caldas

Hi Sharath,

I finally resolve the problem. I update booth wss 3.0 and MOSS 2007 to SP2,
and the problem was resolved.

After I install de SP2 to wss 3.0 I run the wizard configuration and it
gives-me an upgrade error, I ignore it and install de SP2 to MOSS 2007 and
the upgrade was succeeded.

I strongly recommend you to follow the instructions to update.

See this post:
http://blogs.msdn.com/sharepoint/ar...2007-and-windows-sharepoint-services-3-0.aspx

Best regards.

Sharath said:
Hi Ricardo,

Did you find any solution for this error? I am also facing the same problem.

Let me know

Thank you

Regards
Sharath

Ricardo Caldas said:
Hi,

I'm using Project Server 2007 integrated with MOSS 2007, and after a
front-end server migration, I was unable to access to the "Force Check-in
Enterprise Objects ".

That was the error that appears to me:
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()

In the event log is this the error text:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 01-04-2009
Time: 17:41:16
User: N/A
Computer: <SERVER NAME>
Description:
Standard Information:ponto de Entrada de PSI:
PWA.AdminReadCheckedOutEnterpriseProjects
Utilizador do Project: <domain\account>
ID de Correlação: 7643c5e1-3b81-489a-865e-2ec630da54c4
URL do Site de PWA: http://<site name>/PWA
Nome de SSP: SSPGeral
PSErro: Success (0)
Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Procedure
or function 'MSP_ProjQ_Get_Status_Of_Jobs_List' expects parameter
'@wantJobsQLS', which was not supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand)
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet
typedDataSet, String[] tables, String storedProcedureName, SqlParameter[]
parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.GetStatusOfJobsList(String
prefix, String jobUIDList, String TrackingIDList, String jobInfoUIDList,
String resUIDList, String correlationUIDList, String msgTypeList, String
groupStateList, Boolean wantErrorInfo, Nullable`1 history, Nullable`1
startDate, Nullable`1 endDate, Nullable`1 rowLimit, Nullable`1 sortColumn,
Nullable`1 sortOrder)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.GetStatusOfJobsListSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Can anyone help me?

Thank you.
Click to expand...
Click to expand...
 
S

Sharath

Hi Ricardo,

Thanks a lot for your help!! It worked for me as well.

Regards
Sharath

Ricardo Caldas said:
Hi Sharath,

I finally resolve the problem. I update booth wss 3.0 and MOSS 2007 to SP2,
and the problem was resolved.

After I install de SP2 to wss 3.0 I run the wizard configuration and it
gives-me an upgrade error, I ignore it and install de SP2 to MOSS 2007 and
the upgrade was succeeded.

I strongly recommend you to follow the instructions to update.

See this post:
http://blogs.msdn.com/sharepoint/ar...2007-and-windows-sharepoint-services-3-0.aspx

Best regards.

Sharath said:
Hi Ricardo,

Did you find any solution for this error? I am also facing the same problem.

Let me know

Thank you

Regards
Sharath

Ricardo Caldas said:
Hi,

I'm using Project Server 2007 integrated with MOSS 2007, and after a
front-end server migration, I was unable to access to the "Force Check-in
Enterprise Objects ".

That was the error that appears to me:
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()

In the event log is this the error text:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 01-04-2009
Time: 17:41:16
User: N/A
Computer: <SERVER NAME>
Description:
Standard Information:ponto de Entrada de PSI:
PWA.AdminReadCheckedOutEnterpriseProjects
Utilizador do Project: <domain\account>
ID de Correlação: 7643c5e1-3b81-489a-865e-2ec630da54c4
URL do Site de PWA: http://<site name>/PWA
Nome de SSP: SSPGeral
PSErro: Success (0)
Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Procedure
or function 'MSP_ProjQ_Get_Status_Of_Jobs_List' expects parameter
'@wantJobsQLS', which was not supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand)
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet
typedDataSet, String[] tables, String storedProcedureName, SqlParameter[]
parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.GetStatusOfJobsList(String
prefix, String jobUIDList, String TrackingIDList, String jobInfoUIDList,
String resUIDList, String correlationUIDList, String msgTypeList, String
groupStateList, Boolean wantErrorInfo, Nullable`1 history, Nullable`1
startDate, Nullable`1 endDate, Nullable`1 rowLimit, Nullable`1 sortColumn,
Nullable`1 sortOrder)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.GetStatusOfJobsListSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Can anyone help me?

Thank you.
Click to expand...
Click to expand...
Click to expand...
 

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

Similar Threads

Error ID: 12005 Job Type: Save 1
save job failed & blocking with error: ActiveCacheQueuedMessageEx 1
PS 2007 SP1 - Save job failing, cancelling, and restarting at 7% 3
Cube Not Building 2
Another Error 7888 - (Stored Procedure) 0
Queue stuck due to arithmetic overflow 0
Exception when using PWA Services: MSP_SSP_UPDATE_ENTERPRISE_ENTIT 0
ACProjectSave failed 4

Top