Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "[pmidm_26050] Not enough values in the dictionary" when Data Preview on Data Masking transformation fails
Problem Description
Data Preview on Data Masking transformation fails with "[pmidm_26050] Not enough values in the dictionary".

Log Trace

 

2019-05-22 11:02:22.601 <TASK_139630510855936-READER_1_2_1> INFO: [RR_4049] SQL Query issued to database

2019-05-22 11:02:22.602 <TASK_139630502463232-READER_1_1_1> INFO: [RR_4049] SQL Query issued to database

2019-05-22 11:02:22.687 <TASK_139630502463232-READER_1_1_1> INFO: [RR_4050] First row returned from database to reader

2019-05-22 11:02:22.687 <TASK_139630502463232-READER_1_1_1> INFO: [BLKR_16019] Read [12] rows, read [0] error rows for source table [tutorial_dept] instance name [Read_tutorial_dept]

2019-05-22 11:02:22.688 <TASK_139630485677824-TRANSF_1_1_1> INFO: [DBG_21077] Create joiner cache on master relation for transformation [Joiner]

2019-05-22 11:02:22.688 <TASK_139630485677824-TRANSF_1_1_1> INFO: [DBG_21714] Variable Length Data Cache Row Storage Mode is disabled for Joiner Transformation [Joiner].

2019-05-22 11:02:22.688 <TASK_139630485677824-TRANSF_1_1_1> INFO: [TE_7212] Increasing [Index Cache] size for transformation [Joiner] from [89478485] to [89479200].

2019-05-22 11:02:22.688 <TASK_139630485677824-TRANSF_1_1_1> INFO: [TE_7212] Increasing [Data Cache] size for transformation [Joiner] from [178956970] to [178957000].

2019-05-22 11:02:22.701 <TASK_139630502463232-READER_1_1_1> INFO: [BLKR_16008] Reader run completed.

2019-05-22 11:02:22.712 <TASK_139630485677824-TRANSF_1_1_1> INFO: [CMN_1690] Created new data file [/data/informatica/1021/tomcat/bin/cache/PMJNR1_64_0_16131.dat] and index file [/data/isuser/IS_02547680_10.23.141.146_10.2.1_64/10.2.1/tomcat/bin/cache/PMJNR1_64_0_16131.idx] for Joiner [Joiner].

2019-05-22 11:02:22.713 <TASK_139630485677824-TRANSF_1_1_1> INFO: [DBG_21214] Finished joiner cache on master relation for transformation [Joiner]

2019-05-22 11:02:22.728 <TASK_139630510855936-READER_1_2_1> INFO: [RR_4050] First row returned from database to reader

2019-05-22 11:02:22.729 <TASK_139630510855936-READER_1_2_1> INFO: [BLKR_16019] Read [14] rows, read [0] error rows for source table [tutorial_employee] instance name [Read_tutorial_employee]

2019-05-22 11:02:22.729 <TASK_139630502463232-TRANSF_1_2_1> INFO: [DBG_21603] Open master relation cache for detail joiner for transformation [Joiner]

2019-05-22 11:02:22.733 <TASK_139630510855936-READER_1_2_1> INFO: [BLKR_16008] Reader run completed.

2019-05-22 11:02:22.743 <APP_139627999405824> INFO: [pmidm_24095] Dictionary cache created.

2019-05-22 11:02:22.744 <TASK_139630502463232-TRANSF_1_2_1> SEVERE: [pmidm_26050] Not enough values in the dictionary.

2019-05-22 11:02:22.744 <TASK_139630502463232-TRANSF_1_2_1> SEVERE: [TM_6085] A fatal error occurred at  transformation [Data_Masking0], and the session is terminating.

2019-05-22 11:02:22.744 <TASK_139630502463232-TRANSF_1_2_1> SEVERE: [TM_6085] A fatal error occurred at  transformation [Joiner], and the session is terminating.

2019-05-22 11:02:22.744 <TASK_139630502463232-TRANSF_1_2_1> SEVERE: [TM_6085] A fatal error occurred at  transformation [Joiner], and the session is terminating.

2019-05-22 11:02:22.744 <TASK_139630502463232-TRANSF_1_2_1> SEVERE: [TM_6085] A fatal error occurred at  transformation [Read_tutorial_employee], and the session is terminating.

2019-05-22 11:02:22.744 <TASK_139630502463232-TRANSF_1_2_1> SEVERE: [TM_6085] A fatal error occurred at  transformation [Read_tutorial_employee], and the session is terminating.

2019-05-22 11:02:22.744 <TASK_139630502463232-TRANSF_1_2_1> SEVERE: [TM_6085] A fatal error occurred at  transformation [Read_tutorial_employee], and the session is terminating.

2019-05-22 11:02:22.745 <TASK_139630519248640-TRANSF_1_2_1> INFO: [pmidm_24001] De-initializing Data Masking Partition Instance.

2019-05-22 11:02:22.746 <TASK_139630502463232-WRITER_1_*_1> INFO: [WRT_8035] Load complete time: Wed May 22 11:02:22 2019
Cause
This issue occurs when the Native client connectivity configurations are not available for the reference database used with 'Content Management Service' (CMS) from the Informatica DIS server machine.
Solution
Configure the Native client connectivity settings to the reference database used with CMS. 

 

For instance, in case if Oracle database is used with CMS as reference database, the following settings should be made:

 

export set ORACLE_HOME=[absolute_path_to_oracle_database_client]

export set PATH=$ORACLE_HOME/bin:$PATH

export set LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

 

  Example:

export set ORACLE_HOME=/databases/client_12.1.0.2

export set PATH=$ORACLE_HOME/bin:$PATH

export set LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

More Information
Applies To
Product: Data Engineering Integration(Big Data Management)
Problem Type: Configuration
User Type: Developer
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:11/19/2019 4:09 AMID:604878
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)