Rocket MultiValue

Trying to resize a file but getting error message that file is in use, try again later.

Hi,I have Universe pgms that return a UniDynArray, but would like to convert the returns into a json format.I am not sure if this has been asked before but really looking for help on this last section of my code please?------------------------------Daniel ConradieRocket Forum Shared Account------------------------------

Now and then I must look at how long processes are running. Our web applications should be all running in under 500 milliseconds even though there are a lot of records in the database. An important datatable loading program on our web form was taking upwards of 2 seconds to load. I tested it on our development machine and with the client's data and the same number of indexes (7) and found our SELECT times were about the same. The PICKUP.DATE and ORIGIN.TERM are all indexed fields. Obviously, the SELECT optimizer does not work like I think it does. Here is the test code abbreviated that runs in 643 milliseconds TERMINAL.NO = "059" ; BEGIN.DATE = "06/24/2023" ; END.DATE = "06/30/2023" LINE = 'SELECT MOVE.LOADS' LINE := ' WITH PICKUP.DATE GE "':BEGIN.DATE:'"' LINE := ' AND WITH PICKUP.DATE LE "':END.DATE:'"' LINE := ' AND WITH ORIGIN.TERM = "':TERMINAL.NO:'"' EXECUTE LINE CAPTURING OUTPUT LOOP WHILE READNEXT ID READ LD.ITEM FROM

Hi,I have Universe pgms that return a UniDynArray, but would like to convert the returns into a json format.I am not sure if this has been asked before but really looking for help on this last section of my code please?------------------------------Daniel ConradieRocket Forum Shared Account------------------------------

Hi all - any advice here, please? (or please explain my "potential" misunderstanding :) I am experiencing difficulties in understanding why when attempting to use the D3 SQL ISQL commands. I have this version : On executing: which I checked in the code and the code looks for an implementation > 8. Furthermore, from the documentation I see that there is a NT_ISQL verb; which I also attempted  This one just drops to TCL - the code looks for (field function) a '~' separator which I give: And then things get "pear-shaped" 

Hi All, Most likely obvious, but I recently removed millions of records from some UNIDATA files, and I want to reclaim the disk space. In days of old, I would make a new version of the file that is empty, then copy the records into it -- then replace the old file with the new one. Is there a better way to do this now? I have a vauge memory of doing the copy from the ECL prompt, but I may have used Unibasic. I have a few files over 50GB that it would be nice to get the space back.  In reviewing the manuels, (HORRERS) it seems that REBUILD.FILE would basically do that. But I see no example of syntax. :FILE.STAT HISTORYFILE File name (Dynamic File)              = HISTORYFILENumber of groups in file (modulo)     = 36534Dynamic hashing, hash type            = 0Split/Merge type                      = KEYONLYBlock size                            = 16384File has 35382 groups in level one overflow.Number of records                     = 1824235Total number of bytes                 = 9851076322

Working on a routine to take HTML input and convert HTML entities like < and &gt to their character equivalent.  However, HTML entities are case insensitive, so the input string might be <, <, &lT; or ≪.  Is there a clean way to search for < in the string without case sensitivity so the value can be replaced with "<"?

I have this phantom program that runs for a bit and then just stops functioning.  The program continues to run, but doesn't do what it's supposed to do and does not respond to any control inputs other than a Linux kill.  Seems to be caught in some kind of a dead loop.  There are no READU locks preventing the program from running, it just ... doesn't do anything after it's been running for a while. Is there any way to connect the Unidata debugger to the phantom to evaluate variables or step through the program?

I'm a very small shop, only 9 employees.  I recently brought my D3 server back in house after a stint in the cloud.  I'm running D3 on AlmaLinux.  The hardware is an HP Z2 workstation with an i5-12500 6 core processor, 16GB Ram and 2 SSD's.  I do most of my tech support myself, but sometimes farm some work out to a local IT support company, Top Notch.  They're recommending I switch to / embrace virtualization and recommending Windows Server with Hyper-V.  I'm not a big fan of Windows and no next to nothing about virtualization, but I've seen posts about the benefits.  I'm just wondering if the Windows Server is the best solution for me. Any thoughts? TIA, Bruce

hello, I try to call a method which is into a module which is into a package.  on py I do : from package.subpackage import {*|module}  Is there a syntax to do it with PyCallFunction('package.subpackage.module',mth,xx) or PyImport('package.subpacakge.module') ??  thanks for any help------------------------------Manu Fernandes------------------------------

I have installed BDT 4.5.0 on my Windows 10 laptop. I'm connecting to UV 11.3.4 on RHEL 8.8. I get errors trying to connect. So the question is: Do I have to give the unirpc process access to write to my VOC file? We just installed 11.3.4 on our server. What updates are needed? What sequential file failed to open (guessing it was a log file of some sort). If anyone can point me in the right direction, it would be appreciated.

hi, when I use PyCallMethod or PyCallFunction, the result is typed by python. uvPythons doc talk about PYOBJECT. so, how can we define if pyCall return a PYOBJECT or a string/number usable in basic ?  Actually, I perform a pyCallMethod(builtins,'str',myvariable)  Is there a better method ?  manythanks. ------------------------------Manu Fernandes------------------------------

Hi, We recently upgraded the RAM on the server running D3/Linux and would like to allocate a greater portion of it to the D3 VM. What is the proper way to recalculate the "core" value in the pick0 file? Vincent------------------------------Vincent ElliottITC CoordinatorBearings and Accessories LtdGeneral Post Office JM------------------------------

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.

Hey, wondering if anyone is successfully connecting to Uniobjects on a Linux server (a recent Redhat release), using AD authentication?  I'm working with a customer that does not want to use any local accounts at all to connect to Unidata (i.e. the accounts should not be in /etc/passwd or added locally with useradd, they must be AD accounts).  I'm not sure if uniobjects uses PAM and can do that kind of auth. If you are using AD auth with Uniobjects, is the account you're using allowed to login to the server via ssh?  That's the second requirement - they don't want someone with a service account password using it to login.  I know on windows, Uniobjects requires the account to have the "log on locally" privilege. Grateful to hear of anyone's experiences with this (especially if it's a positive "yes it works!") or pointers to docs I may have missed :-)------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

Hello to all, I hope I find you all well.  Before I open a ticket or something ..... We have (a bunch) of U2 installs in AWS EC2 , and once in a while (that is a lot since there are a lot of servers) ,  U2 decides the lic. is no longer valid .... this happens no matter the linux flavor....  we have to re-enter lic detalis and re-activate .....  no instace type change is required to happen , to suffer this fate  any ideas or insights ?  regards, David. ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

I'm pleased to announce the release of MultiValue Integration Server (MVIS)  1.3.3.0. MVIS 1.3.3 is the third maintenance release in the last 18 months. Some of the key highlights in 1.3.3 are: Java 11 support - MVIS now supports Java 11 in addition to Java 8. Support for user defined topic prefixes on Azure service bus - This enhancement provides a way to support multiple mvis/admin pairs on a containerized installation of MVIS, reducing the cost of deployment on Azure (since it removes the requirement for one service bus per MVIS instance). Support for Alpine Linux 3.18 - We've upgraded MVIS containers to the latest version of Alpine Linux, v3.18. 1.3.3 includes 8 bug fixes (refer to the release notes for details) MVIS product lifecycle dates: 30 Jun 2023 GA 30 Jun 2026 EOM 30 Jun 2027 EOS 30 Jun 2028 EOLS ------------------------------Hernando BordaProduct Manager, MultiValue ToolsRocket Softwarehborda@rocketsoftware.com------------------------------

Updating the D3 patch list yet again! In order to help the D3 community stay informed about when patches become available, we will be using the Rocket Forum to announce the availability of new D3 patches and service packs, so make sure that you check back often, or better yet, make sure you receive email notifications from the Rocket Forum. And if you have any questions, please reply to THIS thread, NOT the previous ones! Here's a list of D3 platforms/versions and their current patch levels: D3 AIX 10.3.4D3 AIX 10.3.3: Monitor M8, Flash F3, ABS A14, Install I3D3 AIX 10.3.2: ABS A14D3 AIX 10.3.1: ABS A14D3 AIX 10.2.0: Monitor M1, ABS A82 D3 Linux 10.4.0 ("port" alpha has been removed)D3 Linux 10.3.4*Certified on RedHat, Rocky and Alma v9D3 Linux 10.3.3: Monitor M8, ABS A14, D3_setup_sub*Note that D3_setup_sub will allow D3 Linux 10.3.3 installation on Rocky and Alma Linux v8.xD3 Linux 10.3.2: ABS A14D3 Linux 10.3.1: Monitor M2, ABS A14D3 Linux 10.2.0: Monitor M18, Flash F9, SQL S3, ABS

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,

We are running OpenQM 4.0.8 on W2019 in Azure. We are running an Apache web server on a private separate server outside of Azure. we are having what we consider slow and variable response times. we have added a considerable amount of tracking but are unable to find the bottleneck. we are use PHP page to call a function that gets data from the QM server. we are using a http call from the PHP function we call:    (we have 20+ of these calls for different information), for instance: http://web.xyz.com:8280/api/getpurp?fnme="obj.maint" we know that the pageload (and function call) is taking 1.723 seconds. We have tracked the QM side at 8ms. we have looked at the flush time in QM   and tried WFLUSH to make sure that buffering the response is not part of our problem. we are trying to make sure that we don' t have virus checking software causing delay on the W2019 machine we are looking for best practice here. do people use a private tunnel between webserver and DB server ? do people put

I'm pleased to announce the release of MultiValue Integration Server (MVIS)  1.3.3.0. MVIS 1.3.3 is the third maintenance release in the last 18 months. Some of the key highlights in 1.3.3 are: Java 11 support - MVIS now supports Java 11 in addition to Java 8. Support for user defined topic prefixes on Azure service bus - This enhancement provides a way to support multiple mvis/admin pairs on a containerized installation of MVIS, reducing the cost of deployment on Azure (since it removes the requirement for one service bus per MVIS instance). Support for Alpine Linux 3.18 - We've upgraded MVIS containers to the latest version of Alpine Linux, v3.18. 1.3.3 includes 8 bug fixes (refer to the release notes for details) MVIS product lifecycle dates: 30 Jun 2023 GA 30 Jun 2026 EOM 30 Jun 2027 EOS 30 Jun 2028 EOLS ------------------------------Hernando BordaProduct Manager, MultiValue ToolsRocket Softwarehborda@rocketsoftware.com------------------------------

MultiValue Integration Server version 1.3.3 has been released on June 30 2023 for the below platforms/versions:AIX POWER       7.1,  7.2AlmaLinux       8Amazon Linux       2CentOS       7,  8Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Rocky Linux       8SuSE Linux Enterprise Server Intel       11.0,  12.0,  15.0Windows       Windows 10,  Windows 11,  2016,  2019,  2022This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please

One of my customers has declared end-of-life on their Windows 2012 server upon which we have run 11.3.1 for 10 years or so.?? The new server will be Windows 2022.?? 11.3.1 is not listed as certified for 2022 server.?? Can I have the IT department move our 11.3.1 system to the 2022 server and then install the 11.3.5 to which we are upgrading while we continue to operate on the old server??? Will programs have to be recompiled and recataloged on the new server or will the map still be valid??? Has an upgraded python been included with the UniVerse download and will it be added or replace the current python?Thanks,Dale

Is there a target date for MVIS 2.o release? Any early info on what improvements/changes/enhancements it might contain?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------