2018.2.0 Updates

Download software updates and release notes for Spectrum Technology Platform version 2018.2.0 products.

Apply all the Platform updates in addition to updates for the modules you have installed.

Important: You must install updates in order. For example you must install S01 before S02, and S02 before S03, and so on.

Platform

Update Description Download
2018.2.0 S10 This product update fixes multiple issues and provides some security enhancements.

Server error

Received error “java.lang.NumberFormatException: null” when running a dataflow in Distributed mode

Enterprise Designer fixes
  • Display help in French, according to locale
  • Some subflows are missing for users with non-administrator rights

Security enhancements

  • Provide a way to export security overrides through Admin Utility
  • Add logout events to the audit log
  • Allow LDAP/AD connection with multiple domains

This product update is optional and applies to all supported platforms.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s10_Linux_Unix.zip:
0DBE8BD62D053F56F312F7CBABDDD060547A642DD3DB62A58D10DD35BB8111BA
cdq20182s10_Windows.zip:
FEB226BF9F92FEC8516689631894C570A93150120E2A6F8A3D4CF0C94CDA1CA6

2018.2.0 S15 This software update resolves two issues and provides two security enhancements.
  • The security enhancements:
    • Direct Spectrum Technology Platform to encrypt all resource passwords and to either remove or mask passwords in log files.
    • Provide default support for external requests to the Spectrum Technology Platform server via proxy.
  • We have resolved an issue that caused scheduled jobs running according to control file triggers to end with errors.
  • We have added Japanese language support to Management Console.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182S15_Linux_Unix.zip:
9D7461DBFBAA08DFABE749505B12258F4DA4CE763F5BBFBB3CD2AFBF1030FCFF
cdq20182S15_Windows.zip:
C6CC36E45A46C543B80D9E3E894973C608D4E5BD1FF5FDC80E8DEA121EF5C7C0

2018.2.0 S19 This product update resolves two customer-reported issues and provides a new Command Line Interface (CLI) command.
  • Exported JSON file does not list multiple admin roles.
  • Management Console is unresponsive when multiple secured entities exist.
  • Added a new CLI command to export audit log events.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s19_Linux_Unix.zip:
6612BCE4B22EA490F5B3902955329C3DEC55E7C133AB2490DF5E4E18D61807EC
cdq20182s19_Windows.zip:
BF46104F3F7C8ED2D6D997F9CAA5B0C9CDA8C3CB4064F8584DA2787CE6B70C11

2018.2.0 S20 This product update provides two customer-requested enhancements:
  • Change persistence layer to always check indexes and recreate indexes if not found.
  • Improve the process that Spectrum follows to shut down Neo4j.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s20_Linux_Unix.zip:
50922686A8C6A80D54B3F15C92A08A506FA35F9A2EE888C706F4AF2EEA8D7767
cdq20182s20_Windows.zip:
8A4B1FC35BE03F63AC4943E0D73521BF7FE0143565D8E84FFC798F259D748133

2018.2.0 S25 This product update resolves an issue that occurred when backing up the Spectrum repository. This product update also provides a utility to perform index consistency checks and a store copy utility.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s25_Linux_Unix.zip:
99E4F0D0A58EA3999F894FA6ACF2A52CEC633BE195770ED56A1127E4051F499D
cdq20182s25_Windows.zip:
49DEAD94ACD3D55A686271711AC4C4145AD750161570DD6E5FBD940929D70877

2018.2.0 S28 This product update includes the following:
  • Resolution of a DistributedObjectDestroyed exception occurring in a microflow
  • Improved performance of service dataflows that use the Group Statistics stage
  • A utility that generates encryption strings
  • Requested security enhancements
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s28_Linux_Unix.zip:
BD5948D63FAB7C1AF72583E03B8F820FA831849D24278FA48A6615E29A43E48C
cdq20182s28_Windows.zip:
DDDEC1BC6D515A895E3B629BA21F9AF7BC1B6B3E78A01AB3A98B8FDBE919DF4F

2018.2.0 S33 This product update includes the following fixes:
  • A job located under the Job folder moves to the root folder unexpectedly.
  • The jobexecutor -w option does not work as expected when running multiple (10 or more) concurrent jobs.
  • The account ID needs to be exposed in the Transformer stage.
  • Settings for string conversion format defaults were lost after restarting the server.
  • Previously exposed multi-level Spectrum parent services do not return updated results when a child subflow is updated and exposed.
  • Previously exposed Spectrum parent services do not return updated results when a child subflow is updated and exposed.
  • Spectrum is returning a java.lang.NullPointerException: null INFO | jvm 1 | datetime| at com.pb.spectrum.platform.server.common. audit.core.aspect.AuditAspect.evaluateExpression
  • Processing returned a null pointer exception during a scheduled purge task. The Spectrum 2018.2 remote server is not connecting.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s33_Linux_Unix.zip:
6871B5612B8B160FBF90CFB9459D6D9E32B078EB96BD21C71568140B7D3D2400
cdq20182s33_Windows.zip:
28F6FC2FD7EAEBBBB857E149381A0D1440B9EDF38BD96510FEEFE85856579EE0

