Re: Restore of portal

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi I have tried what was suggested i.e. restoring the portal by entering in
the database information on the restore pages..no joy

I've looked through the error log and can't find any other reference to an
error
I've included it, so if there is something obvious that i'm missing please
let me know

thanks,

**************************************
Portal Creation Log File
**************************************
Tuesday, 08 November 2005 08:33:45 Log file opened.
08:33:45 Starting portal creation for ESB SharePoint Portal
08:33:45 Values used for restore: PortalUrl=http://headiis018s:81/ Virtual
Server Url=http://headiis018s:81/ PortalName=ESB SharePoint Portal
Application Pool=MSSharePointPortalAppPool, user=udesb1\SPSPool
SiteDB=(HEADIIS018S, ESBShare1_SITE) ProfileDB=(HEADIIS018S, ESBShare1_PROF)
ServiceDB=(HEADIIS018S, ESBShare1_SERV)
08:33:45 Original values recovered: SiteCountWarning=9000
SiteCountLimit=15000 OriginalPortalUrl=http://datciis004s:81/
OriginalWorkspaceUrl= PortalWasFederated=FALSE PortalWasCentral=FALSE
08:33:45 Enter RecoverSite()
08:33:45 uHost set as: http://headiis018s:81/
08:33:45 Retrieving identity for application pool 'MSSharePointPortalAppPool'.
08:33:45 Application pool identity is 'udesb1\SPSPool'.
08:33:45 Virtual server Uri is 'http://headiis018s:81/'
08:33:45 Opening virtual server.
08:33:45 Checking virtual server state.
08:33:45 Virtual server needs extend.
08:33:45 Extending virtual server 'http://headiis018s:81/' using existing
AppPool 'MSSharePointPortalAppPool'...
08:33:46 Virtual server extended.
08:33:46 Checking if Document management exclusions are needed.
08:33:46 Start- Recovering original virtual server properties
08:33:46 Recovering Property: alerts-enabled, Value=True
08:33:46 Recovering Property: job-email-enabled-lists, Value=every 1 minutes
between 0 and 59
08:33:46 Recovering Property: emailinsertspublicfolderurl,
Value=http://headexc001s/public/
08:33:46 Recovering Property: alerts-maximum, Value=50
08:33:46 Recovering Property: virtualserverpermsmask, Value=-1
08:33:46 Recovering Property: eventhandlersenabled, Value=True
08:33:46 Recovering Property: defaulttimezone, Value=2
08:33:46 Recovering Property: send-ad-email, Value=True
08:33:46 Recovering Property: job-usage-analysis, Value=daily between
01:00:00 and 01:00:00
08:33:46 Recovering Property: securityvalidation-enabled, Value=True
08:33:46 Recovering Property: max-file-post-size, Value=50
08:33:46 Recovering Property: spallowp2p, Value=1
08:33:46 Recovering Property: securityvalidation-expire, Value=True
08:33:46 Recovering Property: ssc-contact, Value=no
08:33:46 Recovering Property: defaultquotatemplate, Value=No Quota
08:33:46 Recovering Property: securityvalidation-timeout, Value=30
08:33:46 Recovering Property: presenceenabled, Value=yes
08:33:46 Recovering Property: emailinsertsenabled, Value=True
08:33:46 Recovering Property: ssc, Value=yes
08:33:46 Recovering Property: spallowglobalcatalog, Value=0
08:33:46 Recovering Property: data-retrieval-services-oledb-providers,
Value=DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB
08:33:46 Recovering Property: alerts-limited, Value=True
08:33:46 End- Recovering original virtual server properties
08:33:46 Start- Recovering original virtual server prefixes
08:33:47 Start- spVirtualServer.Config.Prefixes.Add(personal, 1)
08:33:47 End- spVirtualServer.Config.Prefixes.Add(personal, 1)
08:33:48 Start- spVirtualServer.Config.Prefixes.Add(projects, 1)
08:33:48 End- spVirtualServer.Config.Prefixes.Add(projects, 1)
08:33:48 End- Recovering original virtual server prefixes
08:33:56 Start- Create SPVirtualServerConfig object
08:33:56 End- Create SPVirtualServerConfig object
08:33:56 Start- config.SelfServiceSiteCreation set
08:33:57 End- config.SelfServiceSiteCreation set
08:33:57 Start- config.Properties.Update()
08:33:57 Looking up STS site ID '441730be-674c-4d51-ba45-413135e48de5' in
topology...
08:33:57 Looking up virtual server ID 'bb1cb63f-fb23-4d32-b149-7466702d9783'
in topology...
08:33:57 Start- m_tm.Databases.Add(new
Database(strProfileDatabaseName=ESBShare1_PROF, virtualServer,
m_profileSqlService))
08:33:57 End- tm.Databases.Add(new
Database(strProfileDatabaseName=ESBShare1_PROF, virtualServer,
profileSqlService)) Return = profileDatabase
08:33:57 Start- tm.Databases.Add(new
Database(strServiceDatabaseName=ESBShare1_SERV, virtualServer,
serviceSqlService))
08:33:57 End- tm.Databases.Add(new
Database(strServiceDatabaseName=ESBShare1_SERV, virtualServer,
serviceSqlService)) Return = serviceDatabase
08:33:57 Flushing connection pool for site database.
08:33:57 Flushing connection pool for profile database.
08:33:57 Flushing connection pool for services database.
08:33:57 Start- tm.PortalSites.Add(new PortalSite(teamSite, strSiteUrl,
serviceDatabase, profileDatabase))
08:33:57 Portal creation failed System.Data.SqlClient.SqlException: Could
not find stored procedure 'dbo.proc_getPortalProperties'. at
Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0, CommandBehavior A_1,
Boolean A_2) at Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0,
CommandBehavior A_1, Boolean A_2) at
Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0, CommandBehavior A_1) at
Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0, CommandBehavior A_1) at
Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0) at
Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0) at
Microsoft.SharePoint.Portal.Topology.PortalSite.a(c A_0, Boolean A_1) at
Microsoft.SharePoint.Portal.Admin.c.b() at
Microsoft.SharePoint.Portal.Admin.c.f()
08:33:57 Enter UnextendVirtualServer
08:33:57 Unextending virtual server 'http://headiis018s:81/'.
(bb1cb63f-fb23-4d32-b149-7466702d9783)
08:33:58 Removing database 'ESBShare1_SERV' from configuration database.
08:33:58 Removing database 'ESBShare1_SITE' from configuration database.
08:33:58 Removing database 'ESBShare1_PROF' from configuration database.
08:33:58 Removing virtual server 'http://headiis018s:81/' from configuration
database. (bb1cb63f-fb23-4d32-b149-7466702d9783)
08:33:58 Exit UnextendVirtualServer
08:33:58 Enter SearchConfigure()
08:33:58 Retrieving portal site 441730be-674c-4d51-ba45-413135e48de5


