Rocket MultiValue

We have a number of distributed files that are keyed off an internal date in the key. So, every year, we need to create new part files and update the @PART.ALGORITHM.  I think this year will push the count to over 80 part files across about a dozen distributed files. I've inherited the existing process, but I wanted to see what other folks are doing, or if there is an established "best practices" for adding new part files to a distributed file. We're running UV11.4.1 on RHEL8, if that makes a difference. v/r Ray------------------------------Raymond DeGennaroUV/D3 DBAUnitedHealth Group IncBelvidere IL US------------------------------

Hi there, Our community member, Olivia, has posted a message in the "General Discussion & Announcements" channel, inquiring about Rocket UniVerse. You may find her message here. Could someone assist her in finding the right answers in her original thread? Thank you!------------------------------Martyna UleviciuteCustomer Community Managermuleviciute@rocketsoftware.com------------------------------

Hi all I'm trying to replicate some legacy code using uopy, but I've found an issue that's hard to solve. This is a LONG process, both server and local side, so timeouts may appear. Using the older UVIC32.dll code we can simply reconnect to a session after it has been closed by the server. But, after health_check returns false to uopy I can't reconnect to the server, and the connect() method is not connecting. Is there a way to do this?

Edit for posterity: Windows 11 runs Viaduct just fine. I'm not sure what went wrong on the first install, but after uninstalling and reinstalling it works. Have also installed on a second PC, which is also running fine. Our office uses Viaduct 2000 installed on Windows 10 to access the D3 instance on the server. I know there's newer and better emulators out there but it's always worked for us and we've never had a need to for anything else. With W10 support coming to an end and needing to upgrade to Windows 11, I tried installing Viaduct on a PC with Windows 11. It installed fine, but when I try to open it, it just has an error message.  My question is, are any of you running Viaduct on Windows 11? I'd like to hear that it's possible before spending a bunch of time trying to troubleshoot my issue. ------------------------------Steve AkhurstAccounts PayableSpecialty Toys Direct IncBURNABY BC CA------------------------------

Hey All, I'm trying to create a python script which can be called from a BP program (use PyCallFunction or the like) which will log to fluentd. I have something which works on the first run of the BP program, but crashes on the second call. To replicate you don't need the BP program, the following will do, from TCL ``` PYTHON from fluent.sender import FluentSender sender.emit('uv', { 'level': 'info', 'message': "hello"}) sender.emit('uv', { 'level': 'info', 'message': "world!"}) quit() PYTHON from fluent.sender import FluentSender sender.emit('uv', { 'level': 'info', 'message': "hello"}) ``` The error is ```   File "/home/u2dev/lib64/python3.11/site-packages/msgpack/__init__.py", line 36, in packb    return Packer(**kwargs).pack(o)           ^^^^^^^^^^^^^^^^TypeError: 'NoneType' object is not callable ``` It looks like on the second go round msgpack can't import Packer for a .so file. I've tried setting REINIT.PYTHON OFF, but no luck. This is on UV 11.4.1 and my python requirements

Question on EDA - from someone outside of/new to the Rocket Community....(excuse the rookie knowledge/terminology)1. Are there any good/bad practices around the handling I-types in EDA ie pros/coms 2. How does EDA handle changes in i-type definitions / changes to subroutines and/or changes in data that subroutines access - ie does the tool/dtabase automatically identity changes , or does the field being converted have to be reinitialised in some way + what is say the downstream impact of replicating a field change in a table of a million records------------------------------Mark MosbauerProject ManagerRocket Forum Shared Account------------------------------

Hi all, i wonder if someone ever have tried tu build a GUI-Screen in SBclient with TU.FORM.LOAD / TU.FORM.ADDOBJ. We are thinking about of doing this because using the gui-form painter is a pain, but in the newer SBXA documentations all of these subroutines are missing and therefore this may be a bad idea. what is  your opinion about doing this. best regards Thomas ------------------------------Thomas LudwigSystem Builder DeveloperRocket Forum Shared Account------------------------------

