WI file not processing correctly when importing Message that 'Not All File would be processed' appeared. When the processing was completed there was nothing in Errors field,checking the actual works orders a large number of the records hadn't been processed.
Whilst there is nothing in Error field, there are numerous entries in the Erroneous Record fields In Invoice Verification Form. These entries have the same error for all type 15 and type 10 records.All type 15 records have the error 'ORA-01722: invalid number'.All the type 10 records have the error 'ORA-01400: cannot insert NULL into ("HIGHWAYS"."INTERFACE_COMPLETIONS_ALL"."IC_WOL_ID")'It is giving the error message for the majority of the type 10 and 15 lines in the WI files, although not all of them. The error message from some of the type 10 records suggest there isn't a valid WOL number, but the WOL number on all the effected 10 lines looks fine.
Replication Steps: Importing a WI file using Interfaces, Completions fileSystem Configuration Info: Standard
User was loading a WI file into the system using wrong procedure selected Interfaces, Completions rather than Interface, Invoice File Invoice Loader. So when processing the Invoice Verification form gave no errors, but produced erroneous records. Reloading file through correct selection resolved.
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!