Rocket® U2 | UniVerse & UniData®

Is there a limit to the value length in a select statement?When I run:   SELECT OP.MANIFESTED.HIST WITH TRACK.NBR = "420015859261290986498138210077"I get multiple rows back with TRACK.NBR different from above. For example:420015859261290986498136795170420015859261290986498151260165420015859261290986498151221500Is there a limit to how many characters it’s comparing in the select value?Other explanations?I removed the indexes off a copy of the file and I still get the same result, so it’s not a bad index issue.

With the shift from simple LLMs to transformative Agentic AI, we know an AI Revolution is coming, bringing significant changes in the near future.But a new question must be asked: Is your MV application ready to join the AI Revolution?MV application modernization is the key to leveraging AI, but when you really try to modernize, you will most likely run into a critical architectural roadblock that stalls progress.Find out what the real MV application modernization challenge is and, more importantly, how to overcome it:Watch the full video here: Is Your MultiValue App Ready to Join the AI Revolution?We invite you to watch, comment, and share your thoughts on the MV modernization journey!

The Recoverable File System (UVRFS) re-introduced in UniVerse 14.2.1 is an optional add-on feature that can be purchased through RBC for Server and Enterprise Editions of UniVerse. How to Order UVRFS via RBC:UVRFS will automatically appear in the list of add-ons in Rocket Business Connect (RBC). The user count for UVRFS will match your UniVerse license user count. Simply check the box to add UVRFS to your license. RBC will automatically apply your contracted rate.For further details on UniVerse optional features please refer to the MV Handbook, available from the RBC documentation page.

helloReally grateful for any assistance, I have been stuck on this for about 1 week now.I have SBXA working with unidata 8.1 sb+ 6.5 on windows 2012R2I have replatformed application to Windows 2022 unidata 8.3 sb+ 6.6.3i have Unidata server and separate commincation server. if i run :C:\Users\<mylogin>\AppData\Local\Apps\2.0\Y2N21CTT.YLM\D6JBB313.34V\sbxa..tion_74d57911d24a77ad_0006.0006_359984abce80fb3f\SBXAWinFxWindow.exeas administrator, intial connection fails: Unable to connect to SB/XAFailed to connect to the application because connecting to the account 'F:\AVANTE9\FLODATA\LIVE\LIVE.DATA.533' on the Application Server with address 'localhost' using U2 User ID 'IUSER\XXX' from the Communications Server failed.Details:[Rocket U2][UCINET - UNIRPC][ErrorCode=81016] The connection was refused as the RPC daemon is not runningSocket Exception caught and WIN32 API Error Code:10061 and Error Message:No connection could be made because the target machine actively refused it 127.0.0.

The Rocket MV team is pleased to announce the release of Rocket ® UniVerse 14.2.1 on 5th November 2025.Rocket® UniVerse 14.2.1 builds on a proven foundation to deliver even greater resilience, flexibility, and modernization. With enhanced high availability and disaster recovery features, this release ensures your business stays online and agile—no matter what.Built for Resilience: Uptime You Can Count OnProtect your system with the Shared Structure Recovery Framework RFSThe enhanced Recoverable File System (RFS) in UniVerse 14.2.1 gives you full control; configure it your way to align with your unique environment. Toggle RFS on or off using the RFS_MODE uvconfig parameter. Please note: UVRFS is an optional add-on feature that can be purchased through RBC.Secure your most critical files with Protected File ConfigurationOnce RFS_MODE is enabled, use a dedicated configuration file to define which files to protect, giving you more control over data protection.When RFS is enabled and files

Hi community,Plateforme : windows server 2016, uv 14.1.1.1002, Over the past few days, we’ve been experiencing random errors on uv static files. The same error messages appear repeatedly — expected blink 0x0 or 0x10000.These errors can occur up to ten times a day and affect various files (e.g., VOC, XXPROCESS, XXPPP, etc.), the most strange is these files are mainly used for read.... To resolve them temporarily, we use fixtool -fix (at boot uv, else the files are locked). Does anybody have any idea what could be causing this?We’ve already checked our antivirus, but the problem persists.Any insights or suggestions would be greatly appreciated ;) With kind regards Manu

Follow the link below to the innovation forum. https://community.rocketsoftware.com/multivalue-innovation-library-home-11/expanding-on-universe-and-unidata-esearch-tool-to-use-python-based-regex-search-27332

Greetings all! Can someone please direct me to documentation to dictionaries in UniVerse and what each attribute is used for? Many THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Hi everyone,  Just a quick reminder: starting tomorrow, Rocket Forum will be temporarily locked as we roll out an exciting transformation. We can't wait to welcome you back to a refreshed, more intuitive, and inspiring community experience on October 23rd. Here's what to expect: The Forum will switch to read-only mode from October 15th to October 23rd. You'll still be able to browse existing content, but posting, commenting, and liking will be paused during this time. After the improvement work wraps up on October 23rd, you'll gain access to the new, improved Rocket Forum, featuring simpler navigation, exclusive insights, and even more recognition for your participation. Important: Upon your first log in after October 23rd, you'll be prompted to reset your password. For more information about the changes ahead, please visit this page. If you have any questions, feel free to reach us at community@rocketsoftware.com. Thank you for being a vital part of our community on Rocket Forum.

Hi All, Hopefully this is a quick one, that I did not want to trouble Rocket support with. I know that UV11.3.5 is certified for Windows Server 2019, we aim to get as many of our customers on Windows onto Server 2022. However, we may have some who want to stay on 2019. To your collective knowledge are there any issues in sticking with 2019 for UV11.3.5? Many thanks.

