none
Project Server 2016 getting System.ArgumentException Error RRS feed

  • Question

  • Hello,

    my customize web API calling CSOM to load project and getting below exception error.

    "PJClientCallableException: GeneralUnhandledException
    GeneralUnhandledException
    Exception = System.ArgumentException: Value was either too large or too small for an Int32.Couldn't store <4722600000100.000000000> in TaskCVP Column.  Expected type is Int32. ---> System.OverflowException: Value was either too large or too small for an Int32.
       at System.Decimal.FCallToInt32(Decimal d)
       at System.Decimal.System.IConvertible.ToInt32(IFormatProvider provider)
       at System.Data.Common.Int32Storage.Set(Int32 record, Object value)
       at System.Data.DataColumn.set_Item(Int32 record, Object value)
       --- End of inner exception stack trace ---
       at System.Data.DataColumn.set_Item(Int32 record, Object value)
       at System.Data.DataTable.NewRecordFromArray(Object[] value)
       at System.Data.DataTable.LoadRow(Object[] values, LoadOption loadOption, Index searchIndex)
       at System.Data.DataTable.LoadDataRow(Object[] values, LoadOption loadOption)
       at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
       at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
       at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
       at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
       at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
       at Microsoft.Office.Project.Server.Data.SqlSession.<>c__DisplayClass4.<Fill>b__3(SqlCommand cmd)
       at Microsoft.Office.Project.Server.Data.SqlSession.ProcessRetryableSqlCommand(SqlCommand command, Boolean retryForDeadlock, Action`1 commandAction)
       at Microsoft.Office.Project.Server.DataAccessLayer.SqlSessionManager.SqlSessionAdapter.<>c__DisplayClass13.<FillDataSetUsingExistingTables>b__12()
       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.FillTypedDataSet(DataSet typedDataSet, String[] tableNames, SqlCommand command, Boolean enforceConstraints)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.<>c__DisplayClass1d.<FillTypedDataSet>b__1b(IProjectServerSqlSession session)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.RunInActiveSession(Action`1 actionHandler)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand, Boolean enforceConstraints, String scopeName)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, String storedProcedureName, Int32 timeout, SqlParameter[] parameters)
       at Microsoft.Office.Project.Server.DataAccessLayer.ProjectDal.ReadProjects(Guid projectUid, Int32 filter)
       at Microsoft.Office.Project.Server.BusinessLayer.Project.ReadProjectInternal(Guid projectUid, DataStoreEnum dataStore, Boolean checkPermissions, Boolean includeLocalCustomFieldDefinitions)
       at Microsoft.Office.Project.Server.BusinessLayer.Project.ReadProjectWithLocalCustomFieldInformation(Guid projectUid, DataStoreEnum dataStore)
       at Microsoft.Office.Project.Server.Wcf.Implementation.CSOMImpl.<>c__DisplayClass10a.<ProjectReadProject>b__109()
       at Microsoft.Office.Project.Server.BusinessObjectMethodInvocation.InvokeBusinessObjectMethod(String methodName, IEnumerable`1 actions)"

    please advise. thanks.

    Wednesday, August 16, 2017 7:24 AM

All replies

  • Did you ever figure out this issue? I am having the same issue on a particular PWA 2016. 
    Tuesday, May 15, 2018 4:59 AM
  • Any suggestion? I have the same error. We made upgrade with December 2018 CU but error still is.

    I found column TaskCVP on view [pjrep].[MSP_EpmTask_UserView] but all tasks from this problematic project have 0 in TaskCVP column.

    Monday, March 11, 2019 11:07 AM