[sddroog]

Hi,

I am trying to install BES 4.1 Express with MDS Services. Everything installs fine, but at the very end of the installation I get the following error:

"MDS Services installation has failed."

The "BlackBerry_MDS_Services_InstallLog.log" logfile shows the following error:

Install Action: Jump To: Next Install Folder -- Prev: Install Folder
Status: ERROR
Additional Notes: ERROR - java.lang.StackOverflowError

It shows this error 6 times in the logfile.

I tried everything, including removing and reinstalling BES completely, and reinstalling other related applications like the MS SQL JDBC driver, Java runtime etc.

Bes including all other services seems to run fine. The only thing missing is the MDS tomcat service.

[blackberry1]

Are you using an MSDE or SQL Server with a Named Instance as the data source.
If yes?

Install BlackBerry MDS Services without using a Named Instance

If that is not the case ,check

RIM KB 04987

[sddroog]

Thanks, the KB article helped me get it installed.

However, after the service started it stops after a few seconds. I get the same error reported in this thread: http://www.blackberryforums.com/bes-...-problems.html

The suggestions in that thread didn't work for me....

[Zro]

MSDE or SQL?

MDS for 4.1 takes a LOT of connections to the database. MDSE has an 8 concurrent connection limit. If that limit is being hit, this will cause connection issues.

Not sure if that's what's going on, but may be a place to look.

Zro

[idontknow]

If you are using MSDE, then you must have enabled mix mode prior to the BES/MDS service install right? MDS Service install requires SQL authentication and will not work using Windows Trusted.

Also, did you drop the 2 MDS databases before re-installing? This should be done.

[sddroog]

I am using MSDE. I did drop the 2 databases before re-installing. I am running mixed mode. I don't know what else to do....

I started tomcat-debug.bat, which seems to start fine. Until I startup the BlackBerry manager and select the MDS:

