Quick Tip: Change A Scheduled Job’s Time Zone Using SQL
If you work with multiple time zones, especially if one uses Daylight Saving Time and the other does not, it can be useful to have scheduled jobs setup using the appropriate time zone.
This can be done by creating separate versions of the P91300 – Scheduled Jobs application....
After running with multiple versions of the P91300, you may find it necessary to move or copy a scheduled job from one time zone to the other. Unfortunately, there is no way to do this using the application.
So, not to be denied, I figured out a little SQL that can be used:
SET SJTIMEZONES=11 --(UTC+08:00) in UDC H91/TZ
WHERE SJSCHJBNM='TEST JOB'
It’s quick. It’s dirty. But… Hey! That’s one of the beautiful things about SQL.
Read more at E1Tips.com
Basics of the Linux Top Command
Recently, I had a tip submitted that referred to using the Linux top command to “check overall CPU utilization and individual CPU utilization”. Thanks, Sworna Dunant. It’s a good tip. However, top can be used for so much more that I decided to expand on it a little…
Before we get started, please note that the top command has it’s own versions and has slightly different options with each version. To check your top command version use the followi...
Quick Tip: How To Find OS Version On IBM i http://e1tips.com/…/uploa…/2017/12/IBM_i_Version-768x461.png
To find the OS version of the IBM i (iSeries, AS/400), use the commands below:
The above commands will result in a screen similar to the one below:
Read more at E1Tips.com
How To Kill Zombies The Easy Way http://e1tips.com/wp-cont…/…/2017/11/How-To-Kill-Zombies.png
Zombie processes have been the scourge of the JDE EnterpriseOne landscape for CNC Admins for many years. Usually, they are difficult to troubleshoot because many times there are no logs to assist you and if you do happen to get a log file, more often than not, it just ends abruptly with no hints as to what caused it.
So, what are these “zombies”?...
They are server processes that have ended but the system thinks they are still out there and available to do work. It doesn’t take long to figure out that it’s a problem if a Call Object Kernel has died but the system is still sending it work to do.
I’m sure there is an explanation that is a lot more technical and detailed, but for how far I need to dive into these things the above is good enough for me.
How do you get rid of Zombies?
Remove Zombies Using Server Manager
The traditional way to rid your system of the dreaded un-dead is to use Server Manager. Use the [Process Detail] view on the EnterpriseServer that has the issue and sort by [Process Status]. You will need to click the column title twice because the processes you are looking for have a status of “STOPPED”.
Then, we check the box beside the little bugger and click [Remove Zombie].
Remove Zombies The Easy Way
Nimish Prabhu has used his .Net skills to devise a way to kill zombie processes using the command line.
Why is that so cool?
Because it can be put into a script and scheduled!
Yep, that’s right! Instead of trudging around in Server Manager when you are alerted of a zombie process (Yes, you can be alerted of zombies if you set it up the Monitor in Server Manager), you can just run a script every few hours or so and not have to worry that your system is being overrun by the un-dead.
Nimish’s little application supports Tools Release 8.984.7 and higher. He was very responsive when I had a question and worked with me to extend it’s compatibility.
Thanks Nimish for helping CNC Admins rid the world (or is it OneWorld) of Zombies!
The post How To Kill Zombies The Easy Way appeared first on E1Tips.com.
5 Ways to Empty a File on Linux http://ifttt.com/images/no_image_card.png
Like most operations on any Operating System, there are several ways to do basic file manipulation on Linux. Below are 5 different ways to empty a file.
Redirection is usually used to output command results to a file. However, if we redirect “nothing” to a file, we can overwrite it with a blank file. Redirection can be done using a “>” greater-than symbol or a “|” pipe symbol.
# > file.txt
# :> file.txt
REDIRECT THE echo command
Use the echo command to redirect null values to a file.
# echo -n > file.txt
n do not output the trailing newline.
UsE THE truncate command
Use the truncate command to shrink or expand the size of a file to the size specified by the s option value. Use zero to make the file empty.
# truncate -s 0 file.txt
# truncate file.txt --size 0
REDIRECT THE /dev/null device
The null device is usually used for disposing of unwanted output streams of a process or as a empty file for input streams or a redirection operation.
# cat /dev/null > file.txt
# cp /dev/null file.txt
cp: overwrite 'file.txt'? y
SCRIPT THE Vim Editor
Vim is a text editor built to make creating and changing any kind of text very efficient. It is included as “vi” in most Linux/Unix systems.
# ex -sc ':%d|x' file.txt
# ex -sc ':1,$d|x' file.txt
ex : Enter into Ex mode
s : Silent; do not display prompts
c : Run the given ex command upon startup
: : Invoke an ex command
% : Choose all the lines
d : Delete selected lines
x : save and close
2g.txt : input filename
The post 5 Ways to Empty a File on Linux appeared first on E1Tips.com.
Windows 2003 Firewall Rules Allow UNC Access To Shared Folders http://e1tips.com/wp-content/uploads/2017/08/E1Tips_Fire.jpg
A couple weeks ago I wrote a post about setting up Windows Firewall on a Windows 2003 Server running Oracle JD Edwards EnterpriseOne.
Well, looks like I wrote that article a little too quickly. Because although Oracle JD Edwards EnterpriseOne ran perfectly, the users were not able to access the exported files on the shared folders. Actually, neither was ...
Results: Where Does The CNC Function Reside In Your IT Department? http://e1tips.com/…/CNC_function_IT_Department_Survey_Chart…
Where do you put CNC?
That was the question I asked in my first survey attempt. Needless to say, the CNC community is a quiet group. I only got 7 responses. I know there are many people that read this blog but rarely do I get comments, suggestions or flat out criticisms. Maybe that’s due to me staying pretty factual (translate “geeky”). For those tha...t actually know me, I don’t seem to hold back when it comes to my opinions.
Anyway, here are the results:
So, are you surprised?
The post Results: Where Does The CNC Function Reside In Your IT Department? appeared first on E1Tips.com.
How To Set Your Linux Command Shell http://e1tips.com/wp-content/uploads/2017/07/Linux_Shell.png
One of the best things about the Linux command line is the ability to recall the last used command by hitting the up arrow ↑. Yes, I realize that Windows command line has done that for a long time, but where do you think they got the idea for that?
I’m fairly new to this whole Linux thing and I had an issue where I used SSH to get to a Linux server but when I ran a command and the...n hit the up arrow ↑, I got back a couple unreadable characters instead of the previous command. I found out that I was using the wrong command shell for what I was wanting to do.
There are a few shells that seem to be fairly common:
bash – Bourne again shell
ksh – Korn shell
csh – C Shell
dash – Debian almquist shell
I’m not sure which shell I was using that day, but I figured out that I needed the bash shell. Below are a few commands that will help you when working with your command shell:
To find all of the available shells in your system, type the following command:
To find out your current shell, type any of the following commands:
ps -p $$
To change your shell to the bash shell, type the following command:
chsh -s /bin/bash
Anything else you want to add to the discussion about shells?
The post How To Set Your Linux Command Shell appeared first on E1Tips.com.
Survey: Where Does The CNC Function Reside In Your IT Department? http://e1tips.com/wp-conte…/uploads/2017/…/E1Tips_Survey.png
I’ve worked at four very different IT organizations. I guess you would call 2 of them large and 2 of them small/medium sized organizations. That’s it. I’ve only received a W2 from four different IT organizations. I think that’s pretty good for a 20 year career in Information Technology, especially having gone through the Y2K Crisis and the Dot-com Bub...ble.
My first IT experience came at a quasi-state agency. It was “quasi” because we were kind of segregated from the rest of the state agencies. Anyway, I hadn’t gotten into JDE yet, so it isn’t really relevant to my thoughts on this post.
The other three organizations were a Fortune 500 company, a large privately held company and now a Fortune 300 company. Although these three organizations are vastly different, there was one thing that seemed to be consistent between them:
Where do we put CNC?
Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.
Be sure to see the final results by signing up for our email list:
The post Survey: Where Does The CNC Function Reside In Your IT Department? appeared first on E1Tips.com.
Securing Oracle JD Edwards EnterpriseOne with Windows Firewall http://e1tips.com/…/2…/07/EnterpriseOne_Windows_Firewall.png
On one of the Oracle JD Edwards EnterpriseOne installations that I manage, we have a few Windows 2003 Servers. Yeah, I know, it’s no longer supported but the Tools Release is 184.108.40.206 and there are a couple third-party applications that are not able to be upgraded. It’s crazy how messy, real-life situations cannot be duplicated in the squeaky-clean confi...
Oracle JD Edwards EnterpriseOne Multi-Foundation http://e1tips.com/…/2…/07/EnterpriseOne_Multi-Foundation.png
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
The post Oracle JD Edwards EnterpriseOne Multi-Foundation appeared first on E1Tips.com.
EnterpriseOne Package Build Completed With Errors http://e1tips.com/wp-content/uploads/2016/08/error.jpg
Don’t ya just hate that message when on the PDF at the completion of an EnterpriseOne package build… Build Completed With Errors?
Well, I came across this the other day and I just couldn’t get the EnterpriseOne package build to rebuild successfully. There were no usual suspects, like coding errors or running out of disk space. The only error I had was:...
Attempting to Link.
Executing: 'dir /b *.obj >> link_cmd'.
Executing: 'link @link_cmd >> CLOC.log'.
Executing: 'mt.exe -manifest E:\JDEdwards\E900\DDP\packages\PDF6000\bin32\CLOC.dll.manifest -outputresource:E:\JDEdwards\E900\DDP\packages\PDF6000\bin32\CLOC.dll;#2'.
builddll.c:4719 BUILDDLL0191 ERROR: Failed to run mt.exe successfully
builddll.c:2394 BUILDDLL0082 ERROR: Exiting DoTheLink with failure.
Finished Linking. Copying .c, .h, .hxx, and bin32 to Package Location.
So, I started messing around with the mt.exe command that it was trying to run and came up with this:
C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin>mt.exe -manifest E:\JDEdwards\
Then, I resubmitted the build using Package Build History and it completed successfully.
Do you have any tricks for getting by odd package build issues?
Submit a Tip or Trick
The post EnterpriseOne Package Build Completed With Errors appeared first on E1Tips.com.
Examining and Generating JD Edwards EnterpriseOne Indexes http://e1tips.com/wp-conte…/uploads/…/07/sql_ninja_thumb.png
Within the last week, Shannon Moir has had 2 great posts about EnterpriseOne indexes that have motivated me to evaluate our database:
JDE slow, missing indexes? find it fast… fix it fast!...
JD Edwards EnterpriseOne Tools Release 220.127.116.11 https://advcit.files.wordpress.com/…/cropped-information-te…
Just in case you missed it, the latest JD Edwards EnterpriseOne Tools Release is now generally available.
As with most new releases, there are some interesting features included: enhancements to EnterpriseOne Search, new Orchestration capabilities, additional flexibility for Media Object storage, and platform certifications....
However, there are a couple things that I think are especially interesting:
“Rather than being licensed as a discrete product, the usage of Orchestrator is now included as part of JD Edwards EnterpriseOne Core Tools and Infrastructure.”
That’s right! The way I read this is that if you are licensed for JDE Core Tools & Infrastructure, you are now licensed for Orchestrator. Good news if you’ve been on the fence about using this new technology or don’t have a big enough project to make the licensing worth it.
You can now store Media Objects on the file system or in the database which enables you to upgrade to TR 18.104.22.168 without re-writing existing Medio Object integrations.
It’s great to see all the improvements that are being made.
What do you think is the most compelling improvement to get you to upgrade?
The post JD Edwards EnterpriseOne Tools Release 22.214.171.124 appeared first on E1 Tips.