Support Support Downloads Knowledge Base Service Request Manager My Juniper Community

Knowledge Base

Search our Knowledge Base sites to find answers to your questions.

Ask All Knowledge Base Sites All Knowledge Base Sites JunosE Defect (KA)Knowledge BaseSecurity AdvisoriesTechnical BulletinsTechnotes Sign in to display secure content and recently viewed articles

[Archive] [Junos Space] Display issue with View Physical Inventory page on platform

0

0

Article ID: KB30498 KB Last Updated: 06 Sep 2019Version: 2.0
Summary:

When you log in to the Junos Space Web UI, select the device, right-click, and navigate to Device Inventory > View Physical inventory, the new window doesn't display the inventory information. However, you can export the inventory to a CSV file and view the details.

Symptoms:

Inventory information is not displayed when navigating to the Device Inventory > View Physical inventory window.

Cause:

The reason for the display issue is that Junos Space cannot handle the special character ' (single apostrophe), as shown in the output below in the 'installedVersion' column of the mysql database table equipment.

[root@space~]# mysql -u jboss -pnetscreen build_db

[root@space~]#select e.id,e.name, e.installedModel, e.installedPartNumber, e.installedSerialNumber, e.installedVersion, e.path, e.manufacturer, l.name, l.platform from Equipment e, LogicalDevice l where installedVersion like "%\'" and e.deviceId=l.id;
+----------+---------+----------------+---------------------+-----------------------+
| id | name | installedModel | installedPartNumber | installedSerialNumber | installedVersion | path | manufacturer | name | platform |
+----------+---------+----------------+---------------------+-----------------------+
| 16549949 | Xcvr 10 | NULL | NON-JNPR | AGA124113DW | ' | 16482366/Chassis (node0)/FPC 0/PIC 0/Xcvr 10 | juniper | VFMTLRC01PG | SRX3400 |
| 16550169 | Xcvr 10 | NULL | NON-JNPR | AGA124113DW | ' | 16482382/Chassis (node0)/FPC 0/PIC 0/Xcvr 10 | juniper | VFMTLRC01PG | SRX3400 |
| 24970241 | Xcvr 10 | NULL | NON-JNPR | FNS15251QDA | ' | 24870934/Chassis (node0)/FPC 0/PIC 0/Xcvr 10 | juniper | VFLABDESJ03 | SRX3400 |
| 24970173 | Xcvr 10 | NULL | NON-JNPR | FNS15251QDA | ' | 24870938/Chassis (node0)/FPC 0/PIC 0/Xcvr 10 | juniper | VFLABDESJ03 | SRX3400 |
+----------+---------+----------------+---------------------+-----------------------+

 
Solution:

Replace the special character with NULL, and Junos Space will be able to fetch the inventory information, for example:

update Equipment set installedVersion=' ' where id=16549949;
update Equipment set installedVersion=' ' where id=16550169;
update Equipment set installedVersion=' ' where id=24970241;
update Equipment set installedVersion=' ' where id=24970173;


[root@space~]# quit

Log in to the Junos Space Web UI and you should be able to view the inventory details for the device.

This issue is seen as of Junos Space Release 14.1R3.

Comment on this article > Affected Products Browse the Knowledge Base for more articles related to these product categories. Select a category to begin.

Security Alerts and Vulnerabilities

Security Alerts and Vulnerabilities Product Alerts and Software Release Notices Problem Report (PR) Search Tool EOL Notices and Bulletins JTAC User Guide Customer Care User Guide Pathfinder SRX High Availability Configurator SRX VPN Configurator Training Courses and Videos End User Licence Agreement Global Search