Rocket MultiValue

I'm working with UniData 8.2.  I've written a utility that lets me view and treat an SQL table like it was a local UniData file with UniQuery type commands.It's been working fine.  But I am having an issue with one ODBC connection that sends back the rows but not the data for the columns.Has anyone seen this before?  Could it be some type of privilege setting?  I can get data back using an SQL manager tool using the same logon credentials.SQLFetch doesn't bring back any error messages, just no data.I am going from one domain to another, all within our intranet.Thoughts?

The requirements listed for 1.3.0 report a minimum of UV 11.3.1The Product Availability Matric in RBC lists a column named "Advised Minimum", leading me to think it might be possible to run MVIS 1.3.0 against an older UV version, like 11.2.5Is it possible to use MVIS 1.3.0 with older UV versions, or does it have a hard requirement for the newer functionality from 11.3.1 onwards?------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

I note that the "requirements" for 1.3.0 list a UV 11.3.1 with connection pool licenses as a minimum.Are the "connection pool" licenses absolutely required for MVIS 1.3.0, or can it be configured to operate using normal UV licenses?------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

Hi,Where can I find the download fo MVIS 1.3?Regards,Thando------------------------------Thando NgayiAxiz------------------------------

We run UV 11.2.5 on RHEL7 servers, and use UniRPC connections a lot.I have been looking for a way to automatically apply reduced priority to some UniRPC connections based on the connecting user id.I have tried creating a new 'conf' file in /etc/security/limits.d.These files get applied by the PAM limits module for new login connections, but when the UniRPC daemon validates the credentials of the in-coming connection it appears to not be running through the PAM modules so when the uvcs / defcs / uvserver session is launched using the supplied user credentials the resulting PID is running with the default priority.Does anyone know of a way to automatically have the launched uvcs / defcs / uvserver process use a non-default priority?

We have used printer loadable soft fonts to print logos on packing slips for over a decade. I am now unable to find anyone that can provide a service or software to convert images into SPF files. Does anyone have any idea of finding something or a workaround like printing an image directly for every printed page?------------------------------Nelson SchrothpresidentC3 Completeshop LLC------------------------------

All,When I have no records selected in an INFORM report, the heading does not print. Users are asking the admin staff if a print job was printed. Is there a way I can force the heading to print if no records are selected, or is there a way I can place the report name in the Unix spooler banner page? I get a banner page with no records selected, but I think it is from the Unix spooler. Maybe set an environment variable to put into the banner?Jon

We use the Import file function in Wintegrate extensively for our quarterly reporting and extracts.   Has anyone automated the process where you call the Import file function (using .wis files predefined) from a program?  Looking to create a batch process for our quarter close and call multiple imports to facilitate data imports into Excel.  I looked through previous threads as well as documentation but could not find anything referencing calling/running the .wis files from a program.------------------------------Cory BelgradeSr ManagerOne America------------------------------

I need to securely store pdf documents.  First thought was to encrypt and store on web server, then keep the key in DB to decrypt.  Second and better thought would be to upload the pdf to the DB and store the binary document in the DB.Just wondering if anybody has attempted to store a PDF document in the db and if they would be willing to share any code/problems.Craig------------------------------Craig Curtiscraig.curtis@seviersd.org------------------------------

Hi Everyone, just a bit of background, we have several Excel Applications that use ODBC to fetch data from UV files and update, and have reached the limits of what is available with the allowed joins and use VBA scripts to perform several queries. We run in to problems that if there are no Client Licences available, for obvious reason the Queries don't execute and this can lead to problems getting the queries to rerun I am sure this is down to MS Excel / MS Query / limitations of the Rocket ODBC drivers. we are using the latest U2CL_5.2.1 I was wondering if anyone has any experience of using MS Access as a vehicle to extract data and if "LINK TABLES" are considered a supportable and reliable way to extract the External Data and then point our Excel process at the Access harvested data rather than Excel extract the data directly from UV I've had a play and only got limited success with the MS ACCESS "Link Table", some tables wont return data and present on ODBC - CALL FAILED error, even

The Rocket MultiValue product management team hosts quarterly livestreams about the MV product roadmaps for Rocket UniVerse, Rocket UniData, Rocket D3, and MultiValue tools. The second quarter event is just 2 days away. Sign up now and pre-register for the third and fourth quarter events as well.Each quarter, Rocket product managers will present both near-future and distant-future plans for MV, as well as the many possibilities we're still thinking about. Additionally, in 2021 we added a cloud roadmap for customers who want help moving to the cloud.Sign up here------------------------------Dave AndrewsHead of Customer EngagementRocket Software------------------------------

