Browse all forums dedicated to the Rocket MultiValue product family.
Recently active
Hi, I've been trying for a few weeks to get MVVS to work with Online Editing. I'm able to log on to my server and see all the different accounts and their files; however, when I try to open up a program, I get an error message saying the file could not be found. Further inspection into the logs revealed that there is an error with XToolSub. The error is U2 XToolSub logon account exception, {oldAccount: TESTACCOUNT, newAccount: XDEMO com.rs.mv.mvvs.common.exception.MvVsException: failed to logto account Is there something that UV admin has to do to allow for the logto to succeed? Any help would be appreciated.
Are there any plans to add JIT privileged access management to Accuterm for Linux in the future?
When doing REST calls with MVIS, I understand how the u2version field works, get it when you read, and then send it back on updates so that MVIS can know if the record has been updated since you read it, implementing optimistic locking. Wondering if there is a function that can be called from U2/PICK Basic to generate this same value manually. We are working on some custom PICK code to read/write data in response to MVIS calls. We'd like to use the same concept with the u2version field but calculated via PICK code on a certain item in PICK/U2. We'd like to be able to generate this field manually for reads and then verify it on updates. Should only add a couple lines of code to our existing routines if there is a way to easily do this from PICK. Looks like maybe the CHECKSUM function would do this, just wondering if this would generate the same value as MVIS u2Version. EDIT: After doing some experiments with CHECKSUM looks like we might be able to do
Hello everyone. I am new to the forum and have just upgraded to UniVerse 11.3.5. I was told there is a tool MVX (Multivalue Performance Experience) that can be installed and was hoping to find out if anyone is currently using this tool. I would like to know more about it, before I decide on whether or not to install it on my system.
I'm trying to format the following lines: $INCLUDE ../T24_BP I_EQUATE $INCLUDE ../T24_BP I_COMMON $INCLUDE ../T24_BP I_F.CUSTOMER $INCLUDE ../T24_BP I_F.COMPANY And I get as result: $INCLUDE . . / T24_BP I_EQUATE $INCLUDE . . / T24_BP I_COMMON $INCLUDE . . / T24_BP I_F.CUSTOMER $INCLUDE . . / T24_BP I_F.COMPANY Any way to exclude spacing for a path? Or add a parameter in format.mvbasic.json to allow ignore formatting for some lines?Ex. specify ignore formatting regex pattern:"ignore.format": [ ".*$INCLUDE.+", ".*$INSERT.+"]
Accuterm GUI when you define multiple columns in your drop down list. Is there a way to wrap the text in a column by separating the multiple lines in that cell with some character. I have tried char(10), char(13), the pipe symbol. I am trying to get this to work like "word wrap" in a grid. In the third column I have multivalued data, that I would like to wrap in each cell. Can't find anything in the manual to give me a hint.
I recently was part of a discussion regarding the use of parenthesis with a SELECT statement. My understanding was that parenthesis were not evaluated with respect to AND and OR logic. Is that correct? Looking in the online documentation, the only mention (that I could find) regarding parenthesis use was in relation to OPTIONS. Specifically the the open parenthesis indicated the beginning of an OPTIONS clause and that a close parenthesis could be used to end the clause and that the OPTIONS clause should always be at the end of the statement. If that is the only allowed use for parenthesis then: Why are parenthesis allowed to be used at all in a SELECT statement as follows:SELECT FILE WITH 1 EQ "ABC" AND ( WITH 2 EQ "123" OR WITH 3 EQ "XYZ" )This command executes without an error? Using a file with the following records: TEST..... A1....... A2... 100 A 1200 A 2300
I am trying to create a new distributed file. I am on a Linux Red Hat version 7 running universe 11.3.5 I tried running this command DEFINE.DF DATA CSA.TRIPPER.CENSUS ADDING CTC1 1 CTC2 2 CTC3 3 CTC4 4 CTC5 5 INTERNAL PARTNOUnable to open DICT "". CSA.TRIPPER.CENSUS is a type 18 file that has existing data. I created the CTC1 - 5 files all type 18 the PARTNO is in the DICT of CSA.TRIPPER.CENSUS 0001: I0002: MOD(SEQ(@ID[LEN(@ID),1]),5)+10003:0004: Partno0005: 6R0006: S When I list CSA.TRIPPER.CENSUS PARTNO the part number is listing 1 through 5 1276225 4 1730044 3 2032590 4 2183863 2 2637682 1 2940228 2 3091501 5 3394047 1 What am I doing wrong? Jon Card Combined Transport
Wise ones, Is there a way to prevent UDOWrite converting large numbers into scientific format? For example: PROGRAM temp $INCLUDE UNIVERSE.INCLUDE UDO.H Value = 1234567890.123Ok = UDOCreate(UDO_OBJECT,hObject)Ok = UDOSetProperty(hObject,'large', Value)Ok = UDOWrite(hObject, UDOFORMAT_JSON, JSON)Crt JSON STOP { "large": 1.234568e+09} I can't make it a string as that will fail the JSON schema validation. Integral numbers are not affected by this so I could INT() it, but that's not really a solution. Thanks
There was a wIntegrate update planned for early 2024, but it appears that didn't happen. I see now a "committed" update, v 6.3.5, for August 2025. Where can I find information on what's included in the update? Oops, sorry, I meant there is a committed update version 6.4.5, that is scheduled for August 2025.
I'm interested if anyone uses NFS to store account data remotely, with something like Netapp Files:https://learn.microsoft.com/en-gb/azure/azure-netapp-files/network-attached-storage-protocols.In my own research of documentation I can see the following:[The ALLOWNFS] parameter should only be turned on in the following cases:- When UniVerse is not running or not installed on the remote system. File integrity is compromised when locks are not maintained on the remote system.- When the system administrator does not allow other UniVerse installations to gain access to the same remote UniVerse files at the same time.So this would seem to indicate we are OK. I think I need to clarify: does local Universe locking still apply when ALLOWNFS is in use (and does this depend on the locking provided by NFS - because capabilities/implementations differ from version to version).
The Universe UDO... functions handle UDOFORMAT_XML and UDOFORMAT_JSON just fine. Is any effort in progress to extend them to UDOFORMAT_YAML?
Running UD 8.3 on AIX with plenty of disk space. I have a number of large files (10M-50M) records that I want to re-size to improve overall performance, but more importantly, prevent any file corruption due to any file re-sizing activities. I am trying to find out what is the optimal number of records that each group should contain: 1- Is there a recommend number of records per group (keep it under 20 or a certain number)? This will allow me to properly size block and modulo. 2- Should I keep increasing size of the block until I have zero level 1 overflow, which means ignore number of records per group? Albeit I managed modulo size in conjunction with block size. Any insights or recommendations is greatly appreciated. Thank you
After performing an upgrade from UniVerse 12.1 to 12.2.1 - we receive the message "Your VOC is out of date. Update to current release (Y/N)?" on the initial LOGTO on each account. Is there a way to just complete these VOC updates en-masse for all accounts? Your VOC is out of date. Update to current release (Y/N)?Y Your VOC is configured for PICK compatibility Updating your "VOC" file. (Each "*" = 10 records) *********************************************************** **** 6 item(s) were removed from your VOC file and placed in file "&TEMP&" to prevent them from being overwritten. Updating your "D_VOC" file. (Each "*" = 10 records) * 11 item(s) were removed from your VOC file and placed in file "DICT &TEMP&" to prevent them from being overwritten.
When attempting to use uopy 1.4.0 with Python 3.12 on Mac OS X Sequoia 15.4.1 (Apple Silicon) I get the following exception when trying to connect to a Universe server: File "*redacted*/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 159, in __init__ self._socket.setsockopt(socket.IPPROTO_TCP, socket.TCP_KEEPIDLE, 1) ^^^^^^^^^^^^^^^^^^^AttributeError: module 'socket' has no attribute 'TCP_KEEPIDLE'. Did you mean: 'TCP_KEEPALIVE'? The above exception was the direct cause of the following exception: Traceback (most recent call last): session.connect() File "*redacted*/.venv/lib/python3.12/site-packages/uopy/_session.py", line 268, in connect self._rpc_connection.connect() File "*redacted*/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 105,
I have just loaded python3.13 and flask onto my rocky 9.5 system. The system already has python3.9 as part of the rocky linux. I have just installed idle3 wanting to use it to work with python3.13 and flask but find that it connects only to 3.9 where I do not have flask. Does anyone know a way to either modify idle to connect to my 3.13 version or is there any way to get the "dnf install" to load it into my 3.13 directory structure? I prefer to use idle instead of the plain 'ol text editor. Thanks, Dale
Hi, I'm new on Unidata. Right now our company is using Manage 2000 with Unidata RDBMS 8.2 version. My question is, is it possible to open my unidata database to SQL Server Management Studio, how? If it's not possible can I create a view on SQL Server Management Studio containing all the data from my unidata database, how? I already created a view file and successfully compiled it but I can't still see it on the SQL Server Management Studio. I also created a link server on SQL Server Management Studio using the U2 ODBC.
Greetings Fellow Members! My co-worker and I have a issue with SB+ that we are banging our heads because we cannot find a solution. Below is a snapshot of the problem As you can see, our "PTEXT" is not getting opened, here. However, this is happening with other files, like our "HELP" and "DEFN" files. Almost all of are users are using GUI, but this has popped up with one or two users who use the Character mode. To make this more interesting, the following could happen: This doesn't happen all the time. When the user clicks on the "Continue" button (Sometimes they have to hit the "Continue" button multiple times), the error message eventually goes away. Lock up their session and need to kick the user out. I have checked the VOC pointers and they are correctly pointing to the correct data files and dictionaries. We believe it is coming from our SB+ interface and/or other processes. &nb
Good morning everyone, We have an issue with a TRANSACTION COMMIT failing with a STATUS = 3. The Unibasic subroutine containing the TRANSACTION START/COMMIT code is called from the outside as a web service. This failure is intermittent. What can cause the STATUS code = 3 ? Thank you in advance. André Guindon
Hi, Does anyone know if there's a function in "Universe Basic" to get the cursor position (row and column)? Thank you very much.
example of code: REQID STIND OF 8 DIGIT REQUEST NUMBERS, IE . 12345678 GTC1=LITERAL FILEIN = /main/submain/submain/DESTINATION/REQID:".GTC1" THE FILE DOESNT EXIST TO START When i run this program as a standalone is works perfectly. When i run this program as a PHANTOM it takes both else clauses OPENSEQ FILEIN TO OUT.FILE ELSE CREATE OUT.FILE ELSE MSG = "CANNOT CREATE ":OUT.FILE CRT MSG STOP END END RUNNING ON REDHAT LINUX 8.10 UNIVERSE REL 11.4.1.6020 PERMISSIONS HAVE BEEN CHECKED USER:GROUP ARE CORRECT any help would be greatly appreciated
No supported signature schemes exist SSH. I know that upgrading these to 8.1.2 corrects the issue, but we have over 200 installs of AccuTerm that we need to upgrade, but would like to upgrade Solaris first. Any solutions?
Hi all, i have a bit of an issue with U2 ODBC trying to connect to uniVerse DB. I installed (at the then time v530 of client tools (ODBC 64bit) onto a workstation and then i was able to connect to the DB and query. Since then i have installed ODBC tools onto another workstation/pc/server (both on premise and within Azure) and completed the same setups i did previously but on these they do not work. i keep getting the same error message (as shown at the bottom of this post) i cannot use the existing workstaiton/PC as that client is not the one i will be completing the connection from when in prod (as it is my workstation used for testing) and also cannot use as unirpc is locked down to specific IP (the new workstation/PC i want to use in Azure). With this being said, if i try to install ODBC onto another workstation, same result, doesn't connect. i am using both the ODBC Tester from the ODBC tools and the Test Connection option from windows (ODBC Data Sources 64-Bit) after creat
I inherited an old MVBase system running on windows. I tried SH and CMD and cannot shell out. Is this possible? Also, I would like to make a file pointer to a directory in windows. Is this possible? I found that I can use a UOPEN to open an os file and write to a file.
From the udt.errlog, the output of a deadlock warning: I can understand most of this, but what does PICK REC mean in this context?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.