Rocket® U2 | UniVerse & UniData®

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 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', '/

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

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

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

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,

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

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

All, I use chatGPT+. I asked it to write a multivalue basic program to calculate a loan payment. This is the result. 0001: PROGRAM LoanPayment0002: PRINT "Enter the loan amount: ";0003: INPUT LoanAmount0004: PRINT "Enter the annual interest rate (as a percentage): ";0005: INPUT AnnualInterestRate0006: PRINT "Enter the loan term in years: ";0007: INPUT LoanTerm0008:0009: MonthlyInterestRate = (AnnualInterestRate / 100) / 120010: NumberOfPayments = LoanTerm * 120011:0012: IF MonthlyInterestRate = 0 THEN0013:    MonthlyPayment = LoanAmount / NumberOfPayments0014: ELSE0015:    MonthlyPayment = LoanAmount * MonthlyInterestRate * (1 + MonthlyInterestRate) ^ NumberOfPayments / ((1 + MonthlyInterestRate) ^ NumberOfPayments - 1)0016: END0017:0018: PRINT "Monthly payment: ", MonthlyPayment 'R2'0019: END It took a bit of cajoling but within three corrections this was the end result. Does anyone have a BNF or ANTLR definition of the BASIC language? I'd like to feed it into chatGPT and see how it i

hello,  when we define a function like  def funcname(a,b,c); return (a * b + c) Can we use keyword argument syntax when calling a method/function ?  like PyCallFunction("module","funcname",a=1,c=2,b=3)   or is it mandatory to use positional argument ? PyCallFunction("module","funcname",1, 3, 2) ?  many thanks------------------------------Manu Fernandes------------------------------

    Key Takeaways:Do not use dimensioned redimensionable-array elements for EXECUTE variable targets for CAPTURING, RTNLIST and SETTING and variable sources for PASSLIST.The areas of concern:1. Information style redimensionable arrays may change size in the executed program.2. Arrays of either flavor compute to a temporary in a PASSLIST that gets overwritten by constructing the command string in a concatenation. This UniVerse bug results in the command string passed to the command as the select list.  Environment:UniVerse 11.3.1.6022Fedora Linux UniVerse supports two kinds of array.  Pick sytle arrays have fixed dimensions at compile time. Each element of the array takes one VARTAB (variable table) slot. VARTAB uses an unsigned short for an index which limits the total number of slots in a compilation unit, program or subroutine, to 64K elements. (This limits an array to a maximum of 64K elements.) Information style arrays specify dimensions at run time and may change and consumes only

I get a lot of survey's everyday. I have received several from Rocket Software on what I would like to see as Enhancements to UniVerse in particular, but multivalue in general. I thought I would toss this our for discussion with the forum members. Any thoughts?Multivalue Enhancements Better overall performance Multithread using data reader/data writer Compile into IL that can be optimized on a given architecture (ECMA 335) Improve connection to alternate database types SQL No-SQL OS Independent OpenQM data type validation, better data cleansing Improve database mirroring Improve Transaction processing Improve Publisher/Subscriber performance Better use of improved system resources Configuration Expert System, Machine Learning Better development environment Visual Code with ability to work on remote servers and multiple accounts VC graphical compiling, cataloging and debugging Extensible Terminal emulator Lint type program to identify problems and poor programming practice

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

Last year, having switched back from Unidata to Universe, you all helped me with simple triggers - which on universe are made as file indexes. Now I am trying to apply that to a NEXT.ID but it's stored in a DICT, not uncommon for PICK. Trying to make an index on a dict, however, didn't work. >CREATE.INDEX DICT KHTEST TRIGGER   Only records of type A, D, I or S allowed! I know this trigger works as I had applied it to the data portion originally. Ideas, suggestions, thoughts? Thanks------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Hello to all !!!!  THere is always a first time ..... what the heck is this ???  RESIZE: FL_GRPRESIZ bit was set on group 0.  Not resizing file. Thanks to all in advance  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

There are two truths I live by - Never start a land war in Africa and PICK (English, retrieve) is HORRIBLE at creating reports! Having moved into a position at a company using Universe, they somehow didn't know that they need a report writer package and have been coding Excel reports through FTD. This is very time consuming and not particularly good at reports. In the past I have used Crystal reports, PHP, ODBC, etc.  Can I get you alls opinion what is the most straightforward, most robust report writer out of Universe (PICK)? Ideally one not overly expensive ;) Thanks! Kathleen------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

I've overcome most of the issues discussed earlier in the following two threads.  The background there may help in addressing this question.Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData Rocket U2][U2ODBC][2300701]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: S1000; U2 Database code: 20085; Msg: [U2] View this on Rocketsoftware > 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 > The current error is the subject error message, which I am receiving when I attempt to query certain "tables" from Microsoft SQL Server Management Studio where the Universe U2 system is configured as a linked server

I was exploring our use of the STATUS statement in a simple BASIC program that we use to show info on a file. There wre 3 date/time pairs: Last Access Last Modification Last Status Last access shows a date from years ago, so it "feels" more like a creation date.  Last Status and Last Modification show identical values. What are these supposedly tell me? Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

I'm in the very beginning stages of designing/developing a program that will create a file or files that can be opened/imported by Word to display multiple tables like these (screenshot from a word document): I can handle part that has to calculate these details. However, i'm not sure what my options are for generating a file that can be imported/read by Word. It appears that Word can handle XML documents, so I'm wondering if that would be worth researching. Our current process is very labor intensive and requires a lot of hands-on, so ideally, my program would generate the file(s), and Word could then open and display the info seen above with minimal manual massaging. Any ideas would be appreciated.------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

Hi , Please can someone assist with this. We have upgraded our Universe from 11.2 to 11.3 and testing the Universe spooler it seems not to work. When we enter  SP-ASSIGN HS "Queing disabled for requested printer" Also checked the usd usd : Queing disabled on requested printer  We checked all the print queue status and it all in "ready" status.  Did an echo test and it printed out successfully.  Thanks. ------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

I am working on an RPM that will install unidata, so as I start down this journey, are there any gotchas other who have gone down a similar path that anyone would care to share?there will be 2 types of installations .....1. on a system WITHOUT unidata installed2. an upgrade of system with unidataI am going to use the parameter file to automate the installation in both cases and when doing #2 I will stop unidata  before preforming the upgrademy main question is about the license file (while developing I will be usings the PE version of unidata so no license issue) but in both cases how do I handle the license?1. do they have to enter  it manually?2. is there a way to "move" the license from version 8.x.x to 8.2.4?also on #2 is there an easy way to tell if unidata is installed and running, I suppose I could look for the unidata daemon to see if its running, but if the system is stopped since I do not know what version of unidata is installed is there something I can look for to see if un

@Jonathan Smith helped me out most recently in this thread... Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData I've overcome most of the issues discussed earlier in the following two threads. The background there may help in addressing this question.Rocket U2 | UniVerse View this on Rocketsoftware > Is there a similar  parameter I can set to get around this in the UCI Configuration Editor?  I've tried "casting" the AVG_COST_PD column differently so that it would return, but to no avail.As usual, I can query this table fine in the U2ODBC Tester, but not in SQL Server Management Studio, PowerBI and other Microsoft Products.  Although Microsoft Query legacy connection can also return the full table to Excel, and I don't see any outlandish values in the AVG_COST_PD column there.The full error now is:The OLE DB provider "MSDASQL" for linked server "mylinkedservername" supplied invalid metadata for column "AV