Knowledgebase

Knowledgebase ID# :: 3289

Collage SQL for Inserting More Assets into a Previously-Created  Scheduled Task

subject: bugs
product: Serena Collage version: 4.x+

There is a bug in the 4.x versions of Collage [and it may also appear in 5.1.x] where individual assets cannot be added to a previously defined Scheduled Deploy.  For example, if there is a scheduled, nightly deploy of 145 assets throughout different sections of the site and an administrator needs to add 1 more asset to that list a Javascript error will prevent the change from taking place in the Properties screen of the Scheduled Deploy.

Use the SHIFT+CONTRAL+ALT+F12 Collage shortcut screen* to access the SQL input box.  Add in the following SQL and execute:

Insert INTO TaskParameters (TaskId,Name,Value) VALUES (13404,'assetList',175)

Where 13404 represents the project Assetid of the asset that needs to be added to the scheduled deploy and 175 represents the TaskId of the specific Scheduled Deploy.

related information:

* Make sure that the following parameter is added to the nas.properties file in Collage in order to access the SQL insert screen:  SVLevel=debug