Rocket MultiValue

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

The process is simple - create a report on the UV side, upload and open the file in Windows after the upload is complete.  I've gotten as far as windows detects a new file, but how can I trigger an app to start and open the new file? ------------------------------Scott JohnstonSr Architect &n DeveloperSonna SolutionsDover DE US------------------------------

Having encountered a problem with MVVS I want to raise a support case so I can document the specific details of the problem (which are not appropriate for public forums). There is no "Product" option for MVVS. I tried the link "Unable to find your Product? Need assistance? We can help!", filled in the form with copious details and submitted it, but got no case number! So,  how exactly can I raise a support case specifically for MVVS ? ------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

The Rocket® Software MultiValue team is pleased to announce the availability of OpenQM 4.0.9 on February 20th, 2024. OpenQM 4.0.9 brings new enhancements to the DEADLOCK parameter making the analysis of a deadlock situation easier, multiple documentation updates, as well as multiple bug fixes. Product Lifecycle 20 Feb 2024 - Generally Available 20 Feb 2027 - End of Marketing 20 Feb 2028 - End of Service 20 Feb 2030 - End of Limited Support Plan your upgrade If you have a current maintenance contract, visit Rocket Business Connect (RBC) today to download 4.0.9 If you don't have an active maintenance contract, please contact your Rocket salesperson or partner. ------------------------------Hunter HolmesRocket Internal - All Brands------------------------------------------------------------Hunter HolmesRocket Internal - All Brands------------------------------

Hi, This is Keerthana. I'm Senior Software Engineer in TP project at Mitra Innovations. Currently, we are attempting to establish a connection between U2 Python and native Python. Our concern is that what we have done first is used UOPY module to access the subroutine and data file in BP source in XDEMO account using session. But U2 python does not require a session because the u2py module is included in the XDEMO account. But if we want to connect U2 python and native python there must be a configuration or session right? Can we connect this without using a session? Or are there other ways? We checked the .pyconfig file in the UV and tried changing the path to PYHOME and PYLIB there. But we are unable to connect. So Now we are thinking for the connection purpose we can use the any middle ware, Like MVIS. I'm not sure our thought is correct or not. So please anyone have any idea let me know or do you have any refrence please share with me ------------------------ Thank youKeerthana.RSe

This is a two part question to solve one problem. The first part; does a called subroutine use a new block of memory and address pointer? If so, doe this newly created memory clock have to wait for a time slice before it is processed? Also if the same sub is called multiple times, will use the already created block of memory?Part two; is it possible that calling a subroutine can break a phantom to the point of failure?We suspect our over night phantom process is dying because a tracing file we update with a small sub is killing the phantom.I personally do not, nor have I ever, actually known a phantom to die, because of repeated sub calls. However, we have to investigate the possibility.Thanks,SJJ  

Hi, This is Keerthana. I'm Senior Software Engineer in TP project at Mitra Innovations. Currently, we are attempting to establish a connection between U2 Python and native Python. Our concern is that what we have done first is used UOPY module to access the subroutine and data file in BP source in XDEMO account using session. But U2 python does not require a session because the u2py module is included in the XDEMO account. But if we want to connect U2 python and native python there must be a configuration or session right? Can we connect this without using a session? Or are there other ways? We checked the .pyconfig file in the UV and tried changing the path to PYHOME and PYLIB there. But we are unable to connect. So Now we are thinking for the connection purpose we can use the any middle ware, Like MVIS. I'm not sure our thought is correct or not. So please anyone have any idea let me know or do you have any refrence please share with me ------------------------ Thank youKeerthana.RSe

Hi All, We have some CALLX programs saving audit data for certain master files. Function system(45) returns the calling program name but that is always the name of the CALLX program. System(33) is supposed to also return a program name but is always empty. Is there a way to retrieve the "chain" of calling programs - similar to check.pibs but without having to understand 2000 lines of deep code! Also a way to see if the item was updated in the editor/UP as opposed to in a program? Any tech ideas welcome. Thanks in Advance Tom Power------------------------------Tom PowerOwnerPower Business SystemsBenoni ZA------------------------------

What version control packages does this product support? Posted: 02-10-2024 10:36------------------------------Doug AverchOwnerU2 Logicwww.u2logic.com------------------------------

We use BEL=CHAR(7) to make a beep on errors.  We would like to have the ability to have 2 beeps or 3 beeps, but multiple beeps get combined into one.  I have only been able to get multiple beeps by adding SLEEP 2 between the BEL's.  Is there another way to get more than one beep to come through? Thanks! Rob Mitchell------------------------------Rob MitchellRocket Forum Shared Account------------------------------

I have been away from the U2 community for 15 years. Just downloaded the UV 11.4 trial Windows (2-user). How is it that I create another user to test remote login from the network?  I looked at XAdmin but didn't see anything about users/logins there.------------------------------Chad LarsonPrincipal DeveloperSelf RegisteredLehi UT US------------------------------

Hi All, I wonder if anyone has ever tried to create an SBXA Character Screen with more than 80x25 characters. I have tried the following: Terminal definition in SBXA Standard and Condensed Column/Row 132/43 Terminal setup in SBClient Wyse60 with 132X43 In principle, everything works, although I have to edit the screen definition with the screen editor to enter the window coordinates 0,0,131,41 because in /SD it isn't accepted. However, the problem is that not all characters are displayed correctly. For example, in the screen I created for testing purposes, texts are not outputted from line 20 onwards, but the field contents are still visible. It seems that something with the cursor Addresing goes wrong by trying this hack... I know I'm pushing the boundaries of SBXA with this, but I want to give it a try to gain some time until we have the replacement of character screens with GUI ready.. Maybe someone has already tried this with, or withoult luck - every information would be hel

I have encountered a hard-error when attempting to use the Online editing mode (Online Editing - Rocket MV BASIC Rocketsoftware remove preview Online Editing - Rocket MV BASIC Online Editing is an additional method for modifying BASIC program files on the U2 server. With this feature, users can remotely edit BASIC program files on the U2 server instead of having to retrieve or upload files from a repository. However, it is important to note that users cannot simultaneously utilize this mode alongside the traditional editing mode. View this on Rocketsoftware > ) . While attempting to open an account in the explorer tree, if the account VOC contains a Q-pointer that contains "?" in the name then an error is presented. No further processing of the VOC is possible and no list of files available for editing is presented. This is what the VOC item looks like: Whilst I wonder why such a character might cause the MV Basic extension so much problems, I can u

The JSON configuration for the UV host has the simple username and password fields, but does not include any settings for SSL connectivity. How far off into the future is support for security connectivity with the UV host?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

does rocket (or anyone else) have a preference of using resize vs memresize and if you do can you elaborate? thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------