4Site
Support Request System
View Patch #50.028.026
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02714 -
"string truncate" error in Scheduling Export
Enhancement Description:
When attempting to export a 4Site schedule to Microsoft Project the export may fail with the error "The statement has been terminated. String or binary data would be truncated."
Solution:
The database procedures for exporting a schedule allow 50 characters for planner, crew and provider identifier and name. In some cases, the data extracted from the 4Site database is greater than 50 characters, causing the above error. The following table columns have been modified to a width of 254 characters: msproj_xx_resources.fullname; msproj_xx_resources.crew; and msproj_xx_tasks.provider.
Browse Patches
Find a Patch
Return to Request System Menu