Peoplebooks and Tomcat Troubleshooting

After installing Peoplebooks 9.0 everything was functioning properly except when trying to use the search function which generated the following error:

No topics found!

Query syntax error!

If you're having the same issue please try the following steps which resolved it in my case:

First, from the web server you installed Peoplebooks on copy psjniverity.dll from (Drive Letter):\psol\webserv\peoplesoft\applications\peoplesoft\PSOL\WEB-INF\lib\winx86 to (Drive Letter):\psol\webserv\peoplesoft\applications\peoplesoft\PSOL\WEB-INF\lib\

Recreate Collections through http:///PSOL/psolmanager.htm (Refer to Peoplebooks documentation regarding this process if needed)

Restart the Tomcat service, and retry the search function.

The above may be all you need to resolve the error, if not, please complete these remaining steps:

From the web server, open style.vgw with notepad which can be found in (Drive Letter):\psol\verity\winx86\common\style\

Comment out the line $include vgwhttp.vgw like so:

#
# Verity gateways definition file
#
$control:1
gateway:
{
# $include vgwhttp.vgw
}
$$

Save the file, recreate Collections, restart the Tomcat service, and test the search function.

If this still has not resolved your issue, you can also try downgrading to Internet Explorer 6 if you’re currently using a newer version, and recreate Collections. Through my research I’ve read people having success with that but it was not necessary in my case.

8.98.2.0 Query Application Security

With Tools Release 8.98.2.0, Oracle has announced a new feature called Application Query Security. When this is implemented, a security administrator (or the person that configures EnterpriseOne security for an organization), can require that data be entered in a field on a form prior to clicking Find. In addition, custom warning/error messages can be configured through the data dictionary.

This new feature can be applied to Applications and the Data Browser, and looks to be a great addition to the EnterpriseOne Toolset. One of the big advantages to this will be to restrict your users from performing wide open queries in applications that use tables that contain large amounts of data (F0911!!).

In order to enable this functionality, your EnterpriseOne system must be upgraded to Tools Release 8.98.2.0, and the following ESUs must be applied (these are current ESUs that contain the required SARS, please note that these ESUs can be superceded at any time):

8.11SP1: JJ17542 and JJ17553
8.12: JK18826 and JK18818
9.0: JL13123 and JL13148

The addendum to the security guide that details the setup of Application Query Security can be found on the Oracle Support Site. Simply log in and perform a search for Doc ID: 884562.1.

EnterpriseOne VM Templates

Our blog has talked about Oracle VM in the past. The new and exciting addition to that is that now Oracle has released Oracle VM images of EnterpriseOne servers. This provides a quick and simpler method for a new EnterpriseOne 9.0 installation.

The following images are currently available:

• JD Edwards EnterpriseOne enterprise server


• JD Edwards EnterpriseOne database server including a complete installation of Oracle Database 11g R1 (64-bit)


• JD Edwards EnterpriseOne HTML server, including a complete installation of Oracle Internet Application Server 10g R3

However, the guest operation system is limited at the moment and is limited to Enterprise Linux 5 Update 2 64-bit.

Also, the deployment server is still needed for a standard installation, but, is not provided as a full template.

You can find the new templates at http://edelivery.oracle.com/oraclevm. So start downloading now and get VMing!

Oracle Weblogic

For the past few years, your choice of Web server was either IBM Websphere or Oracle Application Server. With Oracle's more recent acquisition, it appears that our options will change. The application support roadmap still has IBM Websphere as being supported for the foreseeable future with support levels staying current with the current IBM releases. However, the change that is currently documented in the roadmap is the change from Oracle Application Server to Oracle Weblogic.

The change should be seamless to the end-user, but, the admin and configuration is different than what we are currently used to in Oracle Application Server. Oracle Weblogic can be downloaded from edelivery, so you can get an install loaded in lab and test it out, but, it's currently Weblogic is only supported for Linux-64bit. According to the roadmap, support for Windows will come with Windows 2008.

So keep this change in mind if you are currently find yourself in the process of choosing a web server platform or are considering a current platform change.

Archiving JD Edwards EnterpriseOne logs using MoveIt2 software

Oftentimes, if regular maintenance is not performed, the log files on various JD Edwards servers (especially web servers) can become quite large and take up a considerable amount of hard disk space. Even if services are bounced regularly, the log files can still get out of hand as a new one will be generated every time services come back up. Unless you have a reason to archive these logs, they can simply be deleted, freeing up valuable disk space. However, Windows does not provide a simple way to automate this process...

I did find an easy way to automate this process using a simple (and free) program called MoveIt2 Lite. Using MoveIt2 Lite you are able to setup 5 different threads that run individually based on specified criteria. The interface is simple, and there are many options to make the log maintenance process far easier than doing cleanup manually.

The steps to setup threads to delete logs are as follows: Modify one of the 5 existing threads, renaming it if you wish. Specify the path to the log folder, local, UNC, and FTP locations are supported. Next specify the criteria for the thread. I usually setup the “include filters” to delete all logs (*.LOG) that are older than 30 days. Next, specify the “function.” You can select from move, copy, and delete. You should also specify the "scan time" option to set how often the threads should run. A few times a day or less should be more than enough. Next, activate your thread and the process will run automatically, deleting all of the old logs that would have been taking up unnecessary disk space.

SunStudio 12.1 compiler issue

Recently, while performing an 8.98 Tools Upgrade for one of our Unix customers, we ran into an issue where none of the BSFNs would compile on the new Sun servers being used for the new Tools Release 8.98.2.0. We received many syntax and compiler errors. After many hours of troubleshooting and working with Oracle support, it was determined that the issue was related to the SunStudio 12.1 compiler that was installed. In order to fix this issue, we downgraded to SunStudio 12.0. After that, all BSFNs compiled correctly. one lesson leared here: Even though a "Major" release (SunStudio 12) IS supported by EnterpriseOne, that does not mean a "Dot" release is supported(SunStudio 12.1). Also, if you install a "Dot" release of a 3rd party product, and are having issues, one of the first steps in troubleshooting (after the normal process of looking at JDE logs) should be to revert to a prior "Major" release...

Double checking project promotions in OMW

In the past we have seen issues in OMW where objects in a project were promoted but the changes did not really transfer as they should. You will usually get a message stating that some objects did not need transferred and sometimes you will get no indication that is the case. The best way to avoid this problem is performing a check out/check in from the environment you are transferring from and then performing the project promotion. Once you have promoted the project you can verify the promotion by opening F9861 table using UTB by entering the project name in the SIMODCMT column and ensuring the timestamps of the desired environment was updated.