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

Unanswered questions

43 Topics
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.

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

875
G
2 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
P
phil
asked in Community blog
Interfacing Inbound and Outbound flows to an Oracle database.

We need to interface sales orders, inventory, purchase orders from a USOFT application to an Oracle Database.It looks like we can do this development using the USOft query model? Please ignore above.  Our issue is importing the planned oorders from Oracle ASCP.  

551
USoft Support
2 years ago
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!

452
marc
2 years 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
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 

743
dara.sami
3 years ago
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. 

4301
Gert.K
3 years ago
dara.sami
dara.sami
asked in Got a Question?
In USoft 9.1, when working with modules and trying to update or populate tables of the main application via the authorizer, an 'Invalid object name' RDBMS error is shown, why? 

The error could be a result of USoft not being able to locate the module flat files. If modules are used as part of your application, then you need to make sure that the conceptual flat file (.con) of the module is locatable. More detailed information about how exactly USoft attempts to find application flatfiles is now available at: A quick test to see if the module flat file cannot be located is to put the module flat files in the APP directory of the USoft installation and try to populate/update the tables again via the Authorizer of the main application. If this resolves the error, then this means the flat files cannot be found in the fileSearchPath or HomeDir as indicated in the above documentation. Note that in USoft 10 Authorizer, the update/populate buttons are replaced with a single button Fill Authorizer Tables. The Update option is still accessible via the Authorizer "Tools" menu. If module flat files are missing, then this will also be indicated when trying to Fill the auth

530
dara.sami
3 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
I have a licensing related question, who do I need to contact?

For questions about USoft product license issuing or renewal, we advise you to contact our orders department via orders@usoft.com. For technical questions regarding the installation of the licenses or license servers, we advise you to contact support@usoft.com for further assistance.  Developer information on USoft license management is found via the documentation:  for USoft 9.0 please click here.for USoft 8.0 please click here.

340
annelies.bootsman
3 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
We are experiencing degraded database performance possibly related to the network traffic involved.

We are experiencing degraded database performance possibly related to the network traffic involved, are there settings in USoft we can use to increase our performance in this case? The *optimizationArea parameter may be useful. You can add this parameter as a command line parameter using the -xrm option or by adding the parameter via the USDIW file. More information about RDBMS performance is found in the documentation under RDBMS Performance hints :  

260
annelies.bootsman
3 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
I found a bug or technical issue, how can I report the issue?

You can report issues via multiple channels. You can e-mail us via support@usoft.com. Whenever you encounter an issue or error, we strongly recommend that you take note of the reproduction steps that lead towards the error. This will allow us to help you more effectively.When reporting the issue by e-mail, please provide us with the following information: USoft version(s) used RDBMS ,OS type and version Details of the error code or description, preferably by text. A screenshot is also helpful. Complete step by step instructions that allow us to reproduce the issue on our side. If we are unable to reproduce the issue, we cannot effectively continue our investigation. All relevant logs, this may be: Violation reports Message history logs Rules Service, Service Framework and/or Page Engine logs Definitions/repository files: Flat files XML export of definitions TDF repository backups Repository in advanced cases. OS level: Crash dump files Windows Event logs Process monitor (procm

200
annelies.bootsman
3 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
Since the upgrade we have a problem to start the USoft binder.

Since the upgrade we have a problem to start the USoft binder and the following error message is shown: The code execution cannot proceed because mfc140u.dll was not found. Reinstalling the program may fix this problem. Could it be that there is a problem with the registry? The mfc140u.dll is part of the Microsoft Visual  c++ 2015 redistributable. Normally it is installed along with a USoft installation. The redistributable vcredist_x86.exe / vcredist_x64.exe setup file you can also find seperately in the redist/Microsoft/ folder. For 32 bit versions of USoft , the C:\Windows\SysWOW64 directory is used to locate mfc140u.dll.For 64 bit versions of USoft , the C:\Windows\System32 directory is used to locate mfc140u.dll.If for some reason is missing, you may need to reinstall the Microsoft visual c++ redistributable by launching the above setup file or reinstall USoft. You can also find the currently installed Microsoft Visual  C++  via the "Apps and features" configuration page of Window

120
annelies.bootsman
3 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

610
annelies.bootsman
3 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
When running the USoft application via the Binder, an error related to usdora.dll is shown. How can I solve this?

the following type of error may be shown: Error message: Cannot load DLL of any version for 'usdora'. Reason(s):C:\Usd91\BIN64\usdora.dllC:\Usd91\BIN64\usdora10.dllC:\Usd91\BIN64\usdora90.dll; The specified module could not be found. > The error is caused by the Oracle client that is missing or when the incorrect version of the Oracle client is used against USoft. For example, when a 64 bits USoft installation runs against a 32 bit oracle client or vice versa. It can also occur if the path towards an Oracle client is missing in the Windows environment variables. This error can also occur after a fresh install of Oracle after which the user does not reboot the system and runs USoft immediately after the install. Installing an Oracle instant client in the BIN64 / BIN directory of USoft is a workaround for solving the error until the cause is determined.

510
annelies.bootsman
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

1660
annelies.bootsman
3 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
Where can I Download the latest USoft 8 , 9, 9.1?

If you want to download a USoft version, please send a email to support@usoft.com. They will provide you with the information to download the USoft version you need.

290
annelies.bootsman
3 years ago
annelies.bootsman
annelies.bootsman
asked in Got a Question?
What is USoft policy regarding product support?

It is USoft policy to actively support the last two major versions of USoft products at time of release. This also applies to RDBMS and OS support. USoft 10 is available in production and is the latest major version so USoft 9 -  the previous major release -  is supported. USoft 8.0 and older versions will not be actively supported with the release of USoft 10. This means that questions will still be answered for previous versions but should a problem result in changes being required to our software then a new fix for that version will not be automatically released. 

440
annelies.bootsman
3 years ago

Badge winners

Show all badges
Terms & ConditionsCookie settings