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
  • 119 Replies
63 Topics
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….

151
marc
marc
marc
asked in Got a Question?
Release notes U11.0.1B

Hiya, I see 11.0.1B is out 😀, but I can't find the release notes anywhere (either here or in the zip file) - could you add/publish those somewhere?Thanks!

92
marc
marc
marc
asked in Got a Question?
Container health check for web portal

Hiya, We are looking into enabling health checks for our Service Framework containers. This works fine for most containers (either with or without HTTPS), except for containers serving up a web portal, which return a ‘404 Not Found’ response. I’ve been testing with a wget call:wget https://10.128.19.72:7777/health --no-check-certificate The log shows the expected rerouting to the service and connection name:Incoming 'https://10.128.19.72:7777/health' has been mapped to 'https://10.128.19.72:443/APP_PORTAL/APP_OUT/health'server-ip:10.128.19.72 method:GET uri:/health query:- server-port:7777 client-ip:10.131.33.222 client-user-agent:Wget/1.21.2 client-referer:-MediaType unresolved, set to octet stream, for website/health in WebSite/healthstatus-code:404 status-string:Not Found client-ip:10.131.33.222 method:GET uri:/health content-media-type:null time-taken:1 But that is not where the /health endpoint lives, of course… Anyone know of a way to work around this problem?

20
marc
marc
marc
asked in Got a Question?
Synchronise version control in UDeliver?

Hiya,Is there a way in UDeliver to synchronise a (local) repository with a version control directory? Or better still, to create flat files and service framework servers directly from a version control directory?That would prevent the use of old code in a release if you forget to manually synchronise the (Service) Definer.I checked the UDeliver actions and UBlendIt functions, but there does not seem to be anything there that will do this.

90
marc
Jan
Jan
asked in Got a Question?
RDMI middle ware error on mscorlib.dll

When opening the application under USoft 11 the startup event fires, invoking a component I_LOGGING.This component has an Assembly Reference to the mscorlib.dll, which it can not find. It throws an error as below.  I do not have this dll in the USoft bin directory e.g. (assumption is that it is part of the windows version on my laptop).Strange thing is: colleagues do not run into this issue and they don’t have the dll either…Any idea what might cause this and how to fix this? 

272
Jan
marc
marc
asked in Got a Question?
Convert string to number

Hiya, am I misinterpreting the names of the functions, or are TO_INTEGER() and TO_NUMBER()  in USoft 10.1+ reversed?For example:select to_integer('1.25');select to_number('1.25');select to_number('1.55');gives:1.2512I would expect TO_INTEGER() to return a (rounded?) integer, and TO_NUMBER() not to return an integer?

190
marc
Jan
Jan
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?

191
R
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.   

803
R
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?

231
R
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?

90
R
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

180
R
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 ?

201
R
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.

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

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

363
marc
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!

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

1902
marc
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)?

323
R
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)?

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

723
dara.sami
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.

1214
marc
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.

575
R
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?

774
dara.sami
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?

1077
R
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?

861
dara.sami

Badge winners

Show all badges
Terms & ConditionsCookie settings