最近公司一个R12升级,自己也装个demo对应着,开始遇到的问题都是之前遇到过的,很顺利就过去了,最后打中文补丁6678700,本来应该是睡一觉起来就发现OK了,但是醒了吓一跳啊!居然来了个报错
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIyZuBnLxYDM581N5ITNwQzN0MTMvwlMx8CX5AjMxAjMvw1ckF2bsBXdvwFdl5mLuR2cj5Set1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
很一个莫名,这个时候不要把终端给关了!
进入/d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log
查看adwork 日志
出现这样的错误提示:
Target file: FADTXD.xlf
Start uploading...
[060209_054527800][][EXCEPTION] java.io.UTFDataFormatException: Invalid UTF8 encoding.
at oracle.xml.parser.v2.XMLUTF8Reader.checkUTF8Byte(XMLUTF8Reader.java:160)
at oracle.xml.parser.v2.XMLUTF8Reader.readUTF8Char(XMLUTF8Reader.java:203)
at oracle.xml.parser.v2.XMLUTF8Reader.fillBuffer(XMLUTF8Reader.java:120)
at oracle.xml.parser.v2.XMLByteReader.saveBuffer(XMLByteReader.java:450)
at oracle.xml.parser.v2.XMLReader.fillBuffer(XMLReader.java:2488)
at oracle.xml.parser.v2.XMLReader.tryRead(XMLReader.java:1089)
at oracle.xml.parser.v2.XMLReader.scanXMLDecl(XMLReader.java:3047)
at oracle.xml.parser.v2.XMLReader.pushXMLReader(XMLReader.java:521)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:288)
at oracle.apps.xdo.oa.util.TemplateTranslator.
createMLSTemplates(TemplateTranslator.java:238)
at oracle.apps.xdo.oa.util.XLIFFLoader.processUpload(XLIFFLoader.java:709)
at oracle.apps.xdo.oa.util.XLIFFLoader.process(XLIFFLoader.java:565)
at oracle.apps.xdo.oa.util.XLIFFLoader.main(XLIFFLoader.java:1073)
oracle.apps.xdo.XDOException: Exception while parsing base template
at oracle.apps.xdo.oa.util.TemplateTranslator.
createMLSTemplates(TemplateTranslator.java:241)
at oracle.apps.xdo.oa.util.XLIFFLoader.processUpload(XLIFFLoader.java:709)
at oracle.apps.xdo.oa.util.XLIFFLoader.process(XLIFFLoader.java:565)
at oracle.apps.xdo.oa.util.XLIFFLoader.main(XLIFFLoader.java:1073)
AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.
解决方法:
切换到applmgr用户,运行APPL<CONTEXT_NAME>.env,如果已经有上下文就不必运行
根据情况修改以下命令,然后粘贴执行:
adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME <apps_username> -DB_PASSWORD <apps_password> -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=<db_port>)))(CONNECT_DATA=(SID=<oracle_sid>)))" -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE 00 -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME $FA_TOP/patch/115/publisher/defs/FADTXD.xml
adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME <apps_username> -DB_PASSWORD <apps_password> -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL =tcp)(HOST=<host>)(PORT=<db_port>)))(CONNECT_DATA=(SID=<oracle_sid>)))" -LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF -TRANSLATE Y -FILE_NAME $FA_TOP/patch/115/publisher/templates/US/FADTXD.rtf
<以上方法参见Metalink:[ID 880149.1],是个BUG>
之后重启worker:
$cd /d01/oracle/VIS/inst/apps/VIS_hand/admin/scripts
$adctrl
输入apps密码
之后选择
2. Tell worker to restart a failed job
之后会发现之前暂停在错误地方的终端现在重新运行了!安心吧...