Detailed Description and Symptoms
While upgrading from an earlier version of 8.0 (P4) to 8.0 P7, the customers awinstall finished but they were unable to login to the GUI.
Upon investigation of the awinstall.log file there were several iternations of the error below:
ErrorMsg: AwE-5001 Database Query Error (1/20/12 3:18 PM)
0 tranmode: IN:VARCHAR2:java.lang.String:UF
1 sessionid: IN:OUT:NUMERIC:java.lang.Long:-1
2 status: IN:VARCHAR2:java.lang.String:FORCED
3 client_ip_address: IN:VARCHAR2::null?
?At this time, it was actually possible to get to the client page but the login was failing with the same pop-up error as was seen in the awinstall.log file. The results of 'awexe node' also reported that the Master was up and RUNNING.
After checking on the DB side we noticed that the aw_web_api package did not exist. In order to rebuild this package:
- Delete $AW_HOME/data/extract_file.dat file
- Re-run 'cdinstall' with the CD media/image mounted.
This should rebuild the missing package and resolve the issue.