Rocket MultiValue

All, We have a program that is doing a range of calculations that result in large integers. In some cases we are seeing overflow when negative numbers are being converted to their 2 complement e.g. when assigning it to a value in an array.  This is effectively what is happening (not the actual code and that's deep inside a complex routine). A = -1528596274 B<C,D> += A B<C,D> shows as 2766371022 If we take the assignment out of that program and put just the code into a standalone routine with the same numbers it works without modifying the number. Other calculations using that number also work. If we pass the value and array into a noddy three line subroutine to do the assignment, the value changes. Any attempt to manipulate the number e.g. ABS or even testing it (if A < 0) also coerces it to the 2s complement.  If we turn it into a string, the same. E = A : '' E is 2766... If we use string maths, the same. Other routines in the system are handling much larger numbers wit

Is there anyway we can increase the threshold of READU locks. Currently I am getting below error. READU threshold reached, lock on xxx denied!Program "ED": pc = 69BA, READU threshold reached, lock on "xxxxx" denied!------------------------------Shubham NigamRocket Forum Shared Account------------------------------

Hi guys,We have a situation where we want to have multiple Unidata accounts on a single Windows server but the accounts may related to customer sites in different time zones.The front end will be a browser based web application.If we use DATE() and TIME() that will pick up the date and time from the server which may not match the date/time relating to the location of the customer's site.We have thought about 1. Calling an API to get the site "actual" time but that must rely on both an internet connection and the API always being available. 2. Maintaining a "time offset" setting but that's difficult with daylight saving as that can kick in on different dates each year and sometimes isn't required at all. 3. User the date/time from the users local PC but what if the user is travelling or simply has their date/time set incorrectly.Has anyone come up with a good solution to this?Many thanksBarry GreenCBS SoftwareM: 0414 380192 T:08 82601256www.cbssoftware.com.auwww.cbssoftware.com.a

We are getting this error when trying to connect to Unidata via a web service: [U2][UCINET-UO][ErrorCode=39129] How do I troubleshoot this error, any leads? André Guindon

I finished my contract last week, so back on the market. I landed an interview with a "recognizable company" and went straight to the final round. During the interview one of the panel asked me, "How do you read a file without a select list?" I paused for a moment wondering why anyone would need to do that?  I thought for a moment and came to the conclusion, it may be possible, but I cannot think of how it could be done. I responded to him, "In the twenty years I've worked in multivalue, I have never seen any code that would do that. But I don't ever recall ever having the need". Is it possible?  Does anyone have an example?Added:  This person meant without using SELECT anywhere. At TCL or internally in a program. He claims he has a way, I doubt him.  ------------------------------Scott JohnstonSr Software Engineer, Architect & DeveloperDover DE US------------------------------

Using U2.Data.Clent 3.1.1.1003, I'm receiving this error after the web service has sat for some time.  The Session.Status = 0 and Session.IsActive = true.  I there a way of knowing when the underlying connection has stopped?   U2.Data.Client.UO.UniSubroutineException: ' [U2][UCINET-UO]WIN32 API Error:10053An established connection was aborted by the software in your host machine.[Rocket U2][UCINET - UNIRPC][ErrorCode=81009] The RPC failed

just wondering is there is any advantage one way or the other between using    VAL=EXTRACT(RECORD,1,1,0) vs.   VAL=RECORD<1,1> ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Hi, i would like to query a bunch of tables to see if the indexes have been built I tried LIST-INDEX <FILENAME>.  But it seems to require a <return> if the page is too long. Was also looking at guide_ndx, but i can't see a BUILT column like in LIST-INDEX.   guide_ndx would be ideal because i can call it from a shell script. ------------------------------Jeremy SchmidtprogrammerRocket Forum Shared Account------------------------------

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!