none
Ошибки после установки SP1 для Project Server 2013 RRS feed

  • Вопрос

  • Здравствуйте!

    Имеется ферма, состоящая из 2-х серверов: 1. SharePoint Server 2013 + Project Server 2013; 2. SQL Server 2012.

    После установки SP1 для Project Server 2013 (а предварительно, само собою, и для SharePoint Foundation 2013 с SharePoint Server 2013) стали возникать следующие ошибки при выполнении PowerShell-скриптов по обновлению проектов:

    1. Ошибка при обновлении проекта:

    Ваше задание ProjectUpdate завершилось сбоем. Его текущее состояние: Failed.

    <?xml version="1.0" encoding="utf-16"?>
    <errinfo>
      <general>
        <class name="GeneralQueueException">
          <error id="9131" name="GeneralQueueException" uid="4e24adbf-29aa-e311-93fb-005056b86b77" messageID="2" exception="System.NullReferenceException: Object reference not set to an instance of an object.&#xD;&#xA;   at Microsoft.Office.Project.Server.BusinessLayer.ProjectEngineUpdate.HandleSSPUpdates()&#xD;&#xA;   at Microsoft.Office.Project.Server.BusinessLayer.ProjectEngineUpdate.HandleUpdate()&#xD;&#xA;   at Microsoft.Office.Project.Server.BusinessLayer.ProjectQueueDispatch.HandleProject2(MessageContext mContext, ProjectMain project, ServerEventManager sem, ProjectDataSet dataset, Guid projectUid, Guid sessionUid)&#xD;&#xA;   at Microsoft.Office.Project.Server.BusinessLayer.ProjectQueueDispatch.InternalDispatchMessage(IPlatformContext context, Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)" />
        </class>
        <class name="Queue">
          <error id="26000" name="GeneralQueueJobFailed" uid="4f24adbf-29aa-e311-93fb-005056b86b77" JobUID="14ed62a0-f9ec-437c-88df-5124226f12c8" ComputerName="71a7fe7a-8c66-4dec-8f87-e4e6dc92b25b" GroupType="ProjectUpdate" MessageType="ProjectUpdate2Message" MessageId="2" Stage="" CorrelationUID="6ea47c9c-ff30-f037-2b25-b9047c2bb543" />
        </class>
      </general>
    </errinfo>

    2. Ошибка при выполнении публикации проекта:

    Exception calling "QueuePublish" with "4" argument(s): "ProjectServerError(s) LastError=ProjectPublishEnqueueFailure Instructions: Pass this into PSClientError constructor to access all error information"

    3. Ошибка при выполнении возврата проекта:

    Exception calling "QueueCheckInProject" with "5" argument(s): "ProjectServerError(s) LastError=ProjectCheckinFailed Instructions: Pass this into PSClientError constructor to access all error information"

    Как видно, все ошибки связаны с выполнением заданий очереди.

    Работаю с PSI. Соотв. фрагмент кода:

    # Новый GUID для сессии
    $SessionId = [System.Guid]::NewGuid()
    # ...
    # Новый GUID для задания
    $JobId = [System.Guid]::NewGuid()
    Write-log "Обновляем проект..."
    $SvcPSProxy_Projects.QueueUpdateProject2($JobId, $SessionId, $Project, $false)
    # ...
    # Новый GUID для задания
    $JobId = [System.Guid]::NewGuid()
    Write-log "Публикуем проект..."
    $SvcPSProxy_Projects.QueuePublish($JobId, $Project.Project.PROJ_UID, $true, $EmptyString) | Out-Null
    # ...
    # Новый GUID для задания
    $JobId = [System.Guid]::NewGuid()
    Write-log "Возвращаем проект..."
    $SvcPSProxy_Projects.QueueCheckInProject($JobId, $Project.Project.PROJ_UID, $false, $SessionId, $SessionDescription_CheckIn)

    Если те же самые операции (сохранение, публикацию, возврат) выполнять через сайт PWA или клиент, то ошибок не возникает! Проблема именно при работе с PSI! До установки SP1 всё было Ok!

    Если кто-то уже успел столкнуться с подобным и нашёл выход, просьба поделиться решением. Хотя с радостью приму и просто советы!

    Спасибо!

    13 марта 2014 г. 13:35

