Rocket MultiValue

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

What's the most efficient/fastest way to securely get data in/out of a jBase system? The last time I had to do this, we wrote a CGI interface and accessed the system via HTTPS. This time, we have no need for the full CGI environment, we just need to parse some JSON data, and return a JSON response.  Similarly, MVIS is overkill. Is there a "jClient", like there is with qm? We could just listen to a port, but the inbound connections will be coming from multiple clients, so we really don't want to run multiple transactions through the same process. We like the statelessness of separate connections.  Since jBase apps compile to OS executables, the current thought is to establish an ssh connection, with keys, run the appropriate routine, return the JSON and then exit.  We're wondering if there's something simpler.  ------------------------------Raymond DeGennaroOwnerSelf RegisteredBelvidere IL US------------------------------

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

we have a file that has a MV list of part numbers in an attribute In D3, we used to be able to    select wo "235789" PL.IDS this would give is the keys to a new file. The dictionary looks like: DICT wo pl.ids01: S02: 1903: 04: 05: 06: 07: 08: F;"*"R;19;:;0R;_;:09: L10: 2811: A;0R:"*"R:N(PICKLIST.PNS) ~~ F;0;"*"R;:;19;: In D3, we would get 235789*001 235789*002 235789*003 In QM, we get 235789*001 002 003 Yes, we already use indexes though out our system, but we have some of this old logic.  We are hunting this down, but we would like to know to make the dictionary work correctly. We have tried the "A" correlative, but neither seems to work.------------------------------Jesse TilliaProman-ERP, Inc.West Seneca NY US------------------------------

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

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.

Anyone else getting spurious lint on the $copyright compiler directive? ------------------------------Stuart BoydellAU------------------------------

I have a complex I-Descriptor that should never output more than 2 characters.  Therefor, I have it set to "2L". Due to some bad data, a few records have 5-6 characters for this value. How can I direct the dictionary item to only out 2 chars?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

I have a UniVerse file with a great diversity of record structures. Consequently I want to return the data for a record through EVAL rather than a DICT I-descriptor entry because DICT entries lead to overflows from other incompatibly structured records. FWIW, the output will ultimately be through ODBC using dynamically normalized Native UniVerseSQL. Don't worry if this isn't your thing, you may still be able to help with the EVAL I-descriptor expression I need. The values on the record in question are listed as an arbitrary number of individual attributes, which I can return as a single set of multivalues using LOWER(@RECORD) suitable to be read by ODBC. However I need to return them with the corresponding original attribute numbers and have not been able to come up with anything. Any suggestions would be most appreciated.------------------------------Greg ClitheroeRocket Forum Shared Account------------------------------

i want to install pipi package manager for python in unidata. There is someone that could give some advice?------------------------------Luis SanchezIT Application SpecialistALAMO AUTO SUPPLY------------------------------

Hi all I'm trying to run some Python programs that requiere some third party libraries and I'm having some problems installing them as a regular user. This is the folder structure: [root@~]# ls -lh /usr/uv/python/ drwxr-xr-x 2 root root 4,0K jul 17 13:21 bin drwxr-xr-x 3 root root 22 jun 15 2021 include drwxr-xr-x 4 root root 106 jun 15 2021 lib drwxr-xr-x 3 root root 16 jun 15 2021 share drwxr-xr-x 2 root root 29 jun 15 2021 syslib [root@~]# ls -lh /usr/uv/python/lib/python3.9/ | grep site-pac drwxr-xr-x 18 root root 4,0K jul 17 13:21 site-packages On another server there are some differences, and the owner is the uvdb user, not root. [root@~]# ls -lh /usr/uv/python/ drwxr-xr-x 2 uvdb root 4.0K May 16 13:14 bin drwxr-xr-x 3 uvdb root 24 Oct 18 2023 include drwxr-xr-x 4 uvdb root 114 Oct 18 2023 lib drwxr-xr-x 3 uvdb root 17 Oct 18 2023 share drwxr-xr-x 2 uvdb root 68 Oct 23 2023 syslib When I try to install some package it's going to be installed in the

We're trying to upgrade from RHEL 7 to 8 (and upgrading UniVerse to the supported versions from 12.1 to 12.2.1) Upgrading our test system to RHEL 8 (using the LEAPP in-place upgrade method) and then updating UniVerse to 12.2.1 worked as expected, and critically printing continued to work as normal. However performing this on our production system, results in printing not functioning after the RHEL upgrade. I posted about this issue when we attempted this initially last year and as suggested we've taken a clone of the production system so we can experiment with it freely. So far we've tried: RHEL Upgrade only > printing fails > then Universe update > printing still fails Universe update > printing ok > then RHEL > printing fails Printing direct from the OS level e.g. # cat testfile.txt | lpr -P PRINTERNAME - this results in printer output. So it seems performing the upgrade to RHEL 8 changes "something" in UniVerse which prevents UniVerse from spooling to the printer i

I recently discovered that d3vme /fileload on D3 Windows does NOT build indexes in the FSI accounts. VME accounts only. This was discovered when working with someone who was using d3vme /fileload on D3 Linux 10.4, since entering d3 from a Linux prompt then taking the F option is no longer the way to restore the system. The problem was further masked by the fact that list-index DOES show all of the index references even though the indexes never got built. This is because the index references in a file's D-pointer (file-defining item) get restored when the file is restored, but no further action is taken. The way around this is to run indexer from TCL in the DM account after the file-load is complete. Indexer reads all of the index references in the D-pointers and builds the indexes accordingly. As of now, we are treating this as a documentation issue since this has always behaved this way and the work-around is quite simple. I would appreciate any comments from anyone who uses d3vme /fi

Hi I'm trying to port some code so that all the uopy connections will use u2py instead, so I don't have to spend another extra license when calling my Python code from BASIC. I've been looking to the u2py code for the u2py File object and I can't see a "close" method. What's the proper way to close a file when using u2py?------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

I want to conect to unidata using unix and move with unix commands in the terminal. Im new to unidata any advise to get connected?------------------------------Luis SanchezIT Application SpecialistALAMO AUTO SUPPLY------------------------------

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 some questions / confusion concerning shells. I know that at different companies I have worked they have allowed different shells - korn, bash, bourne, etc.  Is there a standard for invoking each of these shells or is that defined by the admin within each system? !sh, !ksh, !bsh.  Is there any documentation on how to set these up? A way to know which shells are being invoked by the commands?  And a way to update paramaters within each? Thank you for your time, Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Have you thought about changing the CENTURY.PIVOT? We've had some customers attempting to report date bugs as we approach 2030 which are in fact not a bug at all but just a misunderstanding of the CENTURY.PIVOT setting. The century pivot point is the year used to determine the century when an ICONV is done on an external date that only provides a 2-digit year. I have attached a results spreadsheet to this post, so that you can review the different results of setting CENTURY.PIVOT against a 2-digit year ICONV and then seeing the result using an OCONV with a 4-digit year. You can check the century pivot point with the CENTURY.PIVOT command at ECL.>CENTURY.PIVOTCentury pivot date is 1930 You can change the century pivot point for your current session with the CENTURY.PIVOT command, or change it for everyone by changing it in system wide configuration file. (udtconfig for UniData and uvconfig for UniVerse ) From the UniData Help The CENTURY.PIVOT ECL command overrides the system-wide ce