Parker Software Forum : Error when saving server-based canned response http://www.parkersoft.co.uk/forum/ This is an XML content feed of; Parker Software Forum : WhosOn General : Error when saving server-based canned response Wed, 22 May 2013 06:15:36 +0000 Tue, 05 Jun 2012 15:14:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.64 360 www.parkersoft.co.uk/forum/RSS_post_feed.asp?TID=8494 Parker Software Forum http://www.parkersoft.co.uk/forum/forum_images/PSLSmall.bmp http://www.parkersoft.co.uk/forum/ Error when saving server-based canned response : Originally posted by LiamIf... http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8494&PID=19492#19492 Author: Mobiliz.ca
Subject: 8494
Posted: 05 Jun 2012 at 3:14pm

Originally posted by Liam

If you can do this then it may point to a database update that hasn't performed. Please check the following table in the WhosOn database and ensure that the SkillID field is present - UserCannedResponses. If this is not present then you are safe to add this. It should be called SkillID and it should be an integer and nulls are allowed.
 
 
Can you please be more specific? Where do I access that DB?
 
What code should I put in exactly to debug it?
 
We're experiencing the same issue...
]]> Tue, 05 Jun 2012 15:14:16 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8494&PID=19492#19492 Error when saving server-based canned response : Hello Randy,The new Canned... http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8494&PID=19336#19336 Author: Liam
Subject: 8494
Posted: 10 Apr 2012 at 7:01am

Hello Randy,
 
The new Canned Response system uses the WhosOn Web Charts to operate. Are these working correctly for yourself? Are you able to log in and view reports in the web charts?

If you are not able to do this, are you presented with an error when attempting to access or log in to the web charts?

If you can do this then it may point to a database update that hasn't performed. Please check the following table in the WhosOn database and ensure that the SkillID field is present - UserCannedResponses. If this is not present then you are safe to add this. It should be called SkillID and it should be an integer and nulls are allowed.
 
]]> Tue, 10 Apr 2012 07:01:41 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8494&PID=19336#19336 Error when saving server-based canned response : We are new with WhosOn and... http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8494&PID=19333#19333 Author: Randy
Subject: 8494
Posted: 06 Apr 2012 at 6:31pm

We are new with WhosOn and all seems to be going pretty well.  We are working on our last bits of customization before going live and have run into a snag with canned responses.

When we open the Edit Canned Responses window everything seems to go well until we press the save button. After a brief moment a box comes up... the box is titled "Canned Response Error" and it contains this message:  "Could not save canned response. An Unspecified Error Occurred"

That's it.  We cannot save any server-based canned responses.

We tried inserting a URL, using plain text, adding skills and selecting those....  Even only creating a subject with no content. 

My user account is an administrator and the permissions inside WhosOn are wide open.

I speculate that it might be a database problem, but I am new to SQL Server and do not know what to look for nor where to look.

Thanks!

edit:  I can add sites, users, and skills with no problem.  Statistical reports are also being generated and mailed with no issues.

edit 2:  I am using the 2012.1.64 client on Windows XP desktop.  The server is Windows Server 2003 with SQLServer  Express.  It was all installed from fresh downloads two weeks ago.




Edited by Randy - 06 Apr 2012 at 7:36pm]]> Fri, 06 Apr 2012 18:31:53 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8494&PID=19333#19333