Navigation: Workflow >

System activity with error

Overview

This command will list all workflows with a system activity with error in the execution.

Related tables

Table	Description	Primary key (PK)	Connection tables
WFPROCESS	Table that stores instances	PKWFPROCESS	WFSTRUCT
WFSTRUCT	Workflow flowchart item table	PKWFSTRUCT	WFPROCESS

Oracle/Postgres/SQL Server

SELECT
   WFP.IDPROCESS AS Identificador
FROM
   WFPROCESS WFP
WHERE
     EXISTS (
   SELECT
     NULL
   FROM
   WFSTRUCT WFS
   WHERE
   WFS.IDPROCESS = WFP.IDOBJECT
     AND WFS.FGEXECERROR = 1
)

Fields used on the view screen

#	Field ID	Type	Description
1	IDPROCESS	VARCHAR(50)	Fields of the WFPROCESS pivot table
2	FGEXECERROR	NUMERIC(2)	Fields of the WFSTRUCT pivot table