DynamoDB Query fails twice out of 4 hits

four_times_repeated.log

INIT_START Runtime Version: python:3.11.v24	Runtime Version ARN: arn:aws:lambda:us-east-1::runtime:a5ffc62d98071fc767e6f8abc670b5036a0f5a683f0bbc6cb1bac14de89647bf

START RequestId: 23802916-46a1-4a53-814a-7fc52d6e5186 Version: $LATEST

END RequestId: 23802916-46a1-4a53-814a-7fc52d6e5186

REPORT RequestId: 23802916-46a1-4a53-814a-7fc52d6e5186	Duration: 1598.01 ms	Billed Duration: 1599 ms	Memory Size: 128 MB	Max Memory Used: 75 MB	Init Duration: 283.32 ms	

START RequestId: f959cde0-3814-4b95-b3c1-da47b3b974ea Version: $LATEST

END RequestId: f959cde0-3814-4b95-b3c1-da47b3b974ea

REPORT RequestId: f959cde0-3814-4b95-b3c1-da47b3b974ea	Duration: 230.12 ms	Billed Duration: 231 ms	Memory Size: 128 MB	Max Memory Used: 76 MB	


START RequestId: 13073fa0-1091-4d79-878a-c7c7b73b2cce Version: $LATEST

[ERROR] ClientError: An error occurred (ValidationException) when calling the Scan operation: ExpressionAttributeValues contains invalid value: The parameter cannot be converted to a numeric value for key :nitin_nature
Traceback (most recent call last):
  File "/var/task/lambda_function.py", line 15, in lambda_handler
    response_list = client.scan(ExpressionAttributeValues = {":nitin_nature": {'N':search_term}}, FilterExpression='id = :nitin_nature', TableName='activitylg', ProjectionExpression='#ST, #AT', ExpressionAttributeNames={ '#AT': 'dt', '#ST': 'code', },	)
  File "/var/lang/lib/python3.11/site-packages/botocore/client.py", line 534, in _api_call
    return self._make_api_call(operation_name, kwargs)
  File "/var/lang/lib/python3.11/site-packages/botocore/client.py", line 976, in _make_api_call
    raise error_class(parsed_response, operation_name)

END RequestId: 13073fa0-1091-4d79-878a-c7c7b73b2cce

REPORT RequestId: 13073fa0-1091-4d79-878a-c7c7b73b2cce	Duration: 277.98 ms	Billed Duration: 278 ms	Memory Size: 128 MB	Max Memory Used: 76 MB	


START RequestId: 6b93cca0-689f-4664-bca1-d4f5388b824a Version: $LATEST
[ERROR] ClientError: An error occurred (ValidationException) when calling the Scan operation: ExpressionAttributeValues contains invalid value: The parameter cannot be converted to a numeric value for key :nitin_nature
Traceback (most recent call last):
  File "/var/task/lambda_function.py", line 15, in lambda_handler
    response_list = client.scan(ExpressionAttributeValues = {":nitin_nature": {'N':search_term}}, FilterExpression='id = :nitin_nature', TableName='activitylg', ProjectionExpression='#ST, #AT', ExpressionAttributeNames={ '#AT': 'dt', '#ST': 'code', },	)
  File "/var/lang/lib/python3.11/site-packages/botocore/client.py", line 534, in _api_call
    return self._make_api_call(operation_name, kwargs)
  File "/var/lang/lib/python3.11/site-packages/botocore/client.py", line 976, in _make_api_call
    raise error_class(parsed_response, operation_name)

END RequestId: 6b93cca0-689f-4664-bca1-d4f5388b824a

REPORT RequestId: 6b93cca0-689f-4664-bca1-d4f5388b824a	Duration: 265.16 ms	Billed Duration: 266 ms	Memory Size: 128 MB	Max Memory Used: 76 MB	

INIT_START Runtime Version: python:3.11.v24	Runtime Version ARN: arn:aws:lambda:us-east-1::runtime:a5ffc62d98071fc767e6f8abc670b5036a0f5a683f0bbc6cb1bac14de89647bf