The Rocket MultiValue product management team hosts quarterly livestreams about the MV product roadmaps for Rocket UniVerse, Rocket UniData, Rocket D3, and MultiValue tools. The second quarter event is just 2 days away. Sign up now and pre-register for the third and fourth quarter events as well.Each quarter, Rocket product managers will present both near-future and distant-future plans for MV, as well as the many possibilities we're still thinking about. Additionally, in 2021 we added a cloud roadmap for customers who want help moving to the cloud.Sign up here------------------------------Dave AndrewsHead of Customer EngagementRocket Software------------------------------

Every time I've tried to use the Debugger Perspective in U2BDT it crashes the entire application. We're using v4.4.0 of U2BDT, after crashing we get this Java error:Is there anything I should be particularly looking out for configuration wise?------------------------------Matthew WrightTomago Aluminium------------------------------

I have a paragraph which prompts for a branch code to be selected.I want the branch codes to be a dropdown list in the paragraph. example :1 North2 South3 East4 WestMy paragraph output.Enter P to print or D to display report(P/D) =DENTER APPLICATION START DATE =01 FEB 21ENTER APPLICATION END DATE(DD MON YR) =11 FEB 21ENTER YOUR BRANCH NUMBER=Paragraph:SORT MYFILE WITH DATE GE "<<ENTER APPLICATION START DATE >>" AND LE "<<ENTER APPLICATION END DATE(DD MON YR) >>" AND WITH BRANCH EQ "<<ENTER YOUR BRANCH NUMBER>>"AND STATUS = "1" "4" "5" "7" ID STATUS DATE TOTAL AMOUNT BRANCH HDR-SUPP ID-SUPP LPTRAnyone can help?------------------------------Francis AquilaCore Banking Support OfficerTISA------------------------------

Hi,I would just like to say MVIS 1.2.1 is a solid product. 12 months ago I created a POC app to understand the HA element of the solution. It's performance has been outstanding with no downtime and easy cloud integration. Using https://aws.amazon.com/marketplace/pp/Rocket-Software-Inc-Rocket-MultiValue-Application-/B082DLTD53 to build the Back-End & building the Front-End utilising the Angular Framework and deploying both utilising Amazon. We created a simple SPA  to perform our testing of the solution. https://rocket-demo-68270.web.app/login Enjoy.  ------------------------------darren johnsonIndue------------------------------

I am looking for recommendations of companies to run the upgrade of a Universe application currently running Universe 11.1.3 to most current Universe version.   The application is running on a Solaris 10 system so it would be upgraded to Solaris 11 but may also be re-platformed to Linux or AIX.  There is a small staff maintaining the application to consult.

Thanks to everyone who played in the qualifying round of MV Madness. With over 100 entrants you exceeded our expectations for interest in the event! So with that, 23 players are moving into the finals. No one got 100% of the answers correct, but finalists scored between 95% and 75%, which are very fine scores indeed.Members going through to the finals, who've already earned a pair of Rocket pajama pants, are @Henry Unger, @Derek Hayse, @Rajesh Menon, @Fausto Paredes, @Frank Hanshaw, @Tyrel Marak, @Brian Egan, @Craig Curtis, @Gregor Scott, @Mike Raffaele, @Ross Reichardt, @Stuart Boydell, @Todd Hess, @A C, @Bob Ruiz, @David Knight, @Chris Turner, @Nic Davidson, @Alberto Leal, @Brian Paige, @Chris Wolcz, @Nik Kesic, and @Tom Power. Be sure to congratulate these experts when you see them on the Forum; they might just be able to help you with something.    ​​​​​​​​​​​​​​​​​​​​​​​​​Good luck to all those in the final round, and thanks to everyone for your participation. We look forward to w

MV Madness saw MultiValue users from across the globe come together to test their skills and knowledge, but in the end there were just five players who took the championship. Congratulations to @Brian Egan for scoring the most points in the finals, with a score of 40 out of 44 (91%). Four additional players scored 38/44, or 86%. They are @Nic Davidson, @Nik Kesic, @Bob Ruiz and @Henry Unger. In addition to Rocket Pajama pants won by qualifying for the finals, each winner also receives a $100 gift card. I'll be in touch shortly with winners to arrange for all that, and qualifiers can expect to see their Rocket PJs on their doorstep in a couple weeks. Thanks again to everyone who participated and let us know what other events you'd like to see us sponsor.------------------------------Dave AndrewsHead of Customer EngagementRocket Software------------------------------

