Skip to main content

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!

58 Topics
113 Replies

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

58 Topics

asked in Got a Question?

Transaction / Table last generated unique value

As described in Unique values | USoft Community one can refer to a last generated unique value from the rules engine. Would there be a (n undocumented maybe) feature available that enables specifying that for its transaction or even relate that to the table that it was used for?

asked in Got a Question?

Hardware and operating system requirements for USoft 10.1 and 11

There is a nice topic on “Hardware and operating system requirements” for version 9.0, 9.1 and 10.0 https://community.usoft.com/installing-usoft-183/hardware-and-operating-system-requirements-1095?tid=1095&fid=183It would be great if it could be updated with information for USoft 10.1 and later on 11.

asked in Got a Question?

Usage outer join in combination with batch parameterset

In USoft V9.1, if we use an Usage outer join in combination with batch parameterset, it looks like the optimizer removes the outer join instruction and executes an inner join, e.g. update p_set par set column_1 = (select round(nvl(sdurd.duration, adv.value)) from ops_stage_duration_default sdurd , app_default_values adv where par.from_poi_id = sdurd.from_poi_id (+) and par.to_poi_id = sdurd.to_poi_id (+) and ptpc.from_poi_id = par.from_poi_id and adv.name = 'STAGE_DEFAULT_DURATION' ))Start Benchmark and you’ll see the outer join removed Is this intended behavior?

asked in Got a Question?

Serve service framework OpenAPI yaml

Does anyone know if there is a way for a service framework server to serve the generated OpenAPI yaml file? So people can access the server's documentation from a browser?I've tried several variations of the server’s URI, but without success….

asked in Got a Question?

How to add a validation to the phonenumber field that it is at least 10 characters or larger in web form

Hi, For a web form with a telephone number as the field. How can I add validation for the user, so that he can put at least 10 characters or larger. I tried to put a JS in callClientScript() as below. Can you please guide?

asked in Got a Question?

How to remove Help text from Solvinx?

Hi,In order to remove help text from the questionnaire in Solvix , I have deleted it from the question. However, I can still see a blank help text in theTask Overview. Question Task overview form What am I doing incorrect? How can I get rid of such help texts?Please guide. Thanks,Rucha Naik

asked in Got a Question?

Property Inspector dissapeared in windows designer

I am using Usoft 10.1.1D. While working in windows designer, suddenly property inspector disappeared and I couldn’t open it any more. How can I get it back ?

asked in Got a Question?

Export SFW server metadata (XML) in UDeliver?

Anyone know if there is a way to export the XML of a Service Framework server in UDeliver? Similar to the way you can export the XML of the Definer with the ‘Export metadata’ action?It would be nice to have a snapshot of the SFW servers as they were at the time of creating the release, so you can restore or inspect that if needed. I suppose yo u could export the relevant tables using an XML.Export(), but I don’t see an easier way.

asked in Got a Question?

Updating interface components

We are using interface components (RDMI) in USoft 10.1.1D.If a new method is added to a component, it is sometimes necessary to toggle the ‘Interface’ checkbox so the new method shows up in the provided interface object (in the consumer, but also in the provider itself). And yes 😉, I did do a ‘Check’ of the component in the provider to generate the new methods and parameters.Is this a known bug?

asked in Got a Question?

Execute UDeliver rules service script in UBelndIt

I’m trying to run a database script, which is created in UDeliver, using UBlendIt.The upgrade script in UDeliver contains multiple SQL statements, so the resulting URE script looks something like:INSERT INTO ….;UPDATE …;UBlendIt has the pc:SqlStatement directive, but that requires child elements which are not created by UDeliver. And the sql:SqlStmnt function only accepts a single SQL statement, not a script containing multiple statements.Short of creating separate upgrade scripts, each with one SQL statement, anyone know of a way to run the multiple-statement script generated by UDeliver?

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?

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?

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!

1
2
3

Page 1 / 3

Badge winners

Ruchahas earned the badge Explorer
bert.wilmshas earned the badge Explorer
Rens Kersbergenhas earned the badge Explorer
rene.de.bruinhas earned the badge Explorer
rene.de.bruinhas 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 E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

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.
Oude Utrechtseweg 30
3743 KN Baarn
The Netherlands

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

© Copyright 2024 Privacy Policy

EXPLORE MORE

About USoft
Working at USoft
Success stories