All i have is the 4 Data bases

[Malik Al-Shayeb]

Dears
My IT team destroyed the virtual server that was running the Project
server 2007 and all they managed to do is to retrieve the Project
server databases Only that's all i have and now i have to restore the
Project server or at least retrieve the Plans .
i have tried to install project server on another machine and then to
provision a new PWA and replace the databases , that didn't work any
ideas ?

Best Regards

 

[Andre Venter]

Malik,

HI there ,

If the 4 databases that you have are all in sync, you should not have a
problem restoring and creating a new pwa instance from them. I think what
could be happening is the "Patch Levels" are out of sync between the old
server and new server.

Make sure that the new server is exactly on the same Service Pack and CU
level as the previous server, and then try again.

Next time if you post on here please be a bit more specific with the sever /
SP / Problem description. Post some event viewer logs, it will help us to
help you better.

Good Luck
--
Andre Venter
Technical Consultant
UMT South Africa
MCP
MCSE 2000
MCITP Project
MCTS Managing Projects
MCTS Confiuring Project Server
MCTS Charter Member
MCTS MOSS
MCITP Charter member

 

[Ben Howard]

Hi Malik,

Do the following. Restore the DBs into SQL server, eg
projectserver_published etc....
Then, provision an new instance, and type in the names of the previously
restored DBs. This should work.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

 

[Malik Al-Shayeb]

Dears
Thank you for the below is the exception i got when i try to open the
PWA after i replace the database and im trying to know what CU and SP
leave we had on the old server but i don't think that we can do that .


