Rocket MultiValue

hello,I'll introduce a little enhancement suggestion into MVVS display.Like when I edit a json file, I'll read my current 'in code path' into the header of my file. here is the sample on a json : the 'in code path' show the complete 'xpath' like of my cursor position.  Applied to BASIC, I'll have : Directoryname > Filename > sectionName > indentLevel > indentLevel > ... where :sectionName := the nearest upper Label   in sample WIBASIC > WI.OPENAPI.B > PathItemObject: IndentLevel := the list of nested indent 'word' ... for, if, loop, if  with first next word ... in sample  WIBASIC > WI.OPENAPI.B > PathItemObject: > for ivar > if APP When we edit large basic code, a such 'in code path' can be really usefull. With kind regards------------------------------Manu Fernandes------------------------------

When a program locks up and I have to close Accuterm to get out of it,  the system leaves users logged on.  How can I free up those users without rebooting.------------------------------Hal MalletBusiness OwnerAdvanced Retail & Service SystemsChula Vista CA US------------------------------

Hello,  I am migrating our production application (Prelude) from a UNIX to Linux environment. Currently, I am working on moving the U2 ODBC database. UniData is installed and working on the system and presents correctly in Prelude, however the ODBC database is having some issues. When I attempt to connect using U2 ODBC drivers, I can only interact with 5 out of the 40 tables present. The account used to manage these tables/subtables/views has owner permissions on the db and is part of the same groups as it was on Unix. I am not sure where to continue my troubleshooting efforts here, but direction/suggestions are greatly appreciated.------------------------------Phaelen Stuart-BergIT Systems ManagerRocket Forum Shared Account------------------------------

Hallo Everyone, I have newly installed AccuTerm IO Web Application" (Accuterm for web) and I am the new one for this web application, I want some assistance with the application My question is how will I use GUI designer on AccuTerm IO I am attaching the screen shot of error message. ------------------------------AzarRocket Forum Shared Account------------------------------

hi, I'm using Rocket MV BASICv2.2.0 and I edit a simple include item to declare equates. When I try to format ; it scramble my lines ...  what's wrong ?  I attach the item IN_SPO.txt and my format.json settings Thanks for any help.

We're pleased to announce the availability of UniObjects for Python (UOPY) v1.3.0 on October 12, 2023. UniObjects for Python offers many benefits including:•    Provides remote access to MV servers in Python, great for your developers who don't know BASIC•    Offers full stack development in Python: from web server (UOPY) to database backend (U2py)•    Ability to leverage the Python ecosystem including many 3rd party libraries•    Enables rapid application development•    Delivers an open and extensible UniObjects client•    Helps attract new development talent UOPY v 1.3.0 enhancements and bug fixes: Enhancements•    We've added a new uoserver_timeout attribute to uopy.Session, which allows the UO server to retrieve the timeout value from the unirpcservice file. This feature requires UniVerse 11.3.5, UniData 8.3.1 or later versions.•    The fileInfoEx method of the uopy.File object now provides more fileinfo details for the UniData server•    From within Python, you can now determine

If you are considering upgrading to Rocket® UniVerse 11.4.1 and use either Rocket SB/XA (all releases) or Rocket U2 Web DE 5.3.0 or below, you need to plan your upgrade to avoid disruption to your System Builder and Web DE applications. Rocket UniVerse 11.4.1 includes OpenSSL 3.0. With the upgrade of OpenSSL, we also disabled unsafe encryption algorithms including: Hashing Algorithms / Message Digests: MD2, MD4, MDC2, WHIRLPOOL, RIPEMD160 Symmetric Ciphers: Blowfish, CAST, DES (DES_ECB, DES_CBC, DES_OFB, DES_CFB, DES_CFB1, DES_CFB8 and DESX_CBC), IDEA, RC2, RC4, SEED Key Derivation Function (KDF): PBKDF1 Both SB/XA and U2 Web DE 5.3.0 (and earlier) rely on disabled encryption algorithms and won't work unless you reenable them. For SB/XA your options are: Enable legacy algorithms (instructions below) Postpone your UniVerse upgrade. We are working on a Hotfix for SB/XA 6.5.7 to upgrade the encryption algorithm used by SB/XA. We plan to release the hotfix before the end of 2023. For U

