Install/Upgrade

The EnterpriseOne Install/Upgrade category will include all posts and pages pertaining to the installation and upgrade of EnterpriseOne.

Oracle JD Edwards EnterpriseOne Multi-Foundation

EnterpriseOne Multi-Foundation

Oracle JD Edwards EnterpriseOne Multi-Foundation configuration is used to run at least two separate tools releases on the same installation. This is usually done to facilitate an environment or pathcode that can be updated to a new Tools Release without effecting your production environment.

It’s also a great way to remove the dependency of your production environment and non-production environments being on the same set of EnterpriseOne services. That means you can bounce non-production services without effecting production. This is great for troubleshooting as well as applying OS updates.

The easiest way to setup multi-foundation is to follow the steps outlined in the following Oracle doc: Working With Multiple Tools Release Foundations

Do you have an tips or tricks when it comes to working with EnterpriseOne Multi-Foundation?

Submit a Tip or Trick

Finding The Row Count For All Files In An iSeries Library And All Tables In An SQL Server Database

Ive been moving several EnterpriseOne databases to SQL Server lately. In order to do a quick check to make sure that all the data was transferred, I like to compare the number of rows on all the tables. Below are the SQL queries that I use to get a row count on all tables in a database and all files in a library:

iSeries SQL query to get a row count on all files in an iSeries library:

SELECT TABLE_SCHEMA, TABLE_NAME,NUMBER_ROWS
FROM QSYS2.SYSTABLESTAT
WHERE TABLE_SCHEMA = 'PRODDTA'
AND NUMBER_ROWS > 0
ORDER BY NUMBER_ROWS DESC, TABLE_NAME DESC

NOTE: the iSeries SQL query is easiest to do from System i Navigator because you can easily copy the records into Excel.

SQL Server SQL query to get a row count on all tables in an SQL Server database:

SELECT '[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' AS fulltable_name,
SCHEMA_NAME(t.schema_id) AS schema_name, t.name AS table_name,i.rows
FROM sys.tables AS t
INNER JOIN sys.sysindexes AS i ON t.object_id = i.id
AND i.indid > 2
WHERE i.rows > 0
ORDER BY i.rows DESC, t.name DESC

UPDATE: The following SQL statement will not only give you the row counts of all the tables in the SQL Server database it will also give you the amount of disk space that it is taking:

SELECT 
    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8/1024 AS TotalSpaceMB, 
    SUM(a.used_pages) * 8/1024 AS UsedSpaceMB, 
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8/1024 AS UnusedSpaceMB
FROM 
    sys.tables t
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
    sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN 
    sys.schemas s ON t.schema_id = s.schema_id
WHERE 
    t.NAME NOT LIKE 'dt%' 
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255 
GROUP BY 
    t.Name, s.Name, p.Rows
ORDER BY 
    TotalSpaceMB desc, t.Name 

Are there any methods that you use to do a quick data integrity check?

Oracle JDEdwards Tools Release 9.1.5 Is Now Available

Description of Figure 3-1 follows

This is no ordinary Tools Release!  With all the changes, this should really be called TR 9.2.0.

Lets start breaking this down a little

  1. A new look, called Alta (see image above). This brings JDEdwards more in line with the rest of Oracles application offerings with the same look and feel.
  2. Server-only packages and the Primary Server
  3. Recent Breadcrumbs: You can view breadcrumb history which is available even after you log off/on.
  4. Email and Calendar Integration: Personally, I think the advantage of this feature will really be for user support rather than user collaboration.
  5. Simplified Navigation: seems to restrict users to just using E1Pages for navigation.
  6. Clustering for Outbound Business Services
  7. In-Memory Merge to Tools 9.1.5 Code Line
  8. Application Stack Service for Mobile Applications Development

Oracles official announcement: Oracle Announces JD Edwards EnterpriseOne Tools Release 9.1 Update 5 and Application Enhancements (1952442.1)

Net Change for Tools Library, Release 9.1 Update 5 (OTN)

JD Edwards EnterpriseOne Tools and Technology 9.1.x Documentation Overview (Doc ID 1368172.1) has been updated with the Tools 9.1.5 information

JD Edwards EnterpriseOne Tools 9.1 Update 5 Documentation Updates for Installation and Upgrade Guides

Required Components for installing 9.1.5 (Doc ID 1943409.1) including a table of ESUs required to take advantage of the new features.

9.1.5 Known Issues and Workarounds (Doc ID 1945082.1)

In-Memory Tools C API Reference (Doc ID 1952465.1)

OTHER 9.1.5 docs about changes:

  1. Where are the Navigator, Fast Path, Personalization and Roles options in Tools Release 9.1.5 (Doc ID 1950336.1)
  2. 9.1.5 Server-Only Package documents:
    • Server Only Packages Functionality From EnterpriseOne Tools Release 9.1.5 Onwards (Doc ID 1947622.1) a presentation from INFOCUS on the new package build process is linked from this document
    • FAQ, Known Issues, and Troubleshooting Server Only Packages Functionality From EnterpriseOne Tools Release 9.1.5.0 Onwards (Doc ID 1950295.1)
    • SRDC – Data Collection for Troubleshooting a Package Build Issue with Tools Release 9.1.5 Enhanced Package Build Process (Doc ID 1931514.1)

ESU Cleanup

Since our installations of EnterpriseOne were installed and the data upgraded we have applied and installed thousands of ESUs. On 4 of the 7, we neglected to apply the ESUs to the Pristine pathcode (PS900/PS910). This made researching code changes a bit of a challenge.

So, the other day, I decided to rectify that and apply the many, many ESUs to Pristine. Because there were some very old ESUs and not all of them were registered with Change Assistant, it was a very time consuming. After I had finished, I noticed that there were several ESUs that had only been applied to PS & PD and others that had only been applied to PS, DV & PY. Rather than look through every ESU and risk missing some, I connected to E1LOCAL and wrote a SQL statement to get every ESU that had been applied to the system that was not in every pathcode.

Please see “Use Oracle SQL Developer To Modify The JDE LOCAL Database” for connection instructions.

SELECT * FROM (
	SELECT A.SDPKGNAME AS ESUNAME, 
		A.SDSUDFUT2 AS SYS, 
		PS.SDSUDFUT2 AS PS910, 
		DV.SDSUDFUT2 AS DV910, 
		PY.SDSUDFUT2 AS PY910, 
		PD.SDSUDFUT2 AS PD910 
	FROM F9671 A
	LEFT JOIN F9671 PS 
		ON A.SDPKGNAME = PS.SDPKGNAME 
		AND PS.SDSUDFUT2='PS910' 
		AND PS.SDSUDET = '90'
	LEFT JOIN F9671 DV 
		ON A.SDPKGNAME = DV.SDPKGNAME 
		AND DV.SDSUDFUT2='DV910' 
		AND DV.SDSUDET = '90'
	LEFT JOIN F9671 PY 
		ON A.SDPKGNAME = PY.SDPKGNAME 
		AND PY.SDSUDFUT2='PY910' 
		AND PY.SDSUDET = '90'
	LEFT JOIN F9671 PD 
		ON A.SDPKGNAME = PD.SDPKGNAME 
		AND PD.SDSUDFUT2='PD910' 
		AND PD.SDSUDET = '90'
	WHERE A.SDSUDFUT2='ALL' 
		AND A.SDSUDET ='10'
	ORDER BY A.SDPKGNAME DESC
)
WHERE PS910 IS NULL
	OR DV910 IS NULL
	OR PY910 IS NULL
	OR PD910 IS NULL