Please check TIS releases with plano or 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.
<?
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
=
"ReadBudgetWithActualTableParams"
Name
=
"ReadBudgetWithActualTableParams"
AssignedToCategory
=
"18"
KindExternalOp
=
"2"
>
<
AppliedTo
>All</
AppliedTo
>
<
Becomes
>Same</
Becomes
>
</
Operations
>
</
Services
>
</
XimesOp
>
Patch | Tag | Database schema version | Release Date | Interflex Status | Description |
---|---|---|---|---|---|
v6.9.0.21 | dbupdate-2024-07-23-1107.sql | 2024-09-06 | Testing |
| |
v6.9.0.20 | dbupdate-2024-07-09-1342.sql | 2024-07-18 | Testing |
| |
v6.9.0.19 | 2024-07-04 | Testing |
| ||
v6.9.0.18 | dbupdate-2024-06-05-2125.sql | 2024-06-27 | Approved |
| |
v6.9.0.17 | dbupdate-2024-04-17-1132.sql | 2024-04-17 | Approved |
| |
v6.9.0.16 | 2024-04-11 | Approved |
| ||
v6.9.0.15 | 2024-03-18 | Approved |
| ||
v6.9.0.14 | 2024-03-13 | Testing |
| ||
v6.9.0.13 | 2024-03-04 | Testing |
| ||
v6.9.0.12 | 2023-12-13 | Approved |
| ||
v6.9.0.11 | 2023-11-20 | Testing | For updating database with ORA please use this patch.
| ||
TIS6_9_0-45954 (cumulative) | v6.9.0.10 | 2023-11-17 | Testing |
| |
Testing | For new installations with MSSQL please use this patch.
| ||||
v6.9.0.9 | 2023-11-13 | Approved |
| ||
v6.9.0.8 | 2023-11-10 | Approved |
| ||
TIS6_9_0-45672 | v6.9.0.7 | dbupdate-2023-09-07-0749.sql | 2023-11-06 |
| |
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
| |||
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 | Interflex Status | Description |
---|---|---|---|---|---|
TIS6_7_0-41917 | v6.7.0.5 | dbupdate-2022-04-15-2035.sql | 2022-06-30 |
| |
TIS6_7_0-41794 | v6.7.0.4 | 2022-04-01 |
| ||
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