Par2: Error: String data, right truncating 1999-08-09 -- Rick Hoffman Run the MSSQL Trace (with all options turned on), as soon as you get the error open
up the Text file and look at the data log. It will show the files / fields being
accessed.
Today I ran accross the error with a text field in SQL. All I did is put the name of the
field in the EXTERNALNAME field property in the dictionary. This corrected the problem.
"Error show below".
Also do the following.
1. Create a new dictionary.
2. Use the Dictionary Synchronizer and import the SQL tables in question.
Check all fields and keys, make sure they all match to the dictionary in question.
3. Make sure your keys have the following settings. (Case Sensitive "turned > on"
and Exclude Empty Keys "turned off"). This is also very important....
Warning: 01S01[Microsoft][ODBC SQL Server Driver]Error in row
Error Occurred: 01004[Microsoft][ODBC SQL Server Driver]String data, right
truncation NEXT(VIEW:35F304:dbo.Letters 3) File Error: String data, right truncation
Time Taken: 0.02 secs
LET:LETTERNAME : ''
LET:LETTERDESCRIPTION: ''
LET:LETTERTYPE : ''
LET:CONTENTS : ''
Printed December 3, 2024, 11:47 am This article has been viewed/printed 35249 times. |