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,编码对应图在最下面
SELECTCOLLATIONPROPERTY('Chinese_PRC_Stroke_CI_AI_KS_WS', 'CodePage');
SELECT *FROM OPB_REPOSIT;
updateOPB_REPOSIT set codepage_id = '106' where recid='1';
后续操作就是删除原有的content,restore标准库