Rocket MultiValue

Hi, We recently encountered a data file corruption on key files. This was causing our app to fail. Does anyone in the forum have knowledge of any tools that will send email alerts once a new entry is logged into the \\U2\\unidata\\bin\\udt.errlog. Thanks in advance for recommendations. ------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

SB/XA 6.6.1 is now available and includes a lot of smaller enhancements that add up to big improvements, especially if you have an IT group that requires software to work with or include current releases of other technology. For example, SB/XA 6.6.1 includes extensive upgrades to the Xceed DataGrid and the Xceed Toolkit, as well as upgrades to the .NET Framework. These upgrades empower SB/XA to work seamlessly with the latest version of the tools you rely on.  Xceed DataGrid v7.2 (from v5.3)  Xceed Toolkit v4.8 (from v4.5.1)  Both upgrades provide you with a decade or more of incremental performance and stability improvements. And SB/XA 6.6.1 is using versions of the Xceed DataGrid and Xceed Toolkit that are covered by Xceed support.  We've upgraded the .NET Framework to v4.8 (from 4.5). This highly compatible upgrade includes improvements made to the Framework over the last decade.    Finally, SB/XA 6.6.1 includes a roll up of all the hot fixes we've made since SB/X

Hy i have some data ( zipcode database) that i need to transfer from QM to D3i created the tapebut i'm not able to read in D3any sugestions ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

Using a BASIC program, I need to read filenames and file dates from an AIX directory and compare them with names and dates held in UniVerse records. If the files are present among the UniVerse records then they need to be moved out of the directory and more files added from another directory. Any advice or code snippets much appreciated.

Could someone explain why these messages appear and the shell window closes when I use Ctrl-C and then option D while running a Unibasic program? ------------------------------Mark MartinNARocket Forum Shared Account------------------------------

We upgraded our development server to Universe 11.3.4 and one of my programmers wants to work with Basic Profiling, in particular the bpf program. Where do we find it? I had understood that it was available on this version, but it's not in $UVHOME\\bin.------------------------------Phillip PotterV.P. R&DData Management Associates Inc DMACincinnati OH US------------------------------

We use @USER0 for an application-level constant.  We set it in the LOGIN paragraph & it should remain constant. I've seen it sometimes - but not always  - get set to 0 after/while? I've used/exited(?)/re-entered(?) RAID.  I haven't pinned down what triggers  it. Ironically, the reassuring thing is that RAID is disgustingly buggy.  I've had problems in RAID that don't happen when real users run things for real.  So it's probably ok in production.  Probably. Anyone else seen something like this?------------------------------Chuck StevensonDBA / SW DeveloperPomeroyUS------------------------------

The Rocket MV team is pleased to announce the release of Rocket UniData 8.3.2 and Rocket MultiValue Performance Experience (MVX: Performance) 1.10 on April 25th, 2024. UniData 8.3.2 is the first UniData release certified with the Rocket MultiValue Performance Experience (MVX: Performance) 1.10, which is available for our customers on maintenance. MVX: Performance monitors the performance of your UniData server and provides DBAs or developers with a better way to track down issues. It determines the root cause of issues, including the server, the operating system, the hardware, or a combination. DBAs can easily receive alerts when over 40 performance monitoring events occur, so constant monitoring is not required.  In addition, UniData 8.3.2 and MVX: Performance 1.10 provide you with an enhanced replication experience, bolstering High Availability and Disaster Recovery (HA/DR) capabilities. UniData 8.3.2 extends the security features introduced in UniData 8.3.1, which included: Enhance

We have encrypted a number of files. We can grant access to those encrypted files by using the GRANT.KEY command - but this only seems to work for USERS - if we specify a GROUP, then users that belong to that group cannot access the file. The documentation isn't clear on what type of GROUP is being specified - whether this is a Windows group, or a QM group (as defined in ADMIN.USER). We have tried both types of group and still get the same result. Has anyone else used this feature, and have you been able to define group access for an encrypted file? Thanks, Brian------------------------------Brian SpeirsSenior Analyst - Information SystemsRush Flat LtdWellington NZ------------------------------

Is there a .Net Core / .Net 6 compatible MVSP Client API?  If not, is there any planes to support this?I have tried using API version 2.1 for .Net Framework 4.5 in a .Net 6 core application and get the following runtime error.Exception:The type initializer for 'rocketsoftware.MVSP.TIGRCommmon' threw an exception.Inner Exception:Could not load type 'Microsoft.VisualBasic.ApplicationServices.User' from assembly 'Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'..Net Framework DLLs can be loaded into .Net 6 as long as the DLL’s referenced assemblies has a compatible .Net Core equivalent, 'Microsoft.VisualBasic.ApplicationServices.User'  was not ported to .Net Core.Thanks, Bill

 I can't get MVSP on my Linux D3/10.2 server to work with SSL.  I have a server.pem file in the /usr/lib/pick directory and MVSP seems to start ok when I instruct it to do so with ssl. But if I try to use openssl to connect to it, it acts like there is no certificate: # openssl s_client -connect localhost:9000CONNECTED(00000003)140144259938192:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol:s23_clnt.c:794:---no peer certificate available---No client certificate CA names sent---SSL handshake has read 7 bytes and written 289 bytes---New, (NONE), Cipher is (NONE)Secure Renegotiation IS NOT supportedCompression: NONEExpansion: NONENo ALPN negotiatedSSL-Session:    Protocol  : TLSv1.2    Cipher    : 0000    Session-ID:    Session-ID-ctx:    Master-Key:    Key-Arg   : None    Krb5 Principal: None    PSK identity: None    PSK identity hint: None    Start Time: 1723061738    Timeout   : 300 (sec)    Verify return code: 0 (ok) and if I try it with the C# library, I get an

