Please check SP-EXPERT Compatibility.

Please apply patches only on corresponding SP-EXPERT versions.

Please use patch.ps1 if available after stopping TIService (automatically unblocks files and automatically updates config files), instead of manually overwriting existing files. Example:

.\patch.ps1 -deployDir "C:\Interflex\SP-EXPERT Forecast"

For updates from SP-EXPERT version older than 21.2 DB update is a 2-step process:

Update using DBManager 21.2
Update using the TIS-Installer from the deployment after having applied the appropriate patch (download below)
Example: .\patch.ps1 -spxVersion 22.3.2 -deployDir "C:\Interflex\SP-EXPERT Forecast"

Unblock files from internet

On some servers files might be blocked by the operating system and must be unblock explicitly. See also Microsoft's documentation

Version 6.9

Only applicable for SP-EXPERT version 24.1

In case of a new installation, please drop newly created databases and re-create with the patched TISInstaller

In case of updating an installation, please (1) apply patch and (2) delete project clones via AdminPortlet "All project clones" or using following SQL statement before updating the database schema:

In case of plano operator usage, xiOperations.xml needs to be manually extended after applying the patch by merging following template into it.

xiOperationsTemplate.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- Source for planoInstaller: Copies all Elements 'Category' and 'Services' to Interflex\SP-EXPERT Forecast\TimeIntelligence\TEMPLATES\OPERATIONS\xiOperations.xml -->
<XimesOp xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="XimesTI.xsd">
  <Version Major="1" Minor="0" Revision="1"/>
  <Categories>
    <Category Assembly="planor.tis.Operators" Id="18" ResId="plano" Name="plano"/>
  </Categories>
  <Services ServiceName="plano" Assembly="plano.tis.Operators">
    <Operations Section="planor.tis.Operators" UsageHint="SendBudgetCurve" Name="SendBudgetCurve" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="SendSimpleCurve" Name="SendSimpleCurve" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="SendStaffingLevels" Name="SendStaffingLevels" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="SendRelativeOpeningHours" Name="SendRelativeOpeningHours" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="SendAbsoluteOpeningHours" Name="SendAbsoluteOpeningHours" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadBudget" Name="ReadBudget" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>Empty</AppliedTo>
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadBudgetTableParams" Name="ReadBudgetTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadSimpleCurve" Name="ReadSimpleCurve" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>Empty</AppliedTo>
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadSimpleCurveTableParams" Name="ReadSimpleCurveTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadStaffingLevels" Name="ReadStaffingLevels" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>Empty</AppliedTo>
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadStaffingLevelsTableParams" Name="ReadStaffingLevelsTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadStaffingLevelsWithActualTableParams" Name="ReadStaffingLevelsWithActualTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadRelOpeningHours" Name="ReadRelOpeningHours" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>Empty</AppliedTo>
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadRelOpeningHoursTableParams" Name="ReadARelOpeningHoursTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadAbsOpeningHours" Name="ReadAbsOpeningHours" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>Empty</AppliedTo>
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadAbsOpeningHoursTableParams" Name="ReadAbsOpeningHoursTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadCapacitiesFromContractsTableParams" Name="ReadCapacitiesFromContractsTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadCapacitiesFromContractsAndFunctionsTableParams" Name="ReadCapacitiesFromContractsAndFunctionsTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadContractEmployeeStaffingForGroupsTableParams" Name="ReadContractEmployeeStaffingForGroupsTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadShiftScheduleEmployeeStaffingTableParams" Name="ReadShiftScheduleEmployeeStaffingTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadCalendarInformationsFromGroupsTableParams" Name="ReadCalendarInformationsFromGroupsTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadActualStaffingFromShiftTypesTableParams" Name="ReadActualStaffingFromShiftTypesTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadCapacitiesFromBookingsTableParams" Name="ReadCapacitiesFromBookingsTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadWorkflowDataPerEmployeeTableParams" Name="ReadWorkflowDataPerEmployeeTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadWorkflowDataPerGroupTableParams" Name="ReadWorkflowDataPerGroupTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadWageAccountValuesPerGroupTableParams" Name="ReadWageAccountValuesPerGroupTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadFullDayStaffingLevelsWithActualTableParams" Name="ReadFullDayStaffingLevelsWithActualTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadBaseDataView" Name="ReadBaseDataView" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>Empty</AppliedTo>
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="SendFullDayStaffingLevelsTableParams" Name="SendFullDayStaffingLevelsTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadBudgetWithActualTableParams" Name="ReadBudgetWithActualTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
    <Operations Section="planor.tis.Operators" UsageHint="ReadBookingsForEmployeeAndAccountTableParams" Name="ReadBookingsForEmployeeAndAccountTableParams" AssignedToCategory="18" KindExternalOp="2">
      <AppliedTo>All</AppliedTo>
      <Becomes>Same</Becomes>
    </Operations>
  </Services>
