Upgrade Category Error: Difference between revisions
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 |
||
| 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> | |||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:NAA]] | [[Category:NAA]] | ||
[[Category:SQL Queries]] | [[Category:SQL Queries]] | ||
Revision as of 18:26, 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'