For a conversion project at a customer with 4000 custom programs written over 30 years we're trying to get a handle on which programs are actively used.  One idea that's been floated is running a monitoring program as root from the demo account that does the pseudo code below. By definition we'll be running this in production for a month or three, and there's some justified nervousness about any potential performance impacts.  I don't think the monitoring program will be a performance hog itself, but not sure if doing PORT.STATUS on the probed program has any effect - does it "pause" the probed program so the stack collected is consistent for example?  We're not expecting to get 100% coverage from this, but even 80% would be a huge help. Anyone ever done something like this for real?  Any war stories or hard-won words of wisdom to share?  Thanks for reading! LOOP EXECUTE 'LISTUSER' LOOP FOR EACH ROW IN LISTUSER RUN "PORT.STATUS PID <ROW.PID> CALL.

I wondering what others do for pessimistic locking strategies. D3's normal READU will lock a record for that PIB, and that execute level, which is good, and it is the behavior all D3 Basic programs probably use.  My character based apps allow a user to "push" a level, so if you were in a customer maintenance screen,  for example, the customer record ABCD would be locked, and if you pushed a level in that screen  and used a menu selection to open a new customer maintenance screen and tried to edit ABCD, it would locked via the normal READU behavior. This would work the same if some other user on another PIB had  ABCD locked.  With  a Java Swing app using MVSP, because it's a GUI, I can have multiple windows opened at the same time, so I could have 2 (or 200)  customer maintenance screens open and clearly don't want to edit the same record on more than one screen.  If I used one D3 connection per open window, I'd pretty soon run out of user licences, so I'm only using one D3 connection f

Ran into a problem on an Azure RHEL 9 instance where D3_setup could not execute anything out of the /tmp directory resulting in a failed install (/usr/bin/d3 missing, etc.). If you run into this, do the following as root: mount -o remount,suid,exec /tmp You should also alter the /etc/fstab to make this permanent after a Linux reboot. Find this:/dev/mapper/rootvg-tmplv   /tmp   xfs  defaults,rw,nosuid,noexec,nodev,relatime  0 0 change this part:nosuid,noexec to this:suid resulting in this:/dev/mapper/rootvg-tmplv   /tmp   xfs  defaults,rw,suid,nodev,relatime  0 0 While not related to D3 installation, it might be a good idea to make the same changes for the /home directory so that you can execute out of the /home directory as well. To do that, change this line in /etc/fstab as well: Before:/dev/mapper/rootvg-homelv  /home  xfs  defaults,rw,nosuid,noexec,nodev,relatime  0 0After:/dev/mapper/rootvg-homelv  /home  xfs  defaults,rw,suid,nodev,relatime  0 0 The mount would look like this:moun

A quick question from an mvBase user. Is there any way to get past the page width limitation of 132 characters as imposed by mvTerm? Is there an alternative terminal emulator that works with mvBase that could be used that does not have this limitation? Thanks! ------------------------------Edward SmithIT Services & Data Manager------------------------------

Hi All,  This is embarrassing (but not)Please help me here, I need to mount (such that tI may issue a t-select verb in D3) a new tape which is NOT included in the Pick0 file.I know this is doable but I forget the TCL command that does this.I'm on D3 Linux (Redhat) V 10.3 xBTW - I've Googled "Rocket D3 Linux mounting a new tape device" but I really haven't seen a proper answer.As I said - I've seen this before but I have a brain freeze right now :(Stefano

Hello, Our apps are written in SB+ which use a cached opened files, in named common block SBPLUS & SBFILES, of 30 + 750 = 780 filevars (result of OPEN file TO filevar from BASIC). Some of our app's files are indexed, dynamic or distributed.  It means, with 780 cached filevars, we open more than 1000 os file.  With release 11.x we are used to set MFILES 3000 without never a trouble.  Now r12, r14 introduce SESSION_NFILES limit. Which is session's ActiveFileTable instance. SESSION_NFILES is not defined in uvconfig. CONFIG ALL report SESSION_NFILES = 800 ; aka. MFILES x 4) Then, at basic runtime we encounter OPEN file to fv ELSE CRT STATUS() =  -25 which is Exceeded SESSION_NFILES file table resource.  I try to push MFILES from 200 to 300 or set SESSION_NFILES to 2000 in uvconfig ...  - uvregen accept it  - at uv -admin -start I get  StartService failed (1068)  minidumpexception* Unhandled Exception raised at address 0xE7261759 : Acces

