Rocket® U2 | UniVerse & UniData®

Gedday everyone, We have MVIS set up with subroutine and data resource end points for various data retrieval. There was a recent request from the business to be able to supply a list of keys in a request to retrieve one or two specified fields in the response. The number of keys was in the order of 20k-40k. So I did a test and squirted a request (using curl) to our dev MVIS containing of 10k keys. It timed out. I then tried the same request with 5k keys and after a few seconds a valid response was received. Here is the url used. http://mvis.mydomain.com:7171/TEST/DATARESOURCE?select=key=%22KEY1%22%22KEY2%22%22KEYn%22&fields=FIELD1%2Cxref%2CFIELD2 Next we decided to just use the built in limiter (max) via a similar request and found that we could obtain the desired volume in the response. http://mvis.mydomain.com:7171/TEST/DATARESOURCE?max=20000&fields=FIELD1%2Cxref%2CFIELD2 Is anyone using (or has played with) large queries in MVIS. Is there a limit in MVIS or a setting (MVIS/U

We have a strange situation. One of our applications written in vb.net has it's data etc hosted in Azure.  When running the application from the office over a site to site vpn to the Azure endpoint everything works perfectly well eg a typical report runs in about 5 seconds.  However, when the users connect over the Azure software vpn on their home machines (all users regardless of local internet performance) the whole application slows down dramatically eg 90 seconds plus for the same report.  The IT Infrastructure team have exhausted their investigations and can find not reason why. Running commands at TCL using a Telnet application all seems OK but when running the app (uses port 31438 for RPC) is when the speed issue is experienced. Has anyone seen this or have any suggestions on where we might need to look?

Hi, We're working on an archive process and we set it up to run as a phantom. When run as a phantom, the process runs over twice as long as it does on a telnet session. Does anyone know a why to bump up the priority of a phantom job on a Windows server?  Thanks Curt------------------------------CURT VALENTINESOFTWARE ENGINEER IIIPaychex------------------------------

