JD EnterpriseOne 9.0 'hangs' during printing and saving

Autolitho

Member
JD EnterpriseOne 9.0 \'hangs\' during printing and saving

Our system has been unstable since Friday, and yesterday (Monday) as of 2am in the morning, we started experiencing mission-critical stoppages. We are still able to log into JDE but we cannot print and we cannot save records.

These stoppages occur during various activities:

1. Saving a record: when the user completes data entry and clicks OK, the system takes a very long time "processing" and then reports the error message: “TRANSACTION ERROR The transaction cannot be committed. It was cancelled.”

2. Printing. When a user clicks OK in the Printer Selection dialog box, it goes in “Processing” mode for 2 or 3 minutes, after which it hangs and reports “Your report has NOT been submitted successfully.”

At other times the printing process completes, but in the Submitted Jobs, it remains in a status of “Processing” forever.

3. Exiting a form without saving: this also takes long time, with “processing” error message, before crashing with Business Function error.

<font color="red">These problems occur only in the PD environment. </font> In QA and PY, printing or saving is OK. Printing is also OK in PD’s Fat Client. When we reboot the full system, we can print 3 or 4 documents in PD before the system hangs again; but this is only occasional.
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

Here is where your configuration is important.

You are using E900, but:
Which TR?
What Enterprise Server platform and operating system?
What database, database server platform and operating system?
Is your PD environment on a separate system (different set of servers) to QA and PY?
Does the PD environment use different database(s) to QA and PY?

Is there anything in the logs (enterprise server and web and database)? I would find it very difficult to believe that you are experiencing such difficulties with no errors in any log.

It seems intermittent to a certain degree, so I'm wondering if you have some sort of temp space problem.
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

Other details:
- JD Edwards EnterpriseOne 9.0
- E1 9.0 (Update 1)
- Tools Release 8.98.3.1

Note: all servers hosted on VMWare virtual environments.

- Web Server (OAS): Red Hat Enterprise Linux 5.3 x86-64

- Enterprise Server (Production): Red Hat Enterprise Linux 5.3 x86-64. Hosts PD.

- Enterprise Server (Non-Production): Red Hat Enterprise Linux 5.3 x86-64. Hosts QA and PY.

- Database Server: Red Hat Enterprise Linux 5.3 x86-64

- Database: Oracle 11g R2 (11.2.0.1) Linux x86 client

- Application Server: OAS 10g R3 (10.1.3.4.0) 32-Bit

The database is shared. Environments are segregated by namespace.
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

Autolitho,

Judging from the symptoms that you described, I would focus on the database. It sounds like some tables are not allowing you to post transactions. All databases have to be set to allow for growth, the mechanism varies from database to database. I suspct that one of your key PD tablespacs has maxed out.

Your JDE and database logs will tell you exactly where to look. Just repeat your scnario and look at the logs, you will see what table is hanging.

- Gregg
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

From the PD environment, at the time of a crash:

25 Jun 2013 18:45:42,780[SEVERE][USER1][METADATA]Retrieved JDENET.tempFileDir, using /u04/JDE_HOME/targets/PDEAPCC/temp
25 Jun 2013 18:45:44,769[WARN][USER1][RUNTIME]Message:Report R0006P_XJDE0001 is successfully submitted to server: EAPCCES01 job number:851199

at java.lang.Thread.run(Thread.java:595)25 Jun 2013 18:47:52,264[WARN][E1MENU]Couldn't create static link "My System Options" USER: SANES ROLE: *ALL APPLICATION: P0085 You do not have permission to access this application. com.jdedwards.taskexplorer.dataservice.exception.TEDSUserException: USER: SANES ROLE: *ALL APPLICATION: P0085 You do not have permission to access this application.com.jdedwards.taskexplorer.dataservice.exception.TEDSUserException: USER: SANES ROLE: *ALL APPLICATION: P0085 You do not have permission to access this application.

25 Jun 2013 18:48:54,525[SEVERE][SHISEROA][KERNEL]*ERROR* GlossaryText: COSE#1000 Request timeout: timeout after 90000ms host EAPCCES01:6015(32303) SocID:38086 PID:0 25 Jun 2013 18:48:54,525[SEVERE][SHISEROA][JAS]trying implementing getGlossaryTextJava com.jdedwards.system.kernel.CallObjectTimeoutException: COSE#1000 Request timeout: timeout after 90000ms host EAPCCES01:6015(32303) SocID:38086 PID:0
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

There are various error messages in different logs.

One commonly seen error is:

The Submitted Jobs log indicates: "Violation of PRIMARY KEY constraint 'F9312_PK'. Cannot insert duplicate key in object 'SYS7333.F9312'. - SQLSTATE: 23000". Online solutions to this error say that user should upgrade to at least TR 8.98.2, but we are on 8.98.3.
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

Check available disk space on your file systems / disks. Ensure database tablespaces are able to expand/grow.
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

The particular error is a 'red herring'. And has been part of JDE for years. The file is used to keep track of login, logouts. The primary key was set up wrong at the beginning and we have lived with it ever since.

Tom
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

Tom,

Re: "red herring"

I suspect that much. I couldn't see why JDE would interact with an access control file during printing. That bdidn't make sense.
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

After much research, the issue turns out to be corrupted JDE application files on the o/s of the Enterprise Server: dddict, ddtext and glbltble.
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

[ QUOTE ]

25 Jun 2013 18:48:54,525[SEVERE][SHISEROA][KERNEL]*ERROR* GlossaryText: COSE#1000 Request timeout: timeout after 90000ms host EAPCCES01:6015(32303) SocID:38086 PID:0 25 Jun 2013 18:48:54,525[SEVERE][SHISEROA][JAS]trying implementing getGlossaryTextJava com.jdedwards.system.kernel.CallObjectTimeoutException: COSE#1000 Request timeout: timeout after 90000ms host EAPCCES01:6015(32303) SocID:38086 PID:0

[/ QUOTE ]

Based on this message you provided you can now go look at call object kernel logs on your enterprise server called EAPCCES01. There should be a log called jde_32303.log. You might find your next clue there (focus on timestamps 18:47 and 18:48).

-- David
 
Re: JD EnterpriseOne 9.0 \'hangs\' during printing and saving

DO you have security history turned on. If yes, that could be your culprit.

Either the security history table is too big , you can take a back and truncate it or use smoe other way to remove record from that table.

You can also disable this functionality all together, if you are not using it.. We have seen something similar some years ago
 
Back
Top