Rocket MultiValue

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

Has anyone got a JDBC connection to UniData 8.x from Tableau working? The JDBC connection to UniData is set up and working, but Tableau can't see it. The 64-bit ODBC driver doesn't seem to communicate well with Tableau at all.  I did get somewhere with the 32-bit ODBC connection, but it's not performant. Things worked much better when accessing it through an intermediary (Microsoft Access, just to mess around with it), so perhaps Tableau can't handle the quirks of the driver (v7.241).All my experimentation has been done with Tableau desktop edition, but I do have other editions available.  I also have inquired with Tableau, but it's slow going on that front. Any help is appreciated.------------------------------Elaine LitchfieldOwnerElaine Litchfield ConsultingSan Diego CA US------------------------------

EXECUTE has an optional CAPTURING clause. I am curious about the frequency of its usage. I can think of a few workload scenarios.1. CAPTURING: Process the resulting output for some information. 2. CAPTURING: Suppress the output so it does not disrupt a terminal screen.3. CAPTURING: Phantom processes where repeated EXECUTE fill a disk with large &PH& file records.4. No CAPTURING: Phantom process where the output could prove useful if something goes awry. Expected possible failures would most likely be caught in the first scenario and logged.I assume that most instances of EXECUTE use CAPTURING for one of the cited examples. Would anyone like to share their thoughts on the fraction of EXECUTE with or without CAPTURING to the whole population of EXECUTE, or other workloads for using or ignoring the CAPTURING clause?The PHANTOM command now supports a BRIEF keyword to suppress output (except for "Messages" according to the documentation). I assume "Messages" are the kinds of errors

i am looking at a possible job that uses jBase (my favorite of all the pick versions) anyway the last time I used jBase jim idle was the owner of jBase.I LOVED his story of how him and the "fat bloke" wrote jBase ........anyway is there a trial version I can download to start refreshing myself before the interview?thanksdougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

I just downloaded ud8.2.3 (trail version) installed it and I am getting the following error:Couldn't start SMM. Please check /usr/ud82/bin/smm.errlogUniData R8.2 NOT started.Starting UniData...Tue Nov 1 14:38:06 2022; UniData license expired.looking at the error log I see:Tue Nov 1 14:38:06 2022; UniData license expired.Tue Nov 1 14:38:06 2022; Exit: SMM error while checking license.I download this from a link in an email I was sent (your unidata for linux download) with a download now button .........whats up with that?dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

I have used AccuTerm in limited fashion, (text boxes and lists), in my character based systems.  I would like under the GUI AccuTerm to make the conversion behave as now.  Example from events management:  Customer demographics enter customer number or keyword which brings up a list of customers.  I can see this clearly in the DEMO examples.  Change prompt for customer demographics I invite an <O>ptions and display a little window offering options like <R>entals.  If selected it lists the customers existing rentals.  Selecting a rental the calls the rental summary screen with options.  The <B>uildings option lists buildings on the rental.  Selection of a building shows the details of the building portion of the rental, offers options, one is <I>tems which allows entry of table, chairs, etc.  I can see the in CM the forms DETAIL, LOGIN, and MAIN all in the same program.  The event management would require 7 fo