Solved

informatica failed tasks version , other repository queries

Posted on 2013-02-07
1
522 Views
Last Modified: 2013-02-25
Hi I need to find informatica failed tasks version , other handy repository queries welcome too
0
Comment
Question by:oleggold
1 Comment
 
LVL 4

Accepted Solution

by:
subratabiswas earned 500 total points
ID: 38865974
Hi,

Can you please clarify on the question? If you want to find the relevant information from the Informatica repository by using SQL statements, then please look at the table OPB_TASK_INST_RUN. Various values of RUN_STATUS_CODE in that table are as follows:

1 = Suceeded
2 = Disabled
3 = Failed
4 = Stopped
5 = Aborted
6 = Running
7 = Suspending
8 = Suspended
9 = Stopping
10 = Aborting
11 = Waiting
12 = Scheduled
13 = Unscheduled
14 = Unknown
15 = Terminated


The table contains version number also.

If you wanted something else, please let me know.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question