Deleting the manually Added City name entries from NetIM Database (Starting from 2.x versions)

Categories:
Solution Number:
S38641
Last Modified:
2025-02-18
Description
Earlier we used to add manual entries for the cities unavailable in the NetIM database but as we have expanded our database, almost cities are available now.
Now we have came across in a situation where we may see twice entry for the same city (one we added manually and the other one is from the default database of NetIM).

Solution
We can delete the manually added city names in a very easy way but these steps must be performed during a maintenance window as the service stop and start is must to get these changes in effect. 
  1. We need to reach the directory/ folder from NetIM Core VM : "/data1/riverbed/NetIM/2.x.x_xxxx/lib/xml/res/geo/"
  2. Open the "geo" folder and find the file named "Geo_en_changes.res" (it is  the file where we manully add the city entry).
  3. Open it in Notepad and Delete the entire entry for the unwanted city (including country, state, city, timezone etc).
  4. Save the file using Ctrl+S.
  5. SSH to the NetIM core using Putty.
  6. Run the command mentioned below-
    ;stop all 
    app.sh UPDATE_GEO_DATA
    start all

     
  7. Login to the NetIM core, check and you won't see the same city entry for twice.


Note: The above mentioned steps must be followed during a maintenance window as the service stop and start is required to take the changes place.


Example of step 3: Here I want delete City named "Eagan".

Before Deleting"Eagan city"-

        Add cities not present in the dataset
        These should be listed under their appropriate country and region codes
        If the city does not have a region code use "only" as the region code
        At a minimum you should define latitude, longitude, and timezone.
    -->
    <fs:cp name="geoAdditions">
      <fs:cp name="US">
        <fs:cp name="MN">
          <fs:cp name="Eagan">
              <fs:sp name="timezone">America/Chicago</fs:sp>
              <fs:sp name="latitude">44.8041</fs:sp>
              <fs:sp name="longitude">-93.1668</fs:sp>
              <fs:sp name="postalCode">55121</fs:sp>
          </fs:cp>
        </fs:cp>
      </fs:cp>
      <fs:cp name="US">
        <fs:cp name="MN">
          <fs:cp name="Bloomington">
              <fs:sp name="timezone">America/Chicago</fs:sp>
              <fs:sp name="latitude">44.8407</fs:sp>
              <fs:sp name="longitude">-93.2982</fs:sp>
              <fs:sp name="postalCode">55437</fs:sp>
          </fs:cp>


After Deleting-

Add cities not present in the dataset
        These should be listed under their appropriate country and region codes
        If the city does not have a region code use "only" as the region code
        At a minimum you should define latitude, longitude, and timezone.
    -->
    <fs:cp name="geoAdditions">
            <fs:cp name="US">
        <fs:cp name="MN">
          <fs:cp name="Bloomington">
              <fs:sp name="timezone">America/Chicago</fs:sp>
              <fs:sp name="latitude">44.8407</fs:sp>
              <fs:sp name="longitude">-93.2982</fs:sp>
              <fs:sp name="postalCode">55437</fs:sp>
          </fs:cp>



 
Attachments
NOTICE: Riverbed® product names have changed. Please refer to the Product List for a complete list of product names.
Can't find an answer? Create a case