Inactive enumvalue fix - Revision history

Alnaucler at 21:12, 12 April 2015

2015-04-12T21:12:43Z

← Older revision		Revision as of 23:12, 12 April 2015
Line 28:		Line 28:

	'''Quick fix'''<br/>		'''Quick fix'''<br/>
	If all inactive imsmaenums are in the four categories ''Mine Action Activity'', ''RecommendationType'', ''Worksite'' or ''Theme Type'' then is UPDATE query fix it.		If all inactive imsmaenums are in the four categories ''Mine Action Activity'', ''RecommendationType'', ''Worksite'' or ''Theme Type'' then this UPDATE query fix it.
	<pre>		<pre>
	UPDATE imsmaenum		UPDATE imsmaenum

Alnaucler at 15:01, 18 March 2015

2015-03-18T15:01:44Z

@@ Line 1: / Line 1: @@
-The upgrade scripts set '''wrongly''' some of the existing enumvalues to '''Inactive'''. (Tested with 8 Nov build and problem is still there)
+The upgrade scripts set '''wrongly''' some of the existing enumvalues to '''Inactive'''. (Tested with 18 Feb 2015 build and problem is still there)
 Compare the result of this query with the export you did before the upgrade.
@@ Line 15: / Line 15: @@
 "public".imsmaenum
 WHERE
 "public".imsmaenum.isactive = 'f'
 ORDER BY
@@ Line 30: / Line 26: @@
 # Set ''isactive'' to t (TRUE) if the country had them as Active in 5.08.04
 # Repeat 3 - 4 until all are done and run the query again as double-check of number of Inactive.
 {{NavBox Upgrade}}

Alnaucler at 20:07, 18 November 2014

2014-11-18T20:07:54Z

← Older revision		Revision as of 22:07, 18 November 2014
Line 1:		Line 1:
	The upgrade scripts set '''wrongly''' some of the existing enumvalues to '''Inactive'''. (~~Looking better~~ with 11 Nov build ~~need to be verified with more databases~~)		The upgrade scripts set '''wrongly''' some of the existing enumvalues to '''Inactive'''. (Tested with 8 Nov build and problem is still there)

	Compare the result of this query with the export you did before the upgrade.		Compare the result of this query with the export you did before the upgrade.

Alnaucler at 03:32, 18 November 2014

2014-11-18T03:32:51Z

← Older revision		Revision as of 05:32, 18 November 2014
Line 1:		Line 1:
	The upgrade scripts set '''wrongly''' some of the existing enumvalues to '''Inactive'''.		The upgrade scripts set '''wrongly''' some of the existing enumvalues to '''Inactive'''. (Looking better with 11 Nov build need to be verified with more databases)

	Compare the result of this query with the export you did before the upgrade.		Compare the result of this query with the export you did before the upgrade.

Alnaucler at 18:10, 7 October 2014

2014-10-07T18:10:50Z

← Older revision		Revision as of 20:10, 7 October 2014
Line 1:		Line 1:
	The upgrade scripts wrongly ~~add values to the four enumcategories so duplicates are created (This might be fixed now/NAA 2014-10-07).<br/>~~		The upgrade scripts set '''wrongly''' some of the existing enumvalues to '''Inactive'''.
	~~The upgrade scripts also set~~ some of the existing enumvalues to '''~~inactive~~'''

	~~This~~ query ~~(Query Y) fixes~~ the ~~four enumcategories (which might be fixed now/NAA 2014-10-07):~~		Compare the result of this query with the export you did before the upgrade.
	<pre>		<pre>
	~~Delete~~		SELECT DISTINCT
	~~From~~ imsmaenum a		"public".imsmaenum.imsmaenum_guid,
	~~Where~~ imsmaenum_guid ~~in ('0a0a-224d-1416fd019a4-b88d2be0-0-4cc1'~~, ~~'0a0a-224d-1416fd019a4-d726279e-1-1e59'~~,		"public".imsmaenum.enumcategory,
	~~'0a0a-224d-1416fd019a4-706a50d3-3-612d'~~, ~~'0a0a-224d-1416fd019a4-af464191-4-c125'~~, ~~'0a0a-224d-1416fd019a4-fd146973-5-20fc'~~,		"public".imsmaenum.enumvalue,
	~~'0a0a-224d-1416fd019a4-f226cffb-6-e6cf'~~, ~~'0a0a-224d-1416fd019a4-683d623a-7-777c', '0a0a-224d-1416fd019a4-3bde48c9-8-b54c'~~,		"public".imsmaenum.widgettype,
	~~'0a0a-224d-1416fd019a4-ecbeac5e-9-bacd', '0a0a-224d-1416fd019a4-d9d99edf-a-9e90', '0a0a-224d-1416fd019a4-f68dd115-b-20a1',~~		"public".imsmaenum.seqno,
	'~~0a0a-224d-1416fd019a4-4d707100-c-4d01', '0a0a-224d-1416fd019a4-578f86a7-d-b65f~~'~~, '0a0a-224d-1416fd019a4-a8c57e35-e-9bce',~~		"public".imsmaenum.dataentrydate,
	'~~0a0a-224d-1416fd019a4-bc85b8d0-f-ce2a~~'~~, '0a0a-224d-1416fd019a4-b8a8e92e-10-8d9', '0a0a-224d-1416fd019a4-1f1e8407-11-b89',~~		"public".imsmaenum.dataenterer,
	'~~0a0a-224d-1416fd019a4-f581855a-12-7ad~~'~~, '0a0a-224d-1416fd019a4-2947602a-13-888', '0a0a-224d-1416fd019a4-8c31904c-14-cbd',~~		"public".imsmaenum.isactive
	'~~0a0a-224d-1416fd019a4-cc3c4be8-15-7fd~~'~~, '0a0a-224d-1416fd019a4-7469e71b-16-868', '0a0a-2256-14150c2ec4d-5c24e7d6-c8-18c',~~		FROM
	'~~0a0a-223c-141556773b4-2eafbfc-0-5c22c~~'~~, '0a0a-223c-141556773b5-cdf8cf63-1-f947')~~		"public".imsmaenum
	~~And ((Select count(*)~~		WHERE
	~~From~~ imsmaenum b		("public".imsmaenum.enumcategory = 'Mine Action Activity' OR
	~~Where b~~.~~enumvalue = a~~.enumvalue ~~and b.enumcategory = a.enumcategory)~~		"public".imsmaenum.enumcategory = 'RecommendationType' OR
	~~> 1);~~		"public".imsmaenum.enumcategory = 'Worksite' OR
			"public".imsmaenum.enumcategory = 'Theme Type') AND
			"public".imsmaenum.isactive = 'f'
			ORDER BY
			"public".imsmaenum.enumcategory ASC,
			"public".imsmaenum.enumvalue ASC
	</pre>		</pre>

	# If you have ~~any duplicate rows in your result set due to the 4 enumcategories~~, ~~Query Y will fix that (which might be fixed now/NAA 2014-10-07)~~		# If you now have more values that are Inactive than before upgrade, you need do the steps below until you have equally many Inactive ('''mandatory''')

	~~# You~~ need do the steps below until you have ~~no duplicates~~ ('''mandatory''')
	# Open table ''imsmaenum'' with Navicat and sort on ''enumcategory''		# Open table ''imsmaenum'' with Navicat and sort on ''enumcategory''
	# Compare the result set from '''before''' the upgrade scripts with current records		# Compare the result set from '''before''' the upgrade scripts with current records
	# ~~If necessary set~~ ''isactive'' to t (TRUE) ~~on the old rows~~ if the country had them as Active in 5.08.04 ~~and delete the new rows.~~		# Set ''isactive'' to t (TRUE) if the country had them as Active in 5.08.04
	# Repeat 3 - 4 until all are done and run ~~Query 2~~ as double-check of ~~no duplicates remain~~.		# Repeat 3 - 4 until all are done and run the query again as double-check of number of Inactive.

	{{NavBox Upgrade}}		{{NavBox Upgrade}}

