Connectivity error for user Management and Process Model

, ,
1

Hi all,

After server restart getting this error for central user in IS log

[1398]2014-12-06 18:56:15 IST [ISS.0024.0001E] Could not initialize User Manager.
[1397]2014-12-06 18:56:15 IST [ISS.0024.0010C] Central User Manager initialization failed with error : null
[1396]2014-12-06 18:56:15 IST [CommonLib.MWS.0002W] Should have positive integer specified for com.webMethods.sc.mws.db.max.waittime. The current value is null
[1395]2014-12-06 18:56:15 IST [CommonLib.MWS.0002W] Should have positive integer specified for com.webMethods.sc.mws.db.cleanup.period. The current value is null

Also when trying to deploy process model getting this log in IS log

[1122] at com.wm.dd.jdbc.oraclebase.ddaj.run(Unknown Source)
[1121] at com.wm.dd.jdbc.oraclebase.BaseConnection.k(Unknown Source)
[1120] at com.wm.dd.jdbc.oraclebase.BaseConnection.a(Unknown Source)
[1119] at com.wm.dd.jdbc.oracle.OracleImplConnection.x(Unknown Source)
[1118] at com.wm.dd.jdbc.oracle.OracleImplConnection.a(Unknown Source)
[1117] at com.wm.dd.jdbc.oracle.OracleImplConnection.af(Unknown Source)
[1116] at com.wm.dd.jdbc.oracle.OracleImplConnection.a(Unknown Source)
[1115] at com.wm.dd.jdbc.oraclebase.ddb8.a(Unknown Source)
[1114] at com.wm.dd.jdbc.oraclebase.ddb8.b(Unknown Source)
[1113]Error creating database connection to: jdbc:wm:oracle://localhost:1521;serviceName=xecom.wm.dd.jdbc.oraclebase.ddd0: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
[1112]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] pool.cleanup.period is not an integer.
[1111]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] pool.timeout.idle is not an integer.
[1110]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Initializing component: com.webMethods.portal.service.sql.core.ConnectionManager
[1109]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Initializing component: com.webMethods.portal.event.EventDeliveryInitializer
[1108]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Initializing components of: DataPhaseOne
[1107]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Loading phase: [phaseID, phaseName] [DataPhaseOne, DataPhaseOne]
[1106]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Initializing components of: global
[1105]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Initializing component: com.webMethods.portal.service.global.impl.GlobalProvider
[1104]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Initializing component: com.webMethods.event.ecs.ECSInitializer
[1103]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Updated the hostname for the RMI server to: Baharul
[1102]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Initializing server: $cds
[1101]2014-12-06 18:50:09 IST [CommonLib.MWS.0002I] Initializing components of: null
[1100]2014-12-06 18:50:08 IST [CommonLib.MWS.0002I] JMS ClientID: Baharul.mws.library.8703712940330185728
[1099]2014-12-06 18:50:08 IST [CommonLib.MWS.0002I] Initializing components of: cluster
[1098]2014-12-06 18:50:08 IST [CommonLib.MWS.0002I] Initializing component: com.webMethods.portal.system.cluster.impl.ClusterProvider
[1097]2014-12-06 18:50:08 IST [CommonLib.MWS.0002I] Initializing components of: miePhaseTwo
[1096]2014-12-06 18:50:08 IST [CommonLib.MWS.0002I] Loading phase: [phaseID, phaseName] [miePhaseTwo, miePhaseTwo]
[1095]2014-12-06 18:50:08 IST [CommonLib.MWS.0002I] Initializing component: com.webMethods.rtl.util.xml.XMLUtil
[1094]2014-12-06 18:50:08 IST [ISS.0095.0013I] Audit Logging initialized.
[1093]2014-12-06 18:50:06 IST [ISS.0025.0024I] JDBC Connection Manager started
[1092]2014-12-06 18:50:05 IST [ISS.0025.0017I] Repository Manager started
[1091]2014-12-06 18:50:02 IST [ISS.0025.0041I] FIPS mode not initialized


Using webMethod version 8.2and central user is configured through JDBC pool in IS
OS :Windows
DB:Oracle 10g

Thanks

2

Baharul,

Can you kindly stop IS, MWS. Drop all tables using DB component configurator, create all tables once again product wise. Once done with above tasks, please start IS and then MWS. Stop IS if you see Central user is not configured ( you can see it under User management tab of IS admin ) and give a restart of IS which will fix your issue. Kindly perform the above steps and let us know the result.

Thanks,

3

Baharul,

Are you sure about the serviceName=xecom.wm.dd.jdbc.oraclebase.ddd0

For Oracle 10g I assume it must be XE or ORCL, I might be wrong sometimes :slight_smile:

Can you run this query

select sys_context(‘userenv’,‘db_name’) from dual;

select sys_context(‘USERENV’,‘SERVICE_NAME’) from dual

select sys_context(‘userenv’,‘instance_name’) from dual

Or you can also find the SERVICE_NAME from your windows services.