Rocket® U2 | UniVerse & UniData®

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__

I use COPYI  (system is 11.2 PICK flavour) to copy records between files in the same account.  Is there any way to copy records directly from files in another account without adding a Q or F VOC record to point to the file ? I'm imagining something like EVAL but for the VOC instead. Just trying to avoid the overheads when a transient connection is needed for a copy.------------------------------Greg ClitheroeRocket Forum Shared Account------------------------------

I don't recall encountering this before & I don't see it documented.   Within a process that has updated, but not committed, a record & its index, that same process encounters the public old index value, not that in the the cached not-yet-committed record. Some pseudo-code: 1. BEGIN TRANSACTION2.    create or update a record that has an indexed attribute that is changed3.    CALL  subroutine (or inline)       3.1 direct read of record updated in step 2.  - The new version is correctly read.       3.2 selectindex to find the rec from step 2.   - Performs as if the old value is still indexed.       3.3. EXECUTE 'SELECT ...'  functionally same as 3.2, using the index.  - Performs as if the old value is still indexed       3.4. EXECUTE 'SELECT ... NO.INDEX'   same syntax as 3.3 but NO.INDEX - Performs finding new value       3.5  return4.    COMMIT5.  END TRANSACTION (The above is all within one process, one basic program, inside one transaction.  Not something executed by competin

Hello all Is there a way to run a slow u2py operation in background? I ran some tests and the Universe Python seems to not support parallel execution due to GIL, so I discarded Python's native threads. With async routines the execution gets blocked on u2py calls: BASIC code: >CT UP ADORMIR      ADORMIR0001 SLEEP 500002 CRT 'me despierto'0003 RETURN0004> Python code: import asyncio import time from datetime import datetime import u2py MAX_TIME = 60*2 INTERVALO_LARGO = 30 INTERVALO_CORTO = 1 async def corutina_rapida():     i = 0     while i < MAX_TIME/INTERVALO_CORTO:         print(f'{i} - {datetime.now()} - HOLA')         await asyncio.sleep(INTERVALO_CORTO)         i += 1     return 'OK' async def corutina_dormilona_universe():     i = 0     c = u2py.Command('ADORMIR')     while i < MAX_TIME/INTERVALO_LARGO:         r = c.run()         print(f'{i} - {datetime.now()} - A DORMIR - {r}')         i += 1         await asyncio.sleep(0)     return 'OK' async def lanza_cor

Our Universe application consists of 8 accounts for 8 branches. In all accounts, there is a file for the items. The item file is identical for the master data in all accounts, only the transaction data differs. When writing, changes to the file, master data are distributed across all accounts to keep them consistent. Although this approach is certainly not optimal, we do not want to change it because the programming is not easy to modify. I conducted a test, and used: SET.INDEX ITEM TO H:\\ALPHA\\INDEXES\\I_ITEM to set the target path for the index of all 8 item files to the same destination. During a bulk import into the item file, where all 8 files are updated, switching to a single index file, approximately double the speed is achieved. My question now is: Is there anything that speaks against using a single index file for multiple data files, as long as all indexed fields are identical for all data files? greetings Thomas ------------------------------Thomas LudwigSystem Builder D

The Rocket MultiValue team is happy to share that we're released version 2.1.1 of the Rocket® MultiValue Integration Server (MVIS). This release of the product provides additional support of MVIS 2.1, which we released in June 2024. MVIS 2.1.1 includes the following benefits: We've enhanced MVIS Admin API Swagger documentation  to ensure that the content and formatting of the  Swagger documentation is accurate and compliant with the OpenAPI 3.0 specification. We've deprecated Rocket APIs that don't adhere to the OpenAPI 3.0 specification . We've removed obfuscation of MVIS code  so you can easily diagnose runtime issues utilizing third-party tracing tools, such as Dynatrace, without being encumbered by obfuscated class and method names.  This should also eliminate your frustration with obfuscated names of classes and methods in the Admin API Swagger documentation.  Please note, we've kept MVIS's password encryption code to hinder casual observation if decompiled.  We've adjusted t

All, We have a program that is doing a range of calculations that result in large integers. In some cases we are seeing overflow when negative numbers are being converted to their 2 complement e.g. when assigning it to a value in an array.  This is effectively what is happening (not the actual code and that's deep inside a complex routine). A = -1528596274 B<C,D> += A B<C,D> shows as 2766371022 If we take the assignment out of that program and put just the code into a standalone routine with the same numbers it works without modifying the number. Other calculations using that number also work. If we pass the value and array into a noddy three line subroutine to do the assignment, the value changes. Any attempt to manipulate the number e.g. ABS or even testing it (if A < 0) also coerces it to the 2s complement.  If we turn it into a string, the same. E = A : '' E is 2766... If we use string maths, the same. Other routines in the system are handling much larger numbers wit

Is there anyway we can increase the threshold of READU locks. Currently I am getting below error. READU threshold reached, lock on xxx denied!Program "ED": pc = 69BA, READU threshold reached, lock on "xxxxx" denied!------------------------------Shubham NigamRocket Forum Shared Account------------------------------

Hi guys,We have a situation where we want to have multiple Unidata accounts on a single Windows server but the accounts may related to customer sites in different time zones.The front end will be a browser based web application.If we use DATE() and TIME() that will pick up the date and time from the server which may not match the date/time relating to the location of the customer's site.We have thought about 1. Calling an API to get the site "actual" time but that must rely on both an internet connection and the API always being available. 2. Maintaining a "time offset" setting but that's difficult with daylight saving as that can kick in on different dates each year and sometimes isn't required at all. 3. User the date/time from the users local PC but what if the user is travelling or simply has their date/time set incorrectly.Has anyone come up with a good solution to this?Many thanksBarry GreenCBS SoftwareM: 0414 380192 T:08 82601256www.cbssoftware.com.auwww.cbssoftware.com.a

I finished my contract last week, so back on the market. I landed an interview with a "recognizable company" and went straight to the final round. During the interview one of the panel asked me, "How do you read a file without a select list?" I paused for a moment wondering why anyone would need to do that?  I thought for a moment and came to the conclusion, it may be possible, but I cannot think of how it could be done. I responded to him, "In the twenty years I've worked in multivalue, I have never seen any code that would do that. But I don't ever recall ever having the need". Is it possible?  Does anyone have an example?Added:  This person meant without using SELECT anywhere. At TCL or internally in a program. He claims he has a way, I doubt him.  ------------------------------Scott JohnstonSr Software Engineer, Architect & DeveloperDover DE US------------------------------

Using U2.Data.Clent 3.1.1.1003, I'm receiving this error after the web service has sat for some time.  The Session.Status = 0 and Session.IsActive = true.  I there a way of knowing when the underlying connection has stopped?   U2.Data.Client.UO.UniSubroutineException: ' [U2][UCINET-UO]WIN32 API Error:10053An established connection was aborted by the software in your host machine.[Rocket U2][UCINET - UNIRPC][ErrorCode=81009] The RPC failed

just wondering is there is any advantage one way or the other between using    VAL=EXTRACT(RECORD,1,1,0) vs.   VAL=RECORD<1,1> ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Hi, i would like to query a bunch of tables to see if the indexes have been built I tried LIST-INDEX <FILENAME>.  But it seems to require a <return> if the page is too long. Was also looking at guide_ndx, but i can't see a BUILT column like in LIST-INDEX.   guide_ndx would be ideal because i can call it from a shell script. ------------------------------Jeremy SchmidtprogrammerRocket Forum Shared Account------------------------------