Hi Team,
We are facing issues while configuring the SQL HA.
After running configurereplication.bat. The test went successful , but while configuring we are getting the following error :
ERROR OCCURRED: Password validation failed. The password does not meet the operating system policy requirements because it is too short.
InDetails :
[12:10:03:026]|[07-09-2020]|[INFO]|[15]|[com.adventnet.passtrix.sqlserver.replication.SQLServerReplication]|[connectDBServer]: Slave database : PassTrix|
[12:10:27:483]|[07-09-2020]|[INFO]|[24]|[com.adventnet.passtrix.sqlserver.replication.SQLServerReplication]|[createPublication]: Going to configure replication.|
[12:10:39:714]|[07-09-2020]|[SEVERE]|[24]|[com.adventnet.passtrix.sqlserver.replication.SQLServerReplication]|[checkPublicationStatus]: Invalid object name 'pmpdistribution.dbo.mssnapshot_history'.|
java.sql.SQLException: Invalid object name 'pmpdistribution.dbo.mssnapshot_history'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
at com.adventnet.passtrix.sqlserver.replication.SQLServerReplication.checkPublicationStatus(SQLServerReplication.java:1185)
at com.adventnet.passtrix.sqlserver.replication.SQLServerReplication.createPublication(SQLServerReplication.java:860)
at com.adventnet.passtrix.sqlserver.replication.SQLServerReplicationGUI$5.run(SQLServerReplicationGUI.java:684)
[12:10:39:714]|[07-09-2020]|[INFO]|[24]|[com.adventnet.passtrix.sqlserver.replication.SQLServerReplication]|[createPublication]: Going to create distributor and distribution database.|
[12:10:39:714]|[07-09-2020]|[INFO]|[24]|[com.adventnet.passtrix.sqlserver.replication.SQLServerReplication]|[createPublication]: Property - distributor.password is set as "true". Hence going to create distributor with the default password|
[12:10:40:229]|[07-09-2020]|[INFO]|[24]|[com.adventnet.passtrix.sqlserver.replication.SQLServerReplication]|[createPublication]: Password validation failed. The password does not meet the operating system policy requirements because it is too short.|
java.sql.SQLException: Password validation failed. The password does not meet the operating system policy requirements because it is too short.