3 Replies Latest reply on Feb 20, 2020 5:21 AM by Pandiarajan B

How to fetch tasks faulted on Active VOS server from the back end database tables

Mohammed Asim Feb 14, 2020 2:39 AM

Hi There,

We have a requirement to fetch the faulted task details every 15 minutes and send out an email notification to the team with faulted task details. Do we have a sql query available to fetch the faulted task details?

Thanks,

Asim

1. Re: How to fetch tasks faulted on Active VOS server from the back end database tables

kunal pandit Feb 14, 2020 10:52 AM (in response to Mohammed Asim)

Here is a helpful link - ActiveVOS Database Table Descriptions
Like Show 0 Likes(0)

Actions
2. Re: How to fetch tasks faulted on Active VOS server from the back end database tables

Shriharsha Manjunath Feb 18, 2020 10:47 PM (in response to Mohammed Asim)

Please refer the KB article #527410
Like Show 0 Likes(0)

Actions
3. Re: How to fetch tasks faulted on Active VOS server from the back end database tables

Pandiarajan B Feb 20, 2020 5:21 AM (in response to Mohammed Asim)

Please check AeProcess table, 4 is the values for Faulted Tasks.

AeProcess States
State Value
Running 1
Suspended 2
Completed 3
Faulted 4
Compensatable 5
Like Show 0 Likes(0)

Actions

State	Value
Running	1
Suspended	2
Completed	3
Faulted	4
Compensatable	5

Go to original post

Legend

Correct Answers - 4 points

Signing in to Informatica Network

How to fetch tasks faulted on Active VOS server from the back end database tables

1. Re: How to fetch tasks faulted on Active VOS server from the back end database tables

2. Re: How to fetch tasks faulted on Active VOS server from the back end database tables

3. Re: How to fetch tasks faulted on Active VOS server from the back end database tables

AeProcess States

Actions

More Like This

Legend