Rocket MultiValue

The Rocket® Software MultiValue team is pleased to announce the availability of jBASE 6.2.1 on October 30th, 2024. The Rocket jBASE solution is an object-oriented integrated database and application development environment designed for transactional and analytical database applications. It combines scalable, flexible, seamless interoperability with connectivity and low overhead for system management and administration. Many months in the making, 6.2.1 brings some major enhancements to jBASE. Most notably: D3 Compatibility The Why:  - To provide more choice and flexibility for our D3 customers who want to modernize, we now offer an optional migration path to jBASE. The What/Value: - 6.2.1 brings robust documentation, a new licensed package in RBC, and further key changes to the codebase that make conversions more seamless. A new Transaction Journaler The Why:  - To 1.) meet the requirements of key accounts moving to jBASE 2.) simplify administration. The What/Valu

if I type a tcl command and mess it up nothing works.l or .r/asdasd/asdasd  and .c/asdasd/asdasd do nothing. I work on uv and d3 both so I never remember which .r or .c  Oh well, getting older is so much fun :)------------------------------Curt LashleyProgrammerChemstar Mechanical Packing, Inc.Tampa FL US------------------------------

I'm changing the UI of an app from a classic D3 character based UI to a Java Swing app using MVSP Java to talk to D3. I've got a slight architectural problem I'm hoping someone might have some insight into. All the character based programs include an unnamed common block which keeps file descriptors, screen and prompt info etc. All hotkeys can be defined to start a program, so if you are in any input field pressing a hotkey will start a new program and after that program finishes the screen is refreshed back to where you were. A unnamed common block works well, because when the hotkey program is executed, a level is pushed, and because the common block is unnamed, the pushed program gets it's own copy of common and can execute independently of the program that started the pushed program. There a 2 issues: (1) a subroutine cannot declare an unnamed common if the calling program hasn't first, and (2) if you use named common, this is global for all pushed levels during a login session. Us

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

When setting up a data resource, and mapping dictionary items to the REST interface, seems like I'm only able to map one field at a time that points to a given attribute, in my case it's attribute 0.  We have composite ids, and have multiple dict items that point to attribute 0 with some conversions that pull out what that particular dict item needs.  Problem is that when I try to select say _id (attr 0) and other dict items that point to attr 0, it is deselecting the other dict items when I select a new one.  I'd like to have multiple of these at the same time, but not sure how to do that if it's possible.  In my screen shot, I'd like to select _id, sys_date and sys_time but can't seem to get them all checked at the same time.  Any advice welcome. UPDATE: I was able to get both the sys_date and sys_time working, but it doesn't seem to be running the conversion code and just shows the raw field.  When I run a list in TCL, I get the actual converted date/ti

I have been working on getting MVVS operational via X11 on a RHEL8 server. Recently RHEL put out the following table, indicating that OpenJDK 11 ends full support at the end of this month. Does MVVS work with OpenJDK 17 or later?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

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

I found some Linux text utilities that have a lot better interface than the normal Linux command line.  For a file manager I installed Midnight Commander (mc). It installs and runs great even on Centos 7.  I found another program for managing processes called bpytop (btop wasn't available for Centos 7): There's also a python Library, textualize that lets you develop text applications that look and work very similar to GUIs. The problem with all three of these is that they don't work with AccuTerm at all. I know that when the emulation was written not very many people were using Linux. Especially in the mvdb market. Now, it's the main OS for mvdb databases and so the Linux terminal is now the main standard. It's like the Wyse 50 back in the day. It seem crazy that AccuTerm doesn't work the same as all the other standard programs. Even the Microsoft  Windows Terminal and PowerShell commands work. I end up using cmd or the Linux terminal instead of AccuTerm but switching between applic

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

we've recently upgraded our D3 / Flashconnect from Centos7 & D3 10.1 to Almalinux 9.4 & D3 10.3.4. flashconnect has been version 3.9 throughout. everything seems to be working fine except for one thing, which worked on the old set-up and doesn't seem to be working on the new one. the issue is when the client follows a link that takes to a different cgi-bin script on our server. that scrip lets them upload files to the webserver, and contains a <form> link back to where they left off on flashconnect. this has worked perfectly for us for more years than i can remember, the return to flashconnect has always been seemless thanks to a single cookie with the w3profileid stored in the client browser. on the new system however, when they return to fccgi.exe instead of ending up where they should they're getting a logon screen that seems to be generated by wbp w3logonscreen and i have no idea why that's happening. i don't know what's calling that subroutine so i'm not sure how to

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

My org uses a "zero trust" connectivity product called "Zscaler".  It's effectively a replacement for the VPN we used to use for remote users. Ever since Zscaler was implemented, there's been periodic connectivity issues with our D3 systems - they're disconnecting a client connection within milliseconds of accepting it.  Recently, this problem has become dramatically worse - to the point where it's affecting business operations.  People in billing aren't able to connect for hours at a time. It occurred to me today that it might be a licensing problem on the D3 side.  All the problematic connections are being made via MVSP on port 9000. Because of how Zscaler works, all the connections that travel over the Zscaler network are going to hit our servers from the same IP address.  I'm wondering if D3 isn't seeing that and will start denying connections from the same IP address after the connections reach a certain threshold.  Is this possible? Right now the problem has descended to finger-

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