Function 'GetDynamodb' failed to execute for rule. Not able to retrieve and/or parse the requested item from dynamo.

0

We have a rule where the condition is based on data from dynamodb. We wanted the filtering based on if given key had an item in the database. The query looks like:

SELECT * FROM '$aws/events/presence/connected/+' WHERE NOT isNull(get_dynamodb(MY_TABLE, 'HashKey', MY_HASHKEY, 'RangeKey', MY_RANGEKEY, MY_ROLE))

When the data is present the rule works as expected, but when it is not we get these errors logged in CloudWatch:

details: Not able to retrieve and/or parse the requested item from dynamo. ErrorMessage:
eventType: FunctionExecution
logLevel: ERROR
details: Function 'GetDynamodb' failed to execute for rule MY_RULE. Not able to retrieve and/or parse the requested item from dynamo. ErrorMessage:
eventType: RuleExecution
logLevel: ERROR
reason: ExternFunctionException

So the questions are:

  1. Can i use the get_dynamodb function to check if a item exists in the database, or can I only use this function if I know that the data for a given key is present?
  2. Should I expect my error action to trigger in the case described above (testing indicates that my error action is not triggered)?
Magne
已提問 2 年前檢視次數 391 次
1 個回答
1
已接受的答案

Hi Magne.

  1. You can use it when an item is not present, but it will cause the FunctionExecution error you're seeing. So it's probably not the behaviour you're wanting.
  2. No. The error action is only triggered if a rule action suffers an error. Your rule query failed to produce a match (because the error occurred in the WHERE clause) and hence no action was triggered.
profile pictureAWS
專家
Greg_B
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南