Rocket MultiValue

Greetings all! New to this forum.  I am having an issue with AccuTerm 7.  I have a recoverable file that I have been unable to delete.  Can anyone suggest a remedy? THX, ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

I have a few vb apps in place.  My latest one of works in vb 2022 but fails when when I install it in on another computer. Here is my code bit: Global:  Private MVSP As MVSP.PickPrivate MVSPFunc As New MVSP.Functions In form load:    Try       '  pool = New rocketsoftware.MVSP.PickPool()        MVSP = New MVSP.Pick       Display("Run Time Type" & MVSP.GetType().ToString)   Catch ex As Exception       Me.Show()       Display("MVSP Failed to init")       MsgBox("MVSP Init Error" & ex.Message)       BtQuit.PerformClick()   End Try The mvsp = new line is failing with error msg: Init Error int path is empty. I installed the d3client 103.4 on the computer, as well as c++ runtime. Nothing changes. I also installed .net 8 runtime  with the install. What strangeness is this?------------------------------David WilliamsDeveloperComputer Repair & Sales IncWarminster PA US------------------------------

I recently was part of a discussion regarding the use of parenthesis with a SELECT statement. My understanding was that parenthesis were not evaluated with respect to AND and OR logic. Is that correct? Looking in the online documentation, the only mention (that I could find) regarding parenthesis use was in relation to OPTIONS. Specifically the the open parenthesis indicated the beginning of an OPTIONS clause and that a close parenthesis could be used to end the clause and that the OPTIONS clause should always be at the end of the statement. If that is the only allowed use for parenthesis then: Why are parenthesis allowed to be used at all in a SELECT statement as follows:SELECT FILE WITH 1 EQ "ABC" AND ( WITH 2 EQ "123" OR WITH 3 EQ "XYZ" )This command executes without an error? Using a file with the following records: TEST..... A1....... A2... 100        A         1200        A         2300    

I am trying to create a new distributed file. I am on a Linux Red Hat version 7 running universe 11.3.5 I tried running this command DEFINE.DF DATA CSA.TRIPPER.CENSUS ADDING CTC1 1 CTC2 2 CTC3 3 CTC4 4 CTC5 5 INTERNAL PARTNOUnable to open DICT "". CSA.TRIPPER.CENSUS is a type 18 file that has existing data. I created the CTC1 - 5 files all type 18 the PARTNO is in the DICT of CSA.TRIPPER.CENSUS 0001: I0002: MOD(SEQ(@ID[LEN(@ID),1]),5)+10003:0004: Partno0005: 6R0006: S When I list CSA.TRIPPER.CENSUS PARTNO the part number is listing 1 through 5    1276225      4   1730044      3   2032590      4   2183863      2   2637682      1   2940228      2   3091501      5   3394047      1 What am I doing wrong? Jon Card Combined Transport

Is there a way to allow the database access to more RAM? Our Universe/Windows instance only consumes about 24GB of the 128GB it has installed. THX! ~Doc ------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Has anyone tried querying Unidata on Linux using either PowerShell or Python? If yes, any suggestions or tips that you can share?------------------------------Gregory HernandezSenior Systems ProgrammerDesales University------------------------------

Wise ones, Is there a way to prevent UDOWrite converting large numbers into scientific format? For example: PROGRAM temp $INCLUDE UNIVERSE.INCLUDE UDO.H Value = 1234567890.123Ok = UDOCreate(UDO_OBJECT,hObject)Ok = UDOSetProperty(hObject,'large', Value)Ok = UDOWrite(hObject, UDOFORMAT_JSON, JSON)Crt JSON STOP {        "large":        1.234568e+09} I can't make it a string as that will fail the JSON schema validation. Integral numbers are not affected by this so I could INT() it, but that's not really a solution. Thanks

Ever get on a D3 system and run WHERE LZ looking for stuff but get barraged by PIBs in some normal status? I got tired of that and wrote a BP that goes through WHERE LZ output and strips out the trivial stuff. Posting it here for anyone's use, but also to get opinions on improvements. Don't be shy!!* whereLZ - bsc -09/05/2024** ver 1.1 - bsc - 06/05/2025 - detect if hot backup secondary*tclread wCmdslpTim = field(wCmd," ",2)'cn' ;* set sleep secondsif slpTim else slpTim = 2      ;* default is 2passes = field(wCmd," ",3)'cn' ;* set number of passesif passes else passes = 3      ;* default is 3isSecondary = 1 ;* call checkFHBRole(isSecondary)for passNo = 1 to passes  crt "Pass ":passNo  execute \\where lz\\ capturing whereTxt  aMax = dcount(whereTxt,@am)  for aX = 4 to aMax    line = whereTxt<aX>    if index(line,"inconsis",1) then      crt line ;* corrupt FCB/DCB/whateverCB    end else      wPib = line[2,4]      if wPib matches "4n" then        wMode = field(line[33,99],":",1)   

I have an Access database that currently connects to the SQLDEMO tables. That's great. When I look at the server running D3, I see the SQLDEMO folder in the D3Databases folder. Fine So now I want to connect to some live data. Specifically the inventory tables. I have lots of documentation, but I can't seem to find the steps to make the tables visible to my odbc dsn. The folder I think I am after is the MISPR folder. If I'm correct, how do I get access to the values in the tables? I was told I need to define a translation table..yes/no Regards ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

Howdy, again, folks! We experienced an outage yesterday associated with tl_server.exe. We must be running some knock off version.  The system says we are running 11.3.1.6032, but Rocket only shows the last release as .6023  which was released in Feb. 2019.   Since that date, there has been a 11.3.2, 11.3.3, 11.3.4, 11.3.5, 11.4.1, 12.1.1, 12.2.1, and now 14.1.1 We would like to update but are looking at the following constraints: Constraints: Version 11 ended support on 9/1/2024 and fully expires 9/1/26 and will no longer be supported at all... Version 12 did not work... we are searching for documentation that would provide details Version 13 was not released. Version 14 is released and we are looking into upgrade process. Are there any contributors who might share their upgrade experience?  Anyone on version 14 and how it's performing? THX in advance for your always helpful responses! ~Doc ------------------------------Doc RuckelPart time programmerRocket Forum Shared Account--

Is there a limitation on the number of UV  phantom processes that can run simultaneously on a Windows platform?  I seem to recall there is but I can't find any documentation for it. Thanks in advance.------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

Hi all I'm creating a lot of tools using Python and version control is getting quite out of... control. So I'm starting to create a folder infrastructure inside PYPROGS to manage the different tools and keep their basecodes separated. My problem/question is:How can I manage the subfolders in PYPROGS? For example, I have some files organised like this: -U2DBLiveDMS |-u2dblive.py |-u2dblive_common.py -aws_boto3_context_manager.py -aws_file_delete.py -excel_utils.py I can check my files using uopy: with uopy.connect(**config): cmd = uopy.Command("SELECT PYPROGS") cmd.run() select_list = uopy.List() self.__lista_ficheros = select_list.read_list() rgx_cksum = re.compile(r'[Cc]ksum\\s+=\\s+([0-9]+)\\s+') for f in self.__lista_ficheros: if f.endswith('.py'): chk = uopy.Command(f'CHECK.SUM PYPROGS {f}') chk.

There was a wIntegrate update planned for early 2024, but it appears that didn't happen.  I see now a "committed" update, v 6.3.5, for August 2025. Where can I find information on what's included in the update? Oops, sorry, I meant there is a committed update version 6.4.5, that is scheduled for August 2025.  

Hi guys, I have an issue on a customer site that is a Windows 2019 server running Unidata 8.2.1, the workstation is running Windows 11. This is an SB+ site so the users use SBClient (5.5.4). One PC that has been running fine for some time suddenly has a problem were the SBClient is launched, they click Start a Session, it connects to the server, connects to SB+, they enter their SB+ credentials and SBClient  then seems to go into "minimized mode" and will not open. I have tried removing any scripts, deleting and re-creating the profile, re-installing SBClient and even tried installing version 6.5.6 but this problem persists. the user assures me that nothing has changed on that PC. Other users are working fine. This user (with his credentials) works fine on a different PC. Has anyone seen this behaviour before or has any idea what the issue may be? Many thanks Barry------------------------------Barry GreenDirectorCAPITOL BUSINESS SERVICESMawson Lakes SA AU------------------------------

I have a few vb apps in place.  My latest one of works in vb 2022 but fails when when I install it in on another computer. Here is my code bit: Global:  Private MVSP As MVSP.PickPrivate MVSPFunc As New MVSP.Functions In form load:    Try       '  pool = New rocketsoftware.MVSP.PickPool()        MVSP = New MVSP.Pick       Display("Run Time Type" & MVSP.GetType().ToString)   Catch ex As Exception       Me.Show()       Display("MVSP Failed to init")       MsgBox("MVSP Init Error" & ex.Message)       BtQuit.PerformClick()   End Try The mvsp = new line is failing with error msg: Init Error int path is empty. I installed the d3client 103.4 on the computer, as well as c++ runtime. Nothing changes. I also installed .net 8 runtime  with the install. What strangeness is this?------------------------------David WilliamsDeveloperComputer Repair & Sales IncWarminster PA US------------------------------

We have Universe developer opportunity at Advantive. If interested please click the link below. https://www.advantive.com/about/careers/ ------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

I'm interested if anyone uses NFS to store account data remotely, with something like Netapp Files:https://learn.microsoft.com/en-gb/azure/azure-netapp-files/network-attached-storage-protocols.In my own research of documentation I can see the following:[The ALLOWNFS] parameter should only be turned on in the following cases:- When UniVerse is not running or not installed on the remote system. File integrity is compromised when locks are not maintained on the remote system.- When the system administrator does not allow other UniVerse installations to gain access to the same remote UniVerse files at the same time.So this would seem to indicate we are OK. I think I need to clarify: does local Universe locking still apply when ALLOWNFS is in use (and does this depend on the locking provided by NFS - because capabilities/implementations differ from version to version).

Good morning folks! How are VOC items created?  Compile/Catalog?  Are there any other files in UniVerse where executable items exist? THX in advance for your always helpful replies! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

When I right click on a file name in the VSC explorer window I get the option "Compile selected BASIC programs". Selecting this (when connected to the U2 server) runs compile on the selected program(s) on the server. When I run this from F1 (or assign a keyboard shortcut to it) I get an error message even if focus is on the selected file name(s) in the explorer bar. [Cannot read properties of undefined (reading 'forEach')] Is anyone else getting this issue? ------------------------------Stuart BoydellAU------------------------------

The Universe UDO... functions handle UDOFORMAT_XML and UDOFORMAT_JSON just fine. Is any effort in progress to extend them to UDOFORMAT_YAML?

Hi all We have an environment with several users running concurrently. This works fine, but I'm having trouble when several users try to run Python code concurrently. This is my UP NOMBRE.SCRIPT='excel_utils' NOMBRE.FUNCION='leer_excel' PATH.REPOSITORIO='/u2/quiter/CONTA5/REPO.FILE/' FICHERO.EXCEL='Fichero Extracontables a integrar BR LEAPMOTOR.xlsx' RUTA.EXCEL=PATH.REPOSITORIO:FICHERO.EXCEL RUTA.CSV='/u2/quiter/CONTA5/REPO.FILE/' CONVERTIR.CSV='' USAR.CABECERA='1' RESPUESTA=PyCallFunction(NOMBRE.SCRIPT,NOMBRE.FUNCION,RUTA.EXCEL,RUTA.CSV,CONVERTIR.CSV,USAR.CABECERA) IF @PYEXCEPTIONMSG#'' THEN CRT 'ERROR: ':@PYEXCEPTIONMSG END CRT 'RESPUESTA: ':RESPUESTA RETURN If I call RUN UP from two terminals it works fine, once. When I try to run it again... >RUN UP TESTEXCEL RESPUESTA: OK|... >RUN UP TESTEXCEL Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program TESTEXCEL at address 32. Connection to narobial.intra

What's the most efficient/fastest way to securely get data in/out of a jBase system? The last time I had to do this, we wrote a CGI interface and accessed the system via HTTPS. This time, we have no need for the full CGI environment, we just need to parse some JSON data, and return a JSON response.  Similarly, MVIS is overkill. Is there a "jClient", like there is with qm? We could just listen to a port, but the inbound connections will be coming from multiple clients, so we really don't want to run multiple transactions through the same process. We like the statelessness of separate connections.  Since jBase apps compile to OS executables, the current thought is to establish an ssh connection, with keys, run the appropriate routine, return the JSON and then exit.  We're wondering if there's something simpler.  ------------------------------Raymond DeGennaroOwnerSelf RegisteredBelvidere IL US------------------------------

I guess I'm a better programmer than Admin. I have successfully(?) installed UniData on an AWS Server. But I'll be damned if I can start the DB. The install Manual states:You can now start UniData by selecting All Programs > Rocket U2 > UniData RDBMS 8.3.2.I assume that references:C:\\ProgramData\\Microsoft\\Windows\\Start Menu\\Programs\\Rocket U2\\UniData RDBMS 8.3\\UDT or (directly):C:\\U2\\ud83\\bin\\udt.exeUnfortunately, the result is:Error msgno = 427. args = VOCerrno=2: No such file or directoryCan anyone point me in the right direction?Thanks in advance-Rich------------------------------Richard LucibellaDirectorRocket Forum Shared Account------------------------------

I would like to capture the dbpause is on message from a RESTful call.  Currently I'm getting an error 500 can't connect.  If I turn on the server_debug the server debug message does say dbpause is on.  So, I'm wondering if I can get the notification through my RESTful call.------------------------------David GreenComputer ProgrammerRocket Forum Shared Account------------------------------

I have been looking for ways to encrypt data sent from a publisher to a subscriber. That data is sent to unirpcd on the subscriber and I have confirmed that, at present, it is sent as plain text. We have a lead interested in replication but want to ensure that the data transferred between the publisher and subscriber is encrypted (they're Unidata on AIX). I noted the existence of the "-s" option for unirpcd, but when I force unirpcd to start on pub and sub with this option, replication does not operate. I've been told that there is no "official" way to encrypt the replication data travelling between pub and sub(s), but that using a ssh tunnel may be an option. I'm pretty decent at setting up tunnels - I do it all the time, but I have yet to work out how to get replication to go through a tunnel. Any suggestions? Or does anyone have any other suggestions about getting the data from the publisher to the subscriber to be encrypted (preferably without having to do file encryption for ever