Jump to content


Photo

AccuSL AccuSQL error


  • This topic is locked This topic is locked
2 replies to this topic

#1 jhogan1

jhogan1

    Advanced Member

  • Members
  • PipPipPip
  • 71 posts
  • Gender:Male
  • Location:Orlando, Florida

Posted 16 May 2012 - 11:12 AM

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
Attached File  LoginError.png   13.06K   5 downloads

but it does record the appointment succesfully.

When I try to cancel the appointment I get this error

Attached File  SystemModelError.JPG   30.65K   4 downloads

and it does not cancel the appointment.

*******
Jeff Hogan
Instructional Technologist

Nursing and Allied Health

Valencia College

Orlando, Florida 32811

2012 Aspen Prize Winner


#2 jhogan1

jhogan1

    Advanced Member

  • Members
  • PipPipPip
  • 71 posts
  • Gender:Male
  • Location:Orlando, Florida

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)

*******
Jeff Hogan
Instructional Technologist

Nursing and Allied Health

Valencia College

Orlando, Florida 32811

2012 Aspen Prize Winner


#3 cbasoz

cbasoz

    <AccuTrack Support>

  • Moderators
  • PipPipPip
  • 689 posts

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users