Rocket® U2 | UniVerse & UniData®

We get asked every now and then where to get the U2 client software.  These include:U2 Clients ODBC, JDBC, UOJ and .NET drivers and associated tools Visual Schema Generator SSL Setup Tool Certificate Management Tool Dynamic Connect Intercall U2 DBTools U2 Basic Developer Toolkit U2 EDA Replication Configuration Tool U2 EDA Schema Manager U2 Extensible Administration Tool (XAdmin) U2 Metadata Manager U2 RESTful Web Services Developer U2 XML/DB Mapping Tool These two packages are all available for public download from RBC | Rocket Software - just choose : Resources  Product Availability Choose the Product and 'Search',  either for U2 DBTools or U2 Clients (these will always show as for Windows, though the JAVA clients are multi-platform) Use the 'Product' link under the 'Downloads' column for the version required - this will usually be the latest version. You will now have options to download the Product - which includes the Documentation - or the Documentation only, All Documentat

i will have to upgrade a universe server and a unidata server in the coming year. i thought why are we running both. when i upgrade the unidata server should i convert it to universe. is it more work than doing the upgrade itself. if so how much more work.

Are there any TCL/command line tools for updating Unidata ODBC configuration ala VSG?  

Well, don’t know how it happened but somehow the ODBC configuration for one of customer accounts has been damaged and they want to restore it to what it was yesterday.  What files need to be restored to get this repaired?

It used to be the VSG, then the MDM, and I can’t find the MDM anywhere these days. What do y’all use for mapping Unidata tables to ODBC?

We are a rather large implementation of Universe 11.3.1 (originally created in the mid-80s as a PI install and migrated to PI Open to Universe over the years).   We have 3 application developers but do not have a traditional UV admin (we don’t modify the uvconfig parameters at all).  The system just seems to run itself.  I have read through Tech Specs & Release Notes but have not found alot of detail on how to or what to look out for.Does anyone have experience in going from 11 to 14?  Any advice or detailed check list?Thank you!

in Basic.  I have a program which calls a RESTApi and returns results and puts it into a txt file.   When I read the test file with another basic program, an INDEX funtion that I need to perform doesn't appear to work (returns zero).  When I put the file contents into a basic variable, the INDEX function works correctly.   I’ve looked at the file for special or non-printable characters which might cause the INDEX function not to work, and the file itself is clean.  What if anything else can I try  (and I’ve tried a bunch)..

HiI’ve come across SYSTEM(49) in a program that I’ve been asked to update.It’s returning a ‘0’ but I don’t know what it is and the documentation I’ve seen does not say anything about SYSTEM(49).Can anyone help with this?Thanks. 

My own explainer of the LOCATE statement and it’s kin. I never felt quite comfortable with it so I wrote out an explanation and various examples which crystallized things for me.https://krowemoh.com/devlog/locate,-insert,-and-delete.htmlSomeone else may find it useful.

Does anyone have an accurate handle on how and when AUTOLOGOUT triggers?   The manual says….Use AUTOLOGOUT to enable or disable automatic logout. With AUTOLOGOUT enabled, UniVerse logs you out automatically if you have not pressed a key within a specified time.But I don’t believe that is accurate.   We’ve had some confusing results in testing.   A process on a loop with periodic TIMEDATE() displays (output only) does not trigger.  Similarly a loop process with no screen output but just a SLEEP X also does not trigger even in between loops before it goes back to sleep.So, we are trying to understand the actual nuts and bolts of how/when it triggers.   Thanks for any help.Steve DouglasVP Systems AdminMBMS, LLC

I’m told that universe support says: . ... they receive very few support cases related to NLS…There are a couple of possible reasons for this, one being that no-one actually uses it. We have code that supports some high-range ascii characters that would otherwise cause problems with the item storage but are looking to test a proper unicode solution. I really don’t want to be the first down this path ;-) Mike

It’s here :  Universe General Knowledge CertificationThis program includes eight individual quizzes to assess your general knowledge of UniVerseWhen you get a passing grade on the 8 subjects, you will receive a Credly badge which can be added to your linkedin or you can print a certificate as well Topics CoveredMV Architecture and Components Universe Terminal Command Level (TCL) UniVerse System Administration Dictionary Definitions and Retrieve UniVerse File Management Indexes and Performance Tuning UniVerse BASIC, Python, Paragraph and PROCS General Understanding of Replication 

Hi everyone, Does anyone know how to make the "Universe Telnet Service" that runs on our IBS Application server, to only use 128bitblock Ciphers, and disable the other lower 64bit block ciphers? The service listens on port 992. The problem is that our Qualys VUN scanning tool is picking up that port 992 is a security risk againstBirthday attacks against TLS ciphers with 64bit block size vulnerability (Sweet32) and goes on to say"Disable and stop using DES, 3DES, IDEA or RC2 ciphers.  We believe that the "Universe Telnet Service" uses OpenSSL that offers out these lower level ciphers, but we have no idea how to to best address this sothat the only ciphers used are 128-bit or higher ciphers. We are waiting on our third party support to get back to us as they have opened a ticket today. Current version of OpenSSL is OpenSSL 1.0.2m-fips  2 Nov 2017, though "Programs and Features" is saying OpenSSL 1.1.1k (64-bit) was installed on March 2021. Universe is 12.1.1 is installed. Thanks in advan

