We are currently investigating the same issue and would like to know whether others have encountered a similar problem.

In our case, the SData 2.0 request against Opportunity fails with:

com.sage.crm.sdata2.exception.SData2Exception: java.lang.NullPointerException

at com.sage.crm.sdata2.service.SData2ReadFeedService.createJsonPayloadForFeed(...)

The stack trace indicates that the exception occurs during JSON payload generation rather than while retrieving the Opportunity data itself. The same request appears to work when using Atom/XML, which makes us suspect that a specific field value is causing the JSON serializer to fail.

From our investigation so far, it looks very likely that one or more Opportunity fields (or related entities) contain invalid or missing data. However, Sage CRM does not provide enough detail in the exception to identify which field is responsible.

Has anyone experienced a similar issue where:

• SData 2.0 returns a NullPointerException for Opportunity records?
• The root cause was a specific custom field or related entity?
• There is a way to enable more detailed logging to identify the exact field causing the failure?

At the moment, we can confirm that the exception is triggered by missing or invalid field data somewhere in the Opportunity structure, but we have not yet found a practical way to determine which field is causing the problem.

Any suggestions or similar experiences would be greatly appreciated.

Hi All,

So while I do not know the issue we have a Sage CRM connector in our Data Islands tool and this uses the sage rest api and generates the sdata urls for you to see from the command line

Query Sage CRM Data - Accelerator for SageCRM

Now using this

we could test fields one by one easily and it might help figure things out. 

So if you want to connect and we can help here.

What version of Sage CRM are you using?
Can you provide more details on "we recently migrated data from oppos, companies and co. into a new database"?

We are using 2025 R2.1.
We migrated CRM to a new, fresh installation and migrated all data from opportunites, companies, persons, users, communications and linked tables so that we can work with existing data but in a fresh enviroment (new crm installation)