RFL200254 Known Issue - RayFlow 4.1 Packaging project tools configurations are not correct

The following SQL queries can be used to either update all projects within your Rayflow database (if they were all created by copying the Packaging project or have had the Packaging projects tools imported into them), or to update a specific project. 

 

--/ Correct tool path for RayQCAd.exe in all projects

UPDATE Tools

SET ToolPath = '..\RayQCAdvanced\RayQCAd.exe'

WHERE ToolPath = '..\RayQC\RayQCAd.exe'

 

--/ Correct tool path for RayQCAd.exe in a specific projects

UPDATE Tools

SET ToolPath = '..\RayQCAdvanced\RayQCAd.exe'

WHERE ToolId IN

(SELECT t.ToolId

FROM Tools t

JOIN TaskList tl ON tl.TaskListID = t.TaskListId

JOIN Projects p ON p.ProjectID = tl.ProjectID

WHERE t.ToolPath = '..\RayQC\RayQCAd.exe'

AND p.ProjectName = '<enter project name here>')

 

 

 

--/ Correct tool path for RayQCAdCmd.exe in all projects

UPDATE Tools

SET ToolPath = '..\RayQCAdvanced\RayQCAdCmd.exe'

WHERE ToolPath = '..\RayQC\RayQCAdCmd.exe'

 

--/ Correct tool path for RayQCAdCmd.exe in a specific project

UPDATE Tools

SET ToolPath = '..\RayQCAdvanced\RayQCAdCmd.exe'

WHERE ToolId IN

(SELECT t.ToolId

FROM Tools t

JOIN TaskList tl ON tl.TaskListID = t.TaskListId

JOIN Projects p ON p.ProjectID = tl.ProjectID

WHERE t.ToolPath = '..\RayQC\RayQCAdCmd.exe'

AND p.ProjectName = '<enter project name here>')

 

 

 

--/ Correct tool path for RayQC.exe in UAT phase for all projects

UPDATE Tools

SET ToolPath = '..\RayQC\RayQC.exe'

WHERE ToolPath = '..\RayQCAd\RayQC.exe'

 

--/ Correct tool path for RayQC.exe in UAT phase within a projects

UPDATE Tools

SET ToolPath = '..\RayQC\RayQC.exe'

WHERE ToolId IN

(SELECT t.ToolId

FROM Tools t

JOIN TaskList tl ON tl.TaskListID = t.TaskListId

JOIN Projects p ON p.ProjectID = tl.ProjectID

WHERE t.ToolPath = '..\RayQCAd\RayQC.exe'

AND p.ProjectName = '<enter project name here>')

 

 

 

--/ Correct tool arguments for RayQCAdvanced in all projects

UPDATE Tools

SET ToolArguments = '-test rv -source "#PACKAGEFILE#" -Report "%UserProfile%\Documents\RayQC\Reports" -reportFormat PDF -ruleSet Virtualization; System Readiness; Collision -rule VA001;TG101;VA002;TG102;VA003;TG103;VA004;TG104;VA005;TG105;VA006;TG106;VA007;TG107;VA008;TG108;TG109;TG110;TG111;TG112;TG113;TG114;TG115;TG116;TG117;TG118 -rayflow "#RAYFLOWSERVICEURL#;#RAYFLOWSERVICEUSER#;#RAYFLOWSERVICEPASSWORD#;#RAYFLOWUSER#;#PROJECTID#;#PACKAGEID#"'

WHERE ToolArguments = '-test rv -source "#PackageFile#" -Report "C:\Users\Administrator\Documents\RayQC\Reports" -reportFormat PDF -ruleSet Virtualization; System Readiness; Collision -rule VA001;TG101;VA002;TG102;VA003;TG103;VA004;TG104;VA005;TG105;VA006;TG106;VA007;TG107;VA008;TG108;TG109;TG110;TG111;TG112;TG113;TG114;TG115;TG116;TG117;TG118 -rayflow "#RAYFLOWSERVICEURL#;#RAYFLOWSERVICEUSER#;#RAYFLOWSERVICEPASSWORD#;#RAYFLOWUSER#;#PROJECTID#;#PACKAGEID#"'

 

--/ Correct tool arguments for RayQCAdvanced in a specific project

UPDATE Tools

SET ToolArguments = '-test rv -source "#PACKAGEFILE#" -Report "%UserProfile%\Documents\RayQC\Reports" -reportFormat PDF -ruleSet Virtualization; System Readiness; Collision -rule VA001;TG101;VA002;TG102;VA003;TG103;VA004;TG104;VA005;TG105;VA006;TG106;VA007;TG107;VA008;TG108;TG109;TG110;TG111;TG112;TG113;TG114;TG115;TG116;TG117;TG118 -rayflow "#RAYFLOWSERVICEURL#;#RAYFLOWSERVICEUSER#;#RAYFLOWSERVICEPASSWORD#;#RAYFLOWUSER#;#PROJECTID#;#PACKAGEID#"'

