The CreatorCon Call for Content is officially open! Get started here.

ServiceNow Learning 50: Few more Useful Flow Designer backend Tables in ServiceNow

Shamma Negi
Kilo Sage
Kilo Sage

Hi Team,

 

I found few more helpful Flow Tables as mentioned below:

 

 

TableDescriptionDefault retention period
sys_flow_contextParent table that stores all Flow Designer context records and their associated process plans. Context records store the state and references to the data used to run a flow or action. See the child tables for context records in specific states.
  • 2 weeks for completed flows
  • 6 weeks for flows in the error or cancelled state
sys_flow_context_chunkChild table that stores context records and runtime data for currently running flows and actions. This table replaces the sys_json_chunk table as the location to store data for active context records. A running flow or action can be in one of these states.
  • Continue Sync
  • In Progress
  • Queued
  • Waiting
Danger: Do not change or delete data in this table. Flow Designer uses this table for flows and actions that are in an active state.
The system removes these records when the flow stops running and creates an entry in the sys_flow_context_chunk_archive table.
sys_flow_context_chunk_archiveChild table that stores context records and runtime data for flows and actions that have stopped running. This table replaces the sys_json_chunk table as the location to store data for inactive context records. A stopped flow or action can be in one of these states.
  • Cancelled
  • Complete
  • Error
Note: Flow Designer uses this table for flows and actions that are in an inactive state.
Removed when the associated sys_flow_context record is removed.
  • 2 weeks for completed flows
  • 6 weeks for flows in the error or cancelled state

 

 

Hope this helps you.

I hope this article helpful. Please mark it as helpful and bookmark if you like it.

 

Thanks,

Shamma

Regards,Shamma Negi
0 REPLIES 0