Hi, I can see online documentation refers to The EDA SQL Server driver supports SQL Server 2014 and greater. Is there a driver to support SQL Azure. Thanks------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

Hi Running uv 14.1.1 on Windows, we are waiting to receive the patch 1002 Hotfix. Meanwhile, how can we restart uvcleanupd.exe without restarting uv himself !  If I start it from a console, it works but not as a background process. Thanks for any sugg.  Manu

Do we have a version of U2 Toolkit for .NET Developer with U2.Data.Client that supports any .NET 6 or preferably .NET 8 applications? I'm struggling to find information on it.

We have an app that is using the U2.Data.Client (version 2.2.2) to call a subroutine and the app is using transactions for an orchestrated business flow. Part of this orchestration is calling a subroutine and I need to know if that subroutine is, or has a way to, operate within the transaction of the U2.Data.Client. If so, how would I get that to work?

Hey folks, Sorry for the continued PROC questions but the owner of our company loves them...groan! Question for y'all, is there anyway to create a unique list ID within PROC. like "SAVE-LIST LIST.NAME.PORT#" or ...? THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

HelloI am testing the new-ish 'DT' conversion code in UV 11.3.5 (on RHEL8) and am having no success getting it to do what seems like simple conversions. I put together the following test code to give it a go: -- * Testing the new DT conversion code sys.VAL     = system(99)now.VAL     = now()local.VAL   = datetimel()utc.VAL     = datetimez() crt "NLS status : ":oconv(system(100),"S;'On';'Off'")crt "system(99) : ":sys.VALcrt "now()      : ":now.VALcrt "local      : ":local.VALcrt "utc        : ":utc.VAL lst.TESTS = ''lst.TESTS<-1> = "O": @VM: sys.VAL: @VM: "DT"lst.TESTS<-1> = "O": @VM: sys.VAL: @VM: "dt"lst.TESTS<-1> = "O": @VM: now.VAL: @VM: "DT"lst.TESTS<-1> = "O": @VM: now.VAL: @VM: "dt"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "DT"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "dt"lst.TESTS<-1> = "I": @VM: utc.VAL: @VM: "DTIS"lst.TESTS<-1> = "I": @VM: utc.VAL: @VM: "dtis"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "DT"lst.TESTS<-1

For those wanting to learn MVIS, I have created two (free) step by step guides to creating an MVIS/REST backed website. The first of these uses Vue 3, which is arguably (well I will argue) the most friendly of the client side typescript style of web frameworks, and the second uses Microsoft's .NET Blazor so you can take your pick. The guides will work with the U2 Trial Editions and the software is free. Some knowledge of TypeScript or C# would be useful but you can probably follow on without it. I've posted these on the new Rocket Innovations section, or you can download them from the Free Training section of my website (www.brianleach.co.uk). Have fun and good luck!------------------------------Brian LeachDirectorBrian Leach ConsultingChipping Norton GB------------------------------

A couple of posts outlining how I go about importing and exporting things, I use /etc/passwd as the example as I needed a script to move some users over. I have a bash script to do this but moving more of my workflow into Pick is my goal.  Importing into Pick: https://krowemoh.com/devlog/importing-linux-files-into-pick-.html Exporting out of Pick: https://krowemoh.com/devlog/exporting-pick-records-to-linux.html ------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

Hello all - we are switching from one box (unix) to another (linux). We have some programs that check server IP, hostname, uname - to know if the user is addressing our test or production environments. Our question is does anyone know of a Unidata environment variable that holds this type of information we could query easily? Thanks for any ideas! Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Greetings all! Attempting to: Create a list in PROC Call a catalogued Basic program Using PROCREAD in that Basic program in a LOOP/REPEAT construct Expecting the PROCREAD would pop off list elements until exiting the LOOP/REPEAT construct. To date, I haven't been able to get any data passed.  Does anyone have the mojo to get this bugger working? THX in advance for y'alls always great advice! ~Doc

hi everybody, I search a solution to read the locks info when I'm in a transaction ! I need it to act correctly on LOCKED clause..  OPEN 'MD' TO F ELSE STOP TRANSACTION START THEN CRT 'TR OK' READU R FROM F,'EFV' ELSE R = '' EXECUTE 'LIST.READU' EXECUTE 'PHANTOM LIST.READU' EXECUTE 'SH /C smat -r' EXECUTE 'ANALYZE.SHM -r' TRANSACTION ABORT RELEASE F,'EFV' the runtime says :  12 RUN EFVPROGS TESTTRANS TR OK Verb "LIST.READU" illegal when a transaction is active. Verb "PHANTOM" illegal when a transaction is active. Verb "SH" illegal when a transaction is active. Verb "ANALYZE.SHM" illegal when a transaction is active. Is there a hidden SYSTEM(?) to retrieve the LIIT.READU / list_readu / smat -r output ?  (I can perform all READU before TRANSACTION START and if LOCKED perform what I need but I'm into a generic subr

The latest PE version is 8.3.2 I believe, is it possible to get a PE version of 8.2.4 if not I can work with 8.3.2 just asking as the version we are using in production is 8.2.4  and I would like to stay with our production version but if not that ok, just asking. thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Hi All, We are facing issues with deferred server wherein we can see the error as "Subscriber has no alive RWs(2358)!". Could you please suggest what could be the possible reason behind this error. Thanks! ------------------------------Shubham NigamRocket Forum Shared Account------------------------------