Block comments are available in many programming languages and any lines of text between the start block and end block delimiters are considered part of the text. We are starting to use Markdown extensively in program headers for developer, modification history, program documentation, etc. It would be really helpful if U2 would implement this form of comment so that the Markdown text could be put in-line with the other documentation and we would not have to deal with leading comment marks.An example might look like this:​The '***' on line 26 denotes a divider line in Markdown. A simple program can then strip the Markdown area and throw it to a temporary file to be viewed in your favorite browser or printed to a pdf. VSCode already supports Markdown preview and editing. Note that you can embed links to outside web documentation, internal code control resources (like VSTS) or documents in your file system.I'd be curious to hear from the community if this would be helpful to others.------

Just wondering if there is a function for me to send a message to the runtime-errors file?  Trying to debug a program and if I could send a few notes to the runtime-errors file via a function call it would save me a few steps.ThanksCraig

UniData version 8.2.3 has been released on April 30 2021 for the below platforms/versions:AIX POWER       7.1,  7.2Amazon Linux       2CentOS       7,  8HP/UX ITANIUM       11.31Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Solaris SPARC       11SuSE Linux Enterprise Server Intel       11.0 (SP2),  12.0Windows       Windows 8.1,  Windows 10 (Creators Update Supported),  2012 (R2),  2016,  2019This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product av

hello uv's gurus, I'll share a strange behavior we encounter on Uv Windows.We run some phantoms as scheduler which performs actions on request.The phantom check what to do, execute it then wait for the next instruction.  It is restarted each 8 hours.---Sometimes, we encounter troubles at uniQUERY SELECT level, the select is 'pending', seems 'blocked' ...After 50 seconds of execution, we check the status via PORT.STATUS PID xxxx LAYER.STACK and we read the phantom is 'selecting'  - actual level of execution is 'Query' from uniBASIC EXECUTE CAPTURING Here is a sample stack - MI.SCHEDULER is the base program which CALL MI.SCHEDULER.CTRMI.SCHEDULER.CTR-- receive the job to do-- create a level EXECUTE MI.SUB which perform the task In this sample, we read SB.EXECUTE perform a EXECUTE query SELECT ARTICLES ...  PORT.STATUS PID 21448 LAYER.STACK Pid.... User name. Who. Port name..... Last command processed 0ř0ř0 21448řsvc_uv_coldstartř -2řSELECT ARTICLES USING DICT D.FPRART WITH ART.CLE # "" A

I have replication setup on a UV 11.3.1/Windows system from one account to another on the same box.  On the destination file, I have a trigger that goes through and cleans the data and creates a record in another file that I'm exporting to SQL Server via EDA.  However, when I change a source record that gets correctly replicated to the destination, my trigger is not running and the cleansed file is not being updated.I have RW_SKIP_TRIGGER=0 in repconfig according to the docs, but I keep getting this error in the logs:Sat Apr 24 15:34:33 repconfig at line 16: RW_SKIP_TRIGGER cannot turn off: Current release does not support this feature.What can I check?------------------------------Kevin KingPresidentPrecision Solutions, Inc.------------------------------

Hi Everyone We want to make extensive use handheld terminals in our warehouse and Factory for point of activity transaction processing, with a goal to further enhance this and utilise Barcoding to reduce further the amount of manual keying required As there does not appear to be a version of SB Client that will operate natively on anything other than Windows can anyone suggest a handheld that will provide a screen large enough to accommodate SB Menus and also work with a decent touch screen that is not subject to "fat finger" syndrome we have be experimenting with Zebra TC520K android handheld with Velocity Android 2.0 TE terminal emulator. (VT100) this uses Telnet as its connection interface to the UV and SB applications however it does not provide easy Access to "F2" and "F3" keys which are used extensively within our current transaction processes So can anyone recommend a handheld that operates seamlessly with UV and SB applications that provides easy access to "F2" and "F3" functio

We are using UV 11.3.1 and have a .Net application using unirpc to access data from the host (on Linux). There's been a marked degradation in the time the .Net application takes to move from page to page over the last couple of months. I suspect it's an issue with the .Net application but I need to prove that the access on the host side is not causing the issue. CAn any of you learned folks recommend monitoring tools for UV that will report read/write performance and identify latency?I'm pretty sure I can write something to do this but want to see if the problem has already been addressed.Thanks!------------------------------Jeff TeterWoodforest National Bank[Phone]------------------------------