Web/Portal Technologies - JDE1 (MOSC)

MOSC Banner

Unable to generate table after deleting two fields

edited Sep 19, 2020 5:04AM in Web/Portal Technologies - JDE1 (MOSC) 1 commentAnswered

Hi, There is one table F59IN071 recently changed to delete 2 fields as we were getting a size error while doing some operations.

After reducing the table size followed by DV/PY update package build/deployment and generated table successfully but again we are encountered the same error while testing..

Below is the log for your reference while generating table.

23164/15876 WRK:Starting jdeCallObject Wed Sep 9 08:28:03.342000 jdbodbc.c8118

ODB0000164 - STMT:00 [42000][1701][2] [Microsoft][SQL Server Native Client 11.0][SQL Server]Creating or altering table 'F59IN017' failed because the minimum row size would be 8355, including 23 bytes of internal overhead. This exceeds the maximum allowable table row size of 8060 bytes.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center