Rocket® U2 | UniVerse & UniData®

Hi Everyone, Been a while since my last interaction here and have been up to my armpits in it all. Have a question about transaction processing/commits/boundaries etc and the compatibility with file triggers. Can the two co-exist? I have a feeling the answer will be no but thought i should ask. We're on UV11.3.4. Any info would be great thanks. Regards, Peter

i would like to check the amount of arguments are on a universe program before i call it, to build the action before calling it.------------------------------Daniel ConradieRocket Forum Shared Account------------------------------

Hello, My company uses a phantom process that runs using the PHANTOM BRIEF. It's a continuous program that compares the current epoch with the epoch +180 (seconds) to determine when the next iteration will kick off. After 8 or more months of running every 3 minutes, the phantom unexpectedly self-terminates. It's a business-critical process that needs to be running at all times. It stopped unexpectedly over the weekend and resulted in a lot of issues. I've been scouring the forums for a few hours to see if I can figure out some way to prevent it from happening, but I can't identify the root cause. The program has had read/write logging set up for several years. Any error opening files or writing to them is logged to a custom flat file on a network drive, but no logs have been written there the past 3 times the phantom terminated. No logs were written to PH--though I'm not sure if that needs manual setup. The errlog file only displays the current day's user errors, preventing me from see

Hi, Is it possible to make a SQL query and save the result in a python list to later display it in a table? If possible, please indicate the code to do so. Regards------------------------------Antonio MorenoInformaticoSelf RegisteredFernan Nuñez ES------------------------------

I need to encrypt a string with the aes-256-cbc. My encryption is not matching what the other end needs which is a php endpoint.  In the documentation there was definitely a statement that makes me think I did at least one thing wrong but I am not sure.  Converting the aeskey to a hexidecimal format is what I think I may not understand. You see that I am taking each character in aeskey and building a string of the hex values for the character.  Below is a bit of the code for the encryption.  Once again I am missing something. Thanks all. BASE.JSON = '{"customer_id":"1000"}'ALG = "aes-256-cbc"ACT=1AESKEY= "31e92H1^FiERFgv7^nXg6DfC66rGpFb7"GOSUB HEX.AES.KEYIV.HEX = "31313131313131313131313131313131"RESULT=""RES =  ENCRYPT(ALG,ACT,BASE.JSON,1,AESKEY,1,3,"",IV.HEX,RESULT,1)DEBUGSTOPHEX.AES.KEY: NKEY=""KEY.LEN = LEN(AESKEY)FOR X = 1 TO KEY.LEN  KL = AESKEY[X,1]  HKL = OCONV(KL,'MX')  NKEY:=HKLNEXT XAESKEY = NKEYRETURN ------------------------------[Gary] [Rhodes] [Universe Developer][NPW

MultiValue Experiences version 1.7.0.1189 has been released on August 17 2023 for the below platforms/versions:AIX POWER       7.1,  7.2,  7.3AlmaLinux       8,  9CentOS       7,  8RedHat Enterprise Linux Intel       7,  8,  9Rocky Linux       8,  9Windows       Windows 10,  Windows 11,  2016,  2019This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact rbc@rocketsoftware.com.

We have a new installation of EDA and when we try to map a file they all come up as a "B" on the filename, which designates it as a non UniData or directory type file. We have an open case and also a paid contract to Rocket to get it working, but no luck as of now. Throwing this out there to see if anyone else had this issue and resolved it. We have this working on our development server just fine and all code levels and settings are the same. AIX 7.1 UniData 8.2.4 ------------------------------Thomas VanKirkUnix adminCabinetworks Group Michigan, LLC fka Masco Cabinetry LLCGarrettsville OH US------------------------------

None of the calls to the ENCODE function returns the same base64 string as several online sources do.  What am I missing? 001: CRT "DATA ":;INPUT DAT002: IF DAT = "" THEN STOP003: RESULT=""004: ERES = ENCODE("URLENCODE",1,DAT,1,RESULT,1)005: CRT "RES :":ERES006: CRT "BASE64 RESULT: ":RESULT007: RESULT=""008: ERES = ENCODE("SSL_BASE64",1,DAT,1,RESULT,1)009: CRT "RES :":ERES010: CRT "BASE64 RESULT: ":RESULT011: RESULT=""012: ERES = ENCODE("SSL_BASE64_ONELINE",1,DAT,1,RESULT,1)013: CRT "RES :":ERES014: CRT "BASE64 RESULT:":RESULT The results: DATA ?ManRES :0BASE64 RESULT: ManRES :1BASE64 RESULT:RES :1BASE64 RESULT:------------------------------[Gary] [Rhodes] [Universe Developer][NPW Companies][Hialeah] [FL] [USA]------------------------------

Does Universe have a function to encrypt a string with sha256 using a secret key.------------------------------[Gary] [Rhodes] [Universe Developer][NPW Companies][Hialeah] [FL] [USA]------------------------------

I haven't used UV in a while. When I had to convert a D3 account to Universe, there were specific tools to do it.  I can't find them now under Windows and UV 12.2.  The documentation mentions tapein routines or using the import command under Xadmin. Everything is incomplete. Under D3 windows I created a tape pseudo device, set the block size to 512 and used the 'SAVE (TIC" command to create an individual account save that is backwardly compatible. UV documentation has no mention on how to create an entry in the &DEVICE& file to access a windows disk file. Sorting through the VOC verbs I found a command D3RESTORE which looked promising but is not in help system or other documentation. When I used the command  D3restore INFILE "D3ACCOUNT" I get an error "Error Occured at Input Byte: 13" Any help would be appreciated.------------------------------David WilliamsdeveloperComputer Repair & Sales IncWarminster PA US------------------------------

Does anyone have a working recipe for starting/stopping Unidata when the system boots on Redhat 8?  Looks like it's as easy as creating an entry in /etc/systemd/system/unidata.service, but if someone has a working config they'd be willing to share that will save some experimentation :_)https://medium.com/@benmorel/creating-a-linux-service-with-systemd-611b5c8b91d6It doesn't look to hard to do the basics of startud and stopud, but curious if anyone is having systemd restart ud when stopped?  That seems like a bad idea.Thanks for any advice!Ian------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