Alnaucler: Created page with "The upgrade scripts wrongly add values to the four enumcategories so duplicates are created (This might be fixed now/NAA 2014-10-07).
The upgrade scripts also set some of..."

2014-10-07T18:02:58Z

Created page with "The upgrade scripts wrongly add values to the four enumcategories so duplicates are created (This might be fixed now/NAA 2014-10-07).<br/> The upgrade scripts also set some of..."

New page

The upgrade scripts wrongly add values to the four enumcategories so duplicates are created (This might be fixed now/NAA 2014-10-07).<br/>
The upgrade scripts also set some of the existing enumvalues to '''inactive'''

This query (Query Y) fixes the four enumcategories (which might be fixed now/NAA 2014-10-07):
<pre>
Delete
From imsmaenum a
Where imsmaenum_guid in ('0a0a-224d-1416fd019a4-b88d2be0-0-4cc1', '0a0a-224d-1416fd019a4-d726279e-1-1e59',
'0a0a-224d-1416fd019a4-706a50d3-3-612d', '0a0a-224d-1416fd019a4-af464191-4-c125', '0a0a-224d-1416fd019a4-fd146973-5-20fc',
'0a0a-224d-1416fd019a4-f226cffb-6-e6cf', '0a0a-224d-1416fd019a4-683d623a-7-777c', '0a0a-224d-1416fd019a4-3bde48c9-8-b54c',
'0a0a-224d-1416fd019a4-ecbeac5e-9-bacd', '0a0a-224d-1416fd019a4-d9d99edf-a-9e90', '0a0a-224d-1416fd019a4-f68dd115-b-20a1',
'0a0a-224d-1416fd019a4-4d707100-c-4d01', '0a0a-224d-1416fd019a4-578f86a7-d-b65f', '0a0a-224d-1416fd019a4-a8c57e35-e-9bce',
'0a0a-224d-1416fd019a4-bc85b8d0-f-ce2a', '0a0a-224d-1416fd019a4-b8a8e92e-10-8d9', '0a0a-224d-1416fd019a4-1f1e8407-11-b89',
'0a0a-224d-1416fd019a4-f581855a-12-7ad', '0a0a-224d-1416fd019a4-2947602a-13-888', '0a0a-224d-1416fd019a4-8c31904c-14-cbd',
'0a0a-224d-1416fd019a4-cc3c4be8-15-7fd', '0a0a-224d-1416fd019a4-7469e71b-16-868', '0a0a-2256-14150c2ec4d-5c24e7d6-c8-18c',
'0a0a-223c-141556773b4-2eafbfc-0-5c22c', '0a0a-223c-141556773b5-cdf8cf63-1-f947')
And ((Select count(*)
From imsmaenum b
Where b.enumvalue = a.enumvalue and b.enumcategory = a.enumcategory)
> 1);
</pre>

# If you have any duplicate rows in your result set due to the 4 enumcategories, Query Y will fix that (which might be fixed now/NAA 2014-10-07)

# You need do the steps below until you have no duplicates ('''mandatory''')
# Open table ''imsmaenum'' with Navicat and sort on ''enumcategory''
# Compare the result set from '''before''' the upgrade scripts with current records
# If necessary set ''isactive'' to t (TRUE) on the old rows if the country had them as Active in 5.08.04 and delete the new rows.
# Repeat 3 - 4 until all are done and run Query 2 as double-check of no duplicates remain.

{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]