infomatica新建repository 显示编码报错

infomatica安装后,新建repository报错,我弄来弄去就是这两个报错循环

两个错误如下:

The service did not start due to the following error: The repository code page [2252: MS Windows Latin 1 (ANSI), superset of Latin1] does not match the code page specified for the corresponding Repository Service in the Administration Console [936: MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding].. Check the log for more information.


The following error occurred while performing a repository action. Error - [PCSF_10007] Cannot connect to repository [dxj_repo] because \n[[REP_61082] AdminConsole's code page (MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding) is not one-way compatible to repository dxj_repo's code page (MS Windows Latin 1 (ANSI), superset of Latin1). Failed to connect to repository service [dxj_repo].].

原因是:我在安装完成之后,创建repository时,在数据库的编码信息和console不对应

解决方案:

1 数据库中新建查询         SELECT * FROM OPB_REPOSIT; 查询自己所建立的repository在数据库中的编码,

2 修改repository的编码即codepage_id

3 返回查看所创建的repository是否正确


总体操作如下图,我先查询后,进行了修改,我安装完成后,新建了repository,编码选择的是utf-8,所以在数据库修改成为106,编码对应图在最下面

infomatica新建repository 显示编码报错

SELECTCOLLATIONPROPERTY('Chinese_PRC_Stroke_CI_AI_KS_WS', 'CodePage');

SELECT *FROM OPB_REPOSIT;

updateOPB_REPOSIT set codepage_id = '106' where recid='1';

infomatica新建repository 显示编码报错


后续操作就是删除原有的content,restore标准库