Platform Errors

The following platform errors have documented solutions.

Column specified multiple times

The column 'xxxx' was specified multiple times for '_InnerQuery'.
This error happens when a field is listed more than once in your Field List. The fix is to remove all but one. The error will contain the specific Field Name.

Subquery returned more than 1 value

Subquery returned more than 1 value.
This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.

This error usually happens in a view when a subquery must return a single value. This is almost always when a subquery is used in the Field List. To resolve this issue, the subquery should use one of the following techniques to return a single value: Aggregates, TOP 1, STUFF, DISTINCT, GROUP BY (see Advanced SQL - Calculated Fields).

Circular reference between tables

There is a circular reference between tables.
This error normally occurs when attempting to delete a record. Circular references are not easily resolved by the system, so the delete is halted until the circular condition is resolved manually.

1) In general, it is recommended to not delete records. This is the easiest solution.

2) Another option is to find the records which are holding up the delete and remove the relationships specified in the error message. Read the error message carefully to determine which field is the cause of the circular reference. This is the field which needs to be cleared to go forward with the delete. If you need, you can go back and restore the relationships after your delete. You may want to save these in a separate selection so you can go back to them.

Take Groups for example. Groups can refer to Groups via the Parent Group field. If a Parent Group has itself as a child Group (however many levels deep), it will cause a circular reference. Here is a helpful view example to help you locate these type of error records on the Groups page if they are one level deep (it will not reveal multiple levels deep).

Fields:

Groups.[Group_Name] AS [Group Name]
,Parent_Group_Table.[Group_Name] AS [Parent Group Name]

View Clause:

Groups.[Group_ID] = Parent_Group_Table.[Group_ID]

3) A third option is to request Professional Services and have them do the delete for you. Send your request to support.

See also: Deleting Users, Adding and Deleting Security Roles

Invalid sorting expression

Invalid sorting expression: Column index is outside of the column's list.
This happens when you have previously sorted a column in the page grid by clicking on the column header, but the number of columns is now less than it was when you sorted. It is specific to the browser and machine you are using when you sorted. To prevent this error, sort using a different column visible in the view.

Input string as not in the correct format

Input string as not in the correct format.
If you get this when trying to open a record, the likely cause is the Selected Record Expression for the page. If a field name is not fully qualified with a table name, add the table name and a dot: "Program_Name" should be "Programs.Program_Name"

Record corresponding to the provided identifier is not found

Record corresponding to the provided identifier is not found. Parameter name: value
A default value is defined in a table field which has no corresponding record in the related table. The solution is to change the default for the table field using SQL Server Management Studio. See Default Values.

Invalid column name

Invalid column name.
The most likely cause for this error is a field in a view which needs to qualify with the table name. Check both the Fields List and the Filter Clause, the table reference should be fully qualified in both places for views and charts to function correctly.

ORDER BY items must appear in the select list

ORDER BY items must appear in the select list if SELECT DISTINCT is specified
This is usually due to a sort clause in a STUFF function. When using DISTINCT with an ORDER BY clause, the sort field must match the DISTINCT field. In a STUFF, it usually looks like this: STUFF(SELECT DISTINCT ', ' + G.Group_Name FROM... The fix is to use the exact same calculation for the sort, like this: ORDER BY ', ' + G.Group_Name...

Invalid column name 'User_ID'. Procedure: "dp_DeriveValueFromFieldName"

Invalid column name 'User_ID'. Procedure: "dp_DeriveValueFromFieldName".
There are different conditions which can cause this error. Either the value is incorrect or the value should be omitted. In the Steps sub-page in the Processes page, not all of the fields are visible (the fields are hidden or shown depending on which values are selected). This can lead to a condition in which the Lookup User Field is populated but it should not be (if the Step was copied and then edited for example). If the User Lookup Field is not visible, check for a value by following the link navigation to see the full record. If the value is populated (but was not visible) clearing the value may clear up this error.

Cannot insert the value NULL into column

Cannot insert the value NULL into column '<primary key field>', table '<table-name>'; column does not allow nulls. INSERT fails. The statement has been terminated.
When this error occurs for a Primary Key field, the field probably was created without an IDENTITY specification. See Creating Pages

This method or property cannot be called on Null values.

Data is null. This method or property cannot be called on Null values.
This error is not normally reported in the User Interface but can be found in the Event Viewer. One known cause is a Contact who has View Notifications but no email address.

An item with the same key has already been added

An item with the same key has already been added.
This error can be caused by a Filtered Page and may manifest in the use of Core Tools. Check that the System Name for a page has not been used more than once (due to copying an existing page) and make sure there are not two or more Pages for the same table with no filter. Only one Page should be unfiltered.

Ambiguous Column Name

Ambiguous Column Name...
This error can be caused by a Page or View when the resulting SQL statement refers to two fields with the same name from different tables.

Look for any fields listed in the error that are unqualified with a table name:

  • Page:
    • Default Field List.
    • Contact ID Field.
    • Start Date Field.
    • End Date Field.
    • Selected Record Expression.
  • Page Views (start with the Default View or Pick List View depending on the context):
    • Field List.
    • View Clause.
    • Order By.
  • Sub-Page Views (start with the Sub-Pages on the Page):
    • Field List.
    • View Clause.
    • Order By.
Table that supports direct deletes only

Cannot perform operation because the page '<page name>' is based on a table that supports direct deletes only.
This error is reported when the page record has the field "Direct Delete Only" set to prevent cascading deletes. See Direct Delete Only on in Page Fields.

The DELETE statement conflicted with the REFERENCE constraint

The DELETE statement conflicted with the REFERENCE constraint "FK_dp_Notification_Page_View_dp_Page_Views"
This error occurs when trying to delete a View which has View Notifications attached to it.

Conditions Without Specific Error Messages

Not able to edit a Record in the platform.
The symptoms of this issue include: 1) Users are not able to commit changes to a record. 2) The ID for the record does not appear in the title. This can be caused by a self-referencing key in the table. When creating a relationship in SSMS, the default fields are both the primary key. If this is accidentally saved without changing the Foreign Key Column it will cause this issue

Permission Errors

User is not authorized to access page data.
The User requires permission for a Page. If this happens in the context of editing a Series, you will need to grant the Assign permission for the page (see Page Permissions). If the error happens in the context of the Preview Record tab for a Task, the User requires permissions to the record associated with the Task. Check permissions for the page listed in the "Associated Page" column for the task.

Cannot retrieve a user associated with the current request.
the likely cause of this error is an expired login. Login again and retry.

Advanced Search Errors

System was not able to parse and recognize some of the expressions in the field list and filter clause! Do you want to continue?
See Personal Views

Incorrect syntax near the keyword 'ORDER'
This error is often caused by an incomplete filter clause. Look for one or more opening parentheses which don't have corresponding close parentheses.

Cloud Errors (CloudTools/BMT)

Client is unknown or not enabled
This could be a configuration issue on the Cloud Server or in the customer platform. Customers should first check to see that the API Client has not been disabled. The client id in scope can be found in the url in the window where the error message is found.

Message Errors (Email/SMTP)

See Message Errors

Portal and Giving Errors

See Portal Errors

 

Last Modified: 9/10/2019

Did this article help?
× Thank You for the Feedback