Rocket MultiValue

I asked AI  if I need a web server for our D3/LX64 backend and it came back with the following;  Using a web server like NGINX can be beneficial in your setup with Rocket D3 MultiValue Database, a Node.js server, and a React frontend, but it's not strictly necessary. Here's a breakdown of how each component fits into your architecture: Rocket D3 MultiValue Database: This will handle your data storage and retrieval. Node.js Server: This acts as the middle layer, handling API requests, business logic, and communication between your React frontend and Rocket D3 backend. Node.js is well-suited for this role due to its non-blocking, event-driven architecture.React Frontend: This will be your user interface, providing a dynamic and responsive experience for users.NGINX: While not mandatory, NGINX can serve multiple purposes:Reverse Proxy: It can route incoming requests to your Node.js server, improving load balancing and security.Static File Serving: It can efficiently serve static assets li

What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column. Note that the second column also contains values such as L2, L3, etc.------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

I thought maybe it would be something that would help with MVBasic but it seems to be broken and won't install. I get an error that it cant open ".vscode/extensions/rocketsoftwarebeta.rocket-copilot-10.4.0/walkthroughs/getting-started/Git/start-rocket-CoPilot-for-git.md". I checked for the file and it's not there. There a similar one named "start-rocket-devops-for-git.md".  The extension says it's beta but it looks pretty alpha to me. Shouldn't someone at least try it before putting it in the VS code marketplace? It looks bad. Anyone know what it is or what it's supposed to do?------------------------------Joe GoldthwaiteConsultantPhoenix AZ US------------------------------

I'm not sure I know enough to know if this is a dumb question or not, but... Has anyone attempted to make the MV Basic for VS Code plugin function with an Eclipse (the ERP system built on top of Universe, not the IDE)? Would that require customization to work with "Eclipse syntax"? It's my understanding that Eclipse code is "pre-compiled" into Universe code, and so I'm wondering what would be needed to fix syntax highlighting, debugging, etc.------------------------------Kyle GagnetRocket Forum Shared Account------------------------------

i have FCService running ok on our almalinux 9.4 server, but i notice its binding to 0.0.0.0 which i'm sure is ideal when your D3 & Flashconnect are running on separate hardware. in our case they're on the same physical box, so i'd prefer if I could get FCService to bind to 127.0.0.1 instead. (like TLLicMgr does) is this possible? can i use something like a bind: command in flashconnect.conf? or maybe the port statement, instead of port 1505 would port 127.0.0.1:1505 work? thanks in advance!

I have some very vague memory that there's an attribute in a compiled item that indicates whether or not it's been FlashBASIC compiled or not.  Unfortunately, I don't remember what it was, and it's not obvious. :) Here's an example that I know for sure does not use FlashBASIC: Here's an example of a program that's compile with FlashBASIC: Is attribute 12 being > 0 indicate a FlashBASIC compiled program?  The reason I'm chasing this down is that I'm migrating from D3 v9.0.0 to v10.3.4 and I've got a lot of stuff that has to be recompiled due to the FlashBASIC changes, but I've got even more that can't be FlashBASIC compiled.  (does it need to be "normal" compiled due to the version change?) Thanks all! g. ------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific WindowsUS------------------------------

Trying to understand how the login process works on Windows when we use Accuterm and telnet to the Universe server. One of our users gets this message: Welcome to the Rocket U2 UniVerse Telnet Server.Enter user name: hrs\\BOBEnter password:This directory is not set up for uniVerse.Would you like to set it up (Y/N)? Our other users can login to the database just fine. All users should be connecting to the single Universe directory we have on the server. What directory is this BOB user trying to connect to? How do we get this user to connect to the Universe directory?  ------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

