Rocket MultiValue

Our devops team was  performing a system upgrade from Linux Ubuntu 18.04 to 22.04 late last night.  When they completed the migration, they discovered to their horror that the SystemID had changed.   Not knowing what to do at that hour of the night, they searched for a solution.  They found a link  posted by Martin on the Google Groups: www.openqm.com/emergency.htm   They provided the required information and received the following back: 1. We are concerned that after 7 days pass, this license will expire.  Can someone confirm?2. What is the correct action to take?  Our upgrades are going to take place off-hours, late in the evening.3. Is this expected behavior that an O/S upgrade will change the system ID? Any advice is appreciated.------------------------------Ben Cramer DSI Solutions LLCMansfield TX US------------------------------

Has anyone done this with a conversion program or by hand?

Hi,Can someone help for downloading JDBC driver for accessing from UNIX Server (as Client) to Universe DB?------------------------------Elayaraja KathirvelRocket Forum Shared Account------------------------------

I have this audit file that cannot be selected, counted, or cleared. I am running Universe 12.1 in Windows 2016. Generally, this audit file gets purged daily using date criteria of 90 days back, however, I just noticed the select never comes back. I was able to kill the indexes and was hoping that was the problem, but that was not the case. I should point out that I can add more data to the file with writes but not much else.Besides creating a new file and renaming this one, has anyone seen something like this?Posted 08-27-2022 11:43------------------------------Doug AverchOwnerU2 Logic------------------------------

I have several customers who need real-time sales tax calculation. Has anyone integrated an online sales tax calculator with D3 and is willing to share the code?------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Hy... does anyone use SNMP to monitor d3 in linux ? to monitor memory use, disk use and other things... if yes... how ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

hy  i use  the follwing select  :select sgvar614 if a9999 eq "^^^"[401] no items present. but sometimes takes to long...  and i was think... is possible create a index for that ... for exemple CREATE-INDEX SGVAR614 A9999 it would continue acctin as funciction to size.. or would do as the attribute ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

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

sorry to post this again but for some reason I could not post a follow up question to derek's response, is xadmin the ONLY way to create accounts in unidatathanksdougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

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

Please excuse a basic question. but is it possible to delete an item from a select list like you can with an array?SelStr = ' WITH ORD.CODE = "A"  AND ORD.SHIP.DATE < "1/01/2023"'XCmd = 'SSELECT ORDERS' : SelStr : ' TO 1'CRT XCmd ; EXECUTE XCmd  LOOP    READNEXT ORD.ID FROM 1 ELSE EXIT          IF ORD.ID = 12192209 THEN      DELETE ORD.ID FROM 1?????         END   REPEATEND------------------------------Matthew WrightAnalystTomago Aluminium Co PTY Ltd.Tomago NSW AU------------------------------

I've been trying to write an ATGUI program using the data grid.  I want to change the row colors on some of the rows but not all. I was able to do it using the ATGUISETPROPS subroutine but it's pretty slow.  My grid displays that data quickly enough by filling it in with the ATGUISETPROPS and loading them all at once. There are only about 30 rows.  After they're displayed I make a second pass highlighting the special rows. It pops up the "Waiting..." dialog and you can watch the colors flow down.Is there anyway to set multiple row colors all at once like ATGUISETPROPS?When I refresh the grid with new data the highlights stay there. I tried setting all the foreground and background colors for the entire grid by using ATGUISETPROP and setting the col and row values to zero. I couldn't get it to work so instead of just setting the highlight colors I have to reset them all for each row whenever I load new data. Is there a better way to re-initialize the grid colors?Finally, is there any wa

There was an SQL optimization error in 3.4.7 caused by using wildcard characters in your WHERE clause. This build fixes it. If you want this latest version, please contact D3 support and we'll get it to you.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

We ran into this recently and I thought I'd share. In the legacy/character version of our software, we normally prompt for dates using a two digit year (mm-dd-yy), iconving and oconving as needed.  Recently, a user entered "12-31-33" as a date.  The iconv returned -12418 (12-31-1933) rather than the expected value of 24107 (12-31-2033).  After researching this we discovered that Pick/Rocket and QM both default to dates entered with 2 digit years greater than 30 to be in the 1900's, years less than 30 as assumed to be in the 2000's  Note: iconving a date with a 4 digit year always returns the correct value..  QM does have a config setting that will allow you to override the cutoff, however rather than remembering to change the config setting every few years on every user system, we opted to add code to our legacy system that checks the iconv'ed value and adjusts it as needed.------------------------------Ben CramerOwnerDealer Solutions LLCMansfield TX US------------------------------

We ran into this recently and I thought I'd share. In the legacy/character version of our software, we normally prompt for dates using a two digit year (mm-dd-yy), iconving and oconving as needed.  Recently, a user entered "12-31-33" as a date.  The iconv returned -12418 (12-31-1933) rather than the expected value of 24107 (12-31-2033).  After researching this we discovered that Pick/Rocket and QM both default to dates entered with 2 digit years greater than 30 to be in the 1900's, years less than 30 as assumed to be in the 2000's  Note: iconving a date with a 4 digit year always returns the correct value..  QM does have a config setting that will allow you to override the cutoff, however rather than remembering to change the config setting every few years on every user system, we opted to add code to our legacy system that checks the iconv'ed value and adjusts it as needed.------------------------------Ben CramerOwnerDealer Solutions LLCMansfield TX US------------------------------

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

I don't understand how MVIS pooled license work. Can I assume that a single pool license can hold a certain number of user licenses for use with MVIS out of all of the user licenses on the system? If I have a single application on my server does it only require a single pooled license? What if for some reason my API call takes longer than expected, does that prevent other users from connecting to MVIS site?How can I calculate the optimum number of pooled licenses I need to effectively run my new MVIS system?Jon

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

if not is there another way to handle moving files from one OS to anotherthank you dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

I'd like to use Adds Viewpoint enhanced, it works well with my application except - when my application switches from 80 to 132 column mode, it changes the emulation to VT100.  I haven't found the right place to tell me how to fix this.TIA,Bruce------------------------------Bruce AckmanVice PresidentLewis Supply Co IncRichmond VA US------------------------------