May
27
2019
T58-2016: Missing Initial SQL in BIOVIA Biological Registration data source
Biological Registration
The created Biological Registration data source is missing required "Initial SQL" used to set security on upgrade from BioReg 3.1 to BioReg 2016 and 2017.
Resolution:
This issue has been logged as a defect REG-16695 and will be considered for a fix in a future release. If you consider this issue to be high priority (i.e. this is severely blocking your use of this BIOVIA product), please contact BIOVIA Support.
Workaround:
- Manually add the following initial SQL: { call security.calculateSecurity('$(username)') } to the 2016 or 2017 Biological Registration data source in the Pipeline Pilot 2016 or 2017 Admin Portal and then restart Apache.
- This is accessed via the Pipeline Pilot Admin Portal > Setup > Data Sources
- Select the Biological Registration data source > Advanced > add the Initial SQL { call security.calculateSecurity('$(username)') } if it is not already present.