How to Update ACVSCore.dbo.ApplicationServer with Transact-SQL in SQL Server Management Studio

Article ID: SWH-KB-nID-000006849 Published: Oct-20-2022   First check to see what the current values of the relevant fields in the table are with a SELECT statement.     SELECT ObjectID, MachineName,uri,IPAddress FROM ACVSCore.dbo.ApplicationServer     To ensure that the ACVSCore.dbo.ApplicationServer table is updated accurately, use a T-SQL statement such as:     UPDATE ACVSCore.dbo.ApplicationServer SET  MachineName… Continue reading How to Update ACVSCore.dbo.ApplicationServer with Transact-SQL in SQL Server Management Studio

C•CURE 2.70 SP7 Fails to Install with Error Stating It Cannot Open CUREIDPrintQueueManager.exe.config

Article ID: SWH-KB-nID-000006820 Published: Oct-20-2022 Symptom(s)   Installation of C•CURE 2.70 SP7 fails; the following error appears:   Error 25531. Failed to open XML file C:\Program Files (x86)\Tyco\CCURE Client\CCUREIDPrintQueueManager.exe.config, system error: -2147024786     Solution   Edit the (x86)\Tyco\CCURE Client\CCUREIDPrintQueueManager.exe.config file, and in the top line, remove the encoding=”utf-16″ from the XML tag so it looks… Continue reading C•CURE 2.70 SP7 Fails to Install with Error Stating It Cannot Open CUREIDPrintQueueManager.exe.config

C•CURE Upgrade from 2.6 to 2.7 or Greater Fails with Error: Violation of PRIMARY KEY Constraint ‘PK_XFEventLog’

Article ID: SWH-KB-nID-000006853 Published: Oct-20-2022 Symptom(s) Upgrade from version 2.60 or earlier to version 2.70 or later fails.  The following error is found in the installation logs: Error SQL72014: .Net SqlClient Data Provider: Msg 2627, Level 14, State 1, Line 228 Violation of PRIMARY KEY constraint ‘PK_XFEventLog’. Cannot insert duplicate key in object ‘Access.XFEventLog’. The duplicate… Continue reading C•CURE Upgrade from 2.6 to 2.7 or Greater Fails with Error: Violation of PRIMARY KEY Constraint ‘PK_XFEventLog’

XML Import – Culture Settings for Date and Time Fields

Article ID: SWH-KB-nID-000006866 Published: Oct-20-2022   XML Import depends on the culture settings in the XML heather, for date and time related fields; if this information is not provided, then the Import will default to the cultural settings of the windows account that is running the CrossFire Service.   Example 1:   Culture is defined… Continue reading XML Import – Culture Settings for Date and Time Fields