I would like to obtain the workstation hostname when a user logs into a Linux system.  I had it available on our Solaris Unix server but not on our RHEL8 server.  We use this to identify a physical location and to associate network printers nearby.  I am able to get the workstation hostname when in Citrix and by using Accuterm and checking a Session clientname but it is not always present when directly on the network and wondered if it was somewhere else Available to Accuterm.  Where can I found out the PC workstation hostname and what other windows information like this might be available to harvest? 0097:             * Check for citrix environmental variable CLIENTNAME0098:             SCRIPT = 'InitSession.Output Environ("CLIENTNAME") & vbCR'0099:             CRT CHAR(27):CHAR(2):'P':SCRIPT:CHAR(13): ; INPUT CLIENTNAME: ;  IF CLIENTNAME # '' THEN CRT "<-ClientNam

Currently, running 34 jobs in scheduler.  Recently, the scheduler stopped running on 7/21/2024 and started backup on its own on 7/31/2024. Any idea why this would happen?  Are there any updates to address this? Thanks in Advance!------------------------------Val YanezSoftware EngineerSouthwest Traders, Inc.------------------------------

hello,  Under UV r14, these 2 uvconfig GLM_MEM_ALLOC / N_GLM_SELF_BUCKET are documented as :  GLM_MEM_ALLOC - The number of lock nodes allocated for each memory request. This parameter is highly application dependent. if the application requires a large number of locks in one transaction, this setting should be increased to the maximum number of locks per transaction * 2.  N_GLM_SELF_BUCKET - The number of hash buckets for the per-process locking table. This parameter is highly application dependent, If the application requires a large number of locks in one transaction (more than 20), you should increase this setting to the closest prime number to the maximum number of locks per transaction.  So, they are delivered  GLM_MEM_ALLOC 10 N_GLM_SELF_BUCKET 23 So, I try to set locks with READU and I have no problem to set 30'000 locks in one basic loop !  Are they not used if SYSTEM_BUFFER = 0 ?  Thanks for any explain. manu

Hi all,   Is it possible in AccuTerm to call another project from a command button in a different project. I have developed a Customer Maintenance Project with 5 screens and a Customer Enquiry Project with 7 screens. But my customer has now asked to be able to Call the Maintenance Project while in the middle of an Enquiry when they have noticed a problem that need updating, i.e.  wrong phone number.    can this be done or do I need to redevelop my whole maintenance again inside the Enquiry. I have tried several things but nothing works as I had hopped Can ANY ONE help by pointing the way please   haha------------------------------Chris BaxterMDCB SoftIPSWICH GB------------------------------

I am indexing a 21,000,000 record file on the invoice date.  It is a single value field, and when I build the index it works correctly based on the records in the file at the time of the build.  After that, new records or changed records are NOT added to the index. Is there a setting related to indexing that must be set to auto update the index? I have read all the UniData documentation on indexing that I can find. I have been using indexes in other versions of Pick for decades and this is the first time I have hit this problem.------------------------------Bob LislePresidentInformation Technology SystemsDallas TX US------------------------------

In AccuTerm Tools Tab -> Settings -> Connection -> Secure Shell there is an option for Authentication -> public key In the Private key submenu, there are several options to find the private key. I don't see any outside authenticators such as  ssh-agent and/or pageant.  Can AccuTerm be configured to use one of these ? Windows now provides ssh-agent. Pageant has become a defacto standard for this.

We have a multi-valued field that is being exploded for a sort. The dictionary item calls a program to convert the value. When we were on D3, this worked correctly. When we moved to Jbase, the sort failed. It seems to only sort on the first multi-value of each record selected. The program call was originally in <8> of the dict item. Another developer moved it to <7> after the issue was discovered. That worked fine for a while as the order of the original format sorted very close to the sort of the updated format. However, additional changes have been made that now make it obviously incorrect. <8> is the proper location for this call. The subroutine being called does use a few ACCESS references. At first I thought it might be something there, but it does do the conversion correctly. So the outputted data is correct with its format, but the sort result is wrong. Stumped.------------------------------Chris RazzanoSenior PICK programmerHouston's Inc-----------------------

I noticed that when I executed two select statements in a basic program, the 2nd one does NOT utilize the results from the first one: CMD1='SELECT FILE WITH ATTR1 EQ "Y"'' EXECUTE CMD1 CMD2-'SORT FILE F1 F2 F3 F4' EXECUTE CMD2 But, if I combine them it works: MULTI.CMD=CMD1:@AM:CMD2 EXECUTE MULTI.CMD Problem: is there a way to keep the 2nd command from running if the CMD1 finds 0 records? ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------