"Re-connect Data" button: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "Button on main page of CFE that disconnects and re-connects data sources used regularly by CFE. Necessary because we Push and Pull data, and tables that are connected on one user's desktop would not be properly connected on another user's desktop. Also runs some basic consistency checks. Can result in errors, see Procedure when there are differences between L Log and L PHI. == Related articles == {{Related Articles}} Category:Centralized data..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Button on main page of [[CFE]] that disconnects and re-connects data sources used regularly by [[CFE]] | Button on main page of [[CFE]] that disconnects and re-connects data sources used regularly by [[CFE]]. | ||
The button needs to be clicked after each [[Pull]] because tables that are connected on one user's desktop would not be properly connected on another user's desktop. | |||
The button also runs some basic consistency checks between data sources that are stored separately and can therefore not use relational integrity. See [[Procedure when there are differences between L Log and L PHI]]. | |||
The program then also checks that the following queries are empty, and gives an error and a list if they are not: | |||
* [[Reconnect_check_Completes query]] is opened to help the [[Data Processor]] initiate the [[Re-sending data]] process | |||
* [[Reconnect_check_orphans query]] - [[Orphans in Centralized data.mdb]] for what to do about these | |||
* [[Reconnect_check_missing_L_Tables_content query]] | |||
== Related articles == | == Related articles == | ||
Latest revision as of 20:46, 24 March 2022
Button on main page of CFE that disconnects and re-connects data sources used regularly by CFE.
The button needs to be clicked after each Pull because tables that are connected on one user's desktop would not be properly connected on another user's desktop.
The button also runs some basic consistency checks between data sources that are stored separately and can therefore not use relational integrity. See Procedure when there are differences between L Log and L PHI.
The program then also checks that the following queries are empty, and gives an error and a list if they are not:
- Reconnect_check_Completes query is opened to help the Data Processor initiate the Re-sending data process
- Reconnect_check_orphans query - Orphans in Centralized data.mdb for what to do about these
- Reconnect_check_missing_L_Tables_content query
Related articles
| Related articles: |