Skip to main content

USoft Platform Q&A

Get inspired and gain all the USoft knowledge you need

76 Topics
M
MDC
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.   

583
R
4 days ago
Jan
Jan
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?

181
R
18 days ago
marc
marc
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….

100
marc
1 month ago
R
Rucha
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?

70
R
1 month ago
R
Rucha
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

160
R
4 months ago
S
satyabratm
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 ?

171
R
4 months ago
B
bert.wilms
asked in Share your best practices
Best Practices for Navigating from Overview to Detail Windows

I have a data block that displays records from a specific table. Can anyone tell me how to navigate from this summary window to a more detailed information window where data can be changed?To clarify, I have a sensor summary IW window and want to move from this window to a sensor edit IW window, passing as a parameter the Pk of the current record so that the selected record can be edited.We DO NOT have a USOFT web application. 

101
R
5 months ago
R
Rens Kersbergen
posted in Share your best practices
Setup a USoft database environment for dev/test/prod

This instruction is a suggestion on how to setup a environment for a USoft project. Be aware that there are many alternatives that might suit your project better. Please consult support@usoft.com if you are not sure whether these settings are adequate for your project.For testing the USoft platform, this is a best practice to setup your environment. Requirements:A server machine for working on your USoft project SQL Server Manager Studio (SSMS) USoft license USoft software Create new database The following server settings are mandatory if you are using SQL Server for your USoft project. Please contact support@usoft.com if your own requirements clash with the settings in this instruction.Open SSMS, connect to the server that corresponds with the server you are going to work on.In the object explorer, right-click on Databases and select ‘New database’ Fill out these values:- name (the name is difficult to change after this point)- initial size : 64optional: Maximum file size 1024MB - Che

640
R
5 months ago
K
Karst
posted in Share your best practices
Set Environment variable for Windows Service

This is intended for experienced users Open the Registry Editor Go to registry path:Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\<service_name> Add a multi-string value and call it "Environment" Right click to modify and add the desired environment variables Each string value should be a name=value pair, where the name is the environment variable name Now restart the service to applyExampleAttention! When using this to set the FileSearchPath for the USoft Rules Engine, make sure to use the USoft substitution variables for the application name and file extension.For more information see: You can query the rules engine property via HTTP request in your browser to verify if the rules engine picked up the environment variable correctly (this uses the GetProperty method).http://localhost:<port>/<appname>/<app_username>/plain/SqlScript?$Password=<password>&$SQL=select%20rulesengine.getProperty(%27conceptualFile%27)Examplehttp://localhost:91

7680
K
5 months ago
USoft Support
USoft Support
published in Release updates
What’s New in USoft 11 BETA ?

Version 11 BETA is for testing purposes only. We do not support 11 BETA in production or development environments.  What’s New in USoft 11 BETA? Web UIsRenewed runtime web UIThe runtime web UIs output by USoft Web Designer now have a cleaner HTML5 structure.All JavaScript output by USoft has moved to modules. This ensures a clean separation when 3rd‑party libraries are combined with USoft web solutions. Interference between 3rd-party functions and similar USoft embedded functions is prevented. Improved web UI testing suiteThe embedded web UI test recording, playback, and benchmarking tooling that comes with USoft has an improved user experience, making web testing simpler and more fun.Template defaults for web UIsSummary: You can now replace the USoft factory default for web pages by a custom default. You can re-use your default as a template in multiple applications or Development environments.Benefits: Low-code developers are relieved from painstakingly “painting” individual details

1180
USoft Support
5 months ago
B
bert.wilms
asked in Share your best practices
Adding a default record when a another record is inserted

Anyone here who can show me the right direction to achieve the following ? I try to explain it clearly.  Table Aircraft_types has the columns pattern_id, aircraft_id, version_nr, aircraft_class )When someone insert a new record in this table Aircraft_types, a default record need to be inserted into the same Aircraft_types table. it's important that this new record has the same value for Aircraft_id and pattern_id. the aircraft_class need to be retrieved from the column Classid from the aircraft_pattern based on the new pattern_idand it's also important that the default record doesn't need to be created when there is already a record where pattern_id and aircraft_id are identical.So for examplesomene enters the recordpattern_id = BE9M and aircraft_id = P47.The default record that has to be created ispattern_id  = BE9M aircraft_id = BE9Maircraft_class = must contain the value of this select : select aircraft_class from aircraft_patterns where pattern_id = 'BE9M' I've tried a constraint a

191
R
6 months ago
marc
marc
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.

232
marc
7 months ago
R
Rens Kersbergen
published in Share your best practices
USoft Binder: Windows desktop shortcut for a project binder

This topic is a guide for developers to create the best desktop shortcut for your USoft project binder. A great desktop shortcut will bring you to your project in one click while also allowing you admin rights.Please meet these requirements before continuing:Your machine has USoft installed Your machine has a USoft project binder connected to a development database (example below)Please contact your project lead if you are not sure whether you meet these requirements.You were already able to work on your project by navigating to your project binder, but it is nice to have an efficient desktop shortcut. That is what this guide is all about.After installing USoft on your machine, navigate to <Your USoft installation folder>\bin64 – right click on usbinder.exe – Create shortcut.Drag the new shortcut to your desktop. Then right click – Properties.Open a new file explorer and locate your project binder (.usb file), right click – Copy as path.In the usbinder.exe properties window, edit

440
R
8 months ago
marc
marc
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?

413
marc
8 months ago
marc
marc
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?

313
marc
9 months ago
marc
marc
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!

432
marc
1 year ago
marc
marc
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?

1502
marc
1 year ago
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)?

303
R
1 year ago
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)?

1052
marc
1 year ago
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?

623
dara.sami
1 year ago
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.

1074
marc
1 year ago
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.

525
R
1 year ago
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?

504
dara.sami
1 year ago
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
1 year ago
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?

771
dara.sami
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie settings