Rocket MultiValue

hello folks,On large system running hundreds of users on the same application, very often I am faced with uniBASIC runtime errors in generic subroutines for which I do not have the source codes. Most of the time the problem is due to badly initialized variable by the calling program.The difficulty lies in identifying the calling program, knowing that errlog refers to the subroutine without showing the callstack.Does anyone have any idea how to capture the callstack and determine which program to fix?Here some samples from errlog :  Bad data “14/0/21” for conversion “D2-”. Unconverted data used for selection.​ Program “SB.EVAL.EXP”: Line 276, Variable “$R95” previously undefined. Empty string used Program “SB.GEN.DRIV.I”: Line 548, Nonnumeric data when numeric required. Zero used. Program “SB.EVAL.EXP”: Line 121, Nonnumeric data when numeric required. Zero used

Are there any UniVerse utilities that would show the commands run from a specific port?  When certain problems arise, this would be a great troubleshooting tool. One scenario would be to track activities from TCL at that port. Another scenario would be to track activities run from the initial TCL-launched programs It would also be helpful to have the date and time of those commands.  If not a utility, what U2 BASIC functions/commands exist that might be utilized in a monitoring program? Thanks in advance for any feedback.Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Connecting via ODBC, getting an error code of 39204.   Familiar with 39202, (which is usually invalid chars in passwd), but haven't seen this before and can't seem to find it in documentation.    Google search found a few references, but none that seemed pertinent - and there's nothing in this forum regarding it.I suspect that it has to do with user/domain authentication, but that's more hunch than fact based.So, that being said - can anyone point me to what this error code means?Thank you.------------------------------Allen EgertonDeveloperSS&C Technologies IncCT US------------------------------

Hi allFirst time posting...Im connecting successfully to universe, using uopy.connect. with the session i can run a command on the server, however every subsequent call to the server calling cmd.run() (please see below) results in the following error:UOError: Error [39207] : Error occurred on server. Possible client-side licensing failure.Note: this only happens  the second time, also calling uopy.connect takes an awfully long time to return, is this normal?My code: session = uopy.connect(**config) cmd = uopy.Command(cpmmandtext) cmd.run() print(cmd.response)​

Hopefully this is the right forum for this question.  Has anyone used fork (or forkpty) and successfully called _CP_logon from inside of a C program?  Is there a trick to making this work? When I try it, the child dies with a segfault somewhere in pick_init_termio in a call to strcpy.------------------------------Tom MarracciGeneral ManagerAircraft Sprucecorona CA US------------------------------

We have test and production accounts on the same system, which is to say that they reside in different paths on HP-UX.When the test account was first created, it was a clone of the production system with adjustments in various places to reflect the different paths.But our main files, ORDERS, PAYMENTS, and some others, are distributed files, and the distribution algorithms are equivalent on both test and production, as are the number of partitions.So, here are the questions:a) Can I refresh the data on test by simply copying the individual data portions from production to test?b) I recently fixed one broken file by copying the affected partfile from production to test, but maybe I didn't really.  It seems to work, but maybe I'm missing something.  I don't know for sure.  How can I be sure?c) And what about the stub files?  Are there even stub files on UV?  Do they contain the paths in which they were configured?d) Where can I find the latest, on-line documentation about this?-----------

Read my post in the Rocket blog and learn about the success story of Meier Business Systems (MBS) customer -  Mainstream Freight Grouphttps://blog.rocketsoftware.com/multivalue/2022/01/how-one-company-literally-transformed-their-business-using-mvis/------------------------------Brad HermanMultiValue Product EvangelistRocket Internal------------------------------

