The updatedb script fails during the application of the fix pack

If the updatedb script fails, you can try to perform a manual update of the database.

Problem

The updatedb process fails during the WebSphere Commerce fix pack update.

Solution

Complete these steps:

Go to the following directory:
- WC_installdir/logs/updatedb
- WC_installdir\logs\updatedb
- WCDE_installdir\logs
Review the following log files:
- updatedb-instance_name.log
- updatedb.log
- trace.txt
- messages.txt
Where instance_name is the name of your instance, such as demo. For instance, updatedb-demo.log. The trace.txt and messages.txt files are log files for the massload utility, which is called by the updatedb utility. Review these error messages with your database administrator to ensure that there are no data errors.
Note: You can also encounter errors when you are running a process or utility if the input parameters that are used to establish a database connection are incorrect. To validate that a database connection can be established with the configured input parameters, use the database connection validation utility. For more information about running this utility, see Running the database connection validation utility.
Reattempt the database update by using one of the following options:
- Fix the issues and rerun the updatedb utility. The updatedb utility can resume from the point of failure.
- Manually update the database:
  1. Ensure that you have a backup of the database. This backup ensures that the database is reverted to the state it was in before the unsuccessful attempt to run the updatedb command.
  2. Complete one of the following actions:
    - Log on as the non-root user.
    - Log on as a user with Administrator privileges
  3. From a command prompt, run the following command:
    - WC_installdir/bin/updatedb.sh instance_name [currentPropFile]
    - WC_installdir/bin/updatedb.bat instance_name [currentPropFile]
    - WC_installdir/bin/updatedb.sh instance_name [currentPropFile]
    Where instance_name is the name of the instance to be updated.
    The currentPropFile is the full path and name of the database properties file. The currentPropFile is used when a database, other than the one specified in the instance.xml file, is to be updated. For example, two databases might be configured; one for operational purposes and the other for content purposes. The currentPropFile takes the same format as the createInstance.properties found under directory WC_installdir/instances/instance_name/properties. The database section in the currentPropFile is used to acquire the parameters that are required for the updatedb command.
  4. When the update is complete, review the output that is displayed in the console window and ensure that you successfully update the database to the correct fix pack level. For example:
```
UpdateSiteTable: [EchoNL] Updating database fixpack level ... 
[eCDatabaseVersionInfo] UPDATE SITE SET EDITION='ENT', VERSION=7, RELEASE=0, MOD=0, FIXPACK=X WHERE COMPNAME='BASE' 
[eCDatabaseVersionInfo] SELECT COUNT(*) FROM SITE 
[eCDatabaseVersionInfo] SELECT * FROM SITE 
[eCDatabaseVersionInfo] Columns in SITE table: 
[eCDatabaseVersionInfo] COMPNAME=BASE 
[eCDatabaseVersionInfo] EDITION=ENT 
[eCDatabaseVersionInfo] VERSION=8 
[eCDatabaseVersionInfo] RELEASE=0 
[eCDatabaseVersionInfo] MOD=0 
[eCDatabaseVersionInfo] FIXPACK=X 
[eCDatabaseVersionInfo] Updated SITE table successfully. 
[EchoNL] Completed database fixpack update.  BUILD SUCCESSFUL 
```
    Where X is the number of the fix pack installed.