I have a program that creates a Wintegrate pop-up window. Within this window, among other things, I place a picture in a specific location. Currently, the x/y coordinates used to place the picture are based solely on the window it’s self.Problem: the picture seems to move around if I resize and/or move the window. Or worse, if I move the program to a different computer.The solution that I am looking for, is a way to determine exactly what are the x/y coordinates of the upper/left corner of the window as compared to the full monitor screen. This would allow me to calculate exactly where I want to place the picture, within the window, no matter the size or location of said window on the monitor.

Hi all,I’ve been looking looking into what is involved in updating UD and UV systems.  The Universe 14.2.1 installation guide has a link for  the  “U2 Product Availability Matrix” -->  https://rbc.rocketsoftware.com/buildmatrix.asp  Unfortunately, this takes me to a dead-end with “This rbc.rocketsoftware.com page can’t be found”.  Where can I find this document?Thank you,Jonathan WellsAptron Corporation

Hi everyone, I’m attempting to install the UniVerse Personal Edition version 14.1.1 on MacOS Tahoe 26.1 on an M1 Macbook. I’m following Rocket’s official PDF (see attachment) on how to do this via a Docker container and using the supporting files from their Github: RocketSoftware/multivalue-containers Because I’m on Apple Silicon, I adjusted the Dockerfile as follows:Replaced the original FROM to force AMD64 emulation since I’m on ARM:FROM --platform=linux/amd64 rockylinux/rockylinux:latestI also added this to fix a permission error that occurs.RUN chmod +x /usr/local/bin/*uv.sh Now, I consistently hit a segmentation fault in the installer during the init_uvsm step. Below is an excerpt of the output logs where the error occurs after running docker compose up:universe-server  | universe-server  | Starting UniVerse...universe-server  | UVSMM is started.universe-server  | Starting uvsm...universe-server  | /usr/uv/bin/uv.rc: line 562:  3654 Segmentation fault      $uvbin/init_uvsm $init_u

Check out the newest short on the from us here at learn.rocketsoftware.com This short is a simple How-To on uopy.    It explains how to load and use the uopy module and the main classes and functions within it. UniObjects for Python short

Does anyone on the forum, have any information concerning Rocket U2 Application Developer Certification for new developers. This would include coursework, exams, etc. I have not been able to find anything on Rocket’s site concerning that topic.   Thank you in advance.

Is there a log of phantom processes and pids anywhere?I have a job scheduler that runs as a phantom and executes jobs from a table at certain times.I’m having an issue in my scheduler where it appears to run the same task multiple timeson a random basis (ie some days it is just fine, other days  I will see that same job runs multiple times instead of once).   I haven’t been able to figure it out and I was hoping that there was a log somewhere that I could look atthat showed what processes have been started as phantoms.On Universe 11.3 

I have an evaluation copy of universe.   I had created a separate account, created a file with a dictionary, and then attempted to create an index.   What I got is below.   Just wondering if there is something else to be set up, or a permissions issue, or if the evaluation copy doesn’t allow it.   Thank you.>CREATE.INDEX MASTER.TABLE FIELD1 NO.NULLSAttempt to create index directory "C:/U2/UV/RICKDEV/I_MASTER.TABLE" failed.>.L RELLEVEL     RELLEVEL001 X002 11.4.1003 PICK004 PICK.FORMAT005 11.4.1 This is a windows version.

Hi. Below is the version of our product. Are we allowed to use the Rocket MV Basic in the Visual Studio Code to compile the program?Secondly. i try to enter the following infomartion in MV basic,  what is the account name mentioned below  Current Configuration PRODUCT EDITION VERSION QUANTITY OS TYPE OS VERSION SUPPORT   UV SVR 11.2.5 137 HPUXITANIUM 11.31 Active     SBR SVR 5.5.0 137 HPUX ALL Active     SBC SVR 6.6.3 20 WINDOWS 2022 Active    

Hi!I’ve started to tinker with the Universe database of my company using uopy that allows me to run basic commands from a remote server.Is there a book or a formation to learn this basic?Asking AI I’ve been able to list the data of a file, but I would like to filter it by date. What is the formula?Thanks!

Trying to build and index and getting this error:04 BUILD-INDEX LOTIndex name:  SER#Locking 'LOT' file for exclusive use.Index file "INDEX.004" for key "SER#" is locked.  Aborting.File 'LOT' Unlocked. How can I unlock that index so  I can build it?