Halting Error: API Failure: {ts '2014-04-17 08:29:30'}

Status Code returned (500) is not 200.
application URL:
http://ws.dbservices.travalliancemedia.com/1.0.6-1/Sellseries/GetDealDetailBySeoFriendlyURL

application Method:
GET
application Struct:
RequestStruct (ParamStruct) - struct
SEOFriendlyUrl say-i-do-to-a-caribbean-sunset-wedding-6998

application JSON:
{"SEOFriendlyUrl":"say-i-do-to-a-caribbean-sunset-wedding-6998"}

Response Struct:
Response Struct - struct
Data undefined
Details
Response Struct - array
1 System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Login failed for user 'S-1-9-3-679560563-1157945584-699238784-3270178447.'. A severe error occurred on the current command. The results, if any, should be discarded. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source) at Travalliance.ServiceLayer.Helpers.Seo.SeoFriendlyUrlHelper.GetSEOInformationIdFromSEOFriendlyUrl(String seoFriendlyUrl) at Travalliance.ServiceLayer.Services.SellSeries.Deals.Query.GetDealDetailBySeoFriendlyURL.Service.HandleRequest(Request request) at Travalliance.DataServices.Controllers.SellSeries.SellSeriesController.GetDealDetailBySeoFriendlyURL(Request request)
2 System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'S-1-9-3-679560563-1157945584-699238784-3270178447.'. A severe error occurred on the current command. The results, if any, should be discarded. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) ClientConnectionId:fc935da4-6130-40a4-bee3-87ddfc78d011
Messages
Response Struct - array
1 An error occurred while executing the command definition. See the inner exception for details.
2 Login failed for user 'S-1-9-3-679560563-1157945584-699238784-3270178447.'. A severe error occurred on the current command. The results, if any, should be discarded.
StatusCode 500

Response JSON:
{"Data":null,"StatusCode":500,"Messages":["An error occurred while executing the command definition. See the inner exception for details.","Login failed for user 'S-1-9-3-679560563-1157945584-699238784-3270178447.'.\r\nA severe error occurred on the current command.  The results, if any, should be discarded."],"Details":["System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Login failed for user 'S-1-9-3-679560563-1157945584-699238784-3270178447.'.\r\nA severe error occurred on the current command.  The results, if any, should be discarded.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)\r\n   --- End of inner exception stack trace ---\r\n   at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)\r\n   at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)\r\n   at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)\r\n   at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()\r\n   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)\r\n   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)\r\n   at Travalliance.ServiceLayer.Helpers.Seo.SeoFriendlyUrlHelper.GetSEOInformationIdFromSEOFriendlyUrl(String seoFriendlyUrl)\r\n   at Travalliance.ServiceLayer.Services.SellSeries.Deals.Query.GetDealDetailBySeoFriendlyURL.Service.HandleRequest(Request request)\r\n   at Travalliance.DataServices.Controllers.SellSeries.SellSeriesController.GetDealDetailBySeoFriendlyURL(Request request)","System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'S-1-9-3-679560563-1157945584-699238784-3270178447.'.\r\nA severe error occurred on the current command.  The results, if any, should be discarded.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)\r\nClientConnectionId:fc935da4-6130-40a4-bee3-87ddfc78d011"]}

CFCATCH:
cfcatch - struct
Detail [empty string]
ErrorCode [empty string]
ExtendedInfo [empty string]
Message Status Code returned (500) is not 200.
StackTrace coldfusion.runtime.CustomException: Status Code returned (500) is not 200. at coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:142) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799) at cfUtilities2ecfc602122219$funcJSONUNPACKER.runFunction(E:\CFSites\sellseries\SellSeries_Codebase\components\Utilities\Utilities.cfc:1689) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2659) at cfUtilities2ecfc602122219$funcGETDATAFROMCENTRALDATABASE.runFunction(E:\CFSites\sellseries\SellSeries_Codebase\components\Utilities\Utilities.cfc:1561) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2432) at cfPagesData2ecfc265328845$funcGETDEALDATA_BYSEOURL.runFunction(E:\CFSites\sellseries\SellSeries_Codebase\components\Pages\PagesData.cfc:458) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2432) at cfPagesController2ecfc1356707387$funcRETRIEVEDEAL_BYSEOURL.runFunction(E:\CFSites\sellseries\SellSeries_Codebase\components\Pages\PagesController.cfc:80) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2432) at cfindex2ecfm1571619427._factor0(E:\CFSites\sellseries\SellSeries_Codebase\index.cfm:52) at cfindex2ecfm1571619427._factor1(E:\CFSites\sellseries\SellSeries_Codebase\index.cfm:32) at cfindex2ecfm1571619427._factor5(E:\CFSites\sellseries\SellSeries_Codebase\index.cfm:16) at cfindex2ecfm1571619427.runPage(E:\CFSites\sellseries\SellSeries_Codebase\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:428) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722)
Suppressed
cfcatch - array [empty]
TagContext
cfcatch - array
1
cfcatch - struct
COLUMN 0
ID CFTHROW
LINE 1689
RAW_TRACE at cfUtilities2ecfc602122219$funcJSONUNPACKER.runFunction(E:\CFSites\sellseries\SellSeries_Codebase\components\Utilities\Utilities.cfc:1689)
TEMPLATE E:\CFSites\sellseries\SellSeries_Codebase\components\Utilities\Utilities.cfc
TYPE CFML
2
cfcatch - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 1561
RAW_TRACE at cfUtilities2ecfc602122219$funcGETDATAFROMCENTRALDATABASE.runFunction(E:\CFSites\sellseries\SellSeries_Codebase\components\Utilities\Utilities.cfc:1561)
TEMPLATE E:\CFSites\sellseries\SellSeries_Codebase\components\Utilities\Utilities.cfc
TYPE CFML
3
cfcatch - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 458
RAW_TRACE at cfPagesData2ecfc265328845$funcGETDEALDATA_BYSEOURL.runFunction(E:\CFSites\sellseries\SellSeries_Codebase\components\Pages\PagesData.cfc:458)
TEMPLATE E:\CFSites\sellseries\SellSeries_Codebase\components\Pages\PagesData.cfc
TYPE CFML
4
cfcatch - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 80
RAW_TRACE at cfPagesController2ecfc1356707387$funcRETRIEVEDEAL_BYSEOURL.runFunction(E:\CFSites\sellseries\SellSeries_Codebase\components\Pages\PagesController.cfc:80)
TEMPLATE E:\CFSites\sellseries\SellSeries_Codebase\components\Pages\PagesController.cfc
TYPE CFML
5
cfcatch - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 52
RAW_TRACE at cfindex2ecfm1571619427._factor0(E:\CFSites\sellseries\SellSeries_Codebase\index.cfm:52)
TEMPLATE E:\CFSites\sellseries\SellSeries_Codebase\index.cfm
TYPE CFML
6
cfcatch - struct
COLUMN 0
ID CF_INDEX
LINE 32
RAW_TRACE at cfindex2ecfm1571619427._factor1(E:\CFSites\sellseries\SellSeries_Codebase\index.cfm:32)
TEMPLATE E:\CFSites\sellseries\SellSeries_Codebase\index.cfm
TYPE CFML
7
cfcatch - struct
COLUMN 0
ID CF_INDEX
LINE 16
RAW_TRACE at cfindex2ecfm1571619427._factor5(E:\CFSites\sellseries\SellSeries_Codebase\index.cfm:16)
TEMPLATE E:\CFSites\sellseries\SellSeries_Codebase\index.cfm
TYPE CFML
8
cfcatch - struct
COLUMN 0
ID CF_INDEX
LINE 1
RAW_TRACE at cfindex2ecfm1571619427.runPage(E:\CFSites\sellseries\SellSeries_Codebase\index.cfm:1)
TEMPLATE E:\CFSites\sellseries\SellSeries_Codebase\index.cfm
TYPE CFML
Type StackTrace
code [empty string]