Error building Database project with UDF aggregate - by Genius_p

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 790837 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 6/24/2013 10:59:51 PM
Access Restriction Public


We have database project.
In this projct we have user-defined aggregate function with property [Microsoft.SqlServer.Server.SqlUserDefinedAggregate].

Function name is "SumStr".

When we use this function in SQL procedure in "PIVOT" statment, building the database project is:
- success whithout warnings and errors for SQL-procedure;

- success whith warning for SQL-scalar-function: "Warning 1 SQL71502: Function: [dbo].[DatabaseScalarFunction1] has an unresolved reference to object [dbo].[SumStr]." 

- building whith error for SQL-view or inline-functions: "SQL71501: View: [dbo].[View1] has an unresolved reference to object [dbo].[SumStr]." 

But! when we use this compiled function on SQL server side - all queries in view or table-valued functions who use this function, are performed without error. 
Sign in to post a comment.
Posted by Microsoft on 8/5/2013 at 5:19 PM
Hello Genius_p,

Thank you for your feedback. We have fixed this issue, and It should be resolved in the next release of DacFx.

Ali Badereddin