System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: Could not
find stored procedure 'MSP_ADMIN_GetDatabaseTimeout'.
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.ExecuteScalar()
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureScalar
(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.AdminDal.GetDatabaseTimeout
(DatabaseTimeoutType timeoutType)
at Microsoft.Office.Project.Server.Base.PlatformContext.PreInitialize
(Guid trackingId, Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(Boolean isWindowsUser, String username, Guid userId, Guid trackingId,
Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(IPSContextInfo psContextInfo)
at
Microsoft.Office.Project.Server.WebService.Utility.AuthenticateRequest
(HttpContext context)
at Microsoft.Office.Project.Server.WebService.Utility.GetContext()
at
Microsoft.Office.Project.Server.WebService.Authentication.GetUserByName
(Boolean isProjUser, String username)
--- End of inner exception stack trace ---
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: Could not
find stored procedure 'MSP_ADMIN_GetDatabaseTimeout'.
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.ExecuteScalar()
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureScalar
(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.AdminDal.GetDatabaseTimeout
(DatabaseTimeoutType timeoutType)
at Microsoft.Office.Project.Server.Base.PlatformContext.PreInitialize
(Guid trackingId, Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(Boolean isWindowsUser, String username, Guid userId, Guid trackingId,
Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(IPSContextInfo psContextInfo)
at
Microsoft.Office.Project.Server.WebService.Utility.AuthenticateRequest
(HttpContext context)
at Microsoft.Office.Project.Server.WebService.Utility.GetContext()
at
Microsoft.Office.Project.Server.WebService.Authentication.GetUserByName
(Boolean isProjUser, String username)
--- End of inner exception stack trace ---

 

[Andre Venter]

Malik,

Just to verify , you are using the same or newer version of SQL on the new
server. Have you tried restoring the way that Ben Howard mentioned. First
restore then create site based on restored DataBases
--
Andre Venter
Technical Consultant
UMT South Africa
MCP
MCSE 2000
MCITP Project
MCTS Managing Projects
MCTS Confiuring Project Server
MCTS Charter Member
MCTS MOSS
MCITP Charter member

Dears
Thank you for the below is the exception i got when i try to open the
PWA after i replace the database and im trying to know what CU and SP
leave we had on the old server but i don't think that we can do that .


System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: Could not
find stored procedure 'MSP_ADMIN_GetDatabaseTimeout'.
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.ExecuteScalar()
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureScalar
(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.AdminDal.GetDatabaseTimeout
(DatabaseTimeoutType timeoutType)
at Microsoft.Office.Project.Server.Base.PlatformContext.PreInitialize
(Guid trackingId, Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(Boolean isWindowsUser, String username, Guid userId, Guid trackingId,
Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(IPSContextInfo psContextInfo)
at
Microsoft.Office.Project.Server.WebService.Utility.AuthenticateRequest
(HttpContext context)
at Microsoft.Office.Project.Server.WebService.Utility.GetContext()
at
Microsoft.Office.Project.Server.WebService.Authentication.GetUserByName
(Boolean isProjUser, String username)
--- End of inner exception stack trace ---
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: Could not
find stored procedure 'MSP_ADMIN_GetDatabaseTimeout'.
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.ExecuteScalar()
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureScalar
(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.AdminDal.GetDatabaseTimeout
(DatabaseTimeoutType timeoutType)
at Microsoft.Office.Project.Server.Base.PlatformContext.PreInitialize
(Guid trackingId, Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(Boolean isWindowsUser, String username, Guid userId, Guid trackingId,
Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(IPSContextInfo psContextInfo)
at
Microsoft.Office.Project.Server.WebService.Utility.AuthenticateRequest
(HttpContext context)
at Microsoft.Office.Project.Server.WebService.Utility.GetContext()
at
Microsoft.Office.Project.Server.WebService.Authentication.GetUserByName
(Boolean isProjUser, String username)
--- End of inner exception stack trace ---

Hi Malik,

Do the following. Restore the DBs into SQL server, eg
projectserver_published etc....
Then, provision an new instance, and type in the names of the previously
restored DBs. This should work.

 

[Gary Chefetz]

Malik:

Reading this thread, I think you may be misunderstanding the excellent
advice you are getting. Substituting the databases *after* you create the
new instance will not work. Instead, you must substitute the database
*during* the provisioning process, which will work.

Dears
Thank you for the below is the exception i got when i try to open the
PWA after i replace the database and im trying to know what CU and SP
leave we had on the old server but i don't think that we can do that .


System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: Could not
find stored procedure 'MSP_ADMIN_GetDatabaseTimeout'.
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.ExecuteScalar()
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureScalar
(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.AdminDal.GetDatabaseTimeout
(DatabaseTimeoutType timeoutType)
at Microsoft.Office.Project.Server.Base.PlatformContext.PreInitialize
(Guid trackingId, Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(Boolean isWindowsUser, String username, Guid userId, Guid trackingId,
Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(IPSContextInfo psContextInfo)
at
Microsoft.Office.Project.Server.WebService.Utility.AuthenticateRequest
(HttpContext context)
at Microsoft.Office.Project.Server.WebService.Utility.GetContext()
at
Microsoft.Office.Project.Server.WebService.Authentication.GetUserByName
(Boolean isProjUser, String username)
--- End of inner exception stack trace ---
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: Could not
find stored procedure 'MSP_ADMIN_GetDatabaseTimeout'.
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.ExecuteScalar()
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureScalar
(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.AdminDal.GetDatabaseTimeout
(DatabaseTimeoutType timeoutType)
at Microsoft.Office.Project.Server.Base.PlatformContext.PreInitialize
(Guid trackingId, Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(Boolean isWindowsUser, String username, Guid userId, Guid trackingId,
Guid siteId, SPUrlZone urlZone, String lcid)
at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(IPSContextInfo psContextInfo)
at
Microsoft.Office.Project.Server.WebService.Utility.AuthenticateRequest
(HttpContext context)
at Microsoft.Office.Project.Server.WebService.Utility.GetContext()
at
Microsoft.Office.Project.Server.WebService.Authentication.GetUserByName
(Boolean isProjUser, String username)
--- End of inner exception stack trace ---

Hi Malik,

Do the following. Restore the DBs into SQL server, eg
projectserver_published etc....
Then, provision an new instance, and type in the names of the previously
restored DBs. This should work.

 

[Malik Al-Shayeb]

Malik:

Reading this thread, I think you may be misunderstanding the excellent
advice you are getting. Substituting the databases *after* you create the
new instance will not work. Instead, you must substitute the database
*during* the provisioning process, which will work.

--
Gary L Chefetz, MVP, MCT, MCITP
msProjectExpertshttp://www.msprojectexperts.com
FAQs and Referencehttp://www.projectserverexperts.com
BLOG:http://projectserverhelp.com

Dears
Thank you for the below is the exception i got when i try to open the
PWA after i replace the database and im trying to know what CU and SP
leave we had on the old server but i don't think that we can do that .

System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: Could not
find stored procedure 'MSP_ADMIN_GetDatabaseTimeout'.
 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.ExecuteScalar()
 at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureScalar
(String storedProcedureName, SqlParameter[] parameters)
 at
Microsoft.Office.Project.Server.DataAccessLayer.AdminDal.GetDatabaseTimeout
(DatabaseTimeoutType timeoutType)
 at Microsoft.Office.Project.Server.Base.PlatformContext.PreInitialize
(Guid trackingId, Guid siteId, SPUrlZone urlZone, String lcid)
 at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(Boolean isWindowsUser, String username, Guid userId, Guid trackingId,
Guid siteId, SPUrlZone urlZone, String lcid)
 at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(IPSContextInfo psContextInfo)
 at
Microsoft.Office.Project.Server.WebService.Utility.AuthenticateRequest
(HttpContext context)
 at Microsoft.Office.Project.Server.WebService.Utility.GetContext()
 at
Microsoft.Office.Project.Server.WebService.Authentication.GetUserByName
(Boolean isProjUser, String username)
 --- End of inner exception stack trace ---
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: Could not
find stored procedure 'MSP_ADMIN_GetDatabaseTimeout'.
 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.ExecuteScalar()
 at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureScalar
(String storedProcedureName, SqlParameter[] parameters)
 at
Microsoft.Office.Project.Server.DataAccessLayer.AdminDal.GetDatabaseTimeout
(DatabaseTimeoutType timeoutType)
 at Microsoft.Office.Project.Server.Base.PlatformContext.PreInitialize
(Guid trackingId, Guid siteId, SPUrlZone urlZone, String lcid)
 at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(Boolean isWindowsUser, String username, Guid userId, Guid trackingId,
Guid siteId, SPUrlZone urlZone, String lcid)
 at Microsoft.Office.Project.Server.Base.PlatformContext..ctor
(IPSContextInfo psContextInfo)
 at
Microsoft.Office.Project.Server.WebService.Utility.AuthenticateRequest
(HttpContext context)
 at Microsoft.Office.Project.Server.WebService.Utility.GetContext()
 at
Microsoft.Office.Project.Server.WebService.Authentication.GetUserByName
(Boolean isProjUser, String username)
 --- End of inner exception stack trace ---

Thank you all for the great help it worked for me i got the PWA runing
back again , thanks