You’re offline. This is a read only version of the page.
1,642
We've got our Application Server up and running. We called it "Atom Ant".
We use Atom Ant mostly to run nightly Financial Transaction Transfer and to perform some transaction imports.
Recently I had to reschedule some tasks, and the following situation arises:
It's like the Monday Night Football scheduled in your TVGuide, but you turn on the TV and nothing happens.
I also had to move Atom Ant to another machine. My guess is that the schedule information becomes wrong by some combination of "am/pm" "dd/mm" "mm/dd" that's different between computers.
Please help on any hint on this.
Regards.
*This post is locked for comments
Thanks, very insightful.
Now it makes a lot of sense that the Requests table might be messed up after some trial-and-error and some automation I've made.
Also, I'm moving my scheduling to the Windows Server schedule service, which has more powerful scheduling options. The Application Server still performs the job, though.
I recall have a similar issue in an older version of SL. The fix was to reset the application server tables. There used to be a knowledge base document with instruction on how to accomplish the reset. I pulled the following from an old support email that addressed a similar issue. The emails is from 2006 so take that into consideration. I highly recommend opening a support tickets with SL since this fix involves manual changes to the system database.
Prior to running the scripts, make notes of all your scheduled reports, you will need to recreate them.
Make a backup of the system database.
Then delete all the Application server records from these tables:
DELETE FROM AppSrvRequest
DELETE FROM ASRDatabase
DELETE FROM ASRDistList
DELETE FROM Scheduler
DELETE FROM User_Reports
DELETE FROM Template WHERE TemplateID LIKE 'SOLOMONDESKTOP%'
DELETE FROM AppSrvlog
Then, in SQL Server Enterprise Manager, drop the table AppSrvRequest.
open the DSD_sTables.sql in Query Analyzer. This file is located in the Solomon IV\DB\Scripts\Sys\ and search for appsrvrequest table creation statement. Copy the syntax into Query
Then recreate the index on AppSrvRequest. To do this right-click on the AppSrvRequest table, select "All Tasks", Manage Indexes, then click "New...".
Type AppSrvRequest0 in the Index name box. Check the ID column. Also, on the "Index Options" check the "Clustered index" and the "Unique values" option. Then, click OK, then Close.
Now, access Solomon and start AppServer and submit a new request.
You should then be at Request Number 1.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (