Exit C2050-725 IBM WebSphere Commerce V7 (FEP 7), Application Development
Question 3 of 5
0% complete
Q3 Single choice

An application developer recently installed Fix Pack 8 to their Fix Pack 5 IBM WebSphere Commerce Developer toolkit. When the developer was in the process of executing the updateDB steps, they experienced a power outage on their workstation several minutes after the scripts had been successfully running.

After rebooting their system, the developer continued their upgrade where they left off on the updateDB steps, but the script failed immediately after it was started. The following errors were observed in the logs:

Upon researching the -612 error code, the following information is provided: "A non-unique name was specified where a unique name is required. Column names must be uniquewithin an index, a table, or a view, and in the UPDATE OF clause of a trigger definition."

What is the most likely cause of this issue, and how should it be rectified?

  • A

    The -612 error code indicates that configureDatabaseFixpack.xml contains duplicate database commitment statements for the GEONODE table. The developer will need to restore configureDatabaseFixpack.xml before they can continue with the updateDB script.

  • B

    The -612 error code indicates that configureDatabaseFixpack.xml contains duplicate corrupt entries.
    The developer will need to re-run the Fix Pack upgrade before they can re-run the updateDB script.

  • C

    The -612 error code indicates that the database changes have been committed via configureDatabaseFixpack.xml to a duplicate GEONODE table. The developer will need to delete the duplicate table and re-run the updateDB script.

  • D

    The -612 error code indicates that the database change which updateDB is trying to perform has already been successfully completed previously. The developer will need to restore the database and re-run the updateDB script.