Date Time Value is Outside Range of Database Error
Error
Process Runner DB by default restricts the entries of the date that are stated as earlier than the year 1753. Hence, in cases when the date returned from SAP is earlier than the year '1753', an error message similar to the following appears:
TRR:59 Error at Record No. 0 : TRR:23 Datetime value is outside the range of database.
Note: The following procedure is applicable only if Microsoft SQL Server Database is used in Process Runner DB.
Solution
Following are the two solutions for this error:
Update Existing Database Table
If this error is to be resolved for using existing table of SQL Server Database, perform the following:
- Open Data Extractor process file in which this issue is encountered.
- Go to Home tab and select Settings > Advance option.
- In Data Extractor Settings window, Select Allow Less than 1753 Year in "datetime" datatype Field.
- Select OK.
-
From Microsoft SQL Server, update all the fields of datetime datatype to datetime2 datatype manually in the database as shown in the image below.
Create New Database Table
If this error is to be resolved for a new table of SQL Server Database, perform the following:
- Open Data Extractor process file in which this issue is encountered and go to the Home tab.
- Select <Create New Table> in the table field. The Create Table window appears.
- Select Use "datetime2" datatype for SAP datetime field option.
- Select OK and Run the file.