IFBO database trigger and stored procedure create Asset Suite abend

Abend similar to the following shows up on Unix box in directory ../region/REGION/res/ABND.tdq:

2009-09-15-07.43.59.431000TIGECPHYNETNAME DCG2260 DCG2260 N/A +A2KPD0521491030E0C0000000000000000000000000000PASS APPLICATION P
ROGRAM FAILURE 09/15/09 07:43 Program: TIGECPHY Terminal ID: +A2K
Task Number: 2149103 0000000000 Transaction: PD05 MAP STACK : X000 D050

LINK TRACE: TIGMAIN
TIGCURS TIGECPHY

APPLICATION OR SYSTEM FATL ABEND DETECTED IRREGULAR SQL CODE ENCOUNTERED: -0
00029541 ORA-29541: class PASSPORT.com/indus/apibo/afjutcbo/UTecphy could not be resolved ORA-
06512: at "PASSPORT.UTECPHYP", line 1 ORA-06512: at "PASSPORT.UTECYU", line 2 ORA-04088: error during execution of trigger 'PASSPORT.UTE
CPHYU' 4000-UPDATE.

First thing to be aware of is that the Java class, com/indus/apibo/afjutcbo/UTecphy, is stored in the database and not in a jar file.

Connect to the Oracle database as the schema owner and use SQL: select * from user_objects where object_type like '%JAVA%' and status != 'VALID';

Look in the IFBO install log file: create_triggers.log

You're looking for normal Java compile errors like "cannot resolve symbol".