E1 Tips The Tips & Tricks of a CNC Administrator on Oracle JDEdwards EnterpriseOne

Posts Tagged ‘as/400’

How To Start/Stop The Managed Agent On AS400

You can start/stop the managed agent from the command line (green screen) by following the steps below: Start the QSHELL by typing STRQSH at the command prompt. Change to the JDE_HOME/bin directory by typing <install_dir>/JDE_HOME/bin. *** The <install_dir> refers to the installation directory in the IFS To start the agent enter: startAgent & *** The ...

EnterpriseOne Tools Release Upgrade From 8.96 to 8.97 Rough Outline

IBM iSeries/AS400/System i Backup libraries and IFS directories Register Pristine Environment in Server Manager Create Server Manager Server Group for Pristine Upgrade Pristine Web Server Create IBM WebSphere Application Server in Server Manager Create IBM HTTP Server in Server Manager General HTML landing page: update links and info Change DNS entries Copy the code used ...

Clean Up Your Web-Only Versions

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 don’t happen the way they are designed. Anyway, I was doing ...

Egen Process JDBJ Gotcha

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 ...

EnterpriseOne 8.97 Install Host Table Hic-Up

While installing EnterpriseOne 8.97 on one of our instances, we ran across an issue that was pretty puzzling to both us and Oracle’s Global Support Services group. We had successfully installed both the Server Manager Console and the Enterprise Server (System i, iSeries, AS/400) Management Agent.  When everything is working correctly, the Enterprise Server Management ...

Multi Threaded Kernel Issue When Upgrading To EnterpriseOne Tools Release 8.97.2.0

We ran into an issue when upgrading our EnterpriseOne Tools Release from 8.96.1.5 to 8.97.2.0.  In order for the multi-threaded kernels to run correctly there is a setting in the JDE.INI file that needs to be set, SQLServerMode. The error that I was getting was like the following: ConnectDB:Unable to connect to DS ‘XXXXXXX – ...

CNC Certification and Consulting

06.27.2008 · Posted in EnterpriseOne - General

If you pay attention to threads on JDEList, every once in a while someone will inquire about the availability of CNC Certification.  Usually, these inquiries are met with the an answer generally like: No, there are no "official" certifications. The latest inquiry was from Spider006.  Essentially, he just wanted to know what some good "supporting" ...

Escape From SQL

05.12.2008 · Posted in EnterpriseOne - SQLs

The other day, one of my coworkers was presented a question from our development team: How can I use SQL to look for a "%" in a column? Well, the first guess is to use something like: SELECT * FROM MYLIB/MYFILE WHERE MYCOL LIKE '%%%' or SELECT * FROM MYLIB/MYFILE WHERE MYCOL LIKE '%%%' Well, ...