*******************************
There was also this error in the event log
*******************************
Event Type: Warning
Event Source: SharePoint Portal Error Reporting
Event Category: None
Event ID: 0
Date: 08/11/2005
Time: 08:32:16
User: N/A
Computer: HEADIIS018S
Description:
A non-critical error has occurred. If Dr. Watson reporting is enabled,
details of the error will be sent to Microsoft for investigation.

W3WP.EXE: Microsoft.SharePoint.SPException
@Microsoft.SharePoint.Portal.ServerAdmin.PortalCreatePage.a(Object A_0,
EventArgs A_1)

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





"Shane Young [SPS MVP]" wrote:

> I think you need to look a little further down in your error log. There is
> a more descriptive error message usually.
>
> --
> Shane Young - SPS MVP
> SharePoint911 - http://www.SharePoint911.com
> Blog - http://msmvps.com/shane/
>
>
>
> "eoint" <eoint@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:1561A613-47D2-4D65-A971-0CE5BD51BE5D@xxxxxxxxxxxxxxxx
> > Hi we have two sharePoint enviornments Development and Production. I have
> > taken a backup of the three sharepoint databases SITE, SERV and PROF. I
> > want
> > to restore them onto the development machine as a backup to the current
> > production structure. I have restored the databases to the development
> > server
> > and tried running the restore from the administraation pages but it falls
> > over after 30 secs with the following error
> >
> > "Portal creation failed System.Data.SqlClient.SqlException: Could not find
> > stored procedure 'dbo.proc_getPortalProperties'. at
> > Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0, CommandBehavior A_1,
> > Boolean A_2) at Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0,
> > CommandBehavior A_1, Boolean A_2) at
> > Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0, CommandBehavior A_1)
> > at
> > Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0, CommandBehavior A_1)
> > at
> > Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0) at
> > Microsoft.SharePoint.Portal.Data.a.a(SqlCommand A_0) at
> > Microsoft.SharePoint.Portal.Topology.PortalSite.a(c A_0, Boolean A_1) at
> > Microsoft.SharePoint.Portal.Admin.c.b() at
> > Microsoft.SharePoint.Portal.Admin.c.f()"
> >
> > I verified that the exact number of stored procedures were in the restore
> > databases as the originals but after the failed restore the number was
> > less
> > i.e. some were deleted
> >
> > If anyone could shed some light on this I would appreciate it..
> >
>
>
>
.

Quantcast