Rocket MultiValue

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------------------------------

I have 1.3.1 installed in a test environment. Installation was a real pain since the documentation for the correct version of Java and Python were incorrect in the docs. Thank heaven for Rocket support! We wanted to use Azure for our OAUTH bearer token (like we do through Postman), but could never figure out how to do that in 1.3.1. With Rocket's assistance, we got things working using KeyCloak. I have found 1.3.2 release notes and user guide, but cannot see if anything changed to resolce the above problems. 1) does 1.3.2's zip bundle contain the Python and Java versions that are required? 2) can Azure be used for the Bearer token (OAUTH), and if so how? Would appreciate someone pointing me to some more complete docs that may cover these topics. Thanks in advance.------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

We are in testing a new server where we've installed jBASE 5.8.  We migrated everything from the old server running jBASE 5.7 and are concerned about indexes. Although we rebuilt all the indexes the LIST-INDEX command does not display the indexes on jBASE 5.8 Using the INVOICE file as an example, on jBASE 5.7, "LIST-INDEX INVOICE" displays the following: INDEX definitions for file INVOICE at 11:22:28  06 JUL 2023          PAGE    1 INDEX NAME LOCALE NAME SORT KEYS. LOOKUP.... INDEX DEFINITION................... @18        C           AR         D2/        BY-AR OCONV(19,\\D2/\\)@28        C           AR         D2/        BY-AR OCONV(32,\\D2/\\)@29        C           AR         D2/        BY-AR OCONV(33,\\D2/\\)@3         C           AL                    BY 2@50        C           AL                    BY 50A154       C           AL                    BY 154A19        C           AR                    BY-AR 19A210       C           AR                    BY-AR 210A32        C          

hi folks, I hope someone can help me.  First, I want to add pypi.org packages /modules and have it available to import on script.py executed from RUNPY or BASIC py function. How to do it fom within  Universe ?  Second, I want to distribute our own modules with my basic application. (It's a type19 file (directory) with .py files, each one is a 'module'.) how to deploy it into u2python ?  many thanks------------------------------Manu Fernandes------------------------------

We have a need to create a single URL RESTful service that will give a different response for GET and POST queries. For GET, the service just echoes the data passed, but for POST it must return data from the database in JSON format. I created an "endpoints.yaml" to create the GET, but have not found any way to create a single URL that answers both GET and POST and treats them differently. So we might have, for example, a call to the URL: http://testapi.mbs.net.au:7171/APP/subroutine/TESTSUB?responsecode This would be expected to simply return the string "responsecode" as specified in the URL. However, if data is POSTed to the same URL (minus the "?responsecode" part), then JSON containing database information would be returned. I've tried various things in endpoints.yaml but have had no success. Can the above be accomplished in MVIS and, if "yes", how would we go about doing it?------------------------------Martin ShieldsSenior Technical ConsultantMeier Business Systems PTY LTDCarnegie

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:

Hi, I am trying to build a JSON object using UDO functions. How do I format numeric values to display 2 decimal values, by default the output is either an integer or 6 decimals. Below is a snippet of test code and the output generated:          name = "capitalBalance"      value = 672.500      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            name = "amountAvailable"      value = "617.00"      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            name = "arrears"      value = 77617.00      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT       name = "advance"      value = 0.00      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT        name = "interestAccrued"      value = 0.27      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT       name = "installmentDue"      value = "15437.01"      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            GOSUB TEST_AND_DISPLAY_OBJ      RETURN BUILD_JSON_OBJECT:      ST = UDOSetProperty(OBJNAME, name,

we are working on D3 to QM conversion.  The client had a number of select statements that use wildcards. we already know, and are converting to "pattern matching" from QM. The square brackets all still work.  Is there any characters to use similar to D3      with part.nbr = "A^^3^^" The up carrot was a wild card character for a single character. I have been searching the online docs, but have not found it. (like most docs, if you know what you are searching for, it is easy)------------------------------Jesse TilliaRocket Forum Shared Account------------------------------

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

Another frustrating problem I need some help with.  Added a new laser printer, wired ethernet connection. jBase 5.8.5 on Windows 10 Multi-page program output now prints 60 lines on page 1 , 4 lines on page 2, 60 lines on page 3 and so on.  There is no way to set a default line/page on the printer.  I've tried using TERM to change the printer length to 56  and tried creating a formtype with the shortened length but neither worked.  How do I "override" or work around the misplaced formfeed?? Thanks, Marc------------------------------Marc ZitcerPresDavidson SupplyPaterson NJ US------------------------------

Hi All -  I just found on our system that exiting a program does not clear an active select list. Im unsure if this is universe specific as I did not have to clear select buffers in Unidata, but this has shown to be an issue here. There is a basic CLEARSELECT statement just as there is at TCL. Is that a standard for anyone running Universe? To use CLEARSELECT in your programs? Do you use it generically when entering or exiting a program?  And now that I've seen this - what other pieces should I be on the lookout for that are saved between programs by user? Obviously named commons and passed variables but...any like this savedlist that might not be obvious? Lastly, is there an alternative to changing the code? Like an option I could set at tcl or in code that clears the buffers when exiting a program? Thanks!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

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.

AccuTerm version 8.1.0.0 has been released on June 30 2023 for the below platforms/versions:Windows       Windows 10,  Windows 11,  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 contact rbc@rocketsoftware.com.