2018.2.0 S43 This product update includes the following fixes:
  • Fixed incorrect next run date in scheduled flow.
  • Fixed issue that job for checking the certificate expiration does not use the encrypted password.
  • Fixed issue that Spectrum performance degraded over time.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s43_Linux_Unix.zip:
B75F02117F82A1D48234C706D59DEC294E8D3A6A9F6B69DF024FCE3A91CB6355
cdq20182s43_Windows.zip:
20A6B1E93F4988A93EE00110D63F654CF9E457344651767B6D9EFFA3EA98576F

2018.2.0 S44

User can create a service in Spectrum Enterprise Designer which has a Lookup Key field for searching the PBKEY in data.

  • This Looup Key field can now named as any valid string, which was earlier named as "lookupKey" only.
  • Now user can search the PBKEY in Spectrum Management Console with the same name as configured in service.
  • Message for PBKEY not available in data is now logged as info instead of error in the Spectrum wrapper log file.
  • The error messaging is improved for the Geoenrichment service.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s44_Linux_Unix.zip:
A016B6D398536CFD764D55B1B2F2F829A928BF6323B0CD05E375ADD1574FD37C
cdq20182s44_Windows.zip:
CB3DF7ECAFFFD4C5BAA66036F47B4981E3B1C2C3C2A4C3B1673F26FF8C8B2CD8

Advanced Matching Module

Update Description Download
2018.2.0 S06 This product update improves the system generated tags and provides a better user experience.
  • Update

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s06.zip:
A016B6D398536CFD764D55B1B2F2F829A928BF6323B0CD05E375ADD1574FD37C

2018.2.0 S30 This product update fixes the functioning of system security role in the Data Normalization Module and Advanced Matching Module.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s30_Linux_Unix.zip:
4B69A6FD7CBEF4C44C7A3A5509D21CADAAFD139EE2BAC75B0CE4FAEC44EA0783
cdq20182s30_Windows.zip:
158C7F4EA7C0DDE9C27ADCBB3C800DE67A940DFA0EE22FE51660526A8C3A8890

Data Hub Module

Update Description Download
2018.2.0 S13 This product update resolves an issue in which the Write to Hub initial load is failing for large model (Garbage Collection overhead memory issue). This is an optional product update.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s13_Linux_Unix.zip:
2EAFEBC391D3263CAF3182996F45758B67FA8E2AAF2B62A3CF50C0EE66CA0C81
cdq20182s13_Windows.zip:
EF8CAC9596E8FABB278D6ED0BAF3C5012133F38C448100C79B11CB056176A3F3

2018.2.0 S45

This patch updates the deprecated Geocoding service for Data Hub Visualization.​ The service is updated to use the Map Tile Layer on Precisely servers.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s45_Linux_Unix.zip:
06ECAA300AF88F9FF73DEA9E89D2202D8EB62DAB8C097180767C737F995C3039
cdq20182s45_Windows.zip:
6E385368C66EDBBD95BB0183C2CF9E34409C591AD07B5FC13B9FD4CECD944F99

2018.2.0 S48

This product update resolves the following issues:

  • Fixes TrasientTransactionFailureException error when running multiple query/write stages in parallel.
  • Fixes TrasientTransactionFailureException error when while performing a HUB model backup.
  • Fixes a ConstraintViolationException error.
  • Fixes various transaction termination errors in a cluster.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s48_Linux_Unix.zip:
8A2139285A7580EF06BF88D5461C08EAABD508C970BCD70075DC9D7A2E5D7539
cdq20182s48_Windows.zip:
1A4C72CA21692F4B9A6FC696F519F2B7D94FD0584B2D32DBB2F544083C706092

2018.2.0 S49

This product update fixes issues with locks in the Delete from Model stage, adds retry logic to Merge Entities and Split Entity stages, and fixes update issues in the Write to Model stage.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s49_Linux_Unix.zip:
CCBA073421B6596D9036B288B962F9FCF286C56B90FF838B7BB8A96D52185984
cdq20182s49_Windows.zip:
ED1FD14DEDEDBE0EE083A0E3025616F6702785E0583718C37BC3847466838996

Enterprise Geocoding Module

Update Description Download
2018.2.0 S23 This product update includes:

Canada (CAN) dataset: Added a new field CPC_RECORD_TYPE to return a two-character alphanumeric code to identify details on the type (for example, high-rise buildings, or a government street address) of the postal record it was matched against. This information is only returned when a match contains a full FSA (Forward Sortation Area)-LDU (Location Delivery Unit).

Czech Republic (CZE) dataset: Matching improvements include a more accurate and precise location returned because it will now match both house and plot numbers.

