Message: request entity too large!

Avatar
Bahman Ashtari
Updated

In my sql server import I'm getting this error. It's just a simple insert with 25 column names and values are being passed with handle bar. What's the solutions to this? and why is it saying my request is too large when it really shouldn't be? what's the max size allowed? Thanks!

UPDATE:

I even removed all the db column names and now only adding about 27 values and it's still failing. Check out the sample insert call for what i'm doing,

INSERT into <MY_TABLE> VALUES ({{record.id}}, {{record.name}}, {{record.address}}, {{record.storeName}}, {{record.stageid}}, etc..).

and getting, ERROR: Message: request entity too large!

0

Comments

8 comments
Date Votes
  • Avatar
    Kathyana Queeman
    (Edited )
    Technical Writer
    Celigo University Level 4: Legendary
    Engaged

    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
  • Avatar
    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
  • Avatar
    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
  • Avatar
    Bahman Ashtari
    (Edited )

    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
  • Avatar
    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
  • Avatar
    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
  • Avatar
    Bahman Ashtari

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

    0
  • Avatar
    Bahman Ashtari
    (Edited )

    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.

 

Didn't find what you were looking for?

New post