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