Rocket MultiValue

Hello all, I have a program that analyzes data from a 6.8M record file that does not have an index. Is there any way to report on the progress of the EXECUTE, as it may take 20mins or more to run? Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

I found some Linux text utilities that have a lot better interface than the normal Linux command line.  For a file manager I installed Midnight Commander (mc). It installs and runs great even on Centos 7.  I found another program for managing processes called bpytop (btop wasn't available for Centos 7): There's also a python Library, textualize that lets you develop text applications that look and work very similar to GUIs. The problem with all three of these is that they don't work with AccuTerm at all. I know that when the emulation was written not very many people were using Linux. Especially in the mvdb market. Now, it's the main OS for mvdb databases and so the Linux terminal is now the main standard. It's like the Wyse 50 back in the day. It seem crazy that AccuTerm doesn't work the same as all the other standard programs. Even the Microsoft  Windows Terminal and PowerShell commands work. I end up using cmd or the Linux terminal instead of AccuTerm but switching between applic

We are looking for help to automate our testing of Universe programs on Windows. What tools are available, what do you use to test your code? I'm aware of mvTest from Mr. Leach which looks promising.  Thanks in advance.------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

we've recently upgraded our D3 / Flashconnect from Centos7 & D3 10.1 to Almalinux 9.4 & D3 10.3.4. flashconnect has been version 3.9 throughout. everything seems to be working fine except for one thing, which worked on the old set-up and doesn't seem to be working on the new one. the issue is when the client follows a link that takes to a different cgi-bin script on our server. that scrip lets them upload files to the webserver, and contains a <form> link back to where they left off on flashconnect. this has worked perfectly for us for more years than i can remember, the return to flashconnect has always been seemless thanks to a single cookie with the w3profileid stored in the client browser. on the new system however, when they return to fccgi.exe instead of ending up where they should they're getting a logon screen that seems to be generated by wbp w3logonscreen and i have no idea why that's happening. i don't know what's calling that subroutine so i'm not sure how to

We are working on way to  be able to write data into universe files  directly from  python application running on the universe server that  pull data from cloud pub sub topics as we begin the process we have run into a snag, namely being unable to writer records  using u2py . here is little test program we wrote this work complete when running this inside the python shell , however when we try running it using  unix shell it it able to read the SPF.TEST Record but then does not write the data back into the same file as new record AK.TEST2. we only find out that it fail to write bit does not throw an error when we try to read and print the new record.  we are not sure what is missing . any help is appreciated.   import u2py def main(): print("Main start") lp = u2py.Command('LOGTO PROD').run() test = u2py.File("INF.FILES") t_read = test.read("SPW.TEST") print(f"main :",t_read) test.write = ("AK.TEST2",t_read) t_read2 = test.read("AK.TEST2") print(f"main :",t_read2) if __name__

I use COPYI  (system is 11.2 PICK flavour) to copy records between files in the same account.  Is there any way to copy records directly from files in another account without adding a Q or F VOC record to point to the file ? I'm imagining something like EVAL but for the VOC instead. Just trying to avoid the overheads when a transient connection is needed for a copy.------------------------------Greg ClitheroeRocket Forum Shared Account------------------------------

I don't recall encountering this before & I don't see it documented.   Within a process that has updated, but not committed, a record & its index, that same process encounters the public old index value, not that in the the cached not-yet-committed record. Some pseudo-code: 1. BEGIN TRANSACTION2.    create or update a record that has an indexed attribute that is changed3.    CALL  subroutine (or inline)       3.1 direct read of record updated in step 2.  - The new version is correctly read.       3.2 selectindex to find the rec from step 2.   - Performs as if the old value is still indexed.       3.3. EXECUTE 'SELECT ...'  functionally same as 3.2, using the index.  - Performs as if the old value is still indexed       3.4. EXECUTE 'SELECT ... NO.INDEX'   same syntax as 3.3 but NO.INDEX - Performs finding new value       3.5  return4.    COMMIT5.  END TRANSACTION (The above is all within one process, one basic program, inside one transaction.  Not something executed by competin

Hello all Is there a way to run a slow u2py operation in background? I ran some tests and the Universe Python seems to not support parallel execution due to GIL, so I discarded Python's native threads. With async routines the execution gets blocked on u2py calls: BASIC code: >CT UP ADORMIR      ADORMIR0001 SLEEP 500002 CRT 'me despierto'0003 RETURN0004> Python code: import asyncio import time from datetime import datetime import u2py MAX_TIME = 60*2 INTERVALO_LARGO = 30 INTERVALO_CORTO = 1 async def corutina_rapida():     i = 0     while i < MAX_TIME/INTERVALO_CORTO:         print(f'{i} - {datetime.now()} - HOLA')         await asyncio.sleep(INTERVALO_CORTO)         i += 1     return 'OK' async def corutina_dormilona_universe():     i = 0     c = u2py.Command('ADORMIR')     while i < MAX_TIME/INTERVALO_LARGO:         r = c.run()         print(f'{i} - {datetime.now()} - A DORMIR - {r}')         i += 1         await asyncio.sleep(0)     return 'OK' async def lanza_cor

My org uses a "zero trust" connectivity product called "Zscaler".  It's effectively a replacement for the VPN we used to use for remote users. Ever since Zscaler was implemented, there's been periodic connectivity issues with our D3 systems - they're disconnecting a client connection within milliseconds of accepting it.  Recently, this problem has become dramatically worse - to the point where it's affecting business operations.  People in billing aren't able to connect for hours at a time. It occurred to me today that it might be a licensing problem on the D3 side.  All the problematic connections are being made via MVSP on port 9000. Because of how Zscaler works, all the connections that travel over the Zscaler network are going to hit our servers from the same IP address.  I'm wondering if D3 isn't seeing that and will start denying connections from the same IP address after the connections reach a certain threshold.  Is this possible? Right now the problem has descended to finger-

Our Universe application consists of 8 accounts for 8 branches. In all accounts, there is a file for the items. The item file is identical for the master data in all accounts, only the transaction data differs. When writing, changes to the file, master data are distributed across all accounts to keep them consistent. Although this approach is certainly not optimal, we do not want to change it because the programming is not easy to modify. I conducted a test, and used: SET.INDEX ITEM TO H:\\ALPHA\\INDEXES\\I_ITEM to set the target path for the index of all 8 item files to the same destination. During a bulk import into the item file, where all 8 files are updated, switching to a single index file, approximately double the speed is achieved. My question now is: Is there anything that speaks against using a single index file for multiple data files, as long as all indexed fields are identical for all data files? greetings Thomas ------------------------------Thomas LudwigSystem Builder D

The Rocket MultiValue team is happy to share that we're released version 2.1.1 of the Rocket® MultiValue Integration Server (MVIS). This release of the product provides additional support of MVIS 2.1, which we released in June 2024. MVIS 2.1.1 includes the following benefits: We've enhanced MVIS Admin API Swagger documentation  to ensure that the content and formatting of the  Swagger documentation is accurate and compliant with the OpenAPI 3.0 specification. We've deprecated Rocket APIs that don't adhere to the OpenAPI 3.0 specification . We've removed obfuscation of MVIS code  so you can easily diagnose runtime issues utilizing third-party tracing tools, such as Dynatrace, without being encumbered by obfuscated class and method names.  This should also eliminate your frustration with obfuscated names of classes and methods in the Admin API Swagger documentation.  Please note, we've kept MVIS's password encryption code to hinder casual observation if decompiled.  We've adjusted t

The Rocket MultiValue team is happy to share that we're released version 2.1.1 of the Rocket® MultiValue Integration Server (MVIS). This release of the product provides additional support of MVIS 2.1, which we released in June 2024. MVIS 2.1.1 includes the following benefits: We've enhanced MVIS Admin API Swagger documentation  to ensure that the content and formatting of the  Swagger documentation is accurate and compliant with the OpenAPI 3.0 specification. We've deprecated Rocket APIs that don't adhere to the OpenAPI 3.0 specification . We've removed obfuscation of MVIS code  so you can easily diagnose runtime issues utilizing third-party tracing tools, such as Dynatrace, without being encumbered by obfuscated class and method names.  This should also eliminate your frustration with obfuscated names of classes and methods in the Admin API Swagger documentation.  Please note, we've kept MVIS's password encryption code to hinder casual observation if decompiled.  We've adjusted t

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

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

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