Rocket MultiValue

Hello!What are the system requirements to use VS Code? I do not think I can install it since we use Unidata on HPUX , see Restriction from the Rocket website.   Restriction Currently, the extension can only be used to edit BASIC program files on the machine where the VS Code installed, it does not support editing BASIC program files on remote servers directly. -Peter G------------------------------Peter GonzalezprogrammerSelf RegisteredUniversity City MO US------------------------------

I just found that if you have enqueuing enabled on the primary ( FHB-ON (A ) and you also are logging all files ( FHB-ALLFILES-ON )  before using FSIHOTBACKUP to set up the primary queue ( FSIDM,FHB,P ), once you create the queue, an item with a null item ID is written to the FHB,P file along with two other items with the IDs 2 and 3. The presence of the null-item-ID item exposes a bug in the dequeuing mechanism on the secondary which manifests itself as a variable unassigned error in the fhb_GetQueueIndexes subroutine on the secondary server. The subroutine keeps looping around to the same error and dequeuing never starts.Engineering is aware and will be making some changes to the code, but in the meantime if you run into this, simply DELETE FSIDM,FHB,P "" and restart the secondary servers. And you should probably NEVER start enqueuing before you set up the file to which the transactions are queued.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket S

I have implemented multiple secure HTTP calls from UniVerse utilizing Security Contexts.  All I need for FedEx is a simple SOAP transmission, which contains the password, authentication, acct#, etc.Which Basic Extension(s) will do this?  Most of what I see in the manuals seem way more complex tan I need for this.------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Hello. Has anyone upgraded from Unidata 7.3.3 to 8.2.1 and saw a large increase in overall system memory usage? Especially in an AIX environment?We upgraded and went from 50 gig of real memory and 16gb of paging, with 1% paging to currently 130gb real memory  and increased paging to 80gb as a precaution after the system ran out of memory the days after the upgrade. We had to add memory and paging space on the fly after the upgrade. We saw smaller increase on 3 other servers, about 50%,  and the server with 990 users, over 850 logged in routinely, we had the extreme memory usage numbers above.Here is our top ten processes currently:ps aux | head -1; ps aux | sort -rn +3 | headUSER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMANDjgoelz 64815780 0.0 3.0 3687024 3687040 pts/352 A Aug 12 16:16 udtsfarren 2490806 0.0 1.0 1464620 1464636 pts/278 A Aug 13 6:24 udtrloomis 53412190 0.0 1.0 1021108 1021124 pts/1025 A 06:43:46 7:36 udtkbarbe 55247314 0.0 1.0 679120 679136 pts/870 A 06:19:08 2:07 u

I have been scanning the docs for 11.3 and so far have determined that it is possible to configure the UniRPC services (via the secuconf command ) to support secure TLS connections.What I have not seen is any detail about how to ensure that ONLY secure connections are accepted.Does anyone know if this is currently possible?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC Australia------------------------------

We found an issue in OpenDB in which an attempt to manipulate an SQL table that only has a primary key and no additional columns fails. A known-issues post will be made in the Rocket Community OpenDB Downloads section as follows:Known Issues:OpenDB cannot be used against an SQL table that contains only a primary key and no other columns as this causes an error in the WHERE clause of the SELECT statement.This has only happened to one customer who worked around the issue by adding a dummy column to the table. I've never seen this before and seriously doubt I ever will again.One must ask one's self: "Why the heck would one have an SQL table with a primary key and no data?" If anyone has a good answer for that one, please post a reply herein.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

I asked Rocket Software a few years ago whether there would be a library call like UDO for JSON which you can use in Unidata/Universe.Is there such a subroutine, function, or library call in D3?If not, are you using string manipulation to remove, add, and create JSON data arrays and objects?------------------------------Doug AverchOwnerU2 Logicwww.u2logic.com------------------------------

Is there a best practice way to version python packages between production and testing UniData accounts on the same server? The .pth files load in the same order regardless of which account a user is in (which makes sense), and relative paths + environmental variables don't seem to be supported in .pth. Was hoping to be able to make and test changes to a package in a directory under the testing account and move to the production account only when ready, possibly updating a production package. Separate servers, while desirable, in not possible right now.------------------------------Charles Sasaki-SkoppIT Coordinator/DeveloperVSIAlbany OR US------------------------------

I have encountered a weird behaviour of UniVerse 11.3.3 on RHEL .If I run a globally cataloged command and supply command line parameters the command processor does not attempt to run the program at all.As an example I have referenced an existing subroutine in the global catalog, just to prove that the code does get run without parameters.>*SYSFILE_CRTCannot RUN a subroutine that has arguments.>*SYSFILE_CRT HELLO WORLD>I have tested this on UniVerse 11.2.5 on RHEL 7 and had the same result.Is there a known issue with global catalog code not running if command line parameters are supplied?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

We are in the middle of a project to convert our old RedBack Objects over to SOAP Web Services.  I was hoping someone might be able to provide some suggestions to get around some really user-unfriendly aspects of the tool. When launching the Explorer, is there any way to have it default the Navigator to the WSDL?  That is the only thing we use, but it defaults to the UDDI.  Once we switch to the WSDL, it requires it to be selected twice to get the WSDL URL prompt. Once you get to the WSDL URL prompt, is there anyway to get it to default to the End Point?  Every time, we have to copy/paste it from the properties tab.  Since the tool knows what it is, one would think this would have been a no-brainer default. Once an Operation has been chosen to test, we have not found a way to easily switch to another operation (maybe missing something).  The only way we have done it is to close the Explorer and endure #1 and #2 above all over again. We are in no position to switch to any newer "tool"

Is there a way to get Unidata to respect a change to VFIELDSIZE without arestart? I have the setting being exported in a profile.d script and it'sset on interactive logins, but Unidata doesn't seem to want to respect thechange.

Don't miss the last roadmap presentation of 2021. Learn what's new in the most recent product versions and what's next in 2022. As always, we welcome you to share your reactions and feedback in the forum. We're running two live sessions so there's a opportunity for all to attend no matter where you live.Sign up here. ------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY United States------------------------------

Don't miss the last roadmap presentation of 2021. Learn what's new in the most recent product versions and what's next in 2022. As always, we welcome you to share your reactions and feedback in the forum. We're running two live sessions so there's a opportunity for all to attend no matter where you live.Sign up here. ------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY United States------------------------------

I am using UV 11.3.3 on RHEL7 for this investigation.I am trying to resolve the logged in user's group numbers into group names.The BASIC SYSTEM() function has a number of options to get a user's group details: SYSTEM(29) returns the current "gid" - as a group number SYSTEM(30) returns the effective "gid" - as a group number SYSTEM(1017) returns  the user's supplemental groups - as a dynamic array of group names SYSTEM(1403) returns all the local system groups - as a dynamic array of group names Having access to the user' supplemental groups makes it possible to establish security controls for parts of the application.Basing such controls on the group id rather than the name would make the security setup un-portable as there is always the possibility that the group ids will change on different systems.I have not found a system function that returns the group id and group name together.I can execute SH -c "id -gn" in order to get the user's primary group name.I can execute SH -c "id"

is it safe to run "uvlictool clean_lic -a" on a unix system while users are logged on? Thanks,------------------------------mark eastwooddeveloperAFS Technologies IncPhoenix AZ United States------------------------------

I have had a problem for years that when my UniVerse Basic program was attempting to create a security context record, it would create the 1st one just fine and then hang up trying to crate another one.  With the help of Rocket's Brian Kupzyk, we finally found the problem.There is a file in the account named ".bscrfile" that the saveSecurityContext writes to.  Protocol logging showed it was unable to open it, so the save left a lingering RD lock behind (even when breaking out of the program).After increasing the Unix permissions to 660 and setting user & group appropriately, the problem disappeared!Brian has generated a low priority engineering ticket UNV-31674 so Rocket may eventually fix this.In the meantime, this is the workaround for those of you who use SC's who may encounter this problem.Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH United States------------------------------

i just started working at a d3 shop after working with U2 for years. I am very surprised that D3 does not have the U2 AE editor. That AE editor makes it a breeze to view and modify VM and SVM data. I do not understand why it not available. It is just a special text editor.​------------------------------William MoffaSoftware DeveloperSelf RegisteredOld Bridge NJ United States------------------------------

Modernization. You probably see this word all the time. I'm curious, what does it mean to you? Specifically, what does modernization mean for your business-critical application that is built on a MultiValue platform. Your organization has invested in your business-critical MultiValue-based applications over the course of years and maybe decades. How do you ensure those applications can adapt and grow alongside your organization for continued return on investment for years to come? If you're focused on increasing productivity, are you looking at development tools and modern programming languages that are easy to use, efficient, and address the skills gap? If you're focused on simplifying integration, are you interested in lightweight, zero-install client applications with Open APIs? Is speed to market at the top of your list, including implementing continuous integration, continuous delivery (CI/CD), cloud (on-premises or hybrid cloud deployment and containerization)? If you're not focu

Hi, I have installed MV Basic for Visual Studio Code. It's really cool. I could open a basic programs folder, but could not connect to the database, so I can't compile, or have the additional features I saw it provides when connected.  I have followed the documentation of this Forum, downloaded the JDK 11 from the indicated link, placed its path in the MV Basic Extension configuration, and created the following .rmv/db.mvbasic.json file:{"db": {"host": "192.168.2.100","userName": "root","password": "123456","account": "ALEDB","dataSource": "UNIVERSE","port": 31438},"includes": [{"includeFile": "BP","account": "ALEDB", "fileName": "BP"}]}  First of all, whenever I open a Universe Basic, the following message appears in VS Code:Java 11 or Open JDK runtime environment is abnormal. Please check your Java environment and settings  Second, when doing F1 -> Connect to MV Server, another messages tells me "Connect to U2 server failed"  Any ideas?  Regards,------------------------------Enriq

Have heard these sad stories of fool hardy conversions from MV to solutions selected as a result of recommendations by consultants, accountants and teh like.We have developed and implemented systems in MV over 40 years.The frame works that we built 30 years ago still stand robustly .The key words  used when confronted are:1) They say Legacy system: we counter by saying you mean a 9am to -5pm  system?2) The say MultiValue ???   We say: you mean you want to see the data like you see in a pivot table in Excel right ? or do you want an entity relationship diagram?3) They say difficult to maintain and modernize the system: We say we are technology independent .. tell us what you want and what frame work you want us to use to develop in? we will use  the framework that you recommend. 1) dont forget when we first used MV to develop systems the frame works were mainly  I/O (input output) . These systems were used by people who came in at 9 am and worked on thier green screens to input data fro

