***************************************************************** Emerald change history for versions 5.x (All Platforms) ***************************************************************** Modified: 2/22/2024 Copyright (c) 1996-2024 IEA Software, Inc. All rights reserved worldwide. This file contains important, late-breaking information about changes made within Emerald. We recommend that you read this file and keep a printed copy with your Emerald documentation. Tip: If necessary, choose Word Wrap from the Notepad Edit menu or Wrap To Window from the WordPad View/Options menu to wrap the text within the document window. ---------------------------------------------- CHANGES.TXT CONTENTS ---------------------------------------------- . KNOWN PROBLEMS . RELEASE CHANGES ---------------------------------------------- KNOWN PROBLEMS ---------------------------------------------- * None at this time ---------------------------------------------- RELEASE CHANGES ---------------------------------------------- Emerald 5.0.99 - 2/22/2024 -- * Added start window of scheduled tasks with run interval based on start date changed from 60 seconds to scale automatically with interval * Added current license limit parameter licmbrs when running notice queries * Added license keys should also be refreshed when updating GBE configuration * Added readquery and readcachequery emerweb functions to run queries which do not change any data * Added query emerweb function support for columns of type variant, datetimeoffset and native conversions for signed/unsigned 1 and 2 byte integer types * Added scheduler reduced contention queuing task completion reports while no writable databases are accessible * Added binary fields referenced within update emerweb function support eval variable qualifiers * Added entropy of operator session cookies increased from 69 to 83 bits * Added scheduler should log warning rather than block if task cannot be executed due to concurrent task limit * Added filter ews file missing errors associated with unauthenticated sessions from database audit log * Added reduced overhead associated with IP and object access checking * Added minimize write lock hold times while refreshing object group permissions * Added static column binding support for varchar max datatypes and double maximum field length to 64k * Added scheduled tasks with intervals that are integer multiples of a day /w interval based on starting date now run on starting dates time of day regardless of relative dst status * Added RADIUS update moved to standard maintenance set and ordered prior to custom_ms.sql * Added systemd services supported on Linux platform in addition to init * Added dbpool improve management of associative column binding * Added netElastic VSA dictionary update * Added redundant connection pooling features provided by the ODBC driver manager should be disabled * Added improved crypto and filesystem related error messages throughout the system * Added npcat emerweb function modified to automatically append new data to existing value if present * Added copy on write support for concat and npcat emerweb functions * Added remove next parameter and assign row parameter with variable processing to customize row delimiters of table emerweb function * Added while not recommended multiple comma separated email addresses may now be entered into a single email field * Added date datatype treated as timestamp rather than string in emerweb update function for purpose of change detection * Added reduced hold time of write locks while refreshing sections and security configuration * Added payment filter should be changed to also prevent creation of no cost payments * Added date datatype support when processing rating datasources from billing engine * Added web server thread startup can now be canceled much earlier if one or more workers have failed due to resource exhaustion * Added fetch failure obtaining scoped identity should also attempt session fallback * Added cert management and RSA OAEP changes for compatibility with major revision of TLS support libraries * Added web server apply security level 2 when TLS below 1.2 is disabled * Added improved disambiguation of emerweb function and variable labels * Added actionid parameter support for check and filter emerweb functions * Added avoid redundant application DRI checking on dependencies that don't enforce billing group access restrictions * Added avoid unnecessary group lookups by including missing group hints in emerweb update function calls throughout the client * Added avoid unnecessary processing in change and default emerweb functions * Added upgraded TDS and TLS support libraries used to provide Linux database access and HTTPS access to Emerald UI and export system * Added standardize root folder for all unpackaged non-web template processing and allow subfolder access * Added restrict display of path information when reporting ews file access errors to operators who are global admins * Added limit emerweb update function database record binding to parameter fields, metadata and nonbinary datatypes * Added emerweb update function should include field descriptions in all metarule validation failure messages * Added improved logging of all emerweb database related failures * Added default error handlers to if and exec emerweb functions * Added start log spooler earlier to consolidate logging systems and limit messages to windows app event log to severity of error or higher during startup * Added query emerweb function option to bypass error handler and audit logging to support running queries normally expected to fail * Added limit local session maintenance to at most once per minute on busy systems * Added time restricted operators should not be automatically logged off when accessing Emerald outside of allowed hours, manual logoff option offered instead * Added default emerweb error handlers should provide textual response when processing templates in non-web context * Added viewing reports that cannot be displayed due to rendering failure should provide a failure cause to the operator * Added reduce query caching lock contention * Added info emerweb function to query hardware and software environment * Added update emerweb function support for bigint datatypes * Added win32 style atomic operations on Linux platform for operator session management * Added recover from rare signal loss by time limiting infinite condition waits on Linux platform * Added status server displays active sessions having pending async shutdown with a red background color * Fixed scheduled tasks with multiple concurrently running instances should keep local state to reliably log completion status * Fixed error messages for queries which run successfully yet later fail while retrieving result set are not properly displayed * Fixed resource exhaustion while processing multipart requests should result in request failure * Fixed scheduler enabling task debug logging should not call non-reentrant time functions * Fixed branch emerweb function should enforce nesting limits to prevent possible stack exhaustion * Fixed resource exhaustion while adding records to scheduler run list may cause memory leak * Fixed scheduler task configuration and status changes should be properly synchronized * Fixed Linux installer method of detecting systemd should be improved to better detect systems with systemd specific structures yet don't use systemd * Fixed change and default emerweb functions should fail when applied to cached queries referenced by floop instead of copy on write * Fixed resource exhaustion while checking for authorization changes within session manager may cause a memory leak * Fixed scripts run from sql folder should consume any additional results before executing next statement batch * Fixed unused cobalt platform checks should be removed from license manager on Linux platform * Fixed update emerweb function's number normalizer improved to reduce chance of falsely detecting change * Fixed additional constraints on string to floating point conversions should be applied throughout the system to avoid improperly formatted data from being interpreted in unintended ways * Fixed redundant timestamp conversions should be removed from table emerweb function * Fixed additional results if present should be consumed while executing queries from query emerweb function * Fixed crystal print program unable to read configuration with multiple read/write databases and improved error reporting of failures related to extracting ODBC settings and file I/O * Fixed windows installer does not automatically create tmp folder required for external report processing using crystal print program * Fixed default error handler for menu emerweb function was missing * Fixed report failure messages are displayed without normal styling when printing reports * Fixed incorrect UI range validation and misleading custom ID range requirements when managing custom languages and translations * Fixed type failure error messages processing usage charges should report rate bill type rather than dbm type * Fixed filter emerweb function does not check for variable parser failure * Fixed emerweb load library failure message missing library name information * Fixed remove all connection dependent dbpool query functions to prevent failures associated with using queries having not yet reserved a connection * Fixed early failure within update emerweb function due to resource exhaustion may not call specified error handler * Fixed adding fields to query tables with no rows should also include null fields for existing columns * Fixed failure to init read-write db connection group could be concealed by successful init of read only group * Fixed updating records using prefixed parameters from Variables query table should disallow GroupID field and prefer local parameters over imported values * Fixed emerweb update function parameter value 'null' for non-quoted datatypes fails to match null database values while filtering out unchanged columns * Fixed 'null' value in datetime parameter of emerweb update function causes conversion error instead of applying null value to database * Fixed emerweb update function fetch failures while retrieving database version of a record not explicitly handled * Fixed handle leak initializing secure random source if integrated random cannot be generated during startup * Fixed non-web template processor assumes OID:1 when running custom ews requiring a valid operator reference * Fixed operator session management should rely only on local clock instead of database time * Fixed query cache maintenance using wrong criteria to determine whether it's safe to remove cached data * Fixed missing default error handler for driftcheck emerweb function * Fixed resource exhaustion while duplicating a cached query for modification can cause AV * Fixed detection of empty string values fail when some non-Latin alphabets are used exclusively * Fixed csvinput emerweb function fails with column count mismatch error when last column position of a row is empty * Fixed theme matching by client IP uses peer address instead of requesting client address behind a forward proxy * Fixed nosniff header should also be sent for insecure requests * Fixed web server workers fail to enter nonblocking operation on Linux platform Emerald 5.0.98 - 12/6/2022 -- * Added root TLS certificates from DigiCert * Added automatic standby for redundant session manager services * Added emerweb variable qualifier $= implemented in query context * Added upgraded TLS support libraries used to provide HTTPS access to Emerald UI and export system * Added disallow duplicate http request header replacement * Added npcat and npchange emerweb functions variants of concat and change with variable processing disabled to simplify dynamic evaluation * Added avoid replacing invalid object database errors with user friendly messages * Added operator authentication debug logging improvements * Added retrieval of auto number sequence should use scoped identity where possible for interoperability with custom triggers * Added unique thread identifiers should be included in log file output * Added web server should be the passive closer where possible and minimize middlebox allocated port exhaustion * Added web server workers switched to nonblocking operation improving response to management signals * Added access_override parameter to 'update' and 'delete' emerweb functions replacing default access type checking * Added default exception handler for cardtype emerweb function * Added 'once' emerweb function simplified to always use a single associative lookup * Added 'default' emerweb function should ignore empty values resulting from unmatched table variables for improved compatibility with update emerweb function * Added web server should periodically enforce reasonable non backlog receive side limits * Added emerweb function parameter parser lookup table changed to allow values to begin with any symbol except space and equal * Fixed last day of month should be preserved when adding months for purpose of calculating period ending date * Fixed period aligned billing cycle inaccuracies including not accounting for prorate of leading service or suppressing 'prorate of less than adds following months' * Fixed requests should be aborted if 'user' query table cannot be generated * Fixed update emerweb function variable exist filter fails if static values are present after variable name or query table contains no rows * Fixed timefilter emerweb function missing default error message * Fixed denied_item variable should only be set from emerweb check function when the default error handler is called * Fixed emerweb query table changes should be rolled back if field values cannot be set or changed due to resource exhaustion * Fixed dissimilar emerweb table variable names having matching prefix and checksums should not be matched * Fixed missing check for emerquery bind failures caused by resource exhaustion * Fixed self-signed certs created via TLS wizard should have matching SAN attribute * Fixed emerweb variable qualifier $' should evaluate to null instead of empty when a non-numeric value is provided in query context * Fixed workaround error 'failed to obtain identity sequence' when adding new records using prepared statements * Fixed TLS and network messages related to canceled web sessions should not be logged * Fixed check for presence of payment number earlier while creating payments from etrans to prevent later assertion failure * Fixed AV when password complexity requirements are set to an unsupported value * Fixed restrict audit logging attempts while in read only mode with no available read/write databases * Fixed time emerweb function should fail rather than falling back to current time if 'today' parameter can't be parsed * Fixed payment GBE function should use null card prefix for card type matching if account number parameter is masked * Fixed web server enforcement of backlogged connection limits does not properly account for wrapped timestamps * Fixed etrans mutex leak during GBE controlled shutdown Emerald 5.0.97 - 12/1/2021 -- * Added increase maximum allowed http request size from 20MB to 130MB * Added operator accounts can now be configured to login via windows domain authentication on the windows platform without hosting Emerald under IIS * Added when log files are not specified or do not include pathname the default log folder and or default filename should be assumed * Added http client should avoid including port number in host header when default ports are used to improve interoperability * Added simplify web server request scaling and enforce global concurrent buffer pool limits on medium sized or larger requests * Added web server status improved to highlight VIP sessions and display count of idle workers * Added bypass query string processing when serving static content * Added web server backlog mode improved to consider authentication status, data rate and increase signaling performance * Added cutoff blind UNIX time detection for $! formatting to Jan 1 1990 or later and remove Y2038 limit * Added non-delimited four digit MMYY format for date entry * Added automatic century selection for 2-digit year based on nearest century relative to present year * Added GBE log location can now be customized via Emerald configuration server * Added colorcolumn parameter to graph emerweb function customizing flat mode line colors * Added emernet redesigned with new flow processing pipeline and removal of promiscuous mode collection * Added filename parameter to emerweb function exec.emailreport * Added notice batches that render reports should render only the first instance of a report when run in preview mode to avoid delay * Added include peer address in web server TLS read failure messages * Added include peer address in web server TLS handshake failure messages * Added normalize database connection group selection within scheduler, emerweb, GBE and emernet * Added themes upgraded to use ipsets for IP address range related scoring * Added IP access security upgraded to use ipsets to determine whether clients are allowed access * Added emerweb functions encrypt, decrypt and certgen for key management and asymmetric data encryption * Added setting to determine whether new v5 databases and v5 upgrades are to be created within a single transaction * Added join emerweb function should join all available non matching source columns to output table when 'columns' parameter is omitted * Added columns emerweb function to loop thru all columns of current row of input table * Added remove 24xxx class errors from dbpool level reconnect whitelist to work around state tracking failures caused by driver managed reconnection * Fixed requirements assertion committing XML element attributes * Fixed encryption fails for fields with no predefined length limit in Emerald metadata * Fixed ping emerweb function should not modify the request table when it contains no hosts to ping * Fixed decode emerweb function should fail if there is insufficient resources to complete field replacement * Fixed ODBC datasources managed from Emerald configuration server should not set default ANSI or Quoted identifier connection parameters on Windows platform allowing the native ODBC control panel to apply driver defaults * Fixed attribute values may not be displayed properly when showing RADIUS authentication test results for attributes within 3GPP vendor space * Fixed html variable context should be used when processing the request parameter of httpget emerweb function * Fixed use common lookup table to detect values when processing ews templates * Fixed memory leak if insufficient resources exist to decode non-ews http requests * Fixed sort emerweb function returns failure message when sorting a table containing no rows * Fixed request parameter debug logging should avoid recording fields containing operator passwords and cookies * Fixed single byte overflow possible while coalescing related sessions * Fixed some query execution failure messages when creating new database or major upgrade are not properly displayed * Fixed audit log entry missing for failed operator authentications when credentials are passed outside of login form * Fixed web server GET requests containing message bodies may not be considered completed request * Fixed log location registry configurations should be removed from windows installer to prevent overwrite of customized operator log locations * Fixed PRNG should be seeded in stage 8 after configuration is loaded rather than stage 4 during staged startup and correct minor asymmetries in sequencing of startup and shutdown staging * Fixed web server logging to emerweb.log should use same variable substitution as emerweb module * Fixed externally opened queries may be closed locally when processing export results if validation of import configuration fails * Fixed export transaction auto void should be limited to query failure during a controlled shutdown * Fixed export query should be included in failure message if export query fails Emerald 5.0.96 - 3/29/2021 -- * Added upgraded TLS support libraries used to provide HTTPS access to Emerald UI and export system * Added multiple read/write datasources for Emerald managed primary database failover * Added integrate test results into query objects response message whenever a pool claim fails due to group wide unavailability * Added replace active datasource testing from emerweb spooler with consolidated active/passive datasource monitoring within dbpool * Added adjust allocation timeouts for access to connection pool minimizing worst case delay and prioritize global changes * Added report progress of stage 21 database version sync during Emerald startup * Added root TLS certificates from DigiCert, Thawte and ISRG * Fixed connection group bound check off by one when initializing pooled connections and query objects * Fixed datasource name and connection parameters should be trimmed and values containing semicolons filtered when initializing pooled connections * Fixed remove unnecessary pool scans and suppress retry on group wide unavailability when allocating pooled connections * Fixed handling of days starting at 01:00 due to Europe DST rule is triggered unnecessarily when retrieving date only fields via dbpool * Fixed connection pool should be sized to offer maximum connection limit to each datasource rather than sharing limit across all datasources * Fixed emerweb assignincident function should participate in the sessions global transaction if one has been started * Fixed emerweb group function should use exception free initialization and not fail if there is no row data in source table * Fixed emerquery API does not decrement rowcount when deleting rows from a query table * Fixed default emerweb select function error handler should close selection list prior to displaying error message Emerald 5.0.95 - 12/20/2020 -- * Added reduce time required for controlled shutdown of session manager * Added improve reliability and minimize resource usage when insufficient resources available * Added reduce failover delay switching to secondary databases on startup when all primary databases unavailable * Added emerquery deduplicate new columns and replace assertions with call sequence checking * Added replace group emerweb function to improve reliability * Added exec emerweb function should use standard status reporting and exception handling function * Added query emerweb function support for result sets with date datatype * Added buffer scaling prediction improved for variable processing, ews report rendering and scheduler run ews tasks * Added radclient should only apply internally defined attributes if external source of attributes unavailable or unrequested * Added write protect ewp package data loaded into memory * Added SMTP client support for SMTPS (port 465 only) * Added BCC field to email emerweb function * Added config CLI parameter to emerwebsrv in order to bypass any existing restrictions on configuration server access * Added improve network related error messages logged by web server * Added update Emerald cacerts folder with a dozen additional trusted CA certificates and removal of expired certs * Added remove unreachable cached emerweb query tables from session after copied for modification * Added filter submission of update emerweb function identity variables as form input * Added strip emerweb function to remove characters unaddressable as variables from column labels of query tables * Added csvinput emerweb function support for detecting UTF-8 and UTF-16 byte order mark in source parameter data * Added http client improve failure responses, add session reset, stream TLS upgrade option, abstract transport interface and switch to common encoding library * Added improved messages for network and encryption related failures during SMTP sessions * Added multiple condition parameters now supported in filter emerweb function * Added timeout parameter to httpget emerweb function * Added RADIUS client should share global emerald naming cache instead of local instance * Added start parameter to accumulate emerweb function applies offset between first row and starting value to output table * Added csvinput emerweb function to process CSV formatted data into query table * Added PV binding for all emerweb functions updated to use lookup table and allow values to start with '#' * Added color and hover parameters to graph emerweb function to manually determine line colors and apply custom mouseover callback * Added x-value in chart mouseovers now also included for non-time based datasets * Added upgraded TLS support libraries used to provide HTTPS access to Emerald UI and export system * Added charting now display current values while hovering mouse over bar and line data points * Added width parameter to graph emerweb function to define x-axis extent of bars * Added disable downscaling of environment and request indexes between http requests * Added strictly enforce token labeling restrictions of request headers from http clients * Added assign random 128-bit boundaries to outgoing multi-part MIME messages * Added use ISAPI SSF interface for flush hinting when Emerald UI is hosted from Emerald web server * Added suppress queries in debug output from 'update' emerweb function larger than 8k * Added normalize common function library usage within web server * Added include version number in application name field of database connections from session manager, scheduler, emernet and syslog server * Added http to https redirect option to security menu of Emerald configuration server * Added improve startup failure path of work scheduler thread pool * Added limit referring URL field from hyperlinks globally to same origin * Added summary emerweb function support for using a single base column to output multiple aggregates * Added move all remaining request processing out of primary event loop of Emerald web server * Added emerweb function 'join' to apply columns from related lookup tables to input table * Added default exception handler to assignincident emerweb function * Added improve performance of web server startup and shutdown when a large thread pool is configured * Added improve work scheduling and backlog mode within primary event loop of web server * Added include search length of postal code as tie breaker when determining most specific applicable tax within tax group * Fixed missing required parameter checking for sort emerweb function * Fixed scheduler should only update service manager when shutting down if shutdown has been requested by service manager * Fixed improve windows service manager communication when stopping Emerald web server to provide remaining worst case shutdown delay * Fixed rating step cost matching type does not work as expected failing to properly apply first and second colors to each interval of the range * Fixed spooler should be initialized in stage 8 rather than stage 11 to provide early access to log ring and connection testing * Fixed column binding related error messages do not provide information on failure cause * Fixed operator session state should not attempt to be synchronized persistently when operating from secondary database * Fixed unable to run reports during failover to read only database * Fixed output size may be calculated to be larger than actual output length when URL encoding fields * Fixed added missing default exception handler for tablist and select emerweb functions * Fixed scheduler should check for fetch failures if no matching servers found prior to adding server entry for itself * Fixed assertion error during http cc export processing on Linux platform for batch processors without passwords * Fixed web listener should transmit failure response for unknown request methods before closing connection and strict parsing of supported methods * Fixed strings dataset should be loaded during staged init rather than demand loaded and reload operation should simulate a reload without applying changes * Fixed use secure function on windows platform to clear encryption keys from memory when shutting down encryption manager * Fixed remaining non-reentrant time formatting functions should be replaced * Fixed SMTP read timeout may not function properly after upgrading to TLS * Fixed encryption manager access not required by scheduler and should be removed * Fixed SMTP replaced line normalize with streaming version and lines starting with period not properly processed * Fixed all strings data should be protected against permanent or temporary change * Fixed cache_themes emerweb exec function to reload themes should provide status * Fixed added missing default exception handler for group emerweb function * Fixed missing resource allocation exception check applying environment to incoming http requests * Fixed normalize CRLF usage in all MIME messages and HTTP response headers * Fixed synchronize socket access while clearing slow connections in backlog mode * Fixed AV possible after increasing size of server request buffer * Fixed AV while previewing POS estimates on Windows platform using SQL Server native client * Fixed AV in 'update' emerweb function while attempting to update a field not in metadata * Fixed AV checking web server socket status on Linux platform when TLS socket has not been configured * Fixed default robots.txt response should persist after configuration server is disabled * Fixed ISAPI version not properly displayed in process callback listing of status server * Fixed explicitly set stack size creating threads on Windows platform to avoid stack exhaustion when hosted under IIS * Fixed RADIUS attributes having data type signed integer not properly converted from string when transmitted via radlogin emerweb function * Fixed keys obtained from windows keychain should not be used by encryption manager should key authentication fail * Fixed dotted lines appear in date picker under week day when using Firefox browser * Fixed temporary table reference in 'filter' emerweb function not correctly scoped * Fixed off by one enforcing limit on count of 'with' parameters of emerweb 'check' function * Fixed passwords for local operator authentication as well as those passed to radlogin emerweb function should be trimmed prior to use * Fixed query tables created by gbe, emerweb functions range, assignincident and sessions missing specific type information * Fixed quality of ipv4 and ipv6 range parsers should be improved to reduce complexity and better detect input error * Fixed receive side timeouts sending SMTP mail not set properly on Linux platform. In rare cases this leads to blocking further processing of the notice within scheduler * Fixed uppercase and lowercase filtering should not depend on operating system locale * Fixed single element overflow in emerweb query function when executing queries returning more than maximum allowed number of columns * Fixed prevent unnecessary wakeups within work scheduler thread pool * Fixed improve handling of insufficient resources when processing user table and fresnel, elevation, snmpget, snmpwalk, summary, xmlinput, time and radlogin emerweb functions * Fixed summary emerweb function calculates a rolling average instead of average * Fixed emerweb functions 'change' and 'default' should constrain changes to current row and limit automatic column creation when executed on a floop* table * Fixed join emerweb function should not execute if output table has no rows * Fixed range 0.0.0.0/0 should be interpreted system wide as fully covering IPv4 address space * Fixed shutdown of configuration web servers without TLS support can be delayed due to failure to apply socket blocking options * Fixed attributes of tag string having tag values above 31 should be assumed to be non-tagged attributes when displaying RADIUS reply attributes within Emerald UI * Fixed resolve outstanding global vs group conflict for non-global configs having groupid of 1 Emerald 5.0.94 - 5/22/2019 -- * Added piggyback taxes now allowed to be processed across tax groups within same invoice * Added XML parser allow CDATA to be used as element value * Added TLS version 1.3 support for all incoming and outgoing TLS sessions * Added disable availability of SSLv3 when negotiating outgoing https requests from Emerald * Added update private key generator, emerweb hash functions, locking and SRP context for compatibility with upgraded TLS libraries * Added reporting engine configuration now updated when clicking apply no longer requiring service restart * Added updated Linux platform database access drivers, SNMP and LDAP support libraries * Added filter unknown out of range NAS-Port-Type attributes when recording RADIUS accounting data * Added replaced IIS specific processing queue with multi-threaded work scheduler * Added httpget emerweb function support for jsonflat response format * Added hosting Emerald under IIS is now autodetected no longer requiring manual registry settings to enable * Added Windows style username realm stripping of external HTTP or TLS authenticated login * Added tx flush hinting when hosting Emerald as an ISAPI module under IIS * Added cardtype emerweb function now automatically clears previous card type values prior to processing new cards * Added accumulate emerweb function support for table inputs having non-contiguous sequence grouping * Added replace custom list and memory management for operator group access, theme scoring, rating system AVPs, BST guess and GBE config * Added reduce contention during concurrent write to logging ring * Added use termination extension to shutdown Emerald hosted as an ISAPI module under IIS * Added improve empty field detection throughout emerweb * Added database procedures should have more control over ordering of payment and credit distribution to invoice line items * Added data masking transform option to hash emerweb function * Added batch processor lookup operation no longer transmits card account number to database * Added default emerweb function allows input columns containing empty values to be stored as a default value * Added graph emerweb function operating in column mode now supports row filtering using groupcolumn and group parameters * Added months, days and years parameters to time emerweb function allowing configuration of offsets relative to 'today' * Added when data masking is enabled and secure data input value contains masked data allow storage of masked value if current value is empty or does not exist to support externally stored secure data * Added export template area of exports configured as JSON filters are now processed using JSON specific string encoding rules * Added allow packages to be disabled without error when package folder is not configured and report more details about cause of any failures occurring while loading packages * Added switch to pthreads for rw locking on Linux platform * Added concurrent evaluation of access controls, configs lookup and theme selection to reduce thread contention * Added POST_STRING to access raw POST data similar to QUERY_STRING and removal of unused server environment variables from Variables table * Added transaction begin and commit failure messages within Emerald UI should include details of underlying cause * Added reduce overhead of emerweb table and column lookup operations * Added improve type marshalling while matching source RADIUS attribute filters * Added variable qualifier to output as escaped JSON string * Added variable qualifier for unconditional decryption of encrypted data * Added hash emerweb function to apply a cryptographic hash or HMAC keyed hash to given plaintext * Added reduce overhead of emerweb exec plugin function lookup by name * Added prevent hash table downscale for query cache, DNS cache, active operators and authentication lockout * Added improve safety and reliability of failure rollback procedures associated with modifying local configuration files on Linux platform * Added remove per-batch size limitations when executing SQL scripts from emerald/sql folder * Added variable output format qualifier support for RFC5546 / RFC6868 data * Added condition filter parameter added to emerweb select function * Added UTC parameter to time emerweb function and NowXX series of fields to form custom datetime formats * Added improved Emerald UI performance on Linux platform * Added improve quoted data stripping algorithm used by export system * Fixed accumulate emerweb function does not produce expected result when a sequence identifier not provided * Fixed snap invalid dates within standard to daylight time transition forward on Windows platform * Fixed friendly DRI error message not displayed when record deletion fails and changes not executed within transaction * Fixed operator entered dates having 12 hour time formats may not be recorded properly * Fixed execute TLS clearing when shutting down multi-threaded work scheduler * Fixed move temporary folder for custom report post processing from Emerald/web/reports/tmp to Emerald/tmp * Fixed report post processing interface does not work as expected on Linux platform * Fixed session manager should not set rating attributes having null values when rating to detect authorization change * Fixed export system custom filter JSON Flat does not produce expected results parsing JSON formatted responses * Fixed data rates conditioned on time sets should only increment historical time and data usage counters over subset of range currently costed * Fixed hosting Emerald as an ISAPI module under IIS blocks due to processing queue having not started * Fixed staged startup should fail to complete when database encryption is enabled and no decryption key is available * Fixed failure to create one or more threads while initializing multi-threaded work scheduler should result in initialization failure * Fixed prevent web requests from processing should request parameter parsing not be completely successful * Fixed session cookies should not be logged when debug logging is enabled * Fixed scheduler should not cancel reservation after scheduling work since reservations are consumed when scheduled * Fixed logging ring queue overflow warnings should not themselves be dependent on logging ring and must always occur at predictable intervals * Fixed large requests are not processed when hosting Emerald as an ISAPI module under IIS * Fixed memory leak possible failing to add or change a record via update emerweb function when row level label access is denied * Fixed statement future invoice activity filter should disregard nonrecurring services and self-limit to 30 day period * Fixed new statement active MBR filter applied to join rather than where clause * Fixed menu group labels should use dbpool for query parameterization * Fixed statements created as a result of new invoices should filter unprocessed and voided invoices * Fixed single byte overwrite possible should block limit of ews templates loaded from in-memory ewp database be exceeded * Fixed write protect inputs of buffered template processor in order to prevent failure while concurrently processing templates executed from a cached query * Fixed replace configs and RDBMS label parsers within buffered template processor with read-only implementation * Fixed select emerweb function writes an empty class for options having no class assigned to them * Fixed added missing default exception handler for ungroup emerweb function * Fixed variables source table was transmitted as request header variables by httpget emerweb function when a custom request body is used and source table not specified * Fixed summary emerweb function should explicitly check for presence of grouping columns within source table prior to execution * Fixed summary emerweb function must preserve internal type information of all grouping columns and data fields when generating output table * Fixed elements of comma separated emerweb function parameters should be trimmed prior to processing * Fixed improved exception handling when binding all columns via emerquery * Fixed regular expression based validation rules with no validation expressions defined cause no inputs to be accepted on Firefox browser * Fixed when no themes can be matched default theme should be assigned rather than last theme matched within operator's session * Fixed transactions attempting to be committed without having previously started should result in error * Fixed controlled shutdown timeout caused by non-MT safe packaged file reference counter * Fixed stage 12 and 13 plugin and package init failures should prevent init progression and be reliably retried * Fixed cached metadata queries are transmitted to the database when emerweb update function is not executed within an external transaction * Fixed multi-threaded work scheduler used by task scheduler and RadiusNT/X leaks synchronization objects when shutdown * Fixed AV possible in emerweb update function while eliminating auditable fields * Fixed AV possible when an exception occurs validating configuration in Emerald configuration server * Fixed table column sorting in Emerald UI is not available for columns containing a form button Emerald 5.0.93 - 6/10/2018 -- * Added restrict mixed content via content security policy when HSTS is enabled prior to login * Added move HSTS header to be visible to unauthenticated external scanning tools * Added RADIUS client support for concurrent async request processing and decreased lock contention * Added increase per-process open file limits on Linux platform to at least 4096 across all services of Emerald suite * Added include error cause when reporting name resolution failures * Added xendcolumn parameter to graph emerweb function to explicitly declare x-axis extent of y-value * Added reload resolver configuration on name lookup failures on Linux platform limited to once per 10 minutes * Added improve scheduler startup to account for configuration changes while waiting for database, license and encryption manager availability * Added GBE version should be reported in application name field transmitted to database server * Added increase GBE query timeout from 30 seconds to 2 minutes * Fixed scheduler should use dbpool for all query parameterization * Fixed remove unused scheduler support for text mode operation * Fixed improve service compatibility with Debian based systems * Fixed missing DigiCert G2 cert now required by Payeezy batch processor * Fixed AV when creating self-signed public certificates from TLS wizard * Fixed database driver problem on Linux platform leads to invalid rating summaries for per-session totals exceeding 2^31 * Fixed inactive accounts should be excluded when initially loading account data into RadiusNT/X on startup to reduce memory usage * Fixed improve reliability of service init scripts on Linux platform * Fixed include certificates required for Authorize.Net and IP-Pay due to recent service change * Fixed services with period aligned anniversary billing cycle having multi-month pay periods and MBR billing day of 29 or more are sometimes invoiced for a month at a time rather than configured pay period * Fixed validation of password fields when modifying forms where password is unchanged should be supressed to prevent validation rule changes from forcing pre-existing passwords to be changed * Fixed improve reliability of dbpool, registry, keychain, sqlscript and memory backed output when insufficient resources exist to complete initialization Emerald 5.0.92 - 1/12/2018 -- * Added upgraded TLS support libraries used to provide HTTPS access to Emerald UI and export system * Added upgraded support libraries used to graph charts throughout operator client interface * Added once and noonce emerweb function memory should be indexed to efficiently support bulk deduplication * Added escape quotes contained within quoted fields during CSV output * Added quickbooks iif specific formatting and type conversion to csvquery emerweb function * Added snmpget and snmpwalk emerweb function support for SNMPv2c and SNMPv3 * Added use higher resolution timer to report response time for RADIUS requests within Emerald UI on Windows platform * Added expand native type support requiring less type conversion rating external datasources * Fixed realtime CC/EFT transactions where response transaction ID is invalid should additionally result in batch level failure * Fixed void compensation to abort processing of CC/EFT transactions which subsequently cannot be committed locally should be inhibited during manual void transactions * Fixed feature parameter within select emerweb function was not enforced for global administrators * Fixed statistics generated from lock emerweb function may not be stable for all floating point data types leading to detection of false change conflicts * Fixed single byte memory leak using expression based lineinput filter where matched name capture has an empty value * Fixed charts plotted over time display time in UTC rather than browsers local time zone * Fixed packaged javascript library files should be transmitted with mime type text/javascript rather than text/html * Fixed workaround heuristic XSS failures in Opera browser when managing ODBC datasources within Emerald configuration server * Fixed instances of unnecessary intermittent network latency of up to 1000 ms within Emerald web server on Windows platform * Fixed TLS session preparation should not be performed within web server primary async request handler * Fixed remove continue button from TLS certificate wizard when choosing between self-signed and CSR request * Fixed rating history upload process does not completely compensate for upload failures leading to possibility of same usage being uploaded more than once * Fixed accounting setting 'Allow Payment to Trigger new Statements' when disabled does not prevent statements triggered by new payment activity * Fixed service init scripts should try pkill in the event killall is missing on Linux platform Emerald 5.0.91 - 2/20/2017 -- * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added unknown variable can be represented as empty value when using '.' variable qualifier in notice and export systems * Added customer center setting controlling months of invoicing history to display * Added validate calculated line items before committing invoices * Added move 3DES ciphers from high and medium to low security * Added increased maximum size of web server transmit buffer * Fixed rate history updates from rating engine may fail with database error * Fixed change detection error displayed when invoicing POS invoices * Fixed when processing recurring invoicing and billed thru date plus a month and two days is not sufficient to advance billing month invalid invoices are created with ending date a day earlier than starting date each time invoicing is run * Fixed standard functions not thread safe on Linux platform * Fixed restrict evaluation of GETDATE() special value to time related data types in update emerweb function * Fixed improve safe number filter to require negative sign to always precede numeric values * Fixed IP Pay batch processor error data if present should appear within failed transaction response Emerald 5.0.90 - 11/10/2016 -- * Added support for sequence identifiers within accumulate emerweb function to count deltas within named sequence * Added improve error messages normally caused by mismatches in current vs running configuration * Added region parameter support to reports churn, churn service, churn service detail, commission, commission detail, forecast, daily forecast, GL payments, GL invoiced, deferred revenue GL and deferred revenue detail * Added customer center option to control address defaults for credit card AVS when making payment or changing card on file * Added noonce emerweb function which evaluates opposite to once * Added change emerweb function to modify current row of query table * Added PeriodEndDay column to time emerweb function when billday parameter is used to indicate last full day of billing period * Added native support for 64-bit operating systems on Linux platform * Fixed Sybase specific native errors should not be suppressed when executing SQL scripts using SQL Server * Fixed web server buffered write flush should not clear buffer on transmit error * Fixed missing memory allocation exception check loading plugin DLLs * Fixed improve error handling when loading IP access controls into security database and use standard functions for IP/Subnet address checking * Fixed allow Emerald UI to be referenced from external frames if frame is sourced from same domain as Emerald * Fixed remove duplicate path translation check when Emerald not running under IIS * Fixed enterprise edition license should not enable filesystem checking to replace packaged templates * Fixed template parsing problem immediately after some string translation variables can cause invalid character output * Fixed when no port is defined for radlogin emerweb function allow RADIUS client to determine default port from service database rather than default to 1645 * Fixed suppress duplicate output of barcode style sheets on subsequent calls to barcode template function within the same request * Fixed dbpool improve error message on failure to allocate statement handle after query execution and treat no data as successful execution * Fixed prevent billing engine from accepting negative payment amounts prior to payment processing * Fixed when creating a new database from configuration server remove database user and file location settings * Fixed database install scripts not always cleared from memory once database created * Fixed utf-8 characters entered within Emerald on the Linux platform using SQL Server database may not be properly encoded * Fixed interim invoices were being held when they should be allowed to be generated right away when all services within MBR are canceled * Fixed prevent monthly time and data renewal from sometimes occurring a day or two earlier than expected * Fixed batch printed invoices and statements do not render properly for printing in many current browsers * Fixed prevent operators from selecting quantity of less than 1 when adding an adjustment or POS invoice line item Emerald 5.0.89 - 4/10/2016 -- * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added any password meta validation rule for password fields exempt from complexity requirements * Added more TLS cipher strength selection options (low,medium,high,fips140) and removed rc4 based ciphers from availability for medium security strength * Added changed default maximum concurrent database connections from 20 to 32 * Added prevent Emerald from being used within external frames for improved security * Added RADIUS log search report updated to prevent read locks when used with SQL Server * Added limit execution time of credit card import and CC/EFT payment transactions to clear any possible deadlocks while processing transactions * Added syslog server spooler connection pool reuse * Added prepaid sequence for 3 digit numeric account login * Added Worldpay realtime credit card processing gateway * Added improve CC/EFT transaction creation procedure to allow for different execution plans depending on whether called to create new transactions by MBR or globally * Added reduce delays when viewing online list and call search reports * Added MBR and service open/close/change timeline support to billing engine (6) * Added reinvoice billing engine function to automatically void and invoice accounts to match updated timelines (6) * Fixed improve end date prorate calculation of exception where a full month is included when prorate is within a few days of target * Fixed prevent fractional day inaccuracy enforcing past date change restrictions on account close/change to non-accounting administrators * Fixed reduce complexity and correct unhandled failures within 'update' emerweb function * Fixed missing exception handler for 'lock' emerweb function * Fixed syslog server message spooler does not log transaction commit failure * Fixed syslog server should constrain string and ellipses processing for debug logging * Fixed dependency check errors when managing actions, customer center login change and signup using an Oracle database * Fixed name break filter when processing non batched CC transactions for an MBR fails with database error when authorization name does not contain first and last name * Fixed remove unlock emerweb function (unused) * Fixed remove change validation permission bit from access controls (unused) * Fixed calendar emerweb function may fail to match temporary query table of result filter (unused) * Fixed lack of redundant change filtering within market engine leads to infinite loop (6) * Fixed market engine market tag invoiced days limit off by one day (6) * Fixed invoicing over account change timeline involving service type change and open events off by a day (6) * Fixed branch emerweb function does not properly filter children of non-root parentkey (6) * Fixed memory leak when meters parameter of geomatch emerweb function is used (6) Emerald 5.0.88 - 12/10/2015 -- * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added user agent of "Emerald" now included by default if one is not configured with an outgoing http request * Added TLS SNI support in outgoing https requests for CC/EFT/export processing and httpget emerweb function * Added option group support when rendering selection lists from emerweb select function * Added account number masking options to show first 6 and last 4 digits of account numbers * Added RADLOGIN_TIME variable to display response time in milliseconds from radlogin emerweb function * Added minimum and maximum overlap options over calculated polygon area in geomatch emerweb function * Added configuration server security option to configure TLS version * Added aging snapshot report showing non-credit aging based on invoicing and payment history at chosen point in time * Added notice tokenid and subtokenid columns support non-integer strings by hashing strings into integers * Added notice nosend column to enable adding row to actives without sending email/sms notification * Added service data left notification support for interim accounting * Added notice system stored procedure to add actives (6) * Added meters parameter to geomatch emerweb function to declare shape/aux as units of meters for automatic conversion (6) * Added meta option to declare columns add-only preventing update function from changing fields after row is created (6) * Added assignincident emerweb function enhanced to support role based assignment strategies for appointments by distance and time block (6) * Added once2 emerweb function alias of once (6) * Added market engine reduce day processing by excluding tag types which cannot change over time (6) * Added accumulate emerweb function for graphing running totals (6) * Added increased maximum authentication failure lockout history from 4 to 10 tries (6) * Fixed default extension not applied to package created while creating a new MBR * Fixed reduce aggressiveness of authentication failure lockout state expiration when many lockouts are active * Fixed AV possible if it were possible to lookup fields internally from a table with no rows * Fixed security init startup stage may cause AV upon retry if security database previously fails to initialize * Fixed setup charges should not be allowed to cause creation of interim invoice * Fixed remove unused check email task * Fixed graph type cannot be configured separately by line in multicolumn mode when rendering a graph * Fixed missing failure descriptions when summary emerweb function fails to match aggregate functions to columns * Fixed default client side field validation for binary data as string * Fixed starting temporary extension should update while new billing group is selected while creating a new MBR * Fixed remove unused manual change confirmation support from update emerweb function * Fixed set service expiration for accounts with renewal billing cycles where service expiration is blank while applying payment to invoice * Fixed process session manager disconnect for sessions in chronological order from session start instead of from last interim * Fixed unpackaged templates which do not end in a newline may not process the last line of template * Fixed improve counts of days and months between two dates when calculating prorates * Fixed suffix _filename associated with file variables when uploading files from web form is empty when no path information is supplied * Fixed exclude non-recurring MBRs from Accounts / advanced search / free services, free MBRs and serviceless MBRs searches * Fixed explicitly set numeric datatype of lat,long,bearing and distance columns in output table of geodistance emerweb function (6) * Fixed allow dynamic evaluation of once emerweb function when variables are mixed with static values (6) * Fixed calculated bearing to destination when using geodistance emerweb function is incorrect (6) * Fixed inside and outside filtering of geodistance emerweb function should not be performed while the row filter is zero (6) * Fixed round service display cost to 4 places before rounding to 2 places instead of directly to 2 places (6) * Fixed remove unused list emerweb function (6) * Fixed record level application locking for export transactions fails (6) * Fixed market engine functions do not participate in web request transaction when open (6) * Fixed depth first payment ordering filter for nested services does not operate correctly (6) * Fixed filter non-recurring services when loading service data into the market engine (6) * Fixed market engine should filter inactivated account changes (6) * Fixed schema error adding a batch to the batch manager (6) * Fixed market engine service check causes AV (6) * Fixed missing distance and weight variable qualifiers for automatic conversion (6) Emerald 5.0.87 - 7/10/2015 -- * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added urlinput emerweb function for processing external URL encoded parameter lists * Added query variable qualifier '%' for processing date formatted input with line exclusion * Added allow secure data variable qualifiers within query execution for comparing encrypted values * Added variable level eval qualifiers now supported for query processing * Added reduced markup overhead of table emerweb function * Added variable substitution now supported in allowed_include and denied_include fields of check emerweb function * Added reduced delay when applying changes from within Emerald admin * Added optional certcheck parameter to httpget emerweb function allowing certificate validation to be disabled * Added AS keyword supported to specify alternate output column in aggregate function field list of summary emerweb function * Added subject alternative name extension checked when validating certificates for CC/EFT batch and external system processing * Added export system field format md5 hex * Added Converge realtime credit card and ACH processing gateways * Added Payeezy realtime credit card processing gateway * Added limited nested variable substitution for bulk messaging * Added default gateway URL for IP Pay batch processor updated due to changes at gateway vendor * Added voice rating external rate table import file upload feature by destination set * Added length and complexity enforcement options for password fields (6) * Added geocoder export processing and scheduling task type (6) * Fixed substring match in check emerweb function should be case insensitive * Fixed Oracle support missing for emerdap sync profiles * Fixed prevent Accounting-On/Off port clearing hints from automatically generating accounting stop records based on interim data * Fixed operator date format and separator preferences if different from global default was not used when running ews template based reports * Fixed amount field format of declined transaction notice should display up to only two decimal places * Fixed time of day was not included with date field of batch manager search results * Fixed httpget emerweb function should perform certificate validation - httpget is unused by Emerald v5 * Fixed tr emerweb function does not allow default output to be overridden if input parameter contains only symbols * Fixed reduced performance occurs when thousands of query tables are generated within a request * Fixed non default allow direct use setting when creating prepaid card batches was not stored * Fixed range emerweb function should allow equal starting and ending values * Fixed incorrect compensation when there is insufficient memory to add a table to query cache * Fixed export system should support posting data using GET method if request verb is set GET * Fixed display separate errors for name resolution or connection failures when smtp connection cannot be established * Fixed explicitly limit size of all GBE log messages * Fixed improved method for calculating service expiration on payment change by accounting for status of future invoices * Fixed SMS notices fail due to syntax error executing NoticeMailList (6) * Fixed allow feature and label security checks to succeed when feature or label not supplied (6) * Fixed prevent drift caused by rounding error when converting between imperial and metric distance units (6) Emerald 5.0.86 - 3/10/2015 -- * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added reduced processor and memory usage rendering emerweb templates * Added default and once emerweb functions * Added selected_default parameter to select function configuring optional default value when selected parameter empty * Added column, value and description parameters in decode emerweb function to override default query table requirements * Added business checking ACH bank account type option * Added run query scheduled tasks within explicit transaction * Added section2 and nosection2 emerweb function aliases (6) * Added version 6 MBR license counting rules (6) * Added CoA session probing to session manager (6) * Added remove mail and emerald logs, improve classification of audit messages (6) * Added notice system email message status logging (6) * Fixed missing support for displaying RADIUS attributes having types 8-bit integer, 16-bit integer and 32-bit signed integer in Emerald client * Fixed RADIUS dynamic authorization requests from Emerald online list may incorrectly report an incorrect message authenticator * Fixed emerweb variable qualifier $' does not operate as expected in query context * Fixed friendly duplicate warning message covered unique index but not unique constraint violations * Fixed preformatted text in default field output of table emerweb function should not occur by default * Fixed session manager dynamic auth requests may incorrectly report an invalid response authenticator * Fixed correct possible memory leak and missing exception handler within group emerweb function * Fixed uniform support for allowed* and denied* parameters within check emerweb function * Fixed use four decimal digits where available loading data for credit calculations to minimize rounding error * Fixed correct spelling of DateSeparator User table parameter * Fixed uninitialized memory access possible when checking if string represents a valid domain * Fixed disallow unsynchronized configuration changes after emerweb startup * Fixed remove low encryption strength cipher selection option (RC4) for Emerald HTTPS access * Fixed prevent storing initial SSL configuration using ieas.pem certificates * Fixed uninitialized memory access possible calling invoicevoid exec function without providing InvoiceID parameter * Fixed remove table2script exec function * Fixed market engine syntax error in bulk MBR preload query (6) * Fixed deletion of stored encrypted operator session cookies on logout fails (6) * Fixed remote address forwarded from reverse proxies not reflected in local environment (6) * Fixed second person encryption key check fails when only a single key is used (6) * Fixed first key rather than TPI merged key written to windows keychain (6) * Fixed zero memory after pushing 2FA client certificates (6) * Fixed section set should update existing address type and service type formatted groups rather than adding new (6) * Fixed AV processing change auditing for unsupported primary key configurations (6) Emerald 5.0.85 - 12/10/2014 -- * Added SSL certificate wizard to automate creation of private keys, CSRs and self-signed certificates * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added disable submit button after confirming signup to reduce opportunity for duplicate accounts * Added improved performance invoicing MBRs containing many thousands of services * Added default exception handler for lineinput emerweb function (6) * Added emerweb range function support for time quantities (6) * Added json parser to export system, httpget and jsoninput emerweb functions (6) * Added timefilter emerweb function to filter query tables by grouped timerange criteria (6) * Added clientcert emerweb function to generate operator client certificates in pkcs12 format (6) * Added two person encryption key management (6) * Added reflecting regex named captures into query table output from lineinput emerweb function (6) * Added access label and feature checking within emerweb check and select functions (6) * Added regular expression meta validation rule (6) * Added notice system support for SMS, operator targets, delivery time of day restrictions and notice purposes (6) * Added rating engine local aggregation of related intra-session summaries to rate history (6) * Fixed always preference server variables in Variables table even if they have no value * Fixed metaencryption should not be a preparsed function * Fixed remove strings emerweb function * Fixed refreshing configuration while configured backup datasources are unavailable or misconfigured can cause refresh to fail unnecessarily * Fixed remove support for SSLv3 * Fixed RADIUS client should calculate hashes in-place to reduce possibility for error * Fixed buffered writes to non-web targets may not be 8-bit clean * Fixed prevent payment description information in MBR history from being excluded from display * Fixed consumption of minutes within time bank should not round up in case where session duration falls on whole minute boundary * Fixed invoice estimates were not able to be printed using default invoice report Emerald 5.0.84 - 3/10/2014 -- * Added allow alternate port number to be specified in SMTP client as part of SMTP server name * Added metarule automatic conversion and display variable type support for metric and imperial units ft/m, mi/km, lbs/kg and in/cm (6) * Added secure functions for ellipses processing on Windows * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added tax selection from address role, service and custom data fields (6) * Added integrate market engine with GBE (6) * Added batch manager global multiple concurrent access lock and local backup (6) * Added CC/EFT export file level header and footer options while configuring export file formats * Added check deposit report include total number of checks with total amount summary * Added support for SG RADIUS VSA dictionary * Added RBC STD 152 export format includes file header and credit/debit transaction date changed from etrans date to two days from export date * Added include service expiration as reason for session disconnect via session manager * Added NAS-Port / NAS-Port-Id filtering while disconnecting sessions from session manager * Added session manager support for v6 schema (6) * Added changed configuration server document type for HTML5 * Fixed when canceling service cancel date saved is one day earlier than expected and prorate calculation when closing accounts credited for a day more than expected * Fixed corrected inconsistent behavior trimming unused pairs of fractional digits in functions using emerquery * Fixed removed poor random source in client TLS operations while sending SMTP email * Fixed decryption attempt of unencrypted fields smaller than 5 characters was incorrectly interpreted as decryption failure * Fixed rating engine missing exception check while converting IPv4 addresses * Fixed integer field type fails when saving RADIUS attributes * Fixed MBR form reload loop from incompatible changes to billing cycle selection * Fixed automatically remove operator group level configs and report groups when deleting an operator group * Fixed improve performance of bulk invoicing process * Fixed incorrect commission report paid point totals possible for line item quantities greater than one * Fixed adjustments to payments both created and adjusted within the reporting window should be excluded from adjusting column of GL Payments report * Fixed scheduler tasks may still appear in the running task view after having been completed when discrepancies between scheduler and database clock exist * Fixed prevent initial eNom sync updates for inactive accounts Emerald 5.0.83 - 8/10/2013 -- * Added access time format supports one month day - month day range and week of month expressed as English spelled numbers (6) * Added encrypted persistent storage of session cookies (6) * Added search field tab order improvement and initial focus of all search forms accessible from Accounts menu * Added enhanced type detection and empty field checking for all sortable column headings * Added market engine (6) * Added marketactive scheduled task and ews exec function to update MBR/SA market tag status (6) * Fixed when sorting fields within aging report summary footer position should be unaffected * Fixed zero cost rate history items should be excluded from daily error report * Fixed payment change should be allowed for all custom payment types * Fixed duplicate or skipped records possible while rating RADIUS call records * Fixed session manager enforced concurrency limiting should disconnect older sessions before newer sessions Emerald 5.0.82 - 6/10/2013 -- * Added emerweb SSL client certificate authentication (6) * Added operator TLS-SRP secure network authentication option (6) * Added SSL cipher strength options in /settings security menu (6) * Added SSL forward secrecy settings (6) * Added web server support for TLS versions 1.1, 1.2 and configuration setting (6) * Added allow SSL even if no RSA key pairs have been successfully loaded * Added display failure reason in /status URL if any SSL certificates cannot be loaded * Added remove hidden web server IPv6 disable option * Added authenticated cipher mode pa2 to Emerald encryption manager (6) * Added IP metarule validation support for IPv6 and name caching * Added time range and IPv4/IPv6 prefix metarule validation (6) * Added order of operator context requirement within $menu function * Added replace encryption manager length estimator * Added merge session contexts when integrated operator authentication is used * Added abstract short term account lockout features * Added access time restrictions limiting operator access (e.g. business hours) (6) * Added HSTS strict transport security feature and configuration option (6) * Added improve user agent, IPv4/IPv6 prefix and time of day matching in themes (6) * Added message signature attribute for Disconnect/CoA messages from Emerald and session manager * Added CallsMissing and CallsMissingDetail procedures to report potentially missing call records * Added RFC6911 and RFC6930 supporting attributes * Added 30/1 and 60/1 rounding types to rating engine * Fixed service expiration notice should exclude services assigned to packages where package is inactive or canceled * Fixed use of emerweb $select function without operator context when row access labels are referenced triggers AV * Fixed remove redundant random source from linux platform * Fixed replace cookie parser to correct AV triggered by Avast software * Fixed include only recurring accounts in default service expiration reports * Fixed decision to include previous invoice during service close off by one day Emerald 5.0.81 - 3/10/2013 -- * Added improve web server listener failure messages * Added suppress unnecessary request parsing within web server module for requests handed off to emerweb ISAPI module * Added reverse proxy client address forwarding configuration using X-Forwarded-For and X-Real-IP headers (6) * Added perform global IP access checking prior to parsing client request variables * Added metadata controlled transaction level table and column change audit logging (6) * Added removed internal column and row number query table field references * Added restrict number of variables per request to 400,000 and update request parsing operations to complete in linear time * Added floop3 emerweb function * Added xmlquery emerweb function remove memory allocation, parameters to adjust column case, row number tag labels and suppress parent and row tags * Added summary function variable support for groupby,sum,avg,min,max and count parameters * Added graph emerweb function support for column based configuration of multiple graphs within the same chart (6) * Added fresnel emerweb function support for multiple fresnel zones per row, calculating lat/long coordinates along path and antenna height (6) * Added geomatch emerweb function support for maxarea overlap parameter to retrieve record containing maximum area within set of matching polygons (6) * Added changed web worker request reallocation factor from 1.7 to 2.0 * Added RADIUS client expected command code response mismatch failure reporting * Added support for Starent RADIUS VSA dictionary * Added Royal Bank of Canada Standard 152 debit and credit ACH batch file processing * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added emerdap replaced LDAP support libraries and configuration options. LDAP server names must now be entered in URL form ldap://host or ldaps://host * Added emerdap moved to common logging system * Added session manager changed from string to integer associative session lookup * Added support for URLs containing IPv6 literals * Fixed single byte overflow possible during multipart request processing * Fixed reduce unhandled memory allocation failure * Fixed AV on export batch import failure with no messages * Fixed assertion error in httpget emerweb function when processing malformed URLs * Fixed malformed referer should be treated the same as no referer * Fixed export header suppression checking was reversed and did not include transaction id * Fixed export truncated field not written when value length exceeds maximum length * Fixed file transaction failure while multiple files are opened with the same temporary timestamp * Fixed sesson manager rating rule CoA flap caused by initial start record with no data dimension later updated by interim record with data * Fixed start date information is forgotten when updating MBR forms between recurring and non-recurring cycle types * Fixed geodistance erroneous calculation of position given bearing and distance * Fixed client IPv4 address appears invalid in systems using scope identifiers with IPv4 mapped IPv6 addresses * Fixed web server all listener failure and client name exception logging Emerald 5.0.80 - 10/10/2012 -- * Added emerweb direct reference access control (6) * Added increased external emerweb per line character limit * Added emerweb abort function allowed at start of new line * Added removed emerweb commalist function * Added concat emerweb function (6) * Added reduced emerweb dynamic memory usage processing templates * Added improve emerweb table.column variable lookup * Added emerweb row count 'rows' label supported for comparison operations * Added seckeytable parameter to emerweb select function for filtering select items by row level 'label' operator access limit (6) * Added dependancy based row level label access enforcement in update emerweb function (6) * Added sectionprefix and fieldmap parameters in table emerweb function enables column based field rewrite and section enforcement (6) * Added label option to check emerweb function for label access checking (6) * Added header parameter for csvquery emerweb function to toggle output of first row column header * Added label access checking for menu system (6) * Added reduce delay while sending RADIUS queries from Emerald * Added verb parameter in httpget emerweb function to configure request type while sending http requests * Added reduced polygon download delay while running bulk geographic queries (6) * Added emerweb database data type support for GUIDs and conversion from multibyte characters from SQL Server 2012 * Added when running query from Emerald scheduler iterate all result sets before checking Description to set scheduler status message * Added scheduler now uses a thread pool to execute tasks, previously a new thread was created for each task * Added SQL Server 2012 compatibility when creating an Emerald database however recommend not using SQL 2012 until bugs causing large identity field gaps are corrected in a future service pack * Added server name matching by NAS-Identifier during server port access enforcement when NAS-IP missing from RADIUS authentication request * Added improve confirmation dialogue when purchasing time or data from customer center * Added export system realtime geocoder export type * Fixed contention caused by display of backup device information and exclusive file access needed when performing immediate backup * Fixed when MBR or service fields have been disabled by configuration or operator access restrictions an error may occur while saving changes due to missing dependencies * Fixed when IE option to display a notification about every script error is enabled a permission denied error occurs when closing popup menus * Fixed rollup usage from rating system to charge adjustment may not occur when MBR is configured with calendar or anniversary period aligned cycle type * Fixed workaround when running database backup from Emerald scheduler the backup query succeeds yet backup operation fails in SQL Server 2008 or later * Fixed reduced lock contention for sections and further changes to licensed feature strength * Fixed single byte overflow possible while converting datetime fields * Fixed query strings containing a key field without an equal sign and value are now treated the same as a key field with equal sign and no value * Fixed when minimum area overlap option is used within a geographic query count of matches did not increment for all candidates * Fixed while displaying RADIUS response attributes of type octets output now shown in hexadecimal form rather than string * Fixed pad header of table output when no columns are present * Fixed correct missing substitutions and mismatches in emerweb variable format processing * Fixed last line of emerweb external ews files skipped when not terminated by newline * Fixed select emerweb function option values not quoted * Fixed prevent AV caused by customizing login theme file _login.ews to use ews commands requiring an operator context before user has logged on * Fixed items missing from commission detail report when payments are removed during report period Emerald 5.0.79 - 6/10/2012 -- * Added remove preparse parameters for emerweb functions: random, range, time, xmlquery, sessionkill and sessions * Added remove emerweb validate function * Added prevent variable level eval from triggering emerweb functions include, abort and commalist * Added function level emerweb eval using pipe * Added prevent recursive evaluation of variable and function level eval * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added improve native type usage when downloading current record values during update * Added improved error checking and or default exception handlers for emerweb functions: tablist, table, decode, menu, formcheck, range, sessions, udpsend, sessionkill, cardtype, time, random, xmlinput, summary, geodistance, graph, sort, fresnel and (cache)query * Added copy on write while modifying shared data in emerweb functions: decode, geodistance, snmpget and sort * Added headermap parameter in table emerweb function enables column label rewrite * Added csvquery and xlsquery emerweb functions for csv and excel spreadsheet formatted output * Added sections support for menu system * Added xmlinput function dynamic row labels * Added inside and outside centroid filtering parameters for emerweb geodistance function * Added branch emerweb function to construct a depth first graph given unordered flat dependency table * Added SQL scripting error exceptions on oracle native errors 1451, 1442 nullable column change * Added demand loaded staged initialization of Emerald UI * Added IIS worker threads are only enabled when IIS (ISAPI) support is enabled via registry emerweb\IIS=1 * Added Emerald UI access blocked until database version synchronization has completed * Added when Emerald has not fully started display current stage and diagnostic messages until startup has completed * Added unauthenticated script access applies operator group credentials when a file in the trusted database is referenced * Added flush write buffer before session request is cleaned up to improve UI performance * Added cached queries may now optionally define custom TTL if different from global TTL * Added display query execution time in milliseconds for each emerweb database query when Emerald debugging is enabled * Added separate marshaling for bigint datatypes in emerweb query function on windows platform * Added logging ring improvements: size doubled to 2000 entries, overflow warnings, reduced lock contention * Added automatic SMTP TLS upgrade when connecting to an SMTP server supporting STARTTLS * Added rating engine 64-bit data interval and step cost match type * Added move export module into gbe scheduling framework and remove export shared library * Added emerweb exec function support for userexport, batchexport and batchimport * Added export system option to configure requesting http verb * Added emerweb geomatch function to support geographic queries * Added scheduler task type ews enables scheduled execution of ews templates * Added eFolder backup external system option to record storage usage * Added online list and concurrency control enforcement for sessions from unknown servers * Added gbe support for billing cycle calendar year alignment offset * Fixed credit card expiration notices should not be sent to non-recurring MBRs * Fixed exports and batch processing should not run if encryption verifier has not been validated * Fixed oracle platform external system compatibility error with google apps and zimbra * Fixed filter all gbe floating point comparison operations using currency precision * Fixed settle incomplete gbe dependency graph caused by voiding, reinvoicing and redistributing voided payments within the same cycle * Fixed emerweb include function outputs an invalid character when used with no following commands * Fixed Microsoft SQL native client hangs during Emerald web server service shutdown Emerald 5.0.78 - 3/10/2012 -- * Added prevent SSLv2 from being negotiated for outgoing http requests on windows platform * Added AlphaNumeric and AlphaNumericSymbol output variables to the $random emerweb function * Added improve variable documentation when designing custom prepaid card sequences * Added allow $httpget emerweb function to process xml document body even when non 2xx class http result code is received * Added automatic emerweb log file rotation using file labels YYYY, YY, MM and DD * Added emerweb support for syslog logging * Added when rating classifier data attribute is not available in rating request the standard data attribute should be tried * Added increase maximum size of line item description within billing engine only * Added three letter country abbreviation available for CC/EFT exports * Added improve performance when distributing payments to invoice line items * Added provisioning support for zimbra mail accounts via admin soap api * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added support for Moneris eSelect realtime credit card processing gateway * Added decrease delay of Emerald client UI when operator selects Show MBR, MBR History or MBR Statements * Fixed IP Pay batch processor uses three letter country code rather than un country id to correct an input validation problem where transactions with two digit country ids are not accepted by IP Pay gateway * Fixed payflow pro CC and EFT batch processor configuration updated to reflect paypal default transaction URL and prompt separately for vendor and merchant * Fixed prepaid cards where underlying prepaid batch has been inactivated or inactive expiration has been exceeded should not allow direct use authentication or direct use account recharge from customer center * Fixed when voiding an invoice having charge line items contributing to time remaining where historical time tracking is used time allocation may not be revoked * Fixed calculation of disaggregated cost for price inclusive tax was incorrect * Fixed static tax applied to quantity of days should assume the daily tax amount is 1/30th of the static tax * Fixed infinite loop while processing cumulative taxes having zero total taxable amount * Fixed IPv6 address RADIUS attributes within access or accounting request messages from Emerald UI are not transmitted * Fixed http post to site root without trailing / fails due to missing post location * Fixed when package is canceled the final invoice may not be created if the starting date of the account is ahead of billed thru date of the package. This restriction was removed to maintain consistency with services * Fixed RADIUS response IP address prefix validation error * Fixed dbpool mark connection suspect should begin transaction fail Emerald 5.0.77 - 11/10/2011 -- * Added Emerald web server /status display highlight active slot used to process status display * Added database pool query execute status lookup now also effected by status of transaction management commands * Added reduced strength of sections feature bits where positive feature match also requires a positive match to produce a section match * Added rating engine enhancements configurable costing dimension, classifier data source attributes, session counting, datasource attributes may override matching dynamic aggregate attributes, custom historical update query * Added notice send query parameter now accepts NoticeID variable * Added rating datasource update query cost attribute precision increased from 4 to 12 * Added relax ordering restrictions on accounting records in the online view where stop is allowed to override interim out of order by call date * Added customer center rating unapplied usage history does not display usage as pending for previous months having no outstanding balance * Added merak mail database synchronization script updated for compatibility with icewarp 10 schema * Fixed amount remaining for RADIUS balance based time restrictions via rating engine is incorrect when smart caching is enabled * Fixed invoice is billed further in advance than necessary where service introductory offers cycle months is larger than service type cycle count * Fixed online report, call search and user call history should displays input and output usage statistics in quantities of 1000000 bytes * Fixed gbe missing daylight savings offsets when processing invoice starting and ending periods * Fixed signup server error creating account where language autodetect is enabled and no browser languages match the Emerald language database * Fixed lost events in rw locking system leads to deadlocks in windows versions of Emerald while managing many concurrent changes to SSL session cache, IP security and emernet collector * Fixed Emerald web server /status display can cause AV when viewing transport statistics for active sessions * Fixed rating engine divide by zero possible when processing usage without a time interval Emerald 5.0.76 - 7/10/2011 -- * Added support for VeriFone Payware Connect realtime credit card processing gateway * Added fresnel and sections emerweb functions * Added distanceformat parameter to set output distance format of geodistance emerweb function * Added when displaying response attributes promote VSAs having integer types and payload length of 8 bytes to type 64-bit integer * Fixed advanced menu classifier TTL setting after editing a rating classifier is not restored when classifier is subsequently modified * Fixed replacement DRI error message when an item being removed is still used was not shown on the MSSQL 2008 platform Emerald 5.0.75 - 5/10/2011 -- * Added metadata validation support for column level check procedures * Added httpget emerweb function support for sending custom data in the body of a remote web request * Added geodistance emerweb function now calculates bearing angle and inter-cardinal compass direction or ending lat/long given distance and bearing * Added circular reference detection for snmpwalk emerweb function * Added skip query execution for queries containing only whitespace characters * Added enable tcp keepalives while waiting for http client response via export system and httpget emerweb function * Added export system xml parser replaced to support element attributes and utf8 element labels * Added duplicate login check on operator service edit no longer uses popup windows * Added operator group level 'Operator Settings' allowed for idle timeout, history months, operator home page and card swipe * Added address city and state lookup via postal code entry improved for MBR edit and credit card forms * Added churn service and package level change detail report * Added exports using the protocol layer status feature may now parse the error body of a non 2xx class http response * Fixed emernet configuration server missing ODBC settings panel for installation as standalone component * Fixed configuring emerald web server to listen on specific IPv6 addresses may fail causing the system to fallback to listening on all addresses * Fixed export system AV while loading export configuration for an invalid export having no export columns defined * Fixed date header of SMTP mail sent from Emerald reports wrong UTC offset * Fixed IPv6 client addresses larger than 32 bytes truncated during audit logging * Fixed float data types from database queries incorrectly presented as integers * Fixed default times used in report parameter inputs may be an hour or less than intended when the period reported includes a daylight savings time status change * Fixed query error displayed on Oracle platform after selecting match type in standard rating advanced configuration for attributes with no value query defined Emerald 5.0.74 - 3/10/2011 -- * Added fair non-blocking http and https connection request processing * Added reduced initial startup time and virtual memory utilization on Linux platform * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added option to enable or disable case sensitive Emerald operator passwords * Added include message authenticator signature attribute when sending RADIUS requests from Emerald * Added improve quality of request authenticator when sending RADIUS requests from Emerald * Added support for IP Charge realtime credit card and ACH processing gateway * Added enforce sort order for presentation of service custom data fields from show service menu * Added change of service credits starting and ending period now reflected in invoice line item * Fixed ignore external sync failures in daily error summary report having not recently been retried * Fixed updating service billed thru on close or change of service may be off by an hour if previous day has different dst * Fixed default invoice report should only show starting and ending dates for recurring line items * Fixed improve performance of churn by service type report * Fixed customized footers should be available for all pages within customer center interface Emerald 5.0.73 - 1/10/2011 -- * Added table sorting emerweb function * Added regular expression matching for emerweb check function * Added bar code rendering outputs newlines between each symbol to prevent mail servers from improperly breaking long lines * Added column ordering parameter for grouped output of sumary emerweb function * Added low ascii filter string and constant sha1 hex export column format types * Added export configuration feature to treat protocol layer status indication as application layer status * Added upgraded SSL support libraries used to provide HTTPS access to Emerald UI and export system * Added Aux8 app specific transition type for realtime external systems * Added summary section of payments report ordered by payment type * Added usage detail reporting based on rating usage summary * Added row level custom import filter (ExportFilter) to override export global filter setting * Added when an export template section is not defined or empty export column variable configuration are used instead * Added ExternalSyncDelete sync procedure for realtime external systems * Added support for intellipay realtime credit card processing gateway * Added filter non-english characters from authorize.net CC/EFT transactions to prevent transactions from being rejected * Added Aptilo MAS external system sync * Added Emerauth support for Imail version 11.0.3 * Fixed single byte overflow obtaining sqlstate parameter during query error * Fixed date/time field validation failure for dates exceeding year 2037 * Fixed remove service password display field from account summary report * Fixed cc auto should not be entered into the notes fields of manual CC/EFT payments created by an operator or end user Emerald 5.0.72 - 11/10/2010 -- * Added server and client meta column regular expression field validation * Added when there are no query or column parameters defined for httpget ews function default to sending no request parameters rather than sending Variables table * Added web server SSL function order and thread local storage updates * Added client search by external invoice number now supports partial (substring) matching * Added WiMAX Forum RADIUS attributes, draft extensions format and VSA updates * Added signup server and customer center package selection filtering by charge type billing group membership and active status of package types and time charges * Added operator column to MBR history display * Added accuracy of online time display within the service call summary improved to show fractional hours * Added post payments option under the billing menu now supports custom payment types * Added one time charges selection filter by associated charge types group membership and support for disabling time charge by setting negative sort order * Added accept rating configurations where data based rate rules are associated with time sets * Added payment summary area for date range covered by daily payments report * Added call summary by user report by data usage * Added web service provisioning support for eFolder online backup service * Added session manager support for dynamic columns enabling custom fields as attribute input to the rating system * Fixed Oracle calls trigger does not automatically remove interim accounting records * Fixed session manager should use combined upload and download interim data usage rather than download only when making CoA/Disconnect decisions via the rating system * Fixed error message displayed when adding new notices of incident related types on the Oracle database platform * Fixed allow strings update setting to prevent synchronization of existing custom language localization during product upgrade was not honored * Fixed daily error summary report should exclude transactions awaiting export for more than 15 days while they are associated with inactive MBRs * Fixed when uploading scheduler task status to database task information was incorrectly escaped an additional time * Fixed rating engine should zero data dimension when rating in the time dimension and there is no time interval * Fixed rating engine data rates in time rate context with multiple rates may ignore previous local authorization settings * Fixed signup process does not continue past credit card entry form when French language translation is used * Fixed automatic change of service or package type should reset the cycle count limit to allow for chaining of additional introductory types * Fixed when using introductory offers if the cycle months for automatic change of service type has already been invoiced and exceeded due to a configuration change do not attempt to apply the change retroactively * Fixed invoice ending date for services with a prorate close setting of unused month may not be calculated properly * Fixed form header when editing an MBR missing localization string * Fixed export system memory leak while validating server certificate chain for CC/EFT processing and web service requests * Fixed AV possible during concurrent https requests to remote systems * Fixed new account created from signup server or customer center with time left field set to replenish daily is not refreshed on the first day at midnight because a 24-hour period had not yet been reached Emerald 5.0.71 - 9/10/2010 -- * Added indexed RADIUS client attribute search * Added verify_invoices utility to globally verify all invoices associated with active MBRs * Added custom report dependant selection fields for Country and State * Added group selection filtering for admin menu options Domains, Discounts, Sales Persons, Charge Types, Service Types and Package Types * Added column sorting for admin menu options One Time Charges, Pay Periods and Taxes * Added payment receipt report displays CC transaction approval code and lists invoices effected by payment * Added export system unconditional yield counter changed from 100 to 500 transactions * Added session manager will now initiate CoA requests when dynamic changes in upload attributes are detecting in rating system to update active network sessions without disconnecting users. If CoA fails or is unsupported a disconnect request is issued instead * Added Array-Networks RADIUS VSA attributes * Added redundant MBR balance check while creating CC/EFT auto pay transactions * Added RADIUS authentication lookup should not require serial access for initial prepaid lookup * Fixed calls trigger section to further attempt to associate user name with an Emerald service may run unnecessarily if there are several accounting records queued * Fixed log trimming maintenance task did not qualify the table alias of the ExternalTrans.SSN field potentially causing conflicts if custom fields were added to other tables with the same label * Fixed viaWARP gateway export configuration incorrect field format * Fixed scheduler service does not respond to service stop requests before database connectivity has been configured such as installing Emerald and then immediately uninstalling without configuring database access * Fixed taxable line item having price inclusive static cost tax amount less than the total amount of the actual line item must not reduce the line item cost below zero * Fixed RADIUS authorization attributes uploaded from the rating system during authentication should be limited to only those attributes applicable at the instant of authentication rather than to subsequent rule matches throughout the costed dimension * Fixed session duration limits based on current balance from rating engine is not enforced when the InitialCost attribute is uploaded to specify the starting cost of the session * Fixed authentication reject for users associated with one or more rates having no default rules should only be enforced when there are one or more rate matches via rate class * Fixed updating menu options using the menu editor in the advanced menu fails with a query error on the oracle platform * Fixed domain level unique login checking should check the domain associated with the signup server rather than the billing groups default domain * Fixed when http listen port is disabled on hosts supporting dual stack sockets https access also becomes unavailable over IPv4 unless listener configuration is used Emerald 5.0.70 - 7/10/2010 -- * Added external invoice field Invoices.ExtInvoiceNum to enable search and display of origional invoice numbers imported from external systems * Added error_include handler now supported for all ews exec functions which set EXEC_RETCODE (See exec_error.ews) * Added tsgraph enhanced with new graphing system * Added churn by service type reporting * Added verify invoices check to make sure there is agreement between the amount of an invoice line item and its corresponding charge adjustment * Added DAN WiMax RADIUS VSA attributes * Added syslog filter administration improved to show severity labels and allow matching without explicit severity level * Added support for Chargeback Guardian realtime credit card processing gateway * Added churn report now produces figures exclusivly from invoicing histories over time to improve reporting accuracy * Added record count fields for GL invoiced and GL Payments report procedures * Added summary function now supports matchcolumn and matchvalue parameters for restricting aggregate calculation to rows with matching values * Added 'graph' graphing function to render line and bar charts based on source table x/y data * Added EmerAuth support for Imail 11.02 * Fixed when adding a new MBR with a package the starting date of the package is not set to the starting date of the MBR * Fixed charge type listing when creating adjustments or POS invoices may not include charge types associated via service groups * Fixed new account with time left field set to replenish daily is not refreshed on the first day at midnight because a 24-hour period had not yet been reached * Fixed when credit card show last four field hiding is enabled and an effected operator applies payment depending on unrelated configuration the payment may be submitted with the invalid digit hiding value known to the operator instead of actual card number on file * Fixed operators should not be allowed to remove the priority 0 default priority * Fixed expired accounts report should not filter out inactive or deleted accounts * Fixed orbital paymenttech batch processor configuration errors * Fixed statement batch short term exclusion lookahead for pending invoices should be supressed when MBR or service level cancel date is equal or less than the current billed thru date of the service * Fixed voiding of invoices with credit charge adjustments duplicate the adjustments so they can be applied to a future replacement invoice. During duplication the distribution flag field must not be copied for credit adjustments as this will prevent credit amount from being automatically distributed to invoice line items * Fixed multi-value-attribute rfc822mailbox query missing for NIS and Communigate Pro LDAP sync profiles * Fixed Everyone.Net, Helm and CPanel, Diino and Generic WS suspend status for expired accounts occurs a day too soon. Account should be usable for the duration of the expiration date * Fixed RADIUS client did not properly display values for VSAs of type tag attribute * Fixed export system SSL session cache was not thread safe sometimes leading to AV when multiple exports with SSL sessions run concurrently * Fixed transaction list for realtime CC/EFT transactions should be refreshed if an imported transaction id is not recognized to prevent import failure in the rare case a new transaction is added between batch processor initialization and transaction export Emerald 5.0.69 - 5/10/2010 -- * Added query and prefix parameters support for all ews exec functions * Added reduced count of preparsed emerweb functions and switched from optout to optin by default * Added multiple 'with' parameters to check function for match against any available 'with' parameter * Added glcodes selection listing parameter for accounting reports * Added all parameters within the Variables table can now be passed to reports where previously only a select few were allowed * Added SNMP query and walk emerweb functions * Added payment receipt report now includes billing group address information if a report logo is not present * Added emernet debug formatting enhanced to consistantly display flow summaries for concurrent IPv6 and IPv4 collection * Added payment distribution procedures changed to reduce possibility of SQL Server 2000 optimizer choosing a non optimal plan * Added external system provisioning support for the Diino backup service * Added notice type to schedule email sending of any parameter free report to an operator * Added monthly data usage warning notice type based on rating summaries * Fixed improved numeric query parameter restrictions for null matching, trailing/leading spaces and negative numbers * Fixed local group dependancy checking for add and update functions can fail * Fixed when adding new records the system must first make sure at least one field parameter is present * Fixed adding new columns to existing emerweb tables must include all rows of the table instead of just the initial row * Fixed expiring cached queries in the currently active removal exclusion list can lead to AV during load test if multiple expired versions exist concurrently * Fixed checkoperator added debug log message should not be displayed if the operation failed * Fixed emernet promiscuous mode data collection of IPv4 flows may not be captured properly * Fixed post payments billing menu should include additional fields in tab order * Fixed ignore negative quantity POS items * Fixed mime version field now included for messages which do not contain file attachments such as html reports * Fixed while removing external systems any external syncs dependancies should be removed first preventing dependancy error from being displayed * Fixed charge type listing displayed in the accounting admin menu was not sorted by sort order and charge type description * Fixed removed coloring for incident action state in MBR history menu prevent confusion with current state of incident * Fixed new accounts provisioned to CPanel control panel do not initially have passwords set properly until the provisioned account is updated * Fixed wrong billing cycle may be used to calculate service expiration when sending a time left or data left notice based on service time banking Emerald 5.0.68 - 3/10/2010 -- * Added IPv6 native transport for all Emerald modules * Added recursive 802.1q header support for emernet promiscuous mode data collection * Added emernet IPv6 traffic rating for NetFlow v9, IPFIX and promiscuous mode * Added when requesting data from a remote web server where no form parameters are to be sent use method GET instead of POST * Added short term local DNS caching for outgoing SMTP and HTTP connections. Clicking 'Apply' in the Emerald admin resets cache * Added while attempting an outgoing request to a DNS name with multiple IP addresses try subsequent addresses if the connection attempt to previous fails * Added if response to an HTTP request is an error code the code is reported as an error and message content is not parsed by the export system * Added operator IP security access list accepts DNS names and IPv4/IPv6 CIDR notation * Added remove stored session cookies immediately on operator logout * Added changed secondary ordering for incident search results such that open incidents are ordered oldest first and closed incidents are ordered newest first * Added session management system coalesces duplicate operator sessions for operator and web service requests * Added persistent session management for end user access to customer center enabling web server instances to be treated as a stateless system * Added improved language translation lookup * Added integrated operator authentication when emerweb hosted under IIS * Added configuration servers prevent duplicate items from being added to list input box * Added listing of available local IP interfaces are provided during listener configuration * Added operator listing in the Emerald admin security menu is now sortable by column and ordered by active status followed by operator name by default * Added creating new incident using an incident type having an email address and show email enabled the types email is filled into the new incidents email field automatically as an operator clicks the email field * Added creating new incident the assignment role can now be defaulted automatically if available to the operator based on the incident types default role when applicability is set to Customers & Operators * Added incident assignment roles now ordered alphabetically in the operator and admin interfaces * Added incident types and statse with negative sort orders are removed from availability when creating new incidents * Added post payments billing menu supports hotkey navigation (C - Customer ID, A - Amount, I - Invoice ID, S - Statement ID, K - Check Number, P - Make Payment) and auto clearing of previous values when entering subsequent payments * Added statement line items displayed within the MBR statements menu now appear in the inactive background color in the case where an invoice was both created and voided within the same statement * Added region and billing group selection lists have been reordered such that inactive entries with negative sort orders appear last within the list * Added active expire minutes field for prepaid card batches to configure fractional day card expiration * Added email field to MBR account report * Added customer id to default invoice report * Added operator or user created by field to new action notice types * Added operator home page theme based open incident list secondary sort of create date now in ascending order and results display incident creation date * Added when opening an MBR or service require the starting date must not be covered by the terms of an non-voided invoice and non-canceled invoice line item * Added check numbers can be stored when applying payments using payment types other than check payment * Added local concurrent access locking for CC/EFT transactions as a backup measure to the database global lock * Added large CC/EFT batch transactions may now automatically temporarily suspend to allow time sensitive operator or customer submitted manual transactions to process without waiting for batch completion * Added POS invoices with negative credit amounts now allowed by automatic association of a charge with the invoice * Added notice types for sending new incident assignments and new actions can now be restricted to specific incident types * Added total invoice amount including tax line items associated with paid tax line items now reported via additional columns in the tax payments report * Added smartermail web service sync can now request deletion of accounts directly without first requiring a transition to the deactivated state * Added customer center option for users to change their accounts send method. Customer access must be enabled at send method level and web interface / customer settings / allow send method option set 'Yes' to enable this feature * Added improved storage efficiency of clustered indexes for Calls and payment distributions on the Oracle platform * Fixed reseller invoices queued to be generated when the reseller billing feature is not license enabled should be skipped allowing other types of invoices to be processed rather than preventing invoice processing * Fixed access denied error message is displayed when adding an action to an existing incident and the operator does not have modify access to the incident * Fixed credit adjustments unapplied to invoices reflect a negative amount when edited. Amount displayed when the edit from is loaded must always be a positive value as credit/charge radio buttons determine sign of the amount * Fixed audit logging parameters when deleting a service for Login, FirstName and LastName are not set * Fixed emernet promiscuous mode collection now counts byte statistics based on actual L2 payload size rather than IPv4/IPv6 header length field * Fixed workaround for IE problem where onChange event is not triggered by cut and paste or autocomplete to input fields preventing change detection from saving the contents of custom data fields * Fixed when upgrade_go is run to distribute payments after an upgrade or data import the normal distribution rules ordering POS invoices last for CC/EFT auto-pay customers must be ignored so that redistribution is only done in chronological order * Fixed removed option to print payment receipt from the MBR payment menu for Credit Card and EFT transactions as no payment is available to print until the transaction is fully processed and has been approved these types must be printed from the MBR history menu or emailed via the approved batch transactions notice to automatically issue payment receipts * Fixed incidents associated with deleted services should not appear in incident search results * Fixed should scheduled invoice processing fail more specific cause information may be replaced with a generalized message appearing in the scheduled task log * Fixed security and configuration reload when clicking 'Apply' in the Emerald admin may display an error message but still appear besides a green checkbox * Fixed tab orders in post payments form not properly ordered * Fixed failed transactions associated with inactive MBRs should not be displayed in the failed transaction report * Fixed warning should be logged if the global batch lock transaction commit fails * Fixed starting and ending availability settings for service types are not saved when a service type is updated * Fixed daily payments report now presents adjusted payment totals separately. Previously total summaries were calculated incorrectly in the case where a payment amount was changed during periods not covered by the report * Fixed MBRs having a temporary cancellation status should be excluded from automatic deactivation * Fixed updating service information associated with change of recurring package type may fail while the packages extension field is blank * Fixed recurring revenue forecast report should not include services with a cancellation date prior to the reporting period * Fixed avs transaction information may not be sent with credit card transactions processed using the NELiX TransaX gateway Emerald 5.0.67 - 1/11/2010 -- * Added export system remove periods from keys of url encoded response allowing variable names to be referenced * Added allow theme selection for customers visiting the customer center at the billing group level * Added bind failure messages for web listener have been improved to be more specific * Added reporting option to control automatic closing of reports when not in focus * Added allow rated usage charges to be applied earlier than start of services next billing month in cases where the MBR or service has been canceled * Added unsynced history checking before applying late fees if MBRs current balance is zero or credit do not generate late fees even if associated line items are unpaid * Fixed web server rx/tx operations must be aware of anti-dos async connection closures to prevent rare probability of interference with unrelated connections in event of rapid socket reuse * Fixed improved compatibility with RIM Blackberry devices using OS version 4.6 and earlier * Fixed custom data field search results should contain matches only for active or inactive accounts * Fixed AV possible copying SQL message state for display of database related error messages * Fixed collision check warnings may prevent rollup of some usage charges with large amounts over ~20000 * Fixed initial invoice created during signup where a non-recurring invoice is created for a service type the service types AccountTypeID is not set at the invoice line item level * Fixed if the MBR active status field has been disabled from the billing group visible field options an error message is displayed when saving new MBRs * Fixed corrected ordering of html elements within header sections of the signup server and customer account center * Fixed canceled MBRs should not be included in the expired accounts report Emerald 5.0.66 - 11/10/2009 -- * Added service type setting to schedule inactivation of canceled services within an active MBR * Added support for display of IPv6 prefix attributes via the services RADIUS / Auth test menu * Added improved detail for invoice over commit messages * Added rating engine support for dynamic costing of data rates in time dimension * Added revenue by service type report can now be filtered by region * Added operator email address can now be used as a login to access Emerald operator interface * Added generic web service export system to synchronize Emerald account information via user provided web service request * Fixed change of service and closing service credit calculation have been improved to mirror invoice costs * Fixed export system status matching of less than greater than was reversed * Fixed AV possible in export systems using an export template that does not define all variables referenced in the template * Fixed display of currency figures using the currency format specifier to round to two decimal places may not follow asymmetric rounding rules in all cases * Fixed control symbols visible throughout the Emerald client UI when the firefox web browser is used * Fixed table of results presented when the Emerald Admin / Database / SQL Query menu is used should escape any html formatted data output * Fixed customer settings option to disable purchase time menu in the customer center when one or more one-time charges have customer access enabled was ignored * Fixed when services assigned to packages have been canceled and the cancellation date has passed the canceled service should no longer count against the packaged maximum * Fixed should void invoice fail template processing was not canceled * Fixed canceled services should not be included in the expired accounts report * Fixed revenue by service type report should not include unprocessed invoices * Fixed correct instances of mistyped case of column labels for case sensitive databases * Fixed fractional cent over commit warnings when running payment distribution for inconsistent (imported) invoice data * Fixed Imail user configured preferences such as calendar display settings were not stored within Emerald * Fixed packages should not be billed after the only associated services have all been canceled * Fixed applying payment to one-time charge invoice items leading to recharging of time data and or expire fails with a null billed thru date error when the expiration field is left blank * Fixed when voiding invoices having a balance forward cycle type the expiration field should be cleared when updating service billed thru date * Fixed closing MBRs where all invoiced service types have prorate closing service option of "unused months" rarely not all invoices eligible to be automatically voided are voided * Fixed group concurrency control configured on the Oracle platform results in database error being displayed during group concurrent access checking * Fixed forecast report shows invalid quantity information for accounts having pay periods based on a count of days instead of months * Fixed invoiced GL report incorrectly reported adjusted invoice entries based on payment status of adjusted entries rather than reporting only invoice activity Emerald 5.0.65 - 9/10/2009 -- * Added ODBC version 3 is now requested on all applications to workaround Oracle ODBC driver connection handle bug on some Linux platforms * Added include fax phone fields in MBR phone search criteria when substring phone number searching is enabled * Added eight additional cash payment types for processing custom payment methods * Added allow zero cost authorize only batch transactions to be submitted for customer validation purposes even when a minimum transaction limit is enabled * Added dictionary attribute type of IPv6 Prefix now supported via RADIUS dictionary attribute editor * Added statement triggering option to prevent new payment activity from directly triggering statement creation * Added support for beanstream realtime credit card processing gateway * Fixed blank matched data fields during RADIUS log search matching deleted services for operators with global MBR access * Fixed RADIUS log search results present a login search hyperlink which may not include the full login username contained in search results * Fixed relaxed incorrect export system transaction response processing requirement validation when processing credit transactions * Fixed if there is a database related error uploading binary files to the database the error message presented may not be descriptive * Fixed domain metarule validation incorrectly included constraint checking of login rules * Fixed options to add new package to existing MBR may not be visible if the package is made available exclusively via service group membership * Fixed new signups on the Oracle platform may sometimes schedule and run batch processing for new MBRs before there are any transactions available to process * Fixed service expiration customer notice may trigger two days earlier than configured * Fixed SSL CA certificate configuration on Linux platform is ignored using global defaults unless configured from the listener settings menu Emerald 5.0.64 - 7/23/2009 -- * Added options enabling display of currency codes from the organization level for operator client UI, reporting and customer center * Added recently failed transactions are now displayed from the account status dialouge with options to update card information on file or make a new payment * Added while a customer with CC Auto Pay enabled updates their card on file from the customer center and the lastest card transaction has recently failed it can now be automatically voided when the customers card account information is updated * Added customer center card account update can now trigger scheduling of a batch export for the customers MBR * Added RADIUS disconnect messaging from the users online list and session manager now support optional sending of Framed-Address and NAS-Port-DNIS * Added automatic void accounting menu setting for CC/EFT transactions of accounts having zero or credit balance * Added recurring revenue forecast detail report showing per day invoicing forecast * Added sort service and MBR custom data fields having selection lists alphabetically by their list of values * Added introductory offers now supported at the package level * Added set default values for new packaged service associations when configuring new package types * Added improved theme folder inheritance system to search underscore delimited paths. For example a theme labled group_subgroup causes a search using the following folder order 'group_subgroup', 'group' , 'default' * Added emerweb radlogin function can now send the framedip attribute as a request parameter * Fixed cPanel web service synchronization did not set cplan values when changing between service types * Fixed auth address and auth name fields not sent properly to the viaWARP credit card processing gateway * Fixed changed label of service type related field validation errors from 'account type' to 'service type' * Fixed unable to void transactions awaiting import from the billing menu for batch file based CC/EFT batch processors * Fixed signup server package selection display did not use sort order of one-time charges associated with a package as a secondary sort * Fixed introductory offer configuration for service types was not saved when its configuration is updated * Fixed AV when displaying the results of queries returning date formatted data when no operator context is available * Fixed anniversary period aligned cycle types with pay periods larger than one month may incorrectly bill for a single month when the manual invoice next option is used Emerald 5.0.63 - 6/17/2009 -- * Added support for viaWARP realtime credit card processing gateway * Added service expiration notices can now be configured on a per billing group basis * Added MBR option to to hold new CC/EFT payment creation until the holding date has passed for customers on CC/EFT auto pay * Added billing cycle setting to control creation of CC/EFT auto transactions independent of the EFT/CC Bill Days setting * Added send bill for services created via the signup server now default to the service types send bill setting * Added service template option to allow custom changes to accounts created via the signup server directly before the account is invoiced * Added new signup form variable prefix "SP_" enabling variables containing the prefix to be passed unconditionally throughout the signup process * Added IE8 browser compatibility * Added export system parser to extract data from HTML pages with form fields * Added inline support for license checking ews template commands * Fixed AV when verifying operator credentials and password unavailable * Fixed possibility of the wrong meta rule being applied to validate input form data * Fixed billing day field was not shown when enabled in the billing group for MBRs with a period-aligned anniversary billing cycle * Fixed crediting existing CC/EFT payments from the MBR history menu should not allow entry of a negative credit amount * Fixed service expiration notices should not be sent after the service cancellation date has passed * Fixed when adding a new MBR from the operator interface the sales person in the service form does not inherit the sales person selected from the MBR form * Fixed summary template command now assumes numeric type for average function on non timestamp fields and assume integer type when the count function is used * Fixed export errors when synchronizing with cpanel hosting control panel Emerald 5.0.62 - 5/21/2009 -- * Added anniversary accounts billing day can now be changed from the 'Edit MBR' menu. Requires 'Billing Day' visibility setting to be enabled within the billing group * Added users language preference can now be configured from the 'Edit MBR' menu. Requires 'Language' visibility setting to be enabled within the billing group * Added invoiced GL summary report to show charge summaries by GL cateogory * Added emerweb function 'lineinput' used to import the contents of a list of items with acceptable character filtering into an emerweb table structure * Added SMTP configuration option to disable 8-BITMIME option from being set when sending outgoing messages. Not recommended for non-latin based alphabets * Added prohibit negotiation of certain weak ciphers for Emerald SSLv3/TLSv1 sessions allowing the system to pass overzealous (cipher suites are always securly negotiated) compliance scans * Added rating system option allowing authentication to be rejected when a default cost is not configured and there are no matching rating rules for the given authorization parameters * Added external system synchronization for VOP/ModusMail by synchronizing Emerald account information with the VOPMail table schema * Added when rating RADIUS accounting data count both upload and download byte counts rather than download only for all data usage calculations * Fixed listing of avaliable service types in the accounts service menu was too restrictive. It may not have included service types assigned specifically to billing groups to which a non global operator was allowed access * Fixed minor display problem possible with some web browsers when displaying the status of changes made to a customers notification preferences * Fixed error message displayed in certain cases when creating new external systems based on external web service provisioning * Fixed prevent binary contents of forms using the emerweb update function from being changed when new binary data is not uploaded when the form is saved * Fixed compatibility problem when using SMTP authentication with CRAM-MD5 for outgoing email messages to some email servers * Fixed period aligned anniversary billing cycle did not properly align with other services in the same MBR sharing a common pay period * Fixed error message displayed when attempting to apply a payment using a prepaid card with an amount greater than the remaining balance of the card incorrectly displays the MBRs credit limit as the cards remaining balance * Fixed unlikely AV when a rating data source is processed from the Emerald UI and the system is not licensed to use rating features * Fixed when sending email notices filter characters forming the emails name field that can cause the delivery of messages to fail with some email systems * Fixed database error on case sensitive databases when upgrading the stored procedures ErrorHistory and ESEnom used by the daily error summary report and ENom domain service synchronization * Fixed daily error summary report restricted search for 'MBR /w Email send method has no Email' to exclude all canceled MBRs rather than excluding only those canceled accounts with a cancel date in the past * Fixed when accessing send method fees for postal delivery the associated charge adjustment was not created with the flag to inhibit itself from triggering creation of interim invoices * Fixed corrected error in the use of Emerald managed IP Pools on the ORACLE database platform * Fixed direct use one-time accounts created by logging on with the credentials of a prepaid card having a prepaid balance to be distributed to the MBR was incorrectly applied as a charge rather than a credit * Fixed external system web service provisioning sync for data updated via the Aux6 transition type was incorrectly posted to the Aux7 field * Fixed when synchronizing Everyone.Net forwarding information the empty value '' is now used rather than '""' to prevent mail forwards change sync from failing Emerald 5.0.61 - 2/22/2009 -- * Added replaced multipart request parser and a new binary data meta rule to better support binary data * Added geodistance emerweb function to find distance between two lat/long points in decimal degrees * Added operator preferences to select metric and imperial units of measure * Added upgraded SSL support libraries used to provide HTTPS access to Emerald and RADIUS EAP-PEAP/EAP-TTLS protocol support * Added selection list report search fields for regions, incident types, incident states, service types and package types * Added reporting data fields for ews reporting: SalesPersonID, AccountTypeID, PackageTypeID, ChargeTypeID, IncidentTypeID, IncidentStateID, ServerGroupID, RegionID * Added support for SecureNet realtime ACH processing gateway * Added when no default sales person is assigned to a signup server the sales person associated to the signup operator will now be used to set sales person for new signups * Added card accountid search field to the prepaid card account search form * Added when making one time purchases via the customer center and only a single option for purchase is avaliable set its quantity to 1 by default * Added service type configuration options to independently choose between daily or monthly replenish of time left and data left limits * Added configuration option to enable or disable invoice void chronological order enforcement for recurring invoices to accounting settings menu. Disabling this feature is not recommended * Added changed calls trigger to debit data usage from service data left field based on sum of input and output bytes where previously only output bytes were used * Fixed transaction error displayed when applying credits to a SecureNet credit card processing gateway * Fixed custom footer in customer center should not be presented when custom header was not also displayed * Fixed hide operator hyperlinks with a negative sort order * Fixed error displayed when manually adding a new table via the meta table editor from advanced options * Fixed when multiple rating rule sets have been defined with the voice destination rating type - destination rates specific to other rule sets should not be displayed * Fixed when configuring file based external system exports the option to configure export file overwrite vs append behavior were not avaliable * Fixed send method charges were not being assessed when an invoice or statement print batch has been marked as sent * Fixed churn report now supported on Oracle platform and improved accuracy for MBRs having been canceled and reopened more than once over their lifetimes * Fixed DD variable used to set current day of month when generating an export file from the export system was instead reflecting day of week Emerald 5.0.60 - 12/24/2008 -- * Added support for IP Pay realtime credit card and ACH processing gateway * Added SMTP authentication (CRAM-MD5 and LOGIN) when sending email messages thru an SMTP server from Emerald * Added checking to prevent operators from crediting CC/EFT transactions when the MBR is on auto bill and the amount of the credit would lead to a positive balance * Added configurable operator role incident assignment strategy. Currently avaliable options include unfair distribution based on count of each operators of open incidents or fair round-robin distribution * Added change conflict detection for standard incident fields when updating an existing incident * Added notification for missing CC/EFT data when CC/EFT automatic billing is enabled for an MBR via the daily error summary * Added session manager can now disconnect all balance based concurrent sessions within an MBR when their current combined usage exceeds the MBR credit limit in a single pass * Added allow subsequent SSL connections to Emerald web server to choose different protocol versions and ciphers * Added export system support for size limiting evaluated constants for web service requests * Fixed automatic rebatch options configured with the batch processor for failed transactions created automatically via auto bill have no effect * Fixed early checking to prevent new automatic transactions from being created when there is incomplete CC/EFT data avaliable to process * Fixed session manager over limit disconnect determination may reflect DA error when balance limited concurrent sessions from same account are calculated for complex rates with change points based on time of day or aggregate usage * Fixed session manager memory leak when disconnecting sessions * Fixed broken hyperlink when voiding a pending CC/EFT credit transaction from the MBR history menu * Fixed MBR history menu display may display a duplicate entry for the same payment * Fixed javascript warning when login fields are disabled via the signup server contact form * Fixed deadlock on MSSQL and Sybase platforms when using the payment import file feature from the billing / post payments menu * Fixed signup server account creation transaction should fail if the CC card type / card length process does not complete successfully * Fixed make sure both service last modify date and last modify user are updated when closing an MBRs service * Fixed avaliable incident type listing shown in the incident search form should exclude types associated to a specific billing group where the operator does not have MBR access * Fixed when doing an account simple search with the Normal checkbox unchecked a blank screen is displayed instead of search results on the Oracle platform * Fixed rating engine memory leak when reconfiguring active rating rules and a custom classifier query has been associated with a rate Emerald 5.0.59 - 11/22/2008 -- * Added callerid and error type selections when searching RADIUS failure logs from the Emerald reports menu * Added create date in operator service display also shows the operator who created the service * Added bulk email recipient list can now be restricted by region * Added login and passwords fields in the signup server contact form can now be hidden or marked optional * Added multiple packages can now be assigned to individual signup servers, previously only all avaliable or a single package was avaliable for assignment * Added when configuring CC/ACH batch processors system specific labels are now displayed rather than internal generic labels such as Login and Password * Added support for FirstData PayPoint realtime credit card and ACH processing gateway * Added Transaction Central support of credits and voids for realtime credit card and ACH transactions * Added export system support for wildcard server certificates * Added RadiusNT/X advanced menu option to enable WISPr-Session data limit VSAs for NAS enforcement of data left restrictions * Added EmerAuth support for Imail 10 for listing emerald accounts from the Imail admin UI * Fixed receipt of accounting stop records with no input or output byte statistics may cause the services data left field to blank out when data banking is enabled (Does not effect rating system) * Fixed MBR recurring service listing for packages with services assigned to them may show the first service pay period rather than the package pay period if service pay period is not synchronized with package * Fixed commissions report now uses the MBRs sales person for any line items that cannot be directly associated to an individual service or package sales person * Fixed when an account has been canceled as of a past date and an adjustment not yet applied to an invoice exists the interim look-ahead hold period should not apply * Fixed error adding new custom reports from the admin report groups on the Oracle platform * Fixed when rating requests containing usage for both time and data dimensions data only rates previously required a dummy zero cost time rate to prevent the data only rate from being ignored * Fixed operators with restricted billing group access may not see all failed CC/ACH transactions avaliable to them from the billing / failed transactions menu * Fixed provide 405 response to web server HEAD method requests for dynamic content rather than blocking them * Fixed EmerAuth administrator not installed as a service when the EmerAuth optional component is selected from the Emerald installer Emerald 5.0.58 - 10/25/2008 -- * Added hyperlinks to asscociated MBRs from the billing / credit card and bank trans menus when previewing a batch export * Added when changing an incidents type, custom data values are preserved for custom data fields in the destination type labled the same as custom fields in the source type * Added row at the end of the global aging report showing amount totals for each aging bucket * Added four additional auxiliary transition types for external system synchronization * Added RADIUS attribute types for octets, integer64, tag_tunnelpw and tunnelpw * Added notice to send daily summary of operators open incidents and allow notice type queries to specify OperatorID in lieu of CustomerID/AccountID * Added summary emerweb function to apply grouped results for min, max, avg, sum and count against an internal query similiar to SQL aggregate functions * Added calendar emerweb function to render a month calendar for reference and scheduling * Added httpget emerweb function to post requests to a remote server and process the response in urlencoded, xml, ini and raw formats * Added scheduled log trimming now also trims expired one time tasks from scheduling and log tables * Added mail aliases provisioning for the Everyone.Net external system * Added eNom external system for provisioning new domains and renewing currently registered domains with eNom * Fixed when showing incident actions from the customer center for an incident with customer access enabled only actions created with customer access checked should be displayed * Fixed minutes displayed in the online session report is not accurate when viewed by an operator without global MBR access to all billing groups * Fixed cumulative monthly tax types calculated against recurring line items billed for dates starting and ending in the same month may not be applied * Fixed recently added fields were not copied when an export configuration for CC/EFT and provisioning is duplicated using ExportCopy * Fixed when rating external VoiceCalls CDR table using the built in voice calls rating source results may not be commited to the database * Fixed modifying an MBR assigned to a billing group having since been disabled results in the MBRs billing group being changed when the MBR is saved Emerald 5.0.57 - 9/20/2008 -- * Added checks to prevent operators from submitting more than one pending credit against an existing credit card transaction * Added credit card and scheduler related alerts to the daily error summary and reordered alerts so that the more important messages are displayed first * Added allow operators to search incidents assigned specifically to other operators sharing common roles or all operators based on search incident assignment operator group rights * Added enable incident assignment for operators within roles where target/max open incident loads have not been defined * Added phone number search option in web interface / client settings menu to enable slower but thorough pattern matching of entered phone numbers against MBRs and additional address fields * Added support for external linking to specific Packages (pkg.ews?PackageID=x) * Added client side validation support for domain name acceptable character rules * Added when an operator session is established via HTTPS Emerald assigned cookies are marked to prevent them from being used via HTTP in the future * Added improved compatibility with some debian based x64 Linux distributions * Fixed configured operator home page incident listing should not show open incidents for accounts that have since been removed * Fixed floor and ceiling values shown in the admin / accounting / tax configuartion summary display were transposed * Fixed cumulative monthly tax type with a configured floor calculates an extra taxable month for recurring services with pay periods greater than one month * Fixed created operator name not set when creating a new adjustment within an MBR * Fixed Everyone.Net new domain provisioning and change of service type (offers) may fail to properly synchronize with the Everyone.Net web service * Fixed path column bind error reported when using the IIS export synchronization to provision IIS services * Fixed when distributing credits to invoice line items in cases where the credit amount has already been distributed and later revoked due to prior invoice voids the full amount of the credit may not be fully applied to avaliable line items until verify invoices is run Emerald 5.0.56 - 8/20/2008 -- * Added simplify service expiration warning notice parameters * Added support for ANZ eGate realtime credit card processing gateway * Added when removing an operator from an existing incident role a dialouge to reassign any of the operators existing open incidents is displayed * Added incident templating feature enabling incident type specific configuration throughout the operator and customer interfaces * Added allow custom messages to be displayed in the customer center change password form via the theme file custom_cust_passwd.ews * Added reset last modify user and last modify date fields when deleting an MBR * Added emerauth serv-u integration has been updated to support 6.x API version * Fixed failed batch transactions notice did not notify end user on CC/EFT processing failures in most cases * Fixed prevent unecessary void and reinvoicing when canceling service types configured to not calculate credit pro-rate on service cancellation * Fixed intermittent SSL message authentication check failures or AV can occur with high numbers of concurrent SSL connections * Fixed automatic new statement creation can be held up by canceled serviced in an active state * Fixed allow select list emerweb function to be used in situations where no operator context is available * Fixed logging of messages to the Emerald audit table for message types having no description failed * Fixed when adding a range of addresses to the RADIUS managed pool a javascript validation error may be incorrectly displayed for certain valid range combinations Emerald 5.0.55 - 7/22/2008 -- * Added prevent POS payments from being ordered non chronologically for MBRs having a non CC/EFT payment type * Added commission detail report providing commission summaries at the MBR level by sales person * Added deferred revenue by GL summary report to show current deferred revenue * Added MBR history report is now sortable by column heading * Added allow four digit accuracy when creating adjustments or POS items for stored charge type amounts * Added changes in Emerald configured offers or service types and new domains are now synchronized to accounts provisioned via Everyone.net * Added option to hide the make payment menu item from the customer account center while the MBR has a zero or credit balance * Added sync procedure import configuration object enabling dynamic external system synchronization update procedure selection * Added type=word parameter to emerweb decode function to support inline word or phrase level substitutions * Added ungroup emerweb function now supports column prefix matching * Added service templating feature enabling service type specific configuration throughout operator, customer and signup interfaces * Added domain expiration field and the ability to sort by column to domain list * Fixed Static-IP reservations for MBRs or Services that have been deleted rather than inactivated may not be automatically returned to the address pool * Fixed when canceling an MBR from the customer account center clicking the cancel date calendar button results in a javascript error * Fixed clearing a non-operator user session from the active sessions listing may fail redirecting the operator to the operator home page * Fixed pay periods configured to be accessable only to a specific service type were still assignable to other services * Fixed synchronize last modify user field with the operator closing an MBR Emerald 5.0.54 - 6/12/2008 -- * Added export system import variable support for fixed width and delimited responses when processing CC/EFT or export transactions * Added support for Sage Payment Solutions realtime credit card processing gateway * Added assigned mail domain now displayed from the service detail screen * Added additional unescaped character exceptions when URL-Encoding data throughout Emerald for improved compatibility with systems which may not properly decode URL-Encoded data * Added upgraded SSL support libraries used to provide HTTPS access to Emerald and RADIUS EAP-PEAP/EAP-TTLS protocol support * Added substring matching of Login, Caller-ID and DNIS data within the call search report * Added commissions report was updated to reflect total adjusted monies paid over the reporting period separate from amounts invoiced * Added web server receive side improvements to better handle large amounts of received http request data * Added display void status for voided invoices shown via the MBR invoice detail display * Added MBR contact list report providing basic address and telephone contact information for active accounts * Added reduce RadiusNT/X and external system change synchronization overhead on large databases * Added static IP addresses can now be anchored to accounts from the RadiusNT/X managed IP pooling system * Added support for storage of encryption secret key via operating systems secure key store * Added customer settings option to hide display of avaliable credit from the customer account center billing information menu * Fixed when opening a new recurring account having an open pro-rate setting of 'full months' using a monthly billing cycle the pro-rated ending date is off by a day into the future * Fixed an error is displayed when adding a new non-packaged account from the manage accounts area of the end-users customer account center * Fixed cancel reasons configured with a negative sort order should be hidden from view while canceling an open account * Fixed custom data field labels displayed in the MBR edit form were not assigned to the CSS 'label' class * Fixed added workaround of firefox compatibility problem preventing rates and standard rating groups from being managed using the firefox browser * Fixed grandfathering of service group option inclusion throughout the admin UI preventing cases where existing configuration may not reflect the currently assigned service group * Fixed rating source attributes defined under the rating sources advanced menu option could not change or remove attributes added with labels containing non-alphanumeric characters * Fixed text alignment of the default themes service detail has been updated to match the alignment of the MBR detail display * Fixed when making one-time purchases from the end user customer account center package specific options should not be available for purchase if the MBRs package has no active services assigned to it * Fixed statement previews may incorrectly display additional items such as unprocessed or estimate invoices that do not appear on an actual account statement * Fixed statement preview should show starting date in the date column instead of invoice date for recurring invoice line items * Fixed controlled shutdown of the Emerald web server may fail on the UNIX platform if clients are still connected during shutdown * Fixed web server setting to disable SSL by setting the SSL Ports value to -1 was ignored * Fixed session manager fails to disconnect sessions when password field encryption is enabled in the Emerald database Emerald 5.0.53 - 5/9/2008 -- * Added dishonor payment option in case of EFT NSF or CC charge back * Added translation updates for all languages * Added changed expire coloring in simple and service account searches of recurring MBRs to match coloring rules of the MBR service listing * Fixed callerid search phone number lookup may take too long to complete on large databases * Fixed allow credit amount to be entered against an ACH payment from the history menu if the batch processor supports ACH credit * Fixed service custom data fields were ordered by name first instead of configured sort order * Fixed removed unecessary single day invoicing delay for non-usage based reseller invoices * Fixed reseller invoices configured to charge fractional amounts for partial months usage can sometimes be billed at the full months rate * Fixed if the allow custom charge type for adjustments accounting setting is disabled the last charge type avaliable when creating a new adjustment or POS invoice does not apply its default settings when selected Emerald 5.0.52 - 4/23/2008 -- * Added operator group rights preventing operators from choosing a preferred theme or language from the client options menu * Added external system synchronization messages are now included in the daily global sourced error summary report * Added RadiusNT/X DNIS checking rules have been modified so that DNIS groups only apply to service types with a DNIS group selected unless reverse DNIS checking is enabled * Added compatibility with Microsoft SQL Server 2008 while creating a new Emerald database * Added browser title displayed during end user signup can now be customized from the signup server configuration menu * Added MBR custom data fields can now be assigned to service groups * Added incident custom data fields with value lists referenced by incidents can now be removed from the incident type configuration menu * Added secondary setup charge for new accounts at the service type and package type levels * Added Custom Charge Type can now be removed from the type listing when creating an adjustment or adding POS invoice line items * Added changed automatic payment ordering to apply payment to recurring line items in chronological order before applying payment to outstanding POS invoices * Added domains can now be assigned to individual MBRs * Added new accounts added from the customer account center manage accounts menu can now choose from a list of avaliable domains when adding a new account * Fixed corrected minor rounding problem where the actual subtotal amount of invoice line items is rounded directly to two digits rather than rounded to 4 digits and then rounded to two digits matching displayed line item subtotal amounts * Fixed SMTP client has been updated to parse SMTP status response codes crossing packet boundaries * Fixed if the same notice is delivered to multiple recipients and delivery to all receipients fail the notice was added to actives anyway * Fixed after scheduling the external system synchronization from the external systems menu the operator is redirected to the operator home page * Fixed in rare cases unecessary pro-rates may be generated when invoicing recurring accounts with anniversary billing cycles * Fixed malformed web server post request may cause AV * Fixed final userexport synchronization summary counters displayed in scheduler execution log may not be accurate * Fixed when adding a note to an existing assistance request from the customer account center on the Oracle platform the additional note is not saved Emerald 5.0.51 - 3/27/2008 -- * Added Cisco Netflow V9 and IPFIX (RFC 5101) flow format support to the emernet collector * Added support for proxying Asterisk CDR data via Asterisk Manager API to RadiusNT/X for realtime CDR accounting * Added crystal reports activex print server control integration * Added allowed flow export host access control list to the emernet collector * Added custom_pkg_save.ews is now called from a package edit and a package add so custom code from custom_pkg_edit.ews can be processed during an add/edit. * Added enforce short term password lockouts for invalid accounts to prevent leaking valid account names * Added incident custom data fields can now be deleted even if they are currently referenced by an incident * Added custom queries can now be defined to populate the selection list of incident custom data fields * Added configurable client side regular expression field validation patterns and required status for MBR, service and incident custom data fields * Added allow login field parameter to be passed into the signup server contact form without being overwritten by the login field autofill feature * Added incident states can now be configured to apply only to actions within an existing incident * Fixed credit card expiration fields changed in the MBR edit form may revert to a previous value if a different country is selected after changing the expiration field * Fixed changing the amount of an existing check or cash payment from the MBR history menu fails only when the Oracle database platform is used with Emerald on the windows operating system * Fixed possibility of AV during garbage collection of operator sessions Emerald 5.0.50 - 2/11/2008 -- * Added scaling improvements to support large numbers of active accounts * Added enforce print batch limits for invoices and statements * Added current package status to MBR package display * Fixed when auto-voiding a CC/EFT realtime transaction due to permanent error or temporary error during task shutdown the void process may fail due to an unavaliable referenced transaction id * Fixed do not enforce task shutdown request during import phase of realtime transactions * Added support for USA ePay realtime credit card and ACH processing gateway * Added support for NELiX TransaX realtime credit card and ACH processing gateway * Added support for Protx realtime credit card processing gateway * Added rating engine options for voice sessions to include 60/30 and 30 second rounding * Added inactive batches shown in the prepaid batch menu are removed from the batch listing after two months * Added workaround for problem preventing Emerald web server service from shutting down using the SQL Native Client ODBC driver * Added license manager prepaid features * Added three sided conflict detection to MBR package configuration menu * Added primary service automatically updated for packaged services when moving between packages with different primary service types * Added hotkey navigation support for the oracle database platform * Fixed when voiding a pending transaction from the MBR history menu the user is redirected to the operator home page * Fixed when updating package settings the packages creation date and operator is reset * Fixed when voiding an invoice containing a recurring package line item - associated expiration and billed-thru information is not immediatly propagated to the packages services * Fixed when issuing a change of service credit for recurring services the resulting billed-thru date is off one day into the future * Fixed when applying service change credit adjustments the credited amounts were not immediatly avaliable to be distributed to subsequent invoices without clicking verify invoices Emerald 5.0.48 - 1/22/2008 -- * Added VoiceCalls table and datasource configuration for rating and displaying externally imported call records * Added invoice_cdr.ews and statement_cdr.ews reports to include CDR detail when the VoiceCalls table is used for Voice/VoIP rating * Added geographic updates for several countries * Added alternate coloring based on active status when searching accounts via the caller-id popup application * Added prevent unneeded package information from being displayed in the customer account center when a package is used exclusivly for providing customer access control * Added rating datasource configuration option to enable a re-rating procedure controlled from the Emerald Admin / Rating / Rating Datasources menu * Added signup options to enable collection of an alternate address during the end-user signup process * Fixed RadiusX database driver compatibility problem with Sybase ASE 15.0.2 or later on the Linux platform * Fixed automated product update fails refreshing procedures on the Sybase ASE platform * Fixed online session report does not limit view to only accounts within billing groups the operator is allowed access * Fixed display based table security checks failed to enforce all table + group access restrictions * Fixed malformed web server post request may cause AV * Fixed automated product update may fail on the Oracle platform depending on the configured database connection limit and other applications accessing Oracle * Fixed query error displayed while clearing online session status manually using the online report on the Oracle platform * Fixed provisioning of direct use prepaid accounts via RadiusNT/X first login may fail on the Oracle platform * Fixed no matching result warning displayed with search results when results are avaliable from the scheduler log search menu Emerald 5.0.46 - 12/28/2007 -- * Added SmarterMail email account provisioning via SmarterMail web service API * Added new check to the daily error summary report to display MBRs with an email send method who have no accounts configured to receive invoices and statements * Added workaround for IE7 browser problem on some systems where when generating a prepaid batch a blank screen is displayed * Added custom emerweb template custom_mbr_save.ews is now also run when saving changes to an existing MBR * Added Tropos RADIUS VSA attributes * Added operator audit logging to the Emerald administrator * Added trim options to the log trimming menu allowing after a period of time automatic removal of sensitive information from inactive or deleted MBRs and completed CC/EFT transactions * Added workaround for Oracle ODBC driver interfering with SSL operations on the Linux platform * Fixed Emerald admin UI Oracle updates to correct errors adding a new web url link and applying group level config setting defaults * Fixed update service last modify date when opening or closing a service * Fixed database error may be displayed when creating invoices for billing groups having the renewal move expiration strategy of proportional to payment * Fixed database error displayed when editing an MBR using Sybase ASE with a case sensitive character set * Fixed Emerald syslog server displays a database error on startup on the Oracle platform * Fixed cancellation date of an MBRs service is not enforced for RADIUS authentication unless expiration date is less than or equal to the service cancellation date * Fixed when manually adding a non bulk IP Address to an Emerald managed IP group a data validation error is displayed and the new address is not added to the group Emerald 5.0.44 - 11/23/2007 -- * Fixed call search report assumes input as default RDBMS date format for starting and ending search dates * Fixed javascript error noticed when applying a manual credit card payment from within an MBRs payment menu * Fixed end user signup fails when choosing the credit card pay method with a signup server configured to not request address information * Fixed rating engine AV when processing some configurations of realtime call records having no applicable rule sets * Added one time charge descriptions now included with initial package selection options displayed in the new customer signup process * Added default theme updates to support firefox version 3 * Added additional validation when assigning service types to package types via the package type configuration admin menu * Fixed validate all static length table elements to prevent memory overwrite * Fixed error processing credit transactions against previous payments with Authorize.NET in AIM mode * Added accounting settings to automatically close recurring renewal based MBRs after having been expired for a period of time * Added batch manager interface to the general admin menu enabling batch searching with option of resetting a batches print status Emerald 5.0.42 - 11/07/2007 -- * Fixed sortable tables displayed when there is no data avaliable lead to javascript error reported in the browser * Fixed after successfully scheduling a new notice the operator is taken to the operator home page rather than the scheduled task configuration dialouge * Fixed when signing up for a new account via the Emerald signup server no error handlers were assigned to verify credit card data for recurring billing was successfully recorded to the database * Fixed after upgrading from Emerald 4.5 the taxable MBR settings from 4.5 are not imported as tax exemptions in version 5 * Added package type listing in the Emerald Admin / Services menu are now sortable by clicking the columns description * Added account synchronization for CPanel provisioning control panel * Added account synchronization for DirectAdmin provisioning control panel * Added automatic voiding of failed auto bill CC and EFT transactions where new CC/EFT data is avaliable or manual payments are made * Added support for keyboard interfaced credit card readers enabling automatic (track 1) account lookup by credit card swipe or manual payment assisted by card swipe * Added scannable barcodes now displayed on invoice and statement reports * Added support for keyboard interfaced barcode readers to lookup invoices and statements via barcode scan and support for scanned payment posting from the Emerald billing menu Emerald 5.0.41 - 10/17/2007 -- * Fixed file not found error displayed while removing a tax associated to a tax group from the Admin / Accounting menu * Fixed possible AV when opening an account if there is a database connection error preventing the billing engine from loading * Added taxes can now be defined at the city and or postal code levels * Added tax type configuration providing logical groupings of tax rules so that only the most specific match within a group of like taxes is applicable * Added default character set of all outgoing email notifications are now unicode / utf-8 and require SMTP server support of the 8BITMIME ESMTP extension * Added allow batch processors to be assigned globally to all organizations and billing groups * Added reseller billing is now supported at the service and package level, previously services within a package were billed from the reseller billing pov as services * Added callerid search application will now pass credentials to new browser windows opened in a separate process if a session was not already established * Added price inclusive tax structures are now supported enabling disaggregation of the tax component of taxable one-time and recurring charges * Added display MBR current balance in payment import preview * Added prepaid card search options now avaliable from the Emerald client / Accounts / Prepaid Search menu * Added allow custom information to be displayed in the credit card payment form in the customer account center * Added support third party caller lookup URLs from the callerid search application if no matches to the calling number are avaliable Emerald 5.0.40 - 9/23/2007 -- * Fixed when running a bulk payment import from the billing payments menu no preview information is displayed and only the first item of the batch is imported * Added RadiusNT/X now supports RFC 4590 for SIP/HTTP Digest authentication * Added processing of multiple result sets for transactions processed through the export system * Added notice type to send contents of new incidents to those listed in the incidents email field * Added menu option under Emerald Admin / RADIUS / Auth Fail Attributes to provide customization of attributes sent during an authentication failure * Fixed when adding or changing RADIUS reject settings the operator is incorrectly redirected to the operator home page * Fixed page shown directly after operator login may not display correctly for non english translations * Added show notice log detail if avaliable in customer history * Fixed session manager based time left limit enforcement was not done for accounts not having a login limit defined * Added historical time and data left tracking enabling expiration of purchased prepaid time and data for one time charges and direct use prepaid cards * Fixed saving changes to an MBR package fails when the extension field is set to a empty value * Fixed when monthly time and data left updates are enabled services under MBRs assigned a non recurring billing cycle should not have their usage replenished * Fixed honor auth name and address field size restrictions when exporting CC transactions to an orbital paymentech gateway * Added when associating external systems to service types comment and external reference fields have been added * Added allow initial prepaid card direct use account setup to ignore the domain part of the login request * Added export system support for staging of multi-step provisioning tasks * Fixed scheduler AV when an error occurs obtaining a database lock for CC/EFT processing via the export system * Added account synchronization for WebHost Automations Helm provisioning control panel * Fixed when creating a new service the list of avaliable service types may contain duplicate entries * Added xmlinput emerweb function for processing external XML formatted data Emerald 5.0.39 - 9/3/2007 -- * Added improved included random batch card number sequence algorithms to make best use of avaliable number space * Added allow individual prepaid card batches to create up to 100k accounts from the previous limit of 1k * Fixed manual or periodic statements are prevented from being generated while there is no new invoice or payment activity * Fixed compatibility problems during new database install with sybase ASE 15 * Fixed prevent empty queries from being sent to the database for execution * Fixed global group settings in billing group configuration may not display the correct option status depending on the group avaliability of discounts * Added support for the Oracle database platform. Requires version 10g or later /w ODBC driver 10.02.00.03 or later * Added credit card expiration date is now also checked earlier via javascript throughout the operator and customer interfaces * Added workaround for Microsoft Internet explorer bug showing non secure content warning when using SSL with Emerald * Fixed when adding a new package through the operator interface the starting date is always today rather than the start date entered when the package is created * Fixed if multiple packages allowing the same service types are active in an account and a service of the same type is added to a package via the package interface the new service may not be assigned to the correct package * Fixed when changing passwords from the customer account center the last modify date and username are not set for the effected service * Fixed when using the Emerald voice rating UI static and bong charges may not be applied correctly to all prefix matches * Fixed when rating a record with multiple rates or a single rate with time and data rates static cost values may be applied to previously rated items * Added RadiusNT/X now supports EAP-TTLS with the TTLS authentication methods CHAP, PAP, MSCHAPv1 and MSCHAPv2 * Added configuration constraints to the Emerald voice rating UI * Fixed invoices may be created even when having no active invoice line items * Added support for localization of package name and customer description fields in the package type configuration * Added package type invoice and customer facing descriptions can now be set independantly of the package type label * Fixed allow MBRs with a zero credit limit to be included in the Overdue MBR advanced search results * Fixed when removing a roam server from the Emerald admin UI proxy attributes associated with other roam servers may also be removed * Fixed statement aging shows negative values for aging buckets containing credits * Fixed removed unusable global billing group option from the Accounts menu Simple, MBR and Service searches Emerald 5.0.37 - 7/31/2007 -- * Fixed new automatic credit card transactions are not checked for card expiration and marked as declined before being added to the transaction export queue * Fixed after canceling a service the termination reason described in the service detail view may not match the actual termination reason * Fixed when making a manual payment from the client operator interface masked credit card numbers are not accepted for payment * Fixed after reopening an MBR with an anniversary billing cycle that was previously closed the MBR billing day should reflect the opening starting date instead of the day the MBR was origionally created * Fixed AV when processing notices where no required from or subject data is avaliable * Fixed late payement fees were not being properly assessed based on statement aging * Fixed after successfully printing an invoice or statement batch from the print queue for postal mailing the print date on the effected invoices or statements was not set * Added prevent unsent invoices from being batch emailed or batch printed if they were created 45 days or more in the past * Fixed create statements menu showed pending CC/EFT transactions for accounts having been inactivated or deleted Emerald 5.0.36 - 7/12/2007 -- * Fixed show transactions awaiting import report should not display transaction warnings for deleted MBRs * Added upgrade invoice consistancy check procedure CheckInvoices can now adjust line items to match invoice amount on unknown cause when the mode parameter is 2 * Fixed reseller billing attempts to create duplicate invoices during a single invoicing run and correctly fails with a data consistancy error * Fixed informational messages from the emernet rating system should not be logged to disk unless the detail debug level is enabled * Added column headings of search results and data displays throughout emerald can now be sorted alphabetically or numerically * Fixed when forcing invoice next the invoice process should allow itself to be triggered by pending interim charges * Added current database activity display now shows blocked / blocking coloring if there are blocked processes * Added support for SecureNet realtime credit card processing gateway * Fixed invoicing may display a change conflict error when generating reseller invoices Emerald 5.0.35 - 6/27/2007 -- * Fixed default email field value when editing a service reflects the selected domains label rather than the domains DNS mail domain * Fixed when rating external data sources the StaticCost and InitialCost fields were not being honored if a rule set did not first upload them * Fixed rating engine IPv4 address range resolution error * Added removed support for SSLv2 from the Emerald web server. TLSv1 and SSLv3 are now the only encryption protocols supported * Added improved detail of SSL related error messages and prevent logging for some classes of expected connection related failure conditions * Fixed AV when canceling an account while there is an error validating the cancel request * Fixed replaced escape parser used for login and account search operations to prevent last character truncation * Fixed static tax amounts were not assigned to non-cumulative monthly tax types when invoiced for a single month or less * Added static tax amount prorate for non-cumulative monthly tax types of invoice line items covering less than a month * Added ability to target a different request URLs of the same protocol from the exports column editor * Added support for IntelliPay realtime credit card processing gateway * Added improved Show MBR field display for some types of MBR items that may not normally be configured * Added when configuring exports from the advanced menu all avaliable custom filters are now displayed in a selection list * Fixed advanced serviceless MBR search was displaying results for records that did not fit the proper critera Emerald 5.0.33 - 6/7/2007 -- * Fixed when editing an MBR within a country that does not support zipcodes a blank input box appears above the main MBR edit form * Fixed when adding a new service and selecting the cancel button at the bottom of the new service form an error message is displayed * Added support for full range of IPv4 CIDR prefixes to the rating engine * Fixed RADIUS server access configurations having a global service type selected where being ignored and allow configurations with no time of day specs were incorrectly treated as deny rules * Added Req/Resp code search source for RADIUS attribute filtering UI allowing matching of rules based on the request or response type of the RADIUS packet being processed * Fixed rating classifiers may incorrectly assume the MBRs billing day for MBRs assigned a non-anniversary billing cycle * Fixed service level call search report may not always display results in chronological order Emerald 5.0.32 - 5/23/2007 -- * Added new notice type to email payment receipts to customers who have made cash or check payments * Fixed IP access security if the administrator group allows all IP addresses access all other operator groups are granted the same access * Fixed radlogs search report showing duplicate results for operators having MBR Global access where there are not duplicate matching services * Added TLS certificate and host validation for transactions processed through export system * Fixed some classes of TLS handshake errors through the export system did not present a descriptive failure reason * Added when creating a new database if the query to retreieve an avaliable list of databases fails an input box is displayed for manual entry of database name * Added when adding an MBR assigned to a package a new services service type defaults to the primary service type for the selected package * Added include database owner information when creating a new Emerald 5 database on the Microsoft SQL and Sybase ASE platforms * Fixed when an account is invoiced for a future period under renewal billing where the previous invoice had not been paid if the previous invoice is paid and the latest invoice is not the expiration date of the service may not change to reflect payment of previous invoice * Added allow operators and sales persons to be removed from the system in cases where the operator being removed is still referenced * Added when an operator changes their theme the theme database is now also refreshed allowing operator theme selections to take effect without having to use "Apply" changes * Added incident ordering is now influenced by priority for open incidents and priority is now shown in incident search results * Added when creating a new account through the end user signup-server the payment options form is skipped provided the only avaliable payment option is renewal billing * Added show pending time and or data totals for realtime usage fees in the billing status display of the customer account center * Added log trimming option for FTP transfer log and better pruning of server ports to minimize the number of unused ports over time Emerald 5.0.31 - 5/9/2007 -- * Added emernet data collector now supports 802.1q VLAN tagged ethernet frames in packet capture mode * Fixed emernet data collector was not always reporting both send and receive sides of an IPv4 packet in packet capture mode * Fixed error message is displayed while creating a new MBR assigned to a package during MBR creation Emerald 5.0.30 - 4/27/2007 -- * Added additional updates to better support the security countermeasures feature introduced in Emerald 5.0.29 * Fixed when editing an existing prepaid batch type the login and password sequence select lists do not default to their current values * Fixed closing an active web session from the Admin / Web Interface / Active Sessions menu succeeds but incorrectly redirects the operator to home rather than displaying a success message * Fixed when a signup server is configured to assume all signups are in a specific country the states shown in the signup form are not correct when the billing groups country differ from the configured country in the signup server * Added default prepaid card login sequences now accept prepended characters via the login prefix field when generating a new prepaid batch * Added warning messages when making changes to prepaid card sequences managed by Emerald to prevent overwrite of custom settings * Fixed when voiding invoices, deleting accounts or assigning default RADIUS attributes you may be redirected to the operator home page rather than completeing the intended action * Added show destination rate description field when listing destination rates of rating rules having the voice destination rating type * Fixed upgrade of calls table may fail if a call record has a null nas-port value * Added support for external linking to specific MBRs, Services and Incidents (mbr.ews?CustomerID=x, sa.ews?AccountID=x, incident.ews?IncidentID=x) * Fixed tax payments report may not show tax values for periods where tax was paid however all tax values displayed were correct * Fixed when creating a new incident or changing an existing incident the assignment selection list shows only 'myself' when there may be other qualifying operator roles that should also be avaliable * Fixed when a customers recurring credit card information through the customer account center their existing credit card on file is displayed depending on encryption and group right security settings * Added allow customers with manager rights to change their recurring credit card information through the customer account center when the allow payment change customer website option is disabled * Fixed an account search for unpaid invoices in some cases includes paid invoices within the search results * Fixed avaliable package offerings for a signup server did not concider the signup servers group membership incorrectly allowing packages specific to other groups or service groups to be displayed as signup options * Fixed when opening an inactive MBR that was not previously canceled a change conflict error of 'MBR Opening update' is displayed * Added automatic transactions for MBRs on CC or EFT auto pay with a default pay period having confirm trans enabled are now created as having to be confirmed * Added postal code field is not displayed within operator and customer MBR and credit card interfaces for countries that do not use postal codes * Added when signing up for new service from the customer signup server using a credit card the required status of AVS and CVV2 fields can now be controlled from the Emerald Admin / Web Interface / Customer Settings menu * Added customer signup server required field coloring in the contact and payment areas using the style label_required * Added billing group options to hide printing of invoice and or statement from the Emerald billing / send bills menu * Added account status display from the customer account center now shows the total of any currently pending credit card or EFT transactions for customers with manager access to their MBR * Fixed when displayed selection lists throughout the Emerald UI contain no items a javascript error may occur when performing client side validation of form input * Added additional consistancy checking to the verify invoices menu option in the MBR invoicing menu * Added when upgrading to Emerald 5 from an Emerald 4.5 system previously upgraded from Emerald 2.5 common data inconsistancies in Emerald 2.5 data are automatically corrected * Fixed remove print receipt checkbox from the Emerald customer center make payments form as receipts are avaliable only after batch processing from the billing menu Emerald 5.0.29 - 4/4/2007 -- * Added improved layout of the POS invoice line item form * Added customer account center option allowing customers to change their accounts login name * Fixed crystal reports "configuration error" displayed when emerald is installed in a folder containing spaces in its pathname * Fixed when a prepaid card direct use MBR and service are created the default remote access privilege should be 'manager' rather than 'service' * Added support for "bytes left" similiar to the "time left" fields used to enforce data usage based access limits * Fixed additional filtering in the Emerald customer center to keep customers from purchasing time/data options that would have no effect on their accounts due to incorrectly configured one-time charges * Fixed application of payment against one-time charges may result in an error causing the payment operation to fail * Added time and data limit values in the Account Status display of the Emerald Customer center are now updated in realtime during active RADIUS sessions * Fixed incorrect service type default limits may apply when creating new accounts via the signup server * Fixed when using the rule matching status field when rating external data a static per session cost should count as a match while default rule matching is disabled * Added included updated windows packet capture driver with EmerNet * Fixed while configuring server port access deny rules a javascript error may be displayed and the deny selection option may not be stored when saved * Added reverse ordering and inactive coloring for disabled service types and domains * Added new export system synchronization capabilities enabling complex network and web service based provisioning * Added support for Everyone.Net email hosting provider * Added per account external sync errors are now displayed in the services account detail summary * Added domains can now participate in service groups and new external reference fields for domains * Added external system type specific custom parameter fields * Fixed existing discounts, sales persons and pay periods are not defaulted in the selection listing when editing a service where the current item has been disabled from the admin menu * Fixed small memory leak in template based credit card processors and external export system * Added emerald customer center prepaid card recharge feature allowing direct use based recharge of existing accounts * Added per RADIUS client disconnect attribute settings allowing attributes sent to be enabled or disabled on a per client basis * Added support for sending Called-Station-ID attribute in disconnect messages initiated from the Emerald online list * Fixed when disconnecting a session from the Emerald online list disconnect failure messages may not always be displayed when avaliable * Fixed crystal reports printed through Emerald may produce an error or not display properly if the database name stored in the report does not match the name of the Emerald database * Added replaced emerweb deferred memory queue with reference tracking system to better detect errors * Added access logging improvements when a large number of operators are using Emerald at the same time * Added updated french language translation * Added when configuring external rating datasources from the Admin / Rating / Data Sources menu a new "billing mode" option toggles logging of rating results to Rate History * Fixed printable payment receipt is not displayed when applying a payment with the print receipt option selected * Fixed when using the bulk email option to send messages the entire contents of the message may not be included in outgoing emails * Fixed current balance displayed in the MBR detail is not updated when changes are made to an inactive accounts balance such as making a payment * Fixed Point-of-Sale and Adjustment MBR menu items must not be avaliable to inactive MBRs * Fixed MBRs having a cycle type of non-recurring should not dynamically update account expiration based on recurring rules * Fixed when signing up for new service using the signup server having a package type of non recurring with one-time charge for the initial purchase some service type default settings must be ignored based on the one time charge configuration * Added continually refresh Emerald customer center account status display while accounts have run out of time or data to reflect realtime status changes * Fixed when login changing is allowed customers should still not be able to change their login to a blank value from the manage accounts / change account login area in the Emerald customer center * Added credit transaction support and improved response messages for the paymentech orbital batch processor * Fixed license feature enforcement error messages were not being displayed * Added security countermeasures for client initiated requests initiated by links from external domains * Added Emerald database can now be backed up on a recurring or one time basis from the Admin / Database / Backup Emerald link when using the MSSQL database platform * Added when adding a new MBR from the Emerald client interface CC or EFT entry forms are displayed automatically when the new MBR has a payment type of CC or EFT * Fixed rating engine AV when processing external datasources with numeric rating rules having a "less than" match type * Added when rating data using the custom datasources rating menu StaticCost and InitialCost can now be specified in the rating request result set in addition to rating upload attributes * Added Voice Destination Rating type enabling DNIS specific rating and easier import of rate tables * Added allow signup server to be used when Emerald is not licensed for billing features * Fixed when searching for an incident by IncidentID and other search critera is defined that critera should not be concidered Emerald 5.0.28 - 3/14/2007 -- * Fixed email notices configured from the Admin / General / Notices menu may show the 'Schedule' option even after that notice has already been scheduled. Also when scheduling a notice from this menu the default notice type is incorrect and must be manually changed to 'tasknotices' * Fixed default credit limit and one time setup extensions are not set while creating a new MBR from the Emerald client interface * Added missing "Renewal move expiration forward strategy" and amount fields to the Admin / Accounting / Settings menu * Added support for moving expiration date forward proportional on a days scale to amount paid * Added support for requiring full payment before expiration is moved forward * Added in some cases the service expiration date can be rolled back when voiding invoices * Fixed application of invoice line item payments was ordered by invoice number rather than invoice creation date Emerald 5.0.27 - 3/9/2007 -- * Fixed payment distribution for credit adjustment amounts assumed a quantity of 1 when distributing payments to invoice line items * Fixed Credit Card or EFT payments applied to a specific invoice was not distributing the payment amount to the invoice before distributing the remaining payment amounts to invoce line items in reverse chronological order * Added allow custom cash payment types (Other #1 and Other #2) to modify the value of existing payments from the MBR history menu * Fixed insufficient precision in fractional rounding during invoice related billing processes (.499... rounds up rather than down in some cases) * Fixed recurring end date calculation on the Linux platform may be off by a day if the calculation covers a change in daylight savings time status * Fixed payments report payment type totals display did not properly concider change in payment amounts over time * Added card transaction type is now displayed in the credit card export preview display * Fixed typo in buttons_sa.ews theme file that may cause MBR service menu to display incorrectly with some language translations * Fixed customer account center should not show invoices that have not been processed such as POS estimates * Added notice to notify operators when incidents assigned to them have been updated with new actions * Added include local RADIUS server client entry by default to allow RADIUS settings update from admin 'apply' button * Fixed rating no data rules are loaded if there are no time rules assigned to a rate source Emerald 5.0.26 - 2/25/2007 -- * Fixed package type global option cannot be changed from the admin / general / billing groups menu * Fixed loop while invoicing customers with tax configurations having the monthly cumulative type * Fixed duplicate login checking via the service edit form should ignore deleted accounts * Fixed many ews formatted custom reports included with Emerald do not display data when a specific billing group is selected with the report parameter options * Fixed incident searching with assignment option of 'to me' or 'Created by me' did not properly restrict incidents to the operator performing the incident search * Fixed when upgrading from Emerald 4.5 credit card type information is not calculated for Emerald 5 requiring the 'Any' card type to be checked in the batch processor configuration to process automatic card transactions * Added credit limit field is now always accessable via the edit MBR form regardless of weather the MBR has a balance forward or renewal billing cycle * Fixed database upgrade process from Emerald 4.5 fails for previous configurations of custom MBR and service data where one or more accounts have multiple values for the same attribute * Fixed free service and free MBR advanced search options were incorrectly showing accounts having a non-zero recurring cost * Fixed when rating charges for a month and user that has already had charges applied an error may be displayed when rating data covering the previously billed month * Fixed revenue by service type custom report displays incorrect or no results * Added MatchStatus row update variable for rating data sources allows determination of weather any rule sets with no default value (cost < 0) have matched * Added ability to treat non-processed POS invoices not marked as estimates similiar to estimates so that they can be processed in the future * Added EmerAuth support for Imail 2006.2 * Fixed when making a payment from the MBR menu the currently selected payment types options may not reflect that type if the default payment type sort orders have been changed * Fixed EmerAuth admin "invalid license key" error message is displayed when saving settings with a valid license key * Added support for two user definable cash oriented payment types * Added feature updating avaliable payment types via the admin / accounting menu allowing type descriptions, GL Codes and sort orders to be customized * Added default new MBR credit limit can now be set on a global or per billing group basis for balance forward accounts via the admin / accounting / settings menu * Fixed when enforcement of cost base session limits are enabled and the rate assigned to an account is a data only rate configured for session limiting the authentication request should be rejected when the avaliable realtime credit limit has been exceeded Emerald 5.0.25 - 2/11/2007 -- * Fixed when adding a new MBR after the Region option has been removed from the new MBR form via the billing groups menu an error is displayed. This can be fixed in current versions by going into the Admin / Advanced/ Meta Tables menu. Choose the numbered link for 'MasterAccounts', Choose 'RegionID', set nullable to 'Yes'. After updating the form click the apply button for the change to take effect. * Added support for IPWireless RADIUS VSA dictionary * Fixed custom data may be displayed at the MBR or Service level that is marked not visible by the data field configuration. (See Admin / Advanced / Acct Data Fields) * Fixed error displayed when adding IP Security entries from the Admin / Security / Operator Groups menu. This can be worked around in current versions by using the Admin / Security / IP Security menu. * Fixed removed Domains from service group Include/Exclude configuration as Domains cannot participate in service groups * Added emerauth NTMail/Gordono Mail data format update for listing accounts within a domain * Fixed prorate options for package types did not appear in the admin package type configuration * Added database upgrade process and verify invoices now creates charge for all credit line items not already having an assigned charge * Fixed when upgrading from Emerald 4.5 remove ServerID from call records where the specified server no longer exists * Fixed while exporting credit card transactions to a batch file the error "external trans update failed" is displayed * Fixed current status of scheduled tasks may sometimes not update upon completion of a task as shown in the scheduler current activity display * Fixed reduced scheduler status window stay after successful task completion * Added support for transaction type sections when configuring an export template from the Admin / Advanced / Export menu * Added support for the Linux platform * Fixed loop when calculating prorate for future cancelations that effect services not yet billed in combinations of months and days in advance * Fixed when voiding cc or ach transactions that are awaiting batch import an error was displayed * Fixed invoices and statements were showing in the send bills summary display which should have been excluded by the "print 0 balance or credit" invoice and statement rules * Added initial support for sybase ASE 15.0 or later and updates to support case sensitive databases. Note: the "ddl in tran" option must be enabled on tempdb and we recommend utf8 as the servers default character set * Added it is now possible to mark invoices as having been sent similiar to the statement mark sent option * Fixed sent date display in invoices and statements now take into account any avaliable print and or email dates * Fixed improved bill day recalculation when upgrading from Emerald 4.5 Emerald 5.0.24 - 1/20/2007 -- * Fixed missing routing and auth name for manual ACH transactions * Fixed pending ACH transaction listing in billing menu does not correctly display bank number when data encryption is enabled * Fixed Auth.Net support for Void, Credit and Auth Capture * Added support for Transaction Central realtime credit card and ACH/EFT processing gateway * Fixed balance forward billing with credit limit exceeded should continue to invoice recurring services as did Emerald 4.5 * Fixed default billing cycle options included with new Emerald 5 installations were very confusing * Added support for multiple web server bind addresses with independent HTTP(S) listen port and certificate settings * Added support for PayPal's (formerly Verisign) Payflow Pro Credit Card and ACH/EFT processing gateway * Fixed error displayed after deleteing a credit card import column in the advanced options exports editor * Added limit ACH/EFT credits to the entire amount of the ECheck * Added support for case sensitive databases * Added workaround for IE7 print rendering bug in default statement report preventing the bottom portion from being displayed on all but the last statement when multiple statements are printed at once. If upgrading from a previous version of Emerald the updated statement reports are located in the orig/reports folder. * Fixed allow crystal reports without parameters to be displayed from the custom reports menu * Fixed query error displayed when editing an accounts radius attributes when the attribute is a string containing a space or other non alphanumeric values * Fixed when editing a service type RADIUS attribute from the admin/service types menu and the attribute is a string containing a space or other non alphanumeric value portions of the value may be missing in the edit attribute form * Fixed customer account center account status refresh for expired accounts can incorrectly redirect to Emerald login page rather than customer information page * Fixed when invoicing a recurring service pro-rated to align to the MBR/billing cycle day of month and the account is also being invoiced for the next whole pay period the next period starting date is one day ahead * Fixed recalculate bill day based on account billed thru dates during database upgrade from Emerald 4.5 to prevent unecessary prorates on first billing after upgrade * Fixed relaxed start date constraint disallowing invoice creation after canceling an MBR earlier than the accounts start date so that any necessary pro-rated invoices can be generated