HI,
We are looking into customizing this procedure to avoid merging of records are not duplicates. Can somebody shed some light on where this procedure is placed (called within another procedure or something) within Tessitura. This will give us understanding of effects of this procedure run. Thanks for your time and help.
Cheers
Harpreet
We have had a customized LP_Validate_Cust_Merge for quite some time now.
However, with V12.1 we have started to get an error message every time the RaiseError is called.
On the client side it looks like this.
Invalid Entry
Merge not permitted by LP_VALIDATE_CUST_MERGE.
Warning: Null value is eliminated by an aggregate of other SET operation.
Anyone else run into this?
Anyone else have a quick solution?
Here is the type of code that is throwing the error.
if ( not (@Ug_contest like 'PlanM%' and @Ug_contest <> 'PlanMgr') and @delete_id_count > 0)
Begin
RAISERROR ('Merge not possible: Only Membership can merge %s', 16,1,@msg1)
RETURN
End
Unknown said: Merge not permitted by LP_VALIDATE_CUST_MERGE.
By default LP_VALIDATE_CUST_MERGE and LP_CONST_MERGE have old raiseerror syntax that we found that SQL 2012 doesn't like. In both sprocs I had to look for syntax like, e.g.
Begin RAISERROR 50000 'Merge not possible: Delete ID is an Opera Subscriber and Keep ID is not! Try reversing the selection.') RETURN End
And replace it with something like
RAISERROR (N'Merge not possible: Delete ID is an Opera Subscriber and Keep ID is not!
Try reversing the selection.', -1, -1)
Does anyone have a working LP_VALIDATE_CUST_MERGE that works with SQL Server 2016 at Tessitura 12.5.1 that they would be willing to share?
I don't have a solution to this, but now I'm worried. Do we have a list of everything that breaks when we move from SQL 2008R2 to SQL 2016?
We have a proc that works in SQL2014. SQL2016 is no different since compatibility mode needs to be set at 2014 levels.
David Vivino (Past Member) said:Do we have a list of everything that breaks when we move from SQL 2008R2 to SQL 2016?
Other than the "raiserror" stuff above, not aware of anything in the standard code breaking due to move from 08R2 to later versions.
Hi David - back when we upgraded from 2008 R2 to 2012, we ran into the "raiseerror" issue described in this thread. We upgraded to SQL Server 2016 SP1 from 2012 in our 14.1.2 test environment, and so far have had no issues. We aren't live yet - but our experience so far mirrors what Chris said.
As Chris said (Chris Jensen), the main change for 2016 was the raiserror syntax. Chris' fix above should help you with that. I tried to keep a running tab of changes here:
https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_technical-9/19096/polling-v14-sql-server-2014-upgrade-experiences/58154
We have scores and scores of customized reports/tables/jobs/procedures and the two things I found there (one was RAMP specific) were the only things I tripped.
We use Throw.
DECLARE @ERR_MSG AS NVARCHAR(MAX), @ERR_STA AS SMALLINT
SELECT @ERR_STA = ERROR_STATE()
--------- char(13) is a line feed to make the message easier to read
SET @ERR_MSG= 'Merge not possible: Both records have renewal_value.' + CHAR(13) + 'please adjust per business rules for Membership (LP_VALIDATE_CUST_MERGE)';
THROW 50000, @ERR_MSG, @ERR_STA;
We have been testing a change 2008R2 to 2016 as part of a move to RAMP.
Another thing that we found is that some SSRS reports were working OK on onsite even if you don't have IMP USERS on the stored procedure. When we got to RAMP on 2016 these reports stopped working. This may not be part of the 2016 change.