iProcess Objects Server returns -2 SAL System Error
book
Article ID: KB0080000
calendar_today
Updated On:
Products
Versions
TIBCO iProcess Engine (Oracle)
11.6(0.0)
Description
Issue: ====== iProcess Objects Server returns SAL System Error whenever a queue is accessed and the swentobjsv01.log shows the following type of error:
04908|00298|11/08/2018 16:21:31.290|00010000|ERROR|error in salq_list_open (-2) 04908|00298|11/08/2018 16:21:31.290|00010000|ERROR|get_wqs_session() returned an error, qlistsh = 0, err=-2 04908|00298|11/08/2018 16:21:31.290|00010000|ERROR|qquery_win_setup() returned an error, queuename = MYQUEUE@MYNODE, rc = -2 04908|00298|11/08/2018 16:21:31.306|00010000|ERROR|process_transaction() failed, rc=-2, Message Code(QQW)
Environment: ============ TIBCO iProcess Objects Server Version: i11.6(0.0) TIBCO iProcess Engine Version: i11.6-o(0.2) OS: Windows or UNIX
Cause: ====== Reviewing the DEBUG from the WIS (with swadm set_attribute 0 WIS 0 DEBUG ALL=255,MAXSIZE=50000000,ONFULL=SAVE enabled) may show that case fields are being included in the filter string used when the work queue is requested by the client application:
[T=01398]181114155140.095999:T064: wis_filter_init(): parsing 'SEGMENT="THISVALUE" AND DATE_IN=!01/08/2016! AND DATE_OT=!01/08/2017!' [T=01398]181114155140.096205:E004: ==>sal_expression_parse() [T=01398]181114155140.096501:E004: sal_expression_parse(): parsing 'SEGMENT="THISVALUE" AND DATE_IN=!01/08/2016! AND DATE_OT=!01/08/2017!' [T=01398]181114155140.096818:E004: => lsal_exp_schk(SEGMENT="THISVALUE" AND DATE_IN=!01/08/2016! AND DATE_OT=!01/08/2017!) [T=01398]181114155140.097096:E004: <= lsal_exp_schk() - ret = -1 [T=01398]181114155140.097310:E001: sal_expression_parse(): lsal_exp_schk() failed for 'SEGMENT="THISVALUE" AND DATE_IN=!01/08/2016! AND DATE_OT=!01/08/2017!' [T=01398]181114155140.097517:E004: <==sal_expression_parse() [T=01398]181114155140.097726:T001: wis_filter_init(): sal_expression_parse() failed: -2
The fields shown above in the filter string (taken from the wis01.log file) show that SEGMENT, DATE_IN and DATE_OT are expected to be found in the list of Case Data Queue Parameters (CDQP) for the work queue. The WIS cannot parse the expression as the case fields used are not defined as CDQPs and therefore the error -2 is returned.
Issue/Introduction
The iProcess Objects Server can return a -2 SAL System Error when a queue is accessed
Environment
TIBCO iProcess Objects Server Version: i11.6(0.0)
TIBCO iProcess Engine Version: i11.6-o(0.2)
OS: Windows or UNIX
Resolution
The solution to the problem is to either remove the fields from the default filter applied by the application or to create the missing fields as CDQP fields for the work queue.