Listening for transport dt_socket at address: 5005
[INFO ][2006-07-27 13:08:24,234][Catalina]Initialization processed in 1953 ms
[INFO ][2006-07-27 13:08:24,390][StandardService]Starting service Catalina
[INFO ][2006-07-27 13:08:24,421][StandardEngine]Starting Servlet Engine: Apache
Tomcat/5.5.9
[INFO ][2006-07-27 13:08:24,453][StandardHost]XML validation enabled
Found: LogRoot:REG_SZ:c:\Program Files\Research In Motion\BlackBerry Enterprise
Server\Logs\
Found: DailyLogFileFolder:REG_DWORD:1
Found: LogFilePrefix:REG_SZ:
Found: DebugLogIdent:REG_SZ:MDS
Found: DebugLogDailyFile:REG_DWORD:1
Found: DebugLogLevel:REG_DWORD:3
Found: DebugLogSize:REG_DWORD:10485760
Found: DebugLogAutoRoll:REG_DWORD:0
Found: DebugLogMaxDailyFileAge:REG_DWORD:14
LogAutoRollover: false
LogRoot: c:\Program Files\Research In Motion\BlackBerry Enterprise Server\Logs\
LogMaxDailyFileAge: 14
LogDailyFile: true
LogDailyFolder: true
LogMaxFileSize: 10240KB
LogFile: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\Logs\2
0060727\exite001_MDS_01_20060727_0001.txt
initialize log level from registry
default log level: INFO
-----------------------------------------------------------------------
-----------------------------------------------------------------------
[INFO ][2006-07-27 13:08:29,468][[/balancer]]org.apache.webapp.balancer.Balancer
Filter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.we
bapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http
://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterR ule: Target
param name: paramName / Target param value: paramValue / Redirect URL: http://ww
w.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingR ule: Redirect U
RL: http://jakarta.apache.org]]
[INFO ][2006-07-27 13:08:30,031][StoreLoader]Find registry server-registry.xml a
t classpath resource
[INFO ][2006-07-27 13:08:30,218][Catalina]Server startup in 5968 ms
[ERROR][2006-07-27 13:08:47,109][[Catalina]]Exception performing authentication
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnection
Factory ([Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for
user '(null)'. Reason: Not associated with a trusted SQL Server connection.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.create DataSource(BasicDat
aSource.java:855)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getCon nection(BasicDataSo
urce.java:540)
at org.apache.catalina.realm.DataSourceRealm.open(Dat aSourceRealm.java:4
02)
at org.apache.catalina.realm.DataSourceRealm.authenti cate(DataSourceReal
m.java:282)
at org.apache.catalina.authenticator.BasicAuthenticat or.authenticate(Bas
icAuthenticator.java:181)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(Authentica
torBase.java:446)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.j
ava:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java
:856)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.proce
ssConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadP
ool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQ
LServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQ
L Server connection.
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.p rocessReplyToken(Un
known Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReply(Unknown Sour
ce)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnecti on.open(Unknown Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplC onnection(Unknown S
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknow n Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactor y.createConnection(
DriverConnectionFactory.java:37)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFact ory.makeObject(Pool
ableConnectionFactory.java:290)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.valida teConnectionFactory
(BasicDataSource.java:877)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.create DataSource(BasicDat
aSource.java:851)
... 15 more
[ERROR][2006-07-27 13:08:47,156][[Catalina]]Exception performing authentication
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnection
Factory ([Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for
user '(null)'. Reason: Not associated with a trusted SQL Server connection.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.create DataSource(BasicDat
aSource.java:855)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getCon nection(BasicDataSo
urce.java:540)
at org.apache.catalina.realm.DataSourceRealm.open(Dat aSourceRealm.java:4
02)
at org.apache.catalina.realm.DataSourceRealm.authenti cate(DataSourceReal
m.java:282)
at org.apache.catalina.authenticator.BasicAuthenticat or.authenticate(Bas
icAuthenticator.java:181)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(Authentica
torBase.java:446)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.j
ava:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java
:856)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.proce
ssConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadP
ool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQ
LServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQ
L Server connection.
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.p rocessReplyToken(Un
known Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReply(Unknown Sour
ce)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnecti on.open(Unknown Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplC onnection(Unknown S
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknow n Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactor y.createConnection(
DriverConnectionFactory.java:37)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFact ory.makeObject(Pool
ableConnectionFactory.java:290)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.valida teConnectionFactory
(BasicDataSource.java:877)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.create DataSource(BasicDat
aSource.java:851)
... 15 more

It keeps on trying to connect with user (null)... ?!

[idontknow]

This error:

[ERROR][2006-07-27 13:08:47,109][[Catalina]]Exception performing authentication
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnection
Factory ([Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for
user '(null)'. Reason: Not associated with a trusted SQL Server connection.)

What have you used for the SQL login id and password? If you were using the SA account, did you change the password from NULL to something else yet?

[sddroog]

Originally Posted by idontknow

What have you used for the SQL login id and password? If you were using the SA account, did you change the password from NULL to something else yet?

Yes, I changed my SA account password, but I do not use the SA account for MDS anyway.

I am using a rather complex password, could that be causing problems? Where can I easily change the password for this user, apart from reinstalling everything again?

[idontknow]

See KB-2592, but you have to change the NULL to the current password.

For instance:
From a cmd prompt type:

osql -U sa
<you will now be prompted for the password>

1> EXEC sp_password <current password>, <new_password>

2> go

You will receive a Password Changed notification.

1> Exit

If you can't log into the database engine with the sa account and password you have been using, then you've found the problem. Complex passwords are supported, just make sure you're is right!

[sddroog]

Thanks again, but I think you misunderstood. I can login with osql just fine, both as SA and as the MDS user. I can change the password in MSDE without problems, the question is how/where do I change the password MDS is using to log in to the MSDE databases? Or do I really have to install BES with MDS all over again?

[sddroog]

Ok, I think I found it. There was another MSDE instance for another application running, also using port 1433. After I removed that instance all my problems disappeared!

Thanks everybody for there help and input.

[blackberry1]

Originally Posted by blackberry1

Are you using an MSDE or SQL Server with a Named Instance as the data source.
If yes?

Install BlackBerry MDS Services without using a Named Instance

If that is not the case ,check

RIM KB 04987

LOL Did I not tell you to check the same thing 5 days ago

Good Stuff.. I hope others who get this problem read this thread

[sddroog]

Originally Posted by blackberry1

LOL Did I not tell you to check the same thing 5 days ago

Actually, MDS was not running with a Named Instance, but some other application using the same MSDE server did.