000029079 - QA 5.5.1 VRM We can’t assign an issue to anyone (even the admin account can’t use the drop down or type anything into the “assignee” field)

Document created by RSA Customer Support Employee on Jun 15, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000029079
Applies ToRSA Product Set: Security Management
RSA Product/Service Type: Vulnerability Risk Manager
RSA Version/Condition: 1.1
Platform: Windows
Platform (Other): null
O/S Version: 2008 Server R2 Enterprise (64 bit)
Product Name: null
Product Description: null
IssueFolks …good news… we are making progress on this front and are past the previous hurdles. We are now hitting the below when we want to try and assign an issue to a person. Hi Jimmy – here is item we need from RSA for VRM: 1.We can’t assign an issue to anyone (even the admin account can’t use the drop down or type anything into the “assignee” field)
The Archerlookup job is failing with this error in the collector log:
 
11 Nov 2014 14:28:16,942 | INFO - PasswordAwareSimpleJobLauncher$1.run(101) | Job: [FlowJob: [name=loadArcherLookupBatchJob]] launched
11 Nov 2014 14:28:16,942 | INFO - TalendTasklet.execute(51) | getArcherLookup: RUNNING
11 Nov 2014 14:28:24,227 | ERROR - GetArcherLookup.tLogCatcher_1Process(11882) | Error occured processing GetArcherLookup job. Message is net.sf.saxon.trans.XPathException:org.xml.sax.SAXParseException; systemId: file:/E:/rsa/vrm/incoming/feeds/tmp/getArcherLookup/20141111_142816/RawLookupTable.xml; lineNumber: 213; columnNumber: 7; The element type "Root" must be terminated by the matching end-tag "</Root>".
11 Nov 2014 14:28:24,227 | ERROR - TalendTasklet.execute(70) | getArcherLookup: ERROR | Etl job failed with return code: 1
11 Nov 2014 14:28:24,492 | INFO - PasswordAwareSimpleJobLauncher$1.run(103) | Job: [FlowJob: [name=loadArcherLookupBatchJob]] completed with the following status: [COMPLETED]
RawLookupTable.xml does have a root close tag at the end of the file but is missing tags at line 210.  See attachment and bellow.
<?xml version="1.0" encoding="utf-8"?>
<Root>
<SelectDef>
  <Id>10</Id>
  <SelectName>Type</SelectName>
  <GlobalFlag>False</GlobalFlag>
  <Sort>1</Sort>
  <SelectDefValues>
    <SelectDefValue>
      <guid>28017417-40a3-40ad-a01f-b6ac544d0224</guid>
      <Id>80</Id>
      <Name>A/V Equipment</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>0</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>ee6ef3af-8bbe-4afc-8375-e49930afbfb7</guid>
      <Id>81</Id>
      <Name>Desktop</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>4</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>d005ceb1-3549-41f3-8835-fec473f08e1b</guid>
      <Id>82</Id>
      <Name>Handheld</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>9</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>fa17cbf5-720c-48a6-b406-c111a263d5ae</guid>
      <Id>83</Id>
      <Name>Laptop</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>11</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>a1d3b013-b0fe-4a90-8ecf-77b2106ddd58</guid>
      <Id>84</Id>
      <Name>Router</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>14</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>ad40816b-bb85-4c5d-9951-cf6f2640796c</guid>
      <Id>85</Id>
      <Name>Application Server</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>1</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>afe461b1-a5ae-4b68-a2d9-12b2d1e2f763</guid>
      <Id>86</Id>
      <Name>Switch</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>18</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>e9b9284a-9897-469a-902b-c0d143cbb703</guid>
      <Id>1204</Id>
      <Name>Database Server</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>3</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>34a098f0-c2e0-4c04-b5f8-11262f320fb2</guid>
      <Id>1205</Id>
      <Name>File Server</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>7</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>c7e1cd35-ecfa-4948-a936-b5eaf633f896</guid>
      <Id>1206</Id>
      <Name>Print Server</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>13</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>ac7dc956-1b56-488c-9b18-adf526a4c57b</guid>
      <Id>1207</Id>
      <Name>Web Server</Name>
      <Description></Description>
      <Color></Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>19</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>698ef1e1-4f30-4c98-a4b8-8e8c9bb59dcd</guid>
      <Id>65966</Id>
      <Name>Server</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>16</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>4941401d-4067-4e54-82e7-6e8405f6da21</guid>
      <Id>65969</Id>
      <Name>PBX</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>12</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>6718ec8d-96c1-48aa-a30d-70a95b671278</guid>
      <Id>65970</Id>
      <Name>StorageSubsystem</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>17</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>9a4af84f-c93e-4815-915e-8dc69b10c5c1</guid>
      <Id>65971</Id>
      <Name>Firewall</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>8</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>1934f98f-3c30-44cc-a93e-a0017d58ec49</guid>
      <Id>65973</Id>
      <Name>Blade Server</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>2</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>5950b6c8-64d5-4e00-8586-c72ad85cab83</guid>
      <Id>326884</Id>
      <Name>EMC Storage Array</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>5</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>41ff405e-b2c1-4dae-8ba5-87fc7a32bc85</guid>
      <Id>326885</Id>
      <Name>Fibre Channel SAN Switch</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>6</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>d2f703a5-f591-4b91-9a11-511dff35a267</guid>
      <Id>326886</Id>
      <Name>Infrastructure Server</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>10</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
    <SelectDefValue>
      <guid>bfd12f7f-c66b-4279-9296-6b5bf2cf02dd</guid>
      <Id>326887</Id>
      <Name>Security Device</Name>
      <Description></Description>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>15</SortOrder>
      <select_id>10</select_id>
    </SelectDefValue>
  </SelectDefValues>
</SelectDef>escription>
      <Color>#000000</Color>
      <DefaultFlag>False</DefaultFlag>
      <SortOrder>9128</SortOrder>
      <select_id>412</select_id>
    </SelectDefValue>
CausePlatform Values list field in the Devices application incorrectly had thousands of server names and the API call from the collector could only deal with the last few hundred. Clearing out the bad Platform values from the field down to the needed 18 or so resolved the issue with the collector.
ResolutionClear out the bad Platform values from the field down to the needed 18 or so will resolve the issue with the collector.

Outcomes