JDBC Exception: Password Property Exceeds Maximum Number of 128 Characters
0
Hi, I’m automating the deployment of apps using Mendix.Service.Commands.dll. I’m invoking a PowerShell script on the app server from on-premise Azure DevOps which, stops, updates and starts an app. Stripped down, it calls: Stop-MxApp -Name $AppName -Verbose -ErrorAction Stop Update-MxApp -Name $AppName -LiteralPath $MdaFilePath -Verbose -ErrorAction Stop Start-MxApp -Name $AppName -SynchronizeDatabase -Verbose -ErrorAction Stop The update succeeds but the start fails and the app log file shows: com.microsoft.sqlserver.jdbc.SQLServerException: The password property exceeds the maximum number of 128 characters Perhaps it’s using the encrypted password (settings.yaml) directly and skipping decryption but I don't know why? Interestingly, there is no problem when I run the same Start-MxApp command directly on the app server. Has anybody come across this? I don’t see why remote PS execution should have different results in this context. Thanks. Full Log 2019-02-04 18:05:53.285 WARNING - ConnectionBus: Database connections: 0 active, 0 idle. 2019-02-04 18:05:53.285 ERROR - ConnectionBus: Opening JDBC connection to Some([the.ip.address.here]) failed with SQLState: null Error code: 0 Message: The password property exceeds the maximum number of 128 characters., giving up...(4/4) 2019-02-04 18:05:53.285 ERROR - M2EE: An error occurred while initializing the Runtime: Error on initializing database connection. 2019-02-04 18:05:53.285 ERROR - M2EE: com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime: Error on initializing database connection. at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:325) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Error on initializing database connection. at com.mendix.connectionbus.ConnectionBusInitializer.throwDefault$1(ConnectionBusInitializer.scala:58) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The password property exceeds the maximum number of 128 characters. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:206) at com.microsoft.sqlserver.jdbc.SQLServerConnection.ValidateMaxSQLLoginName(SQLServerConnection.java:775) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:933) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:788) at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(SQLServerDataSource.java:719) at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnection(SQLServerDataSource.java:71) at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:44) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:861) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363) at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:49) at com.mendix.connectionbus.ConnectionBusInitializer.$anonfun$createConnection$1(ConnectionBusInitializer.scala:52) at scala.util.Try$.apply(Try.scala:209) at com.mendix.connectionbus.ConnectionBusInitializer.retry(ConnectionBusInitializer.scala:60) at com.mendix.connectionbus.ConnectionBusInitializer.createConnection(ConnectionBusInitializer.scala:52) at com.mendix.connectionbus.ConnectionBusInitializer.initialize(ConnectionBusInitializer.scala:42) at com.mendix.connectionbus.ConnectionBusImpl.initialize(ConnectionBusImpl.java:298) at com.mendix.basis.impl.MxRuntimeImpl.initializeConnectionBus(MxRuntimeImpl.java:474) at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:296) at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:49) at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:30) at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:128) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) at org.eclipse.jetty.server.Server.handle(Server.java:561) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597) at java.lang.Thread.run(Unknown Source)