Oracle Mapviewer 11.1.1.7.1 Problem Managing Tiles from Admin Page

Problem:

When you try to access from Mapviewer Admin page (http://server:port/mapviewer/faces/admin/admin.jspx) to Manage Tiles. Manage Mapviewer -> Manage Tile Layers, then  select one and press "View Map/Manage Files" you receive an "Internal Server Error" page.

At the server log file you can see the error:

admin_mcs_view_map.jspx:1:1: Needed class "javax/servlet/jsp/jstl/core/IndexedValueExpression" is not found when methods of "org.apache.myfaces.trinidadinternal.taglib.ForEachTag" are accessed.

Solution:

If you deployed the mapviewer.ear, you will find the files inside the weblogic server that you choose to target.

/xxxxx/mapviewer_domain/servers/MapviewerServer/tmp/_WL_user/mapviewer/xxxxx/war/WEB-INF/lib

You must replace the jstl.jar file with the glassfish.jstl_1.2.0.0.1.jar file that came with jsf 1.2.9 (glassfish.jsf_1.0.0.0_1-2-15.jar).
Can copy it from MW_HOME/oracle_common/modules/oracle.jsf_1.2.9 if you installed JRF.

JP

Oracle BI Publisher 11.1.1.7 Installation problem on IBM AIX 6.1

During the installation of Oracle BI Publisher 11.1.1.7 appears an error during "Setting up Database Connection" part of the process

Looking at the log and out files found that the problem was during the execution of /oracle/product/middleware/11.1.1.7/Oracle_BI1/bifoundation/install/writeRegistryProperties.py


There is a step where a zip file is copied and extracted

Copied from /oracle/product/middleware/11.1.1.7/Oracle_BI1/products/ha-scripts/essfoconfig.zip to /oracle/product/middleware/11.1.1.7/instances/instance1/bin/essbase_ha/essfoconfig.zip

Appears to be the extraction of the zipped files, but I found that the result file from the copy zip file was empty, with 0 bytes, that's why the extraction failed.

I edited the writeRegistryPropertiecs.py and changed the method that do the copy process.

import shutil
...
...
...
#EpmDeployUtils.copyFile(val_oracleHome + "/products/ha-scripts/essfoconfig.zip", val_oracleInstance + "/bin/essbase_ha/essfoconfig.zip")
shutil.copy(val_oracleHome + '/products/ha-scripts/essfoconfig.zip',  val_oracleInstance + '/bin/essbase_ha/essfoconfig.zip')

Restarted the installation process and worked as expected.

Cheers.

JP

File and FTP Operations Processes with Oracle SOA Suite 11g and OSB 11g Adapters

Oracle SOA Suite 11g File and FTP adapters supports operations that are not available with the wizards.

These operations are Copy, Move and Delete files between File and FTP servers.

It is explained at Oracle Fusion Middleware User's Guide for Technology Adapters

First I developed a composite with a bpel process that exposes this operations, and then an OSB 11g project that use the same adapters.

Some properties can't be assigned at runtime, that's why I created one jca for each operation.

The operations exposed are:

FileCopy -> SourceDirectory, SourceFile, TargetDirectory, TargetFile
FileMove -> SourceDirectory, SourceFile, TargetDirectory, TargetFile
FileDelete -> TargetDirectory, TargetFile
FileToFTPCopy -> SourceDirectory, SourceFile, TargetDirectory, TargetFile, jndiFtp
FileToFTPMove -> SourceDirectory, SourceFile, TargetDirectory, TargetFile, jndiFtp
FTPCopy -> SourceDirectory, SourceFile, TargetDirectory, TargetFile, jndiFtp
FTPMove -> SourceDirectory, SourceFile, TargetDirectory, TargetFile, jndiFtp
FTPDelete -> TargetDirectory, TargetFile, jndiFtp
FtpToFileCopy -> SourceDirectory, SourceFile, TargetDirectory, TargetFile, jndiFtp
FtpToFileMove -> SourceDirectory, SourceFile, TargetDirectory, TargetFile, jndiFtp

The jndiFtp parameter that you use must be added to the FtpAdapter Resource Adapter and redeploy it.
For example: you can use the standard eis/ftp/FtpAdapter or create a new one with the desired configuration.

If the FTP server does not support the RNFR/RNTO FTP commands, then you must set UseNativeRenameOperation to FALSE and define the property in composite.xml, as shown in the following example:

<reference name="FTPMove" ui:wsdlLocation="FTPMove.wsdl">
  <interface.wsdl interface="http://xmlns.oracle.com/pcbpel/adapter/ftp/SOAFtpIO/SOAFtpIO/FTPMove/#wsdl.interface(FTPMove_ptt)"/>
    <binding.jca config="FTPMove_ftp.jca">
      <property name="UseNativeRenameOperation" type="xs:string" many="false" override="may">false</property>
    </binding.jca>
</reference>

If you use this app in a Cluster installation, must change the jca source files to use HA Adapters.

The source code is here.

I hope that this helps.

JP