Server Management Will Not Start After Update
Filed under: EnterpriseOne - General, EnterpriseOne - JAS (Java Application Server), Oracle Server Manager, Server Manager, enterpriseone
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 locationRename 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!
Tags: enterpriseone, enterpriseone, EnterpriseOne - General, EnterpriseOne - JAS (Java Application Server), jde, oracle, Oracle Server Manager, Server Manager, Server Manager, Tools Release, version, xeWeb Only Version Pain
Filed under: EnterpriseOne - General, EnterpriseOne - SQLs, eGen, sql
We seem to be having an issue with old “web only” versions. There are times when the “web only” version causes the other version to not egen correctly. So, below is the SQL that can be used to select the “web only” versions.
SELECT count(*) FROM COPD811/F983051 WHERE VRVCC2='1'
If you want to be more precise, you can grab the “web only” versions that have been executed prior to a certain date by using the VRVED field and the six digit date which can be found on the e1 dates page.
Tags: e1, eGen, eGen, EnterpriseOne - General, EnterpriseOne - SQLs, sql, sql, version, versions, xeHow To Find EnterpriseOne Web Only Versions
Filed under: Batch Versions, EnterpriseOne - General, EnterpriseOne - SQLs, eGen, enterpriseone
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:
where VRVCC2 =’1′
Batch Version (P98305W) Version Error
Filed under: EnterpriseOne - General, EnterpriseOne - Install/Upgrade, Tools Release, enterpriseone
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 dont do it. The second image is the Interactive Versions screen that you will need to use to delete the version.
Tags: batch version, e1, enterpriseone, EnterpriseOne - General, EnterpriseOne - Install/Upgrade, jde, Tools Release, Tools Release, version, versionsEnterpriseOne & 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.
Tags: e1, EASYProcess, enterpriseone, enterpriseone, jde, JDETips, version, versions, worldEnterpriseOne Minimum Technical Requirements
Filed under: EnterpriseOne - General, IBM i/System i/iSeries/AS400, Java, MetaLink, Minimum Technical Requirements, Oracle Server Manager, enterpriseone, oracle, websphere
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 dont 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)
| Application Packs |
| Application Management Pack |
| Business Intelligence |
| Oracle Business Intelligence Publisher |
| Oracle Embedded Business Intelligence Applications |
| Business Servers |
| Business Services Servers |
| Clients |
| EnterpriseOne 8.0/Xe |
| EnterpriseOne Tools 8.9x |
| Clients Pervasive |
| EnterpriseOne 8.0/Xe – Pervasive |
| EnterpriseOne Tools 8.9x – Pervasive |
| Cluster Servers |
| EnterpriseOne 8.0/Xe |
| EnterpriseOne Tools 8.9x |
| Collaborative Portal |
| Collaborative Portal 8.0/Xe |
| Collaborative Portal 8.9x |
| Crystal Report – Business Objects |
| Business Objects Enterprise XIR2 |
| Crystal Reports XIR2 |
| Database Software |
| EnterpriseOne 8.0/Xe |
| EnterpriseOne Tools 8.9x |
| Deployment Server |
| EnterpriseOne 8.0/Xe |
| EnterpriseOne Tools 8.9x |
| Disk Space |
| 8.9x Disk Space Requirements |
| Enterprise Servers |
| EnterpriseOne 8.0/Xe |
| EnterpriseOne Tools 8.9x |
| EnterpriseOne Integration |
| EnterpriseOne Integration Page |
| Extended Process Integration XPI |
| Enterprise XPI Foundation |
| JD Edwards EnterpriseOne 8.12 Integration Points |
| Enterprise XPI 8.11 Integration Points |
| EnterpriseOne 8.11 SP1 Integration Points |
| Mobile Tools |
| Mobile Client 8.9x |
| Mobile Synchronization Server 8.9x |
| PIM Sync Server |
| EnterpriseOne Tools 8.9x |
| Operational Consoles |
| Plant Manger’s Dashboard Version 8.12 |
| Plant Manger’s Dashboard Version 8.11 SP1 |
| Financial Management and Compliance Console Version 8.12 |
| Financial Management and Compliance Console Version 8.11 SP1 |
| Real-Time Events Server |
| EnterpriseOne Tools 8.9x |
| Supply Chain Planning (SCP) |
| EnpterpriseOne Supply Chaining Planning Page |
| Third Party Software |
| WebSphere MQ |
| Vertex Payroll Tax Q Series |
| Vertex Sales Tax Q Series |
| Terminal Servers |
| EnterpriseOne 8.0/Xe |
| EnterpriseOne Tools 8.9x |
| Virtualization |
| Oracle VM |
| Web Servers |
| EnterpriseOne 8.0/Xe |
| EnterpriseOne Tools 8.9x |
| Web Services Gateway Server (WSG) |
| Web Services Gateway server (WSG) |
| Information Websites |
| EnterpriseOne Xe |
| EnterpriseOne 8.0 |
| EnterpriseOne Tools 8.9x |
Clean Up Your Web-Only Versions
Filed under: EnterpriseOne - SQLs, IBM i/System i/iSeries/AS400, enterpriseone
We have been having some issues lately where users create web-only versions and expect to use them after a full package has been built and deployed.
We have processes in place for them to submit new versions to our development teams, but sometimes things dont happen the way they are designed.
Anyway, I was doing some checking and noticed that there were quite a few versions in the F983051 that were web-only versions and were older than the last full build.
So, I created an SQL that we are going to run immediately after the deployment of a new full package.
DELETE FROM <central objects>/F983051 WHERE VRVCC2='1'
***NOTE: the syntax used in the SQL statement is for the IBM System i (as400, iSeries)
Egen Process JDBJ Gotcha
Filed under: EnterpriseOne - JAS (Java Application Server), IBM i/System i/iSeries/AS400, JDBJ, eGen, enterpriseone
When setting up a workstation to perform the eGen process, once in a while there is a step that I seem to forget. It has to do with two settings in the JDBJ.INI file that need to be changed from their default values and JDBJ driver files:
- [JDBj-SPEC DATA SOURCE] This whole stanza needs to be commented out. If you dont, the eGen application will here for the location to which you want to generate your serialized objects, which is defaulted to the local MSDE database.
- [JDBj-JDBC DRIVERS] The values in this stanza are commented out by default. You will need to uncomment the drivers that are appropriate to your installation. For me, that is:
- AS400=com.ibm.as400.access.AS400JDBCDriver
- SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver
- JDBJ Driver Files The four files below need to be copied to the C:\e811\MISC directory.
- jt400.jar
- msbase.jar
- mssqlserver.jar
- msutil.jar
NOTE: This information is for Tools Release 8.97 and may be different for other versions.
Tags: as/400, eGen, eGen, enterpriseone, EnterpriseOne - JAS (Java Application Server), ibm, IBM i/System i/iSeries/AS400, JDBC, JDBJ, sql, Tools Release, version, versionsEnterpriseOne Tools Release 8.97 & 8.98 Not Compatible With FireFox 3
Filed under: EnterpriseOne - Install/Upgrade, EnterpriseOne - JAS (Java Application Server), MetaLink, oracle
In doing some last minute testing with EnterpriseOne Tools Release 8.97.2.0, I found that the applications do not render in FireFox 3. The error that I received in the WAS log is:
VTFormRenderAdaptee: renderHTML4: failed to render: java.util.MissingResourceException: Can't find bundle for base name nls.CPResource, locale
This issue is documented under MetaLink BUG 8917620 & 8917611. The final disposition that is documented as:
Tags: e1, enterpriseone, EnterpriseOne - Install/Upgrade, EnterpriseOne - JAS (Java Application Server), MetaLink, oracle, Tools Release, versionFixfox 3 does not work with e1 due to build id length
change in user agent string, and E1 fail to match it tofirefox pattern with shorter build date pattern.
The following is useragent string for
FF2: MOZILLA/5.0 (WINDOWS; U; WINDOWS NT 5.1; EN-US;
RV:1.8.1.17) GECKO/20080829 FIREFOX/2.0.0.17
FF3: MOZILLA/5.0 (WINDOWS; U; WINDOWS NT 5.2; EN-US;
RV:1.9.0.3) GECKO/2008092417 FIREFOX/3.0.3
Pattern in browsCap.ini for FF2
[*(Win*) Gecko/???????? Firefox/2.*]
Pattern in browsCap.ini for FF3
[*(Win*) Gecko/???????? Firefox/3.*]
With length of build id change from 8 digits to 10 digits
the matching does not work for firefox 3 and runtime fail
to render the E1 form. The solution is to change the match
patter to more generic format without length limitation of
build id by using single wildcard.
[*(Win*) Gecko/* Firefox/3.*]
The change shall be applied to all version of firefox start
from 3. And we may need to check the fix into 897, since
the customer may alread begin to use FF3 instead of FF2.
Quick EnterpriseOne Version Security Solution
Filed under: EnterpriseOne - SQLs, EnterpriseOne - Security
Whether you are trying to change the processing options of an interactive version or a batch version. Sometimes you can run into issues where the application indicates that you do not have authority to change the version like the example to the left.
To quickly get around this error, we can use SQL to change the security setting in the F983051.
UPDATE CODV811/F983051 SET VREXCL = 0 WHERE vRPID = 'P03B2002' AND VRVERS = 'TEST0001'
Tags: batch version, e1, enterpriseone, EnterpriseOne - Security, EnterpriseOne - SQLs, security, sql, version
