tag:blogger.com,1999:blog-79585693459347147892009-11-08T21:02:23.932-05:00JD Edwards EnterpriseOne, SQL Server, WebSphere and other technologiesJeff Stevensonnoreply@blogger.comBlogger27125JeffStevensonsTechnologyBloghttp://feedburner.google.comSubscribe with My Yahoo!Subscribe with NewsGatorSubscribe with My AOLSubscribe with BloglinesSubscribe with NetvibesSubscribe with GoogleSubscribe with PageflakesSubscribe with PlusmoSubscribe with The Free DictionarySubscribe with Bitty BrowserSubscribe with NewsAlloySubscribe with Live.comSubscribe with Excite MIXSubscribe with Yourminis.comSubscribe with Attensa for OutlookSubscribe with WebwagSubscribe with netomat HubSubscribe with Podcast ReadySubscribe with FlurrySubscribe with WikioSubscribe with Daily Rotationtag:blogger.com,1999:blog-7958569345934714789.post-5940700760094747882009-10-11T21:19:00.000-04:002009-11-08T21:02:23.944-05:00

Troubleshooting a UBE on the enterprise server in E1 has always been difficult. Even more difficult when the users are on the web client.  Debugging without causing some sort of interruption for other web users was nearly impossible.  Gathering certain information about how a job was submitted, such as processing options and data selection was also difficult and determining whether a

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2009/10/ube-introspection-dynamic-ube-logging.htmltag:blogger.com,1999:blog-7958569345934714789.post-35373379298253815472009-09-29T13:38:00.003-04:002009-09-29T14:41:53.412-04:00

