Project Server 2013: Project Publish stuck at 74% after upgrade from 2010 RRS feed

  • General discussion

  • Hi all

    just had the pleasure to be first in the world (at least it seems so...)....

    Error message:

    System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'MSP_DATAEDIT_SET_ASSIGNMENT_SUBMITTED_DATA' expects parameter '@TASK_NAME', which was not supplied.    
     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)    
     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)  ClientConnectionId:4b788e4d-e8d3-47ad-9221-5f7dd2faa124

    And YES:

    In pub.msp_assignments_submitted we can find exact 1 line containing a new task that has been requested some resource in the 2010 system - and he managed to create a new task request without giving a name for the task. And the column is nullable - but the procedure isn't.

    delete the bad line from the database table (or try to use a delegate session to delete the request from the system via PWA what I did not try).

    Just in case someone else should stumble across this issue.

    Kind regards

    Christoph Muelder | Senior Consultant, MCTS, MCSE | SOLVIN information management GmbH, Germany

    • Edited by Christoph Muelder Thursday, March 19, 2015 6:07 PM
    • Changed type Christoph Muelder Tuesday, April 7, 2015 6:14 PM As the answer is already contained in the question...
    Thursday, March 19, 2015 6:03 PM

All replies

  • Thanks Christoph - have to keep that one in mind.

    (Moderators please change type of post away from question)



    James Boman BSc. MCP:EAD -

    Friday, March 20, 2015 3:57 AM