Production Issue while processing huge data from excel file

Help Orchestrator
, , , , , , ,
1

Hi all,

My Question is that my process is running well in dev , Qa orchestrator but there is an unexcepted exception occurs in production. how can we resolve it . Reason : process has to access huge number of data from the excel file . In Dev , QA its working fine because it has less data. But in production we have huge data in the excel file . How can i resolve this .

Thanks in Advance

2

Hi @Akash_Clv

In case you are dealing with an exceptionally high volume of Excel data, please consider the approach of using the Excel as a Database option, as it will make your process significantly efficient & reliable.

Hope this helps,
Best Regards.

3

hi @arjunshenoy ,

Thanks for your answer, but the thing is you should not make any changes to the workflow. Because the project is already live and is there any possible way to handle it .

thanks in advance

4

@Akash_Clv

Since you are facing the issue only in production due to larger data sets, you should really reconsider the process design & robustness to tackle the upcoming challenges. For data access and arrangement, you can consider the options such as VBA (Macro) codes. For transformation, you can think of LinQ queries. Like this, you might be able to get rid of any such unexpected exceptions.

Hope this helps,
Best Regards.

1 Like