Issue/Question : When generating the Intrastat report, following server error appears.
Error Message - “Database error occurred. Contact administrator”.
Version No: IFS Cloud
Product/Capability: IFS Cloud 21.1
Residency: Cloud
Solution: Issue corrected in versions 21R2 SU16 ,22R1 SU11 , 22R2 SU4, 23R1 EA
Root Cause: The reason for this server error is, there are 5915 characters for values_(index) variable value and this value cannot be assigned to the file_lines_(i_) variable which can hold a maximum of 4000 characters in INTRASTAT_HANDLING_SVC.CREATE_NEW_FILE___ method.
FOR index_ IN 1..count_ LOOP
IF (names_(index_) = 'FILE_CONTENT') THEN
file_lines_(i_) := values_(index_);
new_rec_.file_data := External_File_Utility_API.Pack_To_Blob(file_lines_);
ELSIF (names_(index_) = 'IMPORT_PROGRESS_NO') THEN
new_rec_.import_progress_no := Client_SYS.Attr_Value_To_Number(values_(index_));
ELSIF (names_(index_) = 'EXPORT_PROGRESS_NO') THEN
new_rec_.export_progress_no := Client_SYS.Attr_Value_To_Number(values_(index_));
ELSIF (names_(index_) = 'INFO') THEN
info$_ := values_(index_);
END IF;
END LOOP;