Rocket® U2 | UniVerse & UniData®

My customer, UniVerse 13.5, is running on Nashville Metro Government's internal cloud.  The network security is so restrictive that it is difficult to get work done for the customer.  I have requested information from the "mypickcloud" website but have received no response.  Does anyone know if that cloud still exists and if so how to contact them.  If they do not exist does anyone have recomendations on other clouds where UniVerse could reside?  I have looked at AWS website and am buffaloed by the complexity of their options.  I would simply want to move my customer's system and data to a cloud server for day-to-day operations. Dale

I have a customer who is attempting to setup a Fedex machine, connecting it to Unidata to transfer data.  The same ODBC driver works perfectly on another system.  On this system, we get odd errors and I have zero clue how to research them. For example: DataSource.Error: ODBC: ERROR [SICOO] [Rocket U2][U2ODBC][1801668]Error ID:33 Severity: ERROR Facility: DBCAPERR - The UV/ODBC server or the underlyingdatabase do not provide the requested feature.Details:DataSourceKind=OdbcDataSourcePath=dsn=upsodbc This happened when attempting to retrieve data through the 32-bit ODBC connector using a 32-bit Excel.  It was able to authenticate and return a list of table names, but when attempting to view the fields inside of the tables, this was the error.

Is there a document somewhere that lists Unidata limitations?  i.e. longest TCL command line, maximum number of indexes, maximum memory per process, that sort of thing?

I recently upgraded a customer's UniVerse to 11.3.5 and am ready to install a new AccuTerm 8 server account.  I am unable to figure out how to create that ACCUTERM account.  I'm used to Unix and Linux menus to create an account but on winndows I cannot find such a menu or a "CREATE.ACCOUNT" verb in the UV VOC.  I vaugely remember a windows administration program, but can't remember it's name and don't know where to find it.  I tried copying the XDEMO account and entering an ACCUTERM item in the UV.accounts file but that didn't work.  Unless I can get the ACCUTERM account established, I'm afraid the server side of AccuTerm won't work. Dale

I am on a Universe system and it does not save the TCL command stack from session to session.  How do i turn that on and have it shared for a user over multiple sessions?  Also, what file is the stack saved in?

Hi, In the same version of U2.Data.Client (3.1.1), the string data format I retrive from a database is different, by changing the library from .NET to .NET Framework, using the codepage 850. In this case, in the .NET Framework is correct and with .NET the "special" characters are not shown properly. I'm portuguese and the problem is in the accent words like á, é ç. Can anyone help me to resolve this issue? Best regards, Jose Baptista

Been using basic Wintegrate for a long time. Now, I would like to construct some GUI screens but cannot locate the designer tool. Is is still out there? If so, where can I look? I've already scanned all of the manuals cannot find a reference as to where to find it (i.e. how to start it. Any help in this matter would be greatly appreciated.

Hi all I'm trying to replicate some legacy code using uopy, but I've found an issue that's hard to solve. This is a LONG process, both server and local side, so timeouts may appear. Using the older UVIC32.dll code we can simply reconnect to a session after it has been closed by the server. But, after health_check returns false to uopy I can't reconnect to the server, and the connect() method is not connecting. Is there a way to do this?

Hi A strange behavior, we have a subr WI.LOG which call another subr GET.PORT which make a simple OCONV(0,'U50BB') U50BB run fine million times a day.  Sometime the session seems 'suspended' and PORT. STATUS LAYER STACK return GET.PORT at 0x000000000 !  After a while, the system continue... I suppose its a lock situation ! Semaphore lock ?  Is someone experience a subr call 'stopped' like this ?  Adress 0x000000 is strange ?  Thanks for any comment.  Manu BASIC run machine GET.PORT 0x00000000 BASIC run machine WI.LOG 0x00000028

We are running SB 5.5.3 and we frequently end up with orphan port assignments in DMSECURITY. We were advised to use the RELEASE.LICENCES process to make the ports in DMSECURITY available. However, it seems that the process is not treating the phantom processes correctly, it determines that these are orphan and releases them. The consequence of this is that when the phantom completed and tries to reschedule itself, it fails. We end up with a shortage of licenses, when we actually have licenses available, the message the users are getting is the following: Has anyone ever experienced this before and if so, how did you deal with it. Upgrading to a newer version of SB is not an option. Thank you. André Guindon

We are running SB on UniData on Linux.  There is a command in SB called LISTU.  It beings back: Port, Pid, Account Name, SB+ User, NT User, Login Date/Time Questions are: 1) Where does it get the Account Name?  I have found this to not be 100% correct, but still want to know. 2) Where does it get the SB+ User?  Again, this is not always correct, so what is it doing?

