Technical FAQs

Ask a Question

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)

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.

Was this helpful?
What can we do to improve the information ?