Good Afternoon Group, I have an issue with SB/XA.   It is telling me that it "Couldn't create pbclass object FK2.  Object name already in use.  405, SBWIN_99_6*FK2".    (Actually image is attached, below.) I have 2 buttons in my GUI screen.   I know that the F2 is normally "Save" and F4 is normally "Delete".   In my case, I'm using the F2 key as "Generate" and the F4 key as "Exit".    I have used this methodology in the old SB+, but we are going start using SB/XA 5.5.4.  This "issue" is from SB/XA. Can anyone offer any advice or guidance on how to get rid of this?   I have deleted the button and re-inserted it, but to no avail.   The interesting part, the F4 is just fine. Thank you for your time and consideration.   I will be looking forward to any and all feedback. ------------------------------Grant BoicePrincipal Software DeveloperMatheson Tri-Gas Inc.Warren, NJ 07059------------------------------

Hi Team,  I have written a sample program to update the data file. PROGRAM UPDATE.DATA.DRV * Declare variables     CUSTOMER.ID = ""     NOTE = ""     RECORD = "" * Get the CUSTOMER ID (2nd word from the sentence)     CUSTOMER.ID = FIELD(@SENTENCE, " ", 2) * Get the NOTE (3rd word and onwards from the sentence)     NOTE = FIELD(@SENTENCE, " ", 3, LEN(@SENTENCE)) * Strip double quotes if present     IF NOTE[1,1] = '"' THEN NOTE = NOTE[2,LEN(NOTE) - 2] * Open the CUSTOMER file     OPEN "CUSTOMER" TO CUSTOMER.FILE ELSE         PRINT "ERROR: Unable to open CUSTOMER data file."         RETURN     END * Read the record for the given CUSTOMER ID     READ RECORD FROM CUSTOMER.FILE, CUSTOMER.ID ELSE         PRINT "ERROR: No record found for CUSTOMER ID: ": CUSTOMER.ID         RETURN     END * Update the NOTE attribute (assuming the note is in attribute 2)     RECORD<2> = NOTE * Write the updated record back to the file     WRITE RECORD ON CUSTOMER.FILE, CUSTOMER.ID     PRINT "CUS

We noticed that our upload program, which utilizes SubmitRequest was timeing out.  We increased the value from 100000 to 400000 and it still timed out at 100 seconds. Seems like the increased variable should have changed the outcome.  Any ideas? httpTimeOut = 400000    contentType = "application/json; charset=utf-8" result = createSecurityContext(security_context, "TLSv1.2:Min")       if (result = 0) then          result = createSecureRequest(postURL, postType, req_handle, security_context)          if (result = 0) then             result = setRequestHeader(req_handle, "Content-Type", contentType)             if (result = 0) then                if (token <> '') then                   result = setRequestHeader(req_handle, "Authorization", "Bearer ":token)                end                result = submitRequest(req_handle, httpTimeOut, postData, respHeaders, respData, httpStatus)                output = respData                if (result = 0) then … ------------------------------

Good Afternoon Group, I have an issue with SB/XA.   It is telling me that it "Couldn't create pbclass object FK2.  Object name already in use.  405, SBWIN_99_6*FK2".    (Actually image is attached, below.) I have 2 buttons in my GUI screen.   I know that the F2 is normally "Save" and F4 is normally "Delete".   In my case, I'm using the F2 key as "Generate" and the F4 key as "Exit".    I have used this methodology in the old SB+, but we are going start using SB/XA 5.5.4.  This "issue" is from SB/XA. Can anyone offer any advice or guidance on how to get rid of this?   I have deleted the button and re-inserted it, but to no avail.   The interesting part, the F4 is just fine. Thank you for your time and consideration.   I will be looking forward to any and all feedback. ------------------------------Grant BoicePrincipal Software DeveloperMatheson Tri-Gas Inc.Warren, NJ 07059------------------------------

