Conversion from String to Number Failed with Blank Value
Example
Exception while establishing database connection to ERP for DSN : [DSN] and Company : [Company] and Error: Conversion from string to number failed with blank value
Meaning
Sage 300 returned or encountered a blank value where a number was expected. The connection failed because the system could not convert that blank value into a numeric value.
Possible Causes
- A required numeric field is blank in Sage 300 setup.
- A DSN or connection property has an empty value where a number is expected.
- The Sage 300 driver encountered unexpected configuration data.
- A company-level setting or custom configuration contains invalid data.
Recommended Resolution
Contact Textura Support, your ERP administrator, or your ERP consultants to review the Sage 300 configuration, DSN settings, and related ERP data for missing numeric values.
Last Published Monday, August 31, 2026