none
Project Server 2016 getting System.ArgumentException Error

    Pertanyaan

  • 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.

    Rabu, 16 Agustus 2017 07.24

Semua Balasan