An opportunity to clarify E1 Business Accelerator (fka Product Packaging) came in the mailbox today:Back in Oct 08, you made a blog entry (http://blog.karamazovgroup.com/2008/10/jde-e1-technical-task-force.html) regarding a JDE E1 Technical Task Force conference which uncovered the Statement of Direction for 8.98. Included in Oracles SOD was Product Packaging improvements. You referred to them as

Jeff Stevensonnoreply@blogger.com2http://jeffstevenson.karamazovgroup.com/2009/09/enterpriseone-business-accelerator.htmltag:blogger.com,1999:blog-7958569345934714789.post-48412529996206286522009-09-16T16:04:00.019-04:002009-09-17T21:35:22.180-04:00

Denver's Server Manager product is the new(er) method for managing all aspects of EnterpriseOne servers - monitoring, configuration, tuning and logging, etc. CNC administrators can now modify settings, see what's happening on their system and do logging all in one interface . In particular the logging enhancements are worthy of mention. I will show that while Server Manager is a great tool,

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2009/09/enterpriseone-user-specific-dynamic.htmltag:blogger.com,1999:blog-7958569345934714789.post-48011953196185424502009-09-02T23:15:00.014-04:002009-09-04T09:50:32.626-04:00

With the change to table-based, XML-format metadata (formerly specs) in EnterpriseOne, first-use dynamic e-generation became a performance issue, impacting end users after a package deployment and affecting their perception of system performance. This article describes an easy method of lessening this impact.A very short primer on auto package discovery and dynamic egeneration as it applies to

Jeff Stevensonnoreply@blogger.com1http://jeffstevenson.karamazovgroup.com/2009/09/rebuild-sql-indexes-in-package-tables.htmltag:blogger.com,1999:blog-7958569345934714789.post-28535862770539467772009-08-05T11:57:00.011-04:002009-09-04T09:56:52.145-04:00

Permissions in SQL for E1 are granted thru the System User/Multiplexing User's (JDE usually) membership in the database role PUBLIC.The PUBLIC database role has Create Table permissions.The PUBLIC database role has SELECT, INSERT, UPDATE, DELETE permissions on all tables within the database.The object owner (PRODDTA, PRODCTL, etc.) database role has explicitly granted object permissions to allow

Jeff Stevensonnoreply@blogger.com1http://jeffstevenson.karamazovgroup.com/2009/08/enterpriseone-sql-security.htmltag:blogger.com,1999:blog-7958569345934714789.post-52959375179565724502009-07-28T11:07:00.004-04:002009-09-04T09:50:58.963-04:00

From the mailbag came the following question that I thought I would answer for everyone:"Hi Jeff, what do you recommend for Oracle CNC training?"My answer:Depends on who it is for. A new CNC guy should have his training tailored and more importantly, timed to coincide with what they are doing on the system.Common Foundation will provide the CNC trainee with the basics of E1 and should be taken

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2009/07/enterpriseone-cnc-training.htmltag:blogger.com,1999:blog-7958569345934714789.post-79851083659762883822009-06-09T11:30:00.009-04:002009-09-04T09:57:25.849-04:00

What we (you, me, everyone in the JD Edwards universe) have always referred to as "Julian Date" is actual an Ordinal Date.http://en.wikipedia.org/wiki/Ordinal_dateIt is not, however, an ISO 8601 compliant Ordinal Date as ISO 8601 requires the use of 4 digit years.http://en.wikipedia.org/wiki/ISO_8601#Ordinal_datesThe Julian Date is actually "...the interval of time in days and fractions of a day,

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2009/06/jd-edwards-julian-date.htmltag:blogger.com,1999:blog-7958569345934714789.post-43739281404478878792009-06-08T18:49:00.013-04:002009-09-04T09:57:42.456-04:00

Occasionally one needs to perform an action in either EnterpriseOne or SQL Server that places the data in one or more tables at risk. Examples include an index or (obviously) a table generation in OMW, a direct update to the data using a query, the first run of a custom UBE that updates data, etc. Best practices dictate that you should get a backup of the data.Rather than using the time

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2009/06/quick-sql-table-backup.htmltag:blogger.com,1999:blog-7958569345934714789.post-37543913018943197742009-03-26T13:32:00.021-04:002009-10-25T13:53:24.466-04:00

.nobrtable br { display: none } No downtime, middle of the day full serialized objects generation. When CNC admins have time to sleep they dream of getting more sleep. They imagine that there is the possibility of performing administrative tasks at some time of the day other than during The Maintenance Window. Generating a full set of serialized objects is not as critical as it was prior

Jeff Stevensonnoreply@blogger.com5http://jeffstevenson.karamazovgroup.com/2009/03/creating-and-using-alternate-serialized.htmltag:blogger.com,1999:blog-7958569345934714789.post-86678596182709028572009-03-24T15:06:00.012-04:002009-09-04T09:58:13.113-04:00

In IBM's Integrated Solutions Console (formerly known as WebSphere Console), the administrative interface for WebSphere 6.1, the default console user inactivity timeout is 30 minutes. I happen to think this is a bit short, particularly since most anyone using the console is a highly trusted user, generally an IT administrator who is well-versed in computer and network security practices.For

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2009/03/integrated-solutions-websphere-console.htmltag:blogger.com,1999:blog-7958569345934714789.post-69009851999845448432009-03-09T21:24:00.014-04:002009-09-04T09:52:38.974-04:00

So you've installed the EnterpriseOne HTML application on your fancy WebSphere Application Server (uppercase) and you are doing some restart/reboot testing. If you are using WebSphere Network Deployment, as you absolutely should be, you may notice that if you reboot the entire box, the previously running application servers (lowercase) do not restart even though the node agent service is set to

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2009/03/auto-restart-websphere-application.htmltag:blogger.com,1999:blog-7958569345934714789.post-31267230022592600242009-01-12T14:24:00.009-05:002009-09-04T09:58:35.720-04:00

Wanna see an ugly URL?http://thisismyservername:82/jde/owhtmlCan we please stop doing this to our EnterpriseOne users? Not only is it tedious and non-descriptive, it looks amateurish.The use of aliasing and Virtual Hosting techniques in DNS, IBM HTTP Server (Apache), and WebSphere allows E1 JAS instances to be referenced by name instead of by TCP Port Number. DNS mappings, Apache VirtualHosts,

Jeff Stevensonnoreply@blogger.com1http://jeffstevenson.karamazovgroup.com/2009/01/simple-e1-url.htmltag:blogger.com,1999:blog-7958569345934714789.post-35480383441781849852009-01-12T10:35:00.014-05:002009-09-04T09:58:51.166-04:00

I was trying to delete a SQL login and received the following message:"You cannot drop the selected ID because that login ID owns objects in one of more databases"I wrote a little script that utilizes the always useful sp_MSForEachDB stored procedure to walk through each database and find the objects owned by a specified user.SQL 2000=======--SQL Script beginEXEC sp_MSForEachDB 'USE [?]; PRINT ''

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2009/01/determine-objects-owned-by-user-in-all.htmltag:blogger.com,1999:blog-7958569345934714789.post-79038848204271820352008-12-30T12:39:00.012-05:002009-09-04T09:56:02.571-04:00

Over three separate weeks during the year 2001, in the basement of Building 1 on the JD Edwards campus in Denver, CO, an amazing set of gatherings occurred that the hundreds in attendance will likely never forget.Conceived in 2000, at the height of the technology boom and full of the giddiness that accompanied it, the Technology Survival Camps were based in part on the very successful Client

Jeff Stevensonnoreply@blogger.com3http://jeffstevenson.karamazovgroup.com/2008/12/jd-edwards-technology-survival-camp.htmltag:blogger.com,1999:blog-7958569345934714789.post-2665188399169212562008-12-16T12:58:00.005-05:002009-09-04T09:59:09.553-04:00

Jeff Stevensonnoreply@blogger.com35http://jeffstevenson.karamazovgroup.com/2008/12/hitler-and-cnc-guys.htmltag:blogger.com,1999:blog-7958569345934714789.post-3306435730002874522008-12-09T15:24:00.027-05:002009-10-16T10:57:19.025-04:00

There are times when CNC administrators need to view a list of all submitted jobs in a single result set. E1 tools or standard SQL scripts do not satisfy this requirement but the script below will allow one to view all submitted UBE's from all servers in one list. The script makes use of the OPENDATASOURCE method, Integrated Security authentication, and the Union operator to allow the script

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2008/12/submitted-jobs-from-all-servers.htmltag:blogger.com,1999:blog-7958569345934714789.post-71844101272675732008-09-25T15:13:00.011-04:002009-09-04T09:59:38.875-04:00

Index fragmentation causes significant performance problems in EnterpriseOne systems. If access to the underlying data is slow, end users will not have the 'snappy' experience they expect, particularly on the web-client interface.Determining index fragmentation on SQL 2000 was simple, using the DBCC SHOWCONTIG command with a few extra arguments:--SQL Script beginUSE databasenameDBCC SHOWCONTIG

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2008/09/determine-index-fragmentation-in-all.htmltag:blogger.com,1999:blog-7958569345934714789.post-42317015919853385532008-09-19T00:10:00.026-04:002009-09-04T09:59:55.601-04:00

This little script tells you in a single result set:Objects Checked OutVersions Checked Out in DV812, PY812, PD812Objects created never checked inVersions created never checked inObjects with tokens heldI always run this just prior to an implementation team leaving the customer site to ensure that they have done the necessary cleanup of objects and projects. I also combine this with xp_sendmail

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2008/09/enterpriseone-objects-versions-checked.htmltag:blogger.com,1999:blog-7958569345934714789.post-3157867721085738892008-09-13T19:53:00.011-04:002009-09-04T10:00:14.051-04:00

So John Bassett and I were working at a client today, complaining about how often we had to go into the Services console and how bad the default settings were.  Every time you open the Services console the default view is Extended instead of Standard, the Window is mis-sized, and the columns are squished.It looks something like this, which is pretty useless:Figure 1 Services console defaultMy

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2008/09/enterpriseone-cncs-spend-lot-of-time.htmltag:blogger.com,1999:blog-7958569345934714789.post-9869640269577342362008-09-11T19:05:00.021-04:002009-09-04T10:00:30.424-04:00

There may be a time when you are required to change the location of the various system databases in SQL 2000- Master, Model, MSDB. Below are several scripts and instructions for manual steps to accomplish this./* Change model database file locations */Stop SQL Server ServiceStart SQL Server from command prompt using NET START MSSQLSERVER /c /T3608--SQL Script begin--Enable xp_cmdshellEXEC

Jeff Stevensonnoreply@blogger.com2http://jeffstevenson.karamazovgroup.com/2008/09/sql-server-system-databases-re-location.htmltag:blogger.com,1999:blog-7958569345934714789.post-46651922337358224512008-09-04T11:51:00.008-04:002009-09-04T10:01:12.282-04:00

I am surprised to hear that so many people are not using all available methods to load balance and create redundancy in their E1 systems. This is not the first time I have read someone mention that Network Deployment is not a good solution. I think that ND is the only really feasible application-level load balancing and failover device available. I try to introduce redundancy into my system at

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2008/09/load-balancing-at-all-levels-in.htmltag:blogger.com,1999:blog-7958569345934714789.post-594816823388194822008-09-02T17:22:00.008-04:002009-09-04T10:01:31.826-04:00

Executive SummaryAs a SQL Server administrator you are probably familiar with this scenario: The phone rings and it is one of your users saying “the system seems really slow today”, or if you have monitoring and alerting set up you get an email telling you the CPU(s) on your SQL server is maxed at 100%. Regardless of the method of alert, you have to figure out what is causing the problem. You

Jeff Stevensonnoreply@blogger.com3http://jeffstevenson.karamazovgroup.com/2008/09/identifying-high-cpu-sql-processes.htmltag:blogger.com,1999:blog-7958569345934714789.post-5109020580498942202008-09-01T19:22:00.013-04:002009-09-04T10:01:43.789-04:00

At some point you will have to troubleshoot a SQL Server issue that is caused by excessive disk input/output (IO). SQL Server's sensitivity to disk bottlenecks makes it crucial that one know how to identify which specific SQL process (SPID) is consuming IO resources.To show instantaneous but cumulative measurement by active SPID:--SQL Script beginif exists (select * from tempdb.dbo.sysobjects

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2008/09/measuring-sql-server-cumulative-disk-io.htmltag:blogger.com,1999:blog-7958569345934714789.post-1915552962214202402008-09-01T17:12:00.004-04:002009-01-14T18:09:06.945-05:00

EnterpriseOne, WebSphere, OAS, Apache, etc. leave numerous files lying about in the filesystem. If you have enough space, these files can generally be left in place for future troubleshooting. Honestly though, I don't really care about a failed login attempt six years ago. Plus, it violates my standard of cleanliness, which I do possess regardless of what my mother thought about my room in my

Jeff Stevensonnoreply@blogger.com0http://jeffstevenson.karamazovgroup.com/2008/09/e1-maintenance-item-log-and-other-files.htmltag:blogger.com,1999:blog-7958569345934714789.post-7719345149668053122008-09-01T00:33:00.003-04:002009-01-14T18:09:16.291-05:00

I am building a new web server to eventually house the Stevenson Family website and other websites that I run. Since the old server runs a rather outdated version of RedHat Linux I decided to install the latest version of Fedora Linux on the new hardware.The struggles began when I ran the first FC5 install CD and the error "No hard drives have been found you probably need to manually choose

Jeff Stevensonnoreply@blogger.com1http://jeffstevenson.karamazovgroup.com/2008/08/installing-fedora-core-5-on-dl380-g1.html