SP-EXPERT Compatibility .
patch.ps1 if available after stopping TIService (automatically unblocks files and automatically updates config files), instead of manually overwriting existing files.
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" On some servers files might be blocked by the operating system and must be unblock explicitly. See also Microsoft's documentation
22.3.0, 22.3.1, 22.3.2, 22.3.3, 22.3.4 LTSR
Patch
Tag
Database schema version
Release Date
Interflex Status
Description
TIS6_6_0-50918 (cumulative)
v6.6.0.19
2024-04-09
Testing
ns 22.3.*. Please provide the exact SPX version as an argument to the patch.ps1 script (e.g. '-spxVersion 22.3.2').
TISInstaller .
#10137 Improved syncronization between Cronjobs and redis #10215 Improved Stimulsoft reporting with cluster #10219 Fixed excel export from TISBoard #10270 Fixed SQL Operator losing file reference with export #10034 Fixed showing online instances offline in Admin portlet #10098 Improved CronJob settings with autoretry #10161 Fixed connection string format for MSSQL #9741 Improved compatibility with Plano 1.38 #9441 Added fallback language to StimulsoftViewer #10098 Added setting CronJobAutoRetry #9026 Improved shared page deployment using the start page function #9890 Fixed legacy operators using System.Integer settings #9848 Impoved deployment during warm-up with SSL #9827 Improved Selenium chrome driver and browser installation #9853 Improved TISInstaller cleanup #9604 Improved cronjob monitoring and error reporting #9914 Improved cluster deployment in case of 5 or more instances TIS6_6_0-44737 (cumulative)
v6.6.0.18
dbupdate-2023-08-28-2002.sql
2023-09-13
Approved
ns 22.3.*. Please provide the exact SPX version as an argument to the patch.ps1 script (e.g. '-spxVersion 22.3.2').
TISInstaller .
#9918 Fixed Multiselect in case of "\" in selected text #9915 Fixed missing files on SPX Cluster installation #9913 Fixed possible NRE on Generate shifts operator TIS6_6_0-44175 (cumulative)
v6.6.0.17
dbupdate-2023-08-11-0847.sql
2023-08-22
Approved
ns 22.3.*. Please provide the exact SPX version as an argument to the patch.ps1 script (e.g. '-spxVersion 22.3.2').
TISInstaller .
#9839 Exclude hidden projects in xirp0004 #9868 Implement stale op/dn recalc thread monitoring #9825 Make import tasks long running #9773 Check tableoppara records at export #9774 Return info regarding failed patches TIS6_6_0-42252 (cumulative)
v6.6.0.16
dbupdate-2023-06-07-0859.sql
2023-06-19
Approved
ns 22.3.*. Please provide the exact SPX version as an argument to the patch.ps1 script (e.g. '-spxVersion 22.3.2').
TISInstaller .
IF-364 Fix license read problem on non-English OS #9736 Improve DB update performance #9728 IF-302 Stimulsoft culture: Use ietf lang tag instead of 2-letter-iso-code #9653 Export: Substitute special characters in file name #9599 Python Op: Don't throw exception if script file cannot be resolved during copy data node/project #9543 CronJob: Implement retry for activate (get session) #9663 Prevent misconfigured cron job runs (template project/clone data source) #9628 Make EnableFirstChanceExceptionLogging runtime controllable #9596 TISBoard: Delete tree nodes of pages belonging to the deleted user TIS6_6_0-40825 (cumulative)
v6.6.0.15
dbupdate-2023-04-18-0919.sql
2023-04-19
Approved
ns 22.3.*. Please provide the exact SPX version as an argument to the patch.ps1 script (e.g. '-spxVersion 22.3.2').
TISInstaller .
IF-330 Fix problem with "Sorting" op and OutOfMemoryException related to cc.License.dll #9595 TISEditor: Fix race condition during copying TIS tables #9596 TISBoard: Fix deleting tree nodes on user deletion #8981 Chart op: Fix op getting dirty after graph display setting change #9504 Add MinIOThreads setting #9601 Write TIS table op: Fix for creating views for EdGrid TIS tables #9517 Write TIS table op: Fix inadvertent update of rows in "Append" mode (introduced by #9176/v6.6.0.14) #9625 Write TIS table op: Fix NullReferenceException when start table empty (introduced by #9176/v6.6.0.14) #9538 Limit TaskRunner session keep-alive to cron job sessions and subsessions #9574 Make core session keep-alive more robust #9583 Log stack trace of uncancellable tasks TIS6_6_0-38980 (cumulative)
v6.6.0.14
2023-02-10
ns 22.3.*. Please provide the exact SPX version as an argument to the patch.ps1 script (e.g. '-spxVersion 22.3.2').
TISInstaller .
IF-331 Sort operator: Implement upgrade path to XIMES sort operator #9176 Write TIS Table operator: Improve handling of null values in keys #9432 TI Service: Fix occasional HttpListener errors #9441 IF-302 Stimulsoft: Fix culture info in C# coded report parts IF-330 Operators: Improve exception logging in case of failure (2) TIS6_6_0-38521 (cumulative)
v6.6.0.13
dbupdate-2022-10-14-1925.sql
2023-01-24
Approved
ns 22.3.*. Please provide the exact SPX version as an argument to the patch.ps1 script (e.g. '-spxVersion 22.3.2').
TISInstaller .
#9356 TISEditor: Fix copying TIS files (ORA) #9360 TISInstaller: Fix error message when upgrading ancient database #9223 Cluster: Fix online instances Redis query timeout #9340 Extend user pool warm-up to include project patching C# operator: Set CCXUseRoslyn to true by default IF-330 Operators: Improve exception logging in case of failure #9299 Fix missing dn op relations in merge ops #9280 TISEditor: Fix operator TIS parameter display in case no op is selected #9168 TISBoard: Fix Excel export containing not-up-to-date #9175 TISBoard: Fix deleting user folders when deleting pool users #9282 Redis: Handle all timeout exceptions IF-327 Python: Include entire pytisapi folder #8846 Escalate if license is missing during project export #9246/IF-310 TISInstaller: Hide passwords in log during MSSQL db operations #9214 TISBoard: Fix orphaned folders in portlet tree #9152 Fix potential deadlock during high frequency table locking (t0002) #9209 Fix loading issues of xir.TIS ressource DLLs #9121 TISInstaller: Check sqlcmd existence #9162 TIService: Don't set security protocol explicitly (let OS decide) #9036 Fix session issues in OpendID/cluster setups #8251 Export: Include projects referenced by TISBoard events #9166 Fix NRE during logging in authentication TIS6_6_0-35748 (cumulative)
v6.6.0.12
dbupdate-2022-09-23-0829.sql
2022-09-30
Approved
ns 22.3.1, 22.3.2, 22.3.3 and 22.3.0. For version 22.3.0: Please install patch TIS6_6_0-40660 (cumulative) (v6.6.0.4) beforehand.
TISInstaller
IF-336 Fixed patch.ps1 with dependentAssemblyRedirect IF-324 TISInstaller: Add support for installing sqlcmd (requirement for MSSQL updates) #9076 Add missing indices on some DB tables #9040 Fix re-use of cron job user pool users #8932 TISBoard: Cron job portlet - fix exception when inputting invalid cron job settings #8746 TISInstaller: Hide password when updating ORA DBs #9031 Init data node: Don't calculate in template projects #9013 Editor: Python-Op - prevent duplicate file references #9009 TISInstaller: Increase default timeout #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 #8948 Editor: Fix 'Edit Table' operator settings UI #8982 TIService: New setting GetProjectCacheLockTimeout (for long running TISBoard portlet calculations) #8985 TISBoard: Fix unexpected logout if browser tab in background TIS6_6_0-40913 (cumulative)
v6.6.0.11
2022-07-25
ns 22.3.1, 22.3.2 and 22.3.0. For version 22.3.0: Please install patch TIS6_6_0-40660 (cumulative) (v6.6.0.4) beforehand.
TISInstaller
IF-272 Wait for SPX application server prior to login IF-298 Editor: Fix dynamic settings in graphs of diagram ops TIS6_6_0-40898 (cumulative)
v6.6.0.10
dbupdate-2022-07-06-1402.sql
2022-07-19
ns 22.3.1, 22.3.2 and 22.3.0. For version 22.3.0: Please install patch TIS6_6_0-40660 (cumulative) (v6.6.0.4) beforehand.
TISInstaller
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 IF-276 Service user patch: Fix ACLs of a DCOM used by SPX operators and fix setting log directory ACLs #8642 TISBoard: Fix dashboard node permission validation after moving a node #8545 Cron Jobs: Fix error message when saving cron jobs IF-291 TIS installer: Fix no response on ORA DB update credentials error #8725 CC_PERSISTENCE: Fix UpdateCultureInfo implementation #8748 TIS installer: Add missing error message for DB update (ORA) #8216 Userpool warm-up: Take all pages in shared folder into account #8792 Project: Fix broken init datanode links #8852 Write TIS table operator: Exclude NULL values from key comparison #8667 Operators: Enable parameter overriding for MarkDirtyCurrentProjectOnly setting in TIS table related operators #8677 Cron Jobs: Clean up stale cron job run locks (after service restart) #8003 Performance: Set TIS table row count asynchronously #8607 Redis: Handle more timeout cases #8830 TISBoard: Don't throw exception in fileguard files portlet if no fg configured #8798 TISBoard: Fix redis timeout error in admin portlets TIS6_6_0-40845 (cumulative)
v6.6.0.9
2022-06-30
ns 22.3.1, 22.3.2 and 22.3.0. For version 22.3.0: Please install patch TIS6_6_0-40660 (cumulative) (v6.6.0.4) beforehand.
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) #8831 Remove TI svc setting "ForceRecreatingAdminPortlets" #8799 TISBoard: Fix "Page portlets not updated on master portlet save" #8757 Fix an error when importing with option "Use existing portlets" TIS6_6_0-40814 (cumulative)
v6.6.0.8
2022-05-03
Approved
22.3.1 LTSR
TIService is stopped, and execute provided install script patch.ps1 as administrator
TISInstaller
IF-277 patch.ps1: Adjust cc.SpExpert assembly redirect dynamically IF-278 patch.ps1: Add TISBoard\IR\Configs folder #8769 Fixed Formular-Op: Return proper error msg on C# syntax error for legacy compilation as well #8774 Fixed Read EdGrid-Op: order of result table cols #8465 Fixed condition for SUPERUSER dashboard folder patch (generate scripts)
TIS6_6_0-40803 (cumulative)
v6.6.0.7
dbupdate-2022-04-15-2045.sql
2022-04-19
22.3.1 LTSR
TIService is stopped, and execute provided install script patch.ps1 as administrator
TISInstaller
#8734 Change ximesfilelinescount to number(10) (Oracle only) #8730 Keep cronjobs alive during long running operations #8680 CronJobs: Lock cluster induced modify and del action #8710 Fix deleting cron job entries (Oracle only) #8513 Fix import of t1060/t1061 records in case of non-result table/use-existing conflict handling #8688 Update Python to 3.9.12 #8679 Implement user pool for cron jobs #8513 Ignore saving content in mode UseExistingTable #8551 UM: Deny access for non-clientadmin user if flag TemporaryPermissionsEnabled not set #8506 TISBoard: Support dedicated user portlet layout in shared dashboard tree #8640 Editor: Fix various permission checks #8648 Editor: Support opening projects in exclusive mode #7509 C#-Op: Support roslyn as compilation option IF-265 TISBoard - Stimulsoft Viewer: Fix data export IF-264 Detail logs regarding generate/verify manifest IF-216 Add IsExternalTokenValid and PingExternalToken API #8589 Editor: Adapt checking project type allowed #8611 Fix cancellation for cron job w/ realc op TIS6_6_0-40671 (cumulative)
v6.6.0.5
2022-02-18
Approved
22.3.1 LTSR
TIService is stopped, and execute provided install script patch.ps1 as administrator
#8465 TISInstaller fixed and update database creates Standard roles/users as well #8427 Fixed OpenId session handling first refresh to be done earlier
#8583 Improved Execute logon events after logon scripts instead of in parallel
#8600 Fixed deep copy of OpDatanodeRefs md snapshot
#7509 Fixed C#-Op: Keep DLL as file too (w/ CcxKeepTempFiles=True)
#8582 Fixed lifestyle of IModelValidation
#8573 Fixed null-check for ParameterList
#8505 Fixed TISInstaller CcSpExpertVersion
#8480 Fixed TISInstaller ensure pip for pypy
SPX 22.3.1 Release
TIS6_6_0-40660 (cumulative)
v6.6.0.4
2022-02-15
22.3.0 LTSR
TIService is stopped, and execute provided install script patch.ps1 as administrator
#8573 null-check for ParameterList
#8521 Fix anonymous user session key
#8463 Register file guard update msg on mq
#8524 Op-Settings: Allow caption and index column references side-by-side
#8317 TISInstaller: Multiply deployment timeout (as secs) with the number of instaces
#8452 XIH.AccountId(): Only return AccountID if user type is anonymous user
#8458 TISBoard-Excel Export: Added random numbers to filename
#8546 Add setting SetDirtyUpdateRecordCountPerStmt (default=20)
#8544 call setValues for tile submits/ master submits as well
#8582 Fix lifestyle issue with IModelValidation (Editor) #8553 Fix memory leak newly created TISDB schema lacking some Interflex objects for Standard-Reports #8485 Enforce max dashboard tree node name length of 50 characters SPX - Shift Schedule: fixed "Blind not expected" error (IF-803036-69224)
SPX - Shift Schedule: fixed time period filter
IF-210 Generic Calendar: display description text #8463 FileGuard - FgFileCleanup: respect fg's allowed APPIDs
#8494 OpNullHandling: Fehler Null-Werte ersetzen bei Time Spalten
#8508 Preserve TIS column type in old-style ops (GenericCalendar et al)
#8510 MergOp FullOuterJoin Bug in RowCopyFunction
#7893 Don't set result table when applying obsolete warning
#6499 OpFilter Upgrade now converts implicit parameter usage to explicit reference using #XI.TISPar('xy')#
#8516 ControlPortlet: fix dirty handling for date*-parameters
#8519 Fix null bit manipulation in GenTable.ReorderColumns
#8507 Fix for: Upgrade to OpMergeData5 changes column order behaviour
#8456 Make config: Case sensitive sync sitename to dirname
#8456 Default site name is 'TIS' (upper-case)
#8488 ORA: script with error handling
#8489 Export Excel from TISBoard: wrong formatting because of hidden columns
#8478 Improvement of "DELETE_AND_INSERT_BY_KEY_STATEMENT" on MSSQL
#8386 pytisapi: deal with None bugfix squashed
#8354 EdGrid: Close various reader instances
#8403 Fix pool user creation/deletion in cluster scenarios
#8414 Python-Op: Force utf-8 on stdin
#8233 Disable some inevitable exceptions when EnableFirstChanceExceptionLogging is turned on
#8395 Log off all local users on svc start
#7509 C# op: Support custom temp dir
#8297 OpPersistence: Replace xirp0032 with xirp_find_child_xpd
#8406 MSSQL ximp0003: set low deadlock prio
#8406 Lazy del project cache user
#8181 Disable temp perm if TemporaryPermissionsEnabled=False
#8181 xirp0021 perf improvements
MSSQL ORA Update 6.5 scripts
Add missing PGSQL 6.5 scripts
#8405 Remove patch del from xisp0012
Cluster: 20 Instanzen für namedpipeserver zulassen
#8394 Query applock before taking, to work-around unreliable LockTake method
#8225 Set LogOn lock expiration timeout to 5 min
LibIniFiles.ps1: Fix error with first comment in the .ini file
#8276 Fixes for updateSiteSettingsXml.ps1
#7893 Don't overwrite op error with obsolete warning
KUNDEN-640 Include pytisapi in IF deployments
#8302 Exit if install python packages failed
#8312 Support e-mail settings in site settings.xml
#8269 Upd proj: Change template flag before all other updates
#8347 pytisapi: Add /sessions/resolveids api
#8336 avoid loading multiselect sublists during master submit
#8469 Prevent copying datanodes to template projects
#7821 Improve EdGrid cursor navigation
#7380 Fall back to number field editing in edgrid
#8401 Make sure to expand user folder before user folder filter
TIS6_6_0-40493
v6.6.0.3
dbupdate-2021-10-20-0705.sql
2021-11-08
SPX 22.3 Release
Patch
Tag
Database schema version
Release Date
Interflex Status
Description
TIS6_5_0-39729 (cumulative)
v6.5.0.10
2022-03-04
TIService is stopped, and execute provided install script patch.ps1 as administrator
IF-264 Detail logs regarding generate/verify manifest #8589 Adapt checking project type allowed #7864 Add cultureinfo if missing #8465 TISInstaller fixed and update database creates Standard roles/users as well #8600 Fix deep copy of OpDatanodeRefs md snapshot TIS6_5_0-39717 (cumulative)
v6.5.0.9
2022-02-15
Approved
TIService is stopped, and execute provided install script patch.ps1 as administrator
#7509 C#-Op: Keep DLL as file too (w/ CcxKeepTempFiles=True) #8582 Fix lifestyle issue with IModelValidation (Editor) #8553 Fix memory leak #8465 Carry over DBManager's script to create Standard roles/users/userroles for new DBs #8485 Enforce max dashboard tree node name length of 50 characters TIS6_5_0-39701 (cumulative)
v6.5.0.8
2022-02-01
TIService is stopped, and execute provided install script patch.ps1 as administrator
SPX - Shift Schedule: fixed "Blind not expected" error (IF-803036-69224) SPX - Shift Schedule: fixed time period filter
IF-210 Generic Calendar: display description text #8469 Prevent copying datanodes to template projects
#7821 Improve EdGrid cursor navigation
#7380 Fall back to number field editing in edgrid
#8401 Make sure to expand user folder before user folder filter
TIS6_5_0-39667 (cumulative)
v6.5.0.7
2021-12-07
Approved
TIService is stopped, and execute provided install script patch.ps1 as administrator
#8413 Fixed TISInstaller make config: adapt sites.xml #8403 Fixed User pool #7509 Improved Formula-Op: support custom temp dir #8297 OpPersistence: Replace xirp0032 with xirp_find_child_xpd #8406 MSSQL ximp0003: set low deadlock prio #8181 Improved performance xirp0021, add TemporaryPermissionsEnabled setting #8405 Remove patch del from xisp0012 #7853 Fixed TISInstaller cluster deployment: allow 20 instances for named pipe server TIS6_5_0-39636 (cumulative)
v6.5.0.6
2021-11-08
Approved
TIService is stopped, and execute provided install script patch.ps1 as administrator
#8267 Expand dashboard tree on login (if not configured otherwise) #8265 Userpool warm up: Don't require service restart in cluster #7963 Support detailed SQL logging #7329 OpUpdatePortletProperties: Fix update of multiple portlets with same name (XIRP0072) #7275 Show non-existing op with error and don't copy it #8199 Increase service startup timeout during startup actions #8224 Prevent exception during clean-up of unstarted tasks #8212 ORA: Delete orphaned XTables (of deleted TIS tables) #8188 Keep op disabled after upgrade #8185 Add missing GetBaseDataServices.asmx to TISBoardWebApp #8127 Make mLockObjects a concurrent dictionary #8128 Catch background scheduled thread exceptions #7658 ORA: Fix temp datafile when creating new db #8036 Improve error message delete tables #8041 Don't lose multiselect dirty state on user mode switch #7998 Use IDataNode.Update(CancellationToken) where possible and cancel early #8006 Upgrade SignalR-Version in TISBoard to 2.4.2 #8002 Improve pp version incr stored procedure #7993 Anon User Admin Portlet: Delete only 1 at a time to prevent deadlock #7977 Add Sql*Timeout settings #7920 Fix TIS table project references display #7954 SPX-Cluster deployment #7916 Catch generic ex during portlet meta data retrieval #7837 OpMergeTime aktualisiert bei Recalc den referenzierten Datenknoten nicht #7855 OpPersistenceRead entfernt default WHERE clause nicht bei Upgrade #7869 MSSQL - Anon User Admin Portlet: Trim userid of anon users query #7922 Error message if cannot find last_update from ORA DB #7909 OpFindAllIdentifier2: Preserve column settings #7908 Pass datadir to create_db script #7901 OPA: OpShiftGeneration2 (fixes & improvements) #7461 Log off subsessions when parent session logs off #7751 User pool Warm up improvements #7911 Keep sessions of queued/running tasks alive #7744 Py - sessionUrl: Fix for SSL envs #7885 Don't ping subsession on parent session op recalc #7875 TaskRunner: Bump on task completed #7879 Implement bulk delete for anonymous users #7876 TaskRunner: Only Dispose completed tasks TIS6_5_0-39434
v6.5.0.5
dbupdate-2021-05-05-0725.sql
2021-06-30
SPX 22.2 Release
Patch
Tag
Database schema version
Release Date
Interflex Status
Description
#8589 Adapt checking project type allowed #7326 Add SameSite=None; Secure to cookies in framed applications #8600 Fix unnecessary op meta data change #8582 Fix lifestyle issue with IModelValidation (Editor) #8553 Fix memory leak #8465 TISInstaller fixed and update database creates Standard roles/users as well #8485 Check max length on page name IF-210 Generic Calendar: display description text #8469 Prevent copying datanodes to template projects #7821 Improve EdGrid cursor navigation #7380 EdGrid: fall back to number field editing #8401 Dashboard: expand user folder before applying user folder filter #8267 Expand dashboard tree on login (if not configured otherwise) #7963 Support detailed SQL logging #7329 OpUpdatePortletProperties: Fix update of multiple portlets with same name (XIRP0072) #7275 Show non-existing op with error and don't copy it #8212 ORA: Delete orphaned XTables (of deleted TIS tables) #8188 Keep op disabled after upgrade #8185 Add missing GetBaseDataServices.asmx to TISBoardWebApp #8127 Make mLockObjects a concurrent dictionary #8128 Catch background scheduled thread exceptions #8036 Improve error message delete tables #8041 Don't lose multiselect dirty state on user mode switch #7998 Use IDataNode.Update(CancellationToken) where possible and cancel early #8006 Upgrade SignalR-Version in TISBoard to 2.4.2 #8002 Improve pp version incr stored procedure #7977 Add Sql*Timeout settings #7916 Catch generic ex during portlet meta data retrieval #7909 OpFindAllIdentifier2: Preserve column settings #7163 Fix missing OPA param MaximumNumberOfPersonsOnCallShifts #7461 Log off subsessions when parent session logs off #7911 Keep sessions of queued/running tasks alive #7885 Don't ping subsession on parent session op recalc #7875 TaskRunner: Bump on task completed #7881 Python op: Fix unnecessary timeout wait for regular script error #7879 Implement bulk delete for anonymous users (via admin portlet) IF-218 Support oping editor from SPX Web Client #7848 Support export of extra large TIS tables #7869 AnonUser admin portlet: Load users from db #7864 Add cultureinfo if missing #7843 Change user pool warm-up script to async #7840 OpTimeIntervals sortiert nicht nach Identifizierern #7739 Reduce transaction scope during page deployment (deadlock prevention) #7701 Pivot-Op: Sonderzeichen in Spaltennamen automatisch ersetzen #7170 Fix irregular timeout in python op #7751 User pool Warm up improvements #7737 Editor: Fix scrolling area of left panel when many projects open #7744 Py - sessionUrl: Fix for SSL envs #7762 Fix export with option "Only export result of base datanotes" #7733 Allow disable portlet info in editor (DisablePortletInfoInEditor setting) #7756 OpMultiplexer added Datanoderefs for non-active Datanodes #7749 Automatic upgrade for EditTable op #7747 Automatic upgrade for PersistenceRead op #7748 Automatic upgrade for ReadEditableGrid op #7639 Fix service crash on file guard solution error TIS6_4_1_35522 (cumulative)
v6.4.1.8
2021-05-31
Approved
TIService is stopped, and execute provided install script patch.ps1 as administrator,
#6904 Fixed race condition with parallel retrieving result tables #7501 Fixed TIS Editor data node result table update #7460 Update SignalR to version 2.4.2 #7695 Fixed Statistics-Op with null values #7673 Fixed potential NRE with XIH.SetParam #7669 Mitigate potential deadlocks with setting portlet properties during logon events #7646 Improved operators keep column selection in op settings if input table changes, improved error message:Select columns-Op Delete columns-Op Delete duplicate data records-Op #7578 Fixed Select data source-Op recalc behaviour #7673 Fixed String parameters trimming to max length (Oracle) #7636 Improved TISVersion information #7652 Improved Project import more logging #7650 Fixed ESS multiple tabs of TIS Board #7660 Fixed copy operator without recalculation then op settings lost #7647 Improved exception handling in project clone #7568 Improved patch.ps1 #7170 Fixed python-op timeout #7637 Fixed HTML portlet token url encoding #7387 Fixed TIS Board Delete deployed pages #7632 Fixed result table filtering, sorting #7460 Fixed missing globalConfig entries for SignalR #7560 Fixed EditTable-Op DataReader error (MSSQL) #7629 Fixed TISInstaller list of imported certificates #7500 Fixed AdminPortlet Logged on user for cluster deployment #7531 Improved TISBoard remove final "Finished" and proceed immediately #7578 Fixed Multiplexer-Op recalculate dirty data nodes #7542 Fixed SendEmail-Op error message #7559 Improved TISEditor add safety question for op upgrade action #7552 Fixed TISInstaller for Oracle TISDB update #7549 Fixed TISEditor role checking for user management #7507 Fixed TISEditor save related operator information #7521 Improved TISEditor highlight sorted columns in result table TIS6_4_1-35414
v6.4.1.7
2021-03-16
SPX 22.1 Release
TIS6_4_1-35388
v6.4.1.6
dbupdate-2021-03-03-0000.sql
SPX 22.1 Beta Version
21.3
Patch
Tag
Database schema version
Release Date
Interflex Status
Description
TIS6_3_0-34797 (cumulative)
v6.3.0.21
2023-06-21
TIService is stopped, and execute provided install script patch.ps1 as administrator.
IF-364 Fix license read problem on non-English OS TIS6_3_0-34795 (cumulative)
v6.3.0.20
2023-04-24
TIService is stopped, and execute provided install script patch.ps1 as administrator.
IF-330 Fix problem with "Sorting" op and OutOfMemoryException related to cc.License.dll TIS6_3_0-34789 (cumulative)
v6.3.0.19
2023-02-17
TIService is stopped, and execute provided install script patch.ps1 as administrator.
IF-330 Operators: Improve exception logging in case of failure (2) TIS6_3_0-34787 (cumulative)
v6.3.0.18
2023-01-26
TIService is stopped, and execute provided install script patch.ps1 as administrator.
IF-330 Operators: Improve exception logging in case of failure TIS6_3_0-34784 (cumulative)
v6.3.0.17
2022-05-25
TIService is stopped, and execute provided install script patch.ps1 as administrator.
IF-336 Fixed patch.ps1 with dependentAssemblyRedirect #8465 Fixed TISInstaller for updating TISDB on Oracle #8660 Fixed Add missing assembly redirect for Python-Op TIS6_3_0-34779 (cumulative)
v6.3.0.16
2022-03-21
TIService is stopped, and execute provided install script patch.ps1 as administrator.
#8660 Add missing assembly redirect for Python operator #8465 Fix path to db script TIS6_3_0-34751 (cumulative)
v6.3.0.15
dbupdate-2022-02-24-0000.sql
2022-03-03
#8589 Adapt checking project type allowed #7864 Add cultureinfo if missing #7326 Add SameSite=None; Secure to cookies in framed applications #8465 TISInstaller fixed and update database creates Standard roles/users as well #8600 Fix unnecessary op meta data change #8553 Fix memory leak #8485 Check max length on page name #8212 ORA: Delete orphaned XTables (of deleted TIS tables) #6992 Fixed ForceRecreatingAdminPortles flag #7739 Avoid deadlocks on MSSQL whilst page deployment TIS6_3_0-34725 (cumulative)
v6.3.0.14
2021-06-02
Approved
#7758 Fixed Stimulsoft localization #7650 Fixed Multiple tabs of TIS Board in ESS #7652 Improved Project import added more logging TIS6_3_0-34720 (cumulative)
v6.3.0.13
2021-05-04
#7575 Fixed Export for cross dbms projects #6803 Fixed Userpool role assignment update on logon #7629 Fixed TISInstaller list imported certificates #7647 Fixed Userpool project cloning without STANDARDUSER role #7660 Fixed copy datanode without immediate recalculation, lost operation settings TIS6_3_0-34711 (cumulative)
v6.3.0.12
2021-03-30
Approved
TIService is stopped, and execute provided install script patch.ps1 as administrator,
#7559 Improved Update-Op function confirm message #7507 Fixed Update-Op function lost op settings if not recalculated #7542 Fixed Send Email Op #7510 Fixed CVE-2021-26701 System.Text.Encodings.Web Vulnerability #7460 Fixed Editor lost SignalR connection due to Chrome update #6725 Fixed PortletPropertyRepository.Create: DBInsertMe failed #7273 Fixed Portlet error message if source data node has been deleted #7272 Fixed TIS Table write op: update mode with data type date/time #7126 Fixed Portlet keep layout on erroneous data node TIS6_3_0-34682 (cumulative)
v6.3.0.11
2021-02-02
Approved
#7204 Fixed TISInstaller database update from version 6.0 for MSSQL (datatype mismatch) #6225 Fixed Editor update operators #7218 Fixed Project import data node order #6499 Fixed Filter operator implicitly refer parameters restored #7283 Fixed Day and Week profile operator #7286 Fixed Editor parameter list tooltip #7318 Fixed TIS Board deploy pages on MSSQL #7321 Fixed Project cache race condition #7331 Fixed EdGrid formatting lost after software update #7281 Fixed Formula operator upgrade using parameters TIS6_3_0-34650 (cumulative)
v6.3.0.10
2020-12-17
#7232 Fixed Recalc-Op dependencies #7229 Fixed TIS Table references #7218 Fixed Import datanode ordering #7226 Fixed TISInstaller database create for MSSQL (ignorable error message) TIS6_3_0-34642 (cumulative)
v6.3.0.9
2020-12-15
#7227 Fixed TISInstaller database create for MSSQL (missing ps1 dependency) TIS6_3_0-34640 (cumulative)
v6.3.0.8
2020-12-11
#7204 Fixed TISInstaller database update for MSSQL (datatype mismatch) #6965 Fixed Allow export of pages in other user trees #7158 Fixed TIS Board handle orphaned subtree #7080 Fixed Export lost parameter reference in recalc op TIS6_3_0-34632
v6.3.0.7
2020-11-05
SPX 21.3 Release Candidate
#4501 Reverted Stimulsoft message on faulty data nodes #7102 Fixed TIS Table naming with Oracle #6878 Added XimesShiftsFast feature TIS6_3_0-34628
v6.3.0.6
2020-11-02
#6537 Fixed Stimulsoft Print #7065 Fixed French number formatting #7055 Fixed User Management error message #6754 Take Interflex build of formula operator cc.csharp TIS6_3_0-34615
v6.3.0.5
dbupdate-2020-08-31-0000.sql
2020-10-20
SPX 21.3 Beta Version
21.2
Patch
Tag
Database schema version
Release Date
Interflex Status
Description
TIS6_2_0-34023 (cumulative)
v6.2.0.19
dbupdate-2022-02-24-0000.sql
2022-03-03
#7864 Add cultureinfo if missing #7326 Add SameSite=None; Secure to cookies in framed applications #8465 TISInstaller fixed and update database creates Standard roles/users as well #8600 Fix unnecessary op meta data change #8553 Fix memory leak #8212 ORA: Delete orphaned XTables (of deleted TIS tables) TIS6_2_0-33999 (cumulative)
v6.2.0.17
2021-06-21
Approved
#7647 Fixed template project cloning #7650 Fixed Multiple tabs of TIS Board in ESS #6992 Fixed ForceRecreatingAdminPortles flag #7739 Avoid deadlocks on MSSQL whilst page deployment TIS6_2_0-33993 (cumulative)
v6.2.0.16
2021-04-01
Approved
#6803 Fixed user pool role update (e.g. ESS) #6685 Fixed Export/Import cross DBMS #7542 Fixed Send Email Op #7460 Fixed Editor lost SignalR connection due to Chrome update #7272 Fixed TIS Table write op: update mode with data type date/time #7331 Fixed EdGrid formatting lost after update TIS6_2_0-33979 (cumulative)
v6.2.0.15
2021-01-26
Approved
#7318 Fixed TIS Board deploy pages on MSSQL TIS6_2_0-33977 (cumulative)
v6.2.0.14
2021-01-20
#7286 Fixed Parameter for operations in old Editor #7218 Fixed Import datanode positions and flags for all projects in an import #7229 Fixed TIS Table read / EdGrid read operator table references TIS6_2_0-33971 (cumulative)
v6.2.0.13
2020-12-04
#6537 Fixed Stimulsoft designer update #7204 Fixed DBManager update for MSSQL #6965 Fixed Export of other user's TISBoard pages #7158 Fixed TISBoard ignore orphaned tree nodes #7080 Fixed Recalc-Op losing parameter references on export/import #6878 Added Generate-shifts-Op MINCOSTMAXFLOW algorithm
v6.2.0.12
2020-11-20
#6537 Fixed Stimulsoft portlet print function #6782 Fixed SPX Picker portlet by incorporating config adaptions into setup TIS6_2_0-33953 (cumulative)
v6.2.0.11
2020-10-15
#7035 Fixed Stimulsoft Report portlet always use StimulsoftReportViewerUrl setting #7013 Fixed SimpleGrid portlet recovers after data source failure #6934 Fixed Legacy user controls with http proxy use TIS6_2_0-33946 (cumulative)
v6.2.0.10
2020-09-22
#6588 Fixed Project activation #6908 Fixed Task Manager race condition #6913 Fixed Project repository deadlock #6914 Fixed Project clone deletion #6792 Fixed potential database deadlock causing ZombieCheck #6944 Fixed EdGrid generate Op #6970 Fixed Dashboard house keeping with anonymous users #6623 Fixed EdGrid portlet keep column formatting #6969 Fixed potential deadlock on parallel page deploy with MSSQL #6958 Fixed vanishing portlets TIS6_2_0-33921 (cumulative)
v6.2.0.9
2020-08-04
#6815 Fixed Send Email Op memory leak #6769 Fixed Editor data node's parent removal and display #6432 Fixed Editor data node's parent selection #6780 Fixed Excel download integer formatting #6727 Fixed Application of temporary certificates #4318 Fixed EdGrid column formatting #6634 Fixed verbose logging TIS6_2_0-33898
v6.2.0.8
2020-06-29
SPX 21.2 Release Version
TIS6_2_0-33889
v6.2.0.7
2020-06-17
#5847 Fixed Delete project with dependencies caused orphaned dashboard pages #6506 Improved Upload portlet resets file selection after upload due to security requirements #5950 Improved EdGrid with time data type TIS6_2_0-33834
v6.2.0.6
dbupdate-2020-04-28-0000.sql
2020-05-05
#6517 Fixed TIS Board Logon event triggering in shared dashboard tree #6505 Fixed TIS Board portlet property disable print icon #6480 Fixed DBManager missing dashboard tree user folder for SUPERUSER TIS6_2_0_33828
v6.2.0.5
2020-04-24
#6502 Fixed Oracle update script TIS6_2_0_33826
v6.2.0.4
dbupdate-2020-04-22-0000.sql
2020-04-23
#6265 Fixed WebApp's web.config #6264 Removed obsolet TIService/IR folder #6479 Delete reports include empty parent folders in files and tables TIS6_2_0-33814
v6.2.0.3
2020-04-22
#6483 Fixed TIS Board keep user folder hidden after import #6481 Fixed Import auto-select own user folder #6480 Create dashboard folder for SUPERUSER #6402 Fixed DBManager set TIS Version to 6.2 #6478 Fixed config files #5973 Fixed Python scripting operator input timeout #6418 Fixed delete user include dashboard folder #6203 Improved Import for large datasets TIS6_2_0-33785
v6.2.0.2
2020-04-06
SPX 21.2 Preview Version
20.3 or 21.1 with updated database schema
dbupdate-2020-02-20-0000.sql), after that it can be updated with TISInstaller to a higher version.
Patch
Tag
Database schema version
Release Date
Description
TIS6_0_3-31448 (cumulative)
v6.0.3.6
2020-08-26
#6792 Fixed potential deadlock and broken db connection #5428 Fixed project locks on TIService startup TIS6_0_3-31442 (cumulative)
v6.0.3.5
2020-06-16
#6638 Fixed potential deadlock with drop table #6618 Fixed potential deadlock with ReplaceAllRows mode #6417 Feature StimulsoftReportViewerRequestTimeOut setting TIS6_0_3-31435 (cumulative)
v6.0.3.4
2020-03-11
#6427 Fixed database connection disposing with pooling TIS6_0_3-31434 (cumulative)
v6.0.3.3
2020-03-05
#6170 Fixed some SQL syntax TIS6_0_3-31432 (cumulative)
v6.0.3.1
2020-02-28
#6348 Fixed potential deadlock in GetProjectTree and UpdateProject TIS6_0_3-31429 (cumulative)
v6.0.3.1
dbupdate-2020-02-20-0000.sql
2020-02-26
#6170 Fixed Transaction problems with concurrent database queries
20.3 or 21.1
Patch
Tag
Database schema version
Release Date
Description
TIS6_0_2-31431 (cumulative)
v6.0.2.10
2020-03-09
#6417 Feature StimulsoftReportViewerRequestTimeOut setting TIS6_0_2-31408 (cumulative)
v6.0.2.9
2020-01-29
#6195 Fixed TIS file and table tree permissions TIS6_0_2-31407 (cumulative)
v6.0.2.8
2020-01-23
#6179 Improved Delete TIS Board page more fault tolerant #5842 Fixed XimesCertificate avoid low key size: "The RSA Public-Key size 1024 is not valid” TIS6_0_2-31402 (cumulative)
v6.0.2.7
2020-01-17
#6159 Fixed Import Standard-Reports NotTimeValid error #6169 Fixed Usersnap Integration TIS6_0_2-31400
v6.0.2.5
2019-12-10
#6002 Fixed CSV-Import with UCS-2 LE BOM encoding #6008 Fixed Send E-Mail-Op with TIS file attachment #6004 Fixed ESS integration with cross-domain #5910 Fixed Zendesk-Op accept TLS 1.2 #5977 Fixed Recalc with input table-Op (parameter references) #5975 Fixed SQL-Import 5.0 operator for Oracle #5983 Fixed SQL-Import 3.1 operator for Oracle #5976 Fixed Export Resources avoid caching by filename with timestamp #5967 Fixed Project import: parameter references in controller portletsProject must be re-imported to fix the problem #5814 Fixed Delete solution in TIS Board with clones of template project #5591 Fixed usersnap integration #5621 Fixed Delete data nodes with circular references #5850 Fixed Python-Op cancellation TIS6_0_2-31348
v6.0.2.4
2019-10-04
SPX 20.3 Release Version
#5787 Fixed Project export with missing resources #4635 Fixed Project export with project names containing a priod "." #5758 Fixed Parameter assignment in Recalc-Op after import TIS6_0_2-31339
v6.0.2.3
2019-09-30
#5677 Improved error message for invalid project import #5783 Fixed Column references for Operators with GenTable #5758 Fixed Parameter assignment in Recalc-Op after import #5769 Fixed Python Scripting-Op column caption escaping #5730 Fixed Log level for missing resources to WARNING #5659 Fixed Python Scipting-Op (handling large data sets) TIS6_0_2-31323
v6.0.2.2
dbupdate-2019-08-09-0000.sql
2019-09-05
SPX 20.3 Beta Version
#5590 Improved EdGrid performance #5580 Feature HTML portlet reloads after controller save #4631 Feature HTML portlet get data node #5515 Feature Read TIS table 7.1-Op #5464 Feature Column range references with "B1" notation (relative column references) #5493 Feature Resolve Pivot Table 4.0-Op (keep relative column references) #4967 Feature EdGrid: Auto-Save with controller / tile portlet sends other #5563 Feature Changed initial password for TISAdmin (stand-alone deployment) #5583 Fixed Python Scripting-Op sometimes one row too many #4462 Fixed Redis handling on time-outs #5364 Fixed Redis handling on Redis restarts #5550 Fixed Delete projects with dependencies in multiple clients context #5323 Fixed Delete pages with dependencies #5164 Fixed Column reference by name with dash in name #5438 Fixed Read TIS Table-Op with using Parameters in WHERE-clause #5476 Fixed Float formatting in English #5377 Fixed XIH.GetParam with empty string or NULL (Oracle) #5394 Fixed Controller Portlet for relative date used with Internet Explorer (IE)
20.2
Patch
Tag
Database schema version
Release Date
Description
TIS6_0_0-31278 (cumulative)
v6.0.0.19
2020-03-19
#6417 Feature StimulsoftReportViewerRequestTimeOut setting TIS6_0_0-31277 (cumulative)
v6.0.0.18
2020-01-22
#5842 Fixed XimesCertificate avoid low key sizeError code 62 ("The RSA Public-Key size 1024 is not valid") when uploading CSR or installing certificatePlease note that the folder DBManager included in the patch must be copied manually to the corresponding parent folder. #6159 Fixed Import Standard-Reports NotTimeValid error #6169 Fixed Usersnap Integration TIS6_0_0-31272 (cumulative)
v6.0.0.17
2019-12-12
#5967 Fixed Project import: parameter references in controller portletsProject must be re-imported to fix the problem #5977 Fixed Recalc with input table-Op (parameter references) TIS6_0_0-31262 (cumulative)
v6.0.0.16
2019-12-09
#6008 Fixed Send E-Mail-Op with TIS file attachment #6004 Fixed ESS integration with cross-domain TIS6_0_0-31259 (cumulative)
v6.0.0.15
2019-11-21
#5975 Fixed SQL-Import 5.0 operator for Oracle TIS6_0_0-31256 (cumulative)
v6.0.0.14
2019-10-04
#5787 Fixed Project export with missing resources #4635 Fixed Project export with project names containing a priod "." #5783 Fixed Column references for Operators with GenTable #5758 Fixed Parameter assignment in Recalc-Op after import TIS6_0_0-31247 (cumulative)
v6.0.0.13
2019-08-12
#5431 Fixed ping method for legacy user controls #5170 Fixed session management with ESS logon #5445 Fixed export with duplicate resource keys #5385 Fixed project cache #5449 Fixed data node dirty on parameter #2838 Fixed project import for long names #5524 Fixed TIS table write op performance issue #5562 Fixed project validity check TIS6_0_0-31235
v6.0.0.12
dbupdate-2019-03-20-0000.sql
2019-07-15
SPX 20.2 Release Version
Security-Patches "Cumulative Update for .NET Framework" KB4565633 (Windows 10) resp. KB4565912 , KB4565511 (Windows Server 2016) or others cause problems with TIS, in particular with SPX base data picker portlet. It fixes critical security problems with ASP.NET and should not be deinstalled.
TIService\bin\TIServiceWindowsService.exe.configWebApp\web.configTISBoard\web.config
<?xml version="1.0" encoding="utf-8"?><configuration> <configSections>
<!-- .... -->
<sectionGroup name="system.data.dataset.serialization" type="System.Data.SerializationSettingsSectionGroup, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <section name="allowedTypes" type="System.Data.AllowedTypesSectionHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> </sectionGroup> </configSections> <system.data.dataset.serialization> <allowedTypes> <!-- <add type="assembly qualified type name" /> --> <add type="cc.Controls.BaseDataAutoCompleteExtender+ValueInfo, cc.Controls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=50ada2d2f8dc09b9" /> <!-- additional <add /> elements as needed --> </allowedTypes> </system.data.dataset.serialization>
<!-- .... -->
</configuration>
Software Patches
TISInstaller Settings
Please check SP-EXPERT Compatibility.
#8734 Known bug with Project-Import with "use existing resources and portlets" option on Oracle