2 Replies Latest reply on Feb 9, 2016 9:07 AM by James Sun

    Does TrackIT support SQL Clustering?

      Share This:

      We are running Track-IT version 11.4 where the SQL database is clustered using SQL Server 2012. When testing failover between the two nodes, it looks like we have to run the DBfix as outlined here:

       

      https://communities.bmc.com/docs/DOC-25928

       

      For example, if the TrackIT DB is on SQL1 node and we failover to SQL2 node we have to run the DBfix before the application works.  When we fail back to SQL1 from SQL2 we have to run the DBfix again.  Each time we tested failing over we have to do this.  Is this normal for this product to manually run this DBfix each time?  

       

      Here is the error we get when attempting to open the Technician Client after failing over:

       

       

      None of the following resolution options in the corresponding KB article for this error worked:

      http://support.numarasoftware.com/support/articles.asp?mode=detail&ID=6890

       

       

       

      Has anyone else had any issues with SQL Clustering/High Availability with TrackIT?  Are you able to switch between nodes without issue?  Any insight anyone can give is very much appreciated.