Hi A strange behavior, we have a subr WI.LOG which call another subr GET.PORT which make a simple OCONV(0,'U50BB') U50BB run fine million times a day.  Sometime the session seems 'suspended' and PORT. STATUS LAYER STACK return GET.PORT at 0x000000000 !  After a while, the system continue... I suppose its a lock situation ! Semaphore lock ?  Is someone experience a subr call 'stopped' like this ?  Adress 0x000000 is strange ?  Thanks for any comment.  Manu BASIC run machine GET.PORT 0x00000000 BASIC run machine WI.LOG 0x00000028

Had a case today where the mvBase 3.3.2 installer would not run on a Windows 11 box. They were trying to install the workstation component. The installer just hung and never made it to the Welcome screen, even though they "ran as administrator" but not logged in as an admin user. We fixed the issue by logging onto the Window 11 box as the local administrator. Then everything ran fine. This is a gentle reminder to ALWAYS be logged on as a local admin user when running the installer. ------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

Rocket® D3® – Looking to the Future Rocket MultiValue (MV) recognizes the essential role D3 plays in supporting the success of our customers, and we deeply value the trust and loyalty of those who use it. We are committed to supporting D3 with ongoing updates and fixes as part of the MultiValue product family of application servers. D3 in 2024 In March 2024, we released D3 10.4 for Windows, delivering the value and supportability that D3 customers expect. With D3 10.4, Rocket MV engineers refactored the underlying code enabling them to align the Windows and Linux platforms and facilitate seamless releases in the future.  D3 10.4 also includes upgrades to Python, along with over 25 enhancements and bug fixes, further improving performance and stability. D3 in 2025 In 2025, we’ll make additional enhancements to D3 10.4 to further align the Windows and Linux platforms making it easier for Rocket to release and maintain D3.  Additionally, we will include high-value, customer requested enha

Hi, actually I only use VS Code with MVVS to program in Universe, and I found it amazing. I am now starting to develop in D3 and jBASE, but found out that these two databases are not supported in MVVS.    Are there plans to add MVVS support for D3 and jBASE? That would be really great!   Regards,   Enrique Murphy------------------------------Enrique Ignacio MurphySoftware EngineerAleator SRLArgentina------------------------------

MVS Toolkit versions 2.2.3.121 and earlier required activation. We no longer have the ability to activate those versions. If you are running an older version, we highly recommend that you upgrade. If you decide to continue to run on the older version, at least make sure you have a current Web Service Export just in case your Toolkit installation breaks and you are forced to upgrade. A Web Service export is much like a Pick file-save: Hopefully you never need it, but if you do, you'll be glad you have it! Upgrading the MVS Toolkit has more benefit that just removing the need for activation. The older Toolkit versions use Jetty and Java versions that have been deprecated because of security issues. If you have questions or need help upgrading, please contact Rocket D3 support.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

We are running SB 5.5.3 and we frequently end up with orphan port assignments in DMSECURITY. We were advised to use the RELEASE.LICENCES process to make the ports in DMSECURITY available. However, it seems that the process is not treating the phantom processes correctly, it determines that these are orphan and releases them. The consequence of this is that when the phantom completed and tries to reschedule itself, it fails. We end up with a shortage of licenses, when we actually have licenses available, the message the users are getting is the following: Has anyone ever experienced this before and if so, how did you deal with it. Upgrading to a newer version of SB is not an option. Thank you. André Guindon

We are looking for help to automate our testing of Universe programs on Windows. What tools are available, what do you use to test your code? I'm aware of mvTest from Mr. Leach which looks promising.  Thanks in advance.------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

