"CMN_1552: Error accessing lookup cache." when running a PowerCenter session with large lookup tables

最新推荐文章于 2024-03-08 19:27:16 发布

浪菜叶

最新推荐文章于 2024-03-08 19:27:16 发布

阅读量7.8k

点赞数

分类专栏： BI 文章标签： session transformation attributes command parameters properties

BI 专栏收录该内容

22 篇文章

订阅专栏

本文介绍了解决在构建大数据量查表缓存时导致PowerCenter会话崩溃的问题。通常由于服务器上的用户进程资源限制配置不当引起此错误。文章提供了调整限制参数和会话属性的具体步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Problem Description

The session crashes and generates a core file when building the lookup cache for lookup tables that have large amounts of data. The error is seen when the lookup table contains millions of records.

CMN_1552: Error accessing lookup cache.
TM_6085 : The transformation [LKP_TRANS {{BLD}}] encountered fatal error. Terminating session.
TM_6085 : The transformation [{{DSQ}}] encountered fatal error. Terminating session.

Cause

This error is usually caused due to the user process resource limits that are configured on the server where PowerCenter is installed.

Solution
To resolve the issue, first check the current user limits for the user that starts PowerCenter:

Run the command following command:

$ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 32768
stack(kbytes) 2768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 1024

Increase the user limits for the data, memory and nofiles parameters. Please check with your System Administrator and make changes to these parameters:

$ ulimit -d 4096000
$ ulimit -m 4096000
$ ulimit -n 4096

Edit the Session properties and increase the Max memory limits for the session:

In the Config Object tab:

Set Maximum Memory Allowed For Auto Memory Attributes = 1024MB
Set Maximum Percentage of Total Memory Allowed For Auto Memory Attributes = 10

Confirm that you have sufficient free space available in the lookup cache directory.

Run the session after making the above changes.