Categories

WFR 12.2.1.4 Error in OCR - Reporting: ORA-00904: "ERRORDESCRIPTION": invalid identifier

User_EY62Y
User_EY62Y Member Posts: 1 Green Ribbon
in General

When WFR is in classification and OCR stage, the below errors is coming for each entry in OFRFIELDS .


[Error] |30| 15:40:04.950 | 4308 | 3928488k/63179784k | 3794136k/73275608k | 480172k/494340k | 689 | 54/53 | Reporting: ORA-00904: "ERRORDESCRIPTION": invalid identifier

[Info]  |30| 15:40:04.952 | 4308 | 3928484k/63179788k | 3794136k/73275608k | 480172k/494340k | 689 | 54/53 | INSERT INTO OFRFIELDS (DOCUMENTNUMBER, FIELDNAME, STATUS, DETAIL, OCRREJECTS, CONTENTRTS , NOOFCANDIDATES, CONFIDENCE, DISTANCE, ERRORDESCRIPTION) VALUES ( N'2a9aa448-a484-496d-bf32-e3923e7c338a', 'DocumentType', 'Valid', 'Automatic', 0, N'INVOICE', 0, '0', '0', N'') 

[Error] |30| 15:40:04.957 | 4308 | 3928512k/63179760k | 3794136k/73275608k | 480172k/494340k | 689 | 54/53 | Reporting: ORA-00904: "ERRORDESCRIPTION": invalid identifier

------------------------------------------------------

Additionally getting the below in the OCR logs. Kindly help in this issue. How can i resolve the same.


Invalid mapping in SRC section: PartitionID is not a valid ASSA column.

[Error] |30| 15:40:02.201 | 4308 | 3928284k/63179988k | 3794136k/73275608k | 480172k/494220k | 683 | 54/53 | Invalid mapping in SRC section: ExternalSiteID is not a valid ASSA column.

[Info]  |30| 15:40:04.960 | 4308 | 3928508k/63179764k | 3794136k/73275608k | 480172k/494340k | 689 | 54/53 | INSERT INTO OFRFIELDS (DOCUMENTNUMBER, FIELDNAME, STATUS, DETAIL, OCRREJECTS, CONTENTRTS , NOOFCANDIDATES, CONFIDENCE, DISTANCE, ERRORDESCRIPTION) VALUES ( N'2a9aa448-a484-496d-bf32-e3923e7c338a', 'CompanyCode', 'Valid', 'Automatic', 0, N'101', 0, '0', '0', N'') 


Thank You in Advance

Comments

  • User_EY62Y
    User_EY62Y Member Posts: 1 Green Ribbon

    Please let me know if there is any reason and solution to this?