Rocket MultiValue

Emma Breslin March 5, 2024 The Rocket MV team is pleased to announce the release of UniData 8.3.1, U2 Common Clients 5.4.1, and MV BASIC for Visual Studio Code (VS Code) 2.4.0 on February 26th, 2024. Rocket® UniData 8.3.1 UniData 8.3.1 HA/DR enhancements and bug fixes help you manage your replication environment more effectively. We’ve added a new script so you can stop and restart the repmanager, eliminating the requirement to restart UniData if the repmanager becomes unresponsive. We’ve enhanced the "invalid log sequence" message to include the actual and expected LSN number, which will assist you when debugging. We’ve added a skip option to the ud_repadmin command to facilitate recovery from stalled subscriber groups. UniData 8.3.1 security upgrades and enhancements help keep your applications and business safe and compliant. By upgrading to OpenSSL v3.0, UniData supports a wide array of protocol levels. OpenSSL 3.0 includes a major architectural change from OpenSSL 1.1 and bring

Paul Chang June 12, 2019 Using multiple unirpcd daemons to balance client requests can have a positive impact on performance. Also, using a different port for a specific application simplifies management. And, if users are on a newer version of UniData or UniVerse, they might want to use a different port specifically for a secure connection. On newer versions of UniDataand UniVerse, multiple Unirpcd Daemons with different port numbers on Microsoft Windows is supported. When you install UniData or UniVerse, the unirpcd daemon uses deaful port # 31438. This allow all U2 clients ti connect to the UniData or UniVerse server without any additional setting. You might want to start two unirpcd daemons with two different ports for shared unirpcd daemon loading. This blog provides details on U2 clients working against the Unirpcd daemon with different port setting., e.g. # 32438. REQUIREMENTS Data Server Verson UniVerse (Windows) 11.3.1.6018 or later Univers (UNIX) 11.3.1.6022, 12.1.1 o

Emma Breslin July 16, 2024 Rocket UniVerse 14.1.1 builds upon functionality implemented in version 11.4.1 and 12.2.1, making it the upgrade and modernization path for all customers on all prior versions. UniVerse 14 ensures business continuity and helps you manage your replication environment effectively with key HA/DR features. Replication is faster and more flexible with Field-Level Updates, since the entire record is no longer transmitted during updates, only the individual field that was modified is replicated - significantly improving performance! Facilitate Replication recovery with the uv_repadmin skip option which allows you to skip an incomplete transaction that has caused replication to stop processing. By using the skip option, administrators keep Replication processing and avoid log build-up and the eventual reset and refresh of Replication due to a stalled group. Facilitate Replication recovery with the enhanced uvreptool. When Replication has stopped processing due to

Safwat Boulos January 24, 2019 We live in a fast-paced world where executives need real-time reports to make business decisions. Thus, users need information at their fingertips to deliver those reports. If your business-critical data lives in a UniDataor UniVerse MultiValue database, External Data Access (EDA) can help. What is EDA? EDA allows users to convert UniData and UniVerse nested relational data to First Normal Form (1NF), where it can reside in a SQL Server, DB2 or Oracle database, making the data easily accessible to standard tools such as Crystal Reports or any of the many open source products. EDA benefits and implementation EDA allows users to seamlessly transform your UniData and Universe nested-relational data to a normalized form where external SQL tools can access your MultiValue application’s data. Since most users are accustomed to SQL, EDA makes them independent, allowing them to manipulate the data and generate the reports of their choice. EDA lifts the burden fr

Jonathan Smith March 13, 2019 UNIDATA HASHED FILES AND OVERFLOW In this first section we are going to discuss the two main types of UniData Hashed File (Static and Dynamic) and we’re going to discuss the two types of overflow that can occur in these files. The objective of file resizing is to minimize overflow as overflow is a performance overhead. 32-BIT V 64-BIT DYNAMIC HASHED FILES 32-Bit A UniDatastatic file or a sub-file of a dynamic file are limited to 2GB in size. Theoretically a UniData dynamic file can grow to 500GB but the internal management of these multiple sub-files requires complicated code and multiple file I/O operations and hence reduces performance of the files. The block-size of the data file is limited to 16K and as data records are now getting larger and larger this also is a performance limitation of the 32Bit model. 64-Bit The 64-Bit data model introduced at UniData 8.1 will resolve these issues so that data files will have virtually no restrictions on file siz