We use the BP (break on program) command in the debugger pretty extensively.  However, on this one customer system, when we do BP followed by a catalogued program name, we get an unusual response: !BP ADJ.DTL.WHSE.DEF***'ADJ.DTL.WHSE.DEF' is not a directory file. The file that this item is in is definitely a DIR-type file.  And of course, this basic program itself is not a directory, it's text.  Is there any workaround to this?------------------------------Kevin KingPresidentPrecision Solutions, Inc.Longmont CO US------------------------------

Trying to resize a file but getting error message that file is in use, try again later.

Now and then I must look at how long processes are running. Our web applications should be all running in under 500 milliseconds even though there are a lot of records in the database. An important datatable loading program on our web form was taking upwards of 2 seconds to load. I tested it on our development machine and with the client's data and the same number of indexes (7) and found our SELECT times were about the same. The PICKUP.DATE and ORIGIN.TERM are all indexed fields. Obviously, the SELECT optimizer does not work like I think it does. Here is the test code abbreviated that runs in 643 milliseconds TERMINAL.NO = "059" ; BEGIN.DATE = "06/24/2023" ; END.DATE = "06/30/2023" LINE = 'SELECT MOVE.LOADS' LINE := ' WITH PICKUP.DATE GE "':BEGIN.DATE:'"' LINE := ' AND WITH PICKUP.DATE LE "':END.DATE:'"' LINE := ' AND WITH ORIGIN.TERM = "':TERMINAL.NO:'"' EXECUTE LINE CAPTURING OUTPUT LOOP WHILE READNEXT ID READ LD.ITEM FROM

Hi,I have Universe pgms that return a UniDynArray, but would like to convert the returns into a json format.I am not sure if this has been asked before but really looking for help on this last section of my code please?------------------------------Daniel ConradieRocket Forum Shared Account------------------------------

Hi All, Most likely obvious, but I recently removed millions of records from some UNIDATA files, and I want to reclaim the disk space. In days of old, I would make a new version of the file that is empty, then copy the records into it -- then replace the old file with the new one. Is there a better way to do this now? I have a vauge memory of doing the copy from the ECL prompt, but I may have used Unibasic. I have a few files over 50GB that it would be nice to get the space back.  In reviewing the manuels, (HORRERS) it seems that REBUILD.FILE would basically do that. But I see no example of syntax. :FILE.STAT HISTORYFILE File name (Dynamic File)              = HISTORYFILENumber of groups in file (modulo)     = 36534Dynamic hashing, hash type            = 0Split/Merge type                      = KEYONLYBlock size                            = 16384File has 35382 groups in level one overflow.Number of records                     = 1824235Total number of bytes                 = 9851076322

Working on a routine to take HTML input and convert HTML entities like < and &gt to their character equivalent.  However, HTML entities are case insensitive, so the input string might be <, <, &lT; or ≪.  Is there a clean way to search for < in the string without case sensitivity so the value can be replaced with "<"?

I have this phantom program that runs for a bit and then just stops functioning.  The program continues to run, but doesn't do what it's supposed to do and does not respond to any control inputs other than a Linux kill.  Seems to be caught in some kind of a dead loop.  There are no READU locks preventing the program from running, it just ... doesn't do anything after it's been running for a while. Is there any way to connect the Unidata debugger to the phantom to evaluate variables or step through the program?

