Kbase 20582: Errors 6175 when loading data into the target data source or creating or updating records through th
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/08/2009 |
|
Status: Unverified
SYMPTOM(s):
Errors 6175 when loading data into the target data source or creating or updating records through the Progress DataServer
SYSTEM ERROR: Date/Time format error. (6175)
FACT(s) (Environment):
MS SQL DataServer
ODBC DataServer
CAUSE:
Each data source has a specific range limit for the values in a date field. When you do a Progress database migration to the data source, the error can occur if, for example, there is a date value in a field in the Progress database that is beyond the range that the data source accepts.
For example, Microsoft SQL Server data values for date time
range from 1/1/1753 to 12/32/9999.
A enhancement request 20020926-025 was submitted in order to automatically use 1/1/1753 for values beyond the limit, however the recomendation from development is to create a trigger for the ASSIGN of the table like in :
TRIGGER PROCEDURE FOR ASSIGN OF Order.Ship-Date.
if ship-date < 1/1/1753 then ship-date = 1/1/1753
FIX:
Verify that the data is valid in the data source. Progress recommends that to avoid inserts and updates into the database that are potentially out of range, place a validation expression and an initial value in the schema holder for date fields.