Rocket MultiValue

We are trying to add a subroutine call from an existing trigger.  The subroutines are definitely being called and acting appropriately, except when they attempt to write to a log file.Using "ED" to make a simple change in order to force the trigger, we are getting this error:Program "ED":  pc = 748C, Program "XXX": LINE 409, FATAL:  The locks necessary for database operations at the current isolation level (0) are not held by this process.The subroutine is trying to write to a type 19 log file which works fine from other programs. Commenting out the log file write avoids the error. Because of this error, the write to the CUST file (which is the one with the trigger) also fails.I assume this is something unique to the trigger function.  The trigger subroutine is cataloged globally as expected, so I am wondering if that is making file access in the account unavailable some how?This is running in UniVerse 11.3.1Any ideas would be gratefully appreciated.Nelson

The installation of MVIS on Linux requires Python3 (and, what is more, a more recent version of Python3 than is included with UV).My question is this: does MVIS require Python for anything other than the installation?

*** Remote File System Error ***Write/Delete (12396*17) Remote Operation FailedO=Logoff / Q=Quit / R=Retry ? Qwhen sometimes i try to write to a remote account i get this message... why ? there is no lock in the source at lest as far i know------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

Running guide in a directory with this:# nohup guide -na -ns -Z8 2>&1​ &...and it's terminating like this:[1]+ Segmentation fault (core dumped) nohup guide -na -ns -Z8 . 2>&1If I select all of the files and run guide individually on them, I don't see any failures.  Is there any way to track down which file is causing the segfault?------------------------------Kevin KingPresidentPrecision Solutions, Inc.Longmont CO US------------------------------

Hy.. i'm trying to create a script to when the user close the last session of accuterm he executes the logout from windows server ...so far i have thisSub CustomExit()Dim n As IntegerDim s As Sessionn=0For Each s In Sessionsn=n+Abs(s.Connected)Next'If n > 0 Then Beep Else AccuTerm.TerminateCmd = "c:\\windows\\notepad.exe"MsgBox "Numero de sessoes " & nIf n < 0 Then Beep Else AccuTerm.TerminateEnd SubSub CustomClose()If ActiveSession.Connected Then Beep Else ActiveSession.CloseEnd Subi'm using Notepad just for testesin the shortcute of accuterm i put "C:\\Program Files (x86)\\Atwin71\\atwin71.exe" Finaliza1.atsc------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

I am no longer able to compile BASIC programs using the Connection.The program I am editing and attempting to compile DOES BELONG TO THE ACCOUNT I AM CONNECTED to, but this error has began recently. I'm not aware of any changes (perhaps VS Code extension updated?)Any steps I can take to troubleshoot and/or workaround this issue? NOTE: this is only a problem with v1.8.0  I reverted back to 1.7.0 and this issue has gone.

I have never had to do any administration and now It has come to my way. Most of my experience is on Unidata as a programmer, with no admin responsibilities. Now I need to do some admin and It starts with creating an account.  How do you do this in Universe on RedHat?------------------------------Gary RhodesUniverse DeveloperNational Auto Parts Warehouse LLCHialeah FL US------------------------------

Just curious, before I build it, if anyone has a script or program that initiates a screen capture when starting an AccuTerm session? What I'm proposing is that a capture session be started using the append method with the file name being the date/time and the user name or other information that would make the session capture unique. This would obviate the need for users to remember to initiate a capture session. Thanks, in advance!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

Are there any recorded d3 python webinars available?   I have searched for it and can't find any.  Not sure if i am looking in the right areas.Thanks,Bill

Can I (and How/where) download SystemBuilder tool to play with my Trial UniData and/or UniVerse Personal Server?My customer don't have it and I would like to prepare a demo.Thank you,.------------------------------Pedro SantosSANTOS DEVMISSION VIEJO CA US------------------------------

Inside a proc you can do T I27,"`:" to set the column width of the wintegrate emulator to 80 characters. Is there a listing of what escape sequences exist to manipulate the wintegrate emulator?The end goal is to change the wintegrate terminal type programmatically.Thanks in advance!------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

