10. adpatch 补丁应用指南（常见问题处理）(10)

手册

1.16.7 如果出现错误A Different index with same

column name exists

这种情况需要drop到客户化索引。

可以参考Note 1514897.1 Patch Application Fails Running FndXdfCmp To Create An Index With Error: A Different Index With Same Column Name Exists

1.16.8 java设置可能会导致的其他错误

可能会碰到下面错误：

- Exception occurred :C: Unable to resolve type

- Exception occurred :Fail to construct descriptor: Unable to resolve type

可能是由java的设置引起的。

根据EBS版本不同，请参考下面文章：

Note 418664.1 Overview of Using Java with Oracle E-Business Suite Release 12 Note 455492.1 Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12 Note 384249.1 Using Latest Update of JDK 5.0 with Oracle E-Business Suite Release 12 Note 300482.1 Overview of Using Java with Oracle E-Business Suite Release 11i Note 401561.1 Using J2SE Version 6 with Oracle E-Business Suite 11i Note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Release 11.5.10 Note 246105.1 Upgrading to J2SE 1.4.2 with Oracle Applications 11i Note 130091.1 Upgrading Oracle Applications 11i to use JDK 1.3 下面文章也记录了类似问题： Note 829023.1 Patch 3480000 Fails on several files like fnd_seed_stage_*.xdf with error \Note 294457.1 Avoiding XDF Errors by Verifying CLASSPATH Settings

1.16.9 手工加载.xdf文件

参考：

Note 308427.1 The XDF Comparison Utility (FndXdfCmp)

Note 551325.1 How to verify or create a Database Object using a odf (adodfcmp) or xdf (FndXdfCmp) file ?

先加载应用环境变量，然后执行：

手册

adjava -ms128m -mx256m -nojit oracle.apps.fnd.odf2.FndXdfCmp apps apps THIN \type $FND_TOP/patch/115/xdf/jtf_pf_tabletype.xdf $FND_TOP/patch/115/xdf/xsl 例子: adjava -ms128m -mx256m -nojit oracle.apps.fnd.odf2.FndXdfCmp ego apps THIN \table $EGO_TOP/patch/115/xdf/ego_mtl_sy_items_ext_b.xdf $FND_TOP/patch/115/xdf/xsl

1.17 如何解决XLIFFImporter (.xlf)文件运行失败

补丁日志中可能会看到下面信息： ATTENTION: All workers either have failed or are waiting: FAILED: file XLIFFImporter.class on worker #. 1.17.1 查看adwork日志

在adpatch的日志中可以看到执行出错的job是分配在哪个worker上运行的，在adwork的

日志中查看错误的详细信息。

1.17.2 如果安装NLS补丁时出现错误

错误信息如： Invoking Utility XLIFFImporter ... Class: oracle.jrad.tools.trans.imp.XLIFFImporter Method: processXLIFF Arguments: &fullpath:::.xlf -username &un_apps -password &pw_apps -dbconnection &jdbc_db_addr TimeStamp : [date] ========================================================== Could not import translations in repository : \========================================================== Done calling the utility function. Return Code = [1] TimeStamp = date Updating task with status 1 AD Worker error: The utility XLIFFImporter returned error for the above task. 手册

错误\: \通常意味这你没有在基础安装或这升级之后立即安装NLS补丁。

出现这个错误的影响是，在使用特定产品的特定页面时可能会出现错误“No page found”

另一个可能导致此错误的原因是repository中没有US xml文件，比如：

adjava -Xmx512M -nojit oracle.jrad.tools.trans.imp.XLIFFImporter &fullpath:ap:mds/oie/policy/category/meals/webui/E:OIE_POL_MEALS_RULES_PAGE.xlf -username &un_apps -password &pw_apps -dbconnection &jdbc_db_addr Reading product information from file... Reading language and territory information from file... Reading language information from applUS.txt ... Temporarily resetting CLASSPATH to: ... Calling $COMMON_TOP/util/java/jdk1.5.0/bin/java ... Could not import translations in repository : \in repository. 这种情况下，可以尝试按照下面步骤重新将US xml文件加载到repository中 1. 确保US目录中相关的.xml文件 我们的例子中需要使用$AP_TOP/mds/oie/policy/category/meals/webui/OIE_POL_MEALS_RULES_PAGE.xml

2. 重新加载XML（US数据） java oracle.jrad.tools.xml.importer.XMLImporter \\ $AP_TOP/mds/oie/policy/category/meals/webui/OIE_POL_MEALS_RULES_PAGE.xml \\ -username APPS -password -dbconnection \\ \PORT=))(CONNECT_DATA=(SID=)))\-rootdir $PRODUCT_TOP/mds 数据库连接串中的HOST/PORT/SID要根据实际情况进行替换，替换之后的命令例如： java oracle.jrad.tools.xml.importer.XMLImporter \\ $AP_TOP/mds/oie/policy/category/meals/webui/OIE_POL_MEALS_RULES_PAGE.xml \\ -username APPS -password APPS -dbconnection \p)(HOST=hostname.domain.com)(PORT=1521)))(CONNECT_DATA=(SID=TEST)))\-rootdir $AP_TOP/mds -rootPackage /oracle/apps 到

手册

3. 重启失败的job或者手工重新加载XLF (NLS data) 手工加载方法： java oracle.jrad.tools.trans.imp.XLIFFImporter \\ -username APPS -password -dbconnection \\ \PORT=))(CONNECT_DATA=(SID=)))“ \\ $/.xlf

可以使用下面的方法查看加载到数据库中的信息

SQL> select RPAD(f.filename,30), f.file_id, RPAD(v.version,20), f.last_update_date from AD_FILES f, AD_FILE_VERSIONS v where f.file_id = v.file_id and f.filename LIKE ''; For example: SQL> select RPAD(f.filename,30), f.file_id, RPAD(v.version,20), f.last_update_date from AD_FILES f, AD_FILE_VERSIONS v where f.file_id = v.file_id and f.filename LIKE 'OIE_POL_MEALS_RULES_PAGE%';

如果重新加载US相关文件还不能解决问题，进行下面步骤： ? 先跳过这个步骤，继续运行后续的补丁操作

? 补丁安装完成之后，参考Note 252422.1 Requesting Translation Synchronization Patches

申请一个Translation Synchronization Patch (TSP)，安装这个补丁可以将NLS和US进行同步这个补丁安装的时候应该就不会出现问题了。

f.creation_date, f.creation_date, 1.17.3 如果出现错误jre: No such file or directory

例如： FAILED: file XLIFFImporter.class on worker 1. adjava -Xmx512M -nojit oracle.jrad.tools.trans.imp.XLIFFImporter &fullpath:icx: mds/por/rcv/webui/ZHS:IcxPorRcvRvwPG.xlf -username &un_apps -password &pw_apps - dbconnection &jdbc_db_addr Reading product information from file... Reading language and territory information from file... 手册

Reading language information from applUS.txt ... Temporarily resetting CLASSPATH to: .... Calling /.../j2sdk1.4.2_13/bin/jre ... /bin/sh: line 1: /.../j2sdk1.4.2_13/bin/jre: No such file or directory 这种情况要检查一下java/jre设置。根据EBS版本不同，可以参考下面文章： Note 418664.1 Overview of Using Java with Oracle E-Business Suite Release 12 Note 455492.1 Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12 Note 384249.1 Using Latest Update of JDK 5.0 with Oracle E-Business Suite Release 12 Note 300482.1 Overview of Using Java with Oracle E-Business Suite Release 11i Note 401561.1 Using J2SE Version 6 with Oracle E-Business Suite 11i Note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Release 11.5.10 Note 246105.1 Upgrading to J2SE 1.4.2 with Oracle Applications 11i Note 130091.1 Upgrading Oracle Applications 11i to use JDK 1.3

1.17.4 运行Performance issues on all

XLIFFImporter.class job时出现性能问题

如果运行XLIFFImporter.class job需要花费很长时间完成，可能需要先安装补丁Patch 8576725

\ 查看Note 839978.1 12.1.1 NLS Upgrade Patch 6678700 : Performance Installation Issues With XLIFFImporter Java Jobs

1.17.5 如果出现错误

oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket

oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)