Hi Folks,First time posting here, but I've been working with UniData for about 5 years now after mostly working with MySQL and Oracle databases.    We get UniData through a VAR, but I'm pretty sure they think I'm crazy so hoping to get some wisdom from the community here.I've got a computed column ADDR.G82.SANITY.CHECK defined asSUBR("CC.G82.ADDRESS.SANITY.CHECK",COUNTRY,STATE,ZIP)The subroutine opens another entity and selects against it to try to match postal code first letter to province and state to ZIP to see if addresses look "sane".If I use the computed column in SELECT criteria with an active list, it fails with wildly wrong results.  However, if I execute a SELECT ADDRESS WITH COUNTRY = 'CN' SAMPLE 1000SAVE.LIST CNADDRGET.LIST CNADDRLIST ADDRESS COUNTRY STATE ZIP WITH ADDR.G82.SANITY.CHECK = 'Y'<<lists 922 correct records>>Trying it with SELECTGET.LIST CNADDRSELECT ADDRESS WITH ADDR.G82.SANITY.CHECK = 'Y'<<returns two records, not 922>>Th

Forgive me if this question has already been asked/answered but I couldn't find a way to search for this on the forum for Universe only.When debbugging a Universe program by putting DEBUG, or multiple DEBUG statements, in the program, then running the program.  Sometimes the program will break on the first DEBUG statement hit but then will not break on any other DEBUG statements and finish running the program.  To resolve this I've had to put input statements in the program and then CTRL-BREAK to get into the debugger.  This is very annoying.  Has anyone else run across this issue or know how to fix the issue?Thanks,Harry------------------------------Harry HambrickSenior Software DeveloperRooms To Go IncSeffner FL US------------------------------

I've noticed that output from my python routines that are called from universe programs doesn't go into the COMO whilst any output from the universe program does.  Anyone noticed this, found an easy way round it?------------------------------Neil SherwoodAnalyst ProgrammerHSBC Global Services (UK) LimitedLondon GB------------------------------

Anyone out there open other files in write triggers?Given a relationship such as this:customers hasmany ordersorders belongsto customerI'd like to sum orders.total and write it on customer.Instead of finding each routine that would need to update this value, I was thinking about adding it to the customer write trigger.  So every time a customer is updated, this value is evaluated and updated.What's the cost/risk to implementing it this way?------------------------------Jeremy LockwoodAwesomeASE Supply IncPortland OR US------------------------------

Hi all, Hopefully you will excuse the question.  I should know the answer but........We have a backup vendor that is triggering errors on our linux d3 volume.  Error is cannot index.  Speaking with them they would like to know how the volume is formatted?  If for no other reason than placing in an exception list so the error will not be triggered.  The company is Rubrik just for information.I told them it was the blob and they didn't think is was funny  :)Thanks for any helpCraig------------------------------Craig CurtisSystem ProgrammerSevier Valley School DistrictRichfield UT US------------------------------

Can anyone tell me a way to determine if a newly opened wIntegrate window is off of the viewable monitor screen? i.e. I command wIntegrate to open a new window but it is partially off of the screen, then I have to use the mouse to physically move it so the whole window is viewable. I have scanned both the 'winthost' and 'wintscr' manuals but have not been able to find a solution. I'm wondering if there is a solution, or perhaps additional documentation that could be helpful. I am using wIntegrate version 6.3.0.------------------------------Kevin HondMr.Self RegisteredKingsport TN US------------------------------

We use the WIN.LOOKUP subroutine often to provide pop-up boxes to allow for list selection by the user.  There is one main limitation for which we have not found a work around and have been trying for many years..  We are using v6.4.0.When the list exceeds 9 choices (and some of ours have 50+), we need the routine to allow for a 2-digit user entry.  Unfortunately, it will not, so to get to "85", a user must type "8" SEVEN times.  This shortcoming almost always causes entry errors and/or unnecessary  help-desk calls.Has anyone found a way to handle this requirement?  A different subroutine?  or is it just a limitation has has not ever been addressed?Appreciate any thoughts.------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

D3 Product Manager @Tim Rude sat down with @Robert Burke, recently reunited with Rocket via the Zumasys transaction, to update him on new developments with D3 and the product direction moving forward. If you are a D3 user you'll want to check it out! The product direction includes an change that promises to higher interoperability between operating systems, but questions still remain as to how to best architect the change to help clients navigate the migration. Tim poses that question around the 8:50 mark - let us know your opinion if you are are customer who will be impacted by this change. Also, feel free to ask any questions on this video below, or just tell us what think about the overall direction.  ​Regards, Dave​------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY US------------------------------

