Upgrade Category Error: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Created page with "In Peru database there was an unexpected category Hazard Reduction. 300px Category:NoPublic Category:NAA Category:SQL Queries"
 
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
In Peru database there was an unexpected category Hazard Reduction.
In Peru database there was an unexpected category in Hazard Reduction. <br/>
[[Image:Category_error.png|300px]]
[[Image:Category_error.png|300px]]<br/> <br/>
[[Image:Category_error2.png|500px]]
 
There were '''no''' error messages when opening Data Inventory Manager nor Summary Template designer but opening DEF designer.<br/>
 
[[Image:Category_error3.png|600px]]
[[Image:Category_error4.png|275px]]
 
<pre>
Internal Error: com.fgm.imsma.model.exception.ModelException: Failed to query Fields using a criterion.
com.fgm.imsma.model.exception.ModelException: Failed to query Fields using a criterion.
at com.fgm.imsma.model.DefaultModel.getAllCriterion(DefaultModel.java:415)
at com.fgm.imsma.pojo.expression.AbstractImsmaCriterion.getAll(AbstractImsmaCriterion.java:148)
at com.fgm.imsma.pojo.PojoEnum.getAllCriterion(PojoEnum.java:1202)
</pre>
 
<pre>
UPDATE field
SET category_guid = '0a0a-5045-112c52995ad-d5d4aa30-5f-534'
WHERE category_guid = 'c0a8-0121-12e9234ae94-276a0098-2-71bf'
 
DELETE
from category where pojo_parent = 'DETECTION'
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:NoPublic]]
[[Category:NAA]]
[[Category:NAA]]
[[Category:SQL Queries]]
[[Category:SQL Queries]]

Latest revision as of 18:31, 4 August 2014

In Peru database there was an unexpected category in Hazard Reduction.


There were no error messages when opening Data Inventory Manager nor Summary Template designer but opening DEF designer.

Internal Error: com.fgm.imsma.model.exception.ModelException: Failed to query Fields using a criterion.
com.fgm.imsma.model.exception.ModelException: Failed to query Fields using a criterion.
	at com.fgm.imsma.model.DefaultModel.getAllCriterion(DefaultModel.java:415)
	at com.fgm.imsma.pojo.expression.AbstractImsmaCriterion.getAll(AbstractImsmaCriterion.java:148)
	at com.fgm.imsma.pojo.PojoEnum.getAllCriterion(PojoEnum.java:1202)
UPDATE field
SET category_guid = '0a0a-5045-112c52995ad-d5d4aa30-5f-534'
WHERE category_guid = 'c0a8-0121-12e9234ae94-276a0098-2-71bf'

DELETE
from category where pojo_parent = 'DETECTION'

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:|}}{{#if:Upgrade Process|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:|{{#if:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:upgrade category error

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:|{{{group2}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list2}}}

}}{{#if:|{{#if:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:upgrade category error

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:|{{{group3}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list3}}}

}}{{#if:|{{#if:|{{{group4}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list4}}}

}}{{#if:|{{#if:|{{{group5}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list5}}}

}}{{#if:|{{#if:|{{{group6}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list6}}}

}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list7}}}

}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list8}}}

}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list9}}}

}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list10}}}

}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list11}}}

}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list12}}}

}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list13}}}

}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list14}}}

}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list15}}}

}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list16}}}

}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list17}}}

}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list18}}}

}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list19}}}

}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list20}}}

}}{{#if:|{{#if:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:upgrade category error

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}

{{{below}}}

}}{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:upgrade category error
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}