Rocket MultiValue

We noticed these entires in our errlog for the first time today - where could we find some more info on what's happened here?Is it just indicating that the unirpc service crashed? We're running UV 12/RHEL 7.9 Mon Jul 25 07:17:09 -17 root /usr/uv/bin unirpc: No Connection Mon Jul 25 07:17:09 -17 root /usr/uv/bin uvnetd: problem send first packet. ------------------------------Matthew WrightAnalystTomago Aluminium Co PTY Ltd.Tomago NSW AU------------------------------

Good Afternoon Everyone!We are in the midst of upgrading to UniData 8.2 from UniData 6.0, SB+ 5.2.3 to SB/AX 5.5.4.   My coworker and I are trying to use the .NET processing to connect to various processes/databases and seems like we are running into "potholes" or "walls".I have downloaded the U2 Clients And APIs UniObjects for .NET Developer Guide version 5.2.1 and the U2 Toolkit for .NET User Guide version 2.2.3.My questions are the following: Has anyone else experienced issue like this that can share with us? Is there other PDFs/documentation out there that we can look at? Any feedback will be welcomed.Best Regards,------------------------------Grant BoicePrincipal Software DeveloperMatheson Tri-Gas Inc.Warren, NJ 07059------------------------------

Hi allIs there a way to test the "level" that one has arrived at when the "execute" (verb) is used in code?It is of my opinion, that if one reaches past a certain level, this may cause the code to break (and falls into debug)I remember with the ADDS Mentor implementation, there was a check (some system(??) ) which one could test and take the appropriate action.Failing which, I guess, a simple stack_pointer counter may have to be implemented before such an (execute) statement - but that's messy :)Thanks------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

Greetings all!We are about to move our Linux OS from RHEL 6.7 to RHEL 8.3 and our DBMS from D3 9.0.0 to D3 10.3.xFrom a security perspective, is there anything that has to be tweeked for user security and user's ability to connect to D3 from RHEL 8.3 and continue working as they do todayt? As an example, if I log onto D3 as "SomeUser", when I shell out to Linux, and perform a "whoami", the result is "root".It is my understanding that Red Hat has done many things to prevent users from inheriting "root" privileges.  Has that proven problematic with D3 use/users?~doc------------------------------[Doc] [Ruckel][IT Guy][Southwest Traders][Temecula] [CA] [USA][Doc]------------------------------

Hi Members,My organisation is trying to engage Tableau for our reporting system. Currently our universe system is 11 .2. Just wondering if Tableau can connect to universe.Please advise accordingly.Thanks------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

Thanks Brian (as usual)!

Is there a way to serialize a UDONode in the UniData debugger?  If not, may I suggest the enhancement; it would be very helpful.!\\RESTMSG a UDO node variable. ------------------------------Elaine LitchfieldOwnerElaine Litchfield ConsultingSan Diego CA US------------------------------

Hello Forum Members!I have a question and hope someone can point me in the right direction.    I recently stumpled across the a file directory named __V__VIEW.     It appears it has something to link UniData to an SQL environment.   My question is this....  Where can I find documentation on this?    I can seem to find it or maybe I'm looking in the wrong places.If someone could lead me into the right direction, I will be most appreciative!!!Thank you for your time and consideration in advance.Sincerely,------------------------------Grant BoicePrincipal Software DeveloperMatheson Tri-Gas Inc.3 Mountainview RoadWarren, NJ 07059------------------------------

Hi Guys,OK so I'm venturing into the snakey  (or snaky) world of Python here :)According to: Python is available in Rocket D3 10.3.1 - The Rocket MultiValue Blog The Rocket MultiValue Blog remove preview Python is available in Rocket D3 10.3.1 - The Rocket MultiValue Blog Python is an exciting addition to the Rocket Software MultiValue databases. Following on the success of bringing Python to UniData and UniVerse, Rocket Software in now bringing Python to Rocket D3. In Rocket D3 10.3.1 we have added Python to work with your existing data in a new language. View this on The Rocket MultiValue Blog > Which I have like so :PYHOME=C:\\\\Users\\\\Stefano Gallotta\\\\AppData\\\\Local\\\\Microsoft\\\\WindowsApps\\\\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0PYLIB=C:\\Program Files\\Python\\Python37\\python35.dllAccording to my machine.However, I still get: (obviously I don't have the correct setup) :(Any pointer/ideas/recomms /stuff to read! :)ThanksStefa

