Rocket MultiValue

I think I am missing something basic with the spooler.  For a long time our company was using D3 and the way our software was setup, whenever something was to be printed, it would first generate a hold file and then the user could send the hold file to the printer at their leisure. When we switched to QM I just had things go immediately to the printer because for the life of me I couldn't figure out how to send a hold file to the printer after the fact.  I know this is something very basic but I just don't see it.  The solution must be in some mental blind spot of mine. Can someone help me with this?------------------------------Steve HenkelCIORocket Forum Shared Account------------------------------

I have RHEL 8.8. It has OpenSSL 1.1.1k. My UniVerse version is 11.3.4. It is OpenSSL 1.1.1b. What is the correct procedure to upgrade UniVerse's OpenSSL to 1.1.1k.  I'm trying to install a Python Module and it throws an error trying to download a new version of OpenSSL. Jon

Hi all, Apologies if I'm in completely the wrong place! We have an appplication running on D3 and have a linked sever in MSSQL using the ODBC connection. When retrieving a date column I am getting error : Error converting data type DBTYPE_DBDATE to date. select * from openquery (LINKEDSERVERNAME, 'SELECT DATE_COMPL FROM SOH SOH WHERE (SOH.DATE_COMPL={d ''2024-03-01''})') From Googling it seems I need to convert it to a string, but I am unsure of the conversion functions in D3. Any assistance would be much appreciated! Many thanks,Michael

I'm embarrassed to even ask this. I've seen the answer a couple of times in the documentation but can't ever seem to find it if I'm looking for it. How do you disable the automatic paging where the program prompts the user to hit the return key to continue. I know I can use the NO.PAGE option when running the program but I want to disable it in the program itself. Most of these programs were written for native Pick and were never designed to handing automatic paging. That's why I want to disable it in the program and not in the menu that run's the program.

I have a client who started their business on R83 and are now on D3 Linux. All of their USERS were created long before D3 and by my former partner. In every account on this particular system, regardless of where you are, a CTRL-BREAK re-executes the MD item - BASIC or PROC - when you type END from the debugger. I reached out to Rocket support and was unable to get a solution, so I poked around in my old reliable R83 manual and found that if Attribute 9 in the USERS item is set to R, that's exactly what will happen. If it's set to L, then END leaves the user at TCL. The moral? Never trash your old manuals.------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

I have noted that the MV BASIC extension creates ".vscode" subdirectories with a simple settings.json file containing "settings": {    "[rocket-mvbasic]": {      "editor.codeLens": false    }} This appears to be how the Code Lens functionality is turned off by default. If I adjust this file to use "true" instead of "false" then I do get the functions and variables presented in the Outline view as well as in the breadcrumbs facility. What I don't get is the reference count functionality shown in Code Lens - Rocket MV BASIC Rocketsoftware remove preview Code Lens - Rocket MV BASIC Code lens allows you to review your code and find references to variables, functions or subroutines without leaving the editor. To list these references, click the hyperlink as illustrated below. The hyperlink is highlighted when you hover your cursor over the text. Since 1.2.0 release, this feature is disabled by default. View this on Rocketsoftware > I can use the <ctrl&gt

As the result of the post by Bryan Buchanan I have started have a look at the Java API to interact with D3. I'm working on AlmaLinux 8.9 with D3 10.4 installed. I have downloaded the file MVSPJavaAPI.zip and successfully compiled and used then MVSPJavaAPI/mvspTest/mvspTest.java program. The program connected instantly and all data accesses were instant. Using that as my basis I created a console program but ran into an issue with connecting. The connection in my program is taking 2 to 3 seconds to complete. Data access is instant after the connection occurs. At the same time I am seeing the following message lines in /var/log/messages: Mar 10 20:49:13 Alma8 systemd[1]: Started D3's per connection MVSP server for pick0 (127.0.0.1:53850). Mar 10 20:49:16 Alma8 systemd[1]: D3MVSPpick0@2-127.0.0.1:9000-127.0.0.1:53850.service: Main process exited, code=exited, status=1/FAILURE Mar 10 20:49:16 Alma8 systemd[1]: D3MVSPpick0@2-127.0.0.1:9000-127.0.0.1:53850.service: Failed with result 'exit-c