Paul Chang July 18, 2018 External Database Access (EDA) enables you to convert data stored in Rocket UniVerse and Unidata databases to a first normal form (1NF) database, such as Microsoft SQL Server, then access that data using existing UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. For the UniVerse I-type fields, they can be mapped in many ways to SQL Server. This post will expand the mapping section of the External Database Access manual. Some additional mapping for I-type field dictionary items will be supported in UV 11.3.1.6018 or later version. In this post, you will learn how to work with the UniVerse EDA solution with I-type field dictionary items. I will provide you with sample steps for each of the different I-type field conversions against SQL Server. Note You must order an additional UniVerse EDA package license to work on this solution. The EDA license information could be verified using the “uvregen -z” command. REQUIREMENTS Rocket MultiValue product Ver

Hi All,We have a customer who are upgrading their hardware and OS to a Hyper-V environment running Windows 2022.Does anyone have any experience of running Unidata/Windows 2022 in a Hyper-V environment? Any issues we need to be aware of?Any comments/suggestions are much appreciated.Many thanks.Barry GreenCBS Software

Hi everyone. Does anybody know the what the cost would be to upgrade to Universe from mvBase, if they have an active support contract for their mvBase installations? Any insight would be helpful. Best regards, Richard ------------------------------Richard OldsDirectorCalidore LtdUKrichard@calidore.comwww.caldiore.co.uk------------------------------

Hi, We recently (last week) installed OpenQM 4.0-9 onto my new notebook. Today, I found that some spreadsheets that rely on the QMClient connection were not working (could not connect to server). It turns out that the QMClient.dll was installed into C:\\Windows\\SysWOW64 instead of C:\\Windows\\System32. Has anyone else struck this? And can someone from Rocket comment on why this is occurring? [Those Windows folder names are quite misleading. System32 is supposed to contain 64-bit libraries, while SysWOW64 contains 32-bit libraries. Who thought that was good naming?] Cheers, Brian------------------------------Brian SpeirsWellington NZ------------------------------

Hey all- I've managed to locate the Unidata Dictionary, Commands, Basic and Administrator manuals. But, after years of being on other platforms, I'm really struggling with queries and report formatting in UniData. Operators like BY-EXP, ID.SUPP, HEADING, etc, keep popping into my recollection, but I'm still having a difficult time with syntax and order. The UniBasic manual helps to some extent, but I'm hoping there might be a more in-depth Manual (or training) specific to creating and formatting reports from ECL.thanks in advance for any assistance- Rich------------------------------Richard LucibellaDirectorRocket Forum Shared Account------------------------------

Hi everyone. Does anybody know the what the cost would be to upgrade to Universe from mvBase, if they have an active support contract for their mvBase installations? Any insight would be helpful. Best regards, Richard ------------------------------Richard OldsDirectorCalidore LtdUKrichard@calidore.comwww.caldiore.co.uk------------------------------

We are building an Net 6 API using UODOTNET to interface with a UNIDATA.we are using version 3.171.0.08 of the library dated 9-14-2016Data is coming back but  the value and attribute marks are using the same value and it seems to be a wide char value 65533 instead of the regular 253, 254.Code snipit:debugger output:Is there a newer version available(UODOTNET)?Has anybody dealt with this before?Thanks in advance for any assistence wih this matter.Dave Just Dave

Does Rocket have any future plans for a uvnet comparable for uniData?

Hi, We are experiencing issues with our UniVerse session, where randomly the session gets frozen and becomes unresponsive. It's random and occurs once or twice per month, and the only solution we have is to restart UniVerse and it starts working. Has anyone experienced this issue or is there a fix around this. We are using Centos to host UniVerse 11.3.1 and this issue has started since November last year.   Below is a sample error message : kernel: uvapi_server[9052]: segfault at 0 ip 00007f7aa5a6b586 sp 00007fff414b15e8 error 4 in libc-2.17.so[7f7aa5938000+1b6000]kernel: uvapi_server[9045]: segfault at 0 ip 00007ff5418e0586 sp 00007ffc9b5592a8 error 4 in libc-2.17.so[7ff5417ad000+1b6000]  Thanks,------------------------------Amarendra RakeshBusiness System ManagerSMC CorporationSydney NSW AU------------------------------

Trying to get ODBC working.  Not sure how to address this error.  Help? 

MV folks, We have a GUI client that runs only in Windows to access our MV/Universe application - and am looking for input from other MV community members on Windows functionality / partition / whatever on a Mac for some users at a new customer.

Hello - I'm having trouble getting the symbol table to load while in the debugger - can someone tell me what I'm doing wrong please? ***There is no symbol table in '/usr/ud/sys/CTLG/m/MV.EMAIL.BUILD.TO.PC.AND.TO.SB'!EXEC BASIC MV.BP MV.EMAIL.BUILD.TO.PC.AND.TO.SB -Z2***Executing UNIDATA command:  BASIC MV.BP MV.EMAIL.BUILD.TO.PC.AND.TO.SB -Z2 Compiling Unibasic: /db1/ud1/PGM/MV.BP/MV.EMAIL.BUILD.TO.PC.AND.TO.SB in mode 'u'.compilation finished!Z MV.BP MV.EMAIL.BUILD.TO.PC.AND.TO.SB***There is no symbol table in '/usr/ud/sys/CTLG/m/MV.EMAIL.BUILD.TO.PC.AND.TO.SB'------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

We turn on work wrap in our Grids. However, we would like to programmatically force a line feed in a cell of the grid. We have not found the character to use to force this to happen. we would typically do: tmp.tab<1,row.ptr,col.ptr> = data.record<1,1>:data.record<1,2> we would like the data.record<1,2> to be on the second line in the cell of the table we have tried the pipe character (such as Combobox in a grid column).  Have not found this in the manual and/or several places online.------------------------------Jesse TilliaProman-ERP, Inc.West Seneca NY US------------------------------

One of my customers has several users who work on both the workstation at their desk and from other locations on a laptop.  Will the Personal installation allow for a single seat to be used for installations on two machines as long as they are only using one at a time?  Or will they have to use the Portable installation on a memory stick? Dale------------------------------Dale KelleyI'm it!Dale W Kelley IncHohenwald TN US------------------------------

I've noticed that a number of lppick processes are hanging around long after they should have exited.  I've seen this in v9, but I figured it was just a bug that would get resolved with v10.3.4.  Apparently not. :( Example: In the past, I've just killed these processes but before I go about that this time, I wanted to find out if there was something I can do to ensure that it doesn't keep happening. I should note that this isn't isolated to one of my plants - here's the list from my other plant: Both hosts are on RHEL 9.4 and using D3 v10.3.4. What do I need to do in order to keep these orphan processes from stacking up? Thanks folks! g. ------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific WindowsUS------------------------------

Hey, guys. new here. Programmed PICK and Unidata back in the late 80's / early 90's and I'm REALLY rusty. Can anyone tell me where to find a Dict Reference Guide?Thanks much- Rich------------------------------Richard LucibellaDirectorRocket Forum Shared Account------------------------------

I have installed the DBTOOLS BASIC DEVELOPER TOOL KIT but I am having issues. Here is some info and a couple of issues I am having and would like some suggestions or advice on what to do next or what I may have done wrong.  We went through the install steps and see these were installed. The BDT launches but fails to update the subroutines. I set permissions on the folder to /usr/ibm/uv/BP.O to write for everyone but it still fails. When connecting I get the following messages and click OK to update. I have set the permissions to the folder so that everyone has write permissions but still get this error. Since the program launches, I decide to try something simple like opening a program but get this error. The source code does exist in file of the shown in the VOC of CK.DATE. Thanks in advance for any assistance.

I have one user who has severe mouse problems inside a spreadsheet that has been executed from AccuTerm.  If the same spreadsheet is opened from Excel itself or from the file explorer, everything works normally.  The problem is a severe lag in any mouse commands.  If the user clicks on a cell, it is 2 to 5 seconds before the cell that was clicked on becomes selected.  If the user tries to drag a selection in order to select multiple cells, there is also a severe lag. The user is on the latest version of Accuterm I have which is 8.1.2.1137.  The mouse pattern file is identical to what I and other people are using. Has anyone encountered this before?

We run d3 on an Windows Server 2008 Can someone describe how to move d3 to a new server (windows 2012)? eg;  Download installer to create the d3 environment Move live data from current server to new server. Explain how the license which allows the application to run is transferred to the new server. Thanks, Bret Stern ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

This is probably an easy question for someone but I dont know the answer. I just switched to a new job and their wildcards seem to be prime like instead of PICK like...for instance - where I used to type 'SELECT VOC = "[KH]"' they are typing 'SELECT VOC WITH @ID LIKE "...KH..."' Can someone tell me if this is a UDT option? term type? some other setting that I can adjust? I can of course just get used to the new syntax but was wondering why it is different. Thank you Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------