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

Got a Question?

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

  • 58 Topics
  • 114 Replies
58 Topics
Marc van Willigen
Marc van Willigen
asked in Got a Question?
Service definer: After upgrade from 9.1 to 10: "No such class: javax.ws.rs.core.Response"

Hi, After the upgrade from 9.1 to 10.0 I run into the following errors when publishing from within the Service Definer.- Class not found: javax.ws.rs.container.ContainerRequestFilter- Annotation 'javax.ws.rs.container.PreMatching' could not be resolved. Check if you have the right annotation name or use the fully qualified name.- Annotation 'javax.ws.rs.container.Priority' could not be resolved. Check if you have the right annotation name or use the fully qualified name.- method 'filter': [source error] no such class  javax.ws.rs.container.ContainerRequestContext errors:- method 'a':[source error] no such class:  javax.ws.rs.core.Response- method 'b':[source error] no such class:  javax.ws.rs.core.Response- method 'c':[source error] no such class:  javax.ws.rs.core.Response It looks that USoft 10 comes with some JAVA package changes. All errors seem to be related to the javax package. Please assist. Thank you advance. 

4541
Gert.K
3 years ago
marc
marc
asked in Got a Question?
Set custom header in REST response

In a REST service built in the Service Definer, I’d like to dynamically set a custom HTTP response header.I can specify the header in the server’s response headers, but can’t figure out how to set its value in the REST service method Java code.Anyone have any ideas?

2322
marc
3 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
What is the RDBMS and OS compatibility of USoft?

USoft 9.1 supports: RDBMS                : Oracle Database 11g Release 2: 11.2.0.1–11.2.0.4 (patchset as of August 2013) Oracle Database 12c Release 1: 12.1 (patchset as of June 2013) Oracle Database 18 Oracle Database 19 SQL Server 2016 SQL Server 2014 Backwards only: SQL Server 2012 SP1 PostgreSQL/Odbc connectivity (limited support) Derby (limited support) OS                        : Windows 10 Windows Server 2016 Backwards only: Windows Server 2012 R2 (version 6.3)   USoft 10 supports: RDBMS                      : Oracle 12c Oracle 19c Oracle 21c SQL Server 2016 SQL Server 2019 Azure SQL Database (provisioned as well as serverless) Odbc connectivity (limited support) Derby (limited support) OS                              : Windows 10 Windows 11 Windows Server 2016 Windows Server 2019 Make sure updates are installed to ensure the latest .Net version is present  USoft 9 supports: RDBMS                      : Oracle Database 10g Release 1: 10.1.0.2–10.1.0.5 (pa

1680
annelies.bootsman
3 years 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?

1672
marc
1 year ago
A
Anonymous
asked in Got a Question?
How do I delete a row using UDB library?

In a WebDesigner script I try this (in a js function): $.udb('PERS').executeQuery()        .then(function() {            $.udb('PERS').rows('condition', { PERSON_ID: "="+event.detail }).rowDelete({                check: function(){                 alert('Deleted: ' + event.detail);                 return true;                }            });        })        .catch(function() {            console.log("Something went wrong deleting a person!");        });where event.detail is the correct id of the person, I console logged it out.No error, even the alert with Deleted comes but no actual delete is performed.I tried instead of $.udb('PERS').rows('condition', { PERSON_ID: "="+event.detail }).rowDeletethis: $.udb('PERS').rows({ PERSON_ID: event.detail }).rowDeletebut still does not work

1627
A
3 years 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)?

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

1178
marc
2 years ago
marc
marc
asked in Got a Question?
USoft 10 "MSOLEDBSQL driver not found, fallback to SQLNCLI11" warning

After the upgrade from USoft 9.1 to USoft 10, we get this warning message (several times) whenever we start a component (Definer, Application, etc.):MSOLEDBSQL driver not found, fallback to SQLNCLI11HResult of 1 returnedThis did not happen with USoft 9.1 using the same SQL Server 2016 database.Anyone know what the cause might be?