Hi all I have some URLs that have special characters, but the server takes them without issue. Example: https://narobialimages.s3.eu-central-1.amazonaws.com/images/Light+version-Customer+Service_Retail_2019_15.jpg My problem is when I try to get this URL from BASIC: URL.CARACTERES='https://narobialimages.s3.eu-central-1.amazonaws.com/images/Light+version-Customer+Service_Retail_2019_15.jpg'RESPUESTA=protocolLogging('/u2/quiter/POSVENTA5/&COMO&/HTTP_LOG_HECTOR_':TIME():'.log', 'ON', 27)RESPUESTA=createSecurityContext(SECCONTEXT.HANDLE,'TLSv1:min')RESPUESTA=addAuthenticationRule(SECCONTEXT.HANDLE, SSL_CLIENT, SSL_RULE_SERVER_NAME, SERVER.NAME)RESPUESTA=addAuthenticationRule(SECCONTEXT.HANDLE,SSL_CLIENT,SSL_RULE_STRENGTH,'generous')RESPUESTA=createSecureRequest(URL.SERVICIO,'GET',HTTP.HANDLE,SECCONTEXT.HANDLE)RESPUESTA=submitRequest(HTTP.HANDLE,30000,'',CABECERA.RESPUESTA,DATOS.RESPUESTA,HTTP.STATUS) The URL gets encoded: 10/22/2024 13:52:21 [ 11047 11046 ] createSecurityContext

Using U2.Data.Clent 3.1.1.1003, I'm receiving this error after the web service has sat for some time.  The Session.Status = 0 and Session.IsActive = true.  I there a way of knowing when the underlying connection has stopped?   U2.Data.Client.UO.UniSubroutineException: ' [U2][UCINET-UO]WIN32 API Error:10053An established connection was aborted by the software in your host machine.[Rocket U2][UCINET - UNIRPC][ErrorCode=81009] The RPC failed

Here is a record sample: The TESTING column is a multi-valued list, and the pipes represent actual SVMs for readability. I'm looking for a function that will return an associated boolean list indicating whether or not either '1400' or '9101' exists in TESTING, so... In this sample, if one is present so is the other, but that's not always the case. So a 1 should be returned if either exists in what is actually a subvalued list. EDIT 1: A subroutine would make this very easy, I know, but I don't have time for the administrative overhead that comes with developing/delivering one to PROD, so I need this to be "idescriptor" language. Also, there will be subsequent processing, based on a SUM() of the Y/N list for each record, which will be compared to DCOUNT(TESTING,@VM). EDIT 2: I think I found a solution. I didn't realize I could use the INDEX function on lists. Though it will require another step or 2 to get the final result, I think it will work.

Hi all I have some problems when connecting to servers using uopy, as the PATH variable is wrong. From the terminal console: >SH -c "echo $PATH" /usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/uv/bin >SH -c "uv -version" UniVerse 14.1.0 When using uopy: cmd = uopy.Command() suffix = " " cmd.command_text = 'SH -c "echo $PATH"' cmd.run() print(f'{cmd.command_text} = {cmd.response.removesuffix(suffix)}') cmd.command_text = 'SH -c "uv -version"' cmd.run() print(f'{cmd.command_text} = {cmd.response.removesuffix(suffix)}') The output is: SH -c "echo $PATH" = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin SH -c "uv -version" = SH: line 1: uv: command not found What's the issue with the uopy connection having an incomplete PATH value?

I am running AIX and ksh.  At the AIX prompt, I have: AIX $ which matches the value for PS1    PS1='AIX $ ' when I issue the SH command from Universe,  I get to the host system.  I can issue AIX commands (without issue I think)However,  the Prompt is NOT displayed.  It is just blank The shells are linked together: $ ls -al | grep 326868 # -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  ksh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  psh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  rksh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  sh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  tsh Does some configuration option ne

Using a BASIC program, I need to read filenames and file dates from an AIX directory and compare them with names and dates held in UniVerse records. If the files are present among the UniVerse records then they need to be moved out of the directory and more files added from another directory. Any advice or code snippets much appreciated.

For a conversion project at a customer with 4000 custom programs written over 30 years we're trying to get a handle on which programs are actively used.  One idea that's been floated is running a monitoring program as root from the demo account that does the pseudo code below. By definition we'll be running this in production for a month or three, and there's some justified nervousness about any potential performance impacts.  I don't think the monitoring program will be a performance hog itself, but not sure if doing PORT.STATUS on the probed program has any effect - does it "pause" the probed program so the stack collected is consistent for example?  We're not expecting to get 100% coverage from this, but even 80% would be a huge help. Anyone ever done something like this for real?  Any war stories or hard-won words of wisdom to share?  Thanks for reading! LOOP EXECUTE 'LISTUSER' LOOP FOR EACH ROW IN LISTUSER RUN "PORT.STATUS PID <ROW.PID> CALL.

