Skip to main content

Reports Populdate Job Error: 245: Conversion failed when converting the varchar value 'Y' to data type int

In this article, we explain why the Reports Populate log shows a varchar-to-int conversion error and how to resolve it.

Y
Written by Yusef Abulaynain
Updated over 4 months ago

This is caused by a change to the person_future_prospects.full_time column in Mosaic 22.2 where the data type was changed.

It's been confirmed that the data in the FULL_TIME column is no longer used in Mosaic or Mosaic Reports and will be resolved by changes to population of DM_FORMER_LOOKED_AFTER in Mosaic Reports Repository 24.1.

Related Articles
Checking the start and end time of the populate reports job
Error: 'OVERLAPPING LEGAL STATUSES MUST BE RESOLVED' in the populate log
Error Merge Person fails with "ora-01722 invalid number" or "50000: Conversion failed when converting the varchar value"
Reports population script: workflow and incremental processing
Postcode related error in population script log
Did this answer your question?