Tenant bill generation error: "[Microsoft][ODBC SQL Server Driver] String data, right truncation and Invalid cursor state" when processing bills in Tenant Metering Software Commercial Edition (TMSCE)

FA212278

24/01/2018

Goals and Symptoms

Symptoms
When processing bills in Tenant Metering Software Commercial Edition (TMSCE) v2.x the following error messages are displayed:

Error (System): [Microsoft][ODBC SQL Server Driver] String, data, right truncation
Error (System): [Microsoft][ODBC SQL Server Drvier] Invalid cursor state

Facts and Changes

PRODUCTS Affected
TMS 2.0, TMS 2.5

Causes and Fixes

Cause

Special characters are present in the 'Tenant ID', 'Tenant Name', or 'Meter Name'.
A special character is defined as any non alpha-numeric character.


Resolution

Remove any special characters from the 'Tenant ID', 'Tenant Name', or 'Meter Name' fields and re-generate the bills.


Legacy KB System (APS) Data: RESL200020 V1.0, Originally authored by MaTh on 09/19/2009, Last Edited by MaTh on 09/19/2009
Related ranges: Tenant Metering Software