We are on 8.03.409C SQL…
We had previously been looking at bad baqs, seeing if the issue always happened at the same time etc. Although most of the time it seemed about the same time of day and the same form printing was held first, that was not always the case.
We found the log kept showing a duplicate index for the system agent table. We were able to escalate the issue with Epicor…Epicor suggested the System Agent was probably corrupt.
First, we stopped the Process, Task, and Report server services (no printing during this time). Next we backed up the LIVE database from SQL mgmt (in order to recreate sysagent later). Epicor did some SQL commands to truncate the tables systask and systask param. Possibly then we deleted sysagent in LIVE? Next we used the admin tools to run conversion 8180 - create system agent (in LIVE). This gave us an empty system agent.
Once the backup of LIVE was completed, we restored the backup to the Pilot environment temporarily (Epicor had to change the config file to point to the SQL database named Backup803 instead of Pilot). This gave us a view of the previously scheduled tasks for copying and recreating.
We were able to copy the schedules themselves by creating a new schedule and then paste update that schedule. We later found that the Daily weekday boxes were not checked and the next run date was incorrect, so we manually corrected these items. We also had to manually recreate all scheduled tasks by viewing them in system monitor (double click the item in scheduled tasks to reveal details) in Pilot. I recreated "process" type tasks, but users had to recreate their own dynamic query exports and scheduled process sets in order to have the output go to their own reports directories.
We currently have about 10 days with no issues, but want to wait until we have 30 days in before acknowledging this issue is really resolved.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, August 20, 2012 7:46 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Printing Lock up
We have had this problem before, but we usually fix it by doing what you have said.
We are losing the will to live logging calls with Epicor now, so e dont bother.
________________________________
From: Anon <epicor-team@...<mailto:epicor-team%40wisconsinconverting.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Monday, 20 August 2012, 13:30
Subject: [Vantage] Printing Lock up
The last two Mondays in a row (so far been always just monday morning, but noticed today that someone was in on sunday and there were print jobs from sunday too) everyone comes in and nothing will print. I restart the print app server, task agent, and process agent and then it all starts flowing through. Any ideas?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
We had previously been looking at bad baqs, seeing if the issue always happened at the same time etc. Although most of the time it seemed about the same time of day and the same form printing was held first, that was not always the case.
We found the log kept showing a duplicate index for the system agent table. We were able to escalate the issue with Epicor…Epicor suggested the System Agent was probably corrupt.
First, we stopped the Process, Task, and Report server services (no printing during this time). Next we backed up the LIVE database from SQL mgmt (in order to recreate sysagent later). Epicor did some SQL commands to truncate the tables systask and systask param. Possibly then we deleted sysagent in LIVE? Next we used the admin tools to run conversion 8180 - create system agent (in LIVE). This gave us an empty system agent.
Once the backup of LIVE was completed, we restored the backup to the Pilot environment temporarily (Epicor had to change the config file to point to the SQL database named Backup803 instead of Pilot). This gave us a view of the previously scheduled tasks for copying and recreating.
We were able to copy the schedules themselves by creating a new schedule and then paste update that schedule. We later found that the Daily weekday boxes were not checked and the next run date was incorrect, so we manually corrected these items. We also had to manually recreate all scheduled tasks by viewing them in system monitor (double click the item in scheduled tasks to reveal details) in Pilot. I recreated "process" type tasks, but users had to recreate their own dynamic query exports and scheduled process sets in order to have the output go to their own reports directories.
We currently have about 10 days with no issues, but want to wait until we have 30 days in before acknowledging this issue is really resolved.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, August 20, 2012 7:46 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Printing Lock up
We have had this problem before, but we usually fix it by doing what you have said.
We are losing the will to live logging calls with Epicor now, so e dont bother.
________________________________
From: Anon <epicor-team@...<mailto:epicor-team%40wisconsinconverting.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Monday, 20 August 2012, 13:30
Subject: [Vantage] Printing Lock up
The last two Mondays in a row (so far been always just monday morning, but noticed today that someone was in on sunday and there were print jobs from sunday too) everyone comes in and nothing will print. I restart the print app server, task agent, and process agent and then it all starts flowing through. Any ideas?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]