Rocket® U2 | UniVerse & UniData®

Hello all,  I made a python script to read multivalue data in universe account and write in a file as CSV for example.  So, for decoding I use cp850.  Until that everithing working. When it's time to write I receive this error: error cp1252: UnicodeEncodeError: 'charmap' codec can't encode character '\\u2591' in position 88: character maps to «undefined» So decode is good with cp850, ok with that ?  Problem is encoding ?  Maybe I can force encoding in utf-8 but I don't know how to do that ? Do you have an universe idea ? :-)  Thank you !  Jean------------------------------deleuze jeanRocket Forum Shared Account------------------------------

Hello all, This is my initial post here. Hope you all are well! I'm searching for some insight. By trade I am more of an Admin, but in my current role I have some developer duties and have inherited some custom work that ranges from fairly simple to robust. Just searching for insight regarding UniQuery. I am actively working for some revisions for Colleague outbound feed; the Select & List criteria currently displays a single list of data. I’m interested in adding an additional column and maybe headers for both.   Currently, the users are only included in the list if they meet the Select criteria. The revisions would result in a full list of users regardless if the meeting the qualifying criteria, a flag being added would solidify yay or nay.  The vendor is requesting a Y or N flag included to be in the data, based on if they meet the selection criteria or not. If a flag doesn’t exist within the Colleague UI to be included in the data output, is it even possible

hello, I want to raise errors in my py scripts then these error catch by into @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK  What can be the best method ?  a/ to re-raise a error from a try sequence : these sample can catch 3 types of error : path not found, json not correct, mykey not found ...  def myfunc(path): result = '' try: f_path = open(path) config = json.load(f_path) a = config["mykey"] except: raise how can I have it at BASIC level into @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK   in this case, @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK are null. b/ to raise a error from script : def myfnc(a) if a < 2: raise ValueError(f"integer above 1 expected, got {a}") in this case, @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK are null. Thanks manu

Both items are strings. They're not equal. It seems Universe is doing some kind of conversion on them that makes them equal. If I convert the strings to integers it knows they're not equal. If I concatenate a letter on to either string it knows they're not equal.  My client was using smaller numbers in a field but a new specification requires and 18 digit number. They don't want to to through all there programs that compare these numbers and modify them with a alpha character or int conversion. Does anyone know what's going on and how to best fix it?

I have RHEL 8.8. It has OpenSSL 1.1.1k. My UniVerse version is 11.3.4. It is OpenSSL 1.1.1b. What is the correct procedure to upgrade UniVerse's OpenSSL to 1.1.1k.  I'm trying to install a Python Module and it throws an error trying to download a new version of OpenSSL. Jon

I'm embarrassed to even ask this. I've seen the answer a couple of times in the documentation but can't ever seem to find it if I'm looking for it. How do you disable the automatic paging where the program prompts the user to hit the return key to continue. I know I can use the NO.PAGE option when running the program but I want to disable it in the program itself. Most of these programs were written for native Pick and were never designed to handing automatic paging. That's why I want to disable it in the program and not in the menu that run's the program.

Is there a way in PROC to test the @TTY variable and exit if it is equal to phantom? Sorry, Prime Information guy here, not much PROC. Jon

Hello All, We have a huge bunch of UniVerse Basic Routine. Now we wish to move to the modern world..specifically ASP.NET.  How should we go about doing this ? While keeping the structure intact and reusing the UV Basic Routine ?------------------------------Koon MIng FongMrP & O Global Technologies SDN. BHD.KUALA LUMPUR MY------------------------------

Hi Team, I am seeking assistance in implementing an audit trail or specific logs to trace issues and check the history of the system or program, including details such as who accessed it, when, and other relevant information. Is there any way to implement this in universe ? I would appreciate it if you could assist with this. Thank you.------------------------------Gnanaseelan gnanapirakasamSSERocket Forum Shared Account------------------------------

