none
URGENT: Cannot access my PWA instance RRS feed

  • Question

  • Hello,

    I am stuck with the following error message when i try to connect to my PWA site "cannot connect to configuration database". I have my SharePoint portal and Project Server instance in the same server and I can access my SharePoint portal without any issues. I have checked that DB Server instance(SQL Service) is running as well. My ULS log is as below

                                

    High     [SERVICE] ProjectQueueService14: shutting down
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x0974) 0x0A1C Project Server                 General                       a06u Medium   [SERVICE] ProjectQueueService14: ProcessWatcher stopping child process for 78e024b7-4b88-4426-82b2-e2b00e672b5c PID: 8932
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x0974) 0x0A1C Project Server                 General                       a06v Medium   [SERVICE] ProjectQueueService14: waiting for child processes to shutdown
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x243C Project Server                 Queue                         7623 Information Queue system stopping. SSP: 78e024b7-4b88-4426-82b2-e2b00e672b5c
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x243C Project Server                 Queue                         8yhi Medium   [QUEUE] 2420_78e024b7-4b88-4426-82b2-e2b00e672b5c QueueExecService shutting down
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x243C Project Server                 Queue                         8yhs Medium   [QSERVICE] QueueManager 78e024b7-4b88-4426-82b2-e2b00e672b5c stopping
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x243C Project Server                 Queue                         8yht Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: Waiting for queue manager thread to complete
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         aqcc Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: Shutting down.
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         8yhw Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: Stopping all queues
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         8yhm Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: Telling ProjectQ to stop
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         sqlk Medium   PWA:http://localhost/PWA, ServiceApp:Project Server Service Application, User:\sp_farm, PSI: [QUEUE] ProjectQ Receiver.Stop()
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         8yhm Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: Telling TimesheetQ to stop
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         sqlk Medium   PWA:http://dangoteepm/PWA, ServiceApp:Project Server Service Application, User:sp_farm, PSI: [QUEUE] TimesheetQ Receiver.Stop()
    01/14/2013 09:45:08.17 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         8yhn Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: Waiting for ProjectQ to finish shutting down
    01/14/2013 09:45:08.19 Microsoft.Office.Project.Server (0x22E4) 0x0098 Project Server                 Queue                         sqnj Medium   PWA:http://dangoteepm/PWA, ServiceApp:Project Server Service Application, User:sp_farm, PSI: [QUEUE] Receiver TimesheetQ shutting down 002951e7-dd26-4b61-85e5-8da4c028ee78
    01/14/2013 09:45:08.19 Microsoft.Office.Project.Server (0x22E4) 0x2A34 Project Server                 Queue                         sqnj Medium   PWA:http://localhost/PWA, ServiceApp:Project Server Service Application, User:\sp_farm, PSI: [QUEUE] Receiver ProjectQ shutting down df22e4e4-ab0f-4184-852a-03548de8ffb0
    01/14/2013 09:45:08.19 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         8yho Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: ProjectQ stopped
    01/14/2013 09:45:08.20 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         7627 Information Queue system stopped. SSP: 78e024b7-4b88-4426-82b2-e2b00e672b5c  SiteUID: f24424b4-1cbb-4da9-b76c-cdb2b3dcb19b Url: http://dangoteepm/PWA Queue: ProjectQ
    01/14/2013 09:45:08.20 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         8yhn Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: Waiting for TimesheetQ to finish shutting down
    01/14/2013 09:45:08.20 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         8yho Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: TimesheetQ stopped
    01/14/2013 09:45:08.20 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         7627 Information Queue system stopped. SSP: 78e024b7-4b88-4426-82b2-e2b00e672b5c  SiteUID: f24424b4-1cbb-4da9-b76c-cdb2b3dcb19b Url: http://localhost/PWA Queue: TimesheetQ
    01/14/2013 09:45:08.20 Microsoft.Office.Project.Server (0x22E4) 0x2DF8 Project Server                 Queue                         8yi0 Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: QueueMgrThread stopped
    01/14/2013 09:45:08.20 Microsoft.Office.Project.Server (0x22E4) 0x243C Project Server                 Queue                         8yhu Medium   [QSERVICE] QueueManager 78e024b7-4b88-4426-82b2-e2b00e672b5c stopped
    01/14/2013 09:45:08.23 Microsoft.Office.Project.Server (0x22E4) 0x243C SharePoint Foundation         Unified Logging Service       8wsw High     Now terminating ULS (Microsoft.Office.Project.Server.Queuing.exe, onetnative.dll)
    01/14/2013 09:45:08.23 Microsoft.Office.Project.Server (0x22E4) 0x243C Project Server                 Unified Logging Service       8wsw High     Now terminating ULS (Microsoft.Office.Project.Server.Queuing.exe, Microsoft.Office.Project.Server.Native.dll)
    01/14/2013 09:45:08.25 Microsoft.Office.Project.Server (0x0974) 0x0A1C Project Server                 General                       8zd9 High     [SERVICE] ProjectQueueService14: stopped
    01/14/2013 09:45:08.30 Microsoft.Office.Project.Server (0x0974) 0x0978 SharePoint Foundation         Unified Logging Service       8wsw High     Now terminating ULS (Microsoft.Office.Project.Server.Queuing.exe, onetnative.dll)
    01/14/2013 09:45:08.30 Microsoft.Office.Project.Server (0x0974) 0x0978 SharePoint Foundation         SQM                           8zhw High     SQM: Could not create background management thread!. Error (0x5)
    01/14/2013 09:45:08.30 Microsoft.Office.Project.Server (0x0974) 0x0978 Project Server                 Unified Logging Service       8wsw High     Now terminating ULS (Microsoft.Office.Project.Server.Queuing.exe, Microsoft.Office.Project.Server.Native.dll)
    01/14/2013 09:45:08.30 Microsoft.Office.Project.Server (0x0974) 0x0978 Project Server                 SQM                           8zhw High     SQM: Could not create background management thread!. Error (0x5)
    01/14/2013 09:45:08.67 w3wp.exe (0x11E0)                       0x16CC Excel Services Application     Excel Calculation Services     8jg2 Medium   ResourceManager.PerformCleanup: Disk Manager: CurrentSize=365040. 11c5f189-0ee9-763d-0000-000050f7b00c
    01/14/2013 09:45:08.81 w3wp.exe (0x11E0)                       0x0888 Excel Services Application     Excel Calculation Services     8jg2 Medium   ResourceManager.PerformCleanup: Memory Manager: CurrentSize=338120704. 53fed7f1-0ee9-763d-0000-000050f7b00c
    01/14/2013 09:45:10.19 OWSTIMER.EXE (0x2F8C)                   0x208C SharePoint Foundation         Monitoring                     nasq Medium   Entering monitored scope (Timer Job job-workflow-failover) d3d26b5a-4b8e-4de7-98ae-4c854c1e1fd8
    01/14/2013 09:45:10.19 w3wp.exe (0x37A8)                       0x0FD4 SharePoint Foundation         Topology                       e5mc Medium   WcfSendRequest: RemoteAddress:

    another section of the log 

    Medium   [QSERVICE] 78e024b7-4b88-4426-82b2-e2b00e672b5c: Starting TimesheetQ for site: f24424b4-1cbb-4da9-b76c-cdb2b3dcb19b  
    01/14/2013 09:48:17.87 Microsoft.Office.Project.Server (0x0A04) 0x227C Project Server                 Queue                         7625 Information Queue system started. SSP: 78e024b7-4b88-4426-82b2-e2b00e672b5c  SiteUID: f24424b4-1cbb-4da9-b76c-cdb2b3dcb19b Url: http://dangoteepm/PWA Queue: TimesheetQ  
    01/14/2013 09:48:17.93 Microsoft.Office.Project.Server (0x0A04) 0x15B4 Project Server                 Queue                         srex Medium   PWA:http://dangoteepm/PWA, ServiceApp:Project Server Service Application, User:DANGOTE_NT\sp_farm, PSI: [QUEUE] ProjectQ: Next cleanup will run at 01/15/2013 00:00:00 0ca72412-5c0c-4e58-9927-1c6b9a2d9a8d
    01/14/2013 09:48:17.93 Microsoft.Office.Project.Server (0x0A04) 0x2480 Project Server                 Queue                         srex Medium   PWA:http://dangoteepm/PWA, ServiceApp:Project Server Service Application, User:DANGOTE_NT\sp_farm, PSI: [QUEUE] TimesheetQ: Next cleanup will run at 01/15/2013 00:00:00 8b3301e9-1ff2-45ce-8e16-4c121de52081
    01/14/2013 09:48:17.95 Microsoft.Office.Project.Server (0x0A04) 0x2480 Project Server                 Queue                         sqnm Medium   PWA:http://dangoteepm/PWA, ServiceApp:Project Server Service Application, User:DANGOTE_NT\sp_farm, PSI: [QUEUE] TimesheetQ queue settings loaded 8b3301e9-1ff2-45ce-8e16-4c121de52081
    01/14/2013 09:48:17.95 Microsoft.Office.Project.Server (0x0A04) 0x15B4 Project Server                 Queue                         sqnm Medium   PWA:http://dangoteepm/PWA, ServiceApp:Project Server Service Application, User:DANGOTE_NT\sp_farm, PSI: [QUEUE] ProjectQ queue settings loaded 0ca72412-5c0c-4e58-9927-1c6b9a2d9a8d
    01/14/2013 09:48:17.99 Microsoft.Office.Project.Server (0x0A04) 0x2480 Project Server                 Queue                         sqll Information Standard Information:PSI Entry Point:   Project User: DANGOTE_NT\sp_farm  Correlation Id: 9298726b-5391-4157-abd2-1cfd760225af  PWA Site URL: http://dangoteepm/PWA  SSP Name: Project Server Service Application  PSError: NoError (0) Queue System Started Successfully. Queue type (Project Queue/Timesheet Queue) is: 'TimesheetQ' 8b3301e9-1ff2-45ce-8e16-4c121de52081
    01/14/2013 09:48:17.99 Microsoft.Office.Project.Server (0x0A04) 0x15B4 Project Server                 Queue                         sqll Information Standard Information:PSI Entry Point:   Project User: DANGOTE_NT\sp_farm  Correlation Id: 6d883fba-c134-4d3d-b113-651fdf8e147e  PWA Site URL: http://dangoteepm/PWA  SSP Name: Project Server Service Application  PSError: NoError (0) Queue System Started Successfully. Queue type (Project Queue/Timesheet Queue) is: 'ProjectQ' 0ca72412-5c0c-4e58-9927-1c6b9a2d9a8d
    01/14/2013 09:48:21.39 w3wp.exe (0x22B0)                       0x2E3C SharePoint Foundation         Topology                       e5mc Medium   WcfSendRequest: RemoteAddress: 'http://prodapp-sp01:32843/183ede9195f448fc963fb5df8928c23b/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:dc427c5d-6b63-4693-a3e0-a1e85ebba0a3'  
    01/14/2013 09:48:21.39 w3wp.exe (0x10BC)                       0x35B0 SharePoint Foundation         Topology                       e5mb Medium   WcfReceiveRequest: LocalAddress: 'http://prodapp-sp01:32843/183ede9195f448fc963fb5df8928c23b/MetadataWebService.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:dc427c5d-6b63-4693-a3e0-a1e85ebba0a3' f3619bdf-b98b-4854-a549-89b482fff196
    01/14/2013 09:48:21.39 w3wp.exe (0x10BC)                       0x35B0 SharePoint Foundation         Monitoring                     nasq Medium   Entering monitored scope (ExecuteWcfServerOperation) f3619bdf-b98b-4854-a549-89b482fff196
    01/14/2013 09:48:21.39 w3wp.exe (0x10BC)                       0x35B0 SharePoint Server             Taxonomy                       fuc5 Medium   MetadataWebServiceApplication.GetChanges called on 'Managed Metadata_Service_Dangote' starting. f3619bdf-b98b-4854-a549-89b482fff196
    01/14/2013 09:48:21.39 w3wp.exe (0x10BC)                       0x35B0 SharePoint Server             Taxonomy                       fuc6 Medium   MetadataWebServiceApplication.GetChanges called on 'Managed Metadata_Service_Dangote' completed. f3619bdf-b98b-4854-a549-89b482fff196
    01/14/2013 09:48:21.39 w3wp.exe (0x10BC)                       0x35B0 SharePoint Foundation         Monitoring                     b4ly Medium   Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=2.0266 f3619bdf-b98b-4854-a549-89b482fff196
    01/14/2013 09:48:21.70 mssearch.exe (0x0C7C)                   0x3470 SharePoint Server Search       Propagation Manager           e3m8 Medium   [b81-c-2 Po] resuming propagation (reason ePauseForCrawlDone)                   [indexpropagator.cxx:1082]  d:\office\source\search\native\ytrip\tripoli\propagation\indexpropagator.cxx  
    01/14/2013 09:48:21.98 w3wp.exe (0x10BC)                       0x35B0 SharePoint Foundation         Topology                       e5mb Medium   WcfReceiveRequest: LocalAddress: 'http://prodapp-sp01:32843/183ede9195f448fc963fb5df8928c23b/MetadataWebService.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:93e4b1ca-6319-4f66-8fd7-86175bcf8450' 7d61640e-09dd-4209-973b-a837e37bf0a2
    01/14/2013 09:48:21.98 w3wp.exe (0x10BC)                       0x35B0 SharePoint Foundation         Monitoring                     nasq Medium   Entering monitored scope (ExecuteWcfServerOperation) 7d61640e-09dd-4209-973b-a837e37bf0a2
    01/14/2013 09:48:21.98 w3wp.exe (0x10BC)                       0x35B0 SharePoint Server             Taxonomy                       fuc5 Medium   MetadataWebServiceApplication.GetChanges called on 'Managed Metadata_Service_Dangote' starting. 7d61640e-09dd-4209-973b-a837e37bf0a2
    01/14/2013 09:48:21.99 w3wp.exe (0x10BC)                       0x35B0 SharePoint Server             Taxonomy                       fuc6 Medium   MetadataWebServiceApplication.GetChanges called on 'Managed Metadata_Service_Dangote' completed. 7d61640e-09dd-4209-973b-a837e37bf0a2
    01/14/2013 09:48:21.99 w3wp.exe (0x10BC)                       0x35B0 SharePoint Foundation         Monitoring                     b4ly Medium   Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=2.3108 7d61640e-09dd-4209-973b-a837e37bf0a2
    01/14/2013 09:48:22.71 w3wp.exe (0x11E0)                       0x0888 Excel Services Application     Excel Calculation Services     8jg2 Medium   ResourceManager.PerformCleanup: Memory Manager: CurrentSize=338935808. 53fed7f1-0ee9-763d-0000-000050f7b00c

    Please help on how I should go about resolving this issue. My client hasn't been able to  access their PWA site for days now.


    • Edited by bami131 Monday, January 14, 2013 9:24 AM
    Monday, January 14, 2013 9:22 AM

