Rocket® U2 | UniVerse & UniData®

A Collaborative Hub for Modernization and Big Ideas We're excited to launch the Rocket MultiValue Innovation Library - a dynamic, shared forum where MV developers, architects, and innovators can showcase and exchange forward-thinking ideas, prototypes, use cases, tools, and more. This is your space to Share groundbreaking concepts Contribute working demos or prototypes Explore real-world use cases Collaborate with the broader MV community Whether you're looking to modernize legacy applications, experiment with new integrations, or simply spark inspiration, the Innovation Library is designed to accelerate innovation across the MV ecosystem. Join us in building the future of MultiValue — one idea at a time. Start exploring the Rocket MultiValue Innovation Library today — and be part of shaping the future of MV development. ------------------------------Christine RizzaManager, MV Product ManagementRocket Softwarecrizza@rocketsoftware.com------------------------------

Greetings folks! Is anyone on this forum doing any work in Python?  Are you converting current source code into Python? THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Hello - I am converting our spooler programs to linux. We use the 'c' record of cups for the job info. The 'd' record stores the data of course. Here is the setptr we are using... SETPTR 0,132,60,0,0,1,AT temp,BRIEF,BANNER KH,EJECT,COPIES 1,"-s" But on linux, using strings (or 'cat') I am not seeing the 'KH' banner text. CREC=attributes-charsetþutf-8Hþattributes-natural-languageþen-usþprinter-uriþ!ipp://localhost:631/printers/tempBþjob-originating-user-nameþkhambricBþjob-nameþcopiesþfinishingsþjob-hold-untilþno-hold!þjob-priorityþjob-sheetsþnoneBþnone!þ    number-upþjob-uuidþ-urn:uuid:b94d739f-56c3-3cfa-60d2-c870b1742125Bþjob-originating-host-nameþ    localhost!þtime-at-creationþhT5,þtime-at-processingþtime-at-completedþjob-idþ    job-stateþjob-state-reasonsþnone!þjob-media-sheets-completedþjob-printer-uriþipp://linuxdev/printers/temp!þjob-k-octetsþdocument-formatþtext/plainþ on Unix (using 'cat') it is stored like this: CREC=Hh50þPkhambricþJtemp-5842þCþLkhambricþA0þBKHþOþK1þT/util/tm

I have U2PY application in my UniData environment.  It is running on AIX. How can I deploy to run as a Phantom in the background? I need the U2-Python application to listen to incoming data on a TCP/IP port.------------------------------Pedro SantosAPI | U2PY | UniData Developer------------------------------

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

Is there a way to allow the database access to more RAM? Our Universe/Windows instance only consumes about 24GB of the 128GB it has installed. THX! ~Doc ------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Has anyone tried querying Unidata on Linux using either PowerShell or Python? If yes, any suggestions or tips that you can share?------------------------------Gregory HernandezSenior Systems ProgrammerDesales University------------------------------

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

Howdy, again, folks! We experienced an outage yesterday associated with tl_server.exe. We must be running some knock off version.  The system says we are running 11.3.1.6032, but Rocket only shows the last release as .6023  which was released in Feb. 2019.   Since that date, there has been a 11.3.2, 11.3.3, 11.3.4, 11.3.5, 11.4.1, 12.1.1, 12.2.1, and now 14.1.1 We would like to update but are looking at the following constraints: Constraints: Version 11 ended support on 9/1/2024 and fully expires 9/1/26 and will no longer be supported at all... Version 12 did not work... we are searching for documentation that would provide details Version 13 was not released. Version 14 is released and we are looking into upgrade process. Are there any contributors who might share their upgrade experience?  Anyone on version 14 and how it's performing? THX in advance for your always helpful responses! ~Doc ------------------------------Doc RuckelPart time programmerRocket Forum Shared Account--

Is there a limitation on the number of UV  phantom processes that can run simultaneously on a Windows platform?  I seem to recall there is but I can't find any documentation for it. Thanks in advance.------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

Hi all I'm creating a lot of tools using Python and version control is getting quite out of... control. So I'm starting to create a folder infrastructure inside PYPROGS to manage the different tools and keep their basecodes separated. My problem/question is:How can I manage the subfolders in PYPROGS? For example, I have some files organised like this: -U2DBLiveDMS |-u2dblive.py |-u2dblive_common.py -aws_boto3_context_manager.py -aws_file_delete.py -excel_utils.py I can check my files using uopy: with uopy.connect(**config): cmd = uopy.Command("SELECT PYPROGS") cmd.run() select_list = uopy.List() self.__lista_ficheros = select_list.read_list() rgx_cksum = re.compile(r'[Cc]ksum\\s+=\\s+([0-9]+)\\s+') for f in self.__lista_ficheros: if f.endswith('.py'): chk = uopy.Command(f'CHECK.SUM PYPROGS {f}') chk.

We have Universe developer opportunity at Advantive. If interested please click the link below. https://www.advantive.com/about/careers/ ------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

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).

Good morning folks! How are VOC items created?  Compile/Catalog?  Are there any other files in UniVerse where executable items exist? THX in advance for your always helpful replies! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

The Universe UDO... functions handle UDOFORMAT_XML and UDOFORMAT_JSON just fine. Is any effort in progress to extend them to UDOFORMAT_YAML?

