Journaling a Physical File on IBM iSeries Using STRJRNPF

We have a system that needs to interface directly with some EnterpriseOne Files.  This system is written in Java and seems to be very difficult to change any JDBC settings to not use commitment control.

Anyway, to get around this issue, we started journaling the physical file that the JDBC command was trying to update using the following command:

STRJRNPF FILE(PRODDTA/F0911) JRN(OWJRNL/OW_JRNL)

Server Management Will Not Start After Update

We are updating our EnterpriseOne Tools Release to 8.98.2.2 and had an issue with updating the Server Manager Agent on our Windows web servers. After following the steps to do the update of the Server Manager Agent it would not restart. I was able to find a document (Doc ID 983043.1) on Oracle Support that fixed the issue.

To resolve this issue, Customers need to download the 8.98.2.2 (or newer) version of the Server Manager update component and proceed with the following steps:

Update your Server Manager console with the newer version of Server Manager.

Locate the “scfagent.jar” file in the following directory:
{jde_home}\targets\oc4j\j2ee\home\applications\ManagementConsole\ManagementConsole_WAR\scfagent
where {jde_home} is your Server Manager console install location.

Copy this file to the following directory on the machine where your Windows Server Manager agent is running:
{jde_agent_home}\lib\_staging
where {jde_agent_home is the Server Manager agent install location

Rename the “scfagent.jar” file that you have copied to “agentUpdate.jar”. If there is already a file with this name, it should be replaced with the new file you have copied.

Run the “startAgent.bat” command file twice from the {jde_agent_home}\bin directory. The first time will update the Server Manager agent JAR files with the newer version, but will likely fail to start the service. The second time should start the service successfully.

I hope that helps!

How To Find EnterpriseOne Web Only Versions

Dealing with EnterpriseOne “Web Only” versions can be a real pain.

They are deleted with each full package deployment and can cause a lot of confusion for the users.

In order to find these troublesome quasi-objects you can run the sql below:

select * from copy811/f983051
where VRVCC2 ='1'

Batch Version (P98305W) Version Error

After our latest tools release update there was a special instruction that I forgot to do on one of the environments.  It was to delete all versions of the Batch Versions (P98305W) application.  Usually, there will be just one version: ZJDE0001.

Well, since I forgot, to the left is the error that you might get if you don’t do it.  The second image is the Interactive Versions screen that you will need to use to delete the version.

EnterpriseOne & Sharepoint

A few weeks ago I attended a webinar sponsored by JDETips and presented by K-Rise Systems.

K-Rise has a very interesting set of EASYProcess web parts that integrate with EnterpirseOne.

Below is a list of selling points:

• With EASYProcess you get the power of Web portal interfaces, workflows, a business process automation engine, data integration, reporting, web services and handheld development, all in one place, integrated seamlessly to work with JDE and any database.
• Absolutely NO CODING in using EASYProcess.Your staff will be developing with EASYProcess very quickly. The learning curve is a couple of days. On-Site and On-Line training available. See possible projects below.
• Are you paying your developers to accurately place semi-colons? Let EASYProcess do that. Now your staff can do what they do best: build useful applications for your customers and users.
• Creates SharePoint compatible webparts with complex workflow.
• Team Development Friendly. All versions of World & E1 compatible

It looks like this product could really help in making EnterpriseOne data available through SharePoint a trivial task.

EnterpriseOne Minimum Technical Requirements

Recently, I found that the Minimum Technical Requirements for Oracle EnterpriseOne to be a little difficult to track down. 

So I thought I should create a post about it here so that I don’t have to waste a bunch of time looking for it. 

If I remember I did this, anyway.

JD Edwards EnterpriseOne Current MTR Index (Doc ID 747323.1)

We had a user submit an issue last week that was a little baffling.

User: “When I try to access an application in EnterpriseOne all I get is the processing image.”

Us: “Does the ‘processing’ ever go away?”

User: “No.  It just sits there.”

Us: “um, ok. Let us do some checking and we’ll get back to you.”

Our PC support staff was able to remote into the PC and found that there was an “element not found” Javascript error.

The error was fixed by modifying the following registry entry:

HKEY_CLASSES_ROOT\TypeLib\{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}\1.1\0\win32

Replace the current value on the default setting from:

"C:WINDOWS\system32\shdocvw.dll"

to

"C:WINDOWS\system32\ieframe.dll"

We didn’t have to reboot for this setting to take effect, but you may have to.

Oracle Give Away Extended Support

I got this email this morning:

Dear JD Edwards EnterpriseOne Customer,

During the recent COLLABORATE conference Oracle President Charles Phillips announced that Oracle will waive first year Extended Support fees for certain product lines. This includes 8.11 and 8.11 SP1 for JD Edwards EnterpriseOne.

What is Extended Support?
Many JD Edwards legacy programs are supported under Oracle’s Lifetime Support Policy. This means that when Premier Support ends, you may continue to receive updates, and legislative and regulatory fixes for an additional three years under Oracle’s Extended Support. Please be sure to review Oracle’s Lifetime Support Policy for details regarding each JD Edwards release.

How Does this Affect You?
All customers currently using JD Edwards EnterpriseOne 8.11 and 8.11 SP1 will have the first year of their Extended Support fee waived. After that you will have the option of continuing your Extended Support service, and can contact your Support Sales representative to initiate the purchasing process.

For more information, please review the following article on MetaLink 3, NOTE: 778948.1, or contact Global Customer Support for further questions.

I wonder if you still get the HelpDesk101-type support when you first call?  I’m not trying to be negative, but you know what I mean:

• Have you applied all the ESUs?
• Have you modified the object?
• Are you on the latest Tools Release?
• Could you send me a full set of logs for both the web server and the enterprise server? – Yeah, sure. Have funning going through 2 GB of TEXT!

Anyway, it may be a good deal.

Add Record To OCM – F986101

The other day, I had a need to insert many records into the OCM (F986101).  So I set out to create a quick SQL statement that would serve that purpose.  Below is what I came up with:

INSERT INTO SY811/F986101                         

VALUES('DV811',0,'OBJECTNAME','LOCAL','','*PUBLIC',  

'*ALL','P','','H95','AV','SQL','BSFN',            

'USERNAME','','','',0,'',0,'','','','')            

Remember – you may have to make entries in both the SY811 and SVM811 F986101 files.

Access To Environments

To find out what users or groups have access to a certain environment run the following SQL:

select * from sy811/f0093
where llll='<enviornment>'    

To find out what environments a user or group has access to run the following SQL:

select * from sy811/f0093
where lluser='<userid>'    

Next Page »