• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 11 replies
  • Subscribers 8 subscribers
  • Views 9117 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Integrations

Error uploading data using Import CSV to Database Smart Service

daven
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
  • 0
    A Score Level 1
    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
  • 0
    A Score Level 1
    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

© 2024 Appian. All rights reserved.