Rapid Insight Inc. - Veera 4.x Change Log

Change Log

Version 4.3.17067.0 [March 8, 2017]

Fixed 3324 - Margins default to 1" when you uncheck "use default settings" on a report section in PDF, .htm and .mht formats.
Fixed 3325 - Duplicate add-in node in second assembly causes meaningless error in log file
Fixed 3329 - Can't run Common Jobs from command line
Fixed 3326 - Veera Pro & Enterprise does not offer the new Managed Driver for Oracle
Changed 3335 - Null terminators in text fields should be removed by the TRIM cleanse or the RTRIM transform function
Fixed 3337 - Filter using DOES NOT START WITH condition fails if the data length is shorter than the character length of the fixed value being compared
Changed 3342 - The SAS driver should be allowed to use the combine inputs node
Fixed 3343 - Cleasing a sorted column before another node that sorts that column breaks the sort
Fixed 3354 - RProject node can leave temp files behind if running a time consuming script

Version 4.3.16309.0 [November 4, 2016]

Fixed 3294 - Native XLSX driver somtimes skips reading a row if the entire row is null
Fixed 3302 - Get Values are identifying (empty), appearing instead of (null). Acting more like a blank space, than a missing value
Fixed 3305 - Previewing a job containing a ReverseTransposeNode sometimes produces an error
Fixed 3299 - Rename/Exclude node breaks when attempt is made to swap column names
Fixed 3314 - Parameters will not replace all instances of the parameter within the same string of text
Changed 3307 - The "Delete User" function in Veera Enterprise Manager should offer an opt out when asked whether to port data to another user
Added 3306 - Veera Enterprise updates should also back up the ProgramData folder as part of the process
Changed 3173 - Veera Server - Enterprise Manager: The prompt to confirm to delete a user should also note that the option to migrate data will follow.
Fixed 3316 - Setting the Type Guess Sample Size user option to a very large number can cause the Text File Schema Windows be be unusable

Version 4.3.16271.0 [September 27, 2016]

Fixed 3274 - Date and Datetime fields cannot be filtered upon if Windows localized date format isn't understood
Added 3291 - Add a built in driver for Oracle to replace the old deprecated Microsoft Provider for Oracle
Fixed 3283 - 64 bit version crashes when starting in some environments
Fixed 2339 - Veera Enterprise Server unnecessarily logs finding the license file, and it does so very frequently, when there is actually a license validation error
Fixed 3278 - Setting Job Schedule Status to Suspended results in that Schedule no longer accessible thru Veera.
Added 3286 - Add a built in driver for SPSS

Version 4.3.16235.0 [August 22, 2016]

Fixed 3226 - Control characters in text columns output to a XLSX file cause the file to be corrupted and completely unreadable in Excel
Added 3232 - New add-in parameter type for a list of column names
Added 3219 - Ability to add new item to a bin without having to reselect all old items
Fixed 2417 - Transform Binning Issue
Fixed 3243 - IsMissing checkbox not always disabled when it should be in binning transform tab
Changed 3239 - Typo on the Veera "Lock License to Hardware" screen
Changed 3065 - StopJob leaves busy bars running
Fixed 3245 - XLS Connection displays weird characters when reading very old formats of the Excel file specification
Fixed 3100 - Stop job node producing 'Job tried to open the node multiple times simultaneously' error in some cases
Fixed 3254 - Excel driver doesn't always show true column names
Added 3252 - Allow /runjob from command line in Veera Pro and Enterprise editions by adding /OSLogon and /Logon parameters to specify the user credentials
Added 3267 - Database sort optimization validation

Version 4.3.16169.0 [June 17, 2016]

Fixed 2369 - MergeNode throws an error when you have duplicate output column names
Fixed 3102 - The job details pane on the Workspace screen does not update after the program opens
Fixed 3181 - Imported jobs have their names truncated when importing directly from outlook in 64 bit Veera
Fixed 3180 - Unable to import an exported transform definition containing Bins
Fixed 3182 - Binning is inappropriately assigning seconds to a Datetime field.
Fixed 3175 - Rename asks if you want to Continue and lose all changes when attempting to save and exit
Added 3196 - New CONCATENATE transform function for concatenating text fields
Added 3195 - New SUM transform function for adding numeric fields
Fixed 3208 - MergeNode in some cases won't report it's sort information to nodes following it

Version 4.3.16116.0 [April 25, 2016]

Fixed 3134 - The 'Flush All Caches' menu item does not flush cache nodes in subroutines.
Fixed 3137 - SQLCommandForEach fails to run if the pre or post commands are empty.
Changed 3107 - When run a job and it prompts for parameters, canceling the prompt window does NOT cancel the run of the job as it should.
Added 3116 - Add Move Up and Move Down buttons to Selection Rule(s) box of DeDup Node.
Fixed 3149 - Wrong permissions on CLSID registry subkey prevents Veera from finding OLEDB providers listed after that key due to security exception.
Fixed 3141 - Filter Node not allowing Add Filter of operator 'Expression' with expression of 'Today'.
Fixed 3077 - Closing a Preview Data window after start running the job will terminate the run when it shouldn't.
Fixed 3158 - SFTP can cause the app to hang if wrong credentials are entered.
Fixed 3162 - The FTP node is unable to correctly parse SFTP credentials containing certain symbols.

Version 4.3.16071.0 [March 11, 2016]

Fixed 3113 - Custom scripts can become stuck in the RProject node which will be continued to used when the job is run
Fixed 3117 - 32-bit floating-point values do not get converted propertly
Fixed 3115 - Spelling error in TransformNode
Fixed 3101 - The 'What Is This Node?' for Set Parameter node does not link correctly
Fixed 3122 - The RProjectNodeWindow parameter highlights are misaligned sometimes
Fixed 3097 - Default values rather than actual values are loaded when editing time-related Bins
Fixed 3111 - CTRL+C to copy and then right-click, select Paste, the nodes are NOT pasted where the cursor is
Fixed 3083 - Filter node doesn't ask if you want to save changes wth certain expressions
Fixed 3127 - In some cases MergeNode can fail to merge a row if joining on a field with trailing spaces
Fixed 3098 - Running the job to get sample values can result in dup values
Added 2968 - Add sorting and searching ability to the "Show Unique/Distinct Values" popup in the Data View window

