Insight RTC Connection Issue
I installed Insight and Database all on a single Windows 2008 x64 server (Oracle 11g EE, Insight 1.0.1.1 with all options). The installation was successful. I can run all the sample reports using the sample data (Online Auction Project). My goal is to connect Insight with our RTC QA instance to produce reports. I followed instructions from the Configuring Insight for RTC.doc document to established the connections. I was able to set up the Rational Team Concert connection, and the Rational Data Warehouse connection (test connection was OK for both). However, when I run the Loop_RTC2.0.0.2 job, the job always stopped quickly due to Unexpected argument Connection.
Here is the command line that runs the job from the Run Jobstream popup window: ============================================== "d:\app\ibm\rational insight\cognos\bin\rundsjob.exe" -P "ORACLE" "DBO_User/~05891659D329428EFB68AC2B37B5E74266@RTC_QA" "Loop_RTC2.0.0.2" -VTRACE_VALUES=PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDSQL,USER,VARIABLE =============================================== Here are the log messages from the console when I executed the job: ============================================== Data Manager v8.4.104.13 -- ((C) Copyright IBM Corp. 2005, 2009.) COGNOS INTERNAL USE ONLY jobstream -- start run on EI1454VWIN.FMR.COM (20-Dec-2011 09:38:01) JobStream 'Loop_RTC2.0.0.2' - run id 38, audit id 38 TRACE_VALUES = 'PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDSQL ,USER,VARIABLE' DS_LOB_MAXMEM_SIZE = '65536' DS_LOB_BUF_SIZE = '8000' DS_DBMS_TRIM = 'SPACE' DS_UDA_FETCH_ROWS = '50' DS_UDA_BULKWRITE_ROWS = '50' DS_RUN_TIMESTAMP = 2011-12-20 09:38:02 DS_JOBSTREAM_NAME = 'Loop_RTC2.0.0.2' DS_JOBSTREAM_FNAME = 'Loop_RTC2_0_0_2' DS_AUDIT_ID = 38 DS_JOB_AUDIT_ID = 38 DS_RUN_ID = 38 DS_LOG_DIR = 'D:\app\IBM\Rational Insight\cognos\dataman ager\log' DS_LOG_NAME = 'D:\app\IBM\Rational Insight\cognos\datama nager\log\Job_Loop_RTC2_0_0_2_0038.log' DS_MAX_RECURSION = '100' . TRACE_VALUES = 'PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDS QL,USER,VARIABLE' . AUDIT_VALUES = 'TIMING,ALERT,USER' . DM_OS = 'WIN32' . DMCATUSR = 'DBO_USER' . DMCATPASSWD = 'PASSWORD' . DMCATDRIVER = 'Oracle' . DMCATDB = 'RTC_QA' . SQLSERVINST = '' . WINAUTH = FALSE . SQLSERV_VERSION = '2005' . DMCATCONSTR = 'ORACLE DBO_USER/PASSWORD@RTC_QA' . JOB_NAME = 'RTC2.0.0.2' JobStream 'Loop_RTC2.0.0.2' 'Loop_RTC'; starting Start Node 1 'Start'; Idle -> Succeeded Condition Node 4 'DataManagerOS'; Pending -> Executing Condition Node 4 'DataManagerOS'; executing (inline) Condition Node 4 'DataManagerOS'; Executing -> Succeeded Condition Node 4 'DataManagerOS'; succeeded (TRUE) RESULT = TRUE Procedure Node 3 'UnixDM'; Idle -> Suspended Procedure Node 2 'WindowsDM'; Idle -> Executing Procedure Node 2 'WindowsDM'; executing (inline) Data Manager v8.4.104.13 -- ((C) Copyright IBM Corp. 2005, 2009.) Catalog Export -- start run on EI1454VWIN.FMR.COM (20-Dec-2011 09:38:04) Catalog Export -- completed (20-Dec-2011 09:38:04) Unexpected argument "Connection" Usage: r <jobstream_name> Where are: {-V<name>} Procedure Node 2 'WindowsDM'; Executing -> Succeeded Procedure Node 2 'WindowsDM'; succeeded RESULT = TRUE Done - 0 00:00:04 elapsed jobstream -- completed (20-Dec-2011 09:38:05) =============================================== Has anyone run into the same issue? Any help is highly appreciated. Thanks, Mai |
2 answers
Mai,
Please double check your parameters DMCATUSR, DMCATPASSWD, DMCATDRIVER, DMCATDB of Loop_RTC2.0.0.2 job. These parameters will be point to Datamanager catalog database, not RTC repository database. |
Wei,
Thanks for the reply. I changed the parameters to point to the DM catalog database. But I still ran into the same issue with "Unexpected argument Connection". I did some debugging and I found the cause of the issue. The WindowsDM node under the Loop_RTC2.0.0.2 job uses a command "catexp" to generate a file called ListRTC.txt, which contains all the connection info to the RIDW and RTC databases. This file is then used to create the RTC1.txt file. The issue is that some additional text ('Connection Details:\n\nUSER: dba_user\nSQL*NET Service: RIDW', and 'Connection Details:\n\nUser: RTC_ENT_Q001DBO\n\nSQL*NET Service: RTC_QA') is added to each line (see the blue strings below). If I pause the execution of the job, remove the 'Connection Details.." string from RTC1.txt file, and resume the job, the Loop_RTC2.0.0.2 job can proceed without complaining. This is just a hack to get things going. Can you tell me how/where to change "catexp"/or Data Manager setting to export the connection info without adding the 'Connection Details..'? The line that creates the ListRTC.txt file in WindowsDM node is: System('catexp {$DMCATCONSTR} ..\ricon\ListRTC.txt A'); Here is result ListRTC.txt file that was created by the command above: ================================================ // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'ClearCase' ODBC 'DSN=ClearCase;DBMS=(other);COGNOSSQL=FALSE;UNICODE=TRUE' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'ClearQuest' ODBC 'DSN=ClearQuest;DBMS=(other);COGNOSSQL=FALSE;UNICODE=TRUE' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'Doors' ODBC 'DSN=DOORS;DBMS=(other);COGNOSSQL=FALSE;UNICODE=TRUE' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'FocalPoint' ODBC 'DSN=FocalPoint;DBMS=(other);COGNOSSQL=FALSE;UNICODE=TRUE' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'MS Project' ODBC 'DSN=MS Project;DBMS=(other);COGNOSSQL=FALSE;UNICODE=TRUE' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'Rational Data Warehouse' ORACLE 'dba_user/~6CEEF4886718BF5D3406E28518E7954BD9@RIDW' 'Connection Details:\n\nUSER: dba_user\nSQL*NET Service: RIDW' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'Rational Quality Manager' ODBC 'DSN=RQM;DBMS=(other);UNICODE=TRUE;COGNOSSQL=FALSE' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'Rational Team Concert' ORACLE 'RTC_ENT_Q001DBO/~3DC18601B3419216BB60DC93D78DF78AE6@RTC_QA' 'Connection Details:\n\nUser: RTC_ENT_Q001DBO\n\nSQL*NET Service: RTC_QA' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'ReportPlannedData' ODBC 'DSN=PlannedData;DBMS=(other);COGNOSSQL=FALSE;UNICODE=TRUE' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'RequisitePro' ODBC 'DSN=ReqPro;DBMS=(other);COGNOSSQL=FALSE;UNICODE=TRUE' // Database Alias specification // Data Manager - catalog API v8.0 <DEFAULT> 'TestManager' ODBC 'DSN=TestManager;DBMS=(other);COGNOSSQL=FALSE;UNICODE=TRUE' ================================= Many thanks for the help. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.