I am looking at getting started with creating custom GCI functions on  UV 11.3.3 (RHEL7 installations).I know nothing about c programming or compiling so am looking for feedback on how to get started (specifically with GCI - I figure I can pick up the c stuff as I go).Has anyone worked through getting the example GCI functions  built and integrated with UV?I have already learned that I needed to install the glibc-devel package in order for the compiler to be happy it has all the includes.Now I am stuck with the following:root@h1133# pwd/usr/uv/gcidirroot@h1133# make -f Make.gci gci_hellogcc -Iinclude -m64 -DU2_64_BUILD -fPIC -m64 -DU2_64_BUILD -DTHREADS -DFASTIO -DUSE_STDARG -DU_LINUX -DU2_LINUX -D_GNU_SOURCE -fPIC -Wimplicit-function-declaration -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -DNETwork=2 -DRAID -DUNIVERSEon -DU2SVNURL="/uvuddb-uv113/release/11.3.3@d15ee91-20210525" -lm -lcrypt -m64 gci_hello.c -o gci_hello/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/crt1.o: I

Hello Everyone, Maybe you have heard there is an important security issue in log4j recently. Hackers could attack your machine by using the log4j security vulnerability. The Rocket MV BASIC extension has several minor releases to fix this risk because it also uses log4j for logging. But sometimes you may don't know the extension has an update, or you forgot to update it. So we would like to share a tips to update the extensions in your VS Code automatically. You can manually upgrade your extension. But VS Code also supports to update all installed extension automatically. You can enable this function follow below steps: 1. open extensions view 2. click the '...' button 3. Move to "Auto Update Extensions" item and select "All Extensions" Then ALL installed extension will be updated automatically when there are new versions. You can also only upgrade enabled extensions by selecting "Only Enabled Extensions". Note: sometimes you need restart VS Code to make the upgrade ta

Hi All,Can anyone provide me with some guidance on how I can change the visibility of the Resize Grip which appears in SB/XA XAML Screens/Forms?I have played with "Snoop" and have tested that changing the "Visibility" property of the ResizeGrip component to "Hidden" has the desired effect of disabling the ability for users to manually stretch and resize my forms.I have managed to achieve this on Dialogs using something like below.<Setter Property="sbc:SBForm.ShowResizeGrip" Value="False" />But can't manage to hide it on standard forms.Thanks in AdvanceAaron#XAML #SB/XA #STYLES #THEME

Hello Again fellow SBXA Developers/XAML Extraordinaires!Can someone please provide some guidance on how to make the buttons in an F3 Intuitive Lookup dialog larger?Also would be great to know how to alter the spacing between them.Regards Aaron#XAML #SB/XA #STYLES #THEME ​​​​​​​

Apache Log4j vulnerability (CVE-2021-44228) - Critical As the Apache Log4j vulnerability (CVE-2021-44228) was disclosed on Dec 09, 2021, your MV teams have been actively monitoring the issue and assessing its impact on the MV products.    The following MV products have been impacted. Product impact and next steps are detailed below.   MV BASIC for VS Code: MV BASIC for VS Code v1.3.0 and prior contains and uses a version of Log4j that can potentially be exploited by this vulnerability.  We have therefore upgraded the Log4j version in MVVS 1.3.2 to v2.16.0 to resolve this issue and advise that you to upgrade by downloading the latest extension on the Visual Studio Code Marketplace.   NOT IMPACTED: The following MV products DO NOT contain any version of Log4j, OR contain a version of Log4j that is not impacted by the vulnerability:   MV Application Servers: UniVerse UniData D3 OpenQM mvBase jBASE   Server Tools: U2 DB Tools U2 Common Clients U2 Toolkit for .NET   Tools: MVX MVIS MVConnec

