FsMigTool using Text file

Hi ​@Irantha 

I cannot see that you are doing anything wrong. Did you use the right database credentials when testing? 🤔

If you did, the next option is to add some debug information in the sql code, around this section:

   IF ((file_source_ IS NULL OR file_source_ != 'FOLDER') AND NOT Document_Exists___ (doc_keys_)) THEN
      IF Other_Type_Document_Exists___(document_type_,doc_keys_) THEN
         reason_ := 'OTHERTYPEEXIST:DOC_TYPE='|| document_type_;
      ELSE
         reason_ := 'The document does not exist: ' || Document_Key_Ref___ (doc_keys_);
         RETURN 'FALSE';
      END IF;
   END IF;
   
--   Check if document revision or document file reference exists when documents migrate from SHARED/FTP.
   IF (file_source_ = 'FOLDER' AND NOT File_Reference_Exists___ (doc_keys_)) THEN
      reason_ := 'The document does not exist: ' || Document_Key_Ref___ (doc_keys_);
      RETURN 'FALSE';
   END IF;

By the way, is the file stored in the database? Check EdmFileStorage as well.

There can be some bug in our PL/SQL code but people have been using it a lot of it's not very likely.
 

Thank you Mathias for the Tips , I will have a look.

Regards,

Irantha