Integration of RQM v2.0.0.1 with Doors v9.2.0.1

Two things;
First, when you install the integration you should have the option to register the database, and so this step would be unnecessary.
Second,you say that

...register Doors Database with admin -a <Hostname> 36677 RQMISYNC RQMISYNC,...

Have you logged in to DOORS as RQMISYNC from a standard client? Have you checked that the password really is RQMISYNC (same as username)?
This step is always useful before calling support as it is likely to be one of the first things they will ask you to do. This verifies that the account is set up properly in DOORS before the integration attempts to use it.

Hi Hazel,

Question 1:
>> First, when you install the integration you should have the option to register the database, and so this step would be unnecessary.

I dont remember seeing the option. Under which steps of the installation did this option appear ?

Question 2:
>> Have you logged in to DOORS as RQMISYNC from a standard client? Have you checked that the password really is RQMISYNC (same as username)?

Yes.. i did check by logging into Doors with RQMISYNC with password RQMISYNC.

Thank you for your reply.

We had RQM 2.0.0.0 with DOORs 9.2.0.1.

When we upgraded to 2.0.0.1, it stopped working. Support is looking in to it for us.

We had RQM 2.0.0.0 with DOORs 9.2.0.1.

When we upgraded to 2.0.0.1, it stopped working. Support is looking in to it for us.

Thank you for your note.

Now i tried the integration between RQM v2.0.0 with Doors v9.2.0.1.

I still could not get it right as when i start RQMI Server, i received similar error.

INFO: RQMI Server v1.02.0002 starting...
Nov 10, 2009 10:30:39 PM uk.co.stpsoft.util.Log error
SEVERE: ERROR: DriverManager.getConnection(jdbc:derby:../../rqmdrsDB;create=fals
e;user=admin;password=<encrypted>) Database '../../rqmdrsDB' not found.
Nov 10, 2009 10:30:39 PM uk.co.stpsoft.util.Log error
SEVERE: ERROR: Sync Database Lookup Failure. Synchronisation cannot be started.
Nov 10, 2009 10:30:39 PM uk.co.stpsoft.util.Log error
SEVERE: ERROR: Exception: null
Nov 10, 2009 10:30:39 PM uk.co.stpsoft.util.Log app
INFO: Initialising server ...
Exception in thread "main" java.lang.StringIndexOutOfBoundsException
at java.lang.String.substring(String.java:1088)
at uk.co.stpsoft.exportserver.RemoteRQMWorker.get(Unknown Source)
at uk.co.stpsoft.exportserver.RQMRMI.initialiseNextTestPlanId(Unknown So
urce)
at uk.co.stpsoft.exportserver.RQMRMI.main(Unknown Source)

Fyi.. before i run RQMI Server, i have started RQM successfully.

Appreciate anybody advise what could have gone wrong.

Thank you.

I'm running into a similar issue where nothing is coming over from the import.

I'm running into a similar issue where nothing is coming over from the import.

I have finally resolved it by not following the setting from the documentation which works for RQM v1.0.1 and Doors v9.2.

I did the following setting instead at the Jazz User Administration page for RQMISVR user.

1) Create a new user account with a userID of RQMISVR.

2) For repository permission, the user account should have both JazzAdmins and JazzUsers

3) For client access license, select Rational Quality Manager - Quality Manager and Rational Quality Manager - Connector.

4) Change the password of the RQMISVR user account.

5) Go to Jazz Project Administration Page

6) Edit each project area and add the RQMISVR user as a Administrator of the project

Interestingly, it works !! I am still trying to confirm with support whether the above is the confirmed setting.

I have finally resolved it by not following the setting from the documentation which works for RQM v1.0.1 and Doors v9.2.

I did the following setting instead at the Jazz User Administration page for RQMISVR user.

1) Create a new user account with a userID of RQMISVR.

2) For repository permission, the user account should have both JazzAdmins and JazzUsers

3) For client access license, select Rational Quality Manager - Quality Manager and Rational Quality Manager - Connector.

4) Change the password of the RQMISVR user account.

5) Go to Jazz Project Administration Page

6) Edit each project area and add the RQMISVR user as a Administrator of the project

Interestingly, it works !! I am still trying to confirm with support whether the above is the confirmed setting.

I have RQM 2.0 and DOORS 9.2.0.2 running. I have installed the RQM Interface server from DOORS to enable the RQM - DOORS integration. Initially I had problems because the settings I entered during installation for username and password (RQMISVR as recommended in the installation guide) were not written to the conf\server.properties file. I corrected the username in this file and ran admin.bat to correct the password. I also had to set the RQM hostname in this file. Having done this, it looks like the RQMI server runs and connects to the RQM server. The log of this is as below:

C:\Program Files\IBM\Rational\DOORS\9.2\RQMInterface\Server\IM\bin>serverstart.bat
Logging level: 1
10-Feb-2010 15:05:43 uk.co.stpsoft.util.Log app
INFO: RQMI Server v1.02.0002 starting...
10-Feb-2010 15:05:45 uk.co.stpsoft.util.Log app
INFO: Initialising server ...
10-Feb-2010 15:05:46 uk.co.stpsoft.util.Log app
INFO: Getting data from RQM ...
10-Feb-2010 15:05:46 uk.co.stpsoft.util.Log app
INFO: RQM RETURN STATUS: 200
10-Feb-2010 15:05:47 uk.co.stpsoft.util.Log app
INFO: Getting data from RQM ...
10-Feb-2010 15:05:47 uk.co.stpsoft.util.Log app
INFO: RQM RETURN STATUS: 200
10-Feb-2010 15:05:49 uk.co.stpsoft.util.Log app
INFO: Getting data from RQM ...
10-Feb-2010 15:05:51 uk.co.stpsoft.util.Log app
INFO: RQM RETURN STATUS: 200
10-Feb-2010 15:05:52 uk.co.stpsoft.util.Log app
INFO: Server started for build v1.02.0002 with database v1.01.0001