Hy i have QS pointer in the account LIST-ITEM MD WEB 001 QS 002 003 unix:/home/saci/tecwebcg i did the account-save ...i open the backup file and saw the data over there but when i do  :account-restore betotesteaccount name on tape:BETOTESTE1 > BETOTESTE 52041742,471 > BETOTESTE > WEB 0,71 > BETOTESTE > WEB > WEB 0,7[235] attempt to write into update protected file!:update-md betoteste to betoteste :lf web[201] 'unix:/home/saci/tecwebcg,,' is not a file name:ed md webtop.p001 QS002003 unix:/home/saci/tecwebcgeoi 003.ex[220] 'web' exited:list web[401] no items present.:linux side:[root@d3erp tecwebcg]# pwd/home/saci/tecwebcg[root@d3erp tecwebcg]# ls -lahtotal 8,0Kdrwxrwxrwx 2 root root 4,0K Nov 24 13:35 .drwxrwxrwx 9 root root 4,0K Set 20 16:54 ..[root@d3erp tecwebcg]#i'm using root user, the linux file has permission 777Boot Monitor. . . . . . . 10.2.0.M18; 20 Sep 2022Boot ABS. . . . . . . . . 10.2.0.A0; 08 Mar 2016Boot ABS Data File. . . . 10.2.0.A0; 08 Mar 2016Syst

Hy i'm helping a friend who has a old d3 9 out of mantince, to improved his system... he is already in virtual machine and his new hardware is a cpu with 32 cores with 32 Gb ram what tweaks i can make to his pick0 file to improve the system ? his configuration is like this: core 3500000 10basic 8192nice 0that box is only for d3, there is no mysql,no orders services runninghis database is arround 98 GB------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

Accuterm Graphical screen creation and programming....I can see that each individual field can be flagged as required, but that seems to be only if the user goes to that field or the program focuses on it.If I have that correct, is there a way to set required on a form level? As in if I go to save a record and I did not go to a field that is required, it will give an error and force the field? Obviously I could make an internal list of all these and loop through them upon save but - since there is a required check box I thought to check here before coding that.Thanks for input. And for those of you out there who are going to say 'check the manual'....please don't.Kathleen------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Hoping this is the correct forum for a UOPY/U2 question.Using U2 11.3.4 and UOPY I'm having an issue with UOPY sending an SQL select statement that works @ TCLprompt.Retrieve command: This works from Python using BOTH UOPY and TCL prompt:          SELECT TABLE1 WITH ORDER.NO = 177This only returns the index value, but it worksSQL command:This works at TCL prompt, but fails going thru Python/UOPY:      SELECT CITY FROM TABLE1 WHERE ORDER.NO = 177;I have tried with "177"    double quotes or single quotes  '177'.  Also with/out  ; at the endI have tried sending the command as both uppercase and lowercase.What am I missing?Thanks for your time. ​------------------------------Dave EvansProgrammerCombined Transport Inccentral point OR US------------------------------

Hi All,Is there a way from ECL to generate a list of all indexes on all files? (And the index attributes)I know I can do a LIST.INDEX FN at the ECL prompt file by file, and I could script running through all VOC records that are files, but I cant seem to pipe and append this ouput to a text file. Rick

We have data that is stored in an attribute with multiple values and up to two sub-values per value. Using an I-type dictionary, I have found that I can only extract specific sub-values if any sub-value marks are converted to another character first. For instance, the following will not work for attribute 2 (formula) in the dictionary to retrieve the first sub-value: FIELDS( @RECORD<77>, @SM, 1, 1 ) ​​​Instead, we have resorted to using the following: CONVERT( @SM, "`", @RECORD<77> ); FIELDS( @1, "`", 1, 1 ) Just curious if this is an expected behavior or if anyone has found a more elegant solution. Thanks!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

We've just posted a video on our Rocket YouTube channel that give you a guided tour on installing mvBase v3.3.2 and applying one-off patches. Content was provided by our mvBase Support specialist, Claude Marinelli. The recording was narrated by Mark Puchalski from our Support department.This is a really good one to watch, especially if you're an mvBase novice like me. I intend to use this content myself to broaden my support expertise.Click here to access the video.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

