Closed SPlanzer closed 7 years ago
Below are the final points that required discussion and action prior to the proposal document sign off. As you see below, all points have either been actioned or deferred to the high level design.
@palmerj can you please review the doc? and when you are comfortable with it I will send the document out for review again.
JPs original feedback in black
+ My comments in green
- JPs further comments in red
Hi Simon,
I have reviewed the document and have the following comments:
i. The operational maintenance role is not well defined or managed. E.g Jeremy and Chris do ad-hoc stuff to keep it going, not too many people know how the system was built or works.
+ I HAVE ADDED THIS CONCERN TO THE DOCUMENT. I have added a section “Production Support” it is
+ obviously important we do not over commit Data Services here – please review and comment.
ii. ii) The server (Windows 2003) and PostgreSQL (8.4) are not well past end of life for vendor support. This cause can cause us both operational and security support issues.
+ ADDED TO DOC
iii) We do not have a robust DR or BCP plan with the business owner, meaning we are at risk if a disaster occurs.
+ The proposal outlines that we will gather RTO and RPO requirements. What else is required as part of the proposal here?
- Didn’t see that it will gather those - I must have somehow skipped over that - great then.
+THE DOCUMENT HAS THE SETTING OF THESE TIME FRAMES AS A REQUIREMENT (Requirements
+ Section) I have spoken with Ivan. He is comfortable with the level of reference in the proposal
+ document to recovery. We will establish RTO and RPO as part of the high level design requirements.
+ This will be more straight forward in the high level design phases once data volumes are understood.
+ Not sure about credit but surely money will be made available as we will no longer pay for the old
+ hardware and its support. Again is this not better suited to the high level design when we understand
+ what resources we require?
+ Does the NZGB currently contribute any costs to the database upkeep? Do I need to make them aware
+ at this stage there will be some cost to them?
- No there is no cost transfer from the SG to DS group. I would just put
- it as a risk, then it can be resolved during the HLD.
Project Scope items. I would say the setup of backup and restore process would be another item.
+ ADDED TO DOC
Out of scope - I would also add we will not be resolving the current IT security issue that allows the web database directly connect from the DMZ network to the production database within the Corporate network.
+ ADDED TO DOC
In the likely R&R who will be the project management? Ivan or you?
+ IVAN – Can you please comment?
Hi @palmerj, I plan to place this proposal document that is currently in Objective in the wiki for this repository.
This repository is public. Can anyone see any issue with the proposal residing here?
@palmerj, I also do understand you are busy the next few days - so when you can is fine.
cheers
I don't see any issue with the proposal being public. Just make sure there is no sensitive data in it. E.g vendor commercial details.
Hi @palmerj and @imincik can you please review the NZ Gazetteer Database Migration Proposal document and provide any feedback regarding actions required to achieve document sign off.
Changes since the last edition that have been made to reflect the updated SSF include:
@SPlanzer, I have reviewed the document. I have left a few minor comments for your consideration, but overall I endorse it. Next steps (once Ivan agrees) will be to engage Wendy and get her approval.
Note the LINZone/objective link you provided above gives the latest published version, but you had a newer draft version that contained updated information. This got be confused for a few mins! Maybe next time just publish the document?
Thanks Jeremy
Hi @SPlanzer , I wanted to review, but they are turning off Objective for night. So, I can't. It is another good reason not to store documents in progress there.
Objective still down. ...
My comments:
Hi @palmerj , @imincik I have made the chances requested
Ivan - You are right about Objective. I have had issues with Objective Documents freezing multiple times today. Though of more concern, as Jeremy points out above it seems the link I have shared relates to an older version. I was not aware that the link only points to published documents.
Some reason I can not publish the document (publish is greyed-out) so I have asked that objective shared a review link with you (this should be in your email inbox). Sorry Ivan I suspect that you will need to review this entire document as the last link was a fairly old version
My comments:
- Below action taken
My comments:
## Expected benefits
## Desired outcomes
# Interfaces
## Projects and programmes
The document has just been retracted and submitted again for approval.
The document was retracted and edit as Wendy made edits, all of which were accepted. All of these edits were grammatical in nature and did not alter the documents content.
Hi @SPlanzer I have approved now.
Hi @SPlanzer I have also approved now. Done !
As this project is considered extra small, it is not to be signed off by LILT as outlined in the Spatial Solution Lifecycle framework but a smaller group of key stake holders. Specifically: