Rocket MultiValue

hi u2python's guru, I run a problem to adress 4 different python on the same machine.  1/ from bash /usr/bin/python (2.6.6)  sys.prefix='/usr' sys.path=['', '/usr/lib/python2.6/site-packages/'........., '/usr/lib64/python2.6', '.....] 2/ from bash /usr/local/bin/python3 (3.6.4) sys.prefix = '/usr/local' sys.path=['', '/usr/local/lib/python36.zip', '/usr/local/lib/python3.6', '/usr/local/lib/python3.6/lib-dynload', '/usr/local/lib/python3.6/site-packages'] 3/ from bash /data/uvdb/uv/python/bin/python3 (3.4.5) sys.prefix='/usr' sys.path = ['', '/usr/lib64/python34.zip', '/usr/lib64/python3.4', '/usr/lib64/python3.4/plat-linux', '/usr/lib64/python3.4/lib-dynload', '/usr/lib64/python3.4/site-packages', '/usr/lib/python3.4/site-packages'] 4/ from uvshell /data/uvdb/uv/bin/uv > python  sys.version='3.4.1 (default, Feb 18 2015, 13:36:51) [GCC 4.4.7 20120313 (Red Hat 4.4.7-3)]' sys.prefix='/data/uvdb/uv/python' sys.path=['/data/uvdb/uv/python/lib/python34.zip', '/

Hi. I've found these forums extremely helpful, especially Pete's posts who's an absolute gem! Today, I need help on a topic which I tried to look up for so many days but didn't find. We've a requirement where we need to do away with PuTTY which we currently use to launch some Linux utilities. Since our tech stack is PICK/UniVerse, what better alternative would be than to leverage AccuTerm 7/8. However, the challenge with this approach we're facing is after we launch the utility, the control is handed over to the program in question (which is nothing but a CLI launched with EXECUTE 'sh -c "./Dashboard"'), and at this point if a user prematurely Closes (or Exits) AccuTerm, it keeps running on the Linux host machine which somehow isn't the case with PuTTY. Thank you.

Hi everyone,How can I use d3py in my Python applications outside of my "d3 box"?I mean, I have created a Python application in my d3 server, and it runs fine using the import d3py, but I want to use it in my Web Server to create my Web App or API endpoint, I have errors to importing d3py outside from my d3server, it says not found the module d3py.How can I implement a Python application with d3py outside of my (D3/Win) Pick server box? It doesn't work moving manually the files or making a map drive.Thank you,

Hello , I have been installing and checking MVVS for a few days now and I have a questions , problems :   - GO TO DEFINITION function - always returns "No definition found for '' " - GO TO REFERENCES function - always returns "No references found for '' ".   do i need to set something?? Displayed functions:

in my phantom log  I saw the msg  cp: failed to close (specific file name), I looked at the file checked permissions and  everything looked good. In the program it processed all of the previous files with no errors. the last for file showed these errors. the programs are running on 15 different server and none of the other servers have this issue. comments? help? Thanks, Theo

I'm trying to work out the correct syntax for the "select" option to "limit the returned results" when testing in Swagger using a UniVerse database as the data source. For example, I have a date field and want to select all the dates in a specific year. Is there some documentation that details how this works? I've tried standard UniVerse syntax, standard SQL syntax, but neither of these seem to do what I want to do.

My application seems to be blocking the ssh connection from Visual Studio Code to my Linux server. With other Rocket products the user is identified as terminal, phantom, uvnet, etc. Is there a special type for the login from MVVS?

I have a Python script that uploads a program and tries to compile it. But every time it compile my program errors because we use Pick.  Can we set up some options so the command executes using Pick flavor?  I already tried setting the TCLTYPE before running the command, but it doesn't work. Connection establisheddone readingfile uploaded Compiling Unibasic: TESTPROGRAM in mode 'u'.main program: syntax error at or before<line 2578>       READSELECT NH ELSE HN.RECS = ""            -----------------------^Expecting: =,:,+,-,*,/,[,< Any suggestions?  Thanks in advance

Somewhere along the line, we have lost the setting in SB client where if you highlight and copy some text on the screen, then paste it into something (like NotePad++ or an email), it loses the CR/LFs.  This means, instead of retaining the format from the screen, the pasted result is one big string on a single line. Where is the setting to tell SB client to keep the CR (CR/LF) when you copy data from the screen? Thanks JRI

Hello everyone,Firstly, I have to say that this is my first experience of attempting to use UOPY so please forgive any obvious mistakes on my part.   The issue which I am looking for some guidance on is as follows:I can log into Universe via an ssh terminal, issue command such as:SELECT CDC.CARD WITH ID = "1234567890123456" TO 1LIST CDC.CARD CARDNUM FROM 1This selects one record into list number one and outputs the ID and CARDNUM values.   CARDNUM Is a calculated field and is decrypted / displayed correctly when the operations are performed as above.However, when using UOPY, I replicate the above using something similar to the below:cmd=uopy.Command(f'LIST {filename} CARDNUM FROM {list_number}',ses) cmd.run()Inspecting the cmd object shows that there's an error in decrypting the value, with the full error message as follows:error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:crypto/evp/evp_enc.c:570I understand that the Command objects should be

Hi,I need to increase space on a customer's D3 Linux 10.2.0. Current disk statement in Pick0:rawdisk offdisk /dev/mapper/rhel-pick 0 209612800 # disk 0They have added a new partition to the VM - so 2 questions.First is it as simple as running the D3setup utility,  adding the partition, and then restarting D3?Secondly, could we have just increased the current partition?Excuse my ignorance around VMs & virtual disks - used to set up small servers with sda1-4 etc - a bit rusty now!Here's the lsblk lsblk NAME                  MAJ:MIN RM  SIZE RO TYPE MOUNTPOINTfd0                     2:0    1    4K  0 disk sda                     8:0    0  500G  0 disk ├─sda1                  8:1    0    1G  0 part /b

Our program uses a pre-compile routine which modifies the code before running the BASIC command to create the object code. Since Rocket MVVS appears to call the BASIC command when compiling, I'm wondering if there might be a way to call our pre-compile routine instead of BASIC.We're in the process of adopting Git and this would help us take full advantage of Rocket MVVS.Thanks in advance for any ideas.

[Rocket U2][U2ODBC][2300701]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: S1000; U2 Database code: 20085; Msg: [U2][SQL Client][UNIVERSE]Program ".ITYPE.": pc = 6, "*PAID.AR.CALC012" is not in the CATALOG space. .".Back in November, I was able to get connected to this U2 database from SQL Server, PowerBI, and other tools using OLEDB and ODBC as outlined in this previous thread:Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData I'm using the latest U2 64-+Bit ODBC Driver Version 7.241.02.9004.The ODBC Connection tests successfully and works perfectly in applications that use ODBC, such View this on Rocketsoftware > After a several month hiatus, I am now trying to work with the U2 database again, and getting this error related to the "CATALOG space" when accessing certain tables that I successfully accessed back in November.I am on the same PC, with the

I feel like I must be missing this but have been unable to find it in the documentation.   Is there a way to set the focus to a particular grid cell in code?   I have a grid with a selection box.  If the user selects a given row I would like to take them immediately to the text box in column X on that row for input.  Thanks.

Where could I find / how could I capture the output of a phantom started by a phantom?We have the code: EXECUTE 'PHANTOM ':TASKNAME CAPTURING EXECMSGE executed by a phantom program.Display statements in the first phantom are output as normal to its &PH& file.'EXECMSGE' contains "Phantom process started -nnnnn"The secondary process does its job, but any display statements are not written to any &PH& fileRunning the secondary process from TCL shows the display outputs at the terminalRunning the secondary process as a first phantom send displays  to &PH&.Running Universe 11.1.4 on Linux.. I'm not in a position to be able to change how it runs (but still need to support it)Thank you in advance for any help :)

I am trying to connect to an API and need some helpUsing RHEL 7 and Universe 11.3.4The curl example they provided works in RHEL. curl -X 'GET'   'https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips?vagusAPIKey=1A2B3C-1533-CMBD-8537-123456789'   -H 'accept: text/plain' This is my BASIC Code      URL = "https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips"      KEY = '1A2B3C-1533-CMBD-8537-123456789'      X = addAuthenticationRule(X.CONTEXT,2, "VerificationStrength", "generous")      X.DEPTH = 2      X.SERVER.OR.CLIENT = 2             ; * CLIENT      X.RTN.CODE = setAuthenticationDepth(X.CONTEXT, X.DEPTH, X.SERVER.OR.CLIENT)      X.RTN.CODE = addAuthenticationRule(X.CONTEXT, 2, "ServerName", "stagingapi.vagustracker.com")      HTTP.METHOD="GET"      X.RTN.CODE = createSecureRequest(U

Hello,Has anyone used any of the available migration tools to migrate away from CentOS v7 to either RockyLinux or AlmaLinux?I just came across the AlmaLinux Elevate Project and am wondering if it is worthwhile to try it.As a secondary question, which of the two distributions is preferred?Vincent

Good day, I am trying to connect to a Universe database using ODBC and have set up my DSN. However when testing the ODBC DSN or opening an ODBC connection to that DSN from C# results in the following error message. System.Data.Odbc.OdbcException: 'ERROR [00000] [Rocket U2][U2ODBC][0302086]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLExecDirect(); State: S1000; U2 Database code: 950088; Msg: [U2][SQL Client][UNIVERSE]UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "?". Scanned command was CALL "*HS.SCHEMA" ( ? .ERROR [00000] [Rocket U2][U2ODBC][0302086]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLExecDirect(); State: S1000; U2 Database code: 950088; Msg: [U2][SQL Client][UNIVERSE]UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "?". Scanned command was CALL "*HS.SCHEMA" ( ? .[Rocket U2][U2ODBC][0400182]Connection not open.' I unfortunately am stuck and cannot find any inf

Morning allIs there a mechanism which allows me to list the full account name, file name, and item within locks? The issue I am having with LIST-LOCKS is the masking to 19 characters for the account and file names. In most of my cases, 19 characters is not long enough to display the full detail. I need to be able to programmactically read the line in order to programmatically run "UNLOCK-ITEM ACCOUNTNAME,FILENAME, ITEM".Additionally, we run Windows and Linux D3, with .NET front-ends, so I need to be able to use one .NET codebase to unlock items on Windows and D3 Linux. It appears that each environment's display is different.In Windows, the filename is truncated due to the length of the account name, and in Linux, it does not display the account name.Windows:FSI Filename        PIB#  Lvl  Type  Item-id             TokenFMCG.DNFDATA,mpcont   12    0  VME   008845           &

Just tried accuterm on a windows 11 machine and  it was working fine until an Accuterm GUI program is launched, then it opens the GUI form and freezes. Anyone run into this andor have a solution?

We have a strange situation. One of our applications written in vb.net has it's data etc hosted in Azure.  When running the application from the office over a site to site vpn to the Azure endpoint everything works perfectly well eg a typical report runs in about 5 seconds.  However, when the users connect over the Azure software vpn on their home machines (all users regardless of local internet performance) the whole application slows down dramatically eg 90 seconds plus for the same report.  The IT Infrastructure team have exhausted their investigations and can find not reason why. Running commands at TCL using a Telnet application all seems OK but when running the app (uses port 31438 for RPC) is when the speed issue is experienced. Has anyone seen this or have any suggestions on where we might need to look?

we mainly use mvis with a subroutine, see definition below.  currently, if the input JSON has the wrong input data element we return a JSON array with error string. however, when use this the HTTP return code is always 200. this means other systems have to look for error strings in response. is there a way to raise the HTTP error code to something else other than 200  to something like an error code of 400 to indicate an error occurred? 

I'm working on something to make deployments to new environments a little easier, and one thing that would be super helpful is the ability to create or update VOC items from a script of some kind (e.g. a PAragraph).  I could of course do it from a basic program, but then the person doing the process would have to know how to save the program to the appropriate place, compile and catalog, and then run the program.  The idea is to give them a script and after saving it as a PA in the VOC, have them run it and it will take care of all the heavy lifting after that.  Most things I can do (creating directories, compiling programs, etc) but can't find a command that will allow you to update a file directly from TCL.  Anyone got any suggestions on a command?  I've got to be missing something obvious that will do this. PA UPDATE VOC INVOICE.EXTRACTS SET INV.PATH='/path/to/invoices' UPDATE VOC INVOICE.EXTRACTS SET INV.PATH2='/path/to/invoices2' UPDATE VOC INVOICE.EXTRACT

Hi, I have the following problem: I have been using the Rocket U2 product (Universe|Unidata) as ODBC configured on a SQL Server 2014 Via Linked Server Tecnology and everything It works correctly, I connect the U2 against my Universe database and this with the ODBC of Universe for Windows Server, finally I use the ODBC to create the Linked Server in SQL SERVER 2014. The problems began when upgrading SQL Server to SQL Server 2019, from that moment with the same configuration the linked server has stopped working. Have you reported any ODBC bug of Universe in SQL Server 2019? Does anyone have a similar scenario? I have tried several configurations both in U2 (via Uci Editor) and in the SQL Server and nothing has worked (The linked Server is infinitely loading and dont retrieve data from U2 database).            

Hi everybody, I'm searching a method to perform communication between 2 running phantoms.  sample : phantomA is a helper which load a lot of info in memory and is capable of complex computing. phantomB manage info and need a computing to be done by phantomA  the method QueueViaDisk :  pantomA read disk on a loop and write the result on disk phantomB write the request on disk, wait, and retrieve the result from disk  a method QueueVia Memory ? QueueVia Socket ? QueueVIA ..... ??  is it possible ? with uv ? with python ? via os ?  Any idea will be welcome. manu