Message: request entity too large!

Comments

8 comments

  • Kathyana Rule Community moderator Technical Writer
    Engaged
    Celigo University Level 2: Seasoned

    Hello Bahman Ashtari

    I noticed that you requested information on the "bulk insert" option. Here's some information on the Microsoft SQL bulk insert option. If you're wondering about the MySQL bulk insert option, I don't think that's available yet, but it may be released in an upcoming release (hopefully this week). 

    Let me know if there's anything else I can do to help. 

    Thanks! 

    1
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Bahman Ashtari can you open a support ticket and provide a link to this post? From there, someone can meet and take a look at what may be going on.

    1
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Bahman Ashtari

    1. Are you using the "run query once per record option"? 
    2. Can you provide a screenshot and sample of the preview output when you go to build the query?
    3. Are any of your fields very large in size? Like any field that is a large JSON blob? Lots of HTML?
    0
  • Bahman Ashtari

    Thanks Tyler,

    1. Yes

    2.

     

    3. no none of the fields are large in side nor they contain html or json blob. They all have a single small value.

    Thanks for helping,

    Cheers!

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Bahman Ashtari does it do it even if you only insert in 1 value? Also, could you try the "bulk insert" option and map your fields using mapper to see if you get the same result? Also, on your export step, can you set your page size to 1 (just to test).

    0
  • Bahman Ashtari

    Thanks Tyler Lamparter, could you help me find out how to try the "bulk insert" option please? please share a link to a post that explains it. For the page size, I did set it to 1 and I'm still getting the same error. Interestingly, I ran the flow and it works without any errors. It's just this preview sql query page that's failing. At this point I feel like it's a Celigo issue that needs to be fixed.  

    0
  • Bahman Ashtari

    Thanks Kathyana Rule, I was just reading that post and it's very helpful. I appreciate it.

    0
  • Bahman Ashtari

    Tyler Lamparter thanks, just opened a support ticket and provided the link to this page.

    https://docs.celigo.com/hc/en-us/requests/200583

    0

Please sign in to leave a comment.