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!

  • 63 Topics
  • 118 Replies
63 Topics
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
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
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

762
R
marc
marc
asked in Got a Question?
UBlendIt strings:ReplaceVariables and escaped characters

During deployments, we use UBlendIt’s strings:ReplaceVariables function to replace placeholders with values specified in the UDeliver registry.If the placeholder values contains an escaped XML character (such as &):<Data name="$[ADV.API_REF_DATA_CONTRACT_URL]" value="https://localhost:8221/reference-data/v1/customer/contract?cas-code=$[CAS_CODE]&program=$[PROGRAM]&validation-date=$[VALIDATION_DATE]"strings:ReplaceVariables throws an error:<Error>Call to strings:ReplaceVariables5(--unknown function signature--) with 5 args: Exception has been thrown by the target of an invocation.'=' is an unexpected token. The expected token is ';'. Line 7, position 152.</Error>Anyone have any suggestions on how to work around this?Thanks!

502
marc
marc
marc
asked in Got a Question?
UDeliver action versions in USoft 10.0

In UDeliver 10.0, all actions still have version 9.1 (both in an upgraded repo and in a ‘fresh’ U10.0 repo). Is that intentional?

332
marc
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?

3362
marc
marc
marc
asked in Got a Question?
Strange Java error in service framework

I’m trying to debug this code in a service framework class;consumer = new org.apache.kafka.clients.consumer.KafkaConsumer(props);consumer.subscribe(java.util.Collections.singletonList(topicName));try { while (true) { org.apache.kafka.clients.consumer.ConsumerRecords records = consumer.poll(100L); for (org.apache.kafka.clients.consumer.ConsumerRecord record : records) {// Some more code here } }} finally { consumer.close(); }Compilation of this code gives this ‘helpful’ error:[source error] ; is missing The (almost exact) same code in Eclipse works fine:KafkaConsumer<String, String> consumer = new KafkaConsumer<String, String>(props);consumer.subscribe(Arrays.asList(topicName));try { while (true) { ConsumerRecords<String, String> records = consumer.poll(100L); for (ConsumerRecord<String, String> record : records) { System.out.printf("offset = %d, key = %s, value = %s\n", record.offset(), record.key(), reco

562
marc
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?

1103
marc
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
N
NoCode
posted in Got a Question?
Where to find USoft 10 documentation online

USoft 9 and previous versions have online documentation available eg:https://developer.usoft.com/documentation/91doc/index.html Is this kind of documentation also available for version 10 ? Kind Regards.

512
N
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...

952
marc
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?

1142
marc

Badge winners

Show all badges
Terms & ConditionsCookie settings