RVR-SRVNW-005

Issue summary

• The error code "RVR-SRVNW-005" indicates an issue with JSON normalization in the ServiceNow data connector on the Data Integration platform. This typically occurs when there are inconsistencies or issues with processing JSON data structures within your Data Flow configuration. The JSON normalization process involves converting nested JSON data into a format that the system can parse and written into your target data destination.

Action steps

To resolve the error, follow these steps:

1. Check JSON Structure:

   • Review the JSON data to extract from ServiceNow to ensure it follows a consistent structure. Look for any malformed JSON or unexpected nesting that might be causing issues.

2. Review Data Mapping:

   • Ensure that your data mapping in Data Integration correctly handles JSON data types, especially if you are feeding data into a structured database like SQL, where JSON needs to be flattened or transformed accordingly.

3. Modify JSON Handling:

   • Consider setting up your Data Flow to flatten nested JSON structures into a single table format or configure Data Integration to preserve JSON data types if your target database supports JSON columns.

4. Preserve Raw Data (if applicable):

   • If using a target like Snowflake, consider using the "Preserve Raw Data" toggle to maintain raw JSON data, and handle normalization with Snowflake's semi-structured data processing capabilities.

5. Verify Data Source Configuration:

   • Double-check your ServiceNow data source configuration to ensure no fields are missing or improperly typed that might affect JSON parsing.

External references

• ServiceNow API: JSON Response Formats

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.