Is there a way in PROC to test the @TTY variable and exit if it is equal to phantom? Sorry, Prime Information guy here, not much PROC. Jon

Hello All, We have a huge bunch of UniVerse Basic Routine. Now we wish to move to the modern world..specifically ASP.NET.  How should we go about doing this ? While keeping the structure intact and reusing the UV Basic Routine ?------------------------------Koon MIng FongMrP & O Global Technologies SDN. BHD.KUALA LUMPUR MY------------------------------

Hi Team, I am seeking assistance in implementing an audit trail or specific logs to trace issues and check the history of the system or program, including details such as who accessed it, when, and other relevant information. Is there any way to implement this in universe ? I would appreciate it if you could assist with this. Thank you.------------------------------Gnanaseelan gnanapirakasamSSERocket Forum Shared Account------------------------------

Good afternoon, D3 hosted on a Windows 2008R2 Server I have recently learned how to add printers to the D3 user-coldstart macro. This is the third printer I have added. The two previous are working perfectly. The last printer I created using a Brother printer (PCL) Windows driver. However all the text coming out of the printer starts with %!, which is an indicator of a postscript text stream. This causes pages of postrscript text to spew out of the printer. I have tried:  changing the driver removing and adding the queue again using a new queue (eg; added a new port 15 and 16) no difference We have 14 printers that work, this one is giving me fits. Ideas welcome. Dumping the printer is an option..but just in case Bret Stern ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

I am trying to confirm how U2 handles this inherently: 1st run a program from my own MY.BP  ex: "RUN MY.BP TEST.PGM"  TEST.PGM calls a subroutine, ex: TEST.SUB(arg1),  that exists in both the account's BP (cataloged in VOC) and a special version in MY.BP.O will U2 first look at the VOC to execute the subroutine and then, if not found, look in MY.BP (where the original pgm was run from) will U2 1st try to run the MY.BP version, and if not found, run the one cataloged in the VOC or, must I name my version to be unique, ex: call TEST.BP.NELSON(arg1), to have it run my version We often have a group of programs and subroutines that handle a process, and we are making changes to some of the subroutines, but not all.  Understanding the U2 rules of engagement would really help. Nelson ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

We're experiencing frequent "No More LCTs" errors in Unidata, forcing restarts to resolve the issue. However, the LCT statistics indicate a normal total LCT count which is below 50%. Can anyone suggest what are the other possible ways to diagnose this issue? is there any way to temporally fix the issue when "No More LCTs" occurs without restarting the UniData. Any help would be appreciated?  Unidata Version - 52

I know of 3 specific issues with MVVS that have impacted our attempts to use it in-house, but these are not listed on the Known Issues page in the Documentation portal. When working with new software I use the Known Issues list to help me understand if a problem I am experiencing is something already known about or if it is new (or unique to my scenario). I'm curious to understand how frequently the list is updated.------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

Hi all, Apologies if I am in completely the wrong place! We have an application running on D3 and have a linked server set up in our MSSQL server using the D3 ODBC. When selecting a date column I'm getting the below error. Google tells me I need to convert it to a string somehow, but I'm not sure of the functions in D3 to achieve this. Any help would be much appreciated! Error converting data type DBTYPE_DBDATE to date. select * from openquery (LINKEDSERVER, 'SELECT DATE_COMPL FROM SOH SOH WHERE (SOH.DATE_COMPL={d ''2024-03-01''})') Many thanks,Michael

We're experiencing frequent "No More LCTs" errors in Unidata, forcing restarts to resolve the issue. However, the Total LCT statistics indicate a normal total LCT count below 30% normally. Can anyone suggest what are the other ways to diagnose this issue to fix permanently?  is there any other way to fix "No More LCTs" without restarting the UniData?

Some existing UniVerse IDE tools still maintain item locks within the database to provide concurrent access controls to source code. How does MVVS manage concurrent access to the same source code file? How well does it work with tools that obtain record locks before code editing begins? Does MVVS detect changes to the source file being edited and either adopt them when there are no changes in the current edit window or provide the option to merge the changes into the edit window so the source code can reflect the recently saved changes as well as the current editor's adjustments?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

