USoft Platform Q&A
Get inspired and gain all the USoft knowledge you need
Using xsl:strip-space in an XSL Stylesheet component (USoft 10.1.1B) results in this error:White space cannot be stripped from input documents that have already been loaded. Provide the input document as an XmlReader instead. Anyone know an easy way to work around this? Thanks!
Hiya,We use a scheduled clean-up task to delete data from a SQL Server 2019 table when it has become obsolete. During high loads, we regularly run into time-outs in a second process which is attempting to insert data into the same table.In the SQL Profiler screenshot below, you can see clean-up process 73 performing a ‘SELECT FOR DELETE’ statement. That uses the UPDLOCK hint, which result in a lock escalation on (a page beneath) the IN_ICM_EVENT table .Process 69 (which is actually a second rules service) attempts to do an insert into that same table, but times out after 10 seconds due to the lock held by the clean-up.We know the data being deleted is not going to be updated (or even selected) by any other process, so we don’t need the lock held by the clean-up process.Does anyone know if there is any way to force the rules engine to forego that lock?
Using RulesEngine.GetLastCaughtErrorsAsXML() gets you the errors in xml format. It looks like you can get those messages with various content (of course) and elements. Would there be any xsd available on these messages so we can write robust transformations on those (e.g. to return to an api call)?
We occasionally have locking issues with our SQL Server 2019 database from a USoft 10.0.1 rules service.When the load on the system is high, this error occurs sometimes:HResult of 0x80004005 (-2147467259) returnedError Source: Microsoft OLE DB Driver 19 for SQL ServerError Description: Connection is busy with results for another commandMost suggestions seem to centre on using multiple database connection or using MARS.Does anyone know if either of these are supported by U10.0 (or U10.1)?
While load testing a new application (processing approx. 40 messages per second), we occasionally get a 60101 technical error:Technical error (code 60101).Contact your system administrator.No additional info is provided, and due to the large volume of messages being processed, profiling the rules service is not really an option.Does anyone have any suggestions about finding the root cause of this error?FYI: running USoft 10.0.1J with SQL Server 2019.
Anyone know how to implement callbacks in the Service Definer?We are using a Kafka producer in the Service Framework, which uses asynchronous calls and a callback interface to handle events (see Callback (kafka 2.6.0 API) (apache.org)).I have tried using Lambda expressions, but it seems those are not supported in the Service Definer.
We are creating custom logs in some of our rules services.Currently, that is done using the StreamWriter class in a C# component, which can cause problems if multiple engines are trying to write to the same log file at the same time.Anyone have any recommendations for a logging framework which we can use in a rules service?
I have a dialog with property “modal” set to “yes” in “Window (Definition Shell)”.It's opened via a button action from a MDI Child window.Modal property seems to only set the window to be in “parent modal” state, but I still can interact with all the controls outside the window that the dialog was opened from.How do I set it to an “application modal”, so the whole application is blocked?
I have a batch job which needs to run as soon as the rules service starts. So there’s a constraint on T_EVENT which invokes that batch job.Sometimes, but not always, that constraint throws an error:<ure:entry host="az048vm3001:7222" time="2022-11-07 07:46:33" source="RulesEngine:1" severity="Error"> <ure:request request-id="0"></ure:request> <uslng:messages app-interface="http" version="1.0"> <uslng:message msg-code="60508" msg-category="Frequent End User Msg" msg-type="Error" system-msg="yes" language="default"> An error occurred when performing the following RDBMS statement: <uslng:param name="Statement">SELECT ''FROM CEP_PCSRD.T_EVENT t1WHERE (t1.EVENT = :1 AND t1.SESSION_ID = :2)</uslng:param> <uslng:param name="Param2">(STARTUP,14482352E4823)</uslng:param> <uslng:param name="Reason">UNIQUE_KEY_REASON</uslng:param> </uslng:message> <uslng
We’re working on a product where timing is quite important. We therefor would like to store a Datetime stamp up to a thousands of a second. I’ve tried multiple solutions manipulating the IO-format of the domain I’m storing the datetimestamp in unfortunately without any luck. The IO formats I tried so far are: YYYY-MM-DD HH24:MI:SS.FF3 YYYY-MM-DD HH24:MI:SS.NNN YYYY-MM-DD HH24:MI:SS.SSSthey each store the datetime stamps without the milliseconds.Even when manually inserting the date via a query in USoft Application, it inserts it without the milliseconds, also shown below Running that exact query directly on the database, and the milliseconds get inserted Is there an easy way to work with milliseconds?
I have a implemented a Role Select Restricting Condition on a table which limits the records that are returned when performing a select on that table.This works fine but when I execute a Job that executes a select on that table the Resticting Condition is not applied and all table records are returned.This seems like incorrect behaviour to me.Is this by design?
Hello,I have recorded some tests of which one invoked other parameterised tests. However when I export these test to a file and import them again they are not working anymore. More precisely it losses the parameter information.The test that is different after an export/import is:Export to a file gives:After a “Clear local repository” and an Import of the file the same test is different:How can this be fixed?
I’m trying to create a custom log format in the Service Framework - specifically, include a GUID in each log line.I *think* I can do that using a formatter (java.util.logging.Formatter), but can't figure out how that would work. Are there any examples around I could steal?Thanks!
I’m sure there’s an easy way to do this, but am not quite sure how 😐…I would like to create a text file in UDeliver which contains the release number of the release. So far, I added an attachment to the release, and was hoping to use the “Mark up text file” action to insert the release number into that, but I think that action only inserts the placeholder itself, not the value of placeholder.Anyone have any good tips? Thanks!
Hello, We started setting up the service definer servers in containers.We want to use a Key Vault to store the passwords, and the CICD pipeline will send the required passwords to the container as Linux environment variables.Therefore, we want to replace some properties of the server config.xml with the value of the Linux environment variables when the container is started.One option is to create a bash script to replace the properties with the environment variables before the server starts, but do you know an easier way to use those environment variables in the server configuration? Many thanks,Albert
Hi,In the Web Designer in USoft 10.0.1G I try do drag a GridControl from the Controls tree onto a Page element. However, the forbidden sign is shown blocking the drag operation. What should be the correct way to add the GridControl? By the way, the same applies to the GridEditControl and the TabularGridControl.Note, I finally managed to use a work-around, that is go to a predefined Info Page and copy + paste a GroupControl containing a GridControl.Thank youy
Is there a general and up-to-date overview on which database versions are supported by which USoft versions (a matrix would be nice). I can find the support for Oracle and SQL server, but not for Postgres (or others) and I don’t see the Oracle version 21c (2020/21) (if applicable). Thanks! Jan.
Sign up for the USoft Community
Already have an account? Login
Login into the USoft Community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.