Answers

  • Hi,

    I would check the following:

    • The Project Application service is running
    • Are the Project Server services running - Queue and event services
    • Check the SQL Server name used to provision the PWA site is still accessible from the server. This should be ok if it was the SQL Server name but if you used an SQL Alias / DNS Alias does this still resolve the correct SQL Server.
    • Any accounts or passwords changed recently?
    • IIS Reset then retest - will take the other IIS Services offline

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    • Marked as answer by bami131 Tuesday, January 15, 2013 1:37 PM
    Monday, January 14, 2013 12:18 PM
    Moderator

All replies

  • Hi there,

    What else doesnt work on the farm? Can you access Central Admin? Can you see the SharePoint Admin configuration database in SQL management studio, is the DB online?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Monday, January 14, 2013 9:49 AM
    Moderator
  • Hello Paul,

    Everything else works fine. I can access Central Admin, The DB is online and I can see the SharePoint configuration database in SQL management studio. Please Help!!!

    Thanks.

    Monday, January 14, 2013 11:52 AM
  • Hi,

    I would check the following:

    • The Project Application service is running
    • Are the Project Server services running - Queue and event services
    • Check the SQL Server name used to provision the PWA site is still accessible from the server. This should be ok if it was the SQL Server name but if you used an SQL Alias / DNS Alias does this still resolve the correct SQL Server.
    • Any accounts or passwords changed recently?
    • IIS Reset then retest - will take the other IIS Services offline

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    • Marked as answer by bami131 Tuesday, January 15, 2013 1:37 PM
    Monday, January 14, 2013 12:18 PM
    Moderator
  • Thanks a lot for these steps Paul.

    It now works. The issue was actually with the identity account running the Project server service application Pool on IIS. The account had expired. So I had to reset the user password from the AD and then make changes everywhere else the account was being used.

    Tuesday, January 15, 2013 1:40 PM