I have developed a website using WEBSVC and port 8180.  After much trial and error, I have it working and continue to add to the site.  Now I am trying to get SSL (https) working.  Apache is serving my login page (does not use WEBSVC and port 8180).  When the user logs in, now WEBSVC comes into action.  Since WEBSVC is running, it starts a phantom that servers 8180.  From the $COMO file, this is what I am getting when trying to connect. $COMO PH173_050924_0953174 line(s)----: P0001: COMO file activated to PH173_050924_0953170002: Phantom 173 started at 09:53:17  05 SEP 20240003: HTTP/1.1 500 Internal server error 1 [7013, 2]0004: Phantom 173 terminated at 09:53:47  5 SEP 2024Bottom at line 4 This is how I am initially starting the WEBSVC phantom. PHANTOM WEBSVC S.WEBSVC-14 DEBUGGING PORT 8180 Is there something I need to do to now tell WEBSVC that https is being used? Thanks for any ideas or help, Ted Hurlbut------------------------------Tedmund HurlbutSelf RegisteredSimpsonville SC U

Many years ago we changed our web-based software to support prompts, menu items, and help to support multiple languages. We did that by using a number for the prompt like 2300 was "Customer Name". Depending on the language you would go to the matching language file to translate the 2300 number to "Nombre cliente" for Spanish and "Nom du client" in French for example. In the 18 years we have demoed this to United States-based companies nobody expressed any interest until last week. This  client would like to have code files like  Code A1 equals Apple or Pomme in Spanish Code Z1 equals Avacado or Avocat in Spanish Our Universe database has a file called Fruits in this example. So my questions for those who have done this are: Do you add a field for every language? Do you add a multivalue field for every language? Do you change the value in the file to a number and translate it to a language field? Do you add a file called Fruit_ES for Spanish? Depending on the method chosen, how does

I'm in the process of setting up a "golden master"[*] in order to migrate six D3 v9.0 Linux hosts to v10.3.4. I wanted to get the base D3 install completed before turning the VM over to my infrastructure team for duplication. I'm installing on RHEL 9 (9.4 specifically) and noticed that nothing has been done regarding systemd during the install process, even though there's some passing acknowledgement in the docs that xinetd is deprecated.  Nothing for telnet, nothing for MVSP. I didn't know what to do regarding the missing systemd service scripts for telnet, (the word "systemd" doesn't even occur in the 10.3.4 installation guide.  That's problematic.), I figured I'd at least see if I could get MVSP set up - maybe that creates the systemd services. I'm greeted with this: :to mvsp < Connect time= 0 Mins.; CPU= 0 Units; LPTR pages= 0        >WHICH TCP/IP PORT NUMBER TO USE (9000) ?DO YOU WANT AN SSL CONNECTION (Y/[N]) ?Updating configuration. This could take upto 2 minutes to comple

Here is a record sample: The TESTING column is a multi-valued list, and the pipes represent actual SVMs for readability. I'm looking for a function that will return an associated boolean list indicating whether or not either '1400' or '9101' exists in TESTING, so... In this sample, if one is present so is the other, but that's not always the case. So a 1 should be returned if either exists in what is actually a subvalued list. EDIT 1: A subroutine would make this very easy, I know, but I don't have time for the administrative overhead that comes with developing/delivering one to PROD, so I need this to be "idescriptor" language. Also, there will be subsequent processing, based on a SUM() of the Y/N list for each record, which will be compared to DCOUNT(TESTING,@VM). EDIT 2: I think I found a solution. I didn't realize I could use the INDEX function on lists. Though it will require another step or 2 to get the final result, I think it will work.

