Re: LMS 2.2 - JRM server down

john.sobrinho · ‎08-05-2003

We just upgraded from LMS 2.1 to 2.2.

Stopped all services, upgraded the server to SP3, stopped all cw2k services again and proceeded to upgrade to LMS 2.2 and IDU 4.0.

ServerConfig > Admin > Job Management

We are receiving JRM Display init. error, JRM service is down or inaccessible.

Tried stop/start services, reined passwords with encryption options, tried different passwords.

Watching pd show, looks like the service dies after 50 seconds - 1 minute from starting.

Also, cannot add jobs in Campus Manager > Admin > Job Schedule

Has anyone else run into this ?

amritpatek · ‎08-11-2003

Seems like its hitting a bug CSCeb04086. Why dont you try the workaround given for this bug ?

a.swain · ‎08-11-2003

I was not able to find the bug ID.... Is this correct? ( CSCeb04086 )

rmushtaq · ‎08-12-2003

Are you using CCO Bug Toolkit to view it ?

http://www.cisco.com/cgi-bin/Support/Bugtool/launch_bugtool.pl

john.sobrinho · ‎08-12-2003

I had a TAC case open on this issue and it was suggested I try this. This did not work in our situation.

I received a solution this morning which worked.

There are 3 lines of text that needed to be added in dbserver.properties file that for some reason was not updated during upgrade process.

The suggested solution will work most of the time.

Thanks

John

andy.walker · ‎11-11-2003

John

I think Iam running into the same problem. Please can you share the solution that worked for you ?

Thanks

Andy

john.sobrinho · ‎11-11-2003

Hi Andy...

On the server open a dos command window and issue

net stop crmdmgtd

make a backup copy of the file dbserver.properties file. Mine was located at c:\program files\cscopx\www\classpath\com\cisco\nm\cmf\dbservice\DBServer.properties

Open the original file and locate following section of test in your file ** note there may be more than one section with text, or the text lines may not fall in order, find the section that has the missing lines of text detailed futher below :

DBConnection.CWUID.cm=xxxxxxxxxxx=

DBConnection.CWPWD.cm=xxxxxxxxxxx=

DBConnection.CWENCYRYPTION.cmf=YES

Where xxx would be your encrypted password if you chose encryption. The last line CWENCRYPTION is whether encryption is enabled or not. So either yes or no

Once you have located the above text copy the following immediately below the lines.

DBConnection.dataSourceUrl.cmf=jbdc:sybase:Tds:localhost:43441?SERVICENAME=cmfdb

DBConnection.jbdcDriver.cmf=com.sybase.jbdc.SybDriver

There should be two lines of text. The message rolled over to the next line. (line 1 and 2).

Save the file after edit and net start crmdmgtd. Wait a few minutes for the services to reinitialize and check the status.

andy.walker · ‎11-11-2003

Many thanks John,

These lines were already in my file, so I guess my issue is slightly different. I'm going to go for a reinstallation of RME to see if that helps.

Thanks again

Andy

john.sobrinho · ‎11-11-2003

have a look at your jrm.log file. that may shed light.

I saw your other post with respect to exclusive locks. Ensure when your doing your push that there is no other active telent sessions to the box.

-JS

ghoffnagle · ‎11-14-2003

I ran into the same problem and John's previous post was the correct fix, only it had a typo in it. Where he has jbdc it should be "jdbc". I had referenced this post in my TAC case and it helped alot. Thanks John - this saved me a lot of time tracking down the problem! Also the TAC rep said this is a known problem but is not a consistent problem.

the corrections to his post below are:

the file does and should state:

DBConnection.CWEUID.cm=xxxxxxxxxxx=

DBConnection.CWEPWD.cm=xxxxxxxxxxx=

DBConnection.CWENCYRYPTION.cmf=YES

and

DBConnection.dataSourceUrl.cmf=jdbc:sybase:Tds:localhost:43441?SERVICENAME=cmfdb

DBConnection.jdbcDriver.cmf=com.sybase.jdbc.SybDriver

John's original post follows:

On the server open a dos command window and issue

net stop crmdmgtd

make a backup copy of the file dbserver.properties file. Mine was located at c:\program files\cscopx\www\classpath\com\cisco\nm\cmf\dbservice\DBServer.properties

Open the original file and locate following section of test in your file ** note there may be more than one section with text, or the text lines may not fall in order, find the section that has the missing lines of text detailed futher below :

DBConnection.CWUID.cm=xxxxxxxxxxx=

DBConnection.CWPWD.cm=xxxxxxxxxxx=

DBConnection.CWENCYRYPTION.cmf=YES

Where xxx would be your encrypted password if you chose encryption. The last line CWENCRYPTION is whether encryption is enabled or not. So either yes or no

Once you have located the above text copy the following immediately below the lines.

DBConnection.dataSourceUrl.cmf=jbdc:sybase:Tds:localhost:43441?SERVICENAME=cmfdb

DBConnection.jbdcDriver.cmf=com.sybase.jbdc.SybDriver

There should be two lines of text. The message rolled over to the next line. (line 1 and 2).

Save the file after edit and net start crmdmgtd. Wait a few minutes for the services to reinitialize and check the status.

john.sobrinho · ‎11-17-2003

^^^ Typo king... sorry folks... (thanks for the correction)

stevek1 · ‎12-08-2003

G'Day,

I too have the problem with the jrm service failing...below is my dbserver.properties file....

*************************************************

*/

# The "DBServer.port" property specifies the port that the

