Error uploading data using Import CSV to Database Smart Service

A Score Level 2

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?

Parents
  • Hi,

    It may be privilege issue.
    you can check the corresponding user having insert privilege.
    if you are having insert privilege,try the below steps.
    While import the data,there is some limitations for file size.
    If you are loading huge number data,you can split the files and import into db.
    For example if you are having 30k records,split the files into 3(10k each) and try to load .

    Thanks,
    Vasanth
Reply
  • Hi,

    It may be privilege issue.
    you can check the corresponding user having insert privilege.
    if you are having insert privilege,try the below steps.
    While import the data,there is some limitations for file size.
    If you are loading huge number data,you can split the files and import into db.
    For example if you are having 30k records,split the files into 3(10k each) and try to load .

    Thanks,
    Vasanth
Children
No Data

 Discussion posts and replies are publicly visible