Skip to main content

Hi IFS Community,

 

We are going to move documents from DB to FSS via ‘Transfer Document’ assistant. The customer is a live customer hosted in IFS Managed cloud and therefore we do not have access to File Storage. Then I have a major concern on what will happen if any technical failure happen ? Is there any chance of happening technical failure during the transfer. 

 

I have analyze the code and here are my findings.

Back ground job created for ‘EDM_FILE_API.Batch_Process’ and then execute Batch_Transfer_Handler_API.Move_From_Db_To_Fss. This create application messages to transfer each file to FSS. Then the IFS connect logic executes as below.

I would like to check whether is there any chance of executing modifyLoactionName without executing actual logic for physical file transfer. 

The location Name in Edm_File_Tab will be changed when ‘modifyLoactionName ’ executes. 

 

1.0 Can IFS RND consultant can check whether is there any chance of happening this ?

2.0 Does any consultant among IFS community encounter this situation ?

3.0 Can you comment if anyone has successfully transferred documents in PROD when the customer is live. We have around 500 000 documents in one document class and then it result around 500000 application messages. I am thinking about what will happen if technical failure happen when this executes.

4.0 I tried transfer DB → FSS and FSS → DB for some files using Transfer Document Assistant. DB→ FSS was successful and no detectable error. However when I transfer back from FSS to DB some of files failed to transfer. Background job is successful and  Application messages failed by saying the file is already existing in DB. Now the files are in both DB and FSS. Edm_File_Tab has FSS as the location_name. Does any one experience  this scenario.

 

Appreciate if any one who did this process share the experience.

Hi,

Today I was able to recreate above suspected problem.  We have changed the current repository to FSS. Tested scenario in EInvoice flow.

 

As per the functionality Invoice report is attaching to invoice as a pdf when sending the invoice.

In EInvoice flow first check  the files in to DB and then transfer the files  to FSS using below logic.

You can see this logic in Send_Einvoice_Attach_Inv_API.Check_In_Files__. 

 

Move_From_Db_To_Fss is the same logic underlined to ‘Transfer Document Assistant’. 

I can see application messages created and successful- However files didn’t move to FSS. But Edm_File_Tab location_name changed to FSS location. File is still there in Edm_File_Storage_Tab. 

 

Luckily before moving files from DB to FSS as a bulk we first tried to allow new file to refer FSS repo. Appreciate if ​@Mathias Dahl  and /or  ​@chanaka-shanil can check this.

Hi,

Today I was able to recreate above suspected problem.  We have changed the current repository to FSS. Tested scenario in EInvoice flow.

 

As per the functionality Invoice report is attaching to invoice as a pdf when sending the invoice.

In EInvoice flow first check  the files in to DB and then transfer the files  to FSS using below logic.

You can see this logic in Send_Einvoice_Attach_Inv_API.Check_In_Files__. 

 

Move_From_Db_To_Fss is the same logic underlined to ‘Transfer Document Assistant’. 

I can see application messages created and successful- However files didn’t move to FSS. But Edm_File_Tab location_name changed to FSS location. File is still there in Edm_File_Storage_Tab. 

 

Luckily before moving files from DB to FSS as a bulk we first tried to allow new file to refer FSS repo. Appreciate if ​@Mathias Dahl  and /or  ​@chanaka-shanil can check this.

Does the Transfer Documents functionality work as it should?

Hi ​@Mathias Dahl ,

 

I was able to solve the EInvoice related problem today. We made the active repo to FSS in UAT for all the new documents without transferring old documents to FSS. We did EInvoice flow testing in UAT after that. This is what we plan to do in PROD environment because of some concerns we have related to document bulk transfer as well as planned activities in customer environments. 

 

EInvoice flow uses same logic for document bulk transfer and then I noted that creating a person for IFSAPP is a essential activity. It solved the issue.

 

However I still think the below code can lead to problems during document bulk transfer. Is there any possibility for you to check that.

My concern is if something (technical failure) happen and if this yellow highlighted if block doesn’t execute then the next code for changing the location in EDM_FILE_TAB executes and created a document access failure. Until we do a data repair and change the location_name the users will not have access to documents.

I still need answers to below concerns

1.0 Can you check whether is there any chance of happening this ?

2.0 Does any consultant among IFS community encounter this situation ?

3.0 Can you comment if anyone has successfully transferred documents in PROD when the customer is live. We have around 500 000 documents in one document class and then it result around 500000 application messages. I am thinking about what will happen if technical failure happen when this executes.

4.0 I tried transfer DB → FSS and FSS → DB for some files using Transfer Document Assistant. DB→ FSS was successful and no detectable error. However when I transfer back from FSS to DB some of files failed to transfer. Background job is successful and  Application messages failed by saying the file is already existing in DB. Now the files are in both DB and FSS. Edm_File_Tab has FSS as the location_name. Does any one experience  this scenario. 

Reply


Terms & ConditionsCookie settings