Leggo My EnterpriseOne (E1) Object!

While trying to delete an object the other day, I received the ever-helpful “Object exists in an active project” error. Since our developers have created a few hundred OMW projects, I didn’t want to go searching through every project to see where this object was. I realize that I should have been able to look at the News/Status tab and get the info, but it didn’t seem to be working.

Anyway, I used the following SQL to get the info (iSeries syntax):

select * from sy811/f98222 where POOMWOBJID like '[object_name]%'

iSeries Audit Journal

Use the following command to display the contents of the audit journal on the iSeries:


This is very useful when researching security issues.

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

EnterpriseOne (E1) UDC Cache

Ok, you experts probably already know this, but…

When a user adds or changes a UDC entry, it can’t be used until the cache is cleared.

How do you do that? Well…

  1. Go to SAW
  2. Change to the “Work with JDBj” view
  3. Using the “Data Refreshing” dropdown, choose “Service cache”
  4. You will receive the following message:
    1. “You asked to refresh the JDBj Service cache!
      This option will flush UDC cache, User reference cache and Rules.
      Are you sure you want to continue with this action?”
  5. Click the arrow button to continue
  6. Have your user test to confirm that it worked

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

The bluehost as well as the hostgator are both excellent hosting options for an e-business.

iSeries JDBC jt400.jar – {note to self}

Excerpt from a post on JDEList.com by Colin Dawes:

You CAN NOT use the jt400 from the client access folder.

You need to use the jt400 that is on your iSeries. The 2 versions are not the same and you’ll get some hanging if you use the iSeries Access version.

The jt400 on the iSeries is located at:

Usually you need to copy this to the following location on Windows:

I say usually because sometimes during the installation prople point the installed to the iSeries Access Path. In this case the WAS variable will be incorrect and you either need to (1) Change the variable in WAS or copy the jt400.jar from the iSeries on top of the jt400.jar that came with iSeries Access.

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

FTP & iSeries

Ok, we have some UBEs that run and they produce a text file in the IFS System on our i550. In the processing options of these UBEs, the user can specify the name that they would like the file to have. Since their UI to the system is through the web, when they put in things like “c:401k.txt” or “c:insmembers.txt” the file gets placed into the root of the IFS system as a file with the name “c:401k.txt” or “c:insmembers.txt”. They look very strange in iSeries Navigator. And, oh by the way, you can’t delete them. The only way that I have found to delete them is by using the windows command line FTP. Here is what I do to get rid of them:

  1. Once logged in through FTP, type quote site namefmt 1 to change to the IFS naming format. You’ll notice that, if you do a pwd, the working directory is “/QSYS.LIB/QGPL.LIB”.
  2. You need to get to the root so, type cd .. [ENTER] cd .. [ENTER]. You should get a response that says your current directory is “/”.
  3. Then either use del or mdel and delete the files.

More on switching between the library file system and the directory file system when FTPing an AS400:

quote site namefmt [0|1]

  • Summary:
    • 0 – specifies the library file system
    • 1 – specifies the directory file system
  • Detail:
    • NAMEFMT 0 | 1 : Specifies the naming
      format that identifies file locations inside your FTP session.
      • NAMEFMT 0 assumes that you?re only copying
        files into and out of the QSYS.LIB file system using the DB2 UDB naming format of
      • NAMEFMT 1 is used for identifying files
        in all IFS file locations, and all files or locations must be listed in IFS notation
        (like /home/dir, /QOpenSys/dir, /QDLS/dir, /QSYS.LIB/dir.lib/file.file). To view the
        current NAMEFMT values for your FTP session, type NAMEFMT or QUOTE SITE NAMEFMT without
        any parameters.

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards