Rocket® U2 | UniVerse & UniData®

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

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?

Hi All, I am exploring using UniDynArray. My Sample Code String xVM = Convert.ToChar(253).ToString(); string inS = "H1" + xVM + "H2" + xVM + "H3"; U2.Data.Client.UO.UniSession ses = U2.Data.Client.UO.UniSession.NullSession(null,Encoding.Unicode); var dynArray = ses.CreateUniDynArray(inS); var s = dynArray.ToString(); MessageBox.Show(dynArray.Extract(1, 1).StringValue); MessageBox.Show(dynArray.Extract(1, 2).StringValue); Issue: My first MessageBox is correct, but the 2nd one is showing me some rubbish.. ------------------------------Koon MIng FongMrP & O Global Technologies SDN. BHD.KUALA LUMPUR MY------------------------------

UniData 8.2.4Linux and HPUX 11Years ago, back when we were on UniData 6 or 7, we figured out a way to wake up a udt process that was in the SLEEP command by using signal SIGALRM.  We did not use this programmatically.  If we needed one process to wake another we would use PAUSE/WAKE.  However, there were occasions where a process was using SLEEP and we wanted it to move along, so we would send it a SIGALRM signal manually.   Now that we are on UniData 8.2.4, SIGALRM no longer wakes up a SLEEP.  Does anyone have another way to wake up a SLEEPing process before the end of it's scheduled sleep time?------------------------------DEAN ARMBRUSTERDeveloper VFerguson Enterprises VA [Country}------------------------------

I'm almost certain that linefeeds are resulting from something as simple as PRINT CHAR(27):"E" Is there a way to do this without causing a linefeed?------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

I have found a number of entries in the ${UVHOME}/errlog file reporting this error message: Unable to create new process. Will try again. I suspect it might be from executing the VOC verb SH (as in SH -c '{run unix command here}') Though the "Will try again" portion does not fit with that as I have only ever thought of the "SH" command as a single-attempt process. Does anyone know what actually does trigger these log entries? Thanks------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

I have some utilities that utilise COMO and/or DIVERT.OUT to  capture screen output for logging and processing. I am working on another utility that I want to run these utilities and capturing the screen output they create, for logging purposes. What I am hoping to find is a mechanism by which I can detect if COMO or DIVERT.OUT are actively redirecting output so I can temporarily direct output somewhere else and then restore it's output redirection. Has anyone had luck doing this sort of output gymnastics just using native functions, or any had-crafted functions for that matter? ------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

I have a data file whose key includes a tilde (~). WITH @ID = 1~12345 returns a lot of records whose keys don't appear to bear any similarity to the term. Works as expected if I use double quotes around the term. Similarly using the LIKE operator and [ or ] which return a larger count of records. I'm curious about what the tilde means.------------------------------Greg ClitheroeRocket Forum Shared Account------------------------------

A phantom log is created in &PH& using background processor but I can't see these logs replicated to subscriber from publisher. Please note every other file which we have created and all it's records are replicated without any issues.  We have commented out EXCLUDE_FILE = &PH& in repacct.def so ideally the logs should be replicated.  Any suggestion would be really helpful. Regards, Shubham Nigam------------------------------Shubham NigamRocket Forum Shared Account------------------------------

is it possible to get a PE version of 8.2.4 of unidata, its what we are currently running and I would like to test with  also when installing 8.3.2  i see .... thank you for installing .... 8.3.2 TE (is that test env or what?  thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Hi guys,We are seeing some strange behaviour on a Unidata/Windows site where SELECT commands that are run from a phantom process take a huge amount of time to run immediately following a server reboot. But if the same SELECT command is run from an SBClient session it runs fine (taking just a few seconds). This issue seems to last for a couple of hours after the reboot as though the server is doing something triggered by the reboot but it only seems to affect the phantom process.The customer assures us that the anti-virus has the Unidata files excluded.Unidata edition is server version 8.2.1Windows is Windows server 2016 standardHas anyone seen anything like this?Many thanksBarry GreenCBS SoftwareM: 0414 380192 T:08 82601256www.cbssoftware.com.auwww.cbssoftware.com.au/terminal-operating-systemwww.cbssoftware.com.au/depot-management-software[CBS_Logo]

Hi all I have some URLs that have special characters, but the server takes them without issue. Example: https://narobialimages.s3.eu-central-1.amazonaws.com/images/Light+version-Customer+Service_Retail_2019_15.jpg My problem is when I try to get this URL from BASIC: URL.CARACTERES='https://narobialimages.s3.eu-central-1.amazonaws.com/images/Light+version-Customer+Service_Retail_2019_15.jpg'RESPUESTA=protocolLogging('/u2/quiter/POSVENTA5/&COMO&/HTTP_LOG_HECTOR_':TIME():'.log', 'ON', 27)RESPUESTA=createSecurityContext(SECCONTEXT.HANDLE,'TLSv1:min')RESPUESTA=addAuthenticationRule(SECCONTEXT.HANDLE, SSL_CLIENT, SSL_RULE_SERVER_NAME, SERVER.NAME)RESPUESTA=addAuthenticationRule(SECCONTEXT.HANDLE,SSL_CLIENT,SSL_RULE_STRENGTH,'generous')RESPUESTA=createSecureRequest(URL.SERVICIO,'GET',HTTP.HANDLE,SECCONTEXT.HANDLE)RESPUESTA=submitRequest(HTTP.HANDLE,30000,'',CABECERA.RESPUESTA,DATOS.RESPUESTA,HTTP.STATUS) The URL gets encoded: 10/22/2024 13:52:21 [ 11047 11046 ] createSecurityContext

We have a number of these type instructions in our programs. Another example is ACCOUNT=FIELD(OCONV(0,"U50BB")," ",2). Is there something in the docs that describes what they are and what they do?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

The Rocket Software MultiValue team would like to invite all Rocket® UniVerse customers, with an active maintenance agreement, to participate in our UniVerse 14.2.1 beta program starting on January 22nd, 2025.   The beta program is the most valuable way for you to contribute to the development process of UniVerse 14.2.1, your insights help us ensure the final release meets the needs and expectations of the whole customer base. Additionally, we are also giving you the opportunity to test a beta version of U2 DBTools 4.6.1 prior to its release. Should you decide to participate these are just some of the new feature and functionality highlights you'll find in UniVerse 14.2.1: Shared Structure Recovery Framework for the Recoverable File System (RFS) UniVerse 14.2.1 will have full RFS functionality, in this release RFS can now be toggled ON or OFF via the RFS_MODE uvconfig parameter. RFS protects your system by preventing file corruption in the event of a system failure ensuring high av

We are being tasked with moving our development and testing accounts off our primary Linux box and putting them on two other Linux boxes.  The problem is we have a number of global files that are shared by all accounts. Can UniData be configured on box A to read and write to box B and or C? Can UniData be configured on box A to run programs on box B? What are the issues to expect? Where can I read about how to do this? Thanks------------------------------[John] [Israel][Sr. Programmer Analyst][Dayton Superior][Miamisburg] [OH] [USA]------------------------------

Customer is running Unidata 7.2. I am running Unidata 8.3.Looks like Universe is able to calculate the distance between 2 points with GCDISTANCE(). I don't see this on Unidata. GCDISTANCE (lat1,lon1,lat2,lon2)ParametersParameter     Descriptionlat1     Latitude of the first point.lon1     Longitude of the first point.lat2     Latitude of the second point.lon2     Longitude of the second point.Example PRINT GCDISTANCE(39.7, -105, 38.9, 121.6) This function returns: 10073112.4749 Has anyone been able to calculate the distance between 2 points ? Trying to calculate the distance with a Basic program which exports GPS tracking data. Maybe there is a way of calling google maps.------------------------------David RiveraSelf RegisteredFORT LAUDERDALE FL US------------------------------

After upgrading from UV 11.3.3 to 11.3.4 I am having an issue causing Universe to crash. I am using the Pymysql library to read/write to a remote MariaDB Database, the same code worked fine before the update and is now crashing on run. What I have figured out so far: The issue is caused within the pymysql's connect() function. After adding some fault handling and looking at the trace (attached pythoncrash program.txt) sends me on a rabbit hole that ends in pymysql's _auth.py file. the scramble_native_password function on line 29. Specifically on line 34 when Hashlib runs the digest() function. I can recreate the issue with the functions directly from hashlib (pythoncrash TCL.txt) and I get the same issue. As a test I try to run a simple script that builds a hash and runs a digest....I crash when running from TCL, but I run successfully when calling from shell, telling me this is an issue somehow localized to Universe, and the changes in the 11.3.3 > 11.3.4 upgrade. /usr/uv/python/

Hello I was reviewing the CREATE.FILE program in the UV account's BP library yesterday and discovered it supports a few keywords that are not documented: UNIQUE, NUMERIC and SQLITYP Does anyone know what these keywords do to the created index, or under what context they could/should be used? Thanks ------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

Hello all, I have a program that analyzes data from a 6.8M record file that does not have an index. Is there any way to report on the progress of the EXECUTE, as it may take 20mins or more to run? Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

We are working on way to  be able to write data into universe files  directly from  python application running on the universe server that  pull data from cloud pub sub topics as we begin the process we have run into a snag, namely being unable to writer records  using u2py . here is little test program we wrote this work complete when running this inside the python shell , however when we try running it using  unix shell it it able to read the SPF.TEST Record but then does not write the data back into the same file as new record AK.TEST2. we only find out that it fail to write bit does not throw an error when we try to read and print the new record.  we are not sure what is missing . any help is appreciated.   import u2py def main(): print("Main start") lp = u2py.Command('LOGTO PROD').run() test = u2py.File("INF.FILES") t_read = test.read("SPW.TEST") print(f"main :",t_read) test.write = ("AK.TEST2",t_read) t_read2 = test.read("AK.TEST2") print(f"main :",t_read2) if __name__