WHERE ToolId IN

(SELECT t.ToolId

FROM Tools t

JOIN TaskList tl ON tl.TaskListID = t.TaskListId

JOIN Projects p ON p.ProjectID = tl.ProjectID

WHERE t.ToolArguments = '-test rv -source "#PackageFile#" -Report "C:\Users\Administrator\Documents\RayQC\Reports" -reportFormat PDF -ruleSet Virtualization; System Readiness; Collision -rule VA001;TG101;VA002;TG102;VA003;TG103;VA004;TG104;VA005;TG105;VA006;TG106;VA007;TG107;VA008;TG108;TG109;TG110;TG111;TG112;TG113;TG114;TG115;TG116;TG117;TG118 -rayflow "#RAYFLOWSERVICEURL#;#RAYFLOWSERVICEUSER#;#RAYFLOWSERVICEPASSWORD#;#RAYFLOWUSER#;#PROJECTID#;#PACKAGEID#"'

AND p.ProjectName = '<enter project name here>')

 

 

 

--/ Correct tool arguments for RayEval in all projects

UPDATE Tools

SET ToolArguments = '-new -@INSTALLERPATH "#PACKAGEFILE#" -@APPNAME "#Application name#" -@APPVERSION "#Application version#" -@MANUFACTURER "#Application vendor#" -@PKGVERSION "#Application version#" -@EVALUATOR "#RAYFLOWUSER#" -APPLICATIONLANGUAGE "#Application language#" -pa #RAYFLOWSERVICEURL# #RAYFLOWSERVICEUSER# #RAYFLOWSERVICEPASSWORD# #RAYFLOWUSER# #PROJECTID# #PACKAGEID#'

WHERE ToolArguments = '-new -@INSTALLERPATH "#PACKAGEFILE#" -@APPNAME "#Application name#" -@APPVERSION "#Application version#" -@MANUFACTURER "#Application vendor#" -@PKGVERSION "#Application version#" -EVALUATOR "#RAYFLOWUSER#" -APPLICATIONLANGUAGE "#Application language#" -pa #RAYFLOWSERVICEURL# #RAYFLOWSERVICEUSER# #RAYFLOWSERVICEPASSWORD# #RAYFLOWUSER# #PROJECTID# #PACKAGEID#'

 

--/ Correct tool arguments for RayEval in a specific project

UPDATE Tools

SET ToolArguments = '-new -@INSTALLERPATH "#PACKAGEFILE#" -@APPNAME "#Application name#" -@APPVERSION "#Application version#" -@MANUFACTURER "#Application vendor#" -@PKGVERSION "#Application version#" -@EVALUATOR "#RAYFLOWUSER#" -APPLICATIONLANGUAGE "#Application language#" -pa #RAYFLOWSERVICEURL# #RAYFLOWSERVICEUSER# #RAYFLOWSERVICEPASSWORD# #RAYFLOWUSER# #PROJECTID# #PACKAGEID#'

WHERE ToolId IN

(SELECT t.ToolId

FROM Tools t

JOIN TaskList tl ON tl.TaskListID = t.TaskListId

JOIN Projects p ON p.ProjectID = tl.ProjectID

WHERE t.ToolArguments = '-new -@INSTALLERPATH "#PACKAGEFILE#" -@APPNAME "#Application name#" -@APPVERSION "#Application version#" -@MANUFACTURER "#Application vendor#" -@PKGVERSION "#Application version#" -EVALUATOR "#RAYFLOWUSER#" -APPLICATIONLANGUAGE "#Application language#" -pa #RAYFLOWSERVICEURL# #RAYFLOWSERVICEUSER# #RAYFLOWSERVICEPASSWORD# #RAYFLOWUSER# #PROJECTID# #PACKAGEID#'

AND p.ProjectName = '<enter project name here>')

 

 

 

--/ Correct tool arguments for PackDesigner in all projects

UPDATE Tools

SET ToolArguments = 'open -path "#PACKAGEFILE#" -profile "%AppData%\RayPack\Profiles\Default.rpprofile" -RayflowPackageId #PACKAGEID# -RayflowServiceUser #RAYFLOWSERVICEUSER# -RayflowServicePassword #RAYFLOWSERVICEPASSWORD# -RayflowUrl #RAYFLOWSERVICEURL# -RayflowProjectId #PROJECTID#'

