A Troubleshooting DAC

This appendix contains troubleshooting topics for the Data Warehouse Administration Console (DAC).

It contains the following topics:

• Handling Parameter Files with Multi-Line Parameters

• Restoring the DAC Repository on Unicode Oracle Databases

Handling Parameter Files with Multi-Line Parameters

Informatica workflows initiated by DAC fail with error code 17 and the error message "Parameter file does not exist" when the parameter file has multi-line parameters. See the below text for an example. Note that in the following example, an error occurs because DAC issues pmcmd with -lpf in the syntax.

$$SYND_DS_PARTITION_TRUNCATE_SQL_TEXT=SELECT 
LTRIM(MAX(SYS_CONNECT_BY_PATH('execute immediate ''ALTER TABLE 
getTableName() TRUNCATE PARTITION ' || '"' ||COUNTRY_REGION_NAME|| '"' ||'''' 
 
,';')) KEEP (DENSE_RANK LAST ORDER BY curr),';') AS SQL_TXTFROM 
(SELECT SOURCE,COUNTRY_REGION_NAME,ROW_NUMBER() OVER (PARTITION BY SOURCE 
 ORDER BY COUNTRY_REGION_NAME) AS curr, ROW_NUMBER() OVER (PARTITION BY SOURCE 
 
ORDER BY COUNTRY_REGION_NAME) -1 AS prev FROM W_SYND_PARTITION_TMP 
 
WHERE SOURCE='W_SYNDD_DS_FS') 
CONNECT BY prev = PRIOR curr START WITH curr = 1 

To prevent this issue, edit <DAC_Config_Location>\conf-shared\infa_command.xml and replace all instances of <-lpf> with <-paramfile>.

This workaround will ensure that DAC uses -paramfile in the pmcmd syntax and Informatica can recognize the multi-line parameters.

Restoring the DAC Repository on Unicode Oracle Databases

When the DAC repository resides on a non-Unicode Oracle database, the Informatica workflow names may not fit into the corresponding DAC fields, which causes tasks to fail during ETL processes.

To work properly in multi-byte character environments, the DAC repository should be created with the Unicode option selected.

Perform the following procedure to fix an existing DAC repository with this problem. You can use the DAC Client or DAC command line parameters to perform the procedure.

1. Connect to the existing DAC repository.

2. Export the entire repository (logical, system, and run time categories).

3. Stop the DAC Server and all DAC Clients except for the one you are using.

4. Drop the current repository.

5. If you are using a DAC Client, restart it.

6. Create a new repository with the Unicode option selected.

7. Import the DAC metadata that you exported in step 2.

8. Re-enter the passwords for all Informatica services and all physical data source connections.