</XimesOp>

Patch	Tag	Database schema version	Release Date	Interflex Status	Description
TIS6_9_0-51420 (cumulative)	v6.9.0.17	dbupdate-2024-04-17-1132.sql	2024-04-17	Testing	#10350 Changed log level for Interflex licencing to info #10348 Improved and regenerate DB-Scripts #10346 Added Excel import to tislib #10321 Set degree of parallelism of cronjobs at deployment time
TIS6_9_0-51073 (cumulative)	v6.9.0.16		2024-04-11	Testing	#10339 Revert changes for XIH.SetDateTime allowing UTC values #10325 Fixed timeout problem with MSSQL when creating/updating database #10277 Fixed Import Text/CSV file operator - added DE and fixed other resources Revert 8873 #10307 Improved loadmask by loading rights and permissions #10034 Fixed showing online instances offline in Admin portlet #9441 Improved Stimulsoft with fallback language setting Revert #9979 #9979 Fixed tisconfig template for redis #10147 Fixed typo for Postgres DB-Update script
TIS6_9_0-49778 (cumulative)	v6.9.0.15		2024-03-18	Approved	#10033 Improved cluster handling with same server name #10237 Improved TISInstaller features #10260 Fixed not visible role management
TIS6_9_0-49423 (cumulative)	v6.9.0.14		2024-03-13	Testing	#10289 Fixed missing settings when upgrading the Create pivot table V4 to V5 operator revert #10283 Change behaviour for the Merge data operator #10256 Fixed creating guard service during installation #10147 Added deletion of Project-clones during DB-Schema update #9441 Added fallback language to StimulsoftViewer #10279 Fixed column order in case of an Excel-Export from TISBoard #10260 Added option to delete Project users in Editor #10240 Fixed build name in TISInstaller #10278 Fixed removing of OpenID rolemapping entries #10270 Fixed SQL Operator losing file reference with export #10034 Fixed showing online instances offline in Admin portlet
TIS6_9_0-48750 (cumulative)	v6.9.0.13		2024-03-04	Testing	#10252 Fixed file handling of SQL-query operator #10237 Improved TISInstaller AppID and redis handling #10238 Fixed column order after updating the rename, delete, reorder operator #10246 Tispatcher moved from service to DB-update #10243 Improved patching process during DB-update #10223 Fixed UI Bug when pageing used in Editable grid #10228 Fixed connection string handling with oracle managed client #10098 Improved robustness of cronjob activation #10219 Fixed excel export from TISBoard #10180 Improved database configuration-file creation #10218 Improved handling of oracle database when, creating/updateing/servicestart #10121 Improved warning message when updating the operator pivot table #10215 Improved Stimulsoft reporting with cluster #10196 Improved warning message using the SQL-import operator #10137 Improved cronjob state management #10193 Fixed TIS certificate handling in cluster #10167 Fixed cronjob with solutionrunner mode #10168 Improved error handling running Cronjobs #10165 Fixed OP merge data 5.0 when using ignore time function #10168 Added support for port usage with MSSQL connection and DAL config #9992 Fixed place holders for sitename
TIS6_9_0-46511 (cumulative)	v6.9.0.12		2023-12-13	Approved	#10128 Removed DbConnectionPool #10120 Fixed bug for chart operator usage without legend #10116 Improved message in case of database acccess with integrated security #10115 Fixed checksum difference for Oracle #10068 Imporved NL translation #10110 Fixed create user script for MSSQL #10101 Fixed checksum difference for MSSQL #10098 Improved CronJob settings with autoretry
TIS6_9_0-46033 (cumulative)	v6.9.0.11		2023-11-20	Testing	For updating database with ORA please use this patch. #9986 Removed usage of modulpath #9830 Fixed number of lines with Python operator
TIS6_9_0-45954 (cumulative)	v6.9.0.10		2023-11-17	Testing	#9986 Improved error handling in case of failed checksum
TIS6_9_0-45929 (cumulative)				Testing	For new installations with MSSQL please use this patch. #10083 Fixed creating a new database on MSSQL (schema checksum check failed) #10071 Fixed TISBoard Multiselect portlet for invalid values
TIS6_9_0-45872 (cumulative)	v6.9.0.9		2023-11-13	Approved	#10079 Improved patch.ps1 check TIS version, removed 7z dependency #10070 Removed unnecessary 7z dependency check
TIS6_9_0-45828 (cumulative)	v6.9.0.8		2023-11-10	Approved	#10007 Excel Download with dynamic combo box in EdGrid not having unique key columns #10067 Fixed Rename-Op: explicit rename column name available now #10065 Fixed TISInstaller update Oracle database removed obsolete generate script checkbox #10038 More logging for Stimulsoft portlet in portlet designer error "The report is not specified" #10073 update database schema fails when checking obsolete operators
TIS6_9_0-45672	v6.9.0.7	dbupdate-2023-09-07-0749.sql	2023-11-06		#10026 EJS Chart 5.0 operator update fixed #10008 caused by #8245 Date has time portion 12:00 reverted to 00:00 #8822 Fixed Stimulsoft portlet designer new calculation mode "KeepFromMrt" as default #10041 Fixed Stimulsoft operator: Column 'PDFPWD' does not belong to table PARAMETER #10047 Fixed SPX operators return changed column captions due to missing resource resolution #10061 Fixed Standard-Reports stop working with IF-STANDARD/1 license for newly created databases due to missing StdReport* roles In case of a new installation, please drop newly created databases and re-create with the patched TISInstaller
TIS6_9_0-43804	v6.9.0.6	dbupdate-2023-04-27-1010.sql	2023-08-08		Released with SPX 24.1

