Changes between Version 33 and Version 34 of Psps_MD_PV2

Timestamp:

Nov 24, 2014, 12:45:27 PM (12 years ago)

Author:

chenx

Comment:

--

Psps_MD_PV2

@@ -184 +184 @@
 missing ones, where 0 are loaded into psps: 43
 }}}
+
+-----------------------
+Load missing OB batches
+-----------------------
+
+The query to get all in WMD:
+{{{
+select D.* from WMD.StateReg.Batch B, WMD.StateReg.DbObject D, WMD.StateReg.[Load] L 
+where L.pkeyBatch = B.pkey AND L.pkeyDbObject = D.pkey AND
+B.BatchName in ( 
+'M09_OB_B01472702',
+'M01_OB_B01472843',
+'M09_OB_B01472564',
+'M06_OB_B01451985',
+'M09_OB_B01472797',
+'M06_OB_B01452062',
+'M06_OB_B01452103',
+'M06_OB_B01452041',
+'M09_OB_B01472519',
+'M07_OB_B01477840',
+'M06_OB_B01452017',
+'M08_OB_B01485856',
+'M06_OB_B01452018',
+'M01_OB_B01472561',
+'M01_OB_B01472520',
+'M06_OB_B01452104',
+'M09_OB_B01472863',
+'M06_OB_B01452261',
+'M01_OB_B01472725',
+'M06_OB_B01451948',
+'M08_OB_B01485921',
+'M07_OB_B01477695',
+'M09_OB_B01472648',
+'M09_OB_B01472144',
+'M06_OB_B01452102',
+'M07_OB_B01477873',
+'M01_OB_B01472778',
+'M07_OB_B01477930',
+'M07_OB_B01477533',
+'M07_OB_B01478103',
+'M09_OB_B01472755',
+'M07_OB_B01477603',
+'M09_OB_B01473031',
+'M09_OB_B01472464',
+'M09_OB_B01472363',
+'M06_OB_B01452061',
+'M09_OB_B01472081',
+'M06_OB_B01452060',
+'M10_OB_B01495720',
+'M06_OB_B01452040',
+'M01_OB_B01471707',
+'M09_OB_B01472418',
+'M06_OB_B01452214'
+)
+}}}
+
+As of 11/24/2014, there are 3 with issues:
+{{{
+42440   LM03    LM03    Load_PS1_M07_0102       M07_OB_B01477533        1073741825      0       M07     LoadStarted OnHold      Load
+42433   LM04    LM04    Load_PS1_M09_0304       M09_OB_B01473031        1073741825      0       M09     LoadStarted OnHold      Load
+39569   LM07    LM07    Load_PS1_M10_0102       M10_OB_B01495720        51      0       M10     LoadStarted LoadCompleted Merge1Started Merge1Completed Load
+}}}
+
+Note M10_OB_B01495720 was not loaded properly (the table Load_PS1_M10_0102.M10_OB_B01495720.[Object] was empty). So I delete all entries of it from WMD (load, batch, dbobject) and load db Load_PS1_M10_0102.
+
+These 3 batches should be reloaded.
 
 === Batches with Extra Stack Detections ===