MWS Not coming up after Fresh Install

, ,
1

Hello,

We just installed a fresh copy of MWS and the underlying db is MS SQL server. However while trying to bring the server up we are getting the below error,

Error Details:
1.
<log4j:event logger=“Framework” timestamp=“1393330355583” level=“FATAL” thread=“WrapperSimpleAppMain”>
log4j:message</log4j:message>
log4j:throwable<![CDATA[java.lang.IllegalStateException: [Pool - default]: can’t retrieve a object within 90 seconds.

<log4j:event logger=“Framework” timestamp=“1393330769748” level=“FATAL” thread=“WrapperSimpleAppMain”>
log4j:message</log4j:message>
log4j:throwable<![CDATA[java.sql.SQLInvalidAuthorizationSpecException: [sag-cjdbc42-0011][SQLServer JDBC Driver][SQLServer]Login failed for user ‘WMWMS’.

<log4j:event logger=“Framework” timestamp=“1393330859879” level=“FATAL” thread=“WrapperSimpleAppMain”>
log4j:message</log4j:message>
log4j:throwable<![CDATA[java.lang.IllegalStateException: [Pool - default]: can’t retrieve a object within 90 seconds.

Please find the msw.db.xml file details below,

<?xml version="1.0" encoding="UTF-8"?> com.webmethods.portal.service.sql.core.BaseSqlWorker com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider com.wm.dd.jdbc.sqlserver.SQLServerDriver jdbc:wm:sqlserver://157.184.229.183:1433;databaseName=wmdbden5 WMWMS {DES}QuPg8sRwxPg= false SELECT COUNT(*) FROM TBLTHING WHERE IDTHING = 1 100 0 60 10

Can anyone tell me is there anything wrong in the configuration xml file above for sqlserver.

2

The error: ][SQLServer]Login failed for user ‘WMWMS’.
indicate the username/password you are using is not correct.

3

You need to enter a valid username/password from your MS SQL Server in SAG folder/MWS/server/default/config/mws.db.xml

Regards

4

The username/password was working fine. That issue got resolved.However after the server got started it again stopped automatically just after sometime,

(Framework:INFO) [RID:10] - Shutting down components of: cluster
2014-02-28 07:12:01 EST (Framework:INFO) [RID:10] - The hostname for the RMI server is: tlexrwmap001.lex.lexmark.com
2014-02-28 07:12:05 EST (Framework:INFO) [RID:11] - Processing request [c494luqbzrff:Administrator] http://tlexrwmap001.lex.lexmark.com:8583/meta/default/wm_xt_fabricfolder/0000003249 (POST)
2014-02-28 07:12:05 EST (Framework:INFO) [RID:12] - Processing request [c494luqbzrff:Administrator] http://tlexrwmap001.lex.lexmark.com:8583/meta/default/wm_xt_fabricfolder/0000003249 (GET)
2014-02-28 07:12:06 EST (Framework:INFO) [RID:13] - Processing request [c494luqbzrff:Administrator] http://tlexrwmap001.lex.lexmark.com:8583/ (GET)
2014-02-28 07:12:07 EST (Framework:INFO) [RID:14] - Processing request [c494luqbzrff:Administrator] http://tlexrwmap001.lex.lexmark.com:8583/meta/default/wm_xt_fabricfolder/0000003249 (POST)
2014-02-28 07:12:07 EST (jsf:INFO) [RID:14] - tlexrwmap001.lex.lexmark.com-node34640 shutdown is in progress…:
2014-02-28 07:12:07 EST (Framework:INFO) [RID:15] - Processing request [c494luqbzrff:Administrator] http://tlexrwmap001.lex.lexmark.com:8583/meta/default/wm_xt_fabricfolder/0000003249 (GET)
2014-02-28 07:12:07 EST (jsf:INFO) [RID:15] - tlexrwmap001.lex.lexmark.com-node34640 shutdown is in progress…:
2014-02-28 07:12:12 EST (Framework:INFO) - Shutting down PortalAxisServlet
2014-02-28 07:12:12 EST (Framework:INFO) - Shutting down PortalServlet
2014-02-28 07:12:12 EST (Framework:INFO) - Shutting down PortalServlet
2014-02-28 07:12:12 EST (Framework:INFO) - Shutting down PortalServlet
2014-02-28 07:12:12 EST (Framework:INFO) - Shutting down…
2014-02-28 07:12:12 EST (Framework:INFO) - Shutting down components of: MWS
2014-02-28 07:12:12 EST (Framework:INFO) - Shutting down components of: startupComplete
2014-02-28 07:12:12 EST (com.webMethods.jackrabbit.spi2mws.query.lucene.IndexMerger:INFO) - IndexMerger terminated
2014-02-28 07:12:12 EST (com.webMethods.jackrabbit.spi2mws.query.lucene.SearchIndex:INFO) - Index closed: /wMMWS1/MWS/server/default/data/search_jcr
2014-02-28 07:12:12 EST (Framework:INFO) - Saving performance information into perfsnapshot-2014-02-28-07_12_12_EST.xml
2014-02-28 07:12:13 EST (Framework:INFO) - Shutting down components of: deploySync
2014-02-28 07:12:13 EST (Framework:INFO) - Shutting down components of: webserver
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: WSRP Consumer
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_wsrp_consumer
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_wiki
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_wiki
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_user_preferences
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_user_preferences
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: Trading Networks
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_tn
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_task_search
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_task_search
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_task_migration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_task_migration
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_task_chart
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_task_chart
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_task_analytics
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_task_analytics
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_sink_admin
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_sink_admin
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_rules
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_rules
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_process_graph
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_process_graph
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_permissions_admin
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_permissions_admin
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_noodle
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_noodle
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_noodle_pack
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_noodle_pack
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_mws_diagnostics
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_mws_diagnostics
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: Administration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_mws_config
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Integration Monitoring
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_mon_services
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_mon_processes
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_mon_processes
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Integration Monitoring
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_mon_docs
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_mon_archivedata
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_mon_archivedata
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_jmxsupport
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_jmxsupport
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_jcr_search
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_jcr_search
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_fabric_nav
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_fabric_nav
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_discussion_board
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_discussion_board
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_csp_task
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_csp_task
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_content_migration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_content_migration
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_comments_editor
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_comments_editor
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_certificate_admin
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_certificate_admin
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_calendar_admin
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_calendar_admin
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_cafsystem
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_cafsystem
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: webMethods CAF Shared Servlets
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_cafshared
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_cafeventagent
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_cafeventagent
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: MWS Deployer Plugin
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_caf_deployer_services
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_caf_app_runtime_config
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_caf_app_runtime_config
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_bam_utils
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_utils
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_bam_system_settings
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_system_settings
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Rule Administration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_rules
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Rule Administration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_rule_filters
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Rule Administration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_rule_create
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Rule Administration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_rule_audit
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - System Monitoring
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_overview
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Application Configuration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_overview_config
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Infrastructure
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_monitoredcomponents
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Application Configuration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_metadata_results
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - LivePurge
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_livepurge
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Application Configuration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_kpi_eventmaps
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Application Configuration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_kpi_dimensions
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_bam_job_queue
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_job_queue
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_bam_job_audit
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_job_audit
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_bam_intel_links
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_intel_links
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Process Monitoring
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_instance
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_bam_discovered_assets
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_discovered_assets
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - System Monitoring
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_diag
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Shared
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_charts
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_bam_biz_viz
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_biz_viz
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: My webMethods - Assets Extractor
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_assets_extractor
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: wm_bam_asset_discovery
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: wm_bam_asset_discovery
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: PoolConfigurator2
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: poolconfigurator2
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: Messaging
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: messaging
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: JournalLogViewer
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: journallogviewer
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: JournalLogConfigurator
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: journallogconfigurator
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: ESB Administration
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: esbadministration
2014-02-28 07:12:15 EST (Framework:INFO) - Web Application destroyed: webMethods Configuration Engine
2014-02-28 07:12:15 EST (Framework:INFO) - unregisterPortletApplication: ccs-engine

Everything got unregistered.

5

Try re-starting the MWS again.

If still the same issue contact SAG support with a ticket.

6

Restart, check if the components got registered. If not then login as sysadmin and do the register manually.

If still does not work try to reinstall or reach SAG customer support.