getting below errors when following sql from trailhead. Need help in completing this challenge
Review your expression errors and try again.
1: Cannot find type for node ssot__SalesOrder__dlm.ssot__GrandTotalAmount__c
2: SUM function has to take 1 argument of type Number
3: Cannot find type for node ssot_Individual__dlm.KQ_Id__c
4: Cannot find type for node ssot__SalesOrder__dlm.ssot__SoldToCustomerId__c
5: EQUAL operator must have the same type of arguments on both sides
6: Cannot find type for node ssot__SalesOrder__dlm.KQ_SoldToCustomerId__c
7: IFNULL function's argument should have same type
8: Failed to parse Sql string
Hi, @Sowmya Jakkula
Let's take a closer look at your errors:
1. Cannot find type for node ssot__SalesOrder__dlm.ssot__GrandTotalAmount__c:
This error indicates that the field ssot__GrandTotalAmount__c does not have a defined data type. Ensure that this field exists in the ssot__SalesOrder__dlm object and has the correct type (e.g., Number).
2. SUM function has to take 1 argument of type Number:
The SUM function must take only one argument of type Number. Ensure you are using the SUM function correctly and passing the appropriate argument.
3. Cannot find type for node ssot_Individual__dlm.KQ_Id__c:
Similar to the first error, check if the KQ_Id__c field exists in the ssot_Individual__dlm object and has the correct data type.
4. Cannot find type for node ssot__SalesOrder__dlm.ssot__SoldToCustomerId__c:
Ensure that the ssot__SoldToCustomerId__c field exists in the ssot__SalesOrder__dlm object and has the correct type.
5. EQUAL operator must have the same type of arguments on both sides:
This error indicates that the EQUAL operator must have the same type of arguments on both sides. Check if you are comparing fields of the same data type.
6. Cannot find type for node ssot__SalesOrder__dlm.KQ_SoldToCustomerId__c:
Similar to previous errors, ensure that the KQ_SoldToCustomerId__c field exists in the ssot__SalesOrder__dlm object and has the correct type.
7. IFNULL function’s argument should have the same type:
The IFNULL function should have arguments of the same type. Make sure you are using it correctly.
8. Failed to parse SQL string:
This error indicates that your SQL query could not be parsed. Check the syntax of your query and ensure it is correct.
Useful links:
There are also several well-known issues that are being worked on:
- https://issues.salesforce.com/issue/a028c00000mNU8VAAW/calculated-insight-dimension-filters-is-not-working-correctly-for-is-in-operator
- https://issues.salesforce.com/issue/a028c00000j5kYWAAY/boolean-value-in-calculated-insight-results-in-internal-server-error-while-querying-data-error-in-data-explorer
- https://help.salesforce.com/s/articleView?id=000389573&type=1
Sincerely,
Mykhailo Vdovychenko
Bringing Cloud Excellence with IBVCLOUD OÜ
