NetManager.getUDCData(): An error occurred trying to fetch UDC data from UDC table in P5214
Purpose of Document
P5214 (Component Code / Burden Cross-Reference) issues Web Client Exception with error in both jasdebug.log and e1root.log as below,
[SEVERE] - [JAS] NetManager.getUDCData(): An error occurred trying to fetch UDC data from UDC table | UserName : USERID, Environment : PD920, User Role : *ALL java.lang.NullPointerException [WARN ] - [RUNTIME] VTComponent.setFocused caught an exception to the control : 0_12 java.lang.NullPointerException
On screen, error represents as below,
WEB CLIENT EXCEPTION An exception has been caught by the Web client. Please contact your system administrator. See log for details. Exception id = Exception_2016-29-10 16:07:10.055_USERID
Issue is caused by missing UDC 52/NB (Non-Billable Flag).
Commonly, this type of generic error can be coming when,
New functionality is added
Special instruction in related ESU is not performed
A certain Grid column is hidden
There is Data Dictionary Override for this hidden column
So to debug this type of issue,
Turn on rtdebugtrace=TRUE in JAS.INI in your WebDev client
Log on to WebDev client
Replicate issue
Analyze jasdebug.log which is turned on by step 1
Example of jasdebug.log:-
29 Jun 2016 12:08:30,122 [APP ] - [JDBJ] SELECT DTDL01,DTCDL FROM CRPCTL.F0004 WHERE ((DTSY = ? AND DTRT = ? )) 29 Jun 2016 12:08:30,122 [APP ] - [JDBJ] SQL statement parameter marker values are : 29 Jun 2016 12:08:30,122 [APP ] - [JDBJ] Param1 : 52_Types.VARCHAR, 29 Jun 2016 12:08:30,122 [APP ] - [JDBJ] Param2 : NB_Types.VARCHAR, 29 Jun 2016 12:08:30,123 [SEVERE] - [JAS] NetManager.getUDCData(): An error occurred trying to fetch UDC data from UDC table | UserName : USERID, Environment : PY900, User Role : *ALL java.lang.NullPointerException 29 Jun 2016 12:08:30,125 [WARN ] - [RUNTIME] VTComponent.setFocused caught an exception to the control : 0_12 java.lang.NullPointerException
Note: Above statement can be translated like SELECT DTDL01,DTCDL FROM CRPCTL.F0004 WHERE ((DTSY = '52' AND DTRT = 'NB' )) which did not return any data.
To fix this type of error,
Log on EnterpriseOne
(Fast Path) UDC, which gives you [Work With User Defined Codes] form
Enter 'Product Code' with '52'
(Form Exit) Code Types, which calls [Work With User Defined Code Types]
Click Add to add Code Type 'NB' (Description = 'Non-Billable Flag, Code Length = 1, 2nd Line(Y/N) = N, Numeric (Y/N) = N)
Enter User Defined Codes with 'NB' in form [Work With User Defined Codes] so Product Code = '52' AND User Defined Codes = 'NB'