Amazon DynamoDB :- Invalid UpdateExpression: Expression size has exceeded the maximum allowed size dynamodb

Question

I am trying to update an item in was dynamoDB using nodes, db.updateItem(query).

I am getting the following error :

Invalid UpdateExpression: Expression size has exceeded the maximum allowed size dynamodb

On reading few posts, I realised that dynamoDB allows itemSize to be 400KB and that might be a problem here. But if that is the problem, why did it allow to insert the item in the first place.

I am not sure what exactly the issue. Any help would be appreciated.

Please let me know if I missed any required information

Solution

You are probably hitting Expression Parameters limits. Please refer to:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Limits.html#limits-expression-parameters

Comments

[user3807691]

Yes, I am crossing the Expression Parameters limit. The object I am updating is huge and have more than 40 embedded objects to be updated. The query being formed is absolutely correct, but the parameters size is big. Any idea how to make it work?

[sigmus]

Maybe you have to split your query? Update less objects per query?