If you are considering upgrading to Rocket® UniVerse 11.4.1 and use either Rocket SB/XA (all releases) or Rocket U2 Web DE 5.3.0 or below, you need to plan your upgrade to avoid disruption to your System Builder and Web DE applications. Rocket UniVerse 11.4.1 includes OpenSSL 3.0. With the upgrade of OpenSSL, we also disabled unsafe encryption algorithms including:•    Hashing Algorithms / Message Digests: MD2, MD4, MDC2, WHIRLPOOL, RIPEMD160•    Symmetric Ciphers: Blowfish, CAST, DES (DES_ECB, DES_CBC, DES_OFB, DES_CFB, DES_CFB1, DES_CFB8 and DESX_CBC), IDEA, RC2, RC4, SEED•    Key Derivation Function (KDF): PBKDF1 Both SB/XA and U2 Web DE 5.3.0 (and earlier) rely on disabled encryption algorithms and won’t work unless you reenable them. For SB/XA your options are:•    Enable legacy algorithms (instructions below)•    Postpone your UniVerse upgrade. We are working on a Hotfix for SB/XA 6.5.7 to upgrade the encryption algorithm used by SB/XA. We plan to release the hotfix before the en

I sometimes see an error message when trying to re-license after an update (which I've been doing a lot recently to get customers up to 3003). "This web address is for US and Canadian customers of RBC.  Please click OK and click the indicated URL to continue." This is from https://rbc.rocketsoftware.com/authprod.asp.  I usually wait a day or two (but not ten!) and go through the process again and it usually seems to work.  I could be entering the details a different way the 2nd time?  The customers work with the VAR to get the license details, so I'm one step removed from requesting and managing the serial numbers, they just call me when they need help. Anyone else seen this, or have advice on what I'm doing wrong? ------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

I'm posting this to alert anyone who's got large multivalued attributes they may want to sum in AQL. A friend of mine logged a case recently where a correlative using the S() function would hang when the file has any items where the attribute in question has more than 32,768 values. Engineering confirmed that this is an AQL limitation because it's using a 16-bit signed variable to track the value count. This variable is used in many places in AQL, and it would be a huge task to rearchitect. In the course of debugging this, Engineering came up with a workaround by using CALL in the correlative. This not only removed the 32,768-value limit, but it is also MUCH faster. Example of the correlative that hangs (using multivalued attribute 9 in the example): 008 A;S(9) Example of the correlative that works (again using multivalued attribute 9 in the example): 008 call bp sumbal Might be a good idea to fully path the subroutine being called. Example of a subroutine in an account called "orders"

I saw some teasers for 8.2.5 a few months back - is there an online "what's coming soon" for Unidata anywhere?------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

Hello I am hoping someone can help with an AccutermIO query. We are following the instructions..... AccuTerm Release Information V8 and we are trying to create a profile. 2 Profiles already exist, thet were created prior to Rocket aquiring Zumasys. When we create a profile we are not getting a check box display for the Role (admin/dev).  We create the profile anyway, but when we launch Accuterm we get the error No profiles have been created. Please login to Portal and create one.  Can anyone please advise on what we are doing wrong. As an aside, the portal we are using is the Zumasys portal, https://zs-portal.rocketsoftware.com/accuterm, as this is where we were redirected.------------------------------Richard OldsSnr DeveloperCalidore Computer Systems LtdGATESHEAD GB------------------------------

Hello, I have a script to launch the  ACCUTERM GUI application from a shortcut in desktop but when the user closes the GUI application the ACCUTERM session is still active letting the user to play around, so the user has to close again the ACCUTERM session.  We need a script to launch the GUI application and when closing it also close ACCUTERM session so the user gets back to desktop screen.   I tried  the  following script but it is not working: .Output "RUN GUIBP GUIAPPLICATION" & ChrW$(13).WaitFor 0, 8, "o:" .Output "QUIT" & ChrW$(13) I will appreciate any advice. Thanks.

I've been asked this before, but did not have an answer!  On Unidata -- in a dictionary -- to do a multivalue OCONV, the command is SUBR("-OCONVS",X,Y) The question I got asked:   "Why is there a "-" in front of that code?" And I was not sure!  Is that because it's a system function?  It's not actually documented as to WHY -- just that it IS. I just looked over the Using UnIData 8.2.4 doc to make sure it was not something documented. Anyone know for sure what the "-" infers or confers beyond my guess that is means 'this is a built in system command'?------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

Hi all, we have many web aplications invoqued from some users via unirpc, and sometimes we are out of available licences for interactive users, are there a way in universe to limit the number of connections that each user can start? 

This is the second MVX: Performance release focused on improving replication as part of a MultiValue HA/DR strategy.  This release includes a new replication dashboard allowing users to quickly and easily perform replication monitoring tasks to assess, in real time, the health of replication activities. The replication dashboard includes details such as a statistical summary of multiple distributions and identifies the stalled LSN causing a subscription group to stop processing. A stalled LSN has been the number one replication-related support case our customers have submitted. This version of MVX: Performance provides resolution steps without users having to reinitialize servers. The dashboard also displays trend information such as pacing time behind and time to catch up.  In addition, v1.8 features three new replication events: ·        Replication disabled event: generated for one event per distribution if any groups are disabled. ·        Replication down event: generated if repl

MultiValue Experiences version 1.8.0.1347 has been released on October 19 2023 for the below platforms/versions:AIX POWER       7.1,  7.2,  7.3AlmaLinux       8CentOS       7,  8RedHat Enterprise Linux Intel       7,  8,  9Rocky Linux       8Windows       Windows 10,  Windows 11,  2016,  2019This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact rbc@rocketsoftware.com.

Nevermind, figured it out. Apparently this forum is an excellent rubber duck. If some kind soul at Rocket would add SQL.WLONGVARCHAR and SQL.WVARCHAR to ODBC.H that would be very nice.

In the world where OpenDB can write D3 data to (say) an Oracle Table, have any of you had the experience to (for whatever reason) write from Oracle to D3? In other words – (say using the ODBC) - I can use SQL statements to INSERT/UPDATE and DELETE a row; this "instruction" is driven from the Oracle side in order to facilitate a D3 file (record) to be modified (WRITTEN TO / UPDATED / DELETED). How do you deal with the aspect of Multivalued fields – the D3 SQL documentation is a little flaky IMO and there are no real examples of what I wish to achieve and that is to INSERT/UPDATE a value within a MULTIVALUE (defined) attribute. The “safe” alternative is to write to a “normalised” D3 table and then have a function in D3 to sort things out! I'd like to know how you may have solved this in a more elegant manner. Regards Stefano

Hello, I am new to Accuterm and the project I am working on requires a date field. Is there any calendar picker component that could be used? The GUI designer does not provide a component like this. I will appreciate any help. Thanks.

I cannot see how to retrieve information returned from a script into my basic program. For example:SCRIPT  = 'width = Field(WindowPos(0),",",3)'CALL WIN.COMSUB(SCRIPT)how do I get the returned information back into my Unidata basic program?

We have hundreds of desktops running wIntegrate version 6.4.4.  After migrating to RHEL we want to find an easy method to enable SSO for all our desktops with wIntegrate.   We would like to run an automated script (using powershell or something) to update all our desktops so we don’t have to update each desktop individually, but the manual states that you cannot edit the session .wic files with a text editor because the files are in a binary format… that you need to use the wIntegrate Editor to edit the .wic files.  This doesn’t sound like something that can be easily automated. We have experimented with using a text editor (Notepad++) to update a .wic file before, and wIntegrate seems to properly recognize the changed setting... so it seems feasible that an automated powershell script could find and update all .wic files with a new setting.  Has anybody else had success updating settings in a wIntegrate .wic session file without using the wIntegrate editor to comp

I am on Universe. I get the following message when I try to delete a file.  "unable to unlink the operationg ssytem file" then it lists the file name. Then it follows with "DELETE failure". What does this mean and what can be done about it?------------------------------Konson GeeProgrammerLiahona Development SolutionsBonney Lake, WA, United States------------------------------

it comes with openssl 1.1.1n  it is possible to update the openssl version by: replace the version in udt version sym link to another version  update the path so it find the redhat version first some other way/suggestion that I am not aware of and will this break anything in udt? thanks dougc ------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Introduction I've installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorials available that cover this specific scenario?