I am trying to confirm how U2 handles this inherently: 1st run a program from my own MY.BP  ex: "RUN MY.BP TEST.PGM"  TEST.PGM calls a subroutine, ex: TEST.SUB(arg1),  that exists in both the account's BP (cataloged in VOC) and a special version in MY.BP.O will U2 first look at the VOC to execute the subroutine and then, if not found, look in MY.BP (where the original pgm was run from) will U2 1st try to run the MY.BP version, and if not found, run the one cataloged in the VOC or, must I name my version to be unique, ex: call TEST.BP.NELSON(arg1), to have it run my version We often have a group of programs and subroutines that handle a process, and we are making changes to some of the subroutines, but not all.  Understanding the U2 rules of engagement would really help. Nelson ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

We're experiencing frequent "No More LCTs" errors in Unidata, forcing restarts to resolve the issue. However, the LCT statistics indicate a normal total LCT count which is below 50%. Can anyone suggest what are the other possible ways to diagnose this issue? is there any way to temporally fix the issue when "No More LCTs" occurs without restarting the UniData. Any help would be appreciated?  Unidata Version - 52

We're experiencing frequent "No More LCTs" errors in Unidata, forcing restarts to resolve the issue. However, the Total LCT statistics indicate a normal total LCT count below 30% normally. Can anyone suggest what are the other ways to diagnose this issue to fix permanently?  is there any other way to fix "No More LCTs" without restarting the UniData?

I want to iterate through and array passed to a subroutine but I need to know how many elements are in the array.

The Rocket MV team is pleased to announce the release of UniData 8.3.1, U2 Common Clients 5.4.1, and MV BASIC for Visual Studio Code (VS Code) 2.4.0 on February 26th, 2024. Rocket® UniData 8.3.1 UniData 8.3.1 HA/DR enhancements and bug fixes help you manage your replication environment more effectively. We've added a new script so you can stop and restart the repmanager, eliminating the requirement to restart UniData if the repmanager becomes unresponsive. We've enhanced the "invalid log sequence" message to include the actual and expected LSN number, which will assist you when debugging. We've added a skip option to the ud_repadmin command to facilitate recovery from stalled subscriber groups. UniData 8.3.1 security upgrades and enhancements help keep your applications and business safe and compliant. By upgrading to OpenSSL v3.0, UniData supports a wide array of protocol levels. OpenSSL 3.0 includes a major architectural change from OpenSSL 1.1 and brings with it enhanced security

Hi there,I've been looking for a long time, how to execute the 'DOS' command in a trigger in Universe.I have seen in some forum, that they indicated to add an 'H' in attribute 4, in the VOC DOS of the UV account.I have tried this and it does not work, since when firing the trigger and executing the DOS command in the subroutine, I get this message: Program "ED": pc = 744C, Verb "DOS" illegal when a transaction is active.Program "ED": pc = 744C, Error performing trigger for "XXXXXXXX".Failed to file "20451390" in file "XXXXXXXX". STATUS = 2Has anyone had the same problem of being able to run Verb on triggers? Thanks and best regards------------------------------Miguel Esteban Rodriguez GonzalezDataDealer Software España------------------------------

The process is simple - create a report on the UV side, upload and open the file in Windows after the upload is complete.  I've gotten as far as windows detects a new file, but how can I trigger an app to start and open the new file? ------------------------------Scott JohnstonSr Architect &n DeveloperSonna SolutionsDover DE US------------------------------

Hi, This is Keerthana. I'm Senior Software Engineer in TP project at Mitra Innovations. Currently, we are attempting to establish a connection between U2 Python and native Python. Our concern is that what we have done first is used UOPY module to access the subroutine and data file in BP source in XDEMO account using session. But U2 python does not require a session because the u2py module is included in the XDEMO account. But if we want to connect U2 python and native python there must be a configuration or session right? Can we connect this without using a session? Or are there other ways? We checked the .pyconfig file in the UV and tried changing the path to PYHOME and PYLIB there. But we are unable to connect. So Now we are thinking for the connection purpose we can use the any middle ware, Like MVIS. I'm not sure our thought is correct or not. So please anyone have any idea let me know or do you have any refrence please share with me ------------------------ Thank youKeerthana.RSe

