SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE deadmessage ( createdate DATETIME, body VARCHAR (MAX), lastexception VARCHAR (MAX) ); INSERT INTO deadmessage (createdate,body,lastexception) VALUES ('4/11/2022 2:04 PM' ,'{"EnrollmentId":"9a745db3-405e-43e9-95b3-b9dd35dfee51","Username":"Mpettway"}' ,'{"ClassName":"System.Exception","Message":"failed: Cannot send EnhancedPrepareRequest to device 29035257 while it has state Resetting.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at Beat.Clinical.DataAccess.NexusDataAccess.CheckForError(ResponseTypeDataType result) in D:\\_work\\8\\s\\Beat.Clinical.DataAccess\\NexusDataAccess.cs:line 981\r\n at Beat.Clinical.DataAccess.NexusDataAccess.PrepareDevice(Int32 prescriptionId, Int32 monitorId, Nullable`1 sensorId, Boolean silentStart, Int32 previousPrescriptionId, Boolean isTestFlag, String username) in D:\\_work\\8\\s\\Beat.Clinical.DataAccess\\NexusDataAccess.cs:line 285\r\n at Beat.Clinical.Engines.ClinicalEngine.StartService(Guid enrollmentId, String username, Boolean silentStart) in D:\\_work\\8\\s\\Beat.Clinical.Engines\\ClinicalEngine.cs:line 2377\r\n at Beat.Clinical.Engines.ClinicalEngine.StartService(Guid enrollmentId, String username) in D:\\_work\\8\\s\\Beat.Clinical.Engines\\ClinicalEngine.cs:line 843\r\n at Beat.Clinical.Service.QueueConsumer.Handlers.StartServiceHandler.Handle(String body) in D:\\_work\\8\\s\\Beat.Clinical.Service.QueueConsumer\\Handlers\\StartServiceHandler.cs:line 32\r\n at Beat.QueueMessaging.Consumer.QueueHandler.<>c__DisplayClass3_1.<InitializeHandler>b__0(Object model, BasicDeliverEventArgs ea)","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":"8\nCheckForError\nBeat.Clinical.DataAccess, Version=2.0.0.279, Culture=neutral, PublicKeyToken=null\nBeat.Clinical.DataAccess.NexusDataAccess\nVoid CheckForError(Beat.Clinical.DataAccess.Nexus.ResponseTypeDataType)","HResult":-2146233088,"Source":"Beat.Clinical.DataAccess","WatsonBuckets":null}' ); SELECT SUBSTRING (body, NULLIF (CHARINDEX (':',body, NULLIF(CHARINDEX(';',body),0)-1),0) , LEN(body) ) FROM deadmessage
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear