Rocket® U2 | UniVerse & UniData®

Hello everyone,Firstly, I have to say that this is my first experience of attempting to use UOPY so please forgive any obvious mistakes on my part.   The issue which I am looking for some guidance on is as follows:I can log into Universe via an ssh terminal, issue command such as:SELECT CDC.CARD WITH ID = "1234567890123456" TO 1LIST CDC.CARD CARDNUM FROM 1This selects one record into list number one and outputs the ID and CARDNUM values.   CARDNUM Is a calculated field and is decrypted / displayed correctly when the operations are performed as above.However, when using UOPY, I replicate the above using something similar to the below:cmd=uopy.Command(f'LIST {filename} CARDNUM FROM {list_number}',ses) cmd.run()Inspecting the cmd object shows that there's an error in decrypting the value, with the full error message as follows:error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:crypto/evp/evp_enc.c:570I understand that the Command objects should be

[Rocket U2][U2ODBC][2300701]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: S1000; U2 Database code: 20085; Msg: [U2][SQL Client][UNIVERSE]Program ".ITYPE.": pc = 6, "*PAID.AR.CALC012" is not in the CATALOG space. .".Back in November, I was able to get connected to this U2 database from SQL Server, PowerBI, and other tools using OLEDB and ODBC as outlined in this previous thread:Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData I'm using the latest U2 64-+Bit ODBC Driver Version 7.241.02.9004.The ODBC Connection tests successfully and works perfectly in applications that use ODBC, such View this on Rocketsoftware > After a several month hiatus, I am now trying to work with the U2 database again, and getting this error related to the "CATALOG space" when accessing certain tables that I successfully accessed back in November.I am on the same PC, with the

Where could I find / how could I capture the output of a phantom started by a phantom?We have the code: EXECUTE 'PHANTOM ':TASKNAME CAPTURING EXECMSGE executed by a phantom program.Display statements in the first phantom are output as normal to its &PH& file.'EXECMSGE' contains "Phantom process started -nnnnn"The secondary process does its job, but any display statements are not written to any &PH& fileRunning the secondary process from TCL shows the display outputs at the terminalRunning the secondary process as a first phantom send displays  to &PH&.Running Universe 11.1.4 on Linux.. I'm not in a position to be able to change how it runs (but still need to support it)Thank you in advance for any help :)

