Skip Headers

Oracle® Health Sciences Pharmacovigilance Operational Analytics User and Administrator Guide Release 1.0 E23554-01 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| PDF · Mobi · ePub

# C Troubleshooting

This appendix contains troubleshooting tips in handling the following scenarios:

- Verify whether the DAC client is able to use Informatica commands

- Unable to run Informatica Workflow from DAC

- Aborting a Workflow

- Unable to Sign In to OPVA

## C.1 Verify whether the DAC client is able to use Informatica commands

Perform these steps to ensure whether the DAC client is able to use the Informatica commands properly:

1. From the machine where the DAC client is installed, open a windows command prompt.

2. Execute pmrep and pmcmd.

3. If the above steps work without any errors, it means that the DAC client can invoke Informatica commands properly.

What If Informatica commands are not recognized?

Perform the following steps if Informatica commands are not recognized:

1. Verify that the INFA_DOMAINS_FILE variable points to the domains.infa file located in the Informatica directory (such as D:\Informatica\9.0.1\clients\PowerCenterClient\domains.infa).

2. Verify that the PATH variable includes the path to the Informatica binaries (such as D:\Informatica\9.0.1\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin), and that pmrep.exe and pmcmd.exe exist in the \bin folder.

3. Ensure that Hotfix2 has been applied to Informatica PowerCenter 9.0.1.

## C.2 Unable to run Informatica Workflow from DAC

Make sure that the user provided to run Informatica mapping has 'Execute' permission on the mapping in the respective folder.

Steps to check whether the User has 'Execute' permission:

Perform the following steps to check if the user has 'Execute' permissions:

1. Log in to the Informatica Administrator's Console as the user whose permission credentials are to be checked.

2. Go to the Security tab and select the Users box, on the left side of the window.

3. Click the Domains, on the right side of to check the permission level assigned to the user.

## C.3 Aborting a Workflow

A workflow can be aborted by the following two methods:

Method 1

Perform the following steps in DAC to abort a workflow:

1. Navigate to Execute > Execution Plan sub tab.

2. Click the Execution Plan you want to abort.

3. Click Abort.

Method 2

Perform the following steps in Informatica PowerCenter to abort a workflow:

1. Open the Informatica PowerCenter Workflow Monitor.

2. In the Repositories tree, navigate to the particular folder that contains the Informatica job.

3. In the Workflow Run pane, select and right-click the workflow, and click Abort.

Method 3

A task/workflow can also be aborted through the Informatica commandline options. Execute the following Informatica commands to abort a workflow:

Informatica command to stop a task:

pmcmd aborttask -s $server_name -u $user_name -p $pass -f $folder -w $wkf $sess

Informatica command to stop a workflow:

pmcmd abortworkflow -s $server_name -u $user_name -p $pass -f $folder $wkf

See Also:

Informatica PowerCenter Online Help

## C.4 Unable to Sign In to OPVA

You might be unable to sign in to OPVA in either of the following scenarios:

- The Login page displays an Internal Server Error message.

- You are logged in but while working on something, you might encounter an error and could get logged out.

In such scenarios, try executing the following steps:

- You can log in to the Console to check the BI Server status.

- You can also log in to the Enterprise Manager and check the status of all the OBIEE components. Enter the \oracle\fmw\instances\instance1\bin> opmnctl status command to view the status of each component in OBIEE.