Case Study - Web Client Exception in P1207 with Invalid row number (-1)
Purpose of Document
In running Equipment PM Schedule (P1207) user hits Web Client Exception for specific equipment number 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_2014-11-17 00:46:00.837_SDONGMYE Invalid row number (-1) com.jdedwards.base.exception.RuntimeGridException: Invalid row number (-1)
STEPS TO DUPLICATE
Go to P1207 (Equipment PM Schedule)
(Row Exit) Routes
Note:
This error is caused by corrupted data or, integrity between F1308 (Equipment Routes Table) and F1201 (Asset Master File)
Grid can be collapsed
A certain asset is deleted from F1201 (Asset Master File)
Missing data from F1201 or data integrity between F1308 and F1201. Such as, having an asset previosly existed in both F1201 and in F1308, but the record is deleted from F1201, but not F1308.
Return Primary Asset Number GC Equipment Number <- BF szAssetNumberInput BC Asset Item Number (F1308)(NUMB) -> BF mnAssetItemNumber GC Description <- BF szDescription001 "1" -> BF cModeOptions
Note:
Above business function EditPrimaryAssetNumber (N1700150, Return Primary Asset Number) is client only business function so it is running in JAS not logic server
If above business function fails to return, then it issues error Invalid Row Number (-1) which is not exactly the issue is about (because it is running in JAS (Java Application Server)
For this example, when user reaches (Equipment) routes it issues SELECT F0SRVT,F0EQR3,F0NUMB,F0AAID FROM PRODDTA.F1308 WHERE (((F0AAID = 128 AND F0SRVT = 'CHECK' ))) ORDER BY F0NUMB ASC
Then based on return value from above query, it gets Description from F1201
