Database restore of SSP does not "remember" PWA site

T

Tweedy

We lost our config file for the farm and didn't have a good SharePoint
backup, only database backups. So we reloaded all of the databases and
rebuilt the farm. In order to restore the SSP, we went into central admin,
clicked on Shared Services Admin, then on Restore SSP. Most everything came
back, including the 240 GB search index (whew!), but our PWA site was no
longer listed in the SSP. The browser is unable to access
https://server/pwa. The message it gets is
"PSI Auth: SiteId f4f29540-08da-4040-88b0-ca4d848baf6a was not found in the
ProjectSiteCollection for this SSP"

All four of the Project Server databases are intact. At this point, we
cannot use either central admin or stsadm to manipulate anything in
SharePoint to get it to "remember" the PWA site (or we just don't know how).
We tried backing up and deleting the pwa site, but SharePoint still thinks
the site exists when we try to do projcreatepwainstance. Running
projupdatepwainstance says the site does not exist. Hmmm. The problem
appears to be that the declared explicit inclusion managed path gives MOSS
this "hant" syndrome. If you're not southern, a "hant" is a ghost.

Partial solution: Exported all the project subsites
https://server/pwa/sitename; deleted the site at server/pwa; deleted the
explicit inclusion path in Central Admin for server/pwa; recreated pwa site
in SSP with existing DBs; imported all the project subsites.

With this "solution," we lost all of the docs in the server/pwa/shared
documents library, which fortunately did not hurt much in this case, but not
ideal.

Any suggestions for future problems?

Thanks.
 
W

waqas sarwar

Dear Tweedy,

I have the same kind of problem and still in it. i tried to restore the full
famr back on another machine, All things recover only PWA sites. provisiong
failed message inside ssp.
Then i try to export then import function also but the same problem exists.
any hint or clue please advices,

I am not development guy so i dont understand what is this, further i try to
catch a error which i will paste here under:

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 ---]
Microsoft.Office.Project.PWA.PJContext.AuthenticateUserForPWA(Boolean
validateUser, String username, Boolean checkTimebomb) +1412
Microsoft.Office.Project.PWA.PJContext.AuthenticateUserForPWA(Boolean
newCookie) +877
Microsoft.Office.Project.PWA.PJContext.GetContext(Boolean
isWebServiceCall, Boolean newCookie, Guid siteId, Nullable`1 zone) +367
Microsoft.Office.Project.PWA.PJBaseWebPartPage..ctor() +285
ASP.DEFAULT_ASPX_529955207..ctor() +9

__ASP.FastObjectFactory_app_web_default_aspx_529955207_miuf8aeu.Create_ASP_DEFAULT_ASPX_529955207() +20
System.Web.Compilation.BuildResultCompiledType.CreateInstance() +49

System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath
virtualPath, Type requiredBaseType, HttpContext context, Boolean
allowCrossApp, Boolean noAssert) +115
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context,
String requestType, VirtualPath virtualPath, String physicalPath) +31

System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext
context, String requestType, VirtualPath virtualPath, String physicalPath) +40
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String
requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)
+139

System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +128
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +161
 
T

Tweedy

I know nothing more than this. It appears that your system was trying to
validate a user for access to PWA and could not find a stored procedure in a
database during the process.

Can someone else help?


waqas sarwar said:
Dear Tweedy,

I have the same kind of problem and still in it. i tried to restore the full
famr back on another machine, All things recover only PWA sites. provisiong
failed message inside ssp.
Then i try to export then import function also but the same problem exists.
any hint or clue please advices,

I am not development guy so i dont understand what is this, further i try to
catch a error which i will paste here under:

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 ---]
Microsoft.Office.Project.PWA.PJContext.AuthenticateUserForPWA(Boolean
validateUser, String username, Boolean checkTimebomb) +1412
Microsoft.Office.Project.PWA.PJContext.AuthenticateUserForPWA(Boolean
newCookie) +877
Microsoft.Office.Project.PWA.PJContext.GetContext(Boolean
isWebServiceCall, Boolean newCookie, Guid siteId, Nullable`1 zone) +367
Microsoft.Office.Project.PWA.PJBaseWebPartPage..ctor() +285
ASP.DEFAULT_ASPX_529955207..ctor() +9

__ASP.FastObjectFactory_app_web_default_aspx_529955207_miuf8aeu.Create_ASP_DEFAULT_ASPX_529955207() +20
System.Web.Compilation.BuildResultCompiledType.CreateInstance() +49

System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath
virtualPath, Type requiredBaseType, HttpContext context, Boolean
allowCrossApp, Boolean noAssert) +115
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context,
String requestType, VirtualPath virtualPath, String physicalPath) +31

System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext
context, String requestType, VirtualPath virtualPath, String physicalPath) +40
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String
requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)
+139

System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +128
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +161

Tweedy said:
We lost our config file for the farm and didn't have a good SharePoint
backup, only database backups. So we reloaded all of the databases and
rebuilt the farm. In order to restore the SSP, we went into central admin,
clicked on Shared Services Admin, then on Restore SSP. Most everything came
back, including the 240 GB search index (whew!), but our PWA site was no
longer listed in the SSP. The browser is unable to access
https://server/pwa. The message it gets is
"PSI Auth: SiteId f4f29540-08da-4040-88b0-ca4d848baf6a was not found in the
ProjectSiteCollection for this SSP"