Hi Guys, we would like to go Paperless  in our Warehouse for our Pick & Pack operations. We currently us SB Client on Windows Laptop and Desktops as the interface to our Business system (IBS from K3), The Business app makes extensive use of F2 and F3 keys and other keyboard input and as such does not lend itself to Touchscreen only use, we currently have any plans to go over to Barcoding at the moment (Thats a long story i shall not bore you with just now) We have as an experiment in our test system, be investigating using small 10" Ruggedised Windows Laptops, for both mobile and for use on Fork Lift trucks. However we are getting significant dropouts from the SB Client Sessions, as we move around the warehouse, We use Meraki for our WIFI and the signal strength from the AP's looks good and we can browse the network and access MS TEAMS, without issue. So this suggests to me that the Meraki's can't currently maintain the transition from one AP to another for the SB Client user sessi

Ever had trouble installing D3 Linux using D3_setup? We've just posted a series of videos on our Rocket YouTube channel that give you a guided tour on making D3 Linux installation MUCH easier by bypassing the use of D3_setup's Configuration menu and loading D3 dependencies manually. This is based on some Knowledge Base articles previously posted to the Rocket Community Portal.There are six videos in the series, the first one being the longest at just over eight minutes in length, the rest being much shorter. They cover the D3 Linux pick0 file and how those elements relate to the items on the D3_setup config menu. They also cover using fdisk, parted and other Linux utilities to create raw disk partitions and logical volumes for use with D3, as well as using the yum utility to load D3's dependent packages.Click here to access the playlist.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

Hi allHas 10.4 (or lower)  got the ability (function) to create (and read) JSON ? (I know that OpenInsight has) If not, is anyone prepared to share their version of such a function that they may have created?I have written something to extract System Builder screens to convert them (into JSON) to HTML pages (using Python) but it may be interesting how others have approached this.Thanks------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

Hello all! We are running UniVerse 11.3.4 on AIX 7.2.  We just started this combination 2 months ago, though we've been running on UniVerse/AIX for many years.  Yesterday we received a UV error during one of our users' sessions:        Integer value over the MAXINT (2147483647). Zero used.We've never encountered that error before. I've run searches through the $uvhome directory at the unix level, and the only references I can find to MAXINT are in python.tar.  We're not running Python code and have not even licensed it.We're looking at the issue, and it's most likely a data error, but is has raised my curiosity.  Where is MAXINT set?  Is it something we can control, or is it hard-coded into UniVerse somewhere?  Has anyone ever had a need to modify the value - up or down?------------------------------Brian Paige------------------------------

I have setup a subroutine endpoint to my database but on trying to perform a POST action in an intranet webpage it is getting a CORS error and going through a preflight.  Is there a way to configure the server to allow cross origin?nb. MVIS and apache are running on the same machine

We are setting up a connection on a new server to connect to our Prelude (UNIDATA) database. I can test the ODBC connection and get success. When we try to use the connection, we get the error below.Error code: 9603Details: Error [0000] [Rocket U2] [U2ODBC] [0302809] Unable to allocate sufficient memory!Error [0000] {Rocket U2] {u2ODBC] [0400182] Connection not open.Activity ID: 47fd30ba-cfa2-4f5b-806c-5f5eb28dc60f.ODBC installed on Windows Server 2022U2 64-bit ODBC Driver  7.241.02.9003when I test the connection to the UNIDATA DB my connection passes. When the connection is used to pull data we get the error.------------------------------Nathan SchultzCertified Power IncFridley MN US------------------------------

After many years of not using wIntegrate, I started again.I'd swear I had ^C  triggering a <break> on the UV server SSH session, but now it isn't.Probably something stupid in the settings, or between the ears.  I can't find it.wIntegrate v6.4.4vt00u2 ssh   port 22Setup > Keyboard >Key Definition Listing> Break Key: <<Ctrl>+CNo special key mapping(looks like what I used to use with Dynamic connect, except ssh)In Putty ssh ^C works.Any advice?  TIAChuck Stevenson------------------------------Chuck StevensonDBA / SW DeveloperPomeroyUS------------------------------