Rocket MultiValue

Hello everyone, i'am updating my server hardwarei'm going to have 256 GB , processor 40 cores, i have 128 users, and my D3 base current has 293 GBthis is my current pick0, what settings i should change for the new configuration D3 10.2 Linux name LINUX pick0nice 0user pickcore 77165824 10npibs 700nphts 120basic 0brkchr 00escchr 1babsbase 18abssize 708abslock onblkfid 4flush 10dwqnum 256clocal offrawdisk onflushers 4

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

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