Error uploading data using Import CSV to Database Smart Service

Certified Senior Developer

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
  • 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
  • 0
    Certified Senior Developer
    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.
Reply
  • 0
    Certified Senior Developer
    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.
Children