Hi all We have an environment with several users running concurrently. This works fine, but I'm having trouble when several users try to run Python code concurrently. This is my UP NOMBRE.SCRIPT='excel_utils' NOMBRE.FUNCION='leer_excel' PATH.REPOSITORIO='/u2/quiter/CONTA5/REPO.FILE/' FICHERO.EXCEL='Fichero Extracontables a integrar BR LEAPMOTOR.xlsx' RUTA.EXCEL=PATH.REPOSITORIO:FICHERO.EXCEL RUTA.CSV='/u2/quiter/CONTA5/REPO.FILE/' CONVERTIR.CSV='' USAR.CABECERA='1' RESPUESTA=PyCallFunction(NOMBRE.SCRIPT,NOMBRE.FUNCION,RUTA.EXCEL,RUTA.CSV,CONVERTIR.CSV,USAR.CABECERA) IF @PYEXCEPTIONMSG#'' THEN CRT 'ERROR: ':@PYEXCEPTIONMSG END CRT 'RESPUESTA: ':RESPUESTA RETURN If I call RUN UP from two terminals it works fine, once. When I try to run it again... >RUN UP TESTEXCEL RESPUESTA: OK|... >RUN UP TESTEXCEL Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program TESTEXCEL at address 32. Connection to narobial.intra

I guess I'm a better programmer than Admin. I have successfully(?) installed UniData on an AWS Server. But I'll be damned if I can start the DB. The install Manual states:You can now start UniData by selecting All Programs > Rocket U2 > UniData RDBMS 8.3.2.I assume that references:C:\\ProgramData\\Microsoft\\Windows\\Start Menu\\Programs\\Rocket U2\\UniData RDBMS 8.3\\UDT or (directly):C:\\U2\\ud83\\bin\\udt.exeUnfortunately, the result is:Error msgno = 427. args = VOCerrno=2: No such file or directoryCan anyone point me in the right direction?Thanks in advance-Rich------------------------------Richard LucibellaDirectorRocket Forum Shared Account------------------------------

I would like to capture the dbpause is on message from a RESTful call.  Currently I'm getting an error 500 can't connect.  If I turn on the server_debug the server debug message does say dbpause is on.  So, I'm wondering if I can get the notification through my RESTful call.------------------------------David GreenComputer ProgrammerRocket Forum Shared Account------------------------------

I have been looking for ways to encrypt data sent from a publisher to a subscriber. That data is sent to unirpcd on the subscriber and I have confirmed that, at present, it is sent as plain text. We have a lead interested in replication but want to ensure that the data transferred between the publisher and subscriber is encrypted (they're Unidata on AIX). I noted the existence of the "-s" option for unirpcd, but when I force unirpcd to start on pub and sub with this option, replication does not operate. I've been told that there is no "official" way to encrypt the replication data travelling between pub and sub(s), but that using a ssh tunnel may be an option. I'm pretty decent at setting up tunnels - I do it all the time, but I have yet to work out how to get replication to go through a tunnel. Any suggestions? Or does anyone have any other suggestions about getting the data from the publisher to the subscriber to be encrypted (preferably without having to do file encryption for ever

Good Morning, I have trying to get rid of some duplicate rows in a process we do but every time i add the distinct or even a count statement im getting this error... Any Suggestions? QUERY: ------------------------------Luis SanchezIT Application SpecialistALAMO AUTO SUPPLY------------------------------

My name is Michael Belme, and I'm a Technical Support Engineer III with Rocket working out of Denver, Colorado. In this 8-part video series, I'll be covering the basics of why SSL is imperative for your business operations and how to easily protect data in transit flowing into and out of your U2 DataServers. I will cover the latest OpenSSL release used in U2 products and the changes it brings along... We'll take a look at Rocket's newly released U2 Certificate Management Tool, as well as the U2 Root Certificate Store and token-based authentication... both of which are found in the latest U2 database releases. Finally, the newly released secure-only UniRPCD port will also be explained along with steps to set up an SSL secured U2 REST server.  If you ever wanted to better understand the available security options found in UniVerse and UniData, then this video playlist is for you!   Note: The video playlist below can be accessed using the menu at the upper right of the fram

I think I have what I need from the python client side but I wanted to know if somebody can point me put to any article or link or Advise to setup this API from unidata------------------------------Luis SanchezIT Application SpecialistALAMO AUTO SUPPLY------------------------------

Hi We have some clients that are using universe version 11.3.1. This release comes with Python 3.4 and we're having some trouble adapting our Python code so it can work properly in several platoforms. Is there a way to safely upgrade the Python version other than updating the whole Universe installation?------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

Hi As I posted in another thread, I'm trying to port some code from uopy to u2py but I can't debug the code properly. I'm using Visual Studio code, connected remotely to a server via ssh. I have a really simple launch.json: { "version": "0.2.0", "configurations": [ { "name": "Debug manual launch", "type": "debugpy", "request": "launch", "program": "${workspaceFolder}/test_file.py", "python": "/u2/uv/python/bin/python3", "console": "integratedTerminal", "justMyCode": false, "args": [], "cwd": "${workspaceFolder}", "env": {"PYTHONPATH": "${workspaceFolder}:${env:PYTHONPATH}"} } ] } The test file is something very simple: def test_u2py(): import u2py c = u2py.Command('WHO', capture=True) l = c.run() print(l) return l And I can call it from BASIC: NOMBRE.SCRIPT='test_file' NOMBRE.FUNCION='test_u2py' RESPUESTA=P

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