Datamart java.lang.OutOfMemoryError: Java heap space

0 Likes

The following error message occurs after a Datamart Extract:

Exit code = 5

Run-time errors:
java.lang.OutOfMemoryError: Java heap space
at com.microsoft.sqlserver.jdbc.TDSPacket.(Unknown Source)
at
com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at
com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at
com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source)
at
com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet$1CloseServerCursorCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.closeServerCursor(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.close(Unknown Source)
at
com.borland.starteam.server.PreparedQuery.collectAll(PreparedQuery.java:241)
at
com.borland.starteam.server.PreparedQuery.executeAll(PreparedQuery.java:151)
at
com.borland.starteam.server.QueryRegistry.getAllObjects(QueryRegistry.java:193)
at com.borland.starteam.server.dbobject.ServerSettings.getAllAccessControlData(ServerSettings.java:793)
at
com.borland.starteam.extractor.ACLExtractor.populateTable(ACLExtractor.java:221)
at com.borland.starteam.extractor.Extractor.doExtract(Extractor.java:481)
at com.borland.starteam.extractor.Extractor.extract(Extractor.java:399)
at com.borland.starteam.extractor.Extractor.run(Extractor.java:66)

Two known solutions:

1. Exit Code 5:  Datamart ran out of memory while executing or had some other memory issue

Often resolved by tweaking the associated "Datamart .stjava" file.

2. Rebuilding indexes using the StarTeam dbcc reindex script and update statistics script.

These scripts can be found typically:

C:\Program Files\Borland\StarTeam Server 13.0\DBScripts\Sqlserver_Scripts

Alternatively they are attached to the article below:

starteam_sqlserver_dbcc_reindex.sql

starteam_sqlserver_update_statistics.sql

Run these scripts against your StarTeam database.  It is advised that you take a backup of your StarTeam db before attempting to run these scripts.

These scripts will help clean up your database and improve the performance.

Run the dbcc_reindex script first followed by the update statistics script before attempting the next extract.

Reference id #2668267

Comment List
Related
Recommended