Version 6.8

Only applicable for SP-EXPERT version 23.2

Patch

Tag

Database schema version

Release Date

Interflex Status

Description

v6.8.0.4

dbupdate-2022-08-04-1313.sql

Please update the database scheme to new version using TISInstaller

#9026 Fix error with start page on partial page deployment/synchronization
#8884 Fix subsession logon via Python op/pytisapi executed within a cron job
#8924 Fix incomplete DB patch: Add missing TIS table meta data
#9008 Prevent project copies being deleted by 'Project Clone' admin portlet action
#8999 Fix precision loss on copy/paste of decimal numbers in EdGrid (TISBoard) and Edit Table op (Editor)
#8970 TISInstaller: Support aborting long running operations (deployment)
#8662 TISInstaller: Support converting ORACLE connection string to ManagedDataAccess driver format
#8948 Editor: Fix 'Edit Table' operator settings UI
#8982 TIService: New setting GetProjectCacheLockTimeout (for long running TISBoard portlet calculations)
#8994 TISInstaller: Fix template config
#8985 TISBoard: Fix unexpected logout if browser tab in background
IF-272 Wait for SPX application server prior to login
#8635 Editor: Allow '/' (in addition to '\') in python op settings paths
IF-298 Editor: Fix dynamic settings in graphs of diagram ops
#8954 Editor: Implement XIH.GetDownloadUrl for generating secure download URLs
IF-273 ESS: Fix dashboard page sharing
IF-296 UM: Fix page sync on role assignment or template role user setting
#8936 Multi-session logoff: Close all SignalR connections
#8935 Multi-session logoff: Properly log out all sessions at once
#8949 Editor: Remove EnableOpMetadataSnapshot session setting
#8780 Editor: Try showing op settings even in error state

