3305 Main Street Ste 019 Vancouver, WA 98663

Why can't Office Connector write data after upgrading Sage 300 Construction and Real Estate?

Background

An Office Connector solution that writes data will contain TSWrite instructions that identify specific tables and columns. Although it is very uncommon, a new version of Sage 300 Construction and Real Estate may include changes to the database that result in certain tables or columns being retired. If a table or column no longer exists in the database and your solution includes TSWrite functions that reference the removed item, all or part of your Office Connector Write solution may not function.

Symptoms

Your Office Connector Write solution may have been affected by a database change if you encounter the following message when trying to write data after upgrading:

"FIELD-NAME" is not a recognized field in the "TABLE-NAME" table. Please ensure that all of your TSWrite functions reference valid field names before sending data to Sage 300 Construction and Real Estate.

Resolution

The resolution to the issue will be dependent on the specific database change that was made. The resolution could consist of removing the reference to the item or replacing it with a different table or column. The specific course of action will best be determined by the author of the solution or a qualified Office Connector consultant.

See also