WebSphere Lombardi Edition on SQLServer 2010 - No message engine was found

I installed WebSphere Lombardi Edition 7.2 win32 edition using a Microsoft SQL Server 2010 database.

After installation the database tables and content were verified (the default users should be present, otherwise you cannot log in, see previous blogpost). All tables were created, with the data present.

However when starting the twprocsvr profile, the following stacktrace came up:

Caused by:
com.lombardisoftware.client.delegate.BusinessDelegateException: CWSIA0241E: An
exception was received during the call to the method
JmsManagedConnectionFactoryImpl.createConnection:
com.ibm.websphere.sib.exception.SIResourceException: CWSIT0008E: A successful
connection was made to the bootstrap server at
srv-lom-01:7277:BootstrapBasicMessaging but the server returned an error
condition: CWSIT0088E: There are currently no messaging engines in bus
twprocsvr_bus running. Additional failure information: CWSIT0103E: No messaging
engine was found that matched the following parameters: bus=twprocsvr_bus,
targetGroup=null, targetType=BusMember, targetSignificance=Preferred,
transportChain=InboundBasicMessaging, proximity=Bus..
at
com.lombardisoftware.client.delegate.BusinessDelegateException.asBusinessDelegateException(BusinessDelegateException.java:41)
at
com.lombardisoftware.client.delegate.common.WebsphereDelegateHelper.doAsCurrentSubjectContextSensitive(WebsphereDelegateHelper.java:132)
at
com.lombardisoftware.client.delegate.EventQueueManagerDelegateDefault.browseErrorQueue(EventQueueManagerDelegateDefault.java:70)
at
com.ibm._jsp._cs_5F_event_5F_mgr_5F_queue._jspService(_cs_5F_event_5F_mgr_5F_queue.java:230)
...
53 more

No message engine running? Hmm, let's check the administration console. twprocsvr profile has no administration console installed, so I started server1 profile for problem determination.

Turns out that the message engine on twprocsvr is configured to use the datasource configured, with schema 'sa'. This is the user used I specified for authentication. There is no schema 'sa' however, the default schema on SQLServer is 'dbo'. Therefore the message engine could not create the tables required for the message engine. They can be recognized by their prefix "SIB":

I found out by looking for SIB in the SystemOut after reading on the web that this error can be caused by invalid SIB* tables.

0000000d SibMessage    E   [twprocsvr_bus:ProcessCenter01.twprocsvr-twprocsvr_bus] CWSIS0002E: The messaging engine encountered an exception while starting. Exception: com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The data source has produced an unexpected exception: com.jnetdirect.jsql.JSQLNonFatalException: The specified schema name "sa" either does not exist or you do not have permission to use it.

0000000d SibMessage    E   [twprocsvr_bus:ProcessCenter01.twprocsvr-twprocsvr_bus] CWSID0035E: Messaging engine ProcessCenter01.twprocsvr-twprocsvr_bus cannot be started; detected error reported during com.ibm.ws.sib.msgstore.impl.MessageStoreImpl start()

0000000d SibMessage    E   [twprocsvr_bus:ProcessCenter01.twprocsvr-twprocsvr_bus] CWSID0027E: Messaging engine ProcessCenter01.twprocsvr-twprocsvr_bus cannot be restarted because a serious error has been reported.

0000000d SibMessage    I   [twprocsvr_bus:ProcessCenter01.twprocsvr-twprocsvr_bus] CWSID0016I: Messaging engine ProcessCenter01.twprocsvr-twprocsvr_bus is in state Stopped.

0000000d SibMessage    I   [twprocsvr_bus:ProcessCenter01.twprocsvr-twprocsvr_bus] CWSID0016I: Messaging engine ProcessCenter01.twprocsvr-twprocsvr_bus is in state Joined.

0000000d SibMessage    E   [twprocsvr_bus:ProcessCenter01.twprocsvr-twprocsvr_bus] CWSID0039E: HAManager-initiated activation has failed, messaging engine ProcessCenter01.twprocsvr-twprocsvr_bus will be disabled. Reason Refer to earlier messages

I fixed it by adding a schema 'sa' to my database in sqlserver

I changed it on database level because I could not change the schema setting on the message engine, when logging in using the tw_admin user. Hmm, I have no credentials for wasadmin... only the default lombardi credentials.

Installing WebSphere Lombardi 7.2

I tried to install WebSphere Lombardi Edition 7.2 on a windows 32bit virtual machine. If I use the Simple Install option, it should install a db2 instance in the background, with the required databases and settings. The installation is successful and the process center server starts. However, I cannot log in with the default user tw_admin. Hmm, that's strange.



A new install, on a 64 bit windows machine this time. Make sure you got the 64 bit installer, the 32 bit installer gives errors halfway the installation on a windows 64 bit. This time I created two empty databases before installing on my local db2 express installation.

Once again, the installer says the installation was successful, and the process center server starts. Again, I cannot log in with tw_admin. What is wrong with it?

Luckily I came across this post where I learned that if the db2 database settings  (pagesize 32k, encoding utf-8) are not correct, the default data (including the usernames and passwords) will not be inserted. Because of that I could not login. If you choose SQLServer as database engine, no specific settings are required, it just works.

The table to check is LSW_USR, which should container 6 entries after installation completes. Entries in LSW_USR + this screen below = success



It is disappointing that the Simple Install does not work.

Install IBM Installation Manager without internet connection or connection with proxy

When you try to install the IBM Installation Manager, and you have no internet connection, or there is a proxy standing in your way, it is possible that you cannot enter any repositories, because the installer does not get launched. It seems to get stuck at trying to connect to public.dhe.ibm.com.

We encountered this when  we tried to install WebSphere Business Monitor. After installing WebSphere Application Server 7, the installer tries to merge the was7 it just installed into a new installation manager installation (if it was not yet installed). 

This IBM document describes the problem : http://www-01.ibm.com/support/docview.wss?uid=swg21420545#NoInternet , here in combination with Process Server 7. The suggested workaround (pre-installing the ibm installation manager with the -input parameter after editing the install.xml file) did not work. Somehow, he still had a reference to the online repository.

Luckily we found a workaround (by accident). When giving an invalid -input parameter (that is, to a file that does not exist), the installation manager installer gets launched without trying to connect to a repository! Now you can unflag the online repositories using the gui, add the repository.config file of the installation manager disk, and install the installation manager.