General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation

Users may experience the following error when selecting Median under Summary For Fund for output in a fund query:
General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation
Native error:8153
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'ID',table
[DatabaseName].dbo.TemporaryMedianModeTable'; column does not allow nulls. INSERT fails.
Native error:515
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Native error:3621

We have evaluated this issue as a bug and we have determined it will not be addressed in the program in its current state.  In this case, we believe the risks and challenges outweigh the potential benefit of resolving this issue. We strive to select the most impactful changes and issues to address with each release to accelerate the rate at which we deliver new features while sustaining the highest level of quality for our customers.

 

We recommend adding any program suggestions to our Ideas Community page. Our developers check here first when building program enhancements to see what our users are most interested in seeing implemented.


Alternate solution:
  • Run Fund Summary from the fund record (View/Summaries/Fund Summary)
  • Use the Fund Summary Report

Steps to Duplicate

  1. Open a new fund query
  2. On the Output tab, select Median under Summary For Fund
  3. Go to the Results tab
  4. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation
    Native error:8153
    [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'ID',table
    MarkOl.dbo.TemporaryMedianModeTable'; column does not allow nulls. INSERT fails.
    Native error:515
    [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
    Native error:3621

Environment

 Raiser's Edge
 7.94

Was this article helpful?