www.usoft.com To www.usoft.com

- - Knowledge base
Ideas
Events

Community
USoft Platform Q&A
Got a Question?

Got a Question?

Can't find what you're looking for? Ask it here!

48 Topics
98 Replies

When you subscribe we will email you when there is a new topic in this category

48 Topics

Recently active

Most replies Most views Newest first

asked in Got a Question?

xsl:strip-space in XSL Stylesheet component

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!

asked in Got a Question?

Delete from SQL Server without UPDLOCK

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?

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

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

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?

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.

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.

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?

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?

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?

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.

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

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?

Dennis.van.Vreeswijk

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?

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!

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?

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?

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?

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!

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!

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

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

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.

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?

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?

1
2

Page 1 / 2

Badge winners

rene.de.bruinhas earned the badge Explorer
rene.de.bruinhas earned the badge Scout
Janhas earned the badge Explorer
kesselringjhas earned the badge Explorer
dara.samihas earned the badge Scout

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up for the USoft Community

Already have an account? Login

Username *

E-mail address *

First name *

Last name *

Company

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login into the USoft Community

No account yet? Create an account

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

CONTACT

USoft B.V.
IJsselmeerweg 1
1411 AA Naarden
The Netherlands

+31 (0)35 699 0699
info@usoft.com
www.usoft.com

© Copyright 2023 Privacy Policy

EXPLORE MORE

About USoft
Working at USoft
Success stories