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
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
|
|
2 |
TIS Table for scripts
|
|
Usage
Usage |
Description |
Screenshots |
---|---|---|
Event |
Refer to a script in event definition |
|
Data source |
Use solution runner as a data source for a portlet Note syntax 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 Note only one project per Tabletype is allowed |
|
B/D |
integer |
per solution unique integer |
|
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 |
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 |
Solutionrunner abbrechnen wenn keine Daten vorhanden |
||
NoDataGoto |
Solutionrunner abbrechnen und wohin springen
|
||
GoTo |
Wohin springen |
||
GotoTag |
Einspringpunkt |
||
PRead |
Peristenztabelle lesen Einstellungen Operator |
||
Recalculate |
Datenknoten neu rechnen |
||
RecalcReport |
Datenknoten neu rechnen inkl. Klonen Resulttabelle SolutionRunner as data source of a portlet, there must be this action as final step. |
||
SetParam |
Sets the value of a TIS Parameter. Note: affected data nodes are not set dirty
|
||
SetTimezone |
Parameter |
||
ParamRecalc |
Controller Portlet (MetaData) |
||
AddScript |
Add Script as a subroutine, identified by another TableType.
|
||
ErrorInfoCollect |
|||
ErrorInfoDBClear |
|||
ErrorInfoDBWrite |
Writes to |
||
RecalcTISChart |
Datenknoten neu rechnen inkl. TISChartInfo |
||
RecalcEJSChart |
Datenknoten neu rechnen inkl. EJSChartInfo |
||
DB_RangeDel |
Löschen mittels DELETE Statement |
||
OpInstruction |
FileGuard |
Führt eine OpInstruktion auf der Operation aus. |
|
SetImportFileName |
FileGuard |
|
|
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
|
||
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).
|
||
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 |
Recalculates a data node |
||
SPX_VALIDATE_OTT |
|||
SpxEmployeeLogOn |
Logon |
FLEX-776 - SPX-Employee-Logon Closed Im Logon-Script |
|
LogOnParams_Convert_PageId |