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

Archive for the ‘IBM i/System i/iSeries/AS400’ Category

How To Copy OCM Records From One Environment To Another Using SQL

This method can be used to copy any records in a database but the issue that I was trying to resolve was to copy 8 records in the Object Configuration Management (OCM) file, F986101, of one object to another object. INSERT INTO SY900/F986101( OMENHV, OMOBNM, OMDATP, OMUGRP,OMOAPP, OMDATM, OMSY, OMSTSO, OMPID, OMFUNO, OMUSER, OMJOBN, OMOCM2, ...

End Of Line (EOL) Character Encoding Using CP1252 and B34A1010

If using encoding CP1252 (ASCII), the EOL character is only LineFeed (hex 0A) and therefore, the flat file transferred during FTP also contains LineFeed. If the EOL characters Carriage Return (hex 0D) and LineFeed (hex 0A) are required in the flat file, use encoding IBM-37 instead and the FTP download from the AS/400 to the ...

Trigger Library JDBTRG1 or JDBTRIG Not Found

Every once-in-a-while we get an error on the Enterprise Server that is similar to the following: 2339/472 MAIN_THREAD Fri Jul 24 14:57:19.994104 jdb_trig.c396 JDB3800024 – Trigger Library JDBTRG1 not found/loaded for table F0015. 2339/472 MAIN_THREAD Fri Jul 24 14:57:19.994696 jdb_trig.c391 JDB9900886 – Fallback Trigger Library JDBTRIG not loaded. 2339/472 MAIN_THREAD Fri Jul 24 14:57:19.994840 jdb_trig.c391 ...

How To Manually Disable WebSphere Admin Console Security

In trying to setup Tools Release 8.98.3.2, I ran across an issue where the Server Manager would not install a J2EE server for an EnterpriseOne HTML server to be installed to. In order to fix the issue I had to disable the Websphere Admin Console Security. The steps below are what I followed: Make a ...

How To Build A SRVPGM Using The Command Line

The other day we had an issue with building a full package for one of our EnterpriseOne installations.  The issue was related to not having the same tools release active on both the Deployment Server and the Enterprise Server. However, I found something rather interesting.  You can build an individual package DLL or SRVPGM on ...