Rocket MultiValue

Hi All ,I've downloaded the trial version of the connector. I want to connect to our universe 11.2.5 with that one.We have installed the U2ODBC 32bit & 64 bit. Did a test connection in Tableau it passed but when we click on OK, it gives an error. The error code is A73B8869.The error is saying something about missing driver.Please assist.Thanks. ------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

Just started a position at Houston's Inc which uses D3. Apparently, sometimes they are setting group locks and other times they set item locks. However, no one seems to know why it does one over the other. The D3 handbook is unclear. We are trying to remove the group locks from happening as they really should only be item locks within their applications. The manual states that the typical readu, matreadu, etc create the locks. But there is no info on how a group is created vs the item...or perhaps both are created at the same time, but the group lock is released sooner? Looking for a way to identify when the code is generating a group lock instead of an item lock so that we can switch to item locks only.------------------------------Chris RazzanoSenior PICK programmerRocket Forum Shared Account------------------------------

Hi All - I am trying to figure out how to get accuterm ftd to create an xlsx instead of an xls. Anyone know the answer to this?Thanks!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Has anyone out there successfully integrated a credit card mag stripe reader with D3? Looking for something that you swipe a credit card and the information is captured using a BASIC INPUT statement as if the information had been typed on the keyboard. I see a few USB mag stripe readers out there on Amazon, but can't tell if they emulate keyboard input. If you're using one that works, please let me know the make, model, and source.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

Hi, Do you know where I can have detail about a U2ConnectionException ? Error I get from sbxa when trying to connect ? Many thanks for any help. Manu ()[SBXA.SBPlusAppServer.dll,SbPlusRuntimeService.SbAppConnect(0)] }{Failed to open connection to luluvpdb2541/E:\\INTEGRIX\\UVDB\\START using LU\\kmaus:SBXA.AppServer.U2OpenConnectionException:[193AG]-12    at SBXA.AppServer.U2Connection.OpenConnection()------------------------------manu fernandes------------------------------

Hi Guys,Maybe I'm missing something but does D3 (10.3) not have the raise (lower) function to alter @Vm to @Am (or vice versa) ?I guess one could use the swap function but I've been working with Open Insight and ​"miss" this :)------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

After installing as root, are there any options for running Unidata as aless-privileged service account? I'm working with a customer that forsecurity reasons does not want the main unidata processes running as root,and they're pointing out that Oracle, Apache HTTP, Postgres and many otherserver-side services have the ability to run under non-user accounts.I don't think it's possible, and haven't seen anything in the docs (thoughthere is a hint that it's possible for UV, running as a user uvadm,https://rbc.rocketsoftware.com/downloads/readme/UV-11.3.3.pdf?16:05)Thanks for any experiences, both positive and negative!Ian

Hi all,Just wondered if anyone has tried this or may know the answer. I have gzipped files in unix and I am trying to send these via a http POST, but having issues. I've tested via postman, so know it's something I am doing wrong.I have added 'Content-Type application/json", and "Content-Encoding gzip" to the header, and read in the file to use as the payload, but get the following when checking the response header:  ------------------------------Simon WoolfallSenior Software EngineerRocket Forum Shared AccountBELFAST GB------------------------------

Hi All ,We currently manually run retrieve sentence to pick up reports from universe 11.2.5 and AIX 7.2 Can we use scheduler to automate it ?Or anything to automate it .Please assist. ------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

good morning folks!does anyone in this group have a standardized test plan they use when upgrading RHEL/Linux in general that they can share?if not a plan, testing suggestions?THX,~doc------------------------------[Doc] [Ruckel][IT Guy][Southwest Traders][Temecula] [CA] [USA][Doc]------------------------------

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