i'm in the process of testing a big upgrade, from d3 linux 10.1 to d3 linux 10.3.4 and i'm sure this is another silly question but i don't know where to find the answers. probably because i'm not sure how to phrase the questions. when i log to the www account to start flashconnect i get the following error: [877] in program "WWW-STATUS", FlashBASIC object revision of program 'wbp WWW-STATUS' is incompatible with system revision - please recompile. i get the same error when i try to use www-manager. when i try to recompile i'm told they're not on file. :compile wbp www-status www-manager [202] 'www-status' not on file. [202] 'www-manager' not on file. i checked the reference manual and i found the (w option to recompile without source code, but same thing :compile wbp www-status www-manager (w [202] 'www-status' not on file. [202] 'www-manager' not on file. and finally, i saw in the flashconnect install.pdf it says you should "run bp upgrade" after an upgrade, so i tried that and got th

Hi, Has anyone experienced executing a Phantom job in Unidata 8.3 on a windows server. Then Sign-out of Server causing the Phantom Job to abort.------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

Many years ago we changed our web-based software to support prompts, menu items, and help to support multiple languages. We did that by using a number for the prompt like 2300 was "Customer Name". Depending on the language you would go to the matching language file to translate the 2300 number to "Nombre cliente" for Spanish and "Nom du client" in French for example. In the 18 years we have demoed this to United States-based companies nobody expressed any interest until last week. This  client would like to have code files like  Code A1 equals Apple or Pomme in Spanish Code Z1 equals Avacado or Avocat in Spanish Our Universe database has a file called Fruits in this example. So my questions for those who have done this are: Do you add a field for every language? Do you add a multivalue field for every language? Do you change the value in the file to a number and translate it to a language field? Do you add a file called Fruit_ES for Spanish? Depending on the method chosen, how does

Has anyone had success using the REGEX function?  I was trying to take advantage of it as it would be more compatible with the Javascript devs, but it always returns false.   Here's my example: CRT REGEX('33333','/^\\d{5}(?:-\\d{4})?$/')   This returns zero (0) for me.  Yet, it should match just fine.  :( This is on QM 4.0-7 ------------------------------Ben Cramer DSI Solutions LLCMansfield TX US------------------------------

Hi all I have some problems when connecting to servers using uopy, as the PATH variable is wrong. From the terminal console: >SH -c "echo $PATH" /usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/uv/bin >SH -c "uv -version" UniVerse 14.1.0 When using uopy: cmd = uopy.Command() suffix = " " cmd.command_text = 'SH -c "echo $PATH"' cmd.run() print(f'{cmd.command_text} = {cmd.response.removesuffix(suffix)}') cmd.command_text = 'SH -c "uv -version"' cmd.run() print(f'{cmd.command_text} = {cmd.response.removesuffix(suffix)}') The output is: SH -c "echo $PATH" = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin SH -c "uv -version" = SH: line 1: uv: command not found What's the issue with the uopy connection having an incomplete PATH value?

back with another question, hopefully this is the last one! when we downloaded d3 linux 10.3.4 there were also three patch files available, 17, 18, & 19 is this a situation where patch 19 contains all the updates from prior ones? or is each patch its own standalone fix? basically what i'm asking is, do we have to apply every patch individually & in order? or can we just apply patch 19 and ignore the prior two? thanks in advance!

i have another question, this time as per subject line i'm trying to set up the d3telnet turnkey stuff, on almalinux 9.4 where xinetd is not available. the admin.pdf talks about using xinetd and doesn't mention any other possibilities. i've searched the forum for 'xinetd' & 'turnkey' & found this post: D3 and mvBase which included a clue re. setting up a d323@.service so i tried to copy that manually then started it with systemctl. it failed though, and some digging revealed that the /usr/bin/d3net/d3_tel command doesn't accept either -w or -p arguments. i poked at it a bit and got the following: Usage: mve_tel [-debug4 | -debug6] [-h] [-n] [-N] [port] but i haven't been able to find where any of those options are defined, and at this point i'm not sure i'm even following the right lead. i've checked all the PDFs that came in the d3 10.3.4 download, and like i said i've searched on here, but i haven't managed to find what i'm looking for. is there a published guide somewhere t

In D3 PICK, how could I check (automated) to ensure that the scheduler is up and running?  Would a PHANTOM job that checks the status of "bgsched" by issuing "where" command? Is there a way from *INUX to have a cronjob check?  If so, how? Thanks In Advance!------------------------------Val YanezProgrammerRocket Forum Shared Account------------------------------

i'm working on a fresh install of almalinux 9.4 and d3 10.3.4, setting up a new box that we plan to migrate a much older d3 install onto within the next month or so. i don't have a ton of experience with alma (or centos7 which the old box is running, or any other rhel variants), so i'm kind of figuring my way through as i go. anyways the problem i've run into now is TLLicMgr is failing to start on its own, and i tracked it down to systemctl reporting that rslm has failed.  here's the error message i get when i do systemctl status rslm.service systemd[1]: Starting Rocket Software License Manager... TLLicMgr[1904]: Unable to create pipe</usr/lib/pick/.LS.NP3><17> TLLicMgr[1905]: Log file is not open TLLicMgr[1905]: Failed to Create File: Permission denied TLLicMgr[1905]: Failed to initialize. The logs may help identify the cause. systemd[1]: Started Rocket Software License Manager. systemd[1]: rslm.service: Main process exited, code=exited, status=1/FAILURE system

The Rocket® MV team is pleased to announce the release of Rocket UniVerse 14.1.1 on June 26th, 2024.  Rocket UniVerse 14.1.1 builds upon functionality implemented in version 11.4.1 and 12.2.1, making it the upgrade and modernization path for all customers on all prior versions. UniVerse 14 ensures business continuity and helps you manage your replication environment effectively with key HA/DR features. Replication is faster and more flexible with Field-Level Updates, since the entire record is no longer transmitted during updates, only the individual field that was modified is replicated - significantly improving performance! Facilitate Replication recovery with the uv_repadmin skip option which allows you to skip an incomplete transaction that has caused replication to stop processing. By using the skip option, administrators keep Replication processing and avoid log build-up and the eventual reset and refresh of Replication due to a stalled group. Facilitate Replication recovery wi

I'm doing a D3 v10.3.4 install and right off the bat I get: d3depends for RHEL/ CentOS 9 - x86_64 [$YUM0]                                                       0.0  B/s |   0  B     00:01Errors during downloading metadata for repository 'd3depends':  - Curl error (9): Access denied to remote resource for ftp://d3mv-repo:d3getRep0@ftp.rocketsoftware.com/RedHatEnterpriseServer/9.4/x86_64/repodata/repomd.xml [Server denied you to change to the given directory]Error: Failed to download metadata for repo 'd3depends': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried /etc/redhat-release contains: Red Hat Enterprise Linux release 9.4 (Plow) i manually installed the packages listed and the install works (well it did until it tried to create a disk partition, but that's a whole separate issue..) Someone should create the file for 9.4 so this doesn't catch anyone else. :) tnx. g. ------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific

Hi everyone,   I have a client with a successful D3 10.3 Linux installation who needs to meet auditing requirements by testing their Disaster Recovery (DR) procedure. The DR test is an annual event where they spin up a Linux server with a D3 instance and restore their database and applications.   Rocket's policy, as outlined in the Rocket MV End User Handbook (page 28), states that when running D3 in a High Availability/Disaster Recovery (HA/DR) setup, matching licenses with unique serial numbers and identical configurations are required. This includes scenarios like using U2 Replication or any secondary mechanisms for failover, all of which need additional licenses.   My client is resistant to replicating their D3 Production environment and is also hesitant about the alternative solution of maintaining a separate D3 machine with minimal configuration. They've pointed out that Oracle allows a separate server setup "for the duration of their DR testing" free of charge.   I'm reaching ou

I am running AIX and ksh.  At the AIX prompt, I have: AIX $ which matches the value for PS1    PS1='AIX $ ' when I issue the SH command from Universe,  I get to the host system.  I can issue AIX commands (without issue I think)However,  the Prompt is NOT displayed.  It is just blank The shells are linked together: $ ls -al | grep 326868 # -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  ksh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  psh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  rksh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  sh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  tsh Does some configuration option ne

Some things I'd like to see. Ability to manage (view/edit/git) MV source that exists in hashed files - VOC, Dicts, etc. (maybe like the SQLTools extension). Code folding support. Option to format document so auto code block folding works. eg PROGRAM/SUBROUTINE, labels and RETURNs are hard left, comments and everything else indented to a minimum of the default margin, etc. Fix use of code folding markers [this can be manually set but something is interfering]. Set default markers - eg !!#region...!!#endregion Addon for xterm.js (vscode shell and ssh emulator) to support [some] SB+ character mode customisations (term type 2). Open the extension repo to GitHub. ------------------------------Stuart BoydellTechnical SpecialistMeier Business Systems PTY LTDCarnegie Vic AU------------------------------