error when cliking on the custom schema web application in Email

[vani97]

I have created a webapplication to capture recipient skin care details and their preference 
here i have used custom schema(tir:skincareDetails) to store recipient preference 

In schema I linked with recipient table where the tcustId is primary key and tcustId referencing as a foreign key in tir:skincareDetails schema also i decalared link in recipient table  

In campaign i queried through recipient table  and i added this web app in mail delivery to send 

but when i click on the web app in mail its getting administrator error 

Im attaching all the possible attachment here 

In personalization block i passed through id
<a href="<%@ include option='NmsServer_URL' %>/webApp/orn_APP784?id=<%=escapeUrl(recipient.cryptedId)%>" target="_blank" class="a button3">Take Survey</button>

Error in webapp

This webapp is working in preview mode by passing ID

Did anyone having solution thanks in advance

[Manoj_Kumar_]

Hello @vani97 

In the preview mode, Which ID are you passing? 

Replace the <%=escapeUrl(recipient.cryptedId)%> in the URL with the ID you are selecting and it will work.

[vani97]

In preview mode I’m selecting id(auto pk primary key in the skin care details table )

I think I have to replace the id as <%=escapeUrl(skincareDetails.cryptedId)%>

will it work ?

[Manoj_Kumar_ · Accepted solution]

Yes, Replace it with <%= recipeint.id %> and it will work.