TechNote (Archived)

java.lang.OutOfMemoryError database error

Issue

---

During the upgrade from Breeze 4.1 to Breeze 5.0, the log produces a "java.lang.OutOfMemoryError" message. As a result, the Breeze upgrade process is aborted.

Below is a snippet from the log related to this error:

 java.lang.Exception: Script error at line 2742.  Cause: java.lang.OutOfMemoryError  Parameters: DB_DEST=db_tmobile confirm-schedule-downtime=true migrate=true account-id=7 confirm-backup-content=true confirm-backup-database=true src=breeze.. feature=766 dest=db_tmobile.. async=true feature=766=Upgrade Breeze confirm-upgrade=true  Statement: {exec:INSERT INTO PPS_TRANSCRIPT_DETAILS (TRANSCRIPT_ID, INTERACTION_ID, SCORE, RESPONSE, DATE_CREATED) VALUES (?, ?, ?, ?, ?) ! SELECT   V.TRANSCRIPT_ID,   AI.INTERACTION_ID,          0, NULL,          MAX(V.DATE_CREATED) FROM PPS_TRANSCRIPTS T, PPS_TRANSCRIPT_VIEWS V, PPS_SCOS S, {dest}PPS_SCO_ASSETS SA, {dest}PPS_ASSET_INTERACTIONS AI WHERE T.TRANSCRIPT_ID = V.TRANSCRIPT_ID AND T.SCO_ID = S.SCO_ID AND S.SCO_ID = SA.SCO_ID AND SA.ASSET_TYPE = 0 AND SA.ASSET_ID = AI.ASSET_ID AND AI.INTERACTION_TYPE = 10 AND V.SLIDE_NUMBER = AI.DISPLAY_SEQ AND S.tree_id IN (SELECT tree_id FROM pps_trees WHERE account_id = {account-id}) GROUP BY V.TRANSCRIPT_ID, AI.INTERACTION_ID ORDER BY INTERACTION_ID }       at com.macromedia.airspeed.db.SQLServerUtilityQueries.runScript (SQLServerUtilityQueries.java:279)      at com.macromedia.airspeed.db.SQLServerUtilityQueries$1.run (SQLServerUtilityQueries.java:151) 

Reason

---

The Java memory in Breeze 5 does not have sufficient memory allocated to process all records in the database.

Solution

---

Follow the steps below to increase the Breeze memory:

1. Logon to the Breeze 5 server.
2. Navigate to the C:\Breeze\appserv\win32 directory.
3. Open the jvm.config file for editing.
4. Search for java.args=-Xmx400m in the file.
5. Increase the number from "400" to "900".
6. Stop the Macromedia Breeze Application Service.
7. Start the Macromedia Breeze Application Service.
8. Repeat the upgrade process using the Breeze Console (http://localhost:8510/console) to upgrade the database.

Search Support

---