RQMI Error when trying to start server

Hi Randy,

it seems that you receive this error because there is no project area yet. At least I'm able to reproduce your error message if I archive all existing project areas.

Could you please create a project area there your user RQMISVR is a member of and assign a process role to him.
Restart RQMI server and the error should be gone.

Hi Paul,

Thank you for the response. I've posted the entire log with logging level 2 turned on. I'm not sure if this helps or not. Please let me know if there are other places I can look to help determine a root cause.

Also I'm not using any special characters for the RQMISVR password. I also verified that I was able to log in to RQM with the RQMISVR account I created.

Logging level: 2
Aug 23, 2013 10:10:35 AM uk.co.stpsoft.util.Log server
INFO: Initialise RMI_HOST: aur-jps-rqm01
Aug 23, 2013 10:10:35 AM uk.co.stpsoft.util.Log server
INFO: Initialise RMI_PORT: 7764
Aug 23, 2013 10:10:35 AM uk.co.stpsoft.util.Log server
INFO: Initialise RMI_PORT2: 7765
Aug 23, 2013 10:10:35 AM uk.co.stpsoft.util.Log server
INFO: Initialise POOL_SIZE: 20
Aug 23, 2013 10:10:35 AM uk.co.stpsoft.util.Log server
INFO: Initialise IPC_PORT: 8768
Aug 23, 2013 10:10:35 AM uk.co.stpsoft.util.Log server
INFO: GET _registryManager
Aug 23, 2013 10:10:35 AM uk.co.stpsoft.util.Log server
INFO: Attempting to get an existing registry ...
creating SSL ServerSocket on port 7764
Aug 23, 2013 10:10:36 AM uk.co.stpsoft.util.Log server
INFO: Existing registry retieved
Aug 23, 2013 10:10:36 AM uk.co.stpsoft.util.Log app
INFO: RQMI Server v1.03.0004 starting...
Aug 23, 2013 10:10:36 AM uk.co.stpsoft.util.Log server
INFO: RMI_PORT: 7764
Aug 23, 2013 10:10:36 AM uk.co.stpsoft.util.Log server
INFO: Database connection string:jdbc:derby:../../rqmdrsDB;create=false;user=adm
in;password=<encrypted>
Aug 23, 2013 10:10:36 AM uk.co.stpsoft.util.Log server
INFO: derby.locks.deadlockTimeout=15
Aug 23, 2013 10:10:36 AM uk.co.stpsoft.util.Log server
INFO: derby.locks.waitTimeout=60
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: The connection is live
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: DBManager.executeGet: BeforeQuery(SELECT * FROM Database)
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Procedure: BeforePrepareStatement(SELECT * FROM Database)
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Procedure: AfterPrepareStatement(SELECT * FROM Database)
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Procedure: BeforeQuery(SELECT * FROM Database)
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Procedure: AfterQuery(SELECT * FROM Database)
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: DBManager.executeGet: AfterQuery(SELECT * FROM Database)
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: FieldCount = 5
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: DBManager.executeGet: RowCount = 1
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log app
INFO: Synchronisation started for: 36677@aur-nce-doors01
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log app
INFO: URL Synchronisation started for: 36677@aur-nce-doors01
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log app
INFO: Initialising server ...
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: creating ServerSocket on port 7765
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: get(ResourceType: ALL_PROJECT_AREAS)
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: the worker has been created
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Getting from ... /qm/secure/service/com.ibm.rqm.integration.service.IInteg
rationService/projects?abbreviate=false
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: client reference
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Start new thread for submitting SSL to RQM
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Security provider
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: client Object created
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: requesting authrequired ...
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log sync
INFO: Sync Interval = 1440
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log sync
INFO: Sync Interval is: 1440 minutes.
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log sync
INFO: URL Sync Interval = 1440
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: requesting initialization data ...
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Logging into RQM ...
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: responseCode ...302
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: ResponseCode 3: 302
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Login request status 302
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log app
INFO: Getting data from RQM ...
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log app
INFO: RQM RETURN STATUS: 200
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: COMPLETE_XML: <?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
<title type="text">projects ATOM feed for all project areas</title>
<id>https://generic-rqm01.contoso.com:9443/qm/service/com.ibm.rqm.integration
.service.IIntegrationService/projects</id>
<link href="https://generic-rqm01.contoso.com:9443/qm/web/console/" rel="alte
rnate"/>
<link rel="self" href="https://generic-rqm01.contoso.com:9443/qm/service/com.
ibm.rqm.integration.service.IIntegrationService/projects?abbreviate=false"/>
</feed>
Aug 23, 2013 10:10:37 AM uk.co.stpsoft.util.Log server
INFO: Obtained all project area's
Exception in thread "main" java.lang.NullPointerException
        at uk.co.stpsoft.exportserver.RQMRMI.initialiseNextTestPlanId(Unknown So
urce)
        at uk.co.stpsoft.exportserver.RQMRMI.main(Unknown Source)

Unfortunately this is the whole error, as stated above, if you know another place for me to look to help gather information I would appreciate it. I've changed the https addresses simply for security reasons.

Thank you,

Randy