Skip to main content
www.usoft.com To www.usoft.com

USoft Platform Q&A

Get inspired and gain all the USoft knowledge you need

84 Topics
Jan
Jan
asked in Got a Question?
xml error transformation

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)?

313
R
marc
marc
asked in Got a Question?
SQL Server "Connection is busy with results for another command"

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)?

1412
marc
marc
marc
asked in Got a Question?
Upgrade from 10.0.1 to 10.1.1

Can we upgrade the USoft ‘runtime’ on our application servers from 10.0.1 to 10.1.1 without having to redeploy the existing applications (which were created in 10.0.1)? Or will that cause problems?

713
dara.sami
marc
marc
asked in Got a Question?
Debugging technical error 60101

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.

1214
marc
marc
marc
asked in Got a Question?
Implementing callbacks in the Service Definer

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.

565
R
marc
marc
asked in Got a Question?
Custom rules service logging

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?

764
dara.sami
J
jrumiak
asked in Got a Question?
How to create an "application modal" dialog?

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?

1037
R
daniel.botman
daniel.botman
asked in Got a Question?
Which .NET versions are suitable for USoft 10?

We are changing to USoft 10.0 for our application and we are considering which version of .NET, .NET Core or .NET Framework to use for our current and future DotNet components.Does a list exist with .NET versions supported in USoft 10?

851
dara.sami
USoft Support
USoft Support
published in Share your best practices
Creating a multi-lingual USoft (web-) applicationTutorial

This article is about making a USoft application multilingual, especially a USoft web application.For a detailed "How to”, download: "Multilingualism in USoft Web Designer applications"

400
USoft Support
Jan
Jan
asked in Got a Question?
official USoft patch upgrade guidelines

Are there official USoft guidelines for upgrading to a new patch. Community content seems to focus on upgrading from one version to another, using the upgrade tool. My question is about procedure and steps to upgrade from 10.0.1.A to 10.0.1.B for example. 

662
Jan
J
j.buren
asked in Share your best practices
Anti Virus Best Practises

At the moment we are running Usoft 8 (and planning an upgrade) but are looking for best practises for configuring anti virus. Is there a document with exclusions that must be set at the client?

451
dara.sami
marc
marc
asked in Got a Question?
SQL Server lock on T_EVENT

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

1268
marc
K
kesselringj
asked in Got a Question?
Missing comma and decimal point characters when using OTS_CSV_UTIL.ToXmlImport

When, with USoft 9.1.1J, the OTS_CSV_UTIL.ToXmlImport function the comma and decimal point characters are removed from the output. Is this by design?

340
K
A
Anonymous
asked in Got a Question?
Datetimestamp in milliseconds

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?

722
R
marc
marc
asked in Got a Question?
Create extended data model or data dictionary

Before I reinvent the wheel ;-)… Is there a way to either:add the table comments and column help text to a data model generated by the Definer/TeamWork, or generate a data dictionary from the Definer tables?Thanks!

592
marc
K
kesselringj
asked in Got a Question?
Role Select Restricting Condition not applied in a Job

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?

271
dara.sami
K
kesselringj
asked in Got a Question?
Imported Web Benchmark testcases do not work

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?

364
dara.sami
marc
marc
asked in Got a Question?
Extend a class in Service Framework

This is a really a different way of asking what I asked in I want to create a custom Formatter, which means extending the java.util.logging.Formatter abstract class.Anyone know if there is a way to do this in the Service Framework?

372
USoft Support
marc
marc
asked in Got a Question?
Custom log4j2 formatting in Service Framework

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!

633
dara.sami
marc
marc
asked in Got a Question?
Create a text file containing the release number in UDeliver

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!

262
marc
A
Albert
asked in Got a Question?
Server secrets in config.xml using environment variables

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

581
Gert.K
Marc van Willigen
Marc van Willigen
asked in Got a Question?
Web Designer Cannot drag GridControl

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

331
Marc van Willigen
Jan
Jan
asked in Got a Question?
Which database versions are supported

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.

851
C
marc
marc
asked in Got a Question?
Determine rules service port inside the rules service?

Anyone know of a way inside the rules service itself to determine on which port it is running?

702
marc
marc
marc
asked in Got a Question?
'Reuse Sockets' option in Service Definer Connection

Is there any documentation about what the 'Reuse Sockets' option in the Service Definer's Connection settings does?

1005
G

Badge winners

Show all badges
Terms & ConditionsCookie settings