UDField on RCVDTL

Hi, I created a field on the RCVDTL table using the usual procedure. I now receive this error when trying to receive something. Really not sure where to start looking to figure out how to fix it. As you can see, the new field is synced in the data model. Any ideas?

Thank you


## System Information ##
==================

AppServer Connection: net.tcp://GAIERP1/ERP10Prod
Form Name: Receipt Entry
Customization Name: V10_NoCost
Menu ID: LOG_RcpE
Software Version: 10.2.700.8

============

Application Error

Exception caught in: System.Data

## Error Detail ##
============
##!Message:##! Input array is longer than the number of columns in this table.
##!Program:##! System.Data.dll
##!Method:##! NewRecordFromArray

## Client Stack Trace ##
==================
   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 Ice.DatasetAdapter.LoadRow[TIceRow,TDataTable](TDataTable destinationTable, Func`2 copyIceRowToArray, TIceRow returnedRow, IceRowState rowState)
   at Ice.DatasetAdapter.CopyTSTableToDataTable[TIceRow,TDataTable](IceTable`1 sourceTSTable, TDataTable destinationTable)
   at lambda_method(Closure , IIceTable , DataTable )
   at Ice.DatasetAdapter.Copy(IceTableset sourceTableset, DataSet destinationDataset)
   at Erp.Proxy.BO.ReceiptImpl.OnChangeDtlReceived(Int32 vendorNum, String purPoint, String packSlip, Int32 packLine, Boolean ipReceived, ReceiptDataSet ds)
   at Erp.Adapters.ReceiptAdapter.OnChangeDtlReceived(Int32 vendorNum, String purPoint, String packSlip, Int32 packLine, Boolean ipReceived)

@alexbg89 I would stop / start all appservers using that database and the task agents to be sure that everything had a chance to reread the schema.

If you are onprem and have SSMS do you see the field in the UD table and the dbo view?

@gpayne thanks for your answer. Yes I do see it in the DBO model in SSMS. I have restarted my app server and everything resolved. Probably went to fast initially.

Thanks again

1 Like