Justin Chang
11/20/2024, 8:25 PMCeligo AI
11/20/2024, 8:25 PMAI generated answer (using internal Slack threads):The error
SSS_SEARCH_ERROR_OCCURRED
with a Search error occurred: Invalid or unsupported search
message usually occurs when there is an issue with the search query. This could be due to the use of fields that are not supported in SuiteQL or due to a timeout issue when the query takes too long to execute.
In the first thread, the user was able to resolve the issue by creating a dataset with the same criteria and joins as the code. They found a significant performance difference between creating the query in code and loading a dataset configured the same way. The error was thrown after 5 minutes using query.runPaged
and seemed to be more of a timeout indicator. Running the loaded dataset took only a few seconds.
In the second thread, the user received a similar error when sending a SuiteQL query via REST. They suspected that the error might be due to a timeout as the response was received 8 minutes after sending the request. Another user suggested that the error might be due to the use of fields that are not supported in SuiteQL.
In the third thread, the users were discussing how to get the internal ids via the search API. They found that some fields were not exposed to SuiteQL and had to use the search API to get the required information.
In all cases, it's important to ensure that the fields used in the SuiteQL query are supported and that the query does not take too long to execute to avoid timeout errors.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
11/20/2024, 8:25 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836095095
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827689528
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827622414
Celigo AI
11/20/2024, 8:25 PM