Root Cause Analysis

Error can be seen in the following log files:

• In C:\TMSM_DBTool.log:

  				2019-10-15 10:45:39 109 [1] ERROR TMSMDBTool - System.ArgumentException: Format of the initialization 
  					string does not conform to specification starting at index 84. at System.Data.Common.DbConnectionOptions.GetKeyValuePair
  					(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, 
  					String& keyname, String& keyvalue)
  				

• In C:\TMSM_PreInstall.log

  				[10-15-2019 10:45:39][DebugLevel-Error]---Install TMSM objects to OSCE DB failed 
  				(D:\TMSM-Server-OnPremise_3.5\installshield\TMSforMacintosh\Script Files\Setup.Rul, 495) 
  				
  				[10-15-2019 10:45:39][DebugLevel-Info]---FreshInstallDB() out (D:\TMSM-Server-OnPremise_3.5\installshield\TMSforMacintosh\Script Files\Setup.Rul, 561)
  				

Based on the log files, there is a connection string error being used by SQL Server to connect to the database. The password being used to connect with the database has some special characters (Ex. [] {}() , ; ? * ! @.), which are incompatible with the connection string.

Resolution

To resolve the issue, change the password of the account being used to connect to the SQL Server, and make sure that it does not contain special characters. (Ex. [] {}() , ; ?' * !" @.).

More information about this issue can be found in this Microsoft article: Format of the initialization string does not conform to specification starting at index.

Root Cause Analysis

• In C:\TMSM_PreInstall.log

  				[8-24-2021 13:14:42][DebugLevel-Info]---Calling TMSMDBTool.exe to install DB to OSCE DB. 
  					Binary at C:\Windows\TEMP\{2A4AD~1\{585D1~1\TMSMDB~1.EXE, DB server is ITMSSQLCLU, 
  					DB name is ApexOne, DB user is sa1, DB auth is 1, SchemaList is 
  					C:\Windows\TEMP\{2A4AD468-A5EF-4E60-BCA8-885683B11D7B}\{585D1C07-4D36-4465-AE4A-FA83DDA71948}\SchemaList.txt
  					c:\ci-jenkins\workspace\TMSM\TMSM-Server-Master\en\installshield\TMSforMacintosh\Script Files\Setup.Rul, 1027)
  				
  				[8-24-2021 13:14:44][DebugLevel-Error]---Install TMSM objects to OSCE DB failed 
  					(c:\ci-jenkins\workspace\TMSM\TMSM-Server-Master\en\installshield\TMSforMacintosh\Script Files\Setup.Rul, 516)
  				

• TMSM_DBTool.log

  				2021-08-24 13:14:44.3904 ERROR [1] TMSMDBTool - System.Data.SqlClient.SqlException 
  					(0x80131904): Invalid object name 'String_Split'.
  				

Based on the findings, the SQL Function "STRING_SPLIT" only started support in SQL Server 2016, under Compatibility level 130. This error can be found on lower SQL versions (SQL 2014 and below).

Resolution

To resolve the issue, follow the steps below:

1. Login to the SQL Server with Microsoft SQL Server Management Studio or another database connection tool.
2. Check the SQL Script like this (the database name 'OSCE_4171' should be changed to the customer's APEX DB's name).
3. Type the following command:
   SELECT compatibility_level FROM sys.databases WHERE name = 'OSCE_4171'.
4. If the level is under 130, like 120 or 110, we need to change this level to SQL Server 2016's default level 130.
5. Use the following command:
   ALTER DATABASE [OSCE_4171] SET COMPATIBILITY_LEVEL = 130

   After using the command, the SQL Server will support its "STRING_SPLIT" function.

6. After performing the steps, try to install the Patch 3.