Record count in systaskparam

Yahoo Archive
1
Brad,

you are correct
the other tables semi related are
sysagenttask
sysagenttaskparam
sysagentsched

These are the ones that hold the jobs to be scheduled by the task / process server.
The task param tables store the parameters for the jobs that are scheduled and should be cleared up as the tasks are cleared up.

You can safely clear out the below list.

Regards,
Stephen

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of BradF
Sent: 14 April 2011 15:39
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Record count in systaskparam



I think I see what's going on. The system is keeping the last 30 days of tasks in these tables and the majority of records are generated by the `Multi-Company Process' which runs every five minutes. We can create a daily SQL job that prunes all `Multi-Company Process' records older than something like two days.

Looks like the following tables would need included in the pruning joined by systasknum. Anyone familiar enough with these tables to verify? Should there be others?

- systask
- systaskparam
- systasklog
- sysrptlst

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Brian W. Spolarich" <bspolarich@...<mailto:bspolarich@...>> wrote:
>
> It looks to me like whatever background cleanup Vantage is doing in
> systask doesn't properly cleanup the associated records in systaskparam.
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> Of BradF
> Sent: Thursday, April 14, 2011 9:18 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Record count in systaskparam
>
> In our database, this table is up to 750,000 rows but the values don't
> appear to have any historical significance. We see rows added and
> deleted but overall row count is always increasing. Has anyone else
> monitored this table? What row count do you currently see?
>
> We're SQL on 8.03.407.
>
> Thanks,
> Brad
>
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>



[Non-text portions of this message have been removed]
2
In our database, this table is up to 750,000 rows but the values don't appear to have any historical significance. We see rows added and deleted but overall row count is always increasing. Has anyone else monitored this table? What row count do you currently see?

We're SQL on 8.03.407.

Thanks,
Brad
3
It looks to me like whatever background cleanup Vantage is doing in
systask doesn't properly cleanup the associated records in systaskparam.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of BradF
Sent: Thursday, April 14, 2011 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Record count in systaskparam

In our database, this table is up to 750,000 rows but the values don't
appear to have any historical significance. We see rows added and
deleted but overall row count is always increasing. Has anyone else
monitored this table? What row count do you currently see?

We're SQL on 8.03.407.

Thanks,
Brad





------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
I'm up to 990K records.



It *should* be cleaned up periodically by the system. I thought it was
truncated upon starting up the Task appserver, but apparently not.



You can truncate this table. Try it in Test or Pilot first. I've
truncated this table in the past with no issues. In fact how I learned
about this was via a support call a while ago. See the Problem
Resolution...



But this table simply holds parameters for reports....... For instance,
if you print a job traveler it will create about 30 or so records.







PROBLEM DESCRIPTION: Unable to Print anything. Error messages in the
TaskAgent.Server.Log:



** SysTaskParam already exist with Task 343 Parameter Name
"AgentCompareString". (132)



This line repeated for every field in the SysTaskParam table.



CAUSE: It is possible that a backup copy of the original database was
loaded to the Test80 folder, and since it has the same Port numbers for
the TaskAgent as the live database it is trying to utilize the same
TaskAgent appserver as the live database. So when print jobs were sent
the queue information was written to the SystemTaskParam table, causing
what appeared to be duplicate records.



PROBLEM RESOLUTION: A fix routine needs to be create and run to delete
the contents of the SysTaskParam table.





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of BradF
Sent: Thursday, April 14, 2011 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Record count in systaskparam





In our database, this table is up to 750,000 rows but the values don't
appear to have any historical significance. We see rows added and
deleted but overall row count is always increasing. Has anyone else
monitored this table? What row count do you currently see?

We're SQL on 8.03.407.

Thanks,
Brad





[Non-text portions of this message have been removed]
5
I think I see what's going on. The system is keeping the last 30 days of tasks in these tables and the majority of records are generated by the `Multi-Company Process' which runs every five minutes. We can create a daily SQL job that prunes all `Multi-Company Process' records older than something like two days.

Looks like the following tables would need included in the pruning joined by systasknum. Anyone familiar enough with these tables to verify? Should there be others?

- systask
- systaskparam
- systasklog
- sysrptlst

--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...> wrote:
>
> It looks to me like whatever background cleanup Vantage is doing in
> systask doesn't properly cleanup the associated records in systaskparam.
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of BradF
> Sent: Thursday, April 14, 2011 9:18 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Record count in systaskparam
>
> In our database, this table is up to 750,000 rows but the values don't
> appear to have any historical significance. We see rows added and
> deleted but overall row count is always increasing. Has anyone else
> monitored this table? What row count do you currently see?
>
> We're SQL on 8.03.407.
>
> Thanks,
> Brad
>
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>