Version 4.3.16039.0 [February 8, 2016]

Fixed 1844 - Job needs a way to delete the cache for a deleted node
Added 2817 - Add drag-drop support to help simplify connection creation
Added 2783 - The ability to compute a parameter value within a job
Added 3078 - Should be able to list parameters used for the job run in an output or report
Added 2109 - Need a "Remove All Occurances" cleanse to cleanup text column data by removing spurious clutter
Added 2714 - Ability to re-order cleanse operations
Added 2920 - Incorporate a cleanse function that will replace personally identifiable data with obfuscated content
Added 2970 - Prompt to save current work when closing the cleanse node
Added 3082 - Add a text trim cleanser to the CleanseNode
Added 2060 - Highlight variables affected By cleanse
Changed 3079 - Signal which rows have a checked checkbox in grids, like Rename/Exclude, Output, and Input Nodes, by shading the text or background of the entire row
Added 3090 - Add EBCDIC as a support text file type
Added 2850 - Allow users to add semi-transparent highlighting boxes to jobs
Fixed 3089 - A Job that finishes with a success but with node warnings gets treated as failure
Added 2679 - User should be able to request the job be run to Get Values in Cleanse, Filter, Transform, CrossTab, and Transpose nodes

Version 4.3.16014.0 [January 14, 2016]

Fixed 3058 - StopJob, Model, R Project Command, and Compress nodes can't be added to a job from the Node Add Runable Menu
Added 3059 - Add support for MySQL 5.2+ ANSI and Unicode ODBC drivers
Added 2107 - Add a standalone SQL Command Node to issue commands to a database (ex. CREATE TABLE or DELETE * FROM ...)
Fixed 3057 - Veera Enterprise Server firewall rule is incorrect for Windows Server installations
Added 2255 - Enable Users to UPDATE db table fields - SQL Command For Each node
Added 2879 - Desire a SQL Command node so that can build statements to do custom inserts, updates, or deletes
Added 3037 - Veera should display dates, times, and numbers in the current Windows culture to be 'internationally' standard
Added 3064 - SQL Command should be able to be canceled when user cancels the job
Added 3063 - SQL Command For Each should have a separate post failure command
Added 3066 - Make it so a diabled StopJob node has no effect when it is in a daisy chain
Added 3067 - Make it so a diabled SQL Command For Each node has no effect when it is in a daisy chain
Fixed 3068 - Exception when reading in a text file when line ends in a single text delimiter
Added 3069 - Date, Time, and Datetime functions in Transform should be able to take numbers for each part
Added 3073 - Publish reports to RapidInsightOnline.com
Fixed 3062 - Veera Enterprise was not setting the firewall rules during install
Fixed 3076 - Publishing a report to RapidInsightOnline.com doesn't use the parameterized filename

Version 4.3.15359.0 [December 25, 2015]

Added 3038 - Allow parameters in Command Node
Fixed 3048 - The default color Rapid Caerulean is missing from styles and report nodes when job is reloaded
Fixed 3049 - Runable add-in nodes do not see updated parameters until job is saved and reopened
Changed 3054 - Better support for reading .XLS files generated from other applications, not Excel
Changed 3056 - CallJobForEach node menu item is missing its icon

Version 4.3.15342.0 [December 8, 2015]

Fixed 2985 - Clean install puts the auto created connections under folder "other"
Fixed 3007 - CTRL+A in a job doesn't select floating notes
Fixed 3017 - Cloning nodes using the ctrl shortcut places them in the wrong location
Changed 2988 - The description for the Transform function CharIndex needs to be corrected
Fixed 2998 - When deleting a job from the workspace there should be a prompt
Changed 2994 - Parameter window does not reflect size of parameter columns
Added 2421 - Add the ability to enter a hexidecimal color code instead of selecting a color by name
Fixed 3028 - In options, the Tab button doesn't correctly 'tab' through the selections
Fixed 3022 - Text files (txt, csv) files with rows containing more than 32kb of data do not read in correctly
Fixed 3026 - No warning for including multiple output proxies in a job when pasting
Added 3029 - Ability to get a trial license directly from new install of Veera like Analytics can
Added 2816 - Hover over Transform to view entire formula
Added 2577 - Limit Veera to open only one copy of the same job at a time
Changed 2083 - The New or Clone Existing option at the top of the Output Table node should be hidden
Added 1927 - Ability to upload reports to a cloud dashboard

Version 4.3.15301.0 [October 28, 2015]

Fixed 2990 - Add-in nodes with non-string parameters are no longer able to be created or used
Fixed 2987 - Transform asks if you want to save changes to current operation if you choose to save and exit despite not making any changes
Fixed 2980 - When double clicking on a job folder in the workspace it sometimes opens a job in that folder
Added 3001 - Add Coalesce function to transforms
Fixed 2989 - Job name in workspace and job name in properties and what is shown as the job name in the job tab can be out of sync
Added 2721 - Merge Node - the ability to add fields to the output columns list by using the enter button
Fixed 2955 - Cloned nodes get placed in the background

Version 4.3.15274.0 [October 1, 2015]

