Hi all,
In the What’s new in V11 doc it talks about LP_CUSTOMER_RANK causing problems with the new services layer and offer 2 solutions. I took the easy one which was adding a couple of lines of code at the beginning and end of LP_CUSTOMER_RANK and this seemed to take care of the issues we were having when updating account info. Now however….the errors have come back! Nothing has changed in LP_CUSTOMER_RANK.
My only thought is to tackle the second solution which is:
“move logic from LP_CUSTOMER_RANK into service interceptors where you have more fine-grained control over when changes will be made”
I have no idea what this actually means and can’t find anything other than to-be conference presentations (I know what I’ll be attending :) ) that makes reference to this. I had a look in TIM and the have also found the Tessitura.Services.Plugin.Examples but not too sure how any of it works. Where would I be moving the logic to exactly? Has anyone else had to do this?
Thanks for any advice!
Hello Natasha,
I have not had to change where LP_CUSTOMER_RANK to an interceptor., But I have written several interceptors. An interceptor is a piece of .Net code that runs based on the service when certain configuration conditions are met. For eaxample you could have an interceptor configured to after the save of an attribute to send an email.
It sounds like in your case you need to execute this stored procedure or the piece of code that you changed in the interceptor using the dataservice Execute method . Please let me know if you need any help with building one I can provide a few examples.
Jon
Hi Jon,
Your examples would be a great help! I’m not sure where to start other than to stop it from executing from the T_CUSTOMER update trigger (which has at least stopped the errors for now).
So in the Data services folder, I add something to the web.config file that executes LP_CUSTOMER_RANK when a customer’s information is updated? Or, I set up the guidelines for it to execute, but it is actually executed from the web.config file in ConstituentServices?
Thanks again Jon!