WHERE ToolArguments = 'open -path "#PACKAGEFILE#" -profile "C:\Users\Administrator\AppData\Roaming\RayPack\Profiles\DEMO.rpprofile" -RayflowPackageId #PACKAGEID# -RayflowServiceUser #RAYFLOWSERVICEUSER# -RayflowServicePassword #RAYFLOWSERVICEPASSWORD# -RayflowUrl #RAYFLOWSERVICEURL# -RayflowProjectId #PROJECTID#'

 

--/ Correct tool arguments for PackDesigner in a specific project

UPDATE Tools

SET ToolArguments = 'open -path "#PACKAGEFILE#" -profile "%AppData%\RayPack\Profiles\Default.rpprofile" -RayflowPackageId #PACKAGEID# -RayflowServiceUser #RAYFLOWSERVICEUSER# -RayflowServicePassword #RAYFLOWSERVICEPASSWORD# -RayflowUrl #RAYFLOWSERVICEURL# -RayflowProjectId #PROJECTID#'

WHERE ToolId IN

(SELECT t.ToolId

FROM Tools t

JOIN TaskList tl ON tl.TaskListID = t.TaskListId

JOIN Projects p ON p.ProjectID = tl.ProjectID

WHERE t.ToolArguments = 'open -path "#PACKAGEFILE#" -profile "C:\Users\Administrator\AppData\Roaming\RayPack\Profiles\DEMO.rpprofile" -RayflowPackageId #PACKAGEID# -RayflowServiceUser #RAYFLOWSERVICEUSER# -RayflowServicePassword #RAYFLOWSERVICEPASSWORD# -RayflowUrl #RAYFLOWSERVICEURL# -RayflowProjectId #PROJECTID#'

AND p.ProjectName = '<enter project name here>')

 

 

 

--/ Correct tool arguments for PackRecorder in all projects

UPDATE Tools

SET ToolArguments = 'rayflow -RayflowPackageId #PACKAGEID# -app "#PACKAGEFILE#" -appParams "" -wizardMode expert -projectName "#PACKAGENAME#" -profile "%AppData%\RayPack\Profiles\DEMO.rpprofile" -RayflowServiceUser #RAYFLOWSERVICEUSER# -RayflowServicePassword #RAYFLOWSERVICEPASSWORD# -RayflowUrl #RAYFLOWSERVICEURL# -RayflowProjectId #PROJECTID#'

WHERE ToolArguments = 'rayflow -RayflowPackageId #PACKAGEID# -app "#PACKAGEFILE#" -appParams "" -wizardMode expert -projectName "#PACKAGENAME#" -profile "C:\Users\Administrator\AppData\Roaming\RayPack\Profiles\DEMO.rpprofile" -RayflowServiceUser #RAYFLOWSERVICEUSER# -RayflowServicePassword #RAYFLOWSERVICEPASSWORD# -RayflowUrl #RAYFLOWSERVICEURL# -RayflowProjectId #PROJECTID#'

 

--/ Correct tool arguments for PackRecorder in a specific project

UPDATE Tools

SET ToolArguments = 'rayflow -RayflowPackageId #PACKAGEID# -app "#PACKAGEFILE#" -appParams "" -wizardMode expert -projectName "#PACKAGENAME#" -profile "%AppData%\RayPack\Profiles\DEMO.rpprofile" -RayflowServiceUser #RAYFLOWSERVICEUSER# -RayflowServicePassword #RAYFLOWSERVICEPASSWORD# -RayflowUrl #RAYFLOWSERVICEURL# -RayflowProjectId #PROJECTID#'

WHERE ToolId IN

(SELECT t.ToolId

FROM Tools t

JOIN TaskList tl ON tl.TaskListID = t.TaskListId

JOIN Projects p ON p.ProjectID = tl.ProjectID

WHERE t.ToolArguments = 'rayflow -RayflowPackageId #PACKAGEID# -app "#PACKAGEFILE#" -appParams "" -wizardMode expert -projectName "#PACKAGENAME#" -profile "C:\Users\Administrator\AppData\Roaming\RayPack\Profiles\DEMO.rpprofile" -RayflowServiceUser #RAYFLOWSERVICEUSER# -RayflowServicePassword #RAYFLOWSERVICEPASSWORD# -RayflowUrl #RAYFLOWSERVICEURL# -RayflowProjectId #PROJECTID#'

AND p.ProjectName = '<enter project name here>')

 

Have more questions? Submit a request

Comments

  • Avatar
    Support RaySuite

    Please ensure that the RayFlow servers application pool is stopped before running these queries against its database, and then started again once those actions have been completed.

Powered by Zendesk