I have a statistics program that builds an array with <1,POS>= sku and <2,POS>=qty.  The output would often have 8-9k SKUs. When I dump it out to a sequential file, I want to output the data as  a sinlge row for each sku in the format of SKU:<delimiter>:QTY I know I can do this programatically using a for...next loop, but wondered if ther was a quicker/built-in way to do this? Nelson ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Hey, I am migrating our codebase from Java to Python but when using the same parameters I am unable to get a connection to the Ellucian database.  Any help with troubleshooting this is appreciated!! My code is: import uopy ses = uopy.connect(hostname='databaseURL', user='databaseUser', password='databasePassword', account='databaseAccount') cmd = uopy.Command("LIST STUDENT.TERMS") cmd.run() print(cmd.response) and my error is: "/Users/adam/Documents/Developer Workspaces/python/.venv/bin/python" "/Users/adam/Documents/Developer Workspaces/python/Uniobjects for Python/helloworld.py" (.venv) adam@A010503 python % "/Users/adam/Documents/Developer Workspaces/python/.venv/bin/python" "/Users/adam/Documents/Developer Workspaces/python/Uniobjects for Python/helloworld.py" Traceback (most recent call last):   File "/Users/adam/Documents/Developer Workspaces/python/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 152, in __init__     self._socket = socket.create_connection((host,

Recently we completed an upgrade from Red Hat 7.9 to 8.10 and UniVerse 12.1 to 12.2.1 on our development machine, which was successful. However last night we attempted the same task on our production server and ran into an issue with printing. While we were conducting checks after the OS upgrade but before the UniVerse upgrade we found that printing from UniVerse had stopped working. Printing from the OS level continued to work as normal, all other UniVerse functions appeared to be operating normally also. In the Extensible tool it appeared that the spooler was running initially but after a few minutes we started to get messages like the screenshot below "SH: /usd: No such file or directory " and "The spooler daemon is not running" All of the printer devices appeared correctly in the extensible tool and uvadm menu. Trying to start the spooler form the uvadm menu we received an error like the one below as well. Naturally we tried restarting the system several times, and looked at permis

Hello everyone, i'am updating my server hardwarei'm going to have 256 GB , processor 40 cores, i have 128 users, and my D3 base current has 293 GBthis is my current pick0, what settings i should change for the new configuration D3 10.2 Linux name LINUX pick0nice 0user pickcore 77165824 10npibs 700nphts 120basic 0brkchr 00escchr 1babsbase 18abssize 708abslock onblkfid 4flush 10dwqnum 256clocal offrawdisk onflushers 4

I have a file trigger when a record is updated it writes information to another file to update UPS tracking in an order file. If I use a SQL statement in Universe to insert the record I get a permissions error (Program "UPSTRACK.TRIGGER": Line 81, FATAL:The locks necessary for database operations at the current isolationlevel (2) are not held by this process.) If I add the item through ED it works fine updates all the files and adds the new record. Are there different levels of permission when execute SQL from TCL vs. ED?Thanks JR Moore------------------------------Jr MooreIT Special ProjectsAuto Parts WarehouseHillsboro OR US------------------------------

I've posed this as it is based on technote that I've wrtitten and the code was written based on a customer support case and I thought other customers may find it useful. The example usage is with the _PH_ file. The code will work for both UniVerse and UniData. The following example is based on the UniData _PH_ file but can easily be transferred to any other directory type data file you wish to report on.Create the following dictionary items. DATE.MODISUBR("GET.FILE.DETS","_PH_",@ID); FIELD(@1," ",2)D4/Date Mod10RS TIME.MODISUBR("GET.FILE.DETS","_PH_",@ID); FIELD(@1," ",3)MTSTime Mod10RS FILE.SIZEISUBR("GET.FILE.DETS","_PH_",@ID); FIELD(@1," ",1)MD0,File Size10RS Then use the CD command to compile the new dictionary items. Create the GET.FILE.DETS program as below (or see the attachment) $IFNDEF U2__UNIVERSE$BASICTYPE "U"$ENDIFSUBROUTINE GET.FILE.DETS(FILE.DETS, FILE.NAME, K.FILE.NAME)$IFDEF U2__UNIVERSE$OPTIONS INFORMATION$OPTIONS -INFO.LOCATE$ENDIFFILE.DETS = ""IF FILE.NAME = "" THEN

We are running SB on UniData on Linux.  There is a command in SB called LISTU.  It beings back: Port, Pid, Account Name, SB+ User, NT User, Login Date/Time Questions are: 1) Where does it get the Account Name?  I have found this to not be 100% correct, but still want to know. 2) Where does it get the SB+ User?  Again, this is not always correct, so what is it doing?