I've emailed this to CY; but, in the event other users have this problem I wanted to post it here as well.
AccuSL does access the correct AccuSQL database. When I schedule an appointment I get this error
LoginError.png 13.06K
5 downloads
but it does record the appointment succesfully.
When I try to cancel the appointment I get this error
SystemModelError.JPG 30.65K
4 downloads
and it does not cancel the appointment.
AccuSL AccuSQL error
Started by jhogan1, May 16 2012 11:12 AM
2 replies to this topic
#1
Posted 16 May 2012 - 11:12 AM
*******
Jeff Hogan
Instructional Technologist
Nursing and Allied Health
Valencia College
Orlando, Florida 32811
2012 Aspen Prize Winner
#2
Posted 16 May 2012 - 11:27 AM
If I login using localhost on the server directly I get this error
Submit operation failed. Invalid column name 'rec_id'.
Invalid column name 'last name'
Invalid column name 'first name'
error details below
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetByUser(String strType, Int32 id, SqlConnection con) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 1011
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetSetCancelInfoSql(Int32 appointId, String connectionString) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 980
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetAppointmentMemberDetail(Appoint appoint) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 0
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.ExpandAppointData(IEnumerable`1 appointments) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 614
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetEmailToTutor(AppointmentStatus status, IEnumerable`1 appoints, Tutor tutor, Int32 advance, MailTemplate template) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 265
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.AppointmentEmailToTutor(AppointmentStatus status, IEnumerable`1 appoints, IEnumerable`1 tutors, Int32 advance) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 236
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetAppointmentEmails(AppointmentStatus status, IEnumerable`1 appoints, Boolean sendEmail, Boolean sendCalendar, Boolean isTutor, CalendarMaker cm) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 194
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.SendAppointmentEmails(AppointmentStatus status, IEnumerable`1 appoints) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 66
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.SendAppointmentEmails(AppointmentStatus status, Int32[] appointIDs) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 52
at WCFRIA2.Web.Services.AppointmentDomainService.UpdateStudentAppointments(AppointmentView av) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\Services\AppointmentDomainService.cs:line 445
at UpdateStudentAppointments(DomainService , Object[] )
at System.ServiceModel.DomainServices.Server.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
at System.ServiceModel.DomainServices.Server.DomainService.InvokeDomainOperationEntry(DomainOperationEntry domainOperationEntry, Object[] parameters, ChangeSetEntry operation)
at System.ServiceModel.DomainServices.Server.DomainService.InvokeCudOperations()
at System.ServiceModel.DomainServices.Server.DomainService.ExecuteChangeSet()
at System.ServiceModel.DomainServices.Server.DomainService.Submit(ChangeSet changeSet)
at System.ServiceModel.DomainServices.Hosting.ChangeSetProcessor.Process(DomainService domainService, IEnumerable`1 changeSetEntries)
at System.ServiceModel.DomainServices.Hosting.SubmitOperationBehavior.SubmitOperationInvoker.InvokeCore(Object instance, Object[] inputs, Object[]& outputs)
Submit operation failed. Invalid column name 'rec_id'.
Invalid column name 'last name'
Invalid column name 'first name'
error details below
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetByUser(String strType, Int32 id, SqlConnection con) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 1011
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetSetCancelInfoSql(Int32 appointId, String connectionString) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 980
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetAppointmentMemberDetail(Appoint appoint) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 0
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.ExpandAppointData(IEnumerable`1 appointments) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 614
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetEmailToTutor(AppointmentStatus status, IEnumerable`1 appoints, Tutor tutor, Int32 advance, MailTemplate template) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 265
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.AppointmentEmailToTutor(AppointmentStatus status, IEnumerable`1 appoints, IEnumerable`1 tutors, Int32 advance) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 236
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.GetAppointmentEmails(AppointmentStatus status, IEnumerable`1 appoints, Boolean sendEmail, Boolean sendCalendar, Boolean isTutor, CalendarMaker cm) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 194
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.SendAppointmentEmails(AppointmentStatus status, IEnumerable`1 appoints) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 66
at WCFRIA2.Web.MailHelpers.AppointmentEmailHelper.SendAppointmentEmails(AppointmentStatus status, Int32[] appointIDs) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\MailHelpers\AppointmentEmailHelper.cs:line 52
at WCFRIA2.Web.Services.AppointmentDomainService.UpdateStudentAppointments(AppointmentView av) in C:\Users\Cetin\Documents\Visual Studio 2010\Projects\WCFRIA2\WCFRIA2.Web\Services\AppointmentDomainService.cs:line 445
at UpdateStudentAppointments(DomainService , Object[] )
at System.ServiceModel.DomainServices.Server.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
at System.ServiceModel.DomainServices.Server.DomainService.InvokeDomainOperationEntry(DomainOperationEntry domainOperationEntry, Object[] parameters, ChangeSetEntry operation)
at System.ServiceModel.DomainServices.Server.DomainService.InvokeCudOperations()
at System.ServiceModel.DomainServices.Server.DomainService.ExecuteChangeSet()
at System.ServiceModel.DomainServices.Server.DomainService.Submit(ChangeSet changeSet)
at System.ServiceModel.DomainServices.Hosting.ChangeSetProcessor.Process(DomainService domainService, IEnumerable`1 changeSetEntries)
at System.ServiceModel.DomainServices.Hosting.SubmitOperationBehavior.SubmitOperationInvoker.InvokeCore(Object instance, Object[] inputs, Object[]& outputs)
*******
Jeff Hogan
Instructional Technologist
Nursing and Allied Health
Valencia College
Orlando, Florida 32811
2012 Aspen Prize Winner
#3
Posted 18 May 2012 - 10:09 AM
This was fixed. Affects only AccuSQL users and if the appointment is created by admin. Contact to support to get current AccuSL version.
Cetin Basoz
Engineerica Senior Developer
Engineerica Senior Developer
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users