It's all about the answers!

Ask a question

Insight RTC Connection Issue


Mai Yang (2144) | asked Dec 20 '11, 10:09 a.m.
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



permanent link
wei zhang (2011) | answered Dec 22 '11, 9:00 p.m.
JAZZ DEVELOPER
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.

permanent link
Mai Yang (2144) | answered Dec 27 '11, 11:31 a.m.
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


Register or to post 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.