0 Replies Latest reply: Apr 18, 2011 3:44 AM by Adelinet-Oracle RSS

    E1: XMLP: Unable to utilise XLS (TL) templates

    Adelinet-Oracle
      8.12
      8.98.4.1

      Customer currently do not have the option to use TL (.xls) templates in their current installation of embedded BI Publisher with JDE E1. The option did not exist in the UDC H95|XP. They added it but are still experiencing issues. Please advise if there are any special installation steps that need to be taken to have this functionality available.

      Below outlines the steps they performed and what was seen in the JDE logs.

      ==============================
      Added TL record UDC to DV812.

      Activated JVM debugging for the JVM process on the Ent server. Ran the Excel test and log showed this :

      18 Apr 2011 15:41:43,256 [Line -1] [main] [DEBUG ] - [25445][RUNTIME] XmlpProxy.generateReport(): Entering...
      18 Apr 2011 15:41:43,270 [Line -1] [main] [DEBUG ] - [25445][RUNTIME] XmlpProxy.generateReport(): XML Data = /var/tmp/CAAqIaOSX | Template Type = TL | Template = /var/tmp/EAAsIaOSX | Template Locale = AU-EN | Transformation = | Translation = | Translation Locale = - | Output type = EXCEL
      18 Apr 2011 15:41:43,309 [Line -1] [main] [DEBUG ] - [25445][RUNTIME] XmlpObjectImpl: Unable to locate JDE.ini file. The full file path to the JDE.ini can be specified using "-Dconfig_file" JVM system propery.
      18 Apr 2011 15:41:43,310 [Line -1] [main] [DEBUG ] - [25445][RUNTIME] XmlpObjectImpl: JDE.ini key tempFileDir in [JDENET] section not set. Checking for JAS.ini...
      18 Apr 2011 15:41:43,391 [Line -1] [main] [DEBUG ] - [25445][BASE] unable to find jas.ini java.io.IOException: Unable to find the configure file jdeinterop.ini
      18 Apr 2011 15:41:43,424 [Line -1] [main] [DEBUG ] - [25445][RUNTIME] XmlpObjectImpl: TEMP_FILE_DIR = webclient/temp/
      18 Apr 2011 15:41:43,447 [Line -1] [main] [DEBUG ] - [25445][RUNTIME] ExcelTemplate.generateReport(): Entering...
      18 Apr 2011 15:41:43,449 [Line -1] [main] [APP   ] - [25445][BASE] Loading config xdo.cfg from classpath:/u10/jdedwards/e812/system/classes/xdo.cfg
      18 Apr 2011 15:41:44,986 [Line -1] [main] [SEVERE] - [25445][RUNTIME] XmlpProxy.generateReport(): com.jdedwards.xmlp.exceptions.XmlpRuntimeException: Excel Proccessor failed.
      18 Apr 2011 15:41:44,988 [Line -1] [main] [DEBUG ] - [25445][RUNTIME] XmlpProxy.generateReport(): Exiting. | Return Code = -5
      =========================================================

      Notice the JDE.INI thing - that is new - adding a config path to the [JDE JVM], and then got this :

      18 Apr 2011 15:51:12,537 [Line -1] [main] [DEBUG ] - [25832][RUNTIME] XmlpProxy.generateReport(): Entering...
      18 Apr 2011 15:51:12,554 [Line -1] [main] [DEBUG ] - [25832][RUNTIME] XmlpProxy.generateReport(): XML Data = /var/tmp/CAAVGaaDY | Template Type = TL | Template = /var/tmp/EAAXGaaDY | Template Locale = AU-EN | Transformation = | Translation = | Translation Locale = - | Output type = EXCEL
      18 Apr 2011 15:51:12,593 [Line -1] [main] [DEBUG ] - [25832][RUNTIME] XmlpObjectImpl: Path to JDE.ini = /u10/jdedwards/e812/ini/JDE.INI
      18 Apr 2011 15:51:12,655 [Line -1] [main] [SEVERE] - [25832][RUNTIME] XmlpObjectImpl: Unable to initialize XmlpObjectImpl class. java.lang.IllegalStateException: Temporary file directory is not accessible. TEMP_FILE_DIR = /tmp
      18 Apr 2011 15:51:12,685 [Line -1] [main] [DEBUG ] - [25832][RUNTIME] XmlpObjectImpl: TEMP_FILE_DIR = /tmp
      18 Apr 2011 15:51:12,708 [Line -1] [main] [DEBUG ] - [25832][RUNTIME] ExcelTemplate.generateReport(): Entering...
      18 Apr 2011 15:51:12,710 [Line -1] [main] [APP   ] - [25832][BASE] Loading config xdo.cfg from classpath:/u10/jdedwards/e812/system/classes/xdo.cfg
      18 Apr 2011 15:51:14,217 [Line -1] [main] [SEVERE] - [25832][RUNTIME] XmlpProxy.generateReport(): com.jdedwards.xmlp.exceptions.XmlpRuntimeException: Excel Proccessor failed.
      18 Apr 2011 15:51:14,219 [Line -1] [main] [DEBUG ] - [25832][RUNTIME] XmlpProxy.generateReport(): Exiting. | Return Code = -5

      ======================================================
      So, JDE.INI fixed, but it did not like the /tmp, I changed it to a full path inside /u10/jdedweards etc by adding an entry for [JDENET] for tempFileDir=/u10/jdedwards/e812/tmp, now we get just this in the logs :

      18 Apr 2011 15:56:36,061 [Line -1] [main] [DEBUG ] - [26172][RUNTIME] XmlpProxy.generateReport(): Entering...
      18 Apr 2011 15:56:36,074 [Line -1] [main] [DEBUG ] - [26172][RUNTIME] XmlpProxy.generateReport(): XML Data = /var/tmp/CAAbGaGhZ | Template Type = TL | Template = /var/tmp/EAAdGaGhZ | Template Locale = AU-EN | Transformation = | Translation = | Translation Locale = - | Output type = EXCEL
      18 Apr 2011 15:56:36,112 [Line -1] [main] [DEBUG ] - [26172][RUNTIME] XmlpObjectImpl: Path to JDE.ini = /u10/jdedwards/e812/ini/JDE.INI
      18 Apr 2011 15:56:36,208 [Line -1] [main] [DEBUG ] - [26172][RUNTIME] XmlpObjectImpl: TEMP_FILE_DIR = /u10/jdedwards/e812/tmp
      18 Apr 2011 15:56:36,230 [Line -1] [main] [DEBUG ] - [26172][RUNTIME] ExcelTemplate.generateReport(): Entering...
      18 Apr 2011 15:56:36,232 [Line -1] [main] [APP   ] - [26172][BASE] Loading config xdo.cfg from classpath:/u10/jdedwards/e812/system/classes/xdo.cfg
      18 Apr 2011 15:56:37,743 [Line -1] [main] [SEVERE] - [26172][RUNTIME] XmlpProxy.generateReport(): com.jdedwards.xmlp.exceptions.XmlpRuntimeException: Excel Proccessor failed.
      18 Apr 2011 15:56:37,745 [Line -1] [main] [DEBUG ] - [26172][RUNTIME] XmlpProxy.generateReport(): Exiting. | Return Code = -5

      Cant find anything related to this Return Code = -5.

      This Excel type seems to do stuff very different.