I have quite a few customers running Rocky Linux as their OS for D3. Every single one of them has the same problem. A reboot of Linux, not a total shutdown, changes the designation of the USB drives that they use for nightly on-site backups. What was /dev/sdb might come up as /dev/sdd on a reboot. Since they are designated in the PICK0 file for FILE-SAVES, this creates a major problem. How can I prevent this problem?------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Hello, Does anyone know how to create a dashboard screen in an Accuterm application?  I am just wondering to create html pages and use the html viewer, but I would appreciate if someone could share his experience on this case. Thanks. 

I want to iterate through and array passed to a subroutine but I need to know how many elements are in the array.

The Rocket MV team is pleased to announce the release of UniData 8.3.1, U2 Common Clients 5.4.1, and MV BASIC for Visual Studio Code (VS Code) 2.4.0 on February 26th, 2024. Rocket® UniData 8.3.1 UniData 8.3.1 HA/DR enhancements and bug fixes help you manage your replication environment more effectively. We've added a new script so you can stop and restart the repmanager, eliminating the requirement to restart UniData if the repmanager becomes unresponsive. We've enhanced the "invalid log sequence" message to include the actual and expected LSN number, which will assist you when debugging. We've added a skip option to the ud_repadmin command to facilitate recovery from stalled subscriber groups. UniData 8.3.1 security upgrades and enhancements help keep your applications and business safe and compliant. By upgrading to OpenSSL v3.0, UniData supports a wide array of protocol levels. OpenSSL 3.0 includes a major architectural change from OpenSSL 1.1 and brings with it enhanced security

There is a command in D3, RENAME-FILE, which changes the name, but does not appear to change the name in Processes where that particular file, or data from it is used. Is there a straightforward way to change all references to the file where it is accessed throughout the system? Thanks

Here's the Rocket Community Portal (RCP) link: https://my.rocketsoftware.com/RocketCommunity/s/release/a0GVx0000007iltMAA/mvs-toolkit-233?c__downloadProduct=Rocket%20MVS%20Toolkit With this new version of the MVS Toolkit, the Jetty web server was upgraded to version 11 to address security concerns. Also contains some minor bug fixes. Here's the important known issues text, just in case you forget to read the readme before installing: MVS Toolkit client and server for Windows requires Visual C++ Redistributable Packages for Visual Studio 2019 to be installed. The MVS Toolkit v2.3.3 installers will not upgrade in-place for versions prior to v2.3.3. Complete the following steps to upgrade: 1. Export your web services.2. Uninstall the previous MVS Toolkit client and server.3. Install the MVS Toolkit v2.3.3 client and server.4. Import your web services. ------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

I'm seeking a way to ascertain where jBASE is verifying login credentials via an AccuTerm script, or at least show a verbose log or trace of the connection attempt. An AccuTerm 7.3a user logs into their workstation using domain credentials. Those same credentials have been stored by AccuTerm in the workstation's user registry for use when connecting to the jBASE server. The jBASE login fails; jBASE then offers a different login scenario (possibly using local user credentials?), requiring manual entry of the credentials, which succeeds. These are the same credentials saved in the registry and Active Directory. AccuTerm 8.1. behaves similarly. This is jBASE 5.2.23 on Windows Server 2016... Any suggestions? Regards, Bob Wyatt .------------------------------Bob WyattIntegration/Support SpecialistAshwood Computer IncCincinnati OH US------------------------------

Hi there,I've been looking for a long time, how to execute the 'DOS' command in a trigger in Universe.I have seen in some forum, that they indicated to add an 'H' in attribute 4, in the VOC DOS of the UV account.I have tried this and it does not work, since when firing the trigger and executing the DOS command in the subroutine, I get this message: Program "ED": pc = 744C, Verb "DOS" illegal when a transaction is active.Program "ED": pc = 744C, Error performing trigger for "XXXXXXXX".Failed to file "20451390" in file "XXXXXXXX". STATUS = 2Has anyone had the same problem of being able to run Verb on triggers? Thanks and best regards------------------------------Miguel Esteban Rodriguez GonzalezDataDealer Software España------------------------------