Rocket MultiValue

I am working on a SB+ screen app where when I bring up a record, information gets displayed, and then when I immediately press F2, this error (in the subject) is displayed followed by:index: 0 to one dimension matrix is out of range..at which time SB+ aborts to the colon prompt.I've checked my code to see if I'm updating some common variable in an unusual fashion but not finding anything like that.  Can anyone with access to the source please tell me which variable is whacked and what I can do about it?Another oddity, I am pressing F2 while the common variable CNT = 1. However, when inspect ​CNT, it's always 1315 - which is about 22% through the mv's being shown on the screen.  This doesn't happen all the time, but with one specific record I can make it happen EVERY time.  Also, I checked the record for any weird control characters and there are none.  I even removed the mv set of data with CNT = 1315 and CNT is still 1315 when it blows up.  Any input about what variable is whacked wou

As I've mentioned, I am on Universe, on Linux, using Accuterm. There is a format in these programs I've inherited that looks like this....FPATH='C:\\Users\\kathleenh\\Downloads\\'DOC='2022-Farm-Market-Application.pdf'PRINT CHAR(27):CHAR(2):"<":FPATH:DOC:CHAR(13)Don't really understand it, but don't need to if it works - which it does :)But what I am trying to do right now is move a doc (jpeg, xlsx, word, pdf, whatever) from either a network spot OR a c drive location to another spot within a basic program. I tried using a '<' and then a '>' for the two locations but that didn't work.My question is does anyone know how (or if possible) to use this feature (which I think is Accuterm) to move a file from one location to another?OR......What other functions / tools would work to do this? Obviously the user has to have permission to both files. Since I can do the above command to either the C drive or network drives I imagine access is not the issue or holdup - just my ignorance. I

Docker ContainersjBASE is officially Docker certified! With a single command, you can pull down a working jBASE image from the Docker Hub and have your jBASE application up and running in a container. What used to take days can now be accomplished in seconds - it really is that easy.With Docker, you can package every piece of your application and database into lightweight, portable containers that build themselves. If you have ever built a MultiValue environment from the ground up, you know it is a long process. Our Docker images bundle everything you need - from Linux to jBASE - to get your application working with the click of a button.Can you containerize a MultiValue database from one of our competitors? Probably. But chances are good it will still look and act like a monolithic virtual machine. jBASE is the only MultiValue database that can be broken down in the true spirit of containers with your database and application running in separate Docker containers.What is a Container?A

The following changes apply to the Windows installer for jBASE release 5.8: Compiler installation is treated as a prerequisite and is prompted for first. If compiler installation is skipped the user will receive a warning to confirm that this is intentional. After accepting the license agreement, the Microsoft Visual C Runtime is installed, and some temporary files needed by the installer are unpacked. After selecting an installation type (Express or Advanced) and the installation directory (JBCRELEASEDIR), there is a new prompt to select the jBASE Global directory (JBCGLOBALDIR). Beginning with release 5.8.0, all configuration files and some other common files have been moved from JBCRELEASEDIR to JBASEGLOBALDIR. In this way, upgrading to newer jBASE releases is simplified because the configuration information is stored independent of the jBASE release. License keys are no longer entered during installation. Follow instructions included with your license document for entering license

Thanks for the response Henry, I would like to receive some information on your offering. dalekelley@dalewkelleyinc.comDale>>>> Hi Dale,>> Integration with Esri ArcGIS is a core part of our UniVerse-based > solutions. We use several different ArcGIS APIs to both provide > information to ArcGIS and retrieve information therefrom, include > REST, JavaScript, and GeoEvent over WebSocket. Use of those method > also provides the data to ArcGIS to construct Esri ArcGIS Dashboards.>> Henry>> *Reply to Group Online > * > *View Thread > * > *Post New Message Online > *>

Registered yet?Join the MV product management team in two weeks to learn about what's new and what's next in the Rocket MultiValue product segment. There will be two sessions so we hope one will fit your schedule. Register here: https://info.rocketsoftware.com/MV-2022-Roadmap_LP.html------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY US------------------------------

Reading the documentation for @ Variables, it seems inconsistent for @DAY to come from the established @DATE, yet the other, similarly named variables should be based on the current date. Variable Read-Only Value @DATE Internal date when the program was invoked. @DAY Day of month from @DATE. @MONTH Current month. @YEAR Current year (2 digits). @YEAR4 Current year (4 digits). The following experiment confirms the current-date @ variable documentation does not reflect the behavior of UniVerse 11.3.1.6022. All values relate to the established @DATE value. Disabling automatic date and time, set the clock to late New Year's eve, run the program, celebrate the new year, and let the program finish. AtDay 0001 program AtDay 0002 0003 D = DATE() 0004 print "DATE(): ":DATE():", ": OCONV(D,"D4/") 0005 print "@MONTH: ":@MONTH 0006 print "@DAY: ":@DAY 0007 print "@YEAR: ":@YEAR 0008 print "@YEAR

Registered yet?Join the MV product management team in two weeks to learn about what's new and what's next in the Rocket MultiValue product segment. There will be two sessions so we hope one will fit your schedule. Register here: https://info.rocketsoftware.com/MV-2022-Roadmap_LP.html------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY US------------------------------

Registered yet?Join the MV product management team in two weeks to learn about what's new and what's next in the Rocket MultiValue product segment. There will be two sessions so we hope one will fit your schedule. Register here: https://info.rocketsoftware.com/MV-2022-Roadmap_LP.html------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY US------------------------------

Registered yet?Join the MV product management team in two weeks to learn about what's new and what's next in the Rocket MultiValue product segment. There will be two sessions so we hope one will fit your schedule. Register here: https://info.rocketsoftware.com/MV-2022-Roadmap_LP.html------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY US------------------------------

Trying to run CONVERT.SQL but getting an error.  Not sure how to track this user down or change the owner.  Clearly that uid is not a windows guid.  The user id doesn't show up in LISTUSERS.  I'm an admin on the server but I'm not sure how that relates to a superuser in unidata.Thanks,Seb------------------------------Sebastian NahapetianRocket Forum Shared Account------------------------------

Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART:SET-DATE-WINDOW 60This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application.I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat.https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/refman/index.htmhttps://www3.rocketsoftware.com/rocketd3/support/documentation/d3server.jsp------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software-----------

Hi Folks, newbie here.I have a UV account that I've backed up using uvbackup.  I want to restore that account under a different account name.  I'm not seeing any options on the uvrestore utility to do that.  I definitely don't want to overwrite the existing production account with what I backed up previously, just set up a duplicate (although outdated) test  account.  Does anyone have any pointers to restore, say, the ACCT as TEST_ACCT using the backup file I created as shown below?Backed up using:   D:\\U2\\UV\\bin\\uvbackup.exe -f -v -nodrive -walk D:\\dbms\\DATA1\\ACCT > D:\\UVBACKUP\\UVBACKUP_ACCT.UBK------------------------------Mark BakerSelect* Associates IncTimonium MD US------------------------------

Hi, all. I used to work for a Rocket UniData client who was able to restrict permissions on production in such a way that for designated production logins, it was not possible to write to disc. One could use the editor, but not file the record; no compiles or catalogs; no file creation; etc. Is there a documented way of setting up this feature? [It has obvious implications for SOX compliance.]------------------------------Ken CibellideveloperRocket Forum Shared Account------------------------------

After working through the extension quick setup I am getting this popup messageMy current settings are This is what is in the directoryC:\\OpenJDK\\jdk-11\\bin>java -versionopenjdk version "11" 2018-09-25OpenJDK Runtime Environment 18.9 (build 11+28)OpenJDK 64-Bit Server VM 18.9 (build 11+28, mixed mode)C:\\OpenJDK\\jdk-11\\bin> So what is so "irregular" about this setup, and how do I fix this?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

Monday marks the pick Julien calendar roll from the 10 to 20 thousands. I'm sure most of you remember when we PICK folk went from four digits in our internal dates to five, back in 1995.Since then I've managed to create an entire additional adult human, as well as create umpteen lines of code.I felt the occasion was worth notice. Anyone have any anecdotal stories of that eventful day? Kathleen------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

hello One behavior of UV / Windows Port.Status that I have never resolved is the presence of Unavailable as the last process command. Which greatly slows down the output of port.status. Have you ever experienced  such a situation? sample There are currently 48 uniVerse sessions; 19 interactive, 29 phantom Pid.... User name. Who. Port name..... Last command processed.......10760 efv 9 Unknown Unavailable  8104 jcd -30 Unavailable  4132 jcd -43 Unavailable  8588 jcd -44 Unavailable 10660 jcd -46 Unavailable ------------------------------Manu Fernandes------------------------------

Hi allI've been doing some experiments accessing UniVerse data via Python for some time and I had my own library before the official Rocket uopy utilities were available to me.One thing I implemented is my own custom representation of a UniVerse record as a Python dictionary and I was wondering if it would be useful to anyone. Maybe I can add it to the Python github.Anyway, I'll explain the logic in my implementation and why I still use it in some places instead of the "natural" DynArrays.My implementation stems from the structure of a lot of the data we use here, as a lot of records are sparsely populated (I use to call my own records "sparse records" to differentiate them from the DynArray)Example: A register with 90 values, which only 4 contain real data. One of them is a multivalue that also contains several "empty" fields.1. "Value1"2. "Value2"3. ""4. ""...60. "a|b|c|d||||||||m|n"...90. "Value90"Using a DynArray results in a mostly empty list, with the footprint that this involves

We're ready for the next round of testing of D3 Linux v10.4 Port!! Since the last round of testing, we have been working hard to make a more complete product. We have addressed a number of bugs, but more exciting than that is that we have added the FSI to our UNIX implementations. This allows us to offer the most highly horizontally scalable multi-value solution on the Unix platforms as we have previously offered on Windows. By decoupling the FSI and VME environments, you can achieve a more seamless cloud experience. Creating a docker instance of your application server (VME) while still utilizing a singular shared Database (FSI) can give you easily deployable instances of your application. If you are interested in assisting us with this exciting newly-architected product, please reply to this post, or email trude@rocketsoftware.com. We are looking forward to working with you again.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software-----------

Hi allJust your thoughts on how much memory should be allocated to a system with < 20 users? (NO Flash basic - Linux D3 (Ver 7.4))The users are complaining that the system is "slow" with 2.62144 TB. (yes you read correctly 2.62144 Terra Bytes) !In my opinion, this is FAR TOO much - and should be reduced to say 16 GB otherwise there is the chance of (per manual) "High values can result in poor performance of other UNIX processes due to inadequate remaining memory."What say you?------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

Greetings! Has a newer version of the Extensible Admin Tool been released?  I just requested the 'trial download' from the Rocket site.  It sent me a download link, but the software it downloaded is the same version I already had - version 4.14.0, Build id: 20181218_2890, as part of DBTools version 4.4.0, from 2018.Is there a newer version - and if so, is there a way to get to it without going through the "sign up for a trial download" process?Brian Paige------------------------------Brian PaigeEnterprise Systems ManagerSerta /Simmons Bedding LLCDoraville GA US------------------------------

I have seen a bunch of changes through the years on additional functionality on this tool. Is there a comprehensive list of what this tool currently can do? I am a VAR and one of my clients expressed interest in it and I cannot find anything on the website.Below are a bunch of questions about the functionality this product has: How does it keep the connection alive if I am in a zoom meeting for 4 hours? Does it allow record locking on the server while I am editing it? Is there a before Read Call? Is there an after Write Call? Is there an after Delete Call? Is there an automatic save after so many minutes? Is there an option if not locked it can tell me the original has been updated? Is there an option when I compile in Unidata I can request the BASICTYPE? Is there a way I can put bookmarks, tasks, or information locally and not in the code? Is there a key sequence I can get where I can get syntax help for commands such as CASE, READNEXT, etc? Is there a way I can get actual errors as

I have a customer using Accuterm 8 who are going to replace 3 of their workstations. Has anyone done this? I'm wondering about the license validation.Dale

Hi,I've installed Universe for Windows community edition.   I want to do a couple of things - install the Developer tools IDE and/or VS Code to edit BASIC programs, and, also test python code executing in Universe to utilise external python modules  and libraries.I can get to the XDEMO account at the BASIC MV shell, and LIST PRODUCTS data.I have tried and failed to connect the Basic Developer Toolkit. I cannot find what username/password to use. When connecting to my instance, what is the default username/password combination or should I set an account up and if so how ?  I think this will also help me connect up VSCode.As a follow up question, I have  python module which I want to include in a python program which I execute in Universe.  Is there specific process I need to run in order to include this module for use ?  I tried to run pip install <my module.whl> but this did not seem t import my module.Thanks - Steve------------------------------Stephen PisaniRocket Forum Shared

Looking to see if anyone has successfully integrated D3 with UPS WorldShip using ODBC -When voiding a shipment/package in WorldShip, I receive a duplicate key error because it appears that it's trying to perform an insert instead of an update statement.On void in WorldShip:Execute 0F99B418( INSERT INTO ups_packages ( ...., voided, id, shipment_id )  VALUES ( ..., 'Y', 'PACKAGE ID', 'UPS SHIPMENT ID' ) )Execute 0F99B418( INSERT INTO ups_shipments ( ...., voided, id )  VALUES ( ..., 'Y', 'UPS SHIPMENT ID' ) )Given that these records already exist, and we're just trying to set the voided flag, it should be an update statement:update ups_packages set voided = 'Y' where shipment_id = 'UPS SHIPMENT ID'update ups_shipments set voided = 'Y' where id = 'UPS SHIPMENT ID'Everything else seems to work.Did I miss mapping something in WorldShip?  Is this a known issue?  Any ideas on how to work around this?Appreciate any help!------------------------------Jeremy LockwoodAwesomeASE Supply IncPortland