hello, I try to call a method which is into a module which is into a package.  on py I do : from package.subpackage import {*|module}  Is there a syntax to do it with PyCallFunction('package.subpackage.module',mth,xx) or PyImport('package.subpacakge.module') ??  thanks for any help------------------------------Manu Fernandes------------------------------

I have installed BDT 4.5.0 on my Windows 10 laptop. I'm connecting to UV 11.3.4 on RHEL 8.8. I get errors trying to connect. So the question is: Do I have to give the unirpc process access to write to my VOC file? We just installed 11.3.4 on our server. What updates are needed? What sequential file failed to open (guessing it was a log file of some sort). If anyone can point me in the right direction, it would be appreciated.

hi, when I use PyCallMethod or PyCallFunction, the result is typed by python. uvPythons doc talk about PYOBJECT. so, how can we define if pyCall return a PYOBJECT or a string/number usable in basic ?  Actually, I perform a pyCallMethod(builtins,'str',myvariable)  Is there a better method ?  manythanks. ------------------------------Manu Fernandes------------------------------

hi u2python's guru, I run a problem to adress 4 different python on the same machine.  1/ from bash /usr/bin/python (2.6.6)  sys.prefix='/usr' sys.path=['', '/usr/lib/python2.6/site-packages/'........., '/usr/lib64/python2.6', '.....] 2/ from bash /usr/local/bin/python3 (3.6.4) sys.prefix = '/usr/local' sys.path=['', '/usr/local/lib/python36.zip', '/usr/local/lib/python3.6', '/usr/local/lib/python3.6/lib-dynload', '/usr/local/lib/python3.6/site-packages'] 3/ from bash /data/uvdb/uv/python/bin/python3 (3.4.5) sys.prefix='/usr' sys.path = ['', '/usr/lib64/python34.zip', '/usr/lib64/python3.4', '/usr/lib64/python3.4/plat-linux', '/usr/lib64/python3.4/lib-dynload', '/usr/lib64/python3.4/site-packages', '/usr/lib/python3.4/site-packages'] 4/ from uvshell /data/uvdb/uv/bin/uv > python  sys.version='3.4.1 (default, Feb 18 2015, 13:36:51) [GCC 4.4.7 20120313 (Red Hat 4.4.7-3)]' sys.prefix='/data/uvdb/uv/python' sys.path=['/data/uvdb/uv/python/lib/python34.zip', '/

Hey, wondering if anyone is successfully connecting to Uniobjects on a Linux server (a recent Redhat release), using AD authentication?  I'm working with a customer that does not want to use any local accounts at all to connect to Unidata (i.e. the accounts should not be in /etc/passwd or added locally with useradd, they must be AD accounts).  I'm not sure if uniobjects uses PAM and can do that kind of auth. If you are using AD auth with Uniobjects, is the account you're using allowed to login to the server via ssh?  That's the second requirement - they don't want someone with a service account password using it to login.  I know on windows, Uniobjects requires the account to have the "log on locally" privilege. Grateful to hear of anyone's experiences with this (especially if it's a positive "yes it works!") or pointers to docs I may have missed :-)------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

Hello to all, I hope I find you all well.  Before I open a ticket or something ..... We have (a bunch) of U2 installs in AWS EC2 , and once in a while (that is a lot since there are a lot of servers) ,  U2 decides the lic. is no longer valid .... this happens no matter the linux flavor....  we have to re-enter lic detalis and re-activate .....  no instace type change is required to happen , to suffer this fate  any ideas or insights ?  regards, David. ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

I'm pleased to announce the release of MultiValue Integration Server (MVIS)  1.3.3.0. MVIS 1.3.3 is the third maintenance release in the last 18 months. Some of the key highlights in 1.3.3 are: Java 11 support - MVIS now supports Java 11 in addition to Java 8. Support for user defined topic prefixes on Azure service bus - This enhancement provides a way to support multiple mvis/admin pairs on a containerized installation of MVIS, reducing the cost of deployment on Azure (since it removes the requirement for one service bus per MVIS instance). Support for Alpine Linux 3.18 - We've upgraded MVIS containers to the latest version of Alpine Linux, v3.18. 1.3.3 includes 8 bug fixes (refer to the release notes for details) MVIS product lifecycle dates: 30 Jun 2023 GA 30 Jun 2026 EOM 30 Jun 2027 EOS 30 Jun 2028 EOLS ------------------------------Hernando BordaProduct Manager, MultiValue ToolsRocket Softwarehborda@rocketsoftware.com------------------------------