(Modified comment string {{PONYDOCSVERSION}} with {{#explode:{{FULLPAGENAME}}|:|4}}) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
= Verify Content 1= | = Verify Content 1= | ||
| + | |||
| + | The job aids on this page and on [[Z_VerifyContent2|Verify Content 2]] basically use checksums from Cargo and DPL queries to verify (a) that the actual data is correct (e.g., writer didn't forget to identify new tables/columns) and (b) that the data stored in Cargo and used to generate query results is complete. The pages have been split because having too many queries on a page can kill page performance. | ||
| + | {{NoteFormat|Be sure to check the [[Z_VerifyContent2|Verify Content 2]] page as well.}} | ||
{{AnchorDiv|VerifyDeltas}} | {{AnchorDiv|VerifyDeltas}} | ||
| Line 15: | Line 18: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-%:{{ | + | |titlematch=%GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}} |
|resultsheader=There are %PAGES% tables (including SDR_*), | |resultsheader=There are %PAGES% tables (including SDR_*), | ||
|include= | |include= | ||
| Line 22: | Line 25: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-%:{{ | + | |titlematch=%GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}} |
|notuses=Template:PDMIndexItem | |notuses=Template:PDMIndexItem | ||
|resultsheader=%PAGES% do not have indexes. | |resultsheader=%PAGES% do not have indexes. | ||
| Line 32: | Line 35: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-%:{{ | + | |titlematch=%GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}} |
|uses=Template:PDMIndexItem | |uses=Template:PDMIndexItem | ||
|include= | |include= | ||
| Line 41: | Line 44: | ||
<li>{{#dpl: | <li>{{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-%:{{ | + | |titlematch=%GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}} |
|includematch=/indexPresentInPartitioned\s*=\s*no/ | |includematch=/indexPresentInPartitioned\s*=\s*no/ | ||
|include={PDMIndexItem}:indexName | |include={PDMIndexItem}:indexName | ||
| Line 52: | Line 55: | ||
<li>{{#dpl: | <li>{{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-%:{{ | + | |titlematch=%GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}} |
|includenotmatch=/keyPresentInNonpartitioned/ | |includenotmatch=/keyPresentInNonpartitioned/ | ||
|include={PDMIndexItem}:indexName | |include={PDMIndexItem}:indexName | ||
| Line 63: | Line 66: | ||
<li>{{#dpl: | <li>{{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-%:{{ | + | |titlematch=%GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}} |
|includematch=/keyPresentInNonpartitioned[0-9]?\s*=\s*no/ | |includematch=/keyPresentInNonpartitioned[0-9]?\s*=\s*no/ | ||
|include={PDMIndexItem}:indexName | |include={PDMIndexItem}:indexName | ||
| Line 126: | Line 129: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=GIM:Library:Table-%:{{ | + | |titlematch=GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}}% |
|uses=Template:PDMColumn | |uses=Template:PDMColumn | ||
|includematch=/colName\s*=\s*START_DATE_TIME_KEY/ | |includematch=/colName\s*=\s*START_DATE_TIME_KEY/ | ||
| Line 141: | Line 144: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=GIM:Library:Table-%:{{ | + | |titlematch=GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}}% |
|uses=Template:PDMColumn | |uses=Template:PDMColumn | ||
|includematch=/colName\s*=\s*.*_AUDIT_KEY/ | |includematch=/colName\s*=\s*.*_AUDIT_KEY/ | ||
| Line 157: | Line 160: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=GIM:Library:Table-%:{{ | + | |titlematch=GIM:Library:Table-%:{{#explode:{{FULLPAGENAME}}|:|4}}% |
|uses=Template:PDMColumn | |uses=Template:PDMColumn | ||
|includematch=/colName\s*=\s*TENANT_KEY/ | |includematch=/colName\s*=\s*TENANT_KEY/ | ||
| Line 176: | Line 179: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=GIM:Library:%:{{ | + | |titlematch=GIM:Library:%:{{#explode:{{FULLPAGENAME}}|:|4}}% |
|uses=Template:Editgrn_open | |uses=Template:Editgrn_open | ||
|noresultsheader=No pages have highlighted text. | |noresultsheader=No pages have highlighted text. | ||
| Line 184: | Line 187: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=GIM:Library:%:{{ | + | |titlematch=GIM:Library:%:{{#explode:{{FULLPAGENAME}}|:|4}}% |
|uses=Template:Chgbar_open | |uses=Template:Chgbar_open | ||
|noresultsheader=No pages have change bars. | |noresultsheader=No pages have change bars. | ||
Latest revision as of 21:39, January 10, 2020
Contents
Verify Content 1
The job aids on this page and on Verify Content 2 basically use checksums from Cargo and DPL queries to verify (a) that the actual data is correct (e.g., writer didn't forget to identify new tables/columns) and (b) that the data stored in Cargo and used to generate query results is complete. The pages have been split because having too many queries on a page can kill page performance.
Verify Summary of Table/Column Changes
The Summary of Info Mart Schema Changes page is constructed by Cargo query. To verify that the Cargo table has updated completely following table page updates, do a checksum of the number of entries in the summary table. Update the following running total as releases are published, so you have a correct baseline for the next checksum.
Checksum
As of release 8.5.014.19, there are 394 entries in the summary table.
Unexplained discrepancy from 8.5.014.09, which showed a total of 384.
JD maybe to do: Provide DPL queries to double-check totals. (For performance reasons, the queries would have to be on separate pages.)
Verify Indexes
There are 132 tables (including SDR_*), of which 26 do not have indexes.
Of the 106 tables that have indexes:
- All indexes are present in partitioned (no indexPresentInPartitioned=no).All indexes are present in partitioned (no indexPresentInPartitioned=no).
- All indexes have keyPresentInNonpartitioned on the page.All indexes have keyPresentInNonpartitioned on the page.
- All index keys are present in nonpartitioned (no keyPresentInNonpartitioned[1], etc.=no).All index keys are present in nonpartitioned (no keyPresentInNonpartitioned[1], etc.=no).
Verify Primary and Foreign Keys
Composite primary keys
Since we have elected to show the nonpartitioned settings in the Column List tables, START_DATE_TIME_KEY is not a primary key in most tables, whereas it is in the partitioned script. However, START_DATE_TIME_KEY is part of a composite PK even in the nonpartitioned script. You may need to manually correct Mykola's import file to set START_DATE_TIME_KEY correctly.
The following table lists the GIM tables where START_DATE_TIME_KEY is part of the composite PK. Use the DPL result that follows the table to verify that START_DATE_TIME_KEY has been set correctly.
| Table | Composite PK |
|---|---|
| BGS_SESSION_FACT | CBS_ID,START_DATE_TIME_KEY |
| CALLBACK_FACT | START_DATE_TIME_KEY,ADDED_TS,DS_AUDIT_KEY,EVENT_SEQUENCE |
| CHAT_SESSION_FACT | MEDIA_SERVER_IXN_GUID,START_DATE_TIME_KEY |
| GPM_FACT | MEDIA_SERVER_IXN_GUID,ROUTE_ATTEMPT_ID,RESOURCE_KEY,START_DATE_TIME_KEY |
| SDR_ACTIVITIES_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SDR_CUST_ATRIBUTES_FACT | SESSION_ID,START_DATE_TIME_KEY,SDR_CUST_ATRIBUTES_KEY |
| SDR_EXT_REQUEST_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SDR_SESSION_FACT | SESSION_ID,START_DATE_TIME_KEY |
| SDR_SURVEY_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SDR_SURVEY_TRANSCRIPT_FACT | SESSION_ID,START_DATE_TIME_KEY |
| SDR_USER_INPUTS_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SDR_USER_MILESTONE_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SM_MEDIA_NEUTRAL_STATE_FACT | START_DATE_TIME_KEY, RESOURCE_KEY, RESOURCE_STATE_KEY, START_TS |
Value of the primaryKey parameter for START_DATE_TIME_KEY on the following table(s):
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CDR FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CHAT THREAD FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-COBROWSE FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-LDR FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR USER MILESTONE FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT - yes
Audit keys
Use the following DPL to confirm that *_AUDIT_KEYs display as a foreign key:
All tables show *_AUDIT_KEY as a foreign key.All tables show *_AUDIT_KEY as a foreign key.
Tenant key
Use the following DPL to confirm that TENANT_KEY displays as a foreign key:
All tables show TENANT_KEY as a foreign key.All tables show TENANT_KEY as a foreign key.
Check Highlights, Change Bars, and Font Colors
The following pages have highlighted text:
- Documentation:GIM:Library:AboutThisPDM:8.5DRAFT
- Documentation:GIM:Library:InfoMart85Tables:8.5DRAFT
- Documentation:GIM:Library:InfoMart85Views:8.5DRAFT
- Documentation:GIM:Library:SubjectAreas:8.5DRAFT
- Documentation:GIM:Library:Table-GROUP ANNEX:8.5DRAFT
- Documentation:GIM:Library:View-CDR:8.5DRAFT
- Documentation:GIM:Library:View-CDR DATE TIME:8.5DRAFT
- Documentation:GIM:Library:Z GenerateDataExportList:8.5DRAFT
- Documentation:GIM:Library:Z GenerateExportLists:8.5DRAFT
- Documentation:GIM:Library:Z Instructions:8.5DRAFT
The following pages have change bars: No pages have change bars.