System Monitor lists reports from wrong database

[rturrentine (Rick Turrentine)]

Here’s a new one on me. We are on our downhill run to upgrading from E9 to E11 (kinetic). Today I backed up our E9 Live DB using SQL and restored it to our Test DB. Everything went without error. However when I go into Test I cannot print or preview any reports. I suspected the Appservers and restarted them in the correct order but looking in System Monitor my reports are sitting in the Scheduled Tasks tab flagged for Immediate Run Request. When I look at the History Tasks in the System Monitor it is showing tasks and reports from our Live DB. I can click on a report and it will preview too.
I know I’m looking at our Test DB. I’ve never seen this before. There must be something still telling Test to point back over to Live. I checked my config file and it is pointing correctly.
Could it be something with the Task Agent needing to be updated for our Test DB?
I’m a bit stumped this afternoon and tired of restarting Appservers with no results.
TIA.

[hkeric.wci (Haso Keric)]

It depends on your setup but its typically under System Agent Maintenance you need to either point the url away from production, or the port.

Once the port is changed you will have to restart the Task Agent again.

See the following post:

Reports are not print previewing but going to scheduled tasks

in the client for Pilot, navigate to System Management > Utilities > System Agent. Confirm that the Task Appserver URL is pointing to 9423 (number 1 below). Confirm that the System AppServer URL is using port 9421 (number 2 below). Save your changes. Restart the taskagent and processserver for Test. In Training, Task port should be 9413 and System AppServer port is 9411. NOTE: you may need to stop your production taskagent and processserver before you can save changes in the system agent in …

[gpayne (Greg Payne)]

@rturrentine here is what I would reset in e9 during a restore.

 
UPDATE SYSAGENT 
            SET APPSERVERURL = 'AppServerDC://localhost:9423',
            MFGSYSAPPSERVERURL = 'AppServerDC://localhost:9425'
            WHERE AGENTID = 'SystemTaskAgent';

[rturrentine (Rick Turrentine)]

Thanks fore the script. SQL is not my native language. I have a lot to learn.

[gpayne (Greg Payne)]

@rturrentine All this would do is change the ports to the normal Test ports. If you do that as @hkeric.wci suggested in system agent and restart the app servers you should be good. No sql required.

[rturrentine (Rick Turrentine)]

I still seem to be having problems. I changed the System Agent to point to our Test DB then restarted the Appservers. Our Test is 9021 and the Task Agent port is 9023.

Looking at our server we only have Progress Explorer Tool and everything looks like its running properly.

Do I need to restart our Production Appservers too? I shouldn’t I’d need to.

[bmanners (brett manners)]

Also watch out for this issue Rogue App Server Flooding SQL with 10K Queries a Minute HELP! - #16 by josecgomez

[gpayne (Greg Payne)]

He is in 9