go to post Michael Lundberg · Mar 15, 2022 ***Solved*** s theResponse = ##class(%ListOfObjects).%New()s SQLQuery = "{call TheProcedure }"s tSC = ..Adapter.ExecuteProcedure(.theResponse , ,SQLQuery) s tSnapshot = theResponse.GetAt(1)
go to post Michael Lundberg · Mar 15, 2022 Hi and thanks for your reply! Since this is not a stored procedure in Iris database but in an MS SQL server, syntax does not work"SELECT PackageName.ClassName_ProcedureName ('parameter')" Normal call is Execute procedure name. For example, when I call a procedure that does not use an output parameter, I use"..Adapter.ExecuteQuery (.tResult, tQuery) Quit: $$$ ISERR (tStatus)" However, because this procedure fills an output parameter, this call does not work. It then returns "Error! Function must return a value". So i suppose i need to use ExecuteProcedure Sincerely, Michael
go to post Michael Lundberg · Sep 4, 2021 Hello again! Thanks for your answers and it was our service provider who turned out to have problems, just like you thought. They have corrected (but still have some problems) and it works pretty well now Regards Michael
go to post Michael Lundberg · Sep 1, 2021 Hello and thank you very much for your answer! That/this was/is the response in SOAP log (I just deleted Style/css info): **************************************************** Input to Web client with SOAP action = urn: submitFile ERROR # 6243: HTTP request to SOAP WebService returned response with unexpected CONTENT-TYPE: text / html; charset = utf-8. Input to Web client with SOAP action = urn: submitFile ERROR # 6243: HTTP request to SOAP WebService returned response with unexpected CONTENT-TYPE: text / html; charset = utf-8. HTTP Status 500 - Internal Server Error. The server encountered an unexpected condition that prevented it from fulfilling the request. javax.servlet.ServletException: An error occurred see.fohm.sminet.util.CheckFilter.doFilter (CheckFilter.java:38) org.apache.catalina.filters.ExpiresFilter.doFilter (ExpiresFilter.java:1232). Apache Tomcat / 8.5.39 (Ubuntu) End. ************************************************ We run in windows, not Ubuntu so it must come from their service Regards Michael
go to post Michael Lundberg · Mar 31, 2021 Thanks for your reply! It can be very helpful and we will try your suggestion and hope we can get something done. Regards Michael
go to post Michael Lundberg · Mar 29, 2021 Hi and thanks for your reply. It is not possible to queue up the requests from the external systems themselves, but they will be sent to our HC- integration regardless of how many we already have in our queue. The answer (response) may take a maximum of 15 seconds, otherwise the response must be saved in the database and delivered at a later request. The problem is knowing how long a message has waited (in a queue) before it is sent to the business process, if the queue exceeds what our business service can process at the time. Our allowed time to process the request will then be 15 seconds minus the waiting time in the queue. I hope I am clear enough with what I mean. Regards Michael
go to post Michael Lundberg · Apr 24, 2020 Hello I don't think so. This is a proxy-class of type %SerialObject which I populate and embed in to the request class /Michael
go to post Michael Lundberg · Apr 23, 2020 Hi and thanks for answer Eduard. It did not work properly and it is still labeled as UTC in the SOAP request I send.I.E 2019-09-12T10: 39: 00Z. Maybe i'm doing something wrong. I dont' know. Anyway, if I instead changed this type in my class from:Property VisitTime As% TimeStamp (XMLNAME = "VisitTime" , XMLPROJECTION = "ATTRIBUTE"); To:Property VisitTime As% TimeStamp (XMLNAME = "VisitTime " , XMLPROJECTION = "ATTRIBUTE", XMLTIMEZONE = "IGNORE"); it came out as 2019-09-12T10:39:00 (No Z at the end indicating UTC). And that's what I was looking for. However it can couse me trouble if the schema will be updated and i will lost my changes. And it would be easier to not change every %Timestamp-property in my class
go to post Michael Lundberg · Apr 23, 2020 Hi and thanks for your answer Robert. I can now see that I was unclear about my question, I apologize for that What I wanted is to see if it was possible to changethe value of parameter without changing the %TimeStamp classor building a new class in my solution.
