2 Replies Latest reply: Aug 25, 2013 3:40 PM by Mohammed Taj RSS

    Error when using XDOLoader to UPLOAD eText template

    User799773-Oracle

      I have been using XDOLoader to upload an etext (RTF) template.

       

      I was incorrectly using '-XDO_FILE_TYPE RTF'

       

      So I have now changed my script to use '-XDO_FILE_TYPE RTF-ETEXT'

       

      But now I get an error during the upload:

       

      [081513_091121182][][ERROR] Invalid column definition found, fail back to use default definition

      oracle.apps.xdo.template.eft.func.ParseException: Encountered "<EOF>" at line 0, column 0.

      Was expecting one of:

          "NOT" ...

          "NULL" ...

          <S_NUMBER> ...

          <QNAME> ...

          <S_BIND> ...

          <S_CHAR_LITERAL> ...

          <S_VARIABLE> ...

          "." ...

          ".." ...

          "/" ...

          "@" ...

          "+" ...

          "-" ...

          "(" ...

          "IF" ...

       

       

              at oracle.apps.xdo.template.eft.func.SqlExpression.generateParseException(SqlExpression.java:1184)

              at oracle.apps.xdo.template.eft.func.SqlExpression.jj_consume_token(SqlExpression.java:1068)

              at oracle.apps.xdo.template.eft.func.SqlExpression.SQLExpression(SqlExpression.java:288)

              at oracle.apps.xdo.template.eft.func.SqlExpression.parsingUnit(SqlExpression.java:67)

              at oracle.apps.xdo.template.eft.func.SqlExpression.parse(SqlExpression.java:53)

              at oracle.apps.xdo.template.eft.func.EFTSQLFunctionConverter.parse(EFTSQLFunctionConverter.java:368)

              at oracle.apps.xdo.template.eft.func.SQLFunctionConverter.parse(SQLFunctionConverter.java:99)

              at oracle.apps.xdo.template.eft.EFTTable.parseExpression(EFTTable.java:522)

              at oracle.apps.xdo.template.eft.EFTTable.getTransformedEFT(EFTTable.java:337)

              at oracle.apps.xdo.template.eft.RTF2EFTParser.closeTable(RTF2EFTParser.java:168)

              at oracle.apps.xdo.template.eft.RTF2EFTParser.publishText(RTF2EFTParser.java:189)

              at oracle.apps.xdo.template.rtf.RTF2XSLParser.begingroup(RTF2XSLParser.java:1006)

              at oracle.apps.xdo.template.rtf.io.RTFFilter.write(RTFFilter.java:199)

              at oracle.apps.xdo.template.rtf.io.Filter.write(Filter.java:124)

              at oracle.apps.xdo.template.rtf.RTF2XSLParser.write(RTF2XSLParser.java:170)

              at oracle.apps.xdo.template.rtf.io.Filter.readFromStream(Filter.java:64)

              at oracle.apps.xdo.template.rtf.RTFParser.generate(RTFParser.java:134)

              at oracle.apps.xdo.template.eft.RTF2EFTParser.generateXSL(RTF2EFTParser.java:143)

              at oracle.apps.xdo.template.EFTProcessor.process(EFTProcessor.java:525)

              at oracle.apps.xdo.oa.util.CoreHelper.runEFTProcessor(CoreHelper.java:179)

              at oracle.apps.xdo.oa.util.XDOLoader.processEFTTemplate(XDOLoader.java:2153)

              at oracle.apps.xdo.oa.util.XDOLoader.processUpload(XDOLoader.java:1298)

              at oracle.apps.xdo.oa.util.XDOLoader.process(XDOLoader.java:1003)

              at oracle.apps.xdo.oa.util.XDOLoader.main(XDOLoader.java:2251)

      [081513_091121251][][ERROR] expression:<> is invalid

       

      But the process appears to work and the template exists. Just I know when I pass this over for install it will be reported back that the install errored.

       

      If I switch it back to RTF (instead of RTF-ETEXT) it complete without error.

       

      Any ideas?