Process NSLDS Files Fails in MSSQL Environment; FAPTLART Cobol Log File Displays Return Code 08619, Error Message 'The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.' (Doc ID 2896384.1)

Last updated on JANUARY 25, 2024

Applies to:

Symptoms

When attempting to run Process NSLDS Files, the COBOL process FAPTLART fails, with the following error displayed in the log file:

The issue will only occur when processing some files and not all. The issue is also only seen in environments on the Microsoft SQL Server (MSSQL) platform.

The issue can be reproduced at will with the following steps:

1. Navigate to Financial Aid > File Management > NSLDS > Process NSLDS Files and run the process.
2. Click link to Process Monitor and note when process ends in Error status.
3. Click Details link, then the link that says 'View Log/Trace', then the link for the .log file in the file list, and note the error message.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.