Skip to main content

Why there is a Server error when generating Intrastat report?


KUSHANI
Do Gooder (Employee)
Forum|alt.badge.img+2
  • Do Gooder (Employee)
  • 6 replies

 

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;

Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings