Native Error 30190
1291704; CQ; ClearQuest; command line; cqload; importschema; importing; schemas; SQLAllocStmt; PERL; perl5lib; jre; path; module; Out Of Memory; importschema FAILED Technote (troubleshooting) Problem(Abstract) This technote explains how to resolve an "Out of Memory" error that occurs when using the cqload importschema command in IBM Rational ClearQuest. Symptom 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!
********************************************************* Cause 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-
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By http://www.ibm.com/support/docview.wss?uid=swg21291704 Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. ODBC Forum at Tek-Tips HomeForumsProject and Data ManagementData Management Programming issuesODBC Forum ERROR IN ODBC LAYER thread706-86648 Forum Search FAQs Links MVPs ERROR IN ODBC LAYER ERROR IN ODBC LAYER apples (IS/IT--Management) (OP) 25 May 01 03:43 The following error occurs in http://www.tek-tips.com/viewthread.cfm?qid=86648 a database function.ODBC(0)INTERSOLVI(ODBC Oracle driver) out of memoryNative Error 30190Please helpThanks Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Click Here to join Tek-Tips and talk with other members! Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Registration on or use of this site constitutes acceptance of our Privacy Policy. Close Box Join Tek-Tips Today! Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Register now while it's still free! Already a member? Close this window and log in. Join UsClose
AdvocacyBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)HelpCommunities TipsCommunities YouTubeBMC Social Central (BMC Only)CommunitiesFree TrialsLog inRegisterCommunities Free TrialsSupportDocumentationAbout BMCNewsLog inRegister Products Events BMC Engage CommunityBMC Exchange EventsDevelopersDeveloper CommunityDeveloper PortalPartners Partner https://communities.bmc.com/thread/30190?start=0&tstart=0 DirectoriesTechnology Alliance Program (TAP)Solution Provider Portal (SPP)User Groups All groupsLocal User GroupsEvent CalendarCustomer ProgramsBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)Help Communities TipsCommunities YouTubeBMC Social Central (BMC Only)Search the BMC CommunitiesSearch the BMC CommunitiesCancelError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it native error enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Discovery / ADDM All PlacesProductsDiscovery / ADDM 13 Replies Latest reply on Sep 15, 2009 2:51 PM by Matt Savino (Socket error - 10048) when using ARTCPPORT native error 30190 variable Petrus Johansson May 12, 2009 1:04 AM Hi,Has anyone run into issues with windows when using the system variable ARTCPPORT when connecting FD/TD 1.6 to Atrium CMDB?I have severe problems deploying the CDM extensions to CMDB because of this. Once the dialogue of selecting the extensions to deploy appears, I try to select and de-select some extensions. After every selection FD/TD makes a new connection to CMDB checking for already deployed extensions. When doing this scenario slowly, it works without any errors. But when doing it in a "normal" pace, I get ARERR90 (Socket error - 10048).Already spent weeks in investigating the network, firewalls, AIX server, AR System but nothing... Now my attention is at the Discovery server itself.I can only imagine the problems FD/TD might have synchronizing the CIs to CMDB if I got this problems now...Can I work around it somehow?We do NOT use portmapper on AR System side. Reason is there are firewalls between Discovery and CMDB.Any ideas is much appreciated!Thanks! 8179Views Tags: none (add) This