There are numerous approaches to turning output pagination OFF from within BASIC code (and I'm not really sure which ones work and which are just hang-overs from other MVDB implementations). What I want to ensure is that output pagination is turned back ON from within BASIC. Does anyone know if a method for achieving this? Thanks ------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

I'm working on something to make deployments to new environments a little easier, and one thing that would be super helpful is the ability to create or update VOC items from a script of some kind (e.g. a PAragraph).  I could of course do it from a basic program, but then the person doing the process would have to know how to save the program to the appropriate place, compile and catalog, and then run the program.  The idea is to give them a script and after saving it as a PA in the VOC, have them run it and it will take care of all the heavy lifting after that.  Most things I can do (creating directories, compiling programs, etc) but can't find a command that will allow you to update a file directly from TCL.  Anyone got any suggestions on a command?  I've got to be missing something obvious that will do this. PA UPDATE VOC INVOICE.EXTRACTS SET INV.PATH='/path/to/invoices' UPDATE VOC INVOICE.EXTRACTS SET INV.PATH2='/path/to/invoices2' UPDATE VOC INVOICE.EXTRACT

Hi, I have the following problem: I have been using the Rocket U2 product (Universe|Unidata) as ODBC configured on a SQL Server 2014 Via Linked Server Tecnology and everything It works correctly, I connect the U2 against my Universe database and this with the ODBC of Universe for Windows Server, finally I use the ODBC to create the Linked Server in SQL SERVER 2014. The problems began when upgrading SQL Server to SQL Server 2019, from that moment with the same configuration the linked server has stopped working. Have you reported any ODBC bug of Universe in SQL Server 2019? Does anyone have a similar scenario? I have tried several configurations both in U2 (via Uci Editor) and in the SQL Server and nothing has worked (The linked Server is infinitely loading and dont retrieve data from U2 database).            

Thanks Brian, and yeah, I've used the SQL functions over ODBC before, butit's kind of fiddly to setup. The intent here is to provide something tobootstrap an inexperienced user in installing some new code and artifactsthat go along with the code. You can type "SQL UPDATE ..." but only afterhaving setup the account for SQL (I think?). I get "No privilege on fileVOC!" as an error at least.I was trying to get away from having a basic program, because it'sobviously challenging to a non programmer to understand all the possibleways compiling and cataloging a program can fail. But installing a utilitylike UPDATE.RECORD once and cataloging globally might be the bestcompromise option. I can write my own, with a pretty rigid syntax like"UPDATE.RECORD VOC TEST SET 3=nk jhkjewqh ekjhqwkje jk" since it's notdesigned to be used interactively, just used for updating parameters wheninstalling some new code.Really appreciate the suggestions!On Mon, Feb 27, 2023 at 11:49 PM Brian Speirs via Rocket

I have been converting code from R83 to Prime Information, Advance Pick to Unidata, Sequoia Pick to Unidata, D3 to Universe, and even Unidata to Universe, I have seen some really awful code and very morbid. Of course, you are thinking some of the latest Basic commands that I use daily in Universe did not exist in R83 so those programmers did the best they could. While I do not disagree, I am looking at code from customers in 2023 that should have been updated sometime in the last 20 years or at least in the last 10 years. I have detailed below my comments with what I found and what I think it should be. I will ignore for the time being GOTO, GOSUB, and ON RESPONSE, for example. I would love to see what you have found as well because it just makes me LOL when I see it. * Using COUNT instead of DCOUNT MY.ARRAY = 5:@FM:7:@FM:8 MAX.FM = COUNT(MY.ARRAY,@FM)+ 1 * Should be MAX.FM = DCOUNT(MY.ARRAY,@FM) * Not knowing about WHILE in a LOOP statement EXECUTE 'SELECT VOC'

while we suspect a 3rd party program might be causing the issue or at least helping it along , what we are trying to do is isolate or prove it. any suggestion or ideas are welcome as we are running out system info udt - 8.1.2 redhat - 7.9 when unidata locks up  showud shows all the processes running yet any ECL sessions are locked up trying to login via udt hangs, we turned on error logging but the log file only shows the start of unidata and nothing else udtmon - does show a little disk activity we did straces on the udt processes including trying to open a udt session  attached is an strace of a udt session and an ipcs output when the system is hung any ideas or suggestions are welcome as well have been stumped, we are talking to the 3rd vendor as well and like I said we are not positive that the issue but we have seen their process using a lot of memory and cpu stopping unidata and starting it back up and everything works fine, for a while, there is no pattern to when it lock

Just noticed that Unidata had a directory called minidump When i looked at files in the folder the files stated "The thread tried to read from or write to a virtual address for which it does not have the appropriate access" What does this mean, should I be concerned, how can I tell what is causing these files to be created------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

Hi Folks, we recently upgraded to 82 Unidata in a testing environment, and are getting the following in SMM logs; In UT.OBJ/_S.READLIST at line 90 insufficient memory, requested size = 37567064. Thu Feb 16 14:28:02; errno=0: ICSubCall returned from basic, ReturnCode=-1. I do not have access to the source code for S.READLIST but it is dealing with very large save lists. Any thoughts on what we might have wrong? Rick Brown------------------------------Rick BrownSysadminRocket Forum Shared Account------------------------------

Anyone using UniVerse and EDA with "virtual" dictionaries?  I have a user running UniVerse 11 and using EDA. EDA is working fine on true attribute dictionaries, but now he's trying to add an I-type like this:      DIV0001 I0002 "10"00030004 DIV0005 10R  Just a hard coded value "10" - but in the SQL Table the column is populating with NULL. ------------------------------Mark EastwoodDeveloperAFS Technologies IncPhoenix AZ US------------------------------

Hi everybody, I'm searching a method to perform communication between 2 running phantoms.  sample : phantomA is a helper which load a lot of info in memory and is capable of complex computing. phantomB manage info and need a computing to be done by phantomA  the method QueueViaDisk :  pantomA read disk on a loop and write the result on disk phantomB write the request on disk, wait, and retrieve the result from disk  a method QueueVia Memory ? QueueVia Socket ? QueueVIA ..... ??  is it possible ? with uv ? with python ? via os ?  Any idea will be welcome. manu 

I am launching a process from a UniVerse Basic program using:       PH.CMD='PHANTOM SQUAWK MY.PROGRAM'      EXECUTE PH.CMD CAPTURING PH.VALS It returns the &PH& log filename and the PID as expected. However, when I de-cataloged the program, it still came back with both values. The only way I realized it was failing was by either running "ps -aef" from Unix or looking in the &PH& file: 0001 Verb "MY.PROGRAM" is not in your VOC. Is there a BASIC program command way to know if MY.PROGRAM actually did launch?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Greetings, all!We are running UniVerse 11.3.4 on AIX 7.2.  We received the following error in the UniVerse errlog file:       Fri Feb 17 15:24:34 -144 root /usr/ibm/uv/bin Failure to login as remote user. There are only 3 of us that know the root password, but none of us were logged in.  Additionally, direct logins using the root user are not allowed by our system - neither through ssh nor through the software application we use (which comes in through uvapi and uvcs).  UV itself does run as root, though.   How can it say that the login failed, when there's already a port number assigned? The uv and unix logs have been checked, and so far there is no evidence of any connection made by the root user at that time. What does the error actually mean?  Any info would help us figure out where to look to determine what happened. Thanks!Brian ------------------------------Brian Paige------------------------------

Hello there, I am writing a data to xml in  Universe Basic. Its seem some invalid ASCII characters were included in the data which causing an error in xml. Could anybody advise what is the command to exclude these bad characters or convert to null in Universe Basic before got written to xml please. Your help would be appreciated. Thanks. ------------------------------Yossy TanSenior Universe DeveloperA2B AustraliaBrisbane QLD AU------------------------------

https://en.wikipedia.org/wiki/Garbage_collection_(computer_science) There really is very little to nothing in this article about how Pick BASIC does Garbage Collection. I feel like there is a disservice in not addressing multi-user environments and how they have special garbage collection requirements.------------------------------Will JohnsonSystems AnalystRocket Forum Shared Account------------------------------

Hi All,We are using Universe 11.3 on Windows.I needed to round a 5DP number up to the Next Whole number, so the result would be ; I could not find a suitable command equivalent to Excel  ROUNDUP, as shown above, so I've manually programmed the required calcs.There does not seem to a be suitable Flag for ICONV / OCONV and INT only grabs the whole numberIs anyone aware of a Function that does what I needed ??Just in case I've missed a  Function, i went through the  UV Basic Command 11,34 pdf guide and could not find anything.However, i spotted in UV Basic Command 12.11 there are 2 x new commands ROUND and also TRUNCWhilst these syntactically don't do what it need, it may help others looking for similar functionality.so as I'd found these new Functions available in V12, it got me thinking, can these new commands be retro applied to earlier versions of UV, obviously I can't just upgrade Universe to access these commands.Secondly as the new to me ROUND function still does no

One of our applications received this error message and aborted. The remote data was never offline. UniData Release 8.2  Build: (1000) (c) Copyright Rocket Software, Inc. 1985-2020. All rights reserved.  Current UniData home is /usr/ud/. Current working directory is /dock/app1/PLT3.   :perform_remexec dp:KMC 870 lblack [1/1] SELECT UNIT.ID SELECT UNIT.ID  1311 records selected to list 0.  In /usr/ud/sys/CTLG/p/perform_remexec at line 225, connect() error(11): Resource temporarily unavailable In /usr/ud/sys/CTLG/p/perform_remexec at line 225, Connect() error (11): Resource temporarily unavailable in UDT_connect. In /usr/ud/sys/CTLG/p/perform_remexec at line 225 Connect dp:/dp/apps/KMC:1155 failed, status 11 In /usr/ud/sys/CTLG/p/perform_remexec at line 225 efs_connect() failed, fname (SAVEDLISTS)In /usr/ud/sys/CTLG/p/perform_remexec at line 228, connect() error(11): Resource temporarily unavailable In /usr/ud/sys/CTLG/p/perform_remexec at line 228, Connect() error (11): Resource tempora

Being used to the Unidata format, when running this command in Universe the file the lock is in does not display. We have common keys across many files so the format of this tool is very unhelpful to us! Does anyone have the syntax, alternate command, or custom ditty that shows all the pertinent info for a lock at one time? IE login, date/time, file, ID, process ID, User ID?Thanks for the help!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

8.2.4 i believe, and any (rough) eta on when the next version will be available? thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Many years ago when we went to the web we stopped using paragraphs. We have not used a PROC since the early 2000s with any of our clients. So when we moved to the web using UniObjects for Java you could only call subroutines through our API. This meant we had no use for any of the 1000-plus paragraphs that we had written over the years. If we need to select we use EXECUTE to handle getting the data.I was wondering if what I am describing is true for other Unidata, Universe, and D3 customers that have gone through a migration to the web. I have a would-be client that says you can keep all of them. I just don't want to use and EXECUTE to call the paragraph and DATA the need inputs. Am I wrong here?------------------------------Doug AverchOwnerU2logic------------------------------

I accidentally created an invalid record(s) in a uv 11.2.5 file that I can't get rid of. The file is CONTROL and the record "@ID" contains multiple CHAR(9)'s. Because CONTROL is open to every process and I can't take the system down, I'm hesitant to try commands that might cause issues. My last resort will be to create a new file, copy the valid records and replace the existing, but there has to be a fix that doesn't require taking the system down. I've tried to manually select and delete the record(s). I also wrote a program when that failed. I've tried multiple things in the program, using SELECT statements and creating the ID, but the READ statement hits the ELSE clause because it's not valid. The info below demonstrates that a single record selected is handled as 2 records when I edit them. >SELECT CONTROL = "[19791 ]"1 record(s) selected to SELECT list #0.>>AE CONTROL< 1 > Top of New "LAST.DMD.NEW.DAILY^009* Date of last NEW demand history load" in "CONTROL".*--: EX

I'm adding some validation to a routine that launches BASIC programs to ensure that the program's object code can be found (and is not a subroutine or function).For main programs I think the search path is as simple as Local VOC GLOBAL.CATDIR (if the program starts with "*" - testing has shown that only globally cataloged programs that start with "*" can be  run ) For subroutines and functions it gets more complicated Local object code of program that will call the sub/function Local VOC GLOBAL.CATDIR (for all the available prefixes: "*", "!", "-", "$" Leaving aside the technical hurdle of pulling apart local object code looking for additional subroutine/functions, and the logic needed to detect if object code is a subroutine/function - that will have to wait for now.Is there anything that I might have missed in these search paths?Is there any case sensitivity settings/toggles that can influence the search in each of these paths? Many thanks------------------------------Gregor Scot

Hello , there. We have a rich client application, written in Delphi that ships (installs) with the follwing dlls dependencies:  As far as I know, there is noother requirement (lib or whatsoever) needed for the client to run. My question is, ¿what is the path that I need to follow to secure comms  (using SSL I guess) this client App ? If there is , ¿can we "pack" the solution with the installer ? . Going PC to PC is out of the equation.Regards, David.  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------