I am trying to get Print at home ticketing working and keep getting this error. Is anyone familiar with this error and if so could you please tell me what we need to add to T_Defaults to make it go away? Any help would be greatly appreciated!
Thanks,
Amy
Message:
Failed to print order.
Severity:
Error
Exception:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Batch Type value not present in T_DEFAULTS table
Error getting batch_no
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(TdsParserStateObject stateObj)
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.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Tessitura.WebAPI.PrintOrder.Execute()
at Tessitura.WebAPI.Tessitura.GetTicketPrintInformation(String sWebSessionId, Int32 iOrderId, String sHeaderDesign, String sTicketDesign, String cReceipt, String cReprint)
--- End of inner exception stack trace --- - SoapException
Source:
Order
StackTrace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at ETicketServerLibrary.API.Tessitura.GetTicketPrintInformation(String sWebSessionId, Int32 iOrderId, String sHeaderDesign, String sTicketDesign, String cReceipt, String cReprint) at Tessitura.ETicket.WindowsService.Orders.ProcessOrder(Int32 orderNumber, String receipt, PahtsSettings settings) at Tessitura.ETicket.WindowsService.Orders.Execute(String receipt)
Thank You, Tessitura Team
Have you had a look at the slides from Hands on Workshop: Set up Print at Home Ticketing for your system? It'll be in the Conference section of the site in the Archived Materials 2010 section/I used this to install on test and am currently using again this afternoon to put it on to our Live Server. It is really useful as it is step by step slides. I had some issues when I was setting up (I don't have the error emails to hand) and follwing these instructions stopped them all.Caryl