Rocket® U2 | UniVerse & UniData®

Hey All, We updated to unidata 8.2 from 8.1, and seem to have broken ssh. Everything seems fine when called from an AIX session, but Unidata sessions are failing when calling same commands... we do recieve the above message X.COMMAND = '-C !scp N19.POSPA…CALL S.EXECUTE(X.COMMAND) This code has been running for years, so any idea on where I should look? Thanks! Rick------------------------------Rick BrownSysadminRocket Forum Shared Account------------------------------

Hi guys - here with a pretty basic question... I am on universe 11.3.4 on linux redhat. We use AWForms here but that app was not able to give me what I wanted so I just wrote the report - but this company does not have a separate printer queue defined for a landscape print(which is what I'm used to). I tried using the printer command within the program but it just prints my characters: PRINT CHAR(27):"&l1O" Can someone tell me the simplest way to flip a report automatically to landscape?------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

is this available in linux as well or is it available in windows only? also when I do !openssl version at ECL I get 3.0.1 when I do /usr/bin/openssl version I get 3.0.1 (or just openssl)  if I do /usr/ud82/bin/openssl version (either at ECL or from linux)   i get 1.1.1n why at ECL i am i getting 3.0.1 the unix verion and not 1.1.1n which is in /usr/ud82/bin/openssl) thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

All,      So we have been battling some extreme system slowness intermittently for years. When this comes up we max out on LCT's, the AIX kernel goes into a panic causing thousands of processes to back up in CPU wait. In  our case it was always nfauser.       We were able to eventually track it back to some infrastructure we had implemented for opening files. Some of the code was basically opening up an NFA  file pointer for each record selected in a loop, so if it was thousands you got thousands of opens and thousands of remote nfauser sessions. We found it and changed it to open once and seemed to fix it for a while. Then it was still happening intermittently. With the previously mentioned bug we saw this on 3 of 4 production systems, once fixed only on our heaviest nfa accessed data server.    What we were able to determine with help from Rocket support was that upon log off UniData spawns a processes that scans /usr/ud/tmp, savedlists, and SAVEDLISTS to cleanup any transient work f

I have the personal edition unidata 8.2.4.3001 and it looks like the openssl version is  3.0.1 can someone confirm to me that this is the same version packaged with 8.2.4.xxxx official? thanks  dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

I am using a install.parmas file with the following: (modified from the default provided) LicAgree        YesStopSys         YesUdtHome         /usr/ud82UdtBin          /usr/ud82/nomUpgrade         YesWorkDir         /usr/ud82/workLibDir          /usr/ud82/libLogDir          /usr/ud82/logUnisharedDir    /usr/ud82/unisharedGroup           sysSerial          LinuxInstallXDEMO    NoRFSflag         YesREPflag         YesREPsysid        dendevmvasbld11_82Backup          NoConfProduct     NoPreservPypath   YesPreservPymodule YesOverWrite       NoConfirm         YesTransMEK        NoSaveDir         saveOldBIN          .CheckLang       YesCheckPerms      YesStartud         YesFixPerms        NoCheckPerms      Yes when I run udtsetup -f install.param I am getting this error: Welcome to the Rocket UniData RDBMS. http://www.rocketsoftware.com/u2 Using /ud8243001/bin.tar during this process. License files are located in $UDTBIN/license. Parent directory of /disk1/agent/workspace/ud_build/src/udh

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