| Author |
Message
|
| golam_m |
 Posted: Thu Apr 06, 2006 5:54 am Post subject: No entry in the fmc.error_log table |
 |
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
Hi,
I am always getting 0 rows returned when querying the Workflow Database with the following query " SELECT * FROM FMC.ERROR_LOG;".
Though the fmcerr.log file is getting updated with trivial messages like "Related message = FMC31050E An error has occurred which has terminated processing.".
Do I need to make changes in the settings to get the error_log table populated?
Thanks, |
|
| Back to top |
|
 |
| jmac |
| Posted: Thu Apr 06, 2006 7:08 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Why do you view the table that way?
You can see the error log by looking at the fmcerr.log file or by using the admin utility to view the ERROR table.
While I have seen in the past that there are differences between the content of the fmcsys.log file and corresponding table, I have never come accross any differences in for the error file and table.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Apr 06, 2006 7:11 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
OK... I thought about this a little more, and you might want to check to see what your error retention period is for the error log, perhaps if it is 0 this table never gets populated, I have never tried that.
You can see this from the Admin utility.
Let me know what you find
Thanks
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| golam_m |
| Posted: Thu Apr 06, 2006 8:22 pm Post subject: |
|
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
Hi JMac,
Thanks for your response. I have checked the error retention period in admin utility. Its P1W. And the latest entry in the fmcerr.log file is on "4/2/2006 1:40:30 AM". But, I don't see this entry in the error_log table.
Thanks, |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Apr 07, 2006 5:30 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
what do you see from fmcautil option el?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| golam_m |
| Posted: Fri Apr 07, 2006 9:57 pm Post subject: |
|
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
In fmcautil, I am able to see system logs but no error logs.
Thanks, |
|
| Back to top |
|
|
| hos |
| Posted: Sun Apr 09, 2006 10:45 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
What version and service level of MQWF are you running?
I think that you just do not have any error entry in your log.
Why do you think that there should be an error entry? |
|
| Back to top |
|
|
| golam_m |
| Posted: Tue Apr 11, 2006 8:36 pm Post subject: |
|
|
Apprentice
Joined: 10 Oct 2005
Posts: 48
|
Hi hos,
I am running MQ Workflow version 3.6.
I am expecting the error_log table to be populated, since I am using the same database instnace for development and testing for last 6 months and I am getting error entries inside the fmcerr.log file. Also the error retention period is 1 week. There can be many reasons for getting entries in the error_log table. For example, I use to terminate process instances using thick client.
Today, I have changed the error retention period to 1 month.
Thanks, |
|
| Back to top |
|
|
| hos |
| Posted: Tue Apr 11, 2006 11:57 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
I recommend to open a PMR for this. Looks like it is a bug. |
|
| Back to top |
|
|
|
|