Все ответы

  • Добрый День !

    Пожалуйста,  посмотирте и покажите нам все, что в ULS пишет при апдейте проекта при

    $SvcPSProxy_Projects.QueueUpdateProject2 


    Vadim Gerya, PMP

    30 марта 2014 г. 21:31
  • Пожалуйста,  посмотирте и покажите нам все, что в ULS пишет при апдейте проекта при

    $SvcPSProxy_Projects.QueueUpdateProject2 

    Здравствуйте!

    Отфильтровал логи по GUID'у соотв. задания очереди (JobId = "7eb413c4-bfe2-4874-bc6b-0bf9a5db6619"). Вот, что получил:

    03/31/2014 01:01:52.70 w3wp.exe (0x0A54) 0x1948 Project Server General ad2n8 High [Forced due to logging gap, Original Level: Verbose] PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: Running command using non-transactioned Sql session. Job:7eb413c4-bfe2-4874-bc6b-0bf9a5db6619 Project:fc47f731-e39e-e311-ae27-001320203f19 946f829c-4f38-f037-2b25-b8ac354880c4 

    03/31/2014 01:01:52.87 w3wp.exe (0x0A54) 0x1948 Project Server General ad2n8 High [Forced due to logging gap, Original Level: Verbose] PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: Running command using non-transactioned Sql session. Job:7eb413c4-bfe2-4874-bc6b-0bf9a5db6619 Project:fc47f731-e39e-e311-ae27-001320203f19 946f829c-4f38-f037-2b25-b8ac354880c4 

    03/31/2014 01:01:53.23 w3wp.exe (0x0A54) 0x1948 Project Server General ad2n8 High [Forced due to logging gap, Original Level: Verbose] PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: Running command using non-transactioned Sql session. Job:7eb413c4-bfe2-4874-bc6b-0bf9a5db6619 Project:fc47f731-e39e-e311-ae27-001320203f19 946f829c-4f38-f037-2b25-b8ac354880c4 

    03/31/2014 01:01:53.29 w3wp.exe (0x0A54) 0x1948 Project Server General ad2n8 High [Forced due to logging gap, Original Level: Verbose] PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: Running command using non-transactioned Sql session. Job:7eb413c4-bfe2-4874-bc6b-0bf9a5db6619 Project:fc47f731-e39e-e311-ae27-001320203f19 946f829c-4f38-f037-2b25-b8ac354880c4 

    03/31/2014 01:01:53.90 w3wp.exe (0x0A54) 0x1948 Project Server Queue 8tfu Medium PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: [QUEUE] [PSI] GetJobWaitTime(7eb413c4-bfe2-4874-bc6b-0bf9a5db6619), LogLevelManager Warning-ulsID:0x38746675 has no entities explicitly specified. 946f829c-5f83-f037-2b25-bb935619c7d5 

    03/31/2014 01:02:01.38 Microsoft.Office.Project.Server (0x1AA4) 0x178C Project Server Queue ad3fy Critical Standard Information:PSI Entry Point: <unknown>  Project User: <unknown>  Correlation Id: <unknown>  PWA Site URL:   SA Name: <unknown>  PSError: <unknown> A queue job has failed. This is a general error logged by the Project Server Queue everytime a job fails - for effective troubleshooting use this error message with other more specific error messages (if any), the Operations guide (which documents more details about queued jobs) and the trace log (which could provide more detailed context). More information about the failed job follows. GUID of the failed job: 7eb413c4-bfe2-4874-bc6b-0bf9a5db6619. Name of the computer that processed this job: 71a7fe7a-8c66-4dec-8f87-e4e6dc92b25b (to debug further, you need to look at the trace log from this computer). Failed job type: ProjectUpdate. Failed sub-job type: ProjectUpdate2Message. Failed sub-job ID: 2. Stage where sub-job failed:  (this is useful when one sub-job has more than one logical processing stages). 946f829c-4f38-f037-2b25-b8ac354880c4 

    03/31/2014 01:02:01.38 Microsoft.Office.Project.Server (0x1AA4) 0x178C Project Server Queue Jobs ad3fy Medium Error is: GeneralQueueJobFailed. Details: Queue Attributes:  7eb413c4-bfe2-4874-bc6b-0bf9a5db6619  71a7fe7a-8c66-4dec-8f87-e4e6dc92b25b  ProjectUpdate  ProjectUpdate2Message  2    946f829c-4f38-f037-2b25-b8ac354880c4  . Standard Information: , LogLevelManager Warning-ulsID:0x000DD158 has no entities explicitly specified. 946f829c-4f38-f037-2b25-b8ac354880c4 

    03/31/2014 01:02:27.17 w3wp.exe (0x0A54) 0x2878 Project Server Queue 8tfj Medium PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: [QUEUE] [PSI] GetJobCompletionState(7eb413c4-bfe2-4874-bc6b-0bf9a5db6619, out errorString), LogLevelManager Warning-ulsID:0x3874666A has no entities explicitly specified. 9c6f829c-8fb1-f037-2b25-ba1de6668b7b 

    03/31/2014 01:02:27.40 w3wp.exe (0x0A54) 0x2878 Project Server Queue actom Medium PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: [QUEUE] SendMessageGroup failed with exception Microsoft.Office.Project.Server.BusinessLayer.Queue.CorrelationBlockedException, message correlation fc47f731-e39e-e311-ae27-001320203f19 is blocked by a failed job uid 7eb413c4-bfe2-4874-bc6b-0bf9a5db6619, owner ffa5b905-fede-e211-93f6-005056b86b77 Job:331e61e3-94a6-4c7e-a4d0-1745e1d79a1b Project:fc47f731-e39e-e311-ae27-001320203f19 9c6f829c-4fbc-f037-2b25-b0a9e9f1b7dc 

    03/31/2014 01:02:27.40 w3wp.exe (0x0A54) 0x2878 Project Server Server-side Project Operations 8koq High PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: Microsoft.Office.Project.Server.BusinessLayer.Queue.CorrelationBlockedException: correlation fc47f731-e39e-e311-ae27-001320203f19 is blocked by a failed job uid 7eb413c4-bfe2-4874-bc6b-0bf9a5db6619, owner ffa5b905-fede-e211-93f6-005056b86b77     at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.SendMessageGroup(String prefix, Group msgGroup, JobTicket jobTicket, Guid serverId, Int32 wakeupTimeSeconds, Boolean forceSend, IEnumerable`1 messages)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.<>c__DisplayClass105.<SendMessageGroup>b__103(QueueDal queueDal)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.<>c__DisplayClass11d.<ExecuteRetryableSqlCall>b__11c(QueueDal queueDal)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.ExecuteRetryableSqlCall[T](Func`2 retryableCall)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SendMessageGroup(Group msgGroup, JobTicket jobTicket, Guid serverId, Int32 wakeupTimeSeconds, Boolean forceSend, IEnumerable`1 messages)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.EndMessageGroup()     at Microsoft.Office.Project.Server.BusinessLayer.Project.PublishAProject(Guid jobUID, Guid projectUid, Boolean fullPublish, ProjectSiteConfiguration projSiteConfig, Boolean isMaster, Boolean addIdeaListLink, Boolean shouldSpawnCreateWssSiteMessage) Job:331e61e3-94a6-4c7e-a4d0-1745e1d79a1b Project:fc47f731-e39e-e311-ae27-001320203f19 9c6f829c-4fbc-f037-2b25-b0a9e9f1b7dc 

    03/31/2014 01:02:27.40 w3wp.exe (0x0A54) 0x2878 Project Server Server-side Project Operations 6vwf High PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: Microsoft.Office.Project.Server.BusinessLayer.Queue.CorrelationBlockedException: correlation fc47f731-e39e-e311-ae27-001320203f19 is blocked by a failed job uid 7eb413c4-bfe2-4874-bc6b-0bf9a5db6619, owner ffa5b905-fede-e211-93f6-005056b86b77     at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.SendMessageGroup(String prefix, Group msgGroup, JobTicket jobTicket, Guid serverId, Int32 wakeupTimeSeconds, Boolean forceSend, IEnumerable`1 messages)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.<>c__DisplayClass105.<SendMessageGroup>b__103(QueueDal queueDal)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.<>c__DisplayClass11d.<ExecuteRetryableSqlCall>b__11c(QueueDal queueDal)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.ExecuteRetryableSqlCall[T](Func`2 retryableCall)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SendMessageGroup(Group msgGroup, JobTicket jobTicket, Guid serverId, Int32 wakeupTimeSeconds, Boolean forceSend, IEnumerable`1 messages)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.EndMessageGroup()     at Microsoft.Office.Project.Server.BusinessLayer.Project.PublishAProject(Guid jobUID, Guid projectUid, Boolean fullPublish, ProjectSiteConfiguration projSiteConfig, Boolean isMaster, Boolean addIdeaListLink, Boolean shouldSpawnCreateWssSiteMessage)     at Microsoft.Office.Project.Server.BusinessLayer.Project.QueuePublish(Guid jobUid, Guid projectUid, Boolean fullPublish, ProjectSiteConfiguration projSiteConfig, Guid categoryPermission, Boolean bypassOwnerValidation, Boolean addIdeaListLink) Job:331e61e3-94a6-4c7e-a4d0-1745e1d79a1b Project:fc47f731-e39e-e311-ae27-001320203f19 9c6f829c-4fbc-f037-2b25-b0a9e9f1b7dc 

    03/31/2014 01:02:27.79 w3wp.exe (0x0A54) 0x2878 Project Server Queue actom Medium PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: [QUEUE] SendMessageGroup failed with exception Microsoft.Office.Project.Server.BusinessLayer.Queue.CorrelationBlockedException, message correlation fc47f731-e39e-e311-ae27-001320203f19 is blocked by a failed job uid 7eb413c4-bfe2-4874-bc6b-0bf9a5db6619, owner ffa5b905-fede-e211-93f6-005056b86b77 Job:5319ad35-f20f-47bd-9778-3da258c0721c Project:fc47f731-e39e-e311-ae27-001320203f19 9c6f829c-dfcb-f037-2b25-b50f1a295156 

    03/31/2014 01:02:27.79 w3wp.exe (0x0A54) 0x2878 Project Server Server-side Project Operations 7pc5 High PWA:http://project/PWA, ServiceApp:Приложение службы Project Server, User:i:0#.w|domain\user, PSI: Microsoft.Office.Project.Server.BusinessLayer.Queue.CorrelationBlockedException: correlation fc47f731-e39e-e311-ae27-001320203f19 is blocked by a failed job uid 7eb413c4-bfe2-4874-bc6b-0bf9a5db6619, owner ffa5b905-fede-e211-93f6-005056b86b77     at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.SendMessageGroup(String prefix, Group msgGroup, JobTicket jobTicket, Guid serverId, Int32 wakeupTimeSeconds, Boolean forceSend, IEnumerable`1 messages)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.<>c__DisplayClass105.<SendMessageGroup>b__103(QueueDal queueDal)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.<>c__DisplayClass11d.<ExecuteRetryableSqlCall>b__11c(QueueDal queueDal)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.ExecuteRetryableSqlCall[T](Func`2 retryableCall)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SendMessageGroup(Group msgGroup, JobTicket jobTicket, Guid serverId, Int32 wakeupTimeSeconds, Boolean forceSend, IEnumerable`1 messages)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.EndMessageGroup()     at Microsoft.Office.Project.Server.BusinessLayer.Project.SendCheckinMessageGroup(Guid jobUID, Guid projectUid, Guid sessionUid, Boolean force)     at Microsoft.Office.Project.Server.BusinessLayer.Project.CheckinAProject(Guid jobUID, Guid projectUid, Guid sessionUid, Boolean force) Job:5319ad35-f20f-47bd-9778-3da258c0721c Project:fc47f731-e39e-e311-ae27-001320203f19 9c6f829c-dfcb-f037-2b25-b50f1a295156 

    31 марта 2014 г. 6:49