Here are the conditions that must all be true in order for the problem to occur:

·         The target PC has a Package task assigned that is configured to allow unattended installation.

·         The assigned Package task has a “repeat deployment” interval set. It could be any interval (hourly, daily, weekly, monthly).

·         The target PC is unattended (powered on but no user is logged in).

Details: 

When all of the conditions listed above are met, the Prism client will run the recurring Package task every few seconds, and it will report those results back to the Prism Server.  This causes the Prism channel database to rapidly increase in size.  The rate of increase depends on how many PCs the Package task has been assigned to and how frequently the target PCs are in an unattended state.

Solution: 

1)      Either immediately uncheck the "Allow Unattended" property on all repeating Package tasks, or remove all repeating Package task assignments from computers and/or groups.  

Here is the text of a SQL query that will removed the “allow unattended” property from any repeating tasks that you currently have. You would run this SQL query against your Prism channel database.

UPDATE Tasks

SET isUnattended = 1

WHERE TaskTypeLookup = 0 AND

      TaskID IN (SELECT TaskID

                 FROM ComputersTasks

                 WHERE RepeatInterval != 0

                 UNION

                 SELECT TaskID

                 FROM GroupsTasks

                 WHERE RepeatInterval != 0)

2)      To clear extra rollback files created by the unattended/repeating task scenario, create a new command task using the settings below.  Be sure to replace <PackageName> with the name of your PWC file.  For example, if the package task points to Safari.PWC, then the UNAPPLY files to be deleted are "Safari *.PWR"

Command tab

  Command Line: cmd

  Command Options: /c del "%ALLUSERSPROFILE%\Prism Deploy\UNAPPLY\<PackageName> *.PWR"

  Options | Run: Hidden

Execution tab

  Check - Allow unattended installation

  Select - Run as the Local System account

Note: if the target machines are 2000 or XP, the Command Options should be: /c del "%ALLUSERSPROFILE%\Application Data\Prism Deploy\UNAPPLY\<PackageName> *.PWR"

Please call Technical Support at New Boundary Technologies for immediate assistance in stopping the problem from happening and in shrinking the channel database. Also call if you need help running the SQL query against your channel database. New Boundary Technical Support can be reached by phone at 612-379-1851 (8:30 - 5:00 Central, M-F) or email at support@newboundary.com. If you are experiencing this problem and you decide to send email instead of calling, please put “TTP 8119” in the subject line.

New Boundary Technologies is working on a fix for this issue and will release it as soon as possible.