Error while loading file WCxxxxxx.55 for Contractor 55 ORA-20001:ORA-01438: Value larger than specified precision allowed in Execution Log, Success Outcome in Executions for the run sequence. File transferred from ftp site to CIM_DIR but remained there and not processed.
Check table interface_run_log table for the contractor in this case 55 above. Sort on irl_con_id = '55' and irl_file_type='WC', order by irl_run_number desc or run. If value returned is 999999 the maximum value that can be stored ( column irl_run_number defined as number(6) ).This is the cause. Contact support for script clear_irl.sql from the useful sql folder.
The query to do the above check is
SELECT irl_con_id, MAX (irl_run_number) FROM interface_run_logGROUP BY irl_con_id;
SELECT irl_con_id, MAX (irl_run_number)
FROM interface_run_log
GROUP BY irl_con_id;
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!