Proact data upload crashing publish

Proact data upload crashing publish

  

Hi all,

So in my app I have the function to upload an excel into the UI, it then splits this up and adds the information to various entities in a back end module.

This works fine.

However after the upload the back end module ceases to work properly, it cannot be published or editted, the entity can't even be removed. 

As well as this the functions in the front end that interact with the back end module cannot be used as they all time out.

I believe this is to do with the quantity of data that has been uploaded (about 3000 rows in 758kb excel file). However this still doesn't seem like a lot of data.


Does anyone have idea how this can be fixed?


Thanks,

James

Hi James,

That's a weird behavior. Did you confirm the 3000 rows are created successfully in the entity? 

Can you please share a screenshot of the error you are getting when trying to publish the espace?

Vera

Vera Tiago wrote:

Hi James,

That's a weird behavior. Did you confirm the 3000 rows are created successfully in the entity? 

Can you please share a screenshot of the error you are getting when trying to publish the espace?

Vera


Hi Vera,


The error is simply that the time out was reached.

I have since found out it is because the action to upload the excel never stopped.

I am trying to figure out why that is the case currently.

If you have any idea please let me know.


Thanks,

James

James Timmins wrote:

Vera Tiago wrote:

Hi James,

That's a weird behavior. Did you confirm the 3000 rows are created successfully in the entity? 

Can you please share a screenshot of the error you are getting when trying to publish the espace?

Vera


Hi Vera,


The error is simply that the time out was reached.

I have since found out it is because the action to upload the excel never stopped.

I am trying to figure out why that is the case currently.

If you have any idea please let me know.


Thanks,

James

Could be an infinite loop? :)

Do you want to share a screenshot with your logic? or maybe your espace?


Vera Tiago wrote:

James Timmins wrote:

Vera Tiago wrote:

Hi James,

That's a weird behavior. Did you confirm the 3000 rows are created successfully in the entity? 

Can you please share a screenshot of the error you are getting when trying to publish the espace?

Vera


Hi Vera,


The error is simply that the time out was reached.

I have since found out it is because the action to upload the excel never stopped.

I am trying to figure out why that is the case currently.

If you have any idea please let me know.


Thanks,

James

Could be an infinite loop? :)

Do you want to share a screenshot with your logic? or maybe your espace?


So the logic is a bit complicated (must admit it wasn't made by me)

Basically it dumps the excel into an entity as binary data. 


Then from there it uses the 'launch load action' to launch a load paragraph action:

Within this it launches the bigger action 'load paragraphs':

In this process it basically: Determines whether to overwrite the existing data or not, then it exports the entity holding the new data and turns it into a record list using a records to list action. Then for each record in that list it creates/updates a lot of entities before finally clearing out the entity that it turned into a record in the first place.

I wonder could the error be because we turned the excel into binary data and then converted it back?


Thanks,

James