Rocket MultiValue

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

if in one sentence (or maybe 2/3) you had to answer this question, how would you answer it?why should I choose universe over unidata or unidata over universe?would love to hear answers from rocketeers ..........dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Hello,Any update on the release of Accuterm GUI for the web?    Thanks------------------------------Peter GonzalezProgrammer/Systems Analyst/EDI DeveloperSelf RegisteredSt. Louis MO US------------------------------

Hi,   I have two MV basic source tables in an account at the Universe server, let's say, account ACC_1 and source files BP_A and BP_B. I created a GitHub repository for each of them, and cloned them at my local machine.  I could successfully compile and catalog from MVVS BP_A sources, but then, when I opened BP_B folder in MVVS, I can't no longer compile from any of the tables. It keeps giving me the same error:  Compiling: Source = BP_B/SOURCE_FILE_X -----> Compilation ignored.The account to which the file belongs does not match the account connected to the server  When looking at the log, I can see that it is considering BP_B as the account instead of ACC_1.   How can I configure MVVS to be able to compile and catalog from any of the source files?  Should I have one local folder for the account, with subfolders for each source file?  Where does MVVS look for the account when compiling?  Any help appreciated  Regards  Enri

How can I access the data that is returned when using the LISTUSER command? What file and account is it being stored in?------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

How can I access the data that is returned when using the LISTUSER command? What file and account is it being stored in?------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

I hope this is the right place to post this ......... if not sorry anywayis there a reason uniobjects and unirpc cannot be turned on in the trail version of universe?  I understand this is to test drive the system and what not, as I am thinking of trying to sell universe with several applications (that I am developing)  but it hard to do when I cannot develop it fully.I have a c# application (developing) that can use couchbase , ms sql, mysql and I would like to add universe as the back end database (there are non production version  and in the case of mysql free versions I can use to demo the application) and then based on which the want or their price point, (how powerful a server they are willing to purchase , how many users etc .....I can recommend a database for them to use.i would LOVE to add pick as a database option (universe and jBase) but I need to be able to connect to a system to test (and develop) before I can think about offering it.  I did look into purchasing a universe

I have the PE versions of both (unidata and universe) and my VM is currently running universe, do I (or should I) spin up a new rocky linux VM to install unidata on or can I install unidata on the machine currently running universe?I guess spinning up a new VM is not a big deal but I was just curious if they both could run on the same system any advice or suggestions  appriciateddougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------