I work with a set of code that verifies data and emails when something is wrong so these problems can be dealt with right away. It runs overnight as a phantom started by a linux cron job.The often changing nature of this code means it can be more prone to bugs like a variable not assigned.  That's fine, I can see the problems in the runtime-errors next day and fix. My problem is this program quits when it runs into a runtime error but if I run the same code in the foreground it doesn't.Is there a setting where I can control this behavior?Environment is D3 10.2 on CentOS------------------------------Bob FrankSoftware DeveloperJoseph N Golubov Associates IncLeesburg FL US------------------------------

Hello!In another thread, Jonathan indicated:"At 11.3.1 python was added for Windows and Linux only. If you want to use python on another platform you will have to upgrade past 11.3.1. Solaris was added at 11.3.2 , Aix was added at 12.1.1 and currently is not available for HP."According to the release notes, Python has been supported in UniVerse on AIX since 11.3.2, same as Solaris. Are the release notes incorrect?Brian Paige

Hello everyone  ,Anyway where I can extract data directly from universe using python?I want to pull data directly from universe and display it using python. Need some guidance here. Thank you.------------------------------Roland KayverCore Banking SupportRocket Forum Shared Account------------------------------

As a normal practice I wouldn't be posting example code onto the forum unless someone was needing help about a specific problem. We did have a question come in from a customer this week asking for a new conversion code be added to UniData. This brought up a couple of interesting subjects. The customer was not aware that you could write your own code following a template to create your own conversion codes. It took me some time to find where this was buried in the manuals I can understand why they would not have come across it.So just in case others were not aware you could do this I thought I'd share with you how you do this.SUBROUTINE SUBNAME( return_val, STATUS, input_val, TYPE )***************************************************************** Brief functional description** (c) Copyright notice**************************************************************** Detailed description** Usage, such as return_val = OCONV(input_val,"USUBNAME")**************************************************

When reading uv/errlog events, I would like to know what the call return stack was when the error occurred.In other words, the same info one gets from PORT.STATUS LAYER.STACK, or RAID "T" trace command, or SYSTEM(9001) function call. Create a UVCONFIG parameter for verbose error logging if you think it will be too burdensome to inflict on unsuspecting customers, but with today's system speed and storage capabilities, I think most would opt for more info. Business case: uv/errlog is an underappreciated but powerful tool for application quality improvement by working patterns of errors, correcting data, & -- most importantly! – finding & correcting root causes. Sometimes it is hard to resolve nebulous errors like:- Bad data "Y" for conversion "D2/". Unconverted data used for selection.- RetrieVe: syntax error. Unexpected symbol. Token was "ALL". Scanned command was . . .- Verb `VAN` is not in your VOC- Program "XYZ": Line 1234, Variable "ABC" previously undefined. Empty stri

Hi AllHas anyone found a suitable extension such that PyCharm works well - as intended?My use is sans extension and my use is "as is" from a full-screen form, however, the editor has some rather great enhancements for  other languages (Python obvious)Thanks------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

I was wondering if someone could comment on the use of the WIN.GETFTP host subroutine.  Every time we use it, it spits out a message "Invalid conversion type NO".  We have always set the type to "0" for ASCII when we make the call, but no matter what we set it to, we always get this message (and have for many years and versions of wIntegrate).  We currently use v6.4.0.What is it complaining about?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

MultiValue Integration Server version 1.3.1 has been released on June 28 2022 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

I'm developing a subroutine that will copy a record from one file to another.Depending on the value of one of the input arguments, the target record will be overwritten if it already exists in the target file.Upon confirmation of a successful copy, and depending on the value of another input argument, the source record could potentially be deleted.I'm looking for methods of confirming the copy was successful; i.e., the target record is identical to the source record.Any suggestions?------------------------------Shawn WaldieManager, Enterprise Application DevelopmentRocket Forum Shared AccountLos Angeles CA US------------------------------