However, when I start DOORS (as RQMISYNC) and choose RQM -> Export to RQM, I get the error message:

The command could not be executed. Details: Connection to server could not be established. The RQM Interface client process may not be running. Please try closing and restarting the DOORS application.

Needless to say, restarting DOORS had no effect. Has anyone got any advice on how to resolve this please?

Thanks,
Mark

I've fixed this issue and now have DOORS 9.2.0.2 working with RQM 2.0. My error was during the RQM Interface client installation, I had entered the host name of the RQM server rather than the RQMI server. I have these running on different machines. In my defence, I did this because I followed the DOORS Installation Guide manual which has an error in it and specifies that the RQM Server hostname should be entered when in fact it should be the RQMI Server hostname. I can't help but think that a different name for the Interface server could have been thought up to avoid confusion between RQM and RQMI.
Note that the "Installing and Using RQMI" manual is correct and much more informative than the DOORS install guide.

Mark

I am attempting integrating DOORS with RQM. I have installed DOORS 9.2.0.2, RQMI server v1.02.0002 and RQM 2.0.

I had installed earlier DOORS 9.2. Export to RQMI was generating XML but import to RQM was failing. After upgrading DOORS to 9.2.0.2, export is creating an exception on starting RQMI server as below:
Logging level: 1
Feb 12, 2010 8:18:42 AM uk.co.stpsoft.util.Log app
INFO: RQMI Server v1.02.0002 starting...
Feb 12, 2010 8:18:43 AM uk.co.stpsoft.util.Log error
SEVERE: ERROR: DriverManager.getConnection(jdbc:derby:../../rqmdrsDB;create=fals
e;user=admin;password=<encrypted>) Failed to start database '../../rqmdrsDB', se
e the next exception for details.
Feb 12, 2010 8:18:43 AM uk.co.stpsoft.util.Log error
SEVERE: ERROR: Sync Database Lookup Failure. Synchronisation cannot be started.
Feb 12, 2010 8:18:43 AM uk.co.stpsoft.util.Log error
SEVERE: ERROR: Exception: null
Feb 12, 2010 8:18:43 AM uk.co.stpsoft.util.Log app
INFO: Initialising server ...
Exception in thread "main" java.lang.StringIndexOutOfBoundsException
at java.lang.String.substring(String.java:1088)
at uk.co.stpsoft.exportserver.RemoteRQMWorker.get(Unknown Source)
at uk.co.stpsoft.exportserver.RQMRMI.initialiseNextTestPlanId(Unknown So
urce)
at uk.co.stpsoft.exportserver.RQMRMI.main(Unknown Source)

I have created users RQMISVR with permission for JazzAdmins, JazzDWAdmins, JazzUsers and JazzProjectAdmins, and with Rational Quality Manager - Quality Manager license assigned. I have created user RQMISYNC in DOORS.

Look forward to your help. Thanks in advance

Regards,

Vinod

I am attempting integrating DOORS with RQM. I have installed DOORS 9.2.0.2, RQMI server v1.02.0002 and RQM 2.0.

I had installed earlier DOORS 9.2. Export to RQMI was generating XML but import to RQM was failing. After upgrading DOORS to 9.2.0.2, export is creating an exception on starting RQMI server as below:
Logging level: 1
Feb 12, 2010 8:18:42 AM uk.co.stpsoft.util.Log app
INFO: RQMI Server v1.02.0002 starting...
Feb 12, 2010 8:18:43 AM uk.co.stpsoft.util.Log error
SEVERE: ERROR: DriverManager.getConnection(jdbc:derby:../../rqmdrsDB;create=fals
e;user=admin;password=<encrypted>) Failed to start database '../../rqmdrsDB', se
e the next exception for details.
Feb 12, 2010 8:18:43 AM uk.co.stpsoft.util.Log error
SEVERE: ERROR: Sync Database Lookup Failure. Synchronisation cannot be started.
Feb 12, 2010 8:18:43 AM uk.co.stpsoft.util.Log error
SEVERE: ERROR: Exception: null
Feb 12, 2010 8:18:43 AM uk.co.stpsoft.util.Log app
INFO: Initialising server ...
Exception in thread "main" java.lang.StringIndexOutOfBoundsException
at java.lang.String.substring(String.java:1088)
at uk.co.stpsoft.exportserver.RemoteRQMWorker.get(Unknown Source)
at uk.co.stpsoft.exportserver.RQMRMI.initialiseNextTestPlanId(Unknown So
urce)
at uk.co.stpsoft.exportserver.RQMRMI.main(Unknown Source)

I have created users RQMISVR with permission for JazzAdmins, JazzDWAdmins, JazzUsers and JazzProjectAdmins, and with Rational Quality Manager - Quality Manager license assigned. I have created user RQMISYNC in DOORS.

Look forward to your help. Thanks in advance

Regards,

Vinod

Vinod,

On your machine running the RQM Interface Server, check if the rqmdrsDB folder has been created. This should be created in the DOORS/9.2/RQMInterface/Server folder automatically. Also, to ask the obvious, have you started RQM before the Interface server?

Mark