Development

The EnterpriseOne Development category will include all posts and pages pertaining to the development of EnterpriseOne applications, reports, table conversions, integrations, etc.

 

Better Performance On Work with Payroll Transaction Ledger (P050999) With An Index On F0618

We have been getting complaints about the Work with Payroll Transaction Ledger (P050999) grid loading performance.  So, I decided to take a look.  What I found was that upon entering the application it does an automatic find on the grid using the following SQL statement with the current G/L date in the WHERE clause.

As you can see, this SQL statement is returning every record in the F0618 that has a G/L Date less than or equal to the system’s current G/L Date.  I don’t know about your installation but the one that I was working on had 17+ million records.  Why the heck would it need to return all that?

That screen was taking 8+ minutes to present information to the user.

With the help of my coworker Geordy and Technet, I came up with an index on the F0618 that didn’t make the SQL statement finish any quicker, but it does present the user the first page of data extremely fast (LESS THAN 3 SECONDS!).

You can see from the index that all I did was create an index over the field that the SQL was sorting on (YTDWK or Date of Work) and included the rest of the fields that were in the query.

There must be other little tricks with indexes in EnterpriseOne.  Have you found any?

 

VBScript To Insert Values Into UBE Data Selection List Of Values

First off… Shannon Moir ROCKS!

He has put together a VBScript that will insert a list of values into the UBE Data Selection List of Values text area on a fat client. If you do much data migration or data refresh work this script will really help.

Recover Lost Disk Space

We currently share development clients and so there can be many people that use each one. Several times some of those clients have filled their C: drives and I have been unable to find where it went. I checked user desktops, downloads, etc. However, I was unable to find anything.

Then, I ran across a simple command that can empty the recycle bins of every user on the PC and help you recover your lost disk space:

Hopefully, writing this little tip here will help me remember and maybe help someone else that has lost disk space and doesn’t know where it went.

Error Installing An Update Package On An E1 Development Client

imageEvery once in a while we get errors when installing update packages on our E1 Development Clients.

An error occurred during the interview for this component. EnterpriseOne Development Client 1.0.0.0.5. The selected package is not valid. Please see log…

So, we go check the log and we see entries like the following that refer to an old full package:

INFO: 01/23/14 10:10:13.731 Cannot get information about the database from file E:\E910\package.inf. Empty file name for DataFileDestDirSPEC_DV910D00
INFO: 01/23/14 10:10:13.731 Cannot get information about the database.  Reason: Cannot get information about the database from file E:\E910\package.inf. Empty file name for DataFileDestDirSPEC_DV910D00
INFO: 01/23/14 10:10:13.731 Cannot get information about the database from file E:\E910\package.inf. Cannot get information about the database.  Reason: Cannot get information about the database from file E:\E910\package.inf. Empty file name for DataFileDestDirSPEC_DV910D00
INFO: 01/23/14 10:10:13.732 Cannot get information about the package’s database. Cannot get information about the database from file E:\E910\package.inf. Cannot get information about the database.  Reason: Cannot get information about the database from file E:\E910\package.inf. Empty file name for DataFileDestDirSPEC_DV910D00
INFO: 01/23/14 10:10:13.732 Package validation failed. An existing package is installed, but we cannot get information about it from the file E:\E910\package.inf. Cannot get information about the package’s database. Cannot get information about the database from file E:\E910\package.inf. Cannot get information about the database.  Reason: Cannot get information about the database from file E:\E910\package.inf. Empty file name for DataFileDestDirSPEC_DV910D00
INFO: 01/23/14 10:10:13.733 Validation of package in file \\WC-CORP-VMDEPLY\E910\package_inf\PD910E00.inf failed!!! Package validation failed. An existing package is installed, but we cannot get information about it from the file E:\E910\package.inf. Cannot get information about the package’s database. Cannot get information about the database from file E:\E910\package.inf. Cannot get information about the database.  Reason: Cannot get information about the database from file E:\E910\package.inf. Empty file name for DataFileDestDirSPEC_DV910D00

The errors continually reference the package.inf file, so we go check that out.  There is only one reference to our old full package (DV910D00). It is in the following stanza:

[Oracle Databases]
SPEC_DV910D00=ORACLE
JDELocal_DV910=ORACLE
SPEC_DV910G00=ORACLE
JDELocal_PY910=ORACLE
SPEC_PY910G00=ORACLE
JDELocal_PD910=ORACLE
SPEC_PD910E00=ORACLE

So, it looks like the old package was not completely removed.  We delete that line from the package.inf file and everything works perfectly.

E1 Development Clients can really be a pain in the butt!