Step
Buffer Lookup
Message
Lookup value not found
Cause
This error occurs when the Buffer Lookup step fails to find a matching value based on the specified criteria.
This could happen because:
The record does not exist in the MongoDB collection.
The query conditions are too restrictive.
There's a mismatch in field names or data types between the lookup criteria and the MongoDB documents.
The collection being queried is empty.
Resolution
To resolve this issue:
Verify that the record exists in the target MongoDB collection.
Check that the field name matches exactly with the field name in MongoDB.
Review the lookup query conditions to ensure they're not too restrictive.
If the record should exist, check for possible data type mismatches (e.g., string vs. object).
Error Detail
json
{
"message": "Lookup value not found",
"statusCode": 404,
"id": "\"limit\":1,\"orderBy\":\"order\"::\"ASC\",\"field\"::\"Company\"}],\"filter\"::\"$and\":\"Company\":{\"{$eq\":\"xxxxx\"}}}}}",
"recordError": true,
"record": {
"recordNumber": 1,
"rowNumber": 1,
"record": {
"Company": "xxxxx"
},
"type": "record",
"isRecordObject": true,
"originalRecord": {
"Company": "xxxxx"
}
},
"stepType": "Mapper",
"stepName": "BufferLookup"
}