This is a two part question to solve one problem. The first part; does a called subroutine use a new block of memory and address pointer? If so, doe this newly created memory clock have to wait for a time slice before it is processed? Also if the same sub is called multiple times, will use the already created block of memory?Part two; is it possible that calling a subroutine can break a phantom to the point of failure?We suspect our over night phantom process is dying because a tracing file we update with a small sub is killing the phantom.I personally do not, nor have I ever, actually known a phantom to die, because of repeated sub calls. However, we have to investigate the possibility.Thanks,SJJ  

I have been away from the U2 community for 15 years. Just downloaded the UV 11.4 trial Windows (2-user). How is it that I create another user to test remote login from the network?  I looked at XAdmin but didn't see anything about users/logins there.------------------------------Chad LarsonPrincipal DeveloperSelf RegisteredLehi UT US------------------------------

does rocket (or anyone else) have a preference of using resize vs memresize and if you do can you elaborate? thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Hi, I have a very simple program to upload a file from the PC to Linux host.  I'm trying to use FTS and the seems to go through the process of uploading but the routine never exits it just hangs once it gets to 100% transfered. Here is my routine.0001:       REMOTE.PATH = "C:USBANK"0002:       REMOTE.FILE = "USBANK.txt"0003:       MODE = 'R,A,T'0004:       RECORD='' ; STAT=''0005:       CALL FTS(MODE,REMOTE.PATH,REMOTE.FILE,RECORD,STAT)0006:       PRINT STAT0007:       PRINT RECORD0008:       STOP0009:    END I'm expecting the routine to finish uploading the print the value of STAT and RECORD.   But it never happens it just hangs. Any ideas?Sam

I use UniVerseSQL a lot. The absence of the equivalent of TSQL's Replace() function was a handicap so I wrote a wrapper function for BASIC EREPLACE() and added it to the Global Catalog. It works fine but the call is a little messy.EVAL 'SUBR("-REP.CHARS", attribute, "somestring", "anotherstring", 1, 1)' I'm curious if there is something I can put in the VOC to allow it to be called using just a VOC name and the arguments like the native UniverseSQL functions.------------------------------Greg ClitheroeRocket Forum Shared Account------------------------------

The Rocket® MV team is pleased to announce the release of U2 Toolkit for .NET 3.1.1 on August 24th,  2023.    The Rocket® U2 Toolkit for .NET Provider offers a free .NET data provider interface for Rocket UniVerse and Rocket UniData®, while U2 Toolkit for .NET Developer adds the ability to develop in Microsoft® Visual Studio.   U2 Toolkit for .NET 3.1.1 enhancements and improvements include:   ·       .NET 6 support streamlines code development for better performance ·       Entity Framework Core 6 support offers query enhancements, performance improvements, and a range of new features to minimize development time and costs ·       U2 .NET 6 and EF Core 6.0 drivers are now available on NuGet.org, allowing you to seamlessly update to the most recent U2 drivers ·       Visual Studio 2022 support for U2 Toolkit Data Provider only ·       TLSv1.3 protocol support for faster, performant, and more secure connections Install Rocket® U2Toolkit for .NET 3.1.1 today on Rocket Business Connect

This is a general question regarding using Test Driven Development in Universe Basic. Has anyone used this to develop their software and is there a testing framework that can be used? I have been asked to try it out and have only found information using object oriented programming languages. So far, I have created an ASSERT function and have started implementing test cases. Thanks in advance for any advice.------------------------------Maureen CollinsUniverse Database ProgrammerTeachers Mutual BankHomebush NSW AU------------------------------

I have been replicating for a while now with cloud systems to our in-house server using Universe and before that Unidata. However, one of our clients asked if you could have the publisher be a subscriber too? And could the subscriber be a publisher too? Posted at: 02-10-2024 10:12