Powercenter712之ORA-01461

Version:PowerCenter7.1.2 (Solaris 8)
Oracle DB:9.2.0.1(Windows Server 2000+SP4)

MAPPING> TM_6683 Repository Name: [xxCN]
MAPPING> TM_6684 Server Name: [xxx0082dap_xx]
MAPPING> TM_6686 Folder: [xxx]
MAPPING> TM_6685 Workflow: [wf_CON_INFO_test]
MAPPING> TM_6101 Mapping name: xxxxxxx [version 2]
MAPPING> CMN_1569 Server Mode: [UNICODE]
MAPPING> CMN_1570 Server Codepage: [ISO 8859-1 Western European]
MAPPING> TM_6151 Session Sort Order: [Binary]
MAPPING> TM_6185 WARNING! Data codepage validation is disabled in this session.
MAPPING> TM_6156 Using LOW precision decimal arithmetic
MAPPING> TM_6180 Deadlock retry logic will not be implemented.

WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-01461: can bind a LONG value only for insert into a LONG column

Solution steps:
1)Check "Connection object Definition" ,code page:"UTF-8 encoding of Unicode"
2)Check Powercenter server configure file:*.cfg:
# Determine one of the two server data movement modes: UNICODE or ASCII.
# If not specified, ASCII data movement mode is assumed.

DataMovementMode=Unicode

3)Chceck environment variable:
bash>env|grep NLS
NLS_LANG=AMERICAN_AMERICA.UTF8

4)Check repository's oracle database
SELECT *
FROM V$NLS_PARAMETERS
where parameter in ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET')

PARAMETER VALUE
============================================
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CHARACTERSET AL32UTF8
5)Update .profile
NLS_LANG=AMERICAN_AMERICA.UTF8
==>
NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Restart Repository server,Restart PowerCenter server,rerun the workflow.successed

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/65994/viewspace-892743/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/65994/viewspace-892743/