Trouble generating output schema with Execute SuiteQL Query

Help Activities
, ,
1

Hi all! I am running into an error when trying to generate the output schema using oracle netsuite Execute SuiteQL Query activity.

I am getting the following error message: the Could not generate custom fields schema. Provider message: Custom fields configuration cannot be retrieved. Consider recreating the activity. Error code: DAP-DT-2253.. Please validate Query field input and try again

Has this happened to anyone else/does anyone else have any insight on what the issue might be? My user profile in NetSuite has access to custom objects and I double checked that the query is correct. Any advice would be appreciated!

2

Hi, Were you able to resolve this issue. We are facing similar issues.

3

Having new lines in some of my old query text caused it to not be able to Generate the output schema when I migrated an automation to a new org.
After using the Expression Editor Test to generate the sql output without whitespace new lines I was able to copy that into the select query * box and generate the output schema.

4

Hey team, I am also facing the same error. How to fix this? I also wonder why it cant generate output schema dynamically on its own upon running. There is definitely space for improvement here.

5

I was receiving the same error with Script that is a valid SQL statement in any other reasonable language:

SELECT ReferenceListCode As Code, ReferenceListPackage As Package, ReferenceListDescription As Description, ReferenceListVersion As Version, ReferenceListType As Type FROM dev.catalog.table ORDER BY ReferenceListVersion DESC LIMIT 10;

Looks like this is caused by some weird validation on fields in the SELECT statement, I resolved the error by adding an asterix:

SELECT ReferenceListCode As Code, ReferenceListPackage As Package, ReferenceListDescription As Description, ReferenceListVersion As Version, ReferenceListType As Type, * FROM dev.catalog.table ORDER BY ReferenceListVersion DESC LIMIT 10;