Just started working with the uopy python library. I'm able to connect successfully and run all the basic examples provided with no issues, but as soon as I started to extend it out to run some subroutines I've written, I started getting "Subroutine Error [30107] : The subroutine failed to complete successfully". Not entirely sure what would cause this as the same subroutine runs fine when ran outside of uopy. One thing I did notice is if I remove the READV statement within the subroutine, I do not receive this error. Below is the test subroutine I have been using.Any help greatly appreciated. SUBROUTINE (USER,JSON) $INCLUDE UNIVERSE.INCLUDE UDO.H READV USER.NAME FROM INIFILE,USER,3 ELSE NAME = '' STATUS = UDOCreate(UDO_OBJECT, testObj) STATUS = UDOSetProperty(testObj, "userName", USER.NAME) STATUS = UDOWrite(testObj, UDOFORMAT_JSON, TEST) STATUS = UDOFree(testObj) JSON = TEST RETURN​

Subject says it all - I've done some searching, haven't found anything, and like most organizations - we're looking at all of our installed products to assess our vulnerability.We've got instances from 10.3.7 through 11.3.2 installed on various servers.------------------------------Allen EgertonDeveloperSS&C Technologies IncCT US------------------------------

Apache Log4j vulnerability (CVE-2021-44228) - Critical As the Apache Log4j vulnerability (CVE-2021-44228) was disclosed on Dec 09, 2021, your MV teams have been actively monitoring the issue and assessing its impact on the MV products.    The following MV products have been impacted. Product impact and next steps are detailed below.   MV BASIC for VS Code: MV BASIC for VS Code v1.3.0 and prior contains and uses a version of Log4j that can potentially be exploited by this vulnerability.  We have therefore upgraded the Log4j version in MVVS 1.3.2 to v2.16.0 to resolve this issue and advise that you to upgrade by downloading the latest extension on the Visual Studio Code Marketplace.   NOT IMPACTED: The following MV products DO NOT contain any version of Log4j, OR contain a version of Log4j that is not impacted by the vulnerability:   MV Application Servers: UniVerse UniData D3 OpenQM mvBase jBASE   Server Tools: U2 DB Tools U2 Common Clients U2 Toolkit for .NET   Tools: MVX MVIS MVConnec

Apache Log4j vulnerability (CVE-2021-44228) - Critical As the Apache Log4j vulnerability (CVE-2021-44228) was disclosed on Dec 09, 2021, your MV teams have been actively monitoring the issue and assessing its impact on the MV products.    The following MV products have been impacted. Product impact and next steps are detailed below.   MV BASIC for VS Code: MV BASIC for VS Code v1.3.0 and prior contains and uses a version of Log4j that can potentially be exploited by this vulnerability.  We have therefore upgraded the Log4j version in MVVS 1.3.2 to v2.16.0 to resolve this issue and advise that you to upgrade by downloading the latest extension on the Visual Studio Code Marketplace.   NOT IMPACTED: The following MV products DO NOT contain any version of Log4j, OR contain a version of Log4j that is not impacted by the vulnerability:   MV Application Servers: UniVerse UniData D3 OpenQM mvBase jBASE   Server Tools: U2 DB Tools U2 Common Clients U2 Toolkit for .NET   Tools: MVX MVIS MVConnec

Apache Log4j vulnerability (CVE-2021-44228) - Critical As the Apache Log4j vulnerability (CVE-2021-44228) was disclosed on Dec 09, 2021, your MV teams have been actively monitoring the issue and assessing its impact on the MV products.    The following MV products have been impacted. Product impact and next steps are detailed below.   MV BASIC for VS Code: MV BASIC for VS Code v1.3.0 and prior contains and uses a version of Log4j that can potentially be exploited by this vulnerability.  We have therefore upgraded the Log4j version in MVVS 1.3.2 to v2.16.0 to resolve this issue and advise that you to upgrade by downloading the latest extension on the Visual Studio Code Marketplace.   NOT IMPACTED: The following MV products DO NOT contain any version of Log4j, OR contain a version of Log4j that is not impacted by the vulnerability:   MV Application Servers: UniVerse UniData D3 OpenQM mvBase jBASE   Server Tools: U2 DB Tools U2 Common Clients U2 Toolkit for .NET   Tools: MVX MVIS MVConnec