New custom fields: For 17 countries, new geographic and postal geocoding custom fields provide additional metadata including primary postcode, multiple area postcodes, and the number of postcodes for each town.
  • MULTIPLE_AREAS_FOR_POSTCODE: Postal centroid candidates return true if more than one town is contained within the postcode.
  • PRIMARY_AREA_FOR_POSTCODE: Postal centroid candidates return true if the current town is the primary town for this postcode.
  • POSTCODE_COUNT_IN_AREA: Geographic centroid candidates return the number of postcodes found in that town when available.

These features are available with the JULY 2019 datasets. For more detail, refer to the Geocoding International Data v2019.07 Release Notes.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s23_Linux_Unix.zip:
984B3059921C9662B551033B1E93FC48C9A3B1DD871922D8E02FFB12B10D44F6
cdq20182s23_Windows.zip:
65BFDF4B206D8B4DCEBEE1267D221A4C0063F5D63D18ED6F67E8A6956FA02A53

2018.2.0 S26 This EGM-USA product update includes:
  • Updated GeoStan libraries: The libraries have been updated to version 32.00. This includes improvements to alias address details and singleline matching enhancements
  • Address variations are easier to identify: In the Reverse pbKey stage, the standardized address elements remain identical, but the parsed, alias address information (the variations) are returned as additional output fields.
  • Added the User Dictionary Writer: Enables you to map fields from your source data to required and optional Spectrum fields, creating a custom dictionary. For example, a local government might create a custom dictionary based on parcel maps for an emergency response or tax assessment application. Note: User Dictionaries are not for use with CASS geocoding.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s26_Linux_Unix.zip:
1B386D680C139BFB5809AA6C880FDB2BFA3CD5B634815B98B24578C0631BE2D7
cdq20182s26_Windows.zip:
00B818F1CABBD50171873051192C3ADF549AA08B4373186D2A30D0AD6AFE0EC9

2018.2.0 S31

This optional EGM-USA update provides access to MLD Extended Attributes such as Assessor's Parcel Number (APN), Elevation, Address Type, and many more output fields.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s31_Linux_Unix.zip:
213F550D5A0F0108E54F2A11A61A29BF194408AE5F621E311999794275176D79
cdq20182s31_Windows.zip:
176D222DC994B79BAF2A24010B5BFDCD58BE72CC207518D2661D03927FEFB627

2018.2.0 S50

This product update provides access to new fields in Master Location Data (MLD) Extended Attributes.

  • Linux

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s50_Linux.zip:
3E52CCFFBE85E9A8AF2A20800A7CD2E4680373FB813C70C8CC9981B173982B57
cdq20182s50_Windows.zip:
BF131193BFBB109EAAA936D7DE2C7DD0518D5CB0771BC444A850E35E7BE87A27

Enterprise Routing Module

Update Description Download
2018.2.0 S07 This mandatory product update applies to all platforms and fixes an issue where in the Settings tab of the GetRoute stage when the user clicked OK and then reopened the Settings tab, the OptimizeBy setting would change from Time to Distance.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s07_Linux_Unix.zip:
EA9BEED9BAD832B91D8357BC3B2318145A20025D50D50403B8A70E43CAB91A8E
cdq20182s07_Windows.zip:
4991C4278725CE5A461867B28E4225D5592B10D95774CEFA181CFE319AFD4FC6

2018.2.0 S21 This product update is for both the Enterprise Routing Module (ERM) and Location Intelligence Module (LIM). It fixes:
  • Some routing web services were reading and writing numeric data in the wrong format because comma decimal points (“,”) used in some countries were not handled in a locale-independent way.

  • For the Travel Boundary stage, when adding a new parameter with String (or list type of string) in the input stage, the same was not listed in Values Field Name in the stage. When modifying the default TravelCost parameter on the Input tab from Double to String (or list type of string) in the input stage, the parameter was listed in the Travel Boundary stage but was not working as expected.

  • An error was occurring while applying persistent updates. It was corrupting the update file which in turn would throw an error at the time of server start.

  • The persistent update request for non-English locales was throwing an error before the completion of the operation.

  • In Enterprise Designer, placing a Spectrum platform stage after a Travel Boundary stage would hide the Cost and CostUnit fields from the output. These fields were in the inspection window but unavailable to downstream stages.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s21_Linux_Unix.zip:
854D2F85AB7B7C70A0A714565BEEACB75987D2173F5C125E2686A32B74434655
cdq20182s21_Windows.zip:
D118CBC37032C83AD72B4DFBE0449373A06353D2FA1EFAFAFF2AAE04625CB620

2018.2.0 S22 This product update is for both the Enterprise Routing Module (ERM) and Location Intelligence Module (LIM). It fixes:
  • Enterprise Routing Module stages were reading numeric data in text box fields in the wrong format because comma decimal points (“,”) used in some countries were not handled in a locale-independent way.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s22_Linux_Unix.zip:
1B692D6248C72EDA4401B257976EA35AC90851F16309D153A116ECFF1CF00E71
cdq20182s22_Windows.zip:
7F7B858C06A57B033CF02E5CFCFCF42597606CD51793BB6E891F495E5FE30B4B

GeoEnrichment Module

Update Description Download
2018.2.0 S36