TIS6_8_0-42740

v6.8.0.3

dbupdate-2022-07-06-1434.sql

2022-07-11

SPX 23.2 Beta

Version 6.7

Only applicable for SP-EXPERT version 23.1

Patch	Tag	Database schema version	Release Date	Description
TIS6_7_0-41917	v6.7.0.5	dbupdate-2022-04-15-2035.sql	2022-06-30	#8870 TISBoard: Added docx mime type #8667 Op settings: AllowOverriding for MarkDirtyCurrentProjectOnly ("Write TIS Table" and related ops) #8830 TISBoard: Fix "Error in Fileguard files portlet if no file guard configured" #8798, #8607 TISBoard: Fix redis timeout in cron job portlet IF-276 Implement script to switch svc user from LOCAL SYSTEM to dedicated svc user #8835 Python: Fix unnecessary timeout on script error (race condition) #8799 TISBoard: Fix "Page portlets not updated on master portlet save" #8757 Fix an error when importing with option "Use existing portlets" IF-275 Fix for error during del of TIS resource strings FLEX-8797 TISBoard/EdGrid: Disable "clear filters" during editing #8740 TISBoard: Add HideLoadMask flag to HTML portlet layout IF-277 Patching: Adjust cc.SpExpert assembly redirect dynamically IF-278 Deployment: Add TISBoard\IR\Configs folder #8772 Fix missing schema info of EdGrid tables and add new op version w/ stricter behav on schema mismatch #8774 Fix order of result table columns in "Read editable grid" operator #8769 C# op: Fix error message on syntax error #8734 DB: Change ximesfilelinescount to number(10) #8679 Cron Jobs: Implement user pool for cron jobs #5568 DB: Remove remnants of DB job during DB creation #8730 Cron Jobs: Keep cronjobs alive during calculation #8451 Fix an error when exporting TIS resource strings #8710 Cron Jobs (ORA): Fix error duing del of Cron Jobs #8513 Fix an error when importing #8569 Editor/OpEditTable: Increase max length of TIS table name to 500 char #8688 Update python to 3.9.12
TIS6_7_0-41794	v6.7.0.4		2022-04-01	#8686 TIS-Installer: Better error logging #8551 Editor/UM: Deny access for non-clientadmin user if flag TemporaryPermissionsEnabled not set #8506 TISBoard: Implement user portlet layout for dynamic adjustments to result table structure #8640 Editor: Fix missing permission checks (del, edit project/dn/op) #8648 Editor: Open projects in exclusive mode #8649 TISBoard: set SameSite=None; Secure in all HTTPS contexts, CookieUtil.js for easier adaption of custom login pages #8389 TIS-Installer: Support ximesdalconfig.xml-only deployment #8569 Editor: limit length of table caption in edit table op #8644 TIS-Installer: Reorganize Deploy form using tabs #7509 C#-Op: Support roslyn as compilation option IF-265 TISBoard: Stimulsoft viewer - fix data export IF-216 Mark external token methods as anon requests (cures warnings in log file) #8532 TIS-Installer: Export db schema scripts #8589 License: Fix project type check #8611 Fix cancellation for cron job w/ realc op #8583 Execute logon events after logon scripts #8600 Fix deep copy of OpDatanodeRefs md snapshot #8534 TIS-Installer: ximesdalconfig.xml manuell erstellen
TIS6_7_0-41624	v6.7.0.3	dbupdate-2022-02-11-1153.sql	2022-02-15	SPX 23.1 Beta

Older Versions

Software Patches up-to version 6.6
Software Patches up-to version 5.15
SP-EXPERT Compatibility up-to version 5.16