Export workflow to xml.
and use text tool to search 'FAIL_PARENT_IF_INSTANCE_FAILS', if '="YES"' follows it, this means you check this optjion. otherwise, you can search nearest '<session' upward to get session name.
You could query the repository database directly:
SELECT * FROM OPB_TASK_INST WHERE TO_NUMBER(BITAND(BIT_OPTIONS,16))=0 AND TASK_TYPE = 62;
Note that it's generally not a good idea to query the internal tables directly, but I don't see any other way to get the information you are asking for. Anyway, pay attention...
Thanks for your solution. It's good to know that TO_NUMBER(BITAND(BIT_OPTIONS,16))=0 indicates unchecked "Fail parent if this task fails". Just need to point out one thing: sessions have TASK_TYPE = 68
Hope the below query answers your question....
OPB_REPOSIT_INFO.REPOSITORY_NAME AS REPOSITORY,
OPB_SUBJECT.SUBJ_NAME AS FOLDER_NAME,
OPB_TASK.TASK_NAME AS WORKFLOW_OR_WORKLET,
DECODE(OPB_TASK_INST.TASK_TYPE,58,'COMMAND',59,'DECISION',60,'EVENT WAIT',62,'START',65,'EMAIL',66,'TIMER',67,'ASSIGNMENT',68,'SESSION',70,'WORKLET',91,'CONTROL',NULL) TASK_TYPE,
OPB_TASK_INST.INSTANCE_NAME AS WORKLET_OR_SESSION,
DECODE (BITAND (OPB_TASK_INST.BIT_OPTIONS, 17),17,'SELECTED','NOT SELECTED') AS FAIL_PARENT_IF_TASK_FAILS
WHERE OPB_TASK_INST.TASK_TYPE != 62
AND OPB_TASK_INST.TASK_TYPE = OPB_OBJECT_TYPE.OBJECT_TYPE_ID
AND OPB_TASK_INST.WORKFLOW_ID = OPB_TASK.TASK_ID
AND OPB_TASK_INST.VERSION_NUMBER = OPB_TASK.VERSION_NUMBER
AND OPB_TASK.SUBJECT_ID = OPB_SUBJECT.SUBJ_ID
AND OPB_TASK.UTC_CHECKIN <> 0
--AND OPB_SUBJECT.SUBJ_NAME NOT LIKE 'WA%'
WHERE FAIL_PARENT_IF_TASK_FAILS <> 'SELECTED'
OPB_TASK_INST view/table I am not able to check in my respository database. I am using 10.2 version.
Please advise in which alternate table/view I can find this information"fail parent if this task fails".
OPB_TASK_INST exists in 10.2.
Please, double check you are checking the correct schema for the repository in database.
Thanks for responding. I checked in the all_tables,all_objects and all_views in the informatica database, not able to check this object OPB_TASK_INST. I think we have to reach out to the informatica admin team for this. Please advise.
No idea which user ID you use to connect to the repository DB, but this table must exist, otherwise not a single task could be run in PowerCenter. This is one of the most vital tables holding runtime information in the PowerCenter repository DB, it must be there.
Are you sure you are connecting to the correct repository DB? And within the repository DB to the correct user schema?
And does the user ID you're using have the necessary privileges to read all the schema contents? Maybe for whatever reason this user ID is lacking SELECT permission on that particular table?