1132
marc
3 years 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.

1134
marc
1 year ago
marc
marc
asked in Got a Question?
Generate Swagger for REST services?

Anyone know if there is an easy way to generate a Swagger file for a REST server created in the Service Definer?

1093
marc
3 years 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
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
2 years ago
marc
marc
asked in Got a Question?
USoft 10 Authorizer roles documentation

Is there any documentation about the new roles in the USoft 10 Authorizer?I’m trying to authorise developers for the Definer, with TeamWork permissions. Role USD_DEVELOPER (“Developer and TeamWork for Developers”) would seem the obvious choice, but then I still get this error:      No or limited SELECT rights on table "T_BUSINESS_PROCESS_STEP"when accessing business processes.Adding those users to the USD_TWRK role also doesn’t fix the problem. Adding them to the USD_REP_OWNER does, but that seems a little extreme...P.S. The same questions arises when configuring UDELIVER and USTESTER and...

912
marc
3 years ago
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.

841
C
2 years 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?

811
dara.sami
1 year ago
B
BerntMikkelsen
asked in Got a Question?
Query Definition

How to fetch and save a “Query Definition”.Purpose: An EndUser wants to save and re-use a QueryDefinition 

763
dara.sami
3 years ago
Gert.K
Gert.K
asked in Got a Question?
How to use values in a xml as a list in a sql statement

I have a relative simple xml as input<annotations> <annotation on_class="CustomREST" name="AuthSaml" method="entity" value=""/> <annotation on_class="CustomREST" name="AuthSaml" method="value" value="a"/> <annotation on_class="DefaultJobREST" name="AuthSaml" method="entity" value=""/> <annotation on_class="DefaultJobREST" name="AuthSaml" method="value" value="b"/></annotations>I want to use the values from the annotation where the method equals value. I have a small xsl transformation to grab the values, but with this I only get one value, so I cant process it as 2 values.invoke usxsl.apply with select'<annotations> <anno.... </annotations>','<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text" indent="no" omit-xml-declaration="yes" /><xsl:template match="annotation[@method=''value'']"><xsl:value-of select="@value"/></xsl:template></xsl:s

752
R
2 years ago
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.   

733
R
2 months ago
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?

692
R
2 years ago
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?

692
marc
2 years 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?

683
dara.sami
1 year ago
marc
marc
asked in Got a Question?
User XXX not registered for application USAUTH after upgrade to USoft 10

Hiya,After upgrading a USoft 9.1 (9.1.1J) application to USoft 10.0 (10.0.1A), I get this error when starting the Authorizer:User "XXX" not registered for application "USAUTH".where XXX is the owner of the database objects.The upgrade seems to have succeeded, despite some “MSOLEDBSQL driver not found, fallback to SQLNCLI11” warnings, and the data in the database appears correct.Starting any other item in the same project predictably results in a similar error.Anyone have any idea what the issue might be?Thanks!

661
marc
3 years ago
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. 

642
Jan
2 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
How do I upgrade between USoft versions?

Patch updates can be upgraded simply by downloading and installing the new version. Upgrading a USoft application to any other major version involves a sequential upgrade of the repository, for example going from 8.0 to 10.0: •          USoft 9.0        :           8.0 -> 9.0                                Upgrading to USoft 9•          USoft 9.1        :           8.0 -> 9.0 -> 9.1                      Upgrading to USoft 9.1•          USoft 10         :           8.0 -> 9.0 -> 9.1 -> 10         and  The upgrade process itself is equivalent along all versions, so you can upgrade your existing application using the same process of using the upgrade tool. We recommend going through the upgrade guidelines before and after upgrading about which more information is found in the above links.Notes:USoft 9 uses .NET Framework 4.5, where USoft 8 uses .NET Framework 3.5NET 4.5 is available starting from Windows Server 2008.Regarding license server software: Usoft 8 uses FlexLM

630
annelies.bootsman
3 years ago
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
2 years ago
Terms & ConditionsCookie settings