Upgrade to 8.0 P7 failing with AwE-5001 error on aw_web_api.aw_client_session

Document ID : KB000088994
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Upgrade to 8.0 P7 failing with AwE-5001 error on aw_web_api.aw_client_session
Resolution:
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.


Investigation

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) 
      Details: aw_web_api.aw_client_session
       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?


Solution

?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.