I am trying to connect to an API and need some helpUsing RHEL 7 and Universe 11.3.4The curl example they provided works in RHEL. curl -X 'GET'   'https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips?vagusAPIKey=1A2B3C-1533-CMBD-8537-123456789'   -H 'accept: text/plain' This is my BASIC Code      URL = "https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips"      KEY = '1A2B3C-1533-CMBD-8537-123456789'      X = addAuthenticationRule(X.CONTEXT,2, "VerificationStrength", "generous")      X.DEPTH = 2      X.SERVER.OR.CLIENT = 2             ; * CLIENT      X.RTN.CODE = setAuthenticationDepth(X.CONTEXT, X.DEPTH, X.SERVER.OR.CLIENT)      X.RTN.CODE = addAuthenticationRule(X.CONTEXT, 2, "ServerName", "stagingapi.vagustracker.com")      HTTP.METHOD="GET"      X.RTN.CODE = createSecureRequest(U

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

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?

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

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 

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

We have a backup script that suspends and restores writes by going into Universe and setting the SYSTEM()  variable 27/43.  We had a problem when after the script suspended writes the unsuspend failed because user license limits were briefly reached.  What is the best way to recover beyond adding more licenses?

I am using Universe 11.3.4 on a RHEL 7 box. I created a trigger on a file and I can create a log every time the file is changed but I can't figure out what program is making the change.  I can see the @TTY, @LOGNAME, and PARASENTENCE DATA but the FILENAME comes back as a blank. I have a Phantom making some of the changes and the PARASENTENCE is giving me the name of the phantom. Is there anyway I can get the Filename of the BP program?Jon CardCombined Transport Inc​​​​

I've added 3 attachments    file "OPENPYXLTEST.txt"   is this basic program that calls Python program named "openpyxlText.py".  From inside an Accuterm7  windows I RUN OPENPYXLTEST program 3 consecutive times. with out changing any code  or anything.  I get the output below.     As a test I ran this python code in Linux and windows neither test caused an error nor OS failure. We are using universe 11.3.4 The python openpyxl library is the most recent available.  I've attached the requirements20230111.txt file also that I created yesterday.I have a few print() statements in python code to show the flow.====== output from python openpyxlTest.py from AccuTerm 7 window ======>RUN OPENPYXLTESTCalled build_u2_objectLoading variablesreturn control to U2loaded start_U2excel methodAt top of method, load_csv_from_file()loading openpyxl libraryJust after import openpyxl lineran load_csv()>>>RUN OPENPYXLTESTCalled bu

i can create an unidata account using ext admin tool just fine but in universe (which is where I came from to unidata) there was a uv account that went to a universe menu where you could add/delete accounts amount  a lot of other things, is this not available in unidata?thanksdougc

in the past as these are test VM's running rocky linux on my personal laptop I usually just disable the firewall so I can use ext admin tool to create accounts and suchbut if I wanted to keep the firewall up what ports do I need to open up so I can still access via ext admin tool?thanks

I'd like to get certified as a UniVerse Administrator. Is there any word on when/where MV Universe will be held in 2023? Can I get certified taking an on-line test?Jon

Hello,We have a requirement to upload a file to an AWS endpoint using the POST method and multipart/form-dataWe have the pieces in place and parameters added using addRequestParameter function, however the file is not getting uploaded with its contents. When we check the contents of the file uploaded in the server it contains the filename itself.What are we missing?*---------------HTTP.POST.FILE:*---------------HTTP.METHOD="POST:multipart/form-data"TIMEOUT=3600svc_return_code = setHTTPDefault("VERSION", "1.1")** Create security context*X.SECURE.HANDLE = ""X.CONTEXT.RESULT = createSecurityContext(X.SECURE.HANDLE, "TLSv1.2") ** Create secure request to S3*svc_return_code = createSecureRequest(X.URL, HTTP.METHOD, REQUEST.HANDLE, X.SECURE.HANDLE)** addRequestParameter*rc = addRequestParameter(REQUEST.HANDLE, 'key', X.KEY, '')CRT 'rc key: ':rcrc = addRequestParameter(REQUEST.HANDLE, 'AWSAccessKeyId', X.AWS.ACCESS.KEY, 'multipart/form-data')CRT 'rc AWSAccessKeyId: ':rcrc = addRequestParamete

Hello everyone,We are planning to upgrade our UniVerse (UV) ERP system this year and also do a hardware refresh. We would like the hardware refresh to include running in a VM (we don't currently). Our current UV system is running on an IBM AIX server with Kaminario flash storage (~2TB) with our largest hashed file being 120GB / 23M records.Looking for any insight or opinions related to getting more speed and performance for UniVerse i.e. stick with AIX or go with another UNIX / Linux? Virtualize or don't virtualize? Nutanix VM or something else? Anything better than flash storage from Kaminario?Thanks in advance!

We are trying to add a subroutine call from an existing trigger.  The subroutines are definitely being called and acting appropriately, except when they attempt to write to a log file.Using "ED" to make a simple change in order to force the trigger, we are getting this error:Program "ED":  pc = 748C, Program "XXX": LINE 409, FATAL:  The locks necessary for database operations at the current isolation level (0) are not held by this process.The subroutine is trying to write to a type 19 log file which works fine from other programs. Commenting out the log file write avoids the error. Because of this error, the write to the CUST file (which is the one with the trigger) also fails.I assume this is something unique to the trigger function.  The trigger subroutine is cataloged globally as expected, so I am wondering if that is making file access in the account unavailable some how?This is running in UniVerse 11.3.1Any ideas would be gratefully appreciated.Nelson

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

I am running Universe 11.3.4 on RHEL 7.7 using AccuTerm 7.3a as my emulator. When I login normally my backspace works. I need to use root permission for some of my phantoms. At TCL prompt I will SH to Unix level then su to root then uv back to universe. My backspace key quits working.  I can manually fix it by running a PTERM command. Is there away to permanently fix this?Jon CardCombined Transport Inc

I have a UniVerse customer, a county highway department.  Over the years we have accumulated a lot of lat/lon coordinates for different resources.  I would like to propose adding a GIS interface to the system.  My question, has anyone already done this to any multi value database and can you suggest products to research?  I have looked, a little, at ArcGIS because they have some low cost online training.

Years ago, in a different forum, someone posted a proc/paragraph they called LSELECT that, as I recall, allowed you to take a select list of values for a specific attribute in a file and select all the records in that file that contained any of the values in the select list. It was very clever.The machine I installed it on is long since off-line. If anyone else has it, I would love to recreate it on the machine I am on now.BTW, i am using Unidata 8.1

Does a command exist for UniData that will list all the data files with triggers in a data account?I could write a routine to do it, but I'd rather not reinvent a wheel that exists.Thank you

Hello, I'm trying to put a copy of my production database into my Windows Personal Edition UniVerse 12.1.1.0 and it´s giving the message below: C:U2UVTEST>uvrestore -i ftp empIPL.LOCb Backup Date : Mon Sep 19 16:50:01 2022 Reel Number : 1 Compression/Encryption: Off Image Type : Full Backup (ver10 UNIX) Block Size : 8192 bytes NLS on : False FastWrite On : False Label : IPL Data Current device(s): ftp empIPL.LOCb IPL.LOC (Sep 19 14:50:01) File "IPL.LOC" has modulo 160309 which is > 10007. Please resize it to modulo <= 10007 in order to use it in Personal Edition. IPL (Sep 19 14:59:20) File "IPL" has modulo 145661 which is > 10007. Please resize it to modulo <= 10007 in order to use it in Personal Edition. Total files: 0 Total bytes : 0 Elapsed Time: 00:00:03 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. 0 ext