After the 2025.1 update my user can no longer query the SuiteQL table

customer

I get

Search error occurred: Invalid or unsupported search

and it times out. I have permissions > List > Customers > Full This just started happening after the update. Does anyone know what permission I need to set to fix this?

Have you tried running something as simple as this

SELECT id
FROM customer

Run it in suiteql query tool which is deployed and execute as role is set as admin.

Yes I did. and that works 🤔

There is something wrong in your query which you are overlooking. You might wanna share the query.

It has worked for over 2 years and started failing today

SELECT d.name
FROM customrecord_sta_dtid AS d 
INNER JOIN customrecord_sta_dtid_subs AS l ON d.id = l.custrecord_sta_dtid_subs_dtid_2 
INNER JOIN customrecord_sta_dt_subs AS s ON s.id = l.custrecord_sta_dtid_subs_contractsubs 
INNER JOIN transaction AS t ON t.id = s.custrecord_sta_dt_subs_so 

-- If I remove this line it works
INNER JOIN customer AS c ON c.id = t.entity 
WHERE d.name  = 'cqsqjcqo0001976r0cl0'

Can you try doing full outer join instead of inner.

Yes. That does work. Do you understand why FULL OUTER works and INNER gives me

Invalid or unsupported search

INNER is what I have uses for about 2 years

I did not go through your complete query, but I assumed that one or more recent transaction did not have a customer associated to it, or maybe some other entity is there. So trying to join something that doesn't exist in customer table threw the error.

Thanks