We will soon upgrade UV storage to solid state.  A couple times in my life I've seen fast I/O bring unanticipated timing issues when file updates happen sooner than anticipated by the application design.  I'm struggling to remember details.  One was a multi-write logical transaction where, at some point, some files were moved to a much faster disk or bus than the others, so the writes got temporarily out of synch, creating unanticipated confusion for nearly simultaneous queries.  It wasn't a problem when everything was slower. Would anyone care to share any such gotchas they've seen, particularly when moving to solid state storage? (It does seem an odd thing to complain about:  my system is too fast.)------------------------------Chuck StevensonDBA / SW DeveloperPomeroyUS------------------------------

Hi I am looking to support a scenario where multiple users share a single workstation and want to work in my SBXA application within the context and constraints of their own user accounts.I'd like to make this switch of user accounts (which is frequent) as quick and painless as possible. And my initial thoughts are to explore smart cards/NFC cards and readers to achieve this.Wondering if anyone has given some thought to how one might go about integrating smartcard/NFC readers with SBXA.Initial thoughts are to explore custom control in SB/XA written in .NET and have it listen for commands and invoke BASIC program to login/logout etc.Not sure if there will be any way to programmatically log a different user in, or whether the SH.SEC.API can decrypt a password, or whether switch of users can occur without knowing the password.Note windows single sign on is not and cannot be used.I would welcome some idea or alternative approaches that the community has implemented to address a similar cha

Good morning Rocketeers!Thanks much for the very helpful replies to my last thread...has already proven valuable.For D3, I would like to know what Rocket suggests for regular tuning, maintenance, administration.If possible, I had hoped to hear from the general D3 Rocketeer community, what practices they adopted for tuning, maintenance, and administration of the D3 database...THX in advance for your helpful replies!~Doc------------------------------[Doc] [Ruckel][IT Guy][Southwest Traders][Temecula] [CA] [USA][Doc]------------------------------

We utilize 4 connection pools used by our Web Service calls.  Occasionally we have had web services timing out and not even reaching our U2 programs.  I was hoping for some ideas on how we might  check the connection pools to determine when they are overly busy, or calls are backing up/timing out.  We have not found a way to determine this.  Our web team contacts us when their calls are failing and we must dig around looking for a problem.  Hoping there might be some "tools" that would specifically target the health of the connection pools.------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

When developing RESTful service APIs or server side code used for jRemote (e.g. ODBC) it can be cumbersome to use logging and/or temporary writes to a file to trouble shoot the send/receive messages in your jBC server side code. In jBASE 5.8, when you start jbase_agent you can optionally include the following options: -S single session -d (enable debugging) -Jr (redirect debugging to another device) -J[D,d] (force the program/subroutine into the debugger at start up) Note that the -J options are standard jBASE program execution options for debugging. The difference between the D and d are that the D will force a debug on all EXECUTEs whereas the d drops into the debugger on the first program being executed. This may be a requirement especially if this is a RESTful API then the initial program will be an EXECUTE from the jbase_agent worker process.The advantage of using -JD or -Jd is not having place a DEBUG statement in your code. Though you may still find this easier depending on your

Good afternoon D3 folks!What is best D3 DBMS practice when it comes to deleting or RESIZE-ing data sections from a files dictionary?If we don't delete these data sections (we use them as work files when compiling report data) we end resizing too many of these data sections/work files. If I delete them, FOF gets populated with much meaningless data.Thank you in advance for your helpful reply/ies!~Doc

Historically, multi-value environments have been somewhat lax in enforcing use of locks when updating files. The locking system is voluntary and, if applications choose not to use locks, data integrity issues may arise. Two processes performing a read/modify/write update of the same record may overlap with one overwriting the other.There is a simple rule that eliminates this problem. Never write or delete a record without locking it first. This could be a simple update lock that protects the specific record or a file lock that effectively locks all records in the file.It is important to understand the significance of the locking system being voluntary. A badly written program that updates a record without locking it is not affected by the locks set by well written programs that follow the rules.This situation should never have been allowed. Attempting to write or delete a record without a lock should lead to some form of application error, however, such a rule cannot be retrospectively