Views:

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.

Root Cause Analysis

In C:\TMSM_PreInstall.log

[9-13-2022 13:37:23][DebugLevel-Info]---Launch TMSM.EXE at C:\Windows\TEMP\
	{F2CEF732-C906-4961-A341-D117A18DE888}\{585D1C07-4D36-4465-AE4A-FA83DDA71948}\TMSM.exe
	(c:\ci-jenkins\workspace\TMSM\OnPremise-Patch6\TMSM-Server-OnPremise-Patch6\en\installshield\
	TMSforMacintosh\Script Files\Setup.Rul, 1248)

[9-13-2022 13:38:08][DebugLevel-Error]---TMSM.exe Installation stopped unexpected.
	(c:\ci-jenkins\workspace\TMSM\OnPremise-Patch6\TMSM-Server-OnPremise-Patch6\en\installshield\
	TMSforMacintosh\Script Files\Setup.Rul, 1265)

[9-13-2022 13:38:08][DebugLevel-Info]---Set Reg SetupRunning =0 
	c:\ci-jenkins\workspace\TMSM\OnPremise-Patch6\TMSM-Server-OnPremise-Patch6\en\installshield\
	TMSforMacintosh\Script Files\Setup.Rul, 1501)

[9-13-2022 13:38:10][DebugLevel-Info]---Check if need to rollback , return 112 
	c:\ci-jenkins\workspace\TMSM\OnPremise-Patch6\TMSM-Server-OnPremise-Patch6\en\installshield\
	TMSforMacintosh\Script Files\Setup.Rul, 259)

[9-13-2022 13:38:10][DebugLevel-Info]---Error message There is not enough space on the disk.

Based on the findings, the Installation directory does not have enough space to perform the Apex One (Mac) plugin installation.

Resolution

  1. Add a disk space in the Apex Server installation directory.
  2. Restart the Apex One Plugin Manager Services and Apex One Master Service, then try to reinstall the Apex One Mac plugin.
  3. Verify if the installation will proceed.