常见错误

 

错误：PCSF_46026 Unable to find valid TrustStore certificate in PEM format

原因：本地没有配置INFA_DOMAINS_FILE和INFA_TRUSTSTORE环境变量

解决：配置INFA_DOMAINS_FILE和INFA_TRUSTSTORE环境变量，具体请参照Informatica安装

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

错误：RR_4035 : SQL Error FnName: Fetch -- [Informatica][ODBC 20101 driver]1906072].

原因：数据转换过程中，数据类型不匹配

　　　例如，数据库表中字段为varchar2，而该表在Mapping中作为Source/Target对应字段为int

解决：修改数据类型，使数据类型匹配

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

错误：当通过DWsqls26.so drivers向Sql Server数据库加载数据时，报如下错误

　　    FnName: Execute -- [Informatica][ODBC 20101 driver]6054
　　　FnName: Execute -- 523 158

原因：Same Session succeeds when using the legacy DWmsss26.so drivers.

解决：将以下属性值加入到odbc.ini文件中对应连接处

           Workarounds2=2

 

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

错误：ERROR: "FR_3093 (At input file offset [423774]) Row [1813]: Record length [317070] is longer than line sequential buffer length [2830] for /IF/NI/in/ZTXT.csv. Record will be rejected

原因：This issue occurs when Line Sequential File Format is selected and the value of the Line Sequential Buffer Length option (default is 1024 bytes) is smaller than the length of the records in the flat file source

解决：根据错误信息调高Line Sequential Buffer Length数值