Oracle® Business Intelligence Data Warehouse Administration Console User's Guide Version 10.1.3.4 Part Number E12652-02 |
|
|
View PDF |
This appendix contains troubleshooting topics for the Data Warehouse Administration Console (DAC).
It contains the following topics:
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.
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.
Connect to the existing DAC repository.
Export the entire repository (logical, system, and run time categories).
Stop the DAC Server and all DAC Clients except for the one you are using.
Drop the current repository.
If you are using a DAC Client, restart it.
Create a new repository with the Unicode option selected.
Import the DAC metadata that you exported in step 2.
Re-enter the passwords for all Informatica services and all physical data source connections.