Added 2832 - Ability to run a scheduled job from the scheduler window
Changed 2938 - Outputting to SQL can be slow
Changed 2391 - Validating a job with a missing add-in node will mark all prior nodes as Dangling, even when they have no issues
Added 2427 - Warn a User that they are closing a TransformNode before applying pending updates
Fixed 2538 - A XML output fails to run when a datetime column has nulls in it
Fixed 2956 - Run job issues with a TransformNode after a ReverseTransposeNode
Fixed 2958 - CallJob and Subroutine nodes do not retain parameter settings after importing and correcting attached job
Changed 2854 - The timestamp and main title overwrite each other in Excel reports
Added 2748 - Aggregate - show calculations in red when a variable is removed from input
Fixed 2967 - Ranking node skips ranks sometimes when "same rank for ties" with a "Group By" condition
Changed 2969 - TransposeNodeWindow does not indicate a transpose column type has changed
Changed 2971 - DeDupNodeWindow does not indicate when a Selection rule column has changed types
Fixed 2966 - Upgrading the Veera Enterprise Server resets the service credentials to their default
Fixed 2975 - Filter optimization fails on MySQL when using a contains filter operation

Version 4.3.15244.0 [September 1, 2015]

Fixed 2856 - Under certain conditions, editing one Transform formula is reflected in another
Changed 2861 - A .csv file where the last row doesn't have the row delimiter drops that (partial?) row from the input
Added 2805 - Add the filtering operators 'Does Not Start With' and 'Does Not End With'
Fixed 2726 - Parameter name length affects ability to perform a 'Starts With' filter
Added 2646 - Make Job Parameters and Date Stamps accessible to filename parameters of the AddInNode
Fixed 2865 - The column option Show Unique/Distinct Values in Data View tabs don't work
Changed 2674 - Chart node data and axis titles fonts should be separated
Fixed 2885 - Users may intentionally/unintentionally edit the password and gain access to an existing Veera Enterprise client account
Added 2827 - When Users are removed from the Veera Enterprise Server, allow other items (connections, scheduled Jobs, and user settings) to be optionally transferred as well
Fixed 2670 - Cleanse node stays on selected variable, but overwrites the last cleanse rather than creating a new cleanse
Changed 2482 - View Report command often displays the wrong copy of the report when a parameter is incorporated into the file name
Changed 2490 - Stop Node does not stop the creation of most output files/reports
Fixed 2745 - DeDup error when using a variable that changed lengths
Fixed 2744 - Transpose does not recognize variable length change
Fixed 2442 - Aggregate reporting error when variable names change case
Fixed 2871 - Deleting all output columns in a merge while editing an output column name causes an error
Added 2902 - Display a Confirm Delete pop-up when deleting a saved Transform formula
Added 2918 - With multiple monitors VeeraClient starts on main monitor to logon before moving to last used monitor
Added 2266 - Develop a new node that would act as a Reverse Transpose
Added 2546 - Allow the use of a parameter in the 'Distributions to Send To' field
Added 2527 - HotKey for saving and exiting nodes
Fixed 2924 - Call Job For Each does not allow you to change input value
Added 2739 - Ability to locate/move to nodes with errors in large jobs
Added 2574 - Type Convert should allow you to multi select formats as well
Fixed 2929 - Excel driver issue with all columns in a .XLS showing up as text
Fixed 2934 - Job run from command line can cause licensing window to appear thus fails when run by Task Scheduler
Changed 2940 - The GetTextFileSchemaWindow visual issues
Added 2797 - Add a TitleCase function to the Transform Node
Fixed 2919 - SubField Transform function issue

Version 4.3.15168.0 [June 17, 2015]

Fixed 2571 - Incorrect marking of node change when only node note changed and undone
Fixed 2824 - The Job Details slider on the Workspace tab retracts automatically whenever the program is minimized
Added 2088 - Oracle has a way to insert multiple rows simultaneously to "bulk load" data, Veera should use it to speed up OutputNode
Added 2788 - Auto-scroll the Jobs Workspace view when dragging icons into a new position
Changed 2828 - Cursor image of dragged nodes do not display correctly when window is scrolled
Changed 2829 - Dragging in between task buttons can result in odd behavior
Fixed 2566 - It is possible to define an Excel connection to a folder NOT on the available folders list by typing in the path
Fixed 2833 - Large log entries will cause an error in Veera's log file viewer
Added 2834 - Add support for the newer MS Access ODBC driver
Fixed 2363 - Veera Server install doesn't set service recovery option on Windows Server 2008 R2

Version 4.3.15147.0 [May 27, 2015]

Changed 2778 - Remove Import Clustering Model wizard, replaced with standard RITD transform definition file
Fixed 2784 - It is possible for the job details pane in the WorkspaceWindow to become so large that it can't be resized
Fixed 2799 - Synchronization with Analytics 3 is missing a case, thus occassionally causing an exception in the opposite app when a connection is edited
Fixed 2800 - Abandoned mutex exception will cause Veera to exit, thus re-abandoning the mutex, so can never get Veera to run
Added 2801 - GreatestIndex and LeastIndex functions added to transform
Changed 2802 - Transform import/export and get/put fron RICC all updated to use format compatible with Analytics 3

Version 4.3.15128.0 [May 8, 2015]