# database service's module listens to for socket based

# requests.

DBServer.corbaName=dbservice

DBServer.debugLevel=0

DBServer.port=33333

DBServer.host=localhost

# Database services socket support debug levels.

DBServerSocket.debugLevel=0

DBServerSocketSelect.debugLevel=0

# The "DBSessionIPC.pingPeriod" is used by the RMI database client to

# periodically send a "I'm Alive" message so that the database

# session reaper will not deallocate the connection being used

# by the client.

#

# Ping period is set to 10800000 ms (3 hours) and the time out

# has been set to 21600000 (6 hours).

DBSession.debugLevel=0

DBSessionIPC.pingPeriod=10800000

DBSessionIPC.timeOut=21600000

# The database session reaper will check for timed out

# connections every "DBSessionReaper.sleepPeriod" milliseconds.

DBSessionReaper.debugLevel=0

DBSessionReaper.sleepPeriod=5000

DBConnectionPool.debugLevel=0

DBConnectionPool.poolSize=10

DBConnectionPool.softLimit=true

DBConnectionPool.maxConnections=30

# Driver can use two either the JDBC-ODBC Bridge driver

# or Sybase's jConnect JDBC driver

# . In order to use jConnect, you need to

# do the following:

#

# 1) Install the sybase CTLib libraries (for TDS protocol support).

# 2) Install the SQLAnywhere Open Gateway Server (dbos50)

# 3) Run the open gateway server (dbos50 listens on a specific port).

#

# NOTE: setAutoCommit(), commit() and rollback() database operations do not work

# with jConnect. Essentially, auto commit is turned on and can't be

# turned off thru jConnect without raising an exception.

#

# JDBC-ODBC Bridge Driver:

# ------------------------

# "DBConnection.dataSourceUrl" should be [jdbc:odbc:]. In

# CRM 1.x, the datasource name is "px", therefore the datasource URL is:

# [jdbc:odbc:px]

#

# jConnect Driver:

# ----------------

# "DBConnection.dataSourceUrl" should be [jdbc:sybase:Tds::].

# For example, if the dbos50 (open gateway server) is runnning on host "cawhite-ss20" and

# is listening to port 9999, then the datasource URL would be:

# [jdbc:sybase:Tds:cawhite-ss20:9999]

#

DBConnection.debugLevel=0

DBConnection.autoCommit=true

#DBConnection.jdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver

#DBConnection.dataSourceUrl=jdbc:odbc:px

# Corba client properties.

corba.DBClient.corbaNoImplSleepPeriod=5000

corba.DBClient.corbaNoImplMaxAttempts=15

# jconnect tuning parameters.

DBConnection.PACKETSIZE=4096

DBConnection.REPEAT_READ=false

# STREAM_CACHE_SIZE limits only jconnect memory requirement; no performance chg

# DBConnection.STREAM_CACHE_SIZE=1000000

### dbconnection for rme ###

DBConnection.dataSourceUrl.rme=jdbc:sybase:Tds:localhost:43442?SERVICENAME=rmeDb

DBConnection.jdbcDriver.rme=com.sybase.jdbc.SybDriver

### dbconnection for default (rme) ###

DBConnection.dataSourceUrl=jdbc:sybase:Tds:localhost:43442?SERVICENAME=rmeDb

DBConnection.jdbcDriver=com.sybase.jdbc.SybDriver

### dbconnection for cmf ###

DBConnection.userName.cmf=cmfDBA

DBConnection.password.cmf=c2kY2k

DBConnection.dataSourceUrl.cmf=jdbc:sybase:Tds:localhost:43441?SERVICENAME=cmfDb

DBConnection.jdbcDriver.cmf=com.sybase.jdbc.SybDriver

DBConnection.CWEPWD.rme=vJa9p8EtilQ=

DBConnection.CWENCRYPTION.rme=YES

DBConnection.CWEUID.rme=eGl3NuGsAk4=

DBConnection.CWENCRYPTION=YES

DBConnection.CWEUID=eGl3NuGsAk4=

DBConnection.CWEPWD=vJa9p8EtilQ=

### dbconnection for ani ###

DBConnection.dataSourceUrl.ani=jdbc:sybase:Tds:localhost:43443?SERVICENAME=aniDb

DBConnection.jdbcDriver.ani=com.sybase.jdbc.SybDriver

DBConnection.CWEUID.ani=uBH6uNzdpWE=

DBConnection.CWEPWD.ani=aGN3aC/hvfc=

DBConnection.CWENCRYPTION.ani=YES

************************************************

Going by previous posts from John and yourself, it looks like I have a problem with this file in that there is no...

DBConnection.CWEUID.cm=xxxxxxxxxxx=

DBConnection.CWEPWD.cm=xxxxxxxxxxx=

DBConnection.CWENCYRYPTION.cmf=YES

instead I have....

DBConnection.CWENCRYPTION=YES

DBConnection.CWEUID=eGl3NuGsAk4=

DBConnection.CWEPWD=vJa9p8EtilQ=

Any ideas would be most appreciated.

Cheers,

Steve.

stevek1 · ‎12-08-2003

Actually pls disregard my previous post as I've fixed the issue I had with jrm process failing. After reading it back to myself it seemed obvious to add the necessary "cm/cmf" text into the lines above. I also reordered these lines + rme equivalents to be 1st - UID, 2nd - PWD and 3rd - ENCRYPTION.

Stopped and started the daemon manager and lo and behold jrm works now.

Thanks a million John.