Skip to main content

 

Hi , 

Here’s a polished version of your text:

I have successfully migrated a document from App9 to the cloud environment using the DocClasses setup. However, when I try to use the File Source method, I encounter a "Document does not exist" error.

I am specifically working on one document for testing purposes, and the document is in a valid status for the FSMig tool to fetch. I have attached a screenshot of my setup.

Does anyone have any idea what I might be doing wrong? I would appreciate it if someone could point me in the direction of the correct setup.

-- Error Log
 

--FsMigTool.cmd
 

-- DocFile.txt

Regards,

Irantha

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


Reply