(warning) Please check TIS releases with plano or SP-EXPERT compatibility.

(warning) Please apply patches only on corresponding SP-EXPERT versions.

(warning) 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"

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

  1. Update using DBManager 21.2
  2. Update using the TIS-Installer from the deployment after having applied the appropriate patch (download below)
  3. 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

(warning) Only applicable for SP-EXPERT version 24.1

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

(warning) 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:

(warning) 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="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

6.9 2024/09/06 (TIS6_9_0-58642)

v6.9.0.21

dbupdate-2024-07-23-1107.sql

2024-09-06

Testing

  • #10356 Added AWS cloud database create/update support
  • #10300 Fixed pool users seeing the dashboard page of the template user
  • #10462 Fixed missing Tispatcher and TIService config
  • #10470 Added usage specific characterset to md5 checksum
  • #10086 Improved deletion of dashboard tree when there are no pages left
  • #9248 Fixed lost Operator references by replacing project
  • #10474 Fixed Scaling Operator line counting
  • #10526 Fixed SQL Syntax for Column Definition
  • #10421 Improved Operator documentation links in TISEditor
  • #10449 Added Cronjob Monitorig with E-Mail notification
  • #10534 Fixed Postgres deadlock in case of AWS deployments
  • #10430 Added delivery DB server timezone based on MSSQL version
  • #10410 Fix deploy scripts to avoid server Http 500 with multiple deployments on the same server
  • #10590 Fixed syntax error
  • #10556 locks on template project instead of clone project fixed
  • #10507 duplicate project clones on user pool logon
  • #10592 Updated DB checksums
  • #10525 Added german as default user language

6.9 2024/07/17 (TIS6_9_0-56012)

v6.9.0.20

dbupdate-2024-07-09-1342.sql

2024-07-18

Testing

  • #10456 Fixed Oracle update script for table t1061 - upgrading from 6.6 or lower to 6.9 or higher with older versions causing potential loss of custom column formatting in TIS tables or result tables.
  • #10449 Added CronJob E-Mail monitoring with deployment option
  • #10437 Improved MSSQL database script
  • #10420 Improved swagger documentation
  • #10388 Improved Oracle checksum
  • #10328 Fixed cummulation project clones for CronJob runs

6.9 2024/07/04 (TIS6_9_0-55258)

v6.9.0.19


2024-07-04

Testing

  • #10356 Added AWS cloud database create/update support
  • #10300 Fixed pool users seeing the dashboard page of the template user

6.9 2024/06/26 (TIS6_9_0-54819)

v6.9.0.18

dbupdate-2024-06-05-2125.sql

2024-06-27

Approved

  • #10415 Improved SQL Export operator column name handling
  • #10345 Improved Cronjob running with preventing user session expriration
  • #10399 Fixed language files for portugese and french
  • #10396 Fixed sorting in the operator sort, rename
  • #10377 Making header set X-frame-options configurable 
  • #10387 Removed nologging clause for index creation on oracle databases
  • #7271 Added checkbox IsLongRunning for operator recalculation with input table
  • #9959 Fixed and imporved handling of long running tasks with added checkbox option
  • #10375 Improved project copying process and deleting orphan records
  • #10371 Added missing project path to link
  • #9482 Improved paste perfomance + show executed steps
  • #10240 Fixed pattern to find release version

TIS6_9_0-51420 (cumulative)

v6.9.0.17

dbupdate-2024-04-17-1132.sql

2024-04-17

Approved

  • #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

Approved

  • #10339 Revert changes for XIH.SetDateTime allowing UTC values
  • #10325 Fixed timeout problem with MSSQL when creating/updating database (warning)
  • #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

(error) 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

(error) 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
    • (warning) 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

(warning) 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



(warning) 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

(warning) 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


  • #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