All four of the Project Server databases are intact. At this point, we
cannot use either central admin or stsadm to manipulate anything in
SharePoint to get it to "remember" the PWA site (or we just don't know how).
We tried backing up and deleting the pwa site, but SharePoint still thinks
the site exists when we try to do projcreatepwainstance. Running
projupdatepwainstance says the site does not exist. Hmmm. The problem
appears to be that the declared explicit inclusion managed path gives MOSS
this "hant" syndrome. If you're not southern, a "hant" is a ghost.

Partial solution: Exported all the project subsites
https://server/pwa/sitename; deleted the site at server/pwa; deleted the
explicit inclusion path in Central Admin for server/pwa; recreated pwa site
in SSP with existing DBs; imported all the project subsites.

With this "solution," we lost all of the docs in the server/pwa/shared
documents library, which fortunately did not hurt much in this case, but not
ideal.

Any suggestions for future problems?

Thanks.
Click to expand...
Click to expand...
 
M

Martin Winzig

I bloged about this topic last year :)

http://projectserver.cz/cms/index.php?itemid=21

Only litle note: When your Site is >2G you can't compress CAB file.

stsadm -o export -url http://sproject.autocont.cz:88/projectserver -filename
c:\projectserver.cab -cabsize 400 -includeusersecurity -nofilecompression





--
Blog: http://www.projectserver.cz


Tweedy said:
I know nothing more than this. It appears that your system was trying to
validate a user for access to PWA and could not find a stored procedure in a
database during the process.

Can someone else help?


waqas sarwar said:
Dear Tweedy,

I have the same kind of problem and still in it. i tried to restore the full
famr back on another machine, All things recover only PWA sites. provisiong
failed message inside ssp.
Then i try to export then import function also but the same problem exists.
any hint or clue please advices,

I am not development guy so i dont understand what is this, further i try to
catch a error which i will paste here under:

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 ---]
Microsoft.Office.Project.PWA.PJContext.AuthenticateUserForPWA(Boolean
validateUser, String username, Boolean checkTimebomb) +1412
Microsoft.Office.Project.PWA.PJContext.AuthenticateUserForPWA(Boolean
newCookie) +877
Microsoft.Office.Project.PWA.PJContext.GetContext(Boolean
isWebServiceCall, Boolean newCookie, Guid siteId, Nullable`1 zone) +367
Microsoft.Office.Project.PWA.PJBaseWebPartPage..ctor() +285
ASP.DEFAULT_ASPX_529955207..ctor() +9

__ASP.FastObjectFactory_app_web_default_aspx_529955207_miuf8aeu.Create_ASP_DEFAULT_ASPX_529955207() +20
System.Web.Compilation.BuildResultCompiledType.CreateInstance() +49

System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath
virtualPath, Type requiredBaseType, HttpContext context, Boolean
allowCrossApp, Boolean noAssert) +115
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context,
String requestType, VirtualPath virtualPath, String physicalPath) +31

System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext
context, String requestType, VirtualPath virtualPath, String physicalPath) +40
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String
requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)
+139

System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +128
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +161

Tweedy said:
We lost our config file for the farm and didn't have a good SharePoint
backup, only database backups. So we reloaded all of the databases and
rebuilt the farm. In order to restore the SSP, we went into central admin,
clicked on Shared Services Admin, then on Restore SSP. Most everything came
back, including the 240 GB search index (whew!), but our PWA site was no
longer listed in the SSP. The browser is unable to access
https://server/pwa. The message it gets is
"PSI Auth: SiteId f4f29540-08da-4040-88b0-ca4d848baf6a was not found in the
ProjectSiteCollection for this SSP"

All four of the Project Server databases are intact. At this point, we
cannot use either central admin or stsadm to manipulate anything in
SharePoint to get it to "remember" the PWA site (or we just don't know how).
We tried backing up and deleting the pwa site, but SharePoint still thinks
the site exists when we try to do projcreatepwainstance. Running
projupdatepwainstance says the site does not exist. Hmmm. The problem
appears to be that the declared explicit inclusion managed path gives MOSS
this "hant" syndrome. If you're not southern, a "hant" is a ghost.

Partial solution: Exported all the project subsites
https://server/pwa/sitename; deleted the site at server/pwa; deleted the
explicit inclusion path in Central Admin for server/pwa; recreated pwa site
in SSP with existing DBs; imported all the project subsites.

With this "solution," we lost all of the docs in the server/pwa/shared
documents library, which fortunately did not hurt much in this case, but not
ideal.

Any suggestions for future problems?

Thanks.
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

Database recovery of SSP does not "remember" PWA site 2
Move PWA instance from one SSP to another SSP 1
Provisioning 'PWA': Error provisioning site or databases 9
can't access PWA site from SharePoint Designer 4
PWA provisioning Failed-See Event Log 1
PWA site won't provision in SharePoint farm - no error given! 0
How to change service account for Project Server 2007. 0
backup and restore PWA 18

Top