This article explains how to fix the issue if the content of the variable is not displaying in Junos Space Security Director.

Here is the screenshot of the issue:

We need to follow this article only if the steps in the article KB78328 [juniper.net] don't fix this issue

To identify the issue, please run the below command in Junos space CLI:

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') sm_db

mysql> select * from VariableDefinition_VariableValue limit 5;

+-------------------+-----------------------------+

| variableValues_id | VariableDefinitionEntity_id |

+-------------------+-----------------------------+

| 266954 | 0 |

| 266955 | 0 |

| 266956 | 0 |

| 266957 | 0 |

| 266958 | 0 |

+-------------------+-----------------------------+

5 rows in set (0.00 sec)

The VariableDefinitionEntity_id shows 0 for each variable in the table VariableDefinition_VariableValue. That’s why it is showing no content.

To fix the issue, please follow the below steps:

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') sm_db

UPDATE VariableDefinition_VariableValue vdv

JOIN VariableValue vv 

   ON vdv.variableValues_id = vv.id

SET vdv.VariableDefinitionEntity_id = vv.parent_id;

Note: Please take VM snapshot before proceeding with this step for a backup plan.