RVR-MGB-100

Issue summary

• The error code RVR-MGB-100 indicates a JSON parsing error while using the MongoDB data connector in Data Integration. This can happen when the JSON data structure processed is not as expected or has anomalies such as invalid syntax or incorrectly nested structures.

Action steps

To resolve the error, follow these steps:

• Verify JSON Structure: Check the JSON data processed to ensure that it is correctly structured. There should be no missing braces, colons, commas, or mismatched brackets.
• Data Type Conversions: Ensure that MongoDB data types are correctly mapped to Data Integration-compatible types during the extraction process. MongoDB objects and arrays should handle as JSON, strings, or other appropriate types depending on the target mapping.
• Check for Nested JSON: If your JSON contains nested objects, verify if they require special handling or transformation before processing. If necessary, consider flattening the JSON structure or extracting relevant fields.
• Inspect Conversion Settings: Review your data conversion settings to make sure there are no inconsistencies in how types you define or expected during mapping.
• Review Logs: Inspect logs to identify where the parsing fails. This can give insights into whether the error is due to a specific part of the JSON document.
• Update MongoDB Connection: Ensure that your MongoDB connection settings are correctly configured and that the URI and credentials are correctly entered.

External references

• For more details on MongoDB data type mapping and JSON handling in Data Integration, visit the Data Integration MongoDB Documentation.
• For troubleshooting JSON errors, consider referencing the JSON Official Documentation for structure guidelines.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.