Duplicated models in JasperReports Availability Individual Selected Models
Article ID: 259356
Updated On:
Products
Issue/Introduction
When I run a Jaspersoft Report (public/CA/Spectrum/reports/availability/individual/Availability Selected Models), in the "Select the Model Names" box some elements appear duplicated, why can this be?
Environment
Release : 21.2
Cause
Based on the following output below:
mysql> select '' as model_name,-1 as model_key from model union select model_name,model_key from (SELECT m.model_key, m.model_h, m.model_name, mt.mtype_name,flag From model m LEFT JOIN (select model_h as flag,model_h,model_key from devicemodel) dm on m.model_h =dm.model_h INNER JOIN modeltype mt ON(m.mtype_h = mt.mtype_h ) inner join reporting.v_security_string_accessibility_by_landscape sec on (m.landscape_h=sec.landscape_h) and (m.security_string=sec.security_string) and (is_security_enabled()= FALSE or sec.user_name='superuser') WHERE (1=true or 0=TRUE or 0=TRUE or 0=TRUE) AND (1=FALSE or (1 =TRUE and m.model_name LIKE '%XXXXXXXX%')) AND (0=FALSE or(0=TRUE and m.model_class=NULL)) AND (0=FALSE or(0=TRUE and m.landscape_h=NULL)) ) asd where (0=FALSE or(0=TRUE and flag is not null)) ORDER BY model_name;
+------------------------------------------------------------+-----------+
| model_name | model_key |
+------------------------------------------------------------+-----------+
| RND1***************************_Gi0/0/0.218 | 44259 |
| RND1***************************_Gi0/0/0.218 | 260586 |
| RND1***************************_Gi0/0/0.218 | 272857 |
| RND1***************************_Gi0/0/0.220 | 44222 |
| RND1***************************_Gi0/0/0.220 | 272866 |
| RND1***************************_Gi0/0/0.230 | 44250 |
| RND1***************************_Gi0/0/0.230 | 272867 |
| RND1***************************_Gi0/0/0.241 | 44237 |
| RND1***************************_Gi0/0/0.241 | 272868 |
| RND1***************************_Tu21990029 | 260599 |
| RND1***************************_Tu21990029 | 310643 |
mysql> select * from model where model_key in (44259,260586,272857,44222,272866,44250,272867,44237,272868,260599,310643);
+-----------+---------+---------------------------------------------+-----------------+---------------------+
| model_key | model_h | model_name | network_address | destroy_time |
+-----------+---------+---------------------------------------------+-----------------+---------------------+
| 44222 | 4347546 | RND1****************************_Gi0/0/0.220 | xx.yy.zzz.1 | 2019-11-27 14:51:41 |
| 44237 | 4347548 | RND1****************************_Gi0/0/0.241 | xx.yy.zzz.1 | 2019-11-27 14:51:41 |
| 44250 | 4347547 | RND1****************************_Gi0/0/0.230 | xx.yy.zzz.1 | 2019-11-27 14:51:41 |
| 44259 | 4347545 | RND1****************************_Gi0/0/0.218 | xx.yy.zzz.1 | 2019-11-27 14:51:41 |
| 260586 | 5027615 | RND1****************************_Gi0/0/0.218 | xx.yy.zzz.111 | 2021-12-14 18:31:52 |
| 260599 | 5027631 | RND1****************************_Tu21990029 | xx.yy.zzz.106 | NULL |
| 272857 | 5038215 | RND1****************************_Gi0/0/0.218 | xx.yy.zzz.1 | NULL |
| 272866 | 5038225 | RND1****************************_Gi0/0/0.220 | xx.yy.zzz.1 | NULL |
| 272867 | 5038226 | RND1****************************_Gi0/0/0.230 | xx.yy.zzz.1 | NULL |
| 272868 | 5038227 | RND1****************************_Gi0/0/0.241 | xx.yy.zzz.1 | NULL |
| 310643 | 5071699 | RND1****************************_Tu21990029 | xx.yy.zzz.102 | 2021-12-14 18:31:52 |
+-----------+---------+---------------------------------------------+-----------------+---------------------+
Resolution
The duplicated names in the Input Controls come from the destroyed models.
Additional Information
How to hide destroyed models in JasperReports Availability Individual Selected Models
https://knowledge.broadcom.com/external/article?articleId=259388
Attachments
Feedback
