Error uploading data using Import CSV to Database Smart Service

daven

Certified Senior Developer

over 5 years ago

We are using Appian 18.1 to bulk upload csv data to a sql server database. We are achieving it by using ‘Import CSV to Database’ smart service, exceltools plugin version 2.0.2(recently upgraded) to import the data to the database.

One of the csv file has 6 columns and around 30k records. There is no data transformations.

After around ~5 mins of upload, it throws with an exception on the Appian Interface with below error(data is though inserted in the database after some time):

"403 Access Denied: you dont have permission to view this page"

Did anyone faced same issue and possible workaround?

Discussion posts and replies are publicly visible

Parents

0 Shanmukha
A Score Level 1
over 5 years ago

Hi Dev,

These type of errors can occur only when there is a problem with executing the node or something it is taking user to some page where the user does not have access to it. If you can attach actual logs in the background then we can figure out what went wrong.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 daven
Certified Senior Developer
over 5 years ago in reply to Shanmukha

Thanks for your reply. Unfortunately there are no specific logs for the errors i can see.

Note that there is no exception executing the process nor does any node fails. When the error is occurred, the model is still running in the backend uploading the data without any error. It is then completed after some time with all data insertion in the DB and obviously with no exception in logs nor any failure in the model.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 daven
Certified Senior Developer
over 5 years ago in reply to daven

Did anyone faced similar issue or any solution to this?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 wesj
Certified Lead Developer
over 5 years ago in reply to daven

I have the same issue with 18.2 using the excel tools. If the process can complete in less than 5 minutes, I do not receive the error, but if the file is larger as soon as the 5 minute mark hits, I receive the 403 access denied error. I'm guessing the web server is timing out. So far I have not found a solution except to completely change to an asynchronous strategy. Can anyone confirm that the cloud web servers have a 5 minute timeout?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 wesj
Certified Lead Developer
over 5 years ago in reply to daven

I have the same issue with 18.2 using the excel tools. If the process can complete in less than 5 minutes, I do not receive the error, but if the file is larger as soon as the 5 minute mark hits, I receive the 403 access denied error. I'm guessing the web server is timing out. So far I have not found a solution except to completely change to an asynchronous strategy. Can anyone confirm that the cloud web servers have a 5 minute timeout?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data