Servicing Director Event Manager Error: "Insert into t_lockbox...is not a valid flat payment record file..."

Servicing Director Event Manager Error: "Insert into t_lockbox...is not a valid flat payment record file..."

Insert into t_lockbox -- Error: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

The statement has been terminated.

File 'xxxxx.txt' is not a valid flat payment record file.

Not all data are read.

Root Cause:

The record content of the lockbox payment file does not have the expected data or record length.

One possible cause is transferring the lockbox file over FTP, and using the FTP transfer mode of ASCII rather than binary, which will modify the end of each record as the FTP ASCII mode would indicate.

Workaround:

If you are transferring the lockbox file over FTP, use the FTP transfer mode Binary and not ASCII.

ArticleNumber:

000041415

Related Articles
Event Manager Lockbox Import Error: Insert into t_lockbox -- Error: Conversion Failed...Not a Valid Flat Payment Record File
The event failed and reported this error: Insert into t_lockbox -- Error: Conversion failed when converting datetime from character string. File '<your lockbox import file path>' is not a valid flat payment record file. Not all data are read. Root ...
Event Manager Lockbox Import Error: "Append records to pmtbatch/pmthdr/pmtdtl...Cannot insert the value into column 'ItemCount'..."
The event failed and reported this error: Append records to pmtbatch/pmthdr/pmtdtl -- Error: Cannot insert the value into column 'ItemCount', table 'Service.dbo.PmtBatch'; column does not allow s. INSERT fails. The statement has been terminated. Root ...
Servicing Director 7.8 Known Issue: The Event Manager>Daily Delinquency Counters Update Error: "T_DelinquentCounters_Update : The INSERT statement conflicted..."
The event failed and reported this error: T_DelinquentCounters_Update : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LoanStatistics_Contact". The conflict occurred in database "Service", table "dbo.Contact". The statement has ...
Servicing Director Payment Processing Incorrectly Creates a Payment Batch Total Amount for One Penny More Than the Imported Lockbox Payment File
When a lockbox file is imported into Servicing Director using the Lockbox Import Event, if the lockbox file contains a record with a transaction code of 260 - Unapplied Payment, and an amount equal to the payoff amount for that loan. You may find ...
Servicing Director 7.9 Known Issue: The Event Manager>Daily Delinquency Counters Update Error: "T_DelinquentCounters_Update : The INSERT statement conflicted...Contact"
The event failed and reported this error: T_DelinquentCounters_Update : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LoanStatistics_Contact". The conflict occurred in database "Service", table "dbo.Contact". The statement has ...