6
Please update release notes to include ANY table structucture (field size and/or type) changes.
When a field size is increased, this can break our custom reports that use a temp table with a structure matching the previous field size/type by causing a truncate error which results in a report run failure.
If we are made aware of these changes prior to Prod deployment, we can update our report temp table structures accordingly and proactively rather than having to rush to fix the errors which impact our users ability to work normally.
2 table structure changes found in 8.1 upgrade (due to report failure) include:
GeneralJournalAccountEntry.Text -ExtendedDataType TransTxt(Str60) changed to TransactionTextLarge(Str512)
ProjInvoiceOnAcc.Txt - ExtendedDataType TransTxt(Str60) changed to Description255
When a field size is increased, this can break our custom reports that use a temp table with a structure matching the previous field size/type by causing a truncate error which results in a report run failure.
If we are made aware of these changes prior to Prod deployment, we can update our report temp table structures accordingly and proactively rather than having to rush to fix the errors which impact our users ability to work normally.
2 table structure changes found in 8.1 upgrade (due to report failure) include:
GeneralJournalAccountEntry.Text -ExtendedDataType TransTxt(Str60) changed to TransactionTextLarge(Str512)
ProjInvoiceOnAcc.Txt - ExtendedDataType TransTxt(Str60) changed to Description255
STATUS DETAILS
Needs Votes