The solution runner does jobs in the background defined by a script.

  • Pure calculations in memory without intermediate results
  • Managing large numbers of users

Admin portlet for cache update

(warning) Note that changed to LogonScript etc. are not active if older version is already loaded to cache. To clean up use following admin portlet:

Setup Solution Runner

Step

Description

Screenshots

1

TIService configuration

  • ProcessMasterSolutionName = "AdminScripts"
  • SolutionRunnerExtendedLog = true/false


2

TIS Table for scripts

  • TIS\$SysTables\AdminScripts

Usage

Usage

Description

Screenshots

Event

Refer to a script in event definition

Data source

Use solution runner as a data source for a portlet

(warning) Note syntax {BP:}<scriptname>{:EP}

(warning) Note that the portlet has to be saved before a solution runner can be specified.

Cron job



Solution Runner Script

Column

Data type

Description


Tabletype

string

unique name of a script


Solution

string

project name

(warning) Note only one project per Tabletype is allowed


B/D

integer

per solution unique integer

(question)

Datanode

string

data node name


NewParent

string



ConnString

string



Select/Values

string



Where/Keys

string



OrderBy

string



Action

string

action identifier see list below


Targettable

string



Order

integer

unique order number per script


Comment

string



Solution Runner Actions

The solution runner can change references, parameter values, recalc ...

Id

Class

Status

Description

 
SQL



Statement fuer SQL-Operator zusammenbauen

 
ClearActionTable



clear solutionrunner-table (cache). AdminScripts is loaded once into a cache. ClearActionTable is necessary if script has changed.

 
SetLongRunning



indicates that this solution runner should continue even if the starting user logges off

 
Parent


(tick)

Elternknoten umhaengen fuer Datenknoten

 
DB_Update



Update fuer Datenknoten aufrufen Werte ersetzen

 
DB_UpdateAdd



Update fuer Datenknoten aufrufen Werte addieren

 
DB_Del



Delete CUD aufrufen

 
TISSolution



TIS Solution oeffnen/holen und durchrechnen

 
Gentable



Resulttable des Knotens setzen

 
ClearResults



Ergebnistabellen disposen

 
BreakNoData


(tick)

Solutionrunner abbrechnen wenn keine Daten vorhanden

 
NoDataGoto


(tick)

Solutionrunner abbrechnen und wohin springen

 
GoTo


(tick)

Wohin springen

 
GotoTag


(tick)

Einspringpunkt

 
PRead



Peristenztabelle lesen Einstellungen Operator

 
Recalculate


(tick)

Datenknoten neu rechnen

 
RecalcReport


(tick)

Datenknoten neu rechnen inkl. Klonen Resulttabelle

SolutionRunner as data source of a portlet, there must be this action as final step.

 
SetParam


(tick)

Sets the value of a TIS Parameter.

Note: affected data nodes are not set dirty (warning)

  • Datanode: Parameter name
  • Targettable: Parameter value
 
SetTimezone



Parameter

 
ParamRecalc


(error)

Controller Portlet (MetaData)

 
AddScript


(tick)

Add Script as a subroutine, identified by another TableType.

  • Datanode: #XI.Add
  • Targettable: TableType of sub-routine
 
ErrorInfoCollect
 




ErrorInfoDBClear
 




ErrorInfoDBWrite



Writes to IQMetrixErrorCodeRecord (t6003).

 
RecalcTISChart


(tick)

Datenknoten neu rechnen inkl. TISChartInfo

 
RecalcEJSChart


(tick)

Datenknoten neu rechnen inkl. EJSChartInfo

 
DB_RangeDel



Löschen mittels DELETE Statement

 
OpInstruction

FileGuard


Führt eine OpInstruktion auf der Operation aus.

 
SetImportFileName

FileGuard


  • Targettable: 0 (position in string)
 
SetExportFileName

FileGuard

 



DeleteFileName

FileGuard


Delete a TIS File.

 
SetLocalParam



Sets a local parameter to a specified (constant) value

 
CheckAccessTISTable



See also LogOnScripts for custom login

Checks if accountname and password match to entries in a tistable

  • #XI.AccountId contains what was store in cookie "custlogin_user"
  • #XI.Pwd contains what was stored in cookie "custlogin_pass"

 
StopIf



Stops if the value of a local parameter equals some constant

case insensitive

 
Condition



Assigns a local parameter depending on a condition

Tests the specified parameter (Datanode) case-sensitive equals constant value (TableTarget). If equals then the specified target parameter (NewParent) is set to ifTrue-value (ConnString) otherwise ifFalse-value (Select).

  • Datanode: test parameter
  • NewParent: target parameter
  • ConnString: ifTrue value
  • Select/Values: ifFalse value
  • Targettable: condition string


 
LogOnAsAnonymousUser

Logon


Gets a anonymous user and performs a logOn

 
GetAnonymousUser



Gets a anonymous user

 
LogOn

Logon


performs a logOn

 
CopyPages



Deploys all pages of a user to another user

 
SyncPages



Synchronizes the pages of an user with an source user: Deploys all pages of the source user and removes all pages of the target user that are not from the source user

 
RecalcNode


(question)

Recalculates a data node

 
SPX_VALIDATE_OTT
 




SpxEmployeeLogOn

Logon

(tick)

TaskFLEX-776 - SPX-Employee-Logon Closed

Im Logon-Script

 
LogOnParams_Convert_PageId