This product update includes the following:

  • While replacing an old H2DB data with a new one or on creating a new Spectrum database using the latest H2DB data, the product expiration information was not getting updated, as the internal cache memory within the module is not getting refreshed.
  • This patch will resolve the issue by refreshing the cache and completely un-regisitering the previous database.
  • Linux/Unix

  • Windows

  • Release notes only

2018.2.0 S42 This product update includes the following:
  • While updating the H2DB data using the same Spectrum resource connection, a Spectrum restart was required to put the new data into effect.
  • With this patch, a Spectrum restart will not be necessary for Database Resource update.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s42_Linux_Unix.zip:
FEA22F8381C123B75804122A22D289423A74106F783347AFFB99B701B2C12715
cdq20182s42_Windows.zip:
57A755C27425A8D0FEDBECEED1E3840CE2AB69CDBF588759FD11C92D8FAEFEFB

Global Addressing Module

Update Description Download
2018.2.0 S04 This product update includes Global Addressing Module support for the Q3 2018 data refresh. You must apply the 2018.2 S04 product update to use the most current version of global data with the Global Addressing Module.
  • Update

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s04.zip:
E81F8F8CD99AF88099B3D7C2686B899375DF83A72B2A0357B5F2B3BEF5008308

2018.2.0 S18 This product update includes:
  • Global Addressing Module support for distribution of dynamic libraries
  • Support for the Global Addressing Module Q1 2019 Data Refresh
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s18_Linux_Unix.zip:
51D572C7B24864A07A145205B2D07AE75997C4FECDF56F7838AED59E7BBAD9C2
cdq20182s18_Windows.zip:
420E82C63787DF16663C3149005E622B49299D1F46EBAE6229741A5896B07F68

Global Geocoding Module

Update Description Download
2018.2.0 S14 This product update includes the following enhancements:
  • PBLocator REST API

    Additional fields exposed - The geocoding candidate output now includes PBKey and Census information where available.

    Note: The PBLocator feature in the Global Geocoding Module is a licensed feature. Please contact your sales representative to obtain a license.

  • MatchScore & Confidence (USA) returned for Forward Geocode Stage

    The EGM confidence values for USA addresses is now available in the Global Geocoding Module.

  • MatchScore – all countries: (Global Feature)

    This is a new custom field that represents a score (0-100) of how well the input compares to the candidate values for certain fields. It is used to better indicate what parts of input address were changed to make the match. Fields checked include street name, house number, directional, street type, unit number, place name, postal code, and area names 1, 3, and 4. A lower match score indicates many input fields were changed.

  • Confidence

    This indicates the confidence in the output provided, from 0 to 100. The higher the score, the higher the probability that the match is correct. If the match is exact, the confidence score is 100. For all other matches, the confidence score is calculated based on which portions of the input address had to be changed to obtain a match.

    If you have enabled the option to return centroids, the confidencevalue indicates the type of centroid returned:
    • 60 for a street centroid
    • 50 for a postal code centroid
    • 35 for a city centroid
    • 30 for a county centroid
    • 25 for a state centroid
  • Update

  • Release notes only