Changed 2746 - TDE Node can only read existing files
Changed 2751 - Misspellings in the function definitions in the transform node
Fixed 2755 - When Veera Pro or Enterprise service is running it prevents Analytics 3 from starting on same system
Added 2760 - Add support for Amazon Redshift
Fixed 2759 - Veera license validation fails after installing Analytics 3 with non-beta license on same machine
Fixed 2762 - DeDup node if use in invalid job where it is opened multiple times simultaneously fails with a different error message (which isn't helpful) than other nodes
Fixed 2763 - Cleanse node does not complain if a cleanse column changes type
Added 2747 - Transform node formula window has no scroll feature
Fixed 2764 - Transform with [_] or LAG() function will have different result followed by a filter (or sort) when optimized vs not

Version 4.3.15107.0 [April 17, 2015]

Fixed 2659 - A Report with an empty table cause an error.
Fixed 2686 - A cache node is slow sometimes.
Fixed 2699 - The merge node can't open or explode in some cases and has to be rebuilt
Fixed 2702 - Creating a transform with an excessively long summary causes the transform list to display as a red X
Fixed 2695 - Aggregate shows no errors when aggregating by a field that has since changed types
Added 2200 - Allow Table Name Patterns to use Parameters in the COMBINE INPUTS node
Fixed 2725 - RProjectNode can't run scripts within the node without saving first
Added 2716 - LAG function for Transform
Added 2588 - Would like a way to purge all persistent CACHE nodes in a job
Added 2673 - Paramater Prompt should have a save and exit option
Added 2735 - Allow cell editing in the addin node for file parameters
Added 2253 - Add an "Is Not Missing" operator to Cleanse Node
Added 2736 - Add modes to CombineInputs on how to handle the schema: fixed, extendable, and dynamic

Version 4.3.15042.0 [February 12, 2015]

Changed 2602 - The load time for large jobs could be improved.
Fixed 2603 - Connection lists can become empty

Version 4.3.15036.0 [February 5, 2015]

Fixed 2591 - Distributing Timestamped Reports gives an error if the time stamp differs from start to finish
Changed 2593 - Better detection of the location of Rscript.exe in RNode
Fixed 2597 - ReportNode shows empty name in Source Section combobox for source coming from a JunctionNode
Fixed 2595 - The JunctionNode blocks chart information from being passed
Added 2573 - Type Convert from Integer to Text needs more formatting options
Fixed 2561 - Subfield Count formula in string functions tab asks for the string expression as a parameter
Fixed 2544 - Scatter Chart does not display x-axis scale
Changed 2598 - Scatter chart's default series labels are vague, where all other charts identify the source columns.
Changed 2596 - Chart Nodes convert missing values to zeros, distorting line plots
Fixed 2594 - The Output Table node Worksheet field will alternately accept, then not except, parameters
Added 2287 - Ability to turn off gridlines in Chart Node by setting the Grid Color to transparent
Added 2600 - Call Job For Each node should be able to continue calling the job even if an error occurs during a call.

Version 4.3.15023.0 [January 23, 2015]

Fixed 2589 - Report Node does not save changes to font selection
Fixed 2590 - User list file upgraded to a new file format in prior release is not being saved

Version 4.3.15019.0 [January 19, 2015]

Fixed 2578 - SubroutineNodeWindow fails to work properly after the node was configured and the job was exported and imported.
Fixed 2579 - When emailing a log file an error is shown every time.
Fixed 2583 - Unable to import scoring model from Analytics 3.
Fixed 2584 - Analytics 3 logistic scoring model creates a 'Score' variable where Analytics 2 created 'Probability'.
Fixed 2585 - Junction node can only be run once, then job has to be closed and re-opened.
Fixed 2586 - Junction node in job causes it to be changed immediately after opening the job, so always prompts to save the job.
Added 2581 - Allow users to rearrange the order of parameters.
Breaking Change 2587 - User list and Connection list now stored in binary encrypted file. Once this version of Veera is run, you can no longer use prior versions.

Version 4.3.14339.0 [December 5, 2014]

Fixed 2552 - Creating a new data connection sometimes results in multiple copies of the same connection appearing in the "Data Connections" window
Fixed 2520 - When Integer values are converted to Real values no values are shown in the filter and other nodes when Getting Values
Fixed 2554 - RenameNode not able to open
Added 2557 - Add Cube and CubeRoot to VRE node
Added 2559 - Add provider.config support for Teradata Aster
Fixed 2562 - Veera jobs respond to prompted Parameter Values only the First Time through
Added 2563 - Quantile node not functioning directly from SQL table input
Added 2568 - Add support for importing Analytics 3 scoring models
Added 2569 - Add a Junction Node that helps with job layout by allowing flow lines to be forced through a location, but had no impact on job run because the node does nothing
Fixed 2565 - An Excel connection made to the root of a drive is unable to find any files
Fixed 2567 - Some XLS files can't be opened by RI Excel provider
Added 2575 - Add provider.config support for Splunk ODBC driver.
Added 2545 - User should be able to create a manual server folder entry in Veera Enterprise Manager.

Version 4.3.14265.0 [September 22, 2014]

Added 2529 - Add support for Vertica 6.1 ODBC driver
Fixed 2531 - Salesforce's connection testing always succeeds
Fixed 2533 - Opening Jobs with bad existing data connections will not allow floating notes to be displayed
Fixed 2537 - Veera Node deletion bug
Changed 2536 - Dropped cube and cubed root as variable transformations in the VRE node
Fixed 2534 - Excel Connection can't read columns with quote chars in them.
Fixed 2543 - Cache nodes can not be read from if they cached 0 rows.
Fixed 2547 - Job run results in a "Object Reference not set to an instance of an object" in the merge node
Changed 2550 - Upgrade TextFileSchema reading and writing
Added 2551 - New users should have a sample job with connection available to them.

Version 4.3.14203.0 [July 22, 2014]

Changed 2522 - The move variables up and down buttons in the transform control have the wrong tooltips
Fixed 2523 - For some users the Veera 4.3 user list upgrade fails, causing logon to fail. Workstation closes and Client notifies user.

Version 4.3.14202.0 [July 21, 2014]

First general release of Veera 4.3
Breaking Change User list and Connection lists moved and encrypted to be compatible with forthcoming release of Analytics 3.0

Fixed 2501 - Working in the TransposeNode can cause the app to crash
Fixed 2503 - HTML reports do not create an initial file when first constructing.
Changed 2507 - Log10 is statistically equivalent to Natural Log for modeling so don't need both choices; Log10 takes longer to calculate so drop it.
Fixed 2508 - Model Node fails to build a model whenever Backward stepwise actually removes a column from the model.
Fixed 2511 - Including an unrelated column in VRENode is causing the best fit transfrom to be created even though the checkbox option is to only create related transforms.
Changed 2510 - RI Excel Driver interprets columns as boolean when using a boolean cell style even though data is not boolean
Fixed 1840 - ScheduledJob can't get owner's name
Fixed 2127 - Connection list presented in OutputNode are all input connections
Added 2146 - Additional TransformNode functions Average, DateFirstOfMonth, and DateLastOfMonth
Added 2499 - New TransformNode function SubFieldCount
Changed 2518 - Encrypt connection lists
Added 2435 - Close All Jobs Feature
Changed 2496 - Zip Code function does not fix hyphenated zips
Fixed 2497 - CallJob nodes do not retain parameter settings after importing and correcting attached job
Added 2498 - New Date Format
Added 2515 - Transform feature that allows you to rearrange assigned variables in the Multi-Variable Formula tab
Fixed 2516 - Unable to save an edited filter when a parameter no longer exists and no prompt shown
Changed 2517 - Change Node Rename to be more like Windows icon rename
Added 2416 - Sort the Group By output on the data columns as well
Added 2502 - Need a way to use a data source to set parameters for a CallJob node and call the job for each record (aka CallJobForEachNode)
Added 2519 - Add a Salesforce Connection

Version 4.2.14125.0 [May 5, 2014]

Fixed 2092 - Merges on GUID column from SQLServer will be incorrect if any branch has optimized sort
Changed 2487 - Date, Time and Datetime transfrom functions are described as taking a string expression, but work on any type that is convertable to the desired type.
Fixed 2486 - Transform function Today() returns a DateTime with a midnight time, so fails compare to a true Date column which has no time portion
Fixed 2489 - ReportNodeWindow custom chart size issue
Fixed 2492 - Report Node 'use different color for negative numbers' has no effect on output.
Fixed 2493 - Heavily using the chart styles window (open & close often) will eventually lead to program becoming unstable and many features non-functional
Fixed 2495 - VRE Node for binary Y calculates a statistic for each categorical which can be off by 1; will cause F Value to be high and significantly so when category has a small Y sum
Changed 2500 - Updated EULA

Version 4.2.14042.0 [February 11, 2014]

Fixed 2474 - The Report node won't allow you to set manual column sizing.
Fixed 2473 - Records stored by a persistent CacheNode cannot be read using a View Data command.
Fixed 2479 - On the string functions tab in the TransformNodeWindow the subfield function won't allow you to put just a space in the P2 box.
Fixed 2481 - Excel provider is unable to read from worksheets with trailing spaces in the name.
Changed 2472 - Show existing ZipcodeLatitude and ZipcodeLongitude functions in Transfrom Node.

Version 4.2.13351.0 [December 17, 2013]

Added 2466 - Added support for TeraData databases
Changed 2468 - Update MS Office file format references to use current MS descriptions
Changed 2455 - Report section titles don't show up in some cases
Fixed 2453 - Veera MSI fails to install on non-English language editions of Windows
Fixed 2431 - ReportNodeWindow is unstable when over 100 reports are attached
Fixed 2467 - Scheduled job fails intermittently, logs do not indicate problem
Fixed 2454 - Veera fails to start on non-English language editions of Windows
Fixed 2458 - Report node manual column sizing does not show changes made to first column
Fixed 2465 - Non-optimized NOT IN operator is returning null values when optimized does not

Version 4.2.13295.0 [October 22, 2013]

Fixed 2420 - When an MSSQL data source is followed by optimized Filter node, the resulting script will fail under certain circumstances.
Fixed 2423 - Reports of Veera freezing up after extended use.
Fixed 2428 - Veera Runner can't open CallJob and Subroutine nodes.
Changed 2429 - Oracle data providers don't understand TIMESTAMP column data type.
Fixed 2434 - Unable to 'View Report' on a ReportNode.
Fixed 2430 - Veera Runner - Unable to save jobs to folders or with new names.
Fixed 2425 - Section Settings Unsavable in Report Node.
Fixed 2424 - Veera Enterprise Manager tab Server Folders does not allow users to remove references.
Changed 2437 - When outputting to an existing file in the output table you cannot see the entire file name.

Version 4.2.13240.0 [August 28, 2013]

Fixed 2413 - The CallJobNode doesn't close after selecting 'Save and Exit'
Fixed 2415 - The CallJob and Subroutine nodes do not save parameters properly

Version 4.2.13226.0 [August 14, 2013]

Changed 2366 - Parameters incorporated into report titles are displayed in single quotes
Fixed 2344 - Clipboard error when trying to perform a print preview
Added 2371 - Ability to format an integer to currency (without decimal)
Added 2305 - Make the Preview Data default values configurable by users
Changed 2381 - The flyover help on the parameter button in the Rename Node is wrong
Added 2376 - Add job run time limit
Added 2372 - Ability to justify (left, center, right) within a report node (groupby, crosstab, etc.)
Added 2383 - Veera Enterprise Manager should be able to view server logs same as Workstation.
Fixed 2388 - Add-in nodes don't show up if they don't directly inherit from VeeraAddInNodeBase, want to be able to subclass them
Fixed 2389 - If a custom Add-in Node causes an error during construction, some or all other Add-in Nodes in the same assembly may not appear either
Fixed 2379 - Veera Enterprise Clients cannot view the reports they've created
Changed 2387 - Dial Area in the chart styles doesn't show the value entered.
Changed 2382 - Manual tick values in the chart node do not show decimal values
Added 2393 - Add a password Addin Node parameter type
Fixed 2396 - Veera job display refresh issue when adding large Excel files
Added 2395 - Add ability to use Job parameters in the CallJob and Subroutine Nodes
Added 2380 - Require a version of Veera Runner that will work with Veera Enterprise
Added 2332 - Would like the Transform Node's "Substring" function to behave like SQL Server's function
Fixed 2401 - File not found warning on the output node with output create if the output file doesn't exist.
Fixed 2397 - When filtering on converted datetime variables if you 'Get Values' it shows datetime as original format rather than converted format.
Fixed 2400 - Veera Enterprise Server check for updates button immediately returns an "Unable to locate server" message
Added 2392 - Get Values from most recent Cache Node rather than the Input Node
Fixed 2390 - Veera Pro cannot be uninstalled without uninstalling the service from the command line
Fixed 2406 - Model Node does not create subroutine jobs in the correct subfolder on the Workspace tab
Fixed 2405 - Workspace tab not refreshed to display subroutine job created by the Model Node
Fixed 2398 - Must run the Enterprise install twice to update an existing install of Enterprise Server

Version 4.2.13189.0 [July 8, 2013]

First general release of Veera Enterprise and Veera Runner

Fixed 2316 - When update a contribution in Collaborative Cloud, if use minus toolbar button to remove attachment it isn't removed
Fixed 2317 - A Collaborative Cloud Contribution's history shows the same date for all actions even when occuring days or months apart
Fixed 2318 - Between Values filter will not accept a parameter as an acceptible entry on the first try, and has issues if parameter is empty
Added 2301 - The ability to store and fetch files on a Hadoop file system using FTP Node
Changed 2303 - Persist the variable(s) selected from the list in the Cleanse Node
Fixed 2321 - Race condidtion causes licensing issue sporadically on some machines
Fixed 2322 - RProject Node in some cases shows a false 'Not all of the parameter(s) are set' message
Fixed 2323 - Optimization Issue with DeDup Node
Fixed 2325 - Updating a Cleanse Node operation isn't always successful
Added 2326 - Display a Video Tutorials RoboHelp Page upon program open of new product installation
Added 2328 - Ability to cancel Find Relationships in VRE Node
Fixed 2329 - VRE Node can become unusable and require closing job if delete or disconnect the prior node
Fixed 2330 - Changing the Text to Category threshold after first Find in VRE Node doesn't take effect until job is closed (or modified before the VRE Node)
Fixed 2333 - Filer Node using a parameter followed by a second Filter Node will fail when could optimize filter
Changed 2071 - Make it so a StopJob node doesn't cause a Job Failed job status message
Fixed 2335 - Rank Node allows selecting multiple 'Rank By' columns in the GUI
Fixed 2336 - Job schedule type "Periodic with Selected Times" doesn't show any next occurances and never runs
Added 2334 - Support Hadoop Hive ODBC driver as an input provider
Added 2121 - Predictive Model Node
Fixed 2343 - Unable to add a Query Node from a table
Added 2341 - RProject Node custom user scripting ability
Added 2342 - Make RProject Node interactive
Fixed 2346 - Quantile Node sometimes produced incorrect values when sorting was optimized with other nodes between Input and Quantile
Fixed 2348 - Query Node gives false validation warning
Added 2299 - Add GUI support for Add-In Nodes' parameter types like FileName and ColumnName
Fixed 2349 - Unlike Merge Node the Lookup Node doesn't match string columns when the case or trailing white space is different
Changed 2350 - Allow Dial Chart to use negative numbers in it range (area), regions, and needles
Added 2345 - Create installs for Veera Client and Server (Veera Enterprise)
Added 2359 - Veera Client install should pickup the proper setting from the Veera Server install so client can communicate without manual configuration
Fixed 2355 - Using an & character causes display issues in node names and notes
Fixed 2356 - Unable to filter on columns with "WHERE " in the column name
Added 2358 - Veera Client should get its updates from its Veera Server
Fixed 1947 - Veera Client can't communicate at all with a Veera Server of different version number
Added 2360 - Veera Server install should create a firewall exception for the proper port
Added 2361 - Veera Server install should open app to add license immediately after a new install
Added 2364 - Recovering lost jobs can 'recover' jobs that still have owners
Added 2260 - Incorporate Parameters into the Rename Node
Added 2362 - Need a Veera Enterprise Management application to configure and manage Veera Server
Added 2337 - Would like to be able to set the default View Data sample size in Options
Added 2310 - Ability to format a percentage as a rounded number (without decimal)
Added 2230 - Allow users to override the auto-scaling of the chart axis to define a fixed scale in a chart style
Fixed 2319 - Veera failing to restore a backup
Added 1695 - Publishing Veera Jobs so they can be run without having a copy of Veera --- VeeraRunner!!!

Version 4.1.13074.0 [March 15, 2013]

Added 2274 - R Project Node to call R scripts for analytical analysis of data, returning results or report
Fixed 2286 - Addin's from the collaborative cloud don't download
Added 2289 - Add support for Interbase ODBC provider
Fixed 2290 - Connections that have a settable port number never shows a box to edit the port number
Fixed 2294 - Sort optimization fails with an empty transform
Changed 2295 - A text output with an integer column formatted to a SSN or Phone # results in a wrong schema so that reading the resulting out with get nulls even though the correct value is in the file
Added 2297 - Subroutine Node should disclose errors that occur within the subroutine used during a job run
Breaking Change 2315 - Allow Custom Add-In Nodes to have more specific data types for parameters, like File Name and Column Name.
NOTE: This will break all existing custom nodes! RI has updated all of theirs on the Collaborative Cloud.
Added 2298 - Expand error logging to include nodes found within jobs found in Called Jobs and Subroutines
Added 1601 - Browse remote in FTP Node
Added 2270 - Allow users to change data types in the Append Node
Fixed 2306 - Misc. Items from the collaborative cloud can not be downloaded
Changed 2308 - Aggregate fails to optimize when used in a subroutine
Fixed 2214 - Custom stand-alone add-in node shows error when validate job
Added 2311 - Allow multiple selected check boxes to toggle with a focused check box in many nodes' windows
Changed 2313 - Call Job Node can permit access to other users' private jobs in a client/server configuration
Fixed 2314 - JobSampleWindow can give misleading feedback
Added 2291 - Add ability to read 837p EDI files and selectively flatten data

Delta 1 of Veera Client-Server

Version 4.1.13015.0 [January 15, 2013]

Fixed 2246 - Contains function does not work with MS Access providers when optimized
Fixed 2256 - Client Server users do not get messages if the server isn't licensed
Fixed 2257 - Aggregate fails optimization with Standard Deviation on some providers
Fixed 2259 - Get Values in the Transpose node window can cause an 'object reference' message
Added 2250 - Add support for PostgreSQL database
Changed 2267 - VRENode Edit menu has Move Up and Move Down choices that do nothing
Added 2268 - VRE node window Edit menu has Check All and Uncheck All choices, but no way to put all back to 'default' state
Fixed 2272 - Seeing an "object reference not set to an instance of an object" message in the VRE node window when trying to find related
Added 2275 - Show R (correlation coefficient) in the VRE node
Changed 2276 - In VRE node make calculating ChiSquare optional and NOT the default for Binary Y variables
Added 2277 - Add support for SAP HANA database
Fixed 2278 - Bulk Cleanse of boolean columns gets an error and create only one cleanse operation
Fixed 2263 - Cannot apply new licenses that have VRE enabled
Fixed 2283 - Manual Ticks in Chart Style Editor aren't working
Fixed 1967 - In Transform when binning a field it sometimes does not allow an exclusive Is Missing option
Fixed 2264 - "Exploded" Merges have all their joins replaced, regardless of type, with inner joins
Fixed 2249 - MySQL data sources produce an error when attempting to populate a report that is configured to be distributed by email
Fixed 2282 - Application freeze when importing a scoring model
Fixed 2273 - The Test SMTP button tests the connection from the vantagepoint of the Veera Client rather than the Veera Server
Fixed 2262 - VRE node not enabled by Veera Trial License
Added 2245 - Ability to sum Time columns in Aggregate node
Breaking Change 2261,2284 - License validation fails (when domain controllers replaced)
NOTE: Some, not all, domain machines will start failing license validation after this update and require RI Support involvement

Gamma 6 of Veera Client-Server

Version 4.1.12254.0 [September 10, 2012]

Changed 1667 - Options for null row/column in CrossTab window
Changed 1720 - Non-alphabetical group ordering in Crosstab
Added 2237 - Add another SSN format that does not use dashes
Fixed 2238 - MySql has issues showing text values in the data view window
Fixed 2239 - User's job unable to use a CallJob node to call a common (shared) job
Changed 2240 - Add ability to allow transform created variable to be used in the CrossTabNode's column variables
Fixed 2241 - Excel file names stored in a Source ID column created by a CombineInputs node do not appear correctly when using the Get Values function
Fixed 2242 - CombineInputs fails to provide a sample value list
Fixed 2243 - Sampling values from CombineInputs node's created or modified date columns returns the table names

Gamma 5 of Veera Client-Server

Version 4.1.12241.0 [August 28, 2012]

Added 1627 - Ability to change the order of the job and other tabs
Added 2216 - Ability to 'tear off' job and other tabs
Added 2206 - Add editable job descriptions to the workspace area
Changed 2145 - Formatting in CrossTab is not inherited by sums
Added 1934 - Desire more Standard text formats to be available, like SSN, Phone, etc.
Added 2059 - Allow users to edit TransposeNode's Transpose By values list
Fixed 2219 - Changing data source drivers sometimes disables Subroutines because of type mismatch when the InputProxy node was created from an actual InputNode
Changed 2224 - Better focus in the Collaborative Cloud search window
Fixed 2220 - Data being pulled from CHAR fields of SQL db can contain trailing blanks that will cause jobs to malfunction
Fixed 2221 - New license with VRE enabled will fail to install
Fixed 2225 - VRENode produces very wrong Chi Square value for some columns in some datasets
Fixed 2222 - Bulk Insert not working when the Max K Rows in Memory is set to default
Fixed 2227 - GetSampleValues doesn't work right after a CombineInputs node
Changed 2099 - Text in windows is distorted when Windows OS text size is set above default

Gamma 4 of Veera Client-Server

Version 4.1.12205.0 [July 23, 2012]

Added 2177 - Add support for "binary(8)" columns in SQLServer
Changed 2179 - Getting missing parameters message when Test an SQLServer connection
Added 2168 - Give Floating Notes the ability to select covered notes (bring to front)
Fixed 2178 - GroupBy node threatens to discard all changes when a field format is edited
Added 1942 - Automated mining / variable reduction wizard
Changed 2170 - Basic Ctrl+<key> commands do not work as expected when editing a node name or a floating note
Added 2186 - Adding source file identifier capabilities to CombineInputsNode
Added 1409 - Ability to save and restore transform definitions
Added 2169 - Set run order of runable nodes in a list instead of having to click through them all
Added 2174 - Auto backup when updating
Changed 2180 - Veera appears to hang when adding a lot of table connections simultaneously
Fixed 2187 - CSV table won't show columns after selecting and importing file format
Added 2140 - Add Parameters to the Excel folder, workbook and worksheet fields of the OutputNode connection
Added 2184 - VRE should be optional extra (upsell) to Veera license
Changed 2108 - Exporting a job should prompt to strip credentials from FTPNode just as it does for OutputNode
Fixed 2188 - Veera freezes when importing a format file
Fixed 2191 - FTP Node test connection fails for SFTP protocol
Fixed 2192 - FTP Node never finds file when polling and using SFTP, SCP, or HTTP protocol
Fixed 2175 - TransformNode showing only column names when opened
Fixed 2185 - New excel provider not guessing types well
Added 1944 - Need a "busy" window while Veera Client is looking for Veera Server
Added 2166 - Add a "View Data" option to the Cache node
Added 2173 - Want to be able to Quantile on descending values
Added 2035 - Add a Range option to the SampleNode
Added 2161 - Add a parameter option to the SampleNode's "N records to sample" field
Added 2194 - Allow View Data and Jobs in a seperate window
Fixed 2197 - Column created by Transpose is attempting to be optimized in a sort
Changed 2198 - If a node is brought to the front it should persist when the job is saved and re-opened
Changed 2199 - ChartNodeWindow won't allow a DialRange lower than 1
Added 2203 - Show Job ID and Created/Modified/Used times when showing job properties and details
Changed 2202 - Duplicate Oracle ADO.NET providers listed in the Providers.config
Fixed 2210 - Quantile Node is putting decending number of records in each quantile when preceeded by DeDup Node
Fixed 2208 - MySQL shows a changed data type error
Added 2183 - VRE Node
Added 2212 - Drag and drop between job windows
Added 2201 - RI Collabrative Cloud for sharing jobs, chart styles, and transforms

Gamma 3 of Veera Client-Server

Version 4.0.12093.0 [April 2, 2012]

Added 2163 - Add the operators to the bottom of the list of functions in the multi-variable transform
Changed 2158 - Update the Rapid Insight Logo found on the Help > About page
Fixed 2164 - Using the new XML provider, can't create a new XML output file
Added 2165 - Want to be able to use CombineInputs node with the new XML provider
Fixed 2154 - Schedule Viewer Occurences doesn't show dates for Selected Days & Times schedule type
Fixed 2171 - Multi select type change in the TypeConvertNode window shows text format options for all items selected
Fixed 2172 - Scoring Models (with excess white space in column names) imported into Veera produce all null scores
Added 2015 - DataView window improvements: key shortcuts, copy/paste cells, column context menu
Added 2091 - Add Import and Export toolbar buttons to the Chart Styles List window
Fixed 2167 - Job details panel gets job info while backing up/restoring
Added 2149 - Add XLS ability to the custom Excel provider

Gamma 2 of Veera Client-Server

Version 4.0.12060.0 [February 29, 2012]

Fixed 2159 - Can't Output to a table using new Excel connection, if specified workbook file extention is missing
Fixed 2160 - Get Sample Values feature does not work correctly with data input using the new Rapid Insight Excel & XML providers
Fixed 2156 - The Text File Schema window guesses the wrong type on dates since new Excel provider was added
Fixed 2162 - RenameNode window shows a "Continue and lose all changes?" when node is opened and then immediatly closed
Added 2150 - Add XLSB ability to the custom Excel provider

Gamma 1 of Veera Client-Server

Version 4.0.12047.0 [February 16, 2012]

First 4.0 general release

Added 1674 - TypeConvertNode should have the ability to convert multiple columns
Fixed 2031 - Charts misbehave when encountering NULL values in the numeric data
Added 2102 - Ability to put a transform formula into a job parameter so it will function, not come out as text
Fixed 2103 - SubroutineNode setup must be opened twice to view subroutine/data schema
Changed 2104 - Column widths in Preview Data output grid revert to default when view checkboxes are used
Fixed 2101 - Report labeling of charts is distorted under certain presentation conditions
Fixed 2105 - TransformNode outputs a null when a Datetime parameter is subtracted from a Datetime column
Fixed 2106 - New SQL Server bulk loading fails when any Datetime, Date, or Time columns are in the output
Fixed 2112 - Frequency Report does not retain changes to the default report settings
Fixed 2113 - A MergeNode with 3 or more joins will fail to Validate/Run if 2 Source flag columns are named the same
Changed 1921 - Output time columns as text to providers that don't have a time specific data type
Fixed 1762 - Some job data flow arrows are drawn wrong
Added 2095 - Alternitive node row count display: default is simple count, comma seperators and unit blocks (K/M/T) are new choices
Added 1930 - Add Clone choice in node context menu to duplicate drag drop copy functionality
Added 2096 - Permit users to clone groups of nodes within the same job
Added 1199 - Stop job button now cancels a bottom sample
Added 1656 - Stop job button now cancels ReportNode writing of report file
Added 1978 - Allow notes to be displayed floating in the job work area
Added 1498 - Stop job button now cancels a connection open if the provider is capable and configured to do so
Changed 1709 - Improve the look of Veera - Themes for interface - Menus and and context menus have icons - More transparency in icons - Complete rewrite of Job designer GUI: much faster, collapsable node toolbars, curved lines, gradient selection and disable, status icon now float outside node icon, multi-node drag and drop, multi-node cloning, hover over show notes/cache/error/status
Added 2120 - Allow Output Nodes to be chained (placed in flow of job as well as at the end)
Added 1759 - Permit use of Parameters in QueryNode
Added 1759 - Parameterized output file/table name
Added 2032 - Allow parameterization of Report title and section titles
Added 1817 - Implement Cut, Copy and Paste - can now copy or move node within and between jobs
Fixed 1997 - The 'Put each source in a separate report section' reporting option does not work correctly with RTF reports
Added 2072 - Add a "Prompt User for Parameter Entry" checkbox option to the Parameter setup window. A value is still required for situation where prompting can not be performed, such as a scheduled job
Fixed 2130 - Deeply nested functions in Transform seem to have a performance penalty compared to Transform based on another Transform
Fixed 2058 - Opening a CombineInputsNode while a job is running will cause the job to fail
Added 2116 - Custom Print/Save dialog for job printing and documenting
Added 1956 - CacheNode should remember sort status for optimizing sort when reading from cache
Changed 2027 - Overall job progress bar doesn't represent the state of the job when final runable if a ReportNode
Added 2118 - Ability to extend the life of a existing persistant cache
Fixed 2133 - CacheNode changes don't cause the node or job to be marked as modified
Added 2114 - Allow File > Save As to save the job report in XML
Added 1957 - OutputNode should record sort status for optimizing sort when reading same file with InputNode
Fixed 2136 - Exception in some CleanseNodes created by Imported Scoring Model
Added 2137 - Increase QuantileNode's maximum to 10000
Added 2037 - Provide a "Save As" option to the FILE > PRINT menu to send job information (printout) to a file
Added 2074 - Permit use of Parameters in FTPNode
Changed 2108 - Exporting a job should prompt to strip credentials from FTPNode just as it does for OutputNode
Added 1501 - Read and write XML files (with limitations)
Fixed 2128 - TransformNode's DaysBetween function does not work correctly with data type Date
Fixed 2144 - Help links from the toolbars for FilterNode and TransformNode are wrong
Added 2119 - Create a custom Excel data provider that will read and write XLSX files with proper data types
Added 2134 - CleanseNode does not allow replacements of Boolean columns
Changed 2152 - Job paths don't show in the SubroutineNode
Changed 2148 - Drop DI Upgrade from Veera Install

Older

The Veera 3.x Change Log is here.