Applies to

• Velixo NX

• Sage Intacct

TABLE OF CONTENTS

• Overview
• Causes
• Resolution

Overview

When executing SI.QUERY function, you may get an error with code DL02000001.

While you are sure you have specified the correct field names, the query does not work and returns the error.

Causes

This error may point to a problem with the naming. Specifically, Sage Intacct cannot find the field you used in your query.

Another likely cause is an attempt to use the User Defined Dimensions (UDD) names instead of IDs in the query filter when specifying UDD value. The UDD name is visible in the Sage Intacct interface and seems to be a natural UDD identifier. However, unlike predefined dimensions, Sage Intacct does not allow the UDDs related to the queried object to be referred to by their names.

Resolution

In the beginning, ensure the query's fields are named correctly. Use the SI.OBJECTDEFINITION function to get a detailed object description and copy field names if necessary.

Double-check the fields specified with dot syntax. Their path should include an integration name of the relationship, not the name of the field the relationship relies on.

In the example below, the path to the site name is RGLDIM14397_10177.NAME, not SITE.NAME. 

If all field names are correct, check if you have UDDs in the filter. Ensure the values you specify are UDD IDs, not their names.

You can query UDD values using an auxiliary query like =SI.QUERY(ConnectionName, "SITE",,"NAME,ID") and then replace UDD names with their IDs in your original query, leveraging VLOOKUP over the auxiliary query result as simple as that:

If, for some reason, you do not like or cannot use the auxiliary query, you can find the UDD value ID in the Sage Intacct.

Navigate to the object definition: Applictions > Platform Services > Objects

After that, select an object used in the SI.QUERY function.

In the first place, make sure you use the integration name of the object field in your query, not the field label.

Then, find a relationship mentioned in the Data type column.

Click the Relationships link or scroll down to the Relationships section.

Find the relationship by the Object name.

Find the object in the Sage Intacct and view a specific record.

Select the System info tab and find the ID field.

Use the found ID instead of the UDD name in your query.