Its an existing defect,

try the workaround

Identify which column(s) are missing in tbl_system_preferences table (this can be done either by looking at the CAR scheduler trace and search for ERRORm, or it can simply be done by querying directly on tbl_system_preferences table via CLI to find out which one(s) are missing: "admin: run sql select * from car:tbl_system_preferences")

If any of these four columns is missing, insert it back to the table with the following logic:

- If MIN_DATE is missing, find CDR_MIN_DATE value and insert such value as MIN_DATE to tbl_system_preferences.

- If CDR_MIN_DATE is missing, find MIN_DATE value and insert such value as CDR_MIN_DATE to tbl_system_preferences.

- If both MIN_DATE & CDR_MIN_DATE are missing, insert '01/01/1970' to both columns to to tbl_system_preferences.

- If MAX_DATE is missing, find CDR_MAX_DATE value and insert such value as MAX_DATE to tbl_system_preferences.

- If CDR_MAX_DATE is missing, find MAX_DATE value and insert such value as CDR_MAX_DATE to tbl_system_preferences.

- If both MAX_DATE & CDR_MAX_DATE are missing, insert '01/01/1970' to both columns to to tbl_system_preferences.

In any of the above cases, once Loader starts and load new files, it will populate the correct values for these columns again, based on the records being loaded.

For example, if CDR_MIN_DATE is missing:

1. Get MIN_DATE value.

admin: run sql select param_value from car:tbl_system_preferences where param_name='MIN_DATE'

2. Get the value from above, eg: 01/01/2008, then run:

admin: run sql insert into car:tbl_system_preferences values('CDR_MIN_DATE', '01/01/2008');

For example, if MAX_DATE is missing:

1. Get CDR_MAX_DATE value.

admin: run sql select param_value from car:tbl_system_preferences where param_name='CDR_MAX_DATE'

2. Get the value from above, eg: 02/14/2008, then run:

admin: run sql insert into car:tbl_system_preferences values('MAX_DATE', '02/14/2008');