Hello Community,
Thought I'd post this here as well as in the Technical Forum.
We are in the process of setting up our TNEW and expecting to go live in a couple of weeks, so we don't have huge amounts of TNEW experience.
I've got a Stored Procedure that I'm trying to call from LTR_TNEW_CUSTOM_FORM_SAVE_DATA, with parameters taken from LTR_TNEW_CUSTOM_FORM_DATA. The SP will then send a notification email to our Fundraising department, because these are Gift Memberships, and they deal with them individually.
Problem is, my SP is not getting fired when I make the purchase through TNEW. It works fine when I run it from Management Studio and sends all the correct data to the correct place, just not from the TNEW site.
Has anyone in TNEW world seen this? As far as I can see, I have set everything up correctly, but I guess I must have missed a vital component.
Any help appreciated.
Thanks, Debbie
I very recently had what sounds to be the same issue.
Is your SP name longer than 30 characters? There is a character limit and if your SP name is longer then it will fail. FYI, if you are using the out-of-the-box SP LRP_TN_EXPRESS_WEB_SAVE_AUX_DATA then it is too long.
If the character limit is not the issue, have you double checked your settings in LTR_TNEW_CUSTOM_FORM_SAVE_DATA to make sure the procedure name is correct and the Use Stored Proc box is checked?
You can also log into the TNEW admin site and check out the logs. They might shed some light on what's happening.