30 JULY 2019
This is an update for Cora SeQuence V8.8. This update includes a new feature and resolved issues.
New feature
Connection string settings for stored procedures: You can set up a connection string to run a stored procedure on another SQL Server database.
For details on setting up data models using stored procedures, see this article.
Resolved issues
| Component | Description | Ticket |
|---|---|---|
| App Studio | The Properties pane did not refresh when user moved between containers. | #66361 |
| Flowtime grids: Multi-selection filter | The values in the multi-selection filter did not refresh when you performed any action on the grid. | #65454 #65689 |
| Security breach | An XSS security breach was solved. |
Update steps
Updating from V8.8
- Back up your Cora SeQuence database.
- Back up the following files:
- In the Administration site:
bin\PNMsoft.Sequence.Studio.dllbin\PNMsoft.Rad.Web.UI.v8.dllbin\PNMsoft.Sequence.Extensions.Design.dllWeb\UI\AppStudio\Resources\Js\WorkflowDiagram.min.jsWeb\UI\Extensions\DataModel\DataSourcesList.ascxWeb\UI\Extensions\DataModel\StoredProcedureDataSourceEditor.ascx
- In the Flowtime site:
bin\PNMsoft.Rad.Web.UI.v8.dllbin\PNMsoft.Sequence.Runtime.Web.UI.dll
- All servers, in the GAC folder:
PNMsoft.Sequence.Administration.dllPNMsoft.Sequence.dllPNMsoft.Sequence.Security.dll
- In the Shared Resources folder:
Components\Flowtime\js\grid.min.js
- In the Administration site:
NOTE
Make sure that you save the backed up files in a different folder, such as the desktop.
- Download the ZIP file.
- Open the DB Scripts folder, and run the following script on your Cora SeQuence database:
PatchSynchronization_Data.sq
- Make sure the following files and folders are in the same level on the server.
EngineSequencePatch.xmlSequencePatcher.ps1
- Run
SequencePatcher.ps1file as Administrator on all Cora SeQuence servers.- Right click
SequencePatcher.ps1, and then select Run with PowerShell.
- Right click
Rollback steps
- Restore the Cora SeQuence database to previous state.
- Restore the backed up files.
NOTE
If you are running a Cora SeQuence version earlier than V8.8.2, you need to upgrade to V8.8.1.1 before you install V8.8.2.