Hello, Our apps are written in SB+ which use a cached opened files, in named common block SBPLUS & SBFILES, of 30 + 750 = 780 filevars (result of OPEN file TO filevar from BASIC). Some of our app's files are indexed, dynamic or distributed.  It means, with 780 cached filevars, we open more than 1000 os file.  With release 11.x we are used to set MFILES 3000 without never a trouble.  Now r12, r14 introduce SESSION_NFILES limit. Which is session's ActiveFileTable instance. SESSION_NFILES is not defined in uvconfig. CONFIG ALL report SESSION_NFILES = 800 ; aka. MFILES x 4) Then, at basic runtime we encounter OPEN file to fv ELSE CRT STATUS() =  -25 which is Exceeded SESSION_NFILES file table resource.  I try to push MFILES from 200 to 300 or set SESSION_NFILES to 2000 in uvconfig ...  - uvregen accept it  - at uv -admin -start I get  StartService failed (1068)  minidumpexception* Unhandled Exception raised at address 0xE7261759 : Acces

I would like to obtain the workstation hostname when a user logs into a Linux system.  I had it available on our Solaris Unix server but not on our RHEL8 server.  We use this to identify a physical location and to associate network printers nearby.  I am able to get the workstation hostname when in Citrix and by using Accuterm and checking a Session clientname but it is not always present when directly on the network and wondered if it was somewhere else Available to Accuterm.  Where can I found out the PC workstation hostname and what other windows information like this might be available to harvest? 0097:             * Check for citrix environmental variable CLIENTNAME0098:             SCRIPT = 'InitSession.Output Environ("CLIENTNAME") & vbCR'0099:             CRT CHAR(27):CHAR(2):'P':SCRIPT:CHAR(13): ; INPUT CLIENTNAME: ;  IF CLIENTNAME # '' THEN CRT "<-ClientNam

hello,  Under UV r14, these 2 uvconfig GLM_MEM_ALLOC / N_GLM_SELF_BUCKET are documented as :  GLM_MEM_ALLOC - The number of lock nodes allocated for each memory request. This parameter is highly application dependent. if the application requires a large number of locks in one transaction, this setting should be increased to the maximum number of locks per transaction * 2.  N_GLM_SELF_BUCKET - The number of hash buckets for the per-process locking table. This parameter is highly application dependent, If the application requires a large number of locks in one transaction (more than 20), you should increase this setting to the closest prime number to the maximum number of locks per transaction.  So, they are delivered  GLM_MEM_ALLOC 10 N_GLM_SELF_BUCKET 23 So, I try to set locks with READU and I have no problem to set 30'000 locks in one basic loop !  Are they not used if SYSTEM_BUFFER = 0 ?  Thanks for any explain. manu

We are upgrading from RHEL 7 to 8 to 9.  Then, we will need to upgrade UV 11.3.1 to 11.4.1. We are considering only going to RHEL 8, but UV 11.4.1 is certified for RHEL 9. Is anyone running UV 11.x on RHEL 9?  Any issues with it? 

hi everybody. A strange behavior we do not understand. on a UV/windows / 11.3.5 we have python 3.11  (the one within uv/python - no other python is installed on the machine)  We  use module 'pandas'  in our script, release 2.2.2 is installed.  When executed from osshell, no problem : dos /c "python path/script.py"  When executed from uv/python, from pyCallFunction() or from TCL >PYTHON then import pandas we get this  DLL load failed while importing aggregations: The specified module could not be found.we do not understand what's wrong with the deploy.... What is the difference between a osshelled python call and a uv's python's one ? any idea ?  Many thanks for any advice  Manu 

Hi Guys,I've got a weird issue affecting a couple of my users.The users all use SB Client V6.3.1 and login to the GUI interface, where they have access to SB + menus and have the facility to create their own User Menu, they typically put their "FAVORITES" that appears as a "window" on the left hand side of their main screen, which should look similar to this, dependant on what the user has added to the menuHowever this is what the users are seeingas you can see from the above the TEXT for the menu does not display correctly, at the point of logging on the text and menu structure is momentarily displayed.A full removal and re-install of SB Client doe not resolve the problem, nor does right clicking the the menu to Change FONT or any of the other items on this menuHas anyone else seen this problem and if so what is the work-around / fix please ??ThanksAndy

It seems that whenever I reboot my Windows PC, the Unidata database 8.2 and the Unidata 8.2 Telnet services are both 'disabled'. I use CCleaner and McAfee anti virus. Could it be that one of these is doing it. Or perhaps something else. Anyone got a clue on this one?