SHA-256 hashes (What's this?)

cdq2018020S14.zip:
B86CB746B232766E418B6AEC0D537A9059893793FBEE7FF8A3F906473BD4B972

2018.2.0 S24 This product update includes the following enhancements:
  • Canada (CAN) dataset: Added a new output field, CPC_RECORD_TYPE.
  • Czech Republic (CZE) dataset: Matching improvements include a more accurate and precise location returned because it will now match both house and plot numbers.
  • New custom fields: For 17 countries, new geographic and postal geocoding custom fields provide additional metadata including: MULTIPLE_AREAS_FOR_POSTCODE, PRIMARY_AREA_FOR_POSTCODE, and POSTCODE_COUNT_IN_AREA.
  • Updated GeoStan libraries: The libraries have been updated to version 32.00. This includes improvements to singleline matching enhancements.
  • HP-UX

  • Linux

  • Unix/AIX

  • Unix/Solaris

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s24_HPUX.zip:
1A5387E3235690B1F9C5B4C48D6E13AD0C5678178C187F68129028AA1260F0D5
cdq20182s24_Linux.zip:
31666FE437DD47903E76AA58CAEA2EAE1DA39827166671ACC508F1588F348441
cdq20182s24_Unix_AIX.zip:
33EC551A3E2E65932246508DB2A0CEC3F8D4AF01C6867435C3E4FA96E5F3BA47
cdq20182s24_Unix_Solaris.zip:
2F4FCEEC1307D4B0E30459E7840EDBDFFE8A3834E6B11E802501F7C3DCAAE3D5
cdq20182s24_Windows.zip:
203DF6325A61E4B3665E41CFDF2B4FE4AF80BE484A33DB2E16F0BB267FDF4CD3

Information Extraction Module

Update Description Download
2018.2S40 This product update fixes the security vulnerabilities in the Information Extraction Module (IEM).
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s40_Linux_Unix.zip:
BC5B0ADB9614F4C9D556981A9C88B046022546C0C8E8C3CEF2B5949CFED24C52
cdq20182s40_Windows.zip:
4AEF59824DAEE1E40D180D1935DE305E32EB4F65ABE62D3584DD62884171FCCE

Location Intelligence Module

Update Description Download
2018.2.0 S01 This product update addresses these issues:
  • From version 2018.2, custom image symbols created by the user can be placed in a folder called SpatialSymbols on the Spectrum server in a location referenced in the classpath.ext properties file. However, when accessing symbols from this location, Spectrum Spatial was pre-fixing the symbol name with the folder name (for example SpatialSymbols/MyCustomSymbol.png). When the Map Uploader creates layers, it references only the symbol names without a path. This behavior meant that custom symbols referenced in layers created by the Map Uploader were not getting matched to the one copied into Spectrum. This has now been fixed so that symbols added to the root of the SpatialSymbols folder will not have the path pre-fixed onto their name.
  • When setting enableAlpha as false in a grid style for an MRR image (which was using classified and image palette component type), the setting was getting ignored and a previously cached value was used. Now any updates made to the GridStyle are being reflected in map rendering and in Spatial Manager.
  • There was an entry in the app switcher called "Spectrum Single Sign-on Integration". This was not relevant for administrators, so it has been removed now.
  • The default settings for the Apache Jackrabbit Janitor was set to 24 seconds instead of 86400 seconds (24 hours). The janitor cleans up the repository journal in which cluster nodes write their changes. It is only relevant for customers who are using a common repository database (LIM cluster) and who have manually set janitorEnabled to true (since by default it is false). If you have enabled the janitor, then please review its settings after the patch is deployed.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

CDQ_201820_S01_Linux_Unix.zip:
8AE86C63E264296C198D6A1E2D330C0CBA8CCA20CDF437E706DB33F536F5DFE7
CDQ_201820_S01_Windows.zip:
48D99799FE4763B05DFCE8B76C93C08795E18A0BEDB48BBBCD78CC8818278E20

2018.2.0 S05 This software update includes the following updates:

Enhancement:

Support of query-param in the POST body along with bound parameters has been provided for the Feature service REST API. This improvement enhances the user experience where the user needed to pass a long SQL query in the query parameter (q) in the POST body, which would otherwise be too long to specify as part of a GET request.

Bugs Fixed:

  • The email and phone icons were missing in the Help menu in Spatial Manager. The missing icons have been restored now.
  • MapInfo Brush values that are used for filling polygons are documented as 1-8, 12-186 according to the MapBasic documentation. Values 9-11 are not supported. However, MapInfo Pro handles value 11 as solid fill whereas Spectrum Spatial did not. In addition, a long-standing black and white thematic template for individual value themes used value 11. This meant that any themes created with this template could not be rendered after uploading. The issue has been fixed as Value 11 is now supported.
  • After upgrade to the Spectrum 2018.2, the validationQuery= "SELECT 1" was returning an error when the query was enclosed with quotes. This property is located in the file pooling-datasource-factory.properties located under \server\modules\spatial. This has been fixed now.

Known Issue:

In the Find Nearest Stage, a maximum distance must be set when using a SQL Server-based named table that uses the SQL Server geography data type (i.e. the database table is in a projection such as EPSG 4326 with longitude and latitude co-ordinates).

  • Update

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s05.zip:
0D0FD14DE3FFC7A741BDF3AFAC2BCE6F1AB0E7C7DCC76A81A35609820C3DBA90

2018.2.0 S17 This product update resolves an issue in which Spatial Manager displays a "LIM license has expired" message after installing a perpetual license key.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s17_Linux_Unix.zip:
5A25A8EB4F558A29DEFD8CE416F41F0276861DC8AF87F56C50F4A162FB7FEF14
cdq20182s17_Windows.zip:
AEB9E4F2B7DA2E2CBA1F48C346C161DD26C4E5181D2ADB4DBBA19CBE633823EF

2018.2.0 S21 This product update is for both the Enterprise Routing Module (ERM) and Location Intelligence Module (LIM).

This update adds two new properties for controlling ACL related behavior and fixes:

  • Combining native and custom handlers for data source definitions was generating an error: “MissingDataProviderReader: Unable to find a data provider reader for this element.”

  • After applying the 2018.2 S05 patch the POST Feature Service request was returning a “Bad Request” error. The same service was returning the expected output in the GET request.

  • The Output field defined for some spatial calculator operations such as Within and Intersects was not part of the stage output.

  • A Describe Table request was not returning the correct EPSG code (such as EPSG 3301) for a native TAB file that uses a specific Estonian Coordinate System.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s21_Linux_Unix.zip:
854D2F85AB7B7C70A0A714565BEEACB75987D2173F5C125E2686A32B74434655
cdq20182s21_Windows.zip:
D118CBC37032C83AD72B4DFBE0449373A06353D2FA1EFAFAFF2AAE04625CB620

2018.2.0 S22 This product update is for both the Enterprise Routing Module (ERM) and Location Intelligence Module (LIM). It fixes:
  • In Internet Explorer 11, options on the Spatial Manager Settings tab were grayed out and unavailable. The Apply button, Restart button, and the Propagate checkbox are now enabled.

  • The geodetic coordinate system for Japan (JGD2000) was not accurately represented.

  • Using MI_GridValueAt and MI_GridValueAtPixel to query the value stored in a classified field generated an error. These Grid functions were returning the class name by doing an additional lookup in the classified table structure, and an error would result when the classified table structure did not have a “Class” field type. They now return the class index itself when the band stores class index. A second MI_GridValueAt and MI_GridValueAtPixel function can be used to specify the band containing the class label to get the class name.

  • When a MI_GridValueAt function was used to query a grid table and field=0 and band=0 was specified, the result was returning the data from the field and band present in the GHX file instead of field 0 and band 0.

  • The MappingService was re-initializing when the mapping configuration in the repository cache was refreshed. This could affect performance when loading many resources to the repository cache.

  • Spatial Manager was not reverting back to English or the default language selected in the Management Console when the browser was set to an unsupported language. It was showing internal variable names for the text. It now works as expected.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s22_Linux_Unix.zip:
1B692D6248C72EDA4401B257976EA35AC90851F16309D153A116ECFF1CF00E71
cdq20182s22_Windows.zip:
7F7B858C06A57B033CF02E5CFCFCF42597606CD51793BB6E891F495E5FE30B4B

2018.2.0 S27 This product update fixes:
  • Rendering BMP (Bitmap) raster data results in misplaced tiles (at raster edges). BMP raster images now tile correctly.

  • Performance using SHP files is slow due to a failure to create a spatial index.

  • Count aggregation query on Oracle native query table had poor performance with large tables. This performance issue has been resolved.

  • Spatial Manager does not have a volatile setting when creating tables with a Database query. It now has a Volatile flag that can be set to true or false, and the default value is set to true.

  • The feature count request made when viewing sample rows in Spatial Manager is slow for large tables. This performance issue has been resolved.

  • A "maximum open cursors exceeded" message displays when querying a database. This has been fixed so that queries do not leave a database cursor open (unclosed) when working with a database query table. This is a named table that contains a database-specific query rather than a reference to an existing database table or database view.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s27_Linux_Unix.zip:
05F7E4A5825DE681A853120D0021828452261F8C162FEC3DC89FD263AEAE887C
cdq20182s27_Windows.zip:
897D386C01E4CC2494CDCB648F72C7273E2BCBD6C5B26A88B1BBB0C70D36B5E3

Metadata Insights

Update Description Download
2018.2.0 S35 This product update fixes the NullPointerException thrown while reading data from a Data Federation Model Store using the external model store driver.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s35_Linux_Unix.zip:
8FCC6F192C60159B4713D3B738ACB72F9A4E20C1456836FB20222FEFB3A79399
cdq20182s35_Windows.zip:
917B7D95C6D16C736931B237711E65DA6896BA93065D6F755EC0F12D802DAEF4

Screener Module

Update Description Download
2018.2.0 S02 This product update fixes the issue where the List Ingestion Utility was not initializing on version 2018.2.
  • Update

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s02.zip:
C4C8B9705DE3B1E4539274B9E7C8B41326EE4842278459E20ADA0CEA1BD1398B

2018.2.0 S12 This product update enables interactive processing of batches of data.
  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182S12_Windows.zip:
D95FCDE64FA91FEF62C4AE58EFE12328FB5201075FB6CB46C59E85A492D7202B

SDK

Update Description Download
2018.2.0 SDKS01

This software update addresses the Spectrum 2018.2 Java client jar integration issues.

  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182_sdk_s01_Linux_Unix.zip:
6C83EB70475F59508C567BA422A7902A5E1BA3071976E2BDB511061729DD1C79
cdq20182_sdk_s01_Windows.zip:
754D7F73FF1D6D2665550A5F4BE8DDAA5C3245BB971C3624DA2EE0419AF869CA

Spatial Analyst Application

Update Description Download
2018.2.0 S01 Spectrum Spatial Analyst is a standalone application that installs and updates separately from the Spectrum Technology Platform.

This product update:

  • Lets you specify a friendly name for map layers so that after saving a map project users see the customized layer names.
  • Lets administrators add various routing options by manually editing the routing config XML.

See the Release Notes for a complete list of fixes.

  • Update

  • Release notes only

SHA-256 hashes (What's this?)

SSA20182S01.zip:
11F6272DF40FEEBBEC3C98D4D8251A1010A9D06C8B73FA7F9E877674FE88FEAD

2018.2.0 S02 Spectrum Spatial Analyst is a standalone application that installs and updates separately from the Spectrum Technology Platform.

This product update gives Extensibility Developers a new Spectrum Spatial Analyst API action called RemoveLegendByNameAction to delete a legend entry for a layer that was dynamically added using the Spectrum Spatial Analyst extensibility.

This product update fixes:
  • Thematic and Query options are visible when unavailable.
  • Legends created using Spectrum Spatial Analyst extensibility cannot be deleted.
  • Template Designer shows duplicate table entries when creating a custom template.
  • Administrators can now manually update the ˂˂print_template.xml˃˃ file to control the callout and FMN results from showing up in the printed PDF documents. This can be done by setting the following flags to false:
    • ˂show-callout-info˃false˂show-callout-info˃
    • ˂show-fmn-results˃false˂show-fmn-results˃

    Note: If you save this print template from Admin Console, these changes will be overwritten.

  • Update

  • Release notes only

SHA-256 hashes (What's this?)

SSA20182S02.zip:
03777FB2A1BE89DEF7A5EE0D9E0D6FC306345C0A1B5E28A01E0C16FFF4927340

2018.2.0 S03 Spectrum Spatial Analyst is a standalone application that installs and updates separately from the Spectrum Technology Platform.

This product update fixes:

  • When creating components for Spectrum Spatial Analyst using extensibility it is now possible to reference and load external JavaScript libraries in cases where Analyst is accessed securely. Previously these would only work if accessing Analyst as a guest user.

  • The performance of the project settings dialog has been improved. Previously for very large projects comprising 100 to 300 layers the project settings would take time to populate and be sluggish to use. This has been fixed and now the page loads quickly and is responsive.

  • We have added the version number of Spectrum Spatial Analyst into the help side panel on the SSA home page. Admins can use this to determine the exact patched version of Spectrum Spatial Analyst.

    Note: The main Spectrum version is still available from the Spectrum landing page under System Information.

  • When creating components for Spectrum Spatial Analyst using extensibility it is now possible to set the visibility of annotations added in extensibility code to be initially hidden.

  • You can now add custom fonts to the customer configurations directory and reference them when creating components for SSA using extensibility. The supported font extensions are .ttf, .woff, and .woff2.

  • When setting the units in a Spectrum Spatial Analyst project between imperial (miles) and metric (meters/kilometres) on the project settings page, the settings did not always apply in all places where measurement units are shown. Previously for example Spectrum Spatial Analyst would show yards as the default unit if imperial was set. Measurements are now shown by default in either miles or feet (if under 1 mile) or kilometres and meters (if under 1 kilometre). Users can still change between all of the supported units.

  • When creating components for Spectrum Spatial Analyst using extensibility it is now possible to get table and layer level information at both group and individual record level for map information. This is available as part of the context data in the call out container. This information can be used for customizing existing map information behaviour.

  • Update

  • Release notes only

SHA-256 hashes (What's this?)

SSA20182S03.zip:
5D7F34B7AD3B021889267238483CA9262D7826C2E11024CCD47989238AFC35E9

2018.2.0 S04 Spectrum Spatial Analyst is a standalone application that installs and updates separately from the Spectrum Technology Platform.

This product update fixes:

  • Previously, an admin query was only visible to the user if it had been configured on the first layer of the named map.

  • Previously, users were unable to set the center of map when using the URL XY parameters for EPSG 27700.

  • In the Address Search box, clicking on "Enter coordinates" now defaults to “Longitude-Latitude” coordinates if the map projection is either EPSG:3857 or EPSG:4326 and to “X-Y” for any other map projection. Previously, it always defaulted to “Longitude-Latitude” for any map projection.

  • For map projects migrated from version 12.2, Map Information was shown as "enabled" in Project Settings whereas it had previously been "disabled".

  • Previously, a named map was always shown unchecked on the legend and its visibility is also turned off when user saved a map project that was migrated from the 12.2 SSA release.

  • Previously, when using map information in an annotation, incorrect results were returned.

    This was happening because in SSA we were converting the geometry to EPSG:4326 before sending it to Spectrum. This conversion resulted in a minor offset of the annotation in the case of EPSG:27700 and EPSG:29902 relative to the layer being searched.

  • Previously, the global copyright statement was not displayed for Spectrum Spatial Tiles when used as a base map.

  • Previously, admin created queries assigned in a project against a named layer did not show up in Spectrum Spatial Analyst.

  • Previously, the ViaEuropa tile layer was not being displayed beyond zoom levels 16 and was showing a watermark. This has been fixed now.

  • Update

  • Release notes only

SHA-256 hashes (What's this?)

SSA20182S04.zip:
C120B1B7CFC035BCA2DFF56DEFA0C5D7443BB7CEDB8D868096599BE465A02705

2018.2.0 S05 Spectrum Spatial Analyst is a standalone application that installs and updates separately from the Spectrum Technology Platform.

This product updates:

  • Exporting data in CSV format with semicolon (";") as a field separator, and comma (",") as a decimal separator in French OS.
  • A Spectrum Spatial Analyst user can now configure a multi-select feature count to customize a number of features selected on the map using multi-select functionality.
  • The Spectrum Spatial Analyst API now includes parameter validation to ensure that it cannot be used to read files outside of the configuration directory. The file name validation ensures that only alphanumeric, dash ("-") and underscore ("_") characters are allowed in filenames for search nearest and print template-icon names.
  • The line feature now highlights on the map using the multi-select tool when fill-opacity is set to "0" for the multi-select class in the corresponding brand.css.
  • Update

  • Release notes only

SHA-256 hashes (What's this?)

SSA20182S05.zip:
9CE3F95DD36CE11D33B199C03C3A359397DB6CD6C8BA2A59A191534FBBFC41E9

2018.2.0 S06 Spectrum Spatial Analyst is a standalone application that installs and updates separately from the Spectrum Technology Platform.

This product updates:

  • The HTTP session ID for a guest user, which was reused when they logged into Spectrum Spatial Analyst after browsing to the application as a guest. Now, the existing HTTP session is destroyed when the user is successfully authenticated, and a new session ID is created. This fixes a potential security vulnerability.
  • The Spectrum Spatial Analyst usage logs. The user's IP address will now use the IP address present in the "X-Forwarded-For" header if that header is included in requests. This is useful in cases where a proxy server sits between the user and Spectrum Spatial Analyst, for example, in a DMZ.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

SSA20182S06_Linux.zip:
C61D6C7D4BA7948BFE4EC3E4346CEC16C1BE3855C55BA2E11F28BD27D5F9FC4A
SSA20182S06_Windows.zip:
FC4AA08A7BD5688FCF8FDFEE1B27CFD6F272FB1F60B73C7B92A52050731735CA

Universal Addressing Module

Update Description Download
2018.2.0 S08 This product update fixes an issue where users were unable to configure UAM International database on Spectrum Technology Platform 2018.2 windows server.
  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s08_Windows.zip:
55F73EBC5157367B83FE9DEA1FF88FE33DEB662D1A8F0DB14EEA2073ADBD8562

2018.2.0 S09 This product update fixes the issue where the Validate Address stage of UAM module throws a pb.service.options.optionNotFound error in Management Console while saving any changes after upgrading from 11.1 S39 to 2018.2 version.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s09_Linux_Unix.zip:
FB93C7122705D8F560B1AE42A261621E33E4C4EAE6E6BA92B00DF741D2A1B6C5
cdq20182s09_Windows.zip:
2091362FE83705CEAF1159B291B927B57D99C3D097BB4FD6914B4EDA906A3D94

2018.2.0 S16 This product update adds a tr​ansaction tracker for Universal Addressing Module Loqate, which lets you record the number of valid records processed.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s16_Linux_Unix.zip:
F6FD815C20BEC89A55EFCBA4A9F804254CF833E2EA125EE6A2540A72E8B6D942
cdq20182s16_Windows.zip:
82217CD8CE9B76CF8DD481830A4832BE19BEAC52BC6F41EFEC8B32E7C3925D3E

2018.2.0 S34 This product update resolves an issue where the Spectrum 2018.2 Command Line Interface (CLI) did not function properly when attempting to set up the UAM INTL France dataset.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s34_Linux_Unix.zip:
2BF3BBEFA834D89A68D7313205AEC45E90F79F5DD5B2EE41DEE2B95CAC84FB52
cdq20182s34_Windows.zip:
F0E10984CF1E094F8072DD7B53A10B6AD241D84C228E4DA6A82FE10A241C7711

2018.2.0 S38 This product update upgrades the UAM Canadian engine library version to 3.4.0.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s38_Linux_Unix.zip:
                  DF1FD3943707D6A730AF1DA9E3866781ED5200DBE6121C719E724F0F7CAB9825
                  cdq20182s38_Windows.zip:
                  17873DE471528168924525283F514AFB26033E6C0EDEAC6099550F6358FB2A4D

2018.2.0 S46 This patch release upgrades the ICP engine to ICP187F01 and resolves the following issues:
  • Good addresses failing validation due to incomplete reference data.
  • Validate Mailing Address Premium multi-match returned where V4 is achievable (France).

  • Linux

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s46_Linux.zip:
3F74757EB9449AAA8A6F66A11E0DC1A13593327A81F66DC24748D0DEEE419AE8
cdq20182s46_Windows.zip:
9EDBC43626E565A429FE072C0379C4ED7F0E69F27C842862E9E79BACCFFEBDEF

2018.2.0 S51 This product update extends the CASS Cycle N license till August 1, 2023.
  • Linux/Unix

  • Windows

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s51_Linux_Unix.zip:
9F55058A912A08332C0DECF32E587BE53A43D5609BFB3DD5CFB13B24517DCDFF
cdq20182s51_Windows.zip:
104D065F1A47B79FBE59F73985BA58211DCFA0C1E61EFEEDA59B0C056D718B94
              

Visual Insights Module

Update Description Download
2018.2.0 S03 This product update releases SVI installer with enhanced security.
  • Update

  • Release notes only

SHA-256 hashes (What's this?)

cdq20182s03.zip:
1DC6AC6E9CB52FE7955BD8A8961E37AFC33268721C78DFC5912607F2E68EAA8D