www.usoft.com To www.usoft.com

Replies posted by USoft Support

6 Replies

marc
marc
asked in Got a Question?

SQL Server lock on T_EVENT

Hi Marc,Thanks for the feedback on your findings!Unfortunately, there doesn't seem to be a quick solution. As I understand it, the collation of already existing data needs to be explicitly converted if a new collation is set. I would guess this is the root cause of your problem. For more detailed information, see https://learn.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-database-collation?view=sql-server-ver16.

8
marc
1 year ago
marc
marc
asked in Got a Question?

SQL Server lock on T_EVENT

Hi Marc,We have discussed your findings and think one of the following could be the problem (some of them you may already have considered).When the rules service is starting, is it starting multiple rules engines at the same time, all using the same database account? If so, this might conceivably cause the locks. On the other hand, each session gets its unique session ID, so there should be no interference between engines.So maybe the problem arises from MS SQL Server settings. USoft requires some specific settings for MS SQL Server concerning collation and database properties. For details see: "https://community.usoft.com/installing-usoft-183/microsoft-sql-server-requirements-1098", with special attention to "Collation" and "Database properties".Do you also encounter this problem on Oracle? Because if that is the case, this would point to a problem with settings for MS SQL Server.

8
marc
1 year ago
A
Anonymous
asked in Got a Question?

Datetimestamp in milliseconds

Hi Dennis,Thanks for asking your question.Unfortunately, USoft at this moment does not support working with milliseconds. The enhancement request to be able to do so has been made but has not yet been scheduled.

2
R
1 year ago
marc
marc
asked in Got a Question?

Create extended data model or data dictionary

Hi Marc, Unfortunately you probably will have to reinvent the wheel ;-). As we understand you questions, you are interested in creating a kind of report on the technical metadata in the repository (like tables and columns) and combining it with functional descriptions of the different elements. The function "Generate Diagram” in the Definer regrettably produces a fixed content. The other possibilities we offer to extract metadata (as you may already have found) are: In the Definer: Choose menu option "Tools”, menu item "Generate HTML reports ...” in SQL Commander, use the function "Repo meta ...” In SQL Commander, use the function “XML.SQLExport” to create a customized report on the repository tables (see: XML.SQLExport. This option offers you a lot of flexibility, but also requires a lot of "wheel reinvention” ;-). In the user application: Using the internal component "USMeta” (see: USMeta internal component). This component does not allow you to select additional metadata. In SQL Com

2
marc
1 year ago
marc
marc
asked in Got a Question?

Extend a class in Service Framework

Hi Marc, thanks for the update, i've marked this topic as answered in : Cheers, Dara

2
USoft Support
1 year ago
P
phil
asked in Community blog

Interfacing Inbound and Outbound flows to an Oracle database.

Hi Phil,Regarding importing planned orders from Oracle ASCP:If I understand you correctly you require information about importing data into (an existing) USoft application from an Oracle RDBMS as the data source.You can find more information about the usage of USoft with respect to Oracle via the following articles:https://community.usoft.com/installing-usoft-183 With specific details in:https://community.usoft.com/installing-usoft-183/installation-overview-1094 https://community.usoft.com/installing-usoft-183/installing-the-database-product-1100https://community.usoft.com/installing-usoft-183/oracle-requirements-1097https://community.usoft.com/installing-usoft-183/connecting-to-the-rdbms-1079Let us know if you have further questions or any additional details that we can help you with.Best regards,Dara

1
USoft Support
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie settings