Rocket® U2 | UniVerse & UniData®

What are all the valid ways to quote literal strings when assigning them to variables in unibasic on Unidata?------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

Any idea what this message means? In /data/pub/TEST/SMART/LIVE/CTLG/UOLOGIN at line 56 index: 201 to one dimension                                                                                                                                                              matrix is out of rangelobal HScript=`Set BackPages="18"`lobal HScript=`Set Columns="132"`xecute HScript ------------------------------David Rivera------------------------------

Good day, I am trying to connect to a Universe database using ODBC and have set up my DSN. However when testing the ODBC DSN or opening an ODBC connection to that DSN from C# results in the following error message. System.Data.Odbc.OdbcException: 'ERROR [00000] [Rocket U2][U2ODBC][0302086]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLExecDirect(); State: S1000; U2 Database code: 950088; Msg: [U2][SQL Client][UNIVERSE]UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "?". Scanned command was CALL "*HS.SCHEMA" ( ? .ERROR [00000] [Rocket U2][U2ODBC][0302086]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLExecDirect(); State: S1000; U2 Database code: 950088; Msg: [U2][SQL Client][UNIVERSE]UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "?". Scanned command was CALL "*HS.SCHEMA" ( ? .[Rocket U2][U2ODBC][0400182]Connection not open.' I unfortunately am stuck and cannot find any inf

Our ERP vendor is suggesting that the following compilation errors stem from "...a known UniBasic limitation on the number of constants. Tech Note 1193075 on Rocket Software's support site explains that there is a limit to the number of variables and constants that can be used in a BASIC program. The limits are 32767 variables and 32765 constants. However, the maximum space that constants can take up in a program is 50,000 bytes and this figure is reduced by the actual number of constants." too many constants near line 115 of...too many constants near line 121 of...too many constants near line 149 of...too many constants near line 149 of... However, all that is required to get past it is is commenting out the following variable assignment, which suggests to me that there is something the string that is freaking out the compiler: X.XML.LINE = '<w:p w14:paraId="50845D62" w14:textId="71EB9312" w:rsidR="00C91BE8" w:rsidRDefault="00C91BE8" w:rsidP="00C91BE8"><w:pPr><w:pStyle

Hello  I am doing some testing , and I wanted to use a u2 acocunt that i have in other box, so i don't have to copy the thing  i am getting this error, when a try to ub\\bin : Problem determining if file VOC is an NFS file. the share is ro, nfsv4 in origin . Readonly is a must since i dont want to mess anything by mistake  any ideas out there ?  thanks in advance  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

On unidata 8.2.1 My objective is to assign a string of characters (xml code) to a variable, and then write said variable as a record on a sequential file.  However, I get the following error when attempting to compile the program if the length of the string exceeds  ~2K (I'm not certain of what that limit is precisely): It will successfully compile as long as I break up the string in chunks that stay under the limit. However, the same program has no issues reading in a string, the length of which is over 80K characters. Any suggestions would be appreciated.------------------------------Shawn WaldieManager, Enterprise Application DevelopmentRocket Forum Shared AccountLos Angeles CA US------------------------------

Does Rocket / Universe support converting a base64 string to a .PNG file and routing that file item to a label printer? Any advice or direction would be appreciated. ------------------------------Jim ScottSenior Programmer/AnalystGardens AliveLawrenceburg IN US------------------------------

Hello  I would like to know, what is the position regarding NUMA enabled / disabled for a Universe database ?  It is well documented for other databases, and we would like to know if Universe is NUMA aware and what is the preferred configuration on or off.  We are talking about boxes with  512GBB RAM, 64 CPUS, and 2 NUMA nodes  thanks in advance  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

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