We're having issues using the UpdatePhone method - with appears to fail. Our website would appear to time out and the Tessitura.asmx page returns the generic (HTTP 500 Internal Server Error) "The website cannot display the page"
I have attached a screen grab from the Tessitura.asmx page showing the values I'm trying to pass. I have double checked and all values are valid. I have tried passing the data with and without the sDayInd and sTeleInd values being supplied. I can confirm that our website returns the appropriate value in the iAddressNo field.
I have also tried these values directly using WP_MAINTAIN_PHONE via SQL and this appears to work just fine - although the SP has a couple of additional parameters. I passed the value 'U' in the @action parameter.
Has anyone else seen/resolved this before? As ever, any help would be gratefully received!
Hi Martin,
Have you logged the session in before making the call?
Cheers,
Patrick.
Hi Patrick,
Yep, I have gone through the login process via the web API. The sequence of API methods was:
GetNewSessionKeyEx
SetVariable
LoginEx2
UpdatePhone
Our issue is that we want the end user to be able to add/update their mobile phone number which is not possible via the UpdateAddress method.
The error I'm still getting is:
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.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.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, String srcTable)
at Tessitura.WebAPI.TessituraUser.UpdatePhone(Char action)
at Tessitura.WebAPI.Tessitura.UpdatePhone(String sSessionKey, Int32 iPhoneNo, Int32 iAddressNo, String sPhoneNumber, Int32 iPhoneType, String sDayInd, String sTeleInd)