Jeff Stevenson's Technology Blog

SQL Server Most Utilized Tables

2011-10-13T22:54:00.000-04:00

Ever wondered which tables in your databases are being used most heavily? Below is a script for SQL Server 2005/2008 that will tell you exactly that - which tables are utilized most and what percentage of that use is reads and what percentage is writes. Heavily utilized tables are prime candidates for SQL Server's Table Partitioning or moving to another filegroup (not necessarily recommended

Auto Open PDF's in EnterpriseOne Web Client

2011-09-21T17:38:00.000-04:00

There has always been an issue opening PDF files from the Work with Submitted Jobs list in the EnterpriseOne web client - the end user is prompted to determine what they wish to do with the file when, chance are very good that they want to open it. The problem is related to how the PDF content is delivered to the browser by the E1 code and how the browser handles that content. Full disclosure:

EnterpriseOne Temporary Print Files on Enterprise Server

2011-09-07T14:33:00.001-04:00

Your EnterpriseOne system may be creating hundreds of thousands of files on your JD Edwards Enterprise Server in a location that is not readily apparent and not cleaning them up...ever. During a UBE run that involves a version that has Print Immediate turned on at the version level (introduced in TR 8.96) a 'temporary' print definition file (either PostScript or PCL depending on how you defined

EnterpriseOne JAS and JDEROOT Log Files on Enterprise Server

2011-09-02T15:10:00.001-04:00

It is well known that JD Edwards EnterpriseOne splatters logs and temporary files all over the place. As the application has gotten more complex with added components such as Web servers, Java Application servers, Server Manager, etc. the sheer number of log files generated in wildly varying locations has notably increased and keeping track of and managing all these logs files is a chore.

EnterpriseOne 9.0 SQL Server Collation Issues

2011-08-29T22:41:00.000-04:00

Starting in EnterpriseOne 9.0 the platform pack delivers pre-built databases that are simply attached and are set to a collation of Latin1_General_CI_AS_WS when created at Oracle. This collation is different than the default SQL Server collation and different than the old (pre-9.0) collations. Because of this, you will usually find a mix of collations on an E1 install, particularly upgrades.

LiteSpeed Object Level Recovery Performance Enhancement

2011-07-28T19:14:00.004-04:00

I recently had the opportunity (if you'd call it that) to utilize LiteSpeed's Object Level Recovery functionality on a large (~500GB) database and was somewhat surprised at the poor performance. An end user had run a report in the JD Edwards EnterpriseOne application with incorrect settings, corrupting a table to the point where we needed the data from prior to the report run. Object Level

Windows 2008's Magic Performance Button

2011-06-16T11:53:00.034-04:00

Who knew changing a single setting away from the default in Windows 2008 would result in an increase of 70% in performance? That's exactly what happened recently at a client experiencing JD Edwards EnterpriseOne UBE performance issues during upgrade testing. We were able to make UBE's that previously ran in 10 minutes run in less than 3 minutes simply by changing a setting on only the SQL

EnterpriseOne Table List With Column Information

2011-03-31T22:08:00.003-04:00

I recently saw a request for a complete list of EnterpriseOne tables with column specifications and other information. Getting these details using a SQL script is not simple since JD Edwards seems to violate several standards in SQL-92 and database normalization best practices. Since the required information is not kept in one table it is necessary to use SQL joins and foreign key relationships

Tether Your Verizon Blackberry to an iPad Using Bluetooth

2010-12-24T21:17:00.006-05:00

I recently setup my iPad to use bluetooth to connect to my Verizon Blackberry Tour 9630 so I could access the Internet (and my customer's VPN's) from anywhere I can get cell reception. Doing this requires you to "Jailbreak" your iPad, a process that opens up the device for non-Apple approved software. This is not an action that everyone will want to do, but then again not everyone wants to use

SQL Server - Members of db_datareader not in db_denydatawriter

2010-11-02T13:53:00.005-04:00

In an earlier series of articles on EnterpriseOne SQL Server default security we discussed the issue of Oracle granting permissions to PUBLIC that created a security exposure when placing users in the SQL Server db_datareader database role. I advised you to place any user of an E1 database that is in the db_datareader role in the db_denydatawriter role also. However, I didn't leave you with any

Default SQL Permissions in EnterpriseOne Part 3

2010-10-10T22:29:00.014-04:00

As mentioned in parts 1 and 2 of Default SQL Permissions in EnterpriseOne the permissions granted in EnterpriseOne databases during the install leave quite a security exposure. Those articles covered in depth the reasons for this and ways to address the problem. This article will detail two more items of concern: database level permissions set by the install and Guest user access from a

Default SQL Permissions in EnterpriseOne Part 2

2010-10-07T10:22:00.003-04:00

In Default SQL Permissions in EnterpriseOne Part 1 we discussed the problem with granting ad-hoc SQL logins access to EnterpriseOne databases and how doing so gave them rights to modify data. In part 2 we are going to demonstrate this effect in hopes of creating a better understanding of exactly what is going on. Afterward I will offer some suggestions to work around and/or remedy the

Default SQL Permissions in EnterpriseOne Part 1

2010-10-03T22:08:00.010-04:00

So you've gotten EnterpriseOne installed or have had it installed for a long time and you've finally changed the default E1 SQL user (CRPDTA, DD812, PRODCTL, etc.) passwords in SQL Server. If you haven't at least done that you should stop right here and go change those passwords using the article E1: DB: How to Change the Database Object Owner Passwords for EnterpriseOne Databases [ID

Partial Cross Reference Rebuild in EnterpriseOne

2010-08-22T16:12:00.004-04:00

Completely rebuilding the tables used by the Cross Reference Facility application in EnterpriseOne is a large, complex process that can take a long time to run. There is a way to shorten the run time of the rebuild but selecting only those objects changed since the last run. The Cross Reference Facility application (P980011) in EnterpriseOne gives developers and administrators information about

Restarting the EnterpriseOne Queue Kernel

2010-08-17T11:34:00.003-04:00

There is a way to restart just the UBE queue in EnterpriseOne. If you are faced with a situation where submitted jobs are not processing and the jobs are sitting in a waiting status you can get the queue restarted without bringing down the entire E1 system, allowing interactive users to continue their work. In older (prior to 8.9) releases the queue was a separate Windows service called JDE

How Large Are My Tables?

2010-07-07T23:55:00.018-04:00

Sometimes I am beating around on a SQL script that I really want to share with others. A couple of scripts I wrote to show the largest tables in a database and the largest tables in all databases on a SQL server is a perfect example.The scripts make extensive use of the SQL 2005/2008 dynamic management view sys.dm_db_partition_stats. This view displays information about the space used to store

Disable Indexes During SQL Import

2010-05-22T16:36:00.014-04:00

SQL Server indexes are useful objects, greatly decreasing the time needed to find and return data in database tables. Unfortunately, the opposite occurs during record inserts to tables with indexes. When one is inserting a record or two, or even a hundred, the penalty generally isn't large enough to warrant spending time disabling the indexes to improve the insert operation performance.

Now Featured on Quest's Blog Roundup

2010-05-20T16:30:00.001-04:00

Jeff Stevenson's Technology Blog is now featured on Quest's Blog Roundup. Quest International is the customer-driven group supporting Oracle applications users, including PeopleSoft, JD Edwards and Oracle Utilities and their Blog Roundup highlights relevant blogs in the community. Check out the Blog Roundup http://www.questdirect.org/questdirect/Connect/Blog+Roundup.htm and the main Quest site

Tools Release 8.98.3 Information

2010-05-03T17:00:00.005-04:00

I have posted the first in a series of articles on the soon-to-be released Update 3 for Tools Release 8.98 over on The Karamazov Group's blog, where strategy items are published. The first article in the series can here found here: http://blog.karamazovgroup.com/2010/05/enterpriseone-tools-release-8983-notes.html Second article: http://blog.karamazovgroup.com/2010/05/

Bypassing EnterpriseOne Menu-Based Security in the Web Client

2010-03-22T17:16:00.014-04:00

A certain philosophy exists within the JD Edwards ecosphere where some believe that instead of doing the hard work to properly secure an EnterpriseOne system they can instead configure the menu in such as way as to "hide" applications from users. This is perhaps based on a couple of faulty premises - that menu configuration is easier than security configuration and that users will not be able to

(Very) Old Style EnterpriseOne Environment Refresh

2010-03-09T10:00:00.003-05:00

Back in the day whole environment refreshes were commonplace, utilized both as a go-live step and as a way of ensuring that environments before PD in the SDLC were synchronized. It worked and in the absence of a true object management tool, was pretty useful. Whole methodologies developed around this practice. With the introduction of OMW and subsequent understanding of how to manage a SDLC in

Identify SQL Table Backups

2010-01-03T17:17:00.009-05:00

Earlier we discussed methods for executing quick SQL table backups and performing quick SQL table restores as a way to mitigate risk to data during certain operations. In this article we are going to discuss some low-effort housekeeping methods to keep us from forgetting about the table backups we created. While it is not a huge deal that a few table backups are hanging out in your databases,

Quick SQL Table Restore

2009-12-07T20:09:00.015-05:00

A while back I discussed a method to do quick SQL table backups. I usually create backups of tables prior to taking an action that has the potential to create the need to restore that table's data. It's just a good idea, is easier than taking a full backup and gives you a readily available source of the original data should something go wrong with the changes you make. Not that it has ever

Data Selection Security in EnterpriseOne

2009-12-03T23:25:00.002-05:00

One of newest types of security for JD Edwards EnterpriseOne is Data Selection security. Using Data Selection security CNC administrators can secure users from modifying, adding, deleting, and viewing the data selection for batch applications or specific versions of batch applications. Data Selection security was made available with Tools Release 8.98 Update 1 (8.98.1.0) and has a minimum

Adding a Large Number of Objects to an OMW Project in EnterpriseOne

2009-11-13T09:39:00.034-05:00

Occasionally it is necessary to place a large number of objects in an EnterpriseOne Object Management Workbench project. The default method of selecting a single object in the right pane and clicking the left arrow to add an object to a project is cumbersome but not a huge issue for an object or two. After about ten objects though and the interface gets tiresome. A typical use that