Well,  Interesting announcement this morning!!I have been hesitant to mention MVConnect as a great solution to modernize D3 since the product wasn't owned by the resource we are communicating on.  As of today I can!!!  While rocket has the MVToolkit that they are working on I prefer the MVConnect product as a solution and have built our web integration upon this product.The product is light weight and allows full control of the disbursement of data via pick basic and the business logic you currently have in place.MVConnect ROCKS!!!!I encourage all to take a look at it as a solution to your modernization needs.------------------------------Craig CurtisSystem ProgrammerSevier Valley School DistrictRichfield UT United States------------------------------

A while back, D3 introduced the concept of Host Authentication to give users the ability to manage passwords and password standards using O/S authentication ( Active Directory, LDAP, whatever ). This is detailed in the D3 System Administration Guides:https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/admin/index.htmhttps://www3.rocketsoftware.com/rocketd3/support/documentation/d3linux/103/admin/index.htmhttps://www3.rocketsoftware.com/rocketd3/support/documentation/AIX/103/admin/index.htmWhile that is a really good thing to implement and highly recommended by Rocket D3 staff, including myself, sometimes it can be a bit challenging to implement. For those of you who simply want a way to enforce D3 password standards ( expiry, history, length, character content ) from within D3 itself, you might want to take a look at this program I wrote for an end user. To implement it, you would call this program from the USERS file item logon macro ( somewhere after TERM-TYPE on

Currently, I can list the last 60 commands.Can this be adjusted?------------------------------Shawn WaldieRocket Forum Shared Account------------------------------

Good morning everyone;We are getting ready to do a request for qualifications and I'm not sure where to get started.  I am reaching out to this group since the project is to maintain and program our Unidata software through Rocket Dynamic Connect.  I have been the Accounting Manager and only know a bit about the technicalities of the software, all I know is that the software works, I just need help to maintain it and make changes as needed, create reports and perform routine maintenance to prevent issues with the system.Is anyone aware of a sample RFQ that I can use to send out to potential consultants.  We are currently working with a two employee company and we are growing much faster than they can keep up with us.  We are a water district and use Unidata for everything, currently using 11 modules (Accounts Payable, Accounts Receivable, Backflow, Utility Billing, Fixed Assets, General Ledger, Inventory, Purchasing, Payroll, Assessors Database and Valve Maintenance).I'm not sure if th

How have others that are using MVS tackled the challenge of pagination for result sets?------------------------------Jeremy LockwoodAwesomeASE Supply IncPortland OR United States------------------------------