IBM Support

Out of Memory error occurs when running using the importschema command

Technote (troubleshooting)


This technote explains how to resolve an "Out of Memory" error that occurs when using the cqload importschema command in IBM® Rational® ClearQuest®.


The cqload importschema command fails with an "Out of Memory" error message:

Starting importschema
SQLAllocStmt: RETCODE=-1, State=S1001, Native Error=30190
SQL statement="select max(schema_rev) from master_schemarevs where schema_id = 29"
[DataDirect][ODBC Oracle Wire Protocol driver]Out Of Memory
ERROR: importschema FAILED!


There are two known causes of this problem:

Cause 1

The environment variable paths PATH and PERL5LIB contain versions of Java or Perl that conflict with the packaged versions that ClearQuest requires. This happens when Oracle software is installed on the same computer. Oracle 10g creates a PERL5LIB environment variable, and setting this value on the machine cause this error message indirectly. 1

Cause 2

The export of the schema is from a 2003.06.x version of ClearQuest. 2

Resolving the problem

Solution to Cause 1:

If the PERL5LIB variable has any values for Perl libraries that are set by installing other applications like Oracle 10g, then set the necessary values in the beginning for PERL5LIB by going into the Microsoft® Windows® Control Panel, and selecting the System folder. In the Advanced Tab, click on Environment Variables.

Set one of these paths as the first value, depending on your product version:

ClearQuest 7.0.x

C:\Program Files\Rational\Common\lib\perl5\5.8.6

ClearQuest 7.1.x

C:\Program Files\IBM\RationalSDLC\common\lib\perl5\5.8.6

There is no need to delete current values.

If the PERL5LIB variable does not have any values for Perl libraries, then simply unset the PERL5LIB environment variable. To do this, run the following command from the command prompt:

@set PERL5LIB=

Make sure that the PATH variable contains the value for the ClearQuest JRE location. If it is there already, move the ClearQuest-based JRE location to the beginning of the environment variable. These paths are based on the default installation directories:

ClearQuest 7.0.x

C:\Program Files\Rational\Common\java\jre

ClearQuest 7.1.x

C:\Program Files\IBM\RationalSDLC\common\Java5.0\jre


  • Changing environment variables might require a reboot of the machine in order for the changes to take effect.
  • If the error persists after changing these environment variables, uninstall and reinstall ClearQuest.

Solution to Cause 2:

Connect to the source schema repository with a 7.x installation, and export the schema from there. Attempting the import again should yield no further "Out of Memory" errors.

Related information

Error: Failed condition:m_pPerl != 0 when creating a n

Document information

More support for: Rational ClearQuest
Command Line Tools - CQLoad

Software version: 7.0,,,,,,,, 7.0.1,,,,,,, 7.1,,

Operating system(s): Windows

Reference #: 1291704

Modified date: 16 September 2009