none
Associating a SharePoint template to a Project 2013 Pro template RRS feed

  • Question

  • Question - We're moving to Project 2013 Pro / PWA Online with Project 365 - so everything is stored in the cloud. I have created an Enterprise Template in Project 2013 Pro, but I don't know where to go to associate a specific PWA SharePoint Site template or to customize the template that's used by Project 2013 Pro when a new project is created using the Enterprise Template.

    FWIW - I have been able to create a new Enterprise Project Type in PWA and have been able to associate the PWA Site template to that EPT, but in that situation, it doesn't pull the assigned Project Plan Template into the new project being created through PWA with that EPT (I'm receiving an error message as it tries to create it. The project is created, but has no schedule - but I think that's a different question for the board).

    Thank you in advance!

    Tuesday, September 22, 2015 5:06 PM

Answers

  • Check if in your template you have some generic resources added and see if they are part of your enterprise resources? Seems you are trying to assign an activity to a resource that is not a valid enterprise resource.

    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    • Marked as answer by EleanorH2 Wednesday, September 30, 2015 10:25 PM
    Monday, September 28, 2015 6:34 AM

All replies

  • Hello,

    Both the Project Plan template and Project Site template are set on the EPT (Enterprise Project Type) on the PWA Setting > Enterprise Project Types menu.

    What part is erroring? What is displayed in the queue?

    Paul


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

    Tuesday, September 22, 2015 6:41 PM
    Moderator
  • Thank you for the quick response!

    I go into PWA and create a New project using the new EPT. The system allows me to enter the required information and the owner name and then press the Finish button. Some of the prefilled field values show up in this "wizard", but others don't (yet). PWA thinks for a minute and then gives me the response, "Sorry, we can't create your project right now. If this happens again, contact your administrator."

    I press the Cancel link and then go to Projects > Check in my Projects and the project shows up there. I check the project in. When I check PWA Settings > Operational Policies > Connected SharePoint sites, the project is not listed and so neither is the PWA site.

    I open Project Pro 2013 and choose Open and open the project from the correct URL. The project opens as Read Only, and there are no tasks listed (there are many listed in the associated project plan template). When I click the Check Out button, I receive a message stating, "The project cannot be checked out because the server is in read-only mode. Try again later."

    The Manage Queue job shows that the following job types for this project were cancelled: Project Create, Project Update from PSI, Project Publish and Start Workflow.

    When I click to view the error details and I see the graphic below for the Project Create item, and "Root element is missing" for the other items.

    Datasets:•ProjectDataSet?Table Assignment?Row:
    ASSN_UID='95fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='96fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='97fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='98fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='99fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='9afe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='9bfe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='9cfe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='9dfe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='9efe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='9ffe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a0fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a1fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a2fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a3fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a4fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a5fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a6fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a7fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a8fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='a9fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='aafe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='abfe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='acfe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='adfe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='aefe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='affe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='b0fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='b1fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='b2fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='b3fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='b4fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

    ?Row: ASSN_UID='b5fe0a88-6f61-e511-80ce-00155dac6d27'

     PROJ_UID='56fe0a88-6f61-e511-80ce-00155dac6d27'

    ?Error AssignmentInvalidOwner (139) - column RES_UID_OWNER<o:p></o:p>

     <o:p></o:p>



    General•DatabaseUndefinedError:?DatabaseUndefinedError (50000). Details:
    id='50000'

     name='DatabaseUndefinedError'

     uid='fa6c0c91-6f61-e511-80ce-00155dac6d27'

    . <o:p></o:p>

    •GeneralQueueException:?GeneralQueueException (9131). Details:
    id='9131'

     name='GeneralQueueException'

     uid='fb6c0c91-6f61-e511-80ce-00155dac6d27'

     messageID='1'

     exception='System.Data.SqlClient.SqlException (0x80131904): Invalid
    object name 'pjdraft.MSP_TVF_PROJECTS_#UPDLOCK'. at
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
    breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
    stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
    System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand
    cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
    TdsParserStateObject stateObj, Boolean& dataReady) 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,
    Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,
    RunBehavior runBehavior, Boolean returnStream, String method,
    TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean
    asyncWrite) at
    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1
    completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean
    asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
    Microsoft.Office.Project.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand
    command, SqlInfoMessageEventHandler handler) at
    Microsoft.Office.Project.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand
    command) at
    Microsoft.Office.Project.Server.DataAccessLayer.SqlSessionManager.SqlSessionAdapter.<>c__DisplayClass1.<ExecuteStoredProcedureNonQuery>b__0()
    at Microsoft.Office.Project.Server.DataAccessLayer.SqlSessionManager.SqlSessionAdapter.RetryableExecuteHandlerWithSession(Action
    retryableAction, Boolean allowRetry) at
    Microsoft.Office.Project.Server.DataAccessLayer.SqlSessionManager.SqlSessionAdapter.LogSpecificSqlExceptions(Action
    action) at Microsoft.Office.Project.Server.DataAccessLayer.SqlSessionManager.SqlSessionAdapter.ExecuteStoredProcedureNonQuery(String
    schemaQualifiedStoredProcedureName, SqlParameter[] parameters) at
    Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.<>c__DisplayClass29.<ExecuteStoredProcedureNoResult>b__25(IProjectServerSqlSession
    session) at
    Microsoft.Office.Project.Server.DataAccessLayer.DAL.RunInActiveSession(Action`1
    actionHandler) at
    Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureNoResult(String
    storedProcedureName, SqlParameter[] parameters) at
    Microsoft.Office.Project.Server.DataAccessLayer.ProjectDal.DeleteProject(Guid
    projectUid) at
    Microsoft.Office.Project.Server.BusinessLayer.ProjectMain.QuickDeleteProject(IPlatformContext
    context, Guid projectUid) at
    Microsoft.Office.Project.Server.BusinessLayer.ProjectQueueDispatch.HandleProjectAddToMessage(MessageContext
    mContext, ProjectMain project, ServerEventManager sem, ProjectAddToMessage
    projectAddToMessage) at Microsoft.Office.Project.Server.BusinessLayer.ProjectQueueDispatch.InternalDispatchMessage(IPlatformContext
    context, Message msg, Group messageGroup, JobTicket jobTicket, MessageContext
    mContext) ClientConnectionId:dd1d63eb-70e7-4232-855b-a875ac47485d Error
    Number:208,State:1,Class:16'

    . <o:p></o:p>

    •Queue:?GeneralQueueJobFailed (26000) -
    ProjectCreate.ProjectAddToMessage. Details: id='26000'

     name='GeneralQueueJobFailed'

     uid='fc6c0c91-6f61-e511-80ce-00155dac6d27'

     JobUID='68fe0a88-6f61-e511-80ce-00155dac6d27'

     ComputerName='e179d4c1-e213-4a7b-8589-0d94cf4c42c2'

     GroupType='ProjectCreate'

     MessageType='ProjectAddToMessage'

     MessageId='1'

     Stage=''

     CorrelationUID='9491309d-f0fc-2000-20f7-09b7f07dce00'

    For more details, check the ULS logs on machine
    e179d4c1-e213-4a7b-8589-0d94cf4c42c2 for entries with JobUID
    68fe0a88-6f61-e511-80ce-00155dac6d27.<o:p></o:p>


     

    Tuesday, September 22, 2015 9:49 PM
  • Check if in your template you have some generic resources added and see if they are part of your enterprise resources? Seems you are trying to assign an activity to a resource that is not a valid enterprise resource.

    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    • Marked as answer by EleanorH2 Wednesday, September 30, 2015 10:25 PM
    Monday, September 28, 2015 6:34 AM
  • Thank you! We do have Generic Resources added to the schedule, and they are listed in the Enterprise Resource Pool as Generic resources, but I can test removing them from the schedule to see if that fixes the failure.
    Tuesday, September 29, 2015 8:48 PM
  • Thank you for the hint! I removed the Generic Resources from the Project Schedule Template. I WAS able to then create a project using the custom Enterprise Project Type!

    I've since re-added one of the Generic Resources and am still able to create the project.

    My next struggle is customizing the out-of-box Schedule Project Detail Page so the Project Managers see the information they need, but I think I'm tracking that solution down online.

    Thank You for your help!

    Wednesday, September 30, 2015 10:25 PM