Snap Updates, 2015

Owned by Aparna Tayi (Unlicensed)
Last updated: Sept 28, 2022 by Kendy Li
19 min read

In this Page

This page provides a history of incremental Snap updates for 2015.

Pipelines which are already started before a Snap update will continue to run with the older version of the Snaps. Only pipelines started after the new Snaps are deployed will run with the new Snaps.


For ultra pipelines, the currently running instances would continue to run with the older Snap packs. Editing and saving the task instance in Manager will cause a rolling restart of the ultra pipeline instances and the new Snap Packs will get picked up.

4.3.1

Live on production on 11/13/2015

Updated Snap Packs

Anaplan

Anaplan Write

  • Resolved an issue with Anaplan Write Snap's error handling in some cases producing inaccurate information.
  • Resolved null pointer exceptions in the Write Snap.
  • Server filename is now suggestible.
  • Migration impact: The output of the Write Snap is now a document instead of a string. Any pipelines using Anaplan Write along with a downstream Snap that is parsing the Anaplan Write output it will have to be reworked to use the new document map.

Binary

  • Feature: Enhanced File Delete Snap to support S3 protocol.
  • Resolved an issue with smb pathname failing when directory name contained a space.
  • Resolved an issue with a pipeline  showing as successful when writing to a project to which it had no access.
  • Resolved an issue with Directory Browser not returning any data when target files were not present. The option, Ignore empty result, now allows you to determine whether or not to output an empty document of no data is passed through.

Box

  • Resolved an issue with Snaps in this Snap Pack not being proxy-aware.

Flow

  •  Resolved an issue with the ForEach poll interval being inconsistent.

Google Spreadsheet

  • Improved performance of the Worksheet Writer Snap.
  • Resolved a null pointer exception in the Spreadsheet Writer Snap.

JDBC

  • New! Generic JDBC SELECT Snap
  • New! Generic JDBC UPDATE Snap
  • Feature: JDBC Snaps - add a new property 'Database name' to JDBC Account
  • Defect: JDBC Execute Snap fails in preview for Oracle timestamp data type
  • Defect: JDBC Insert to Snowflake throws an error
  • Defect: Generic JDBC Execute with JDBC4OLAP drivers to connect to Essbase resulted in com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Unable to parse content type: null

JMS

  • Defect: [JMS Producer] JMSExpiration header attribute is not being set
  • Defect: Improve Duplicate Ack Message
  • Defect: JMS Consumer with message count of 0 does not empty the queue
  • Resolved an issue with JMS Snaps failing when using SQS.

Oracle

  • Resolved a database access error occurring while iterating over table name result set with the Oracle Select Snap.

Redshift

  • Resolved a "Failed to close database cursor connection." issue in Redshift SCD2.
  • Redshift BULK Upsert Snap: Key columns and Tables name properties can now be evaluated from pipeline parameters

REST

  • Defect: REST GET Snap fails saying 'Scheme "http" not registered'

Salesforce

  • Defect: Salesforce Wave - please add a regex to restrict characters for dataset name (dash is not allowed)

ServiceNow

  • Defect: ServiceNow Query Snap does not return complete information when compared to the results of the same API call made outside of SnapLogic

SOAP

  • Resolved a null pointer exception.
  • Added thread safety to XML library to prevent Null pointer exception.

Splunk

  • Feature: Additional configuration parameters for the Splunk Writer Snap.

Transform

  • Defect: XML Generator failing with null pointer exception when simultaneous triggered task are executed
  • Defect: JSON Formatter Snap - fails to close JSON binary stream with closing bracket ']' when user stop the pipeline

Vertica

  • Defect: Vertica Account- Validation fails with in built Vertica jdbc jar file

Workday

  • Defect: Workday Read Input Using As Of Date/Time in Response_Filter
  • Defect: Workday Snap Does Not Show All Services

Fall Release 2015 (4.3.0)

Live on production October 24, 2015.

New Snap Packs

Cassandra Snap Pack

  • NEW! Snaps for Cassandra Execute and Select.

Azure Active Directory Snap Pack

  • Azure Active Directory Authenticate Users
  • Azure Active Directory Create Entry
  • Azure Active Directory Delete Entry
  • Azure Active Directory Get Group Members
  • Azure Active Directory Get Role Members
  • Azure Active Directory List Users
  • Azure Active Directory Manage Group Membership
  • Azure Active Directory Manage Role Membership
  • Azure Active Directory Search Entries
  • Azure Active Directory Update Entry

Updated Snap Packs

General

  • OAuth 2.0 Accounts updated to handle passing an access_token as an HTTP Header expression variable.

Active Directory Snap Pack

  • The Update Snap now populates all attributes during Suggest. The Search Snap now shows those attributes that have values.

Anaplan

  • Migration Impact: The Anaplan Read Snap now writes the Anaplan file data read into the binary output view as a stream. This was done to resolve an issue with the Snap generating all column values into a single column.

Binary Snap Pack

  • File Reader and File Writer now support Azure Blob as a file protocol. 
  • Support for specifying another Windows drive path added to Directory Browser, File Poller, Multi File Reader, File Reader, and File Writer.
  • File Delete no longer displays user credentials in error messages.
  • Resolved an issue with File Poller failing to properly determine directories versus files in an S3 path.

DynamoDB Snap Pack

  • NEW! DynamoDB Bulk Get
  • Resolved an issue with table names not showing in Bulk Write and Bulk Get Snaps. Thread count field added.

Flow Snap Pack

  • In Data Validator, the pattern option now works with partial matches.
  • Exit Snap 
    • Error handling improved to handle messages that are non-strings.
    • Exit Snap now supports expressions in the Exit error message property.
  • ForEach Snap now generates output documents when run. Output documents will also be produced if a child pipeline called by the ForEach is manually stopped.

Google BigQuery Snap Pack

  • Google BigQuery Execute:
    • Support added to allow the writing of large query results to a table.
    • Max result field removed.

Google Spreadsheet Snap Pack

  • Refresh Token added to Google Spreadsheet OAuth 2.0 account. If the token is not found, you can force the token refresh. To force receiving a new refresh token, change Approval Prompt to force, click the Authorize button, give consent to offline access in the browser, and confirm that you now have a refresh token. If you have any existing Google Spreadsheet OAuth 2.0 accounts, you will need to recreate them to get the refresh token.

JMS Snap Pack

JMS Consumer 

  • This Snap can now consume all messages in the queue and then stop by setting the message count to zero.

  • Resolved an issue that prevented multiple input streams.

  • Resolved an issue with JMS Consumer not closing its connection if called by a ForEach Snap in Fire and Forget mode.

  • Updated error message in JMS Consumer for invalid expression.

  • JMS Acknowledge now supports message recovery.

JMS Producer

  • This Snap can now be used in Ultra pipelines.

  • The error view is now a document view.

LinkedIn Snap Pack

  • Linked OAuth2 account no longer has Client-ID/Client-Secret hard coded.

Microsoft Dynamics AX Snap Pack

  • Validation added to Dynamics AX account.

MongoDB Snap Pack

  • Resolved an issue with an incorrect resolution displaying during account validation if the username was blank.
  • Resolved an issue in the MongoDB Find Snap with nested arrays.
  • Resolved an issue in MongoDB Find with data not being usable be other Snaps.

MySQL Snap Pack

  • Table List Snap: A new option, Compute table graph, now lets you determine whether or not to generate dependents data into the output.

Oracle Snap Pack

  • Table List Snap: A new option, Compute table graph, now lets you determine whether or not to generate dependents data into the output.
  • Oracle Bulk Load
    • Resolved an issue with a pipeline never completing.
    • Resolved an issue with pipeline statistics, bulk load summary statistics not matching and bulk load summary was confusing.
    • Maximum error count field added to set the maximum number of rows which can fail before the bulk load operation is stopped.
    • Mixed-case matching option removed.
    • Added error messaging to handle BLOB type data trying to be loaded to an Oracle table when not supported.
    • Resolved an issue with the record separator of the input file not being processed correctly.
    • Improved error messages for when data types do not match.
  • Oracle Stored Procedure: All accessible objects are now visible during design.

PostgreSQL Snap Pack

  • Ignore empty result added to Execute and Select Snaps. The option will not write any document to the output view for select statements producing no results.

REST Snap Pack

  • Two-way SSL support added to the REST account.
  • REST Get 
    • Now has support for iterating over additional result pages.
    • Header variables are now being updated for each input
  • REST Post
    • Improved error handling messages.
    • Resolved an issue with the Snap failing with "Failed to execute HTTP request" error.

Redshift Snap Pack

  • Table List Snap: A new option, Compute table graph, now lets you determine whether or not to generate dependents data into the output.
  • Redshift Unload Snap Parallel property now explicitly adds 'PARALLEL [OFF|FALSE]' to the UNLOAD query.

Salesforce Snap Pack

  • NEW! Salesforce Batch Create
  • Salesforce Wave ID field suggestions now include upstream schema.
  • Resolved an issue in Salesforce Lookup Snap failing to generate an output schema if more than 50 records are found.

SOAP Snap Pack

  • Resolved an issue in not being able to generate a complete Customize envelope.
  • Improved caching to help prevent execution failures.
  • Resolved an issue with incorrectly generating templates for custom WSDL files.

SQL Server Snap Pack

  • Table List Snap: A new option, Compute table graph, now lets you determine whether or not to generate dependents data into the output.
  • Resolved a "Cannot convert from 12345 (class java.lang.String) to class [B" issue in SQL Server Insert.

Transform Snap Pack

  • Excel Parser now has an Evaluate formulas option. Select this option if the cell-formulas are to be evaluated and results displayed instead of raw formulas.
  • Multi Join Snap
    • Enhanced to make the Left and Right path schema aware. 
    • Resolved an issue when attempting a join where one or both inputs are empty.

September 5, 2015 (4.2.2) 

New Snap Packs

Google BigQuery Snap Pack

  • NEW! Snaps for Google BigQuery Execute and Write.

Updated Snap Packs

Active Directory Snap Pack

  • Resolved an issue with the account failing to validate after the last Snap release.
  • Resolved an issue with the Active Directory Search Snap failing to throw an exception for an invalid search.
  • Resolved an issue with the Active Directory Search Snap not routing an error to the error view for a null search.
  • Resolved an issue with the Active Directory Search Snap adding a blank space on all strings.
  • Updated the tooltips within the Active Directory Snap Pack.

Binary Snap Pack

  • Resolved an issue with the ZipFile Read Snap failing to decompress a zip file.
  • Resolved an issue with MultiFile Reader not able to read UNC-syntax local files in Windows Groundplex.
  • Resolved an SFTP I/O error with File Read.
  • Resolved an issue in SFTP pooling when a large number of connections are opened for both pooling enabled and disabled.
  • Resolved an issue in File Poller where setting Polling timeout to a negative number below -1 caused the Snap to run forever.
  • Resolved an issue in AES Snap with 256 bit keys.
  • Resolved a file size issue in File Writer with the Dropbox FTP site.

DynamoDB Snap Pack

  • Resolved an issue with the DynamoDB Scan Snap throwing an exception if Total segments was provided.
  • Resolved an issue with the DynamoDB Scan Snap not returning the specified attribute names list if Projection expression was set to an attribute name.

Facebook Snap Pack

  • Snap Pack updated to work with the latest Facebook API.
    • Deprecated: FetchConnections Snap and UserDetails Snap are no longer supported in the current Facebook API.
    • Search Snap: Post is no longer a supported object type for search.

Flow Snap Pack

  • Resolved an issue in ForEach where a recursive pipeline in synchronous mode was unable to finish execution.
  • Resolved an issue in Data Validator not working for partial matches.

JDBC Snap Pack

  • Ignore empty result added to Execute Snap. The option will not write any document to the output view for select statements producing no results.

  • Addressed an issue with idle timeouts.

  • Resolved an issue in JDBC Execute throwing an exception, unable to get driver.

JMS Snap Pack

  • NEW! JMS Acknowledge Snap

  • JMS Consumer Snap's Message count property now accepts a variable parameter (script enabled).

  • Stopping a pipeline that contains a JMS Snap now shuts down its own listener.

  • Resolved a "Please file a defect" error when Control Destination was not given.

  • Resolved pipeline never stopping and retiring more than specified count, while passing count from upstream.

  • Resolved an issue with JMS Consumer sometimes reading more messages then specified.

  • Improved the error message presented when mandatory Control Destination is value is not provided.

LDAP Snap Pack

  • Resolved an issue with an incorrect error message displaying during account validation.

MongoDB Snap Pack

  • Username and Password are no longer required fields when creating a MongoDB account since it is possible to configure an instance where that information is not required.

  • MongoDB account now supports Mongo Java Driver 3.0.2.

  • MongoDB Find

    • Resolved an issue with MongoDB Find not properly supporting the expression language.

    • Resolved an issue with MongoDB Find returning "Current context not an ARRAY but OBJECT" for a deep nested ObjectId object.

    • Resolved an issue with MongoDB Find when data had built in datatype.

    • Resolved a null pointer exception in MongoDB Find.

    • Resolved an issue with MongoDB Find not routing failed documents to the error view.

  • Resolved an issue with MongoDB error handling when maximum number of documents reached.

  • Improved the error message presented when MongoDB database could not reach the JCC.

MySQL Snap Pack

  • Ignore empty result added to Execute and Select Snaps. The option will not write any document to the output view for select statements producing no results.
  • Resolved a Java exception in MySQL Merge Snap.

NetSuite Snap Pack

  • Snaps tested against NetSuite server version 2015.2.

OpenAir Snap Pack

  • Resolved an issue with the OpenAir account validating when an incorrect password was used against a locked account.

Oracle Snap Pack

  • NEW! Oracle Bulk Load Snap
  • Oracle Execute Snap: Columns now appear in the order of the select query.
  • Addressed a memory issue in Oracle Stored Procedure Snap.
  • Ignore empty result added to Execute and Select Snaps. The option will not write any document to the output view for select statements producing no results.

REST Snap Pack

  • Maximum retries and Retry interval support added.
  • Resolved an issue with using a REST Dynamic OAuth2 account with Facebook Graph API.
  • REST Account: REST SSL account added.

Redshift Snap Pack

  • Resolved an issue where Redshift SCD2 Snap historized the current row when no Cause-historization fields had changed.
  • Ignore empty result added to Execute and Select Snaps. The option will not any document to the output view for select statements.
  • Resolved an issue with Redshift Select Snap returning a Date object for DATE column data type instead of a LocalDate object.
  • Resolved an issue in RedShift SCD2 failing to close database cursor connection.
  • Resolved an issue with Redshift Lookup Snap not handling values with spaces in the prefix.
  • Salesforce Snap Pack
  • Resolved an issue the failing to validate the account if the password contained a colon (:).
  • Salesforce Snaps now default to the latest Salesforce API version.
  • Create/Update/Upsert Snaps did not support related object mappings.

Salesforce Snap Pack

  • NEW! Salesforce Batch Create
  • Resolved an issue with Salesforce Wave analytics throwing an error when metadata contained a hash symbol in number format.

SAP Hana Snap Pack

  • Ignore empty result added to Execute and Select Snaps. The option will not any document to the output view for select statements.

SOAP Snap Pack

  • Support added to return SOAP headers in SOAP Execute Snap.
  • Resolved an issue with SOAP Execute being unable to interpret MTOM response SOAP responses.
  • Migration impact: Output SOAP Envelope now defaults to false.
  • New setting: SSL Protocol

SQL Server Snap Pack

  • Ignore empty result added to Execute and Select Snaps. The option will not write any document to the output view for select statements producing no results.
  • Resolved an issue in the SQL Server Lookup Snap not handling values with spaces in the prefix.

Transform Snap Pack

  • NEW! Multi Join Snap. This streaming supports joins of two or more sorted data streams.
  • Sequence Snap now supports pass through.
  • Resolved an issue where the Excel Parser Snap always returned the header from the first sheet for all sheets if the Excel file format was the older .xls format. Additionally, Improved the error message when the sheet given does not exists.
  • Sort Snap: Null greater option added to let you indicate if null values should be treated as greater than non-null values when sorted.
  • Resolved an issue with the Aggregate Snap failing with a null pointer exception.

Twitter Snap Pack

  • Updated messages within the Snap Pack.

Vertica Snap Pack

  • Improved error handling for Vertica Bulk Load Snap.
  • Resolved a syntax error in Vertica Bulk Upsert.
  • Resolved several failures in the Vertica Insert Snap.
  • Resolved a "No column values found" error in Vertica Bulk Load.
  • Resolved a issue in Vertica Insert with Boolean values of "t" and "f" being inserted as null.

August 7, 2015 (2015.25/4.2.1)

Active Directory

  • Resolved "Pass through only supported for Map data." message showing in Active Directory Rename Snap.

Anaplan

  • Anaplan Write:

    • Resolved an issue with the Anaplan Write Snap skipping the first row.

    • Resolved an Anaplan Exception when writing from a database to Anaplan.

    • Resolved an issue with requests routing to error view but the file getting imported into Anaplan instance.

  • Migration Impact: The Anaplan Read Snap now writes the Anaplan file data read into the binary output view as a stream. This was done to resolve an issue with the Snap generating all column values into a single column.

Binary Snap Pack

  • NEW! File Poller Snap. This Snap polls a directory looking for files matching the specified pattern.
  • PGP Decrypt now supports files that are encrypted and signed.
  • Resolved Directory Browser unable to support file protocol on Windows Groundplex
  • Resolved Multi File Reader File protocol is not working for Windows Groundplex

Concur

  • Concur Write now routes all error messages to the Error view.

DynamoDB Snap Pack

  • NEW! In this Snap Pack, we are introducing three Snaps:

    • DynamoDB Bulk Write to write data into AWS DynamoDB.

    • DynamoDB Scan to reads data from a DynamoDB table.

    • DynamoDB Update to update data in a DynamoDB table.

Email

  • Email Reader Snap now has an option to read older message first.
  • Resolved Null Pointer exception in Email Reader Snap when reading from Yahoo mailbox.

Flow Snap Pack

  • NEW! Exit Snap. This Snap forces a pipeline to stop with a failed status if it receives more records than the user-defined threshold.
  • Resolved error in ForEach Snap where an exposed error view triggered a pipeline failure.

Google SpreadSheet Snap Pack

  • NEW! This Snap Pack contains Snaps for browsing Google SpreadSheets, reading worksheets, and writing to worksheets.

JDBC

  • Resolved Generic JDBC Execute not working with value substitution

  • Resolved JDBC Execute unable to read CLOB columns via jTDS/JDBC

LDAP

  • Update Entry Snap now supports expression in the Distinguished Name field.

MongoDB

  • MongoDB - Find: Resolved Error- Failure: java.util.HashMap cannot be cast to java.lang.String when in query condition passes without single quotes.
  • MongoDB - Find: Resolved failure with Query Using Operators.
  • Resolved MongoDB driver and account do not support current version of MongoDB.
  • Resolved a failure MongoDB Insert with custom _id.

MySQL

  • Resolved an error in MySQL Merge Snap while trying to load Images.
  • Resolved an error when MySQL Execute Snap was placed after a ForEach Snap.
  • Output fields table property added to Select Snap.
  • Resolved an issue in Execute and Select Snaps where the output document was the same as the input document if the query produces no data. When there is no result from the SELECT query, the input document will be passed through to the output view as a value to the 'original' key. The new property Pass through with true default.

Oracle

  • Oracle connection errors now route to error view.
  • Output fields table property added to Select Snap.
  • Resolved an issue in Execute and Select Snaps where the output document was the same as the input document if the query produces no data. When there is no result from the SELECT query, the input document will be passed through to the output view as a value to the 'original' key. The new property Pass through with true default.

Oracle E-Business

  • Oracle EBS requests - "timeout" field accepts alphanumeric values

Redshift

  • Updated driver not distributed with the Redshift Snap Pack.
  • Output fields table property added to Select Snap.
  • Resolved an issue with Redshift - Bulk Loader incorrectly writing to wrong location on S3 and disable data compression not working
  • Resolved an issue in Execute and Select Snaps where the output document was the same as the input document if the query produces no data. When there is no result from the SELECT query, the input document will be passed through to the output view as a value to the 'original' key. The new property Pass through with true default.

SQL Server

  • Output fields table property added to Select Snap.
  • Resolved an issue with SQL Server where inserting datetime with timezone converted to UTC.
  • Resolved an issue with SQL Server where inserting datetime into date column inserted NULL.
  • Resolved an issue with SQL Server Select schema name with parameter.
  • Resolved an issue with SQL Server Insert not handling value 255 for tiny int data type.
  • Resolved an issue with SQL Server - Execute Snap when a stored procedure was executed.
  • Resolved an issue in Execute and Select Snaps where the output document was the same as the input document if the query produces no data. When there is no result from the SELECT query, the input document will be passed through to the output view as a value to the 'original' key. The new property Pass through with true default.

SOAP

  • SOAP Execute Snap now disables importing XSDs if any are in a WSDL.
  • Resolved a Null pointer exception in SOAP Execute.
  • Resolved an issue with not being able to generate a template from Taleo WSDL.
  • Resolved a loader contraint violation issue in SOAP Execute when resolving method "org.apache.http.impl.client.HttpAuthenticator".
  • Resolved an issue with WSSE Account not working with SOAP Execute Snap

Transform

  • Resolved an issue in Excel Parser where Headers were not displayed properly if a few columns were blank.
  • Resolved a null pointer exception in the Aggregate Snap. The resolution included the addition of a new field, Sorted stream, where you designate whether or not the incoming date is sorted, as presorted data will allow the Snap to run more efficiently. The default value is Ascending for newly placed Aggregate Snaps; existing Aggregate Snaps will default to Unsorted for compatibility with previous functionality.
  • NEW! Transcoder Snap. Resolves an issue where preview of Snaps was not able to handle special characters.
  • Resolved an issue with XML Formatter including "Metadata" in the output.

Zuora

  • Resolved incorrect error message when creating Zuora account with invalid credentials.

Summer 2015 Release (Platform Update, July 18, 2015)

Binary Snap Pack

  • Support for S3 Server-side encryption. See AWS S3 Account at Binary Accounts.

June 27, 2015 (2015.22)

Google Accounts

Please note that Google APIs no longer support OAuth1 accounts.

Anaplan

  • Anaplan action Snap should work for Anaplan processes as well.

Flow

  • The Router Snap now supports even distribution across all output views if no expressions are defined. With this change, Routes is no longer a required field.

Email Snap Pack

  • Email Sender now supports the ability to pass through input documents.

HBASE

  • NEW! HBase Put and Get Snaps for use in Standard Mode.

JDBC

  • JDBC Execute Snap: SQL operation failed with an invalid batch command when using table name as an input variable.
  • JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.

JMS

  • Can now validate a JMS Account against AWS SQS.

Oracle

  • Oracle Merge: SQL operation failed with an "IO Error: Connection reset, error code: 17002, SQL state: 08006 connection failure".
  • JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.

REST

  • REST Get: Now allows you to have no output views. Previously, there was exactly one output view.

PostgreSQL

  • PostgreSQL Insert Snap: resolved an issue where it inserts a negative value when the input data was out of range.
  • PostgreSQL Snaps did not properly handle when a table name was created in mixed case.
  • JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.

Redshift

  • Redshift Bulk Load and Upsert: Disable the option for EMPTYASNULL
  • Redshift Bulk Load Snap does not encode UTF-8 writing to S3 file in Windows GroundPlex
  • JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.

ServiceNow

  • Display value not working in ServiceNow Query Snap.

SAP HANA

  • Mismatched datatype values are inserted as NULLs
  • JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.

SQL Server

  • JDBC Driver Class property was hard-coded in the Snap.
  • SQL Server Select: with TEXT data type fails
  • JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.

SOAP

  • Timeout option required for SOAP Execute Snap.
  • Support for SOAP attachments.

Transform Snap Pack

  • Sort Snap: performance improvements for sorting large amounts of records.
  • XML Formatter:
    • resolved an error where documents could not be converted to XML since the last Snap update.
    • resolved an exception found within this Snap.
  • JSON Splitter: resolved an issue with the Snap not honoring the Null-safe access option
  • Excel Parser: Headers were not displaying properly if a few columns are blank.

Migration Impacts

  • If using the SQL Server Snap Pack with native Windows authentication, it is recommended that you restart your nodes.

June 6, 2015 (2015.20)

Migration Impacts

  • There is a change in behavior in the MySQL Insert and Merge Snaps that is not backwards compatible. When a string value is inserted or merged into an integer type field of MySQL and the string value is not a numeric string or is larger than the maximum integer value (2147483647), the Snap will throw an error or route an error to the error view. The previous behavior was that if the string value was not a numeric string, it was converted to zero, and if the string value was larger than the maximum integer value, it was converted to the maximum integer value.

Transform Snap Pack

  • CSV Parser: You can now select the character set in which your incoming CSV data is encoded. 
  • CSV Formatter: You can now select the character set in which encode your CSV data. You can also select to writhe the BOM (ByteOrderMark) for the character set selected.
  • NEW!: Avro Parser and Formatter
  • Excel Parser Snap: resolved failure due to file size
  • XML Formatter:
    • resolved "Cannot read attribute: element has children or text" error
    • Additional property, Strict XSD Output, added to extract the root element name and the wrapper name from the XSD file.

Binary Snap Pack

  • ZipFile Read Snap hangs when the File property is evaluated to a binary object too large to be a file URL
  • Directory Browser: Unexpected results when using SFTP protocol paths
  • SMB ClearText credentials visible for incorrect connection string

Flow

  • Task execute should have execute on preview
  • Directory Browser Snap did not render output data when running from "Windows" Groundplex

REST Snap Pack

  • Rest Post Snap now supports posting a file

SOAP Snap Pack

  • SOAP Execute: resolved an issue with the SOAP WSSE account not working

Oracle Snap Pack*****

  • Oracle Lookup failed in preview if DATE column was used for Lookup conditions
  • Dynamic DB queries now supported in the Execute Snap.
    The SQL statement property now can be set as an expression property. When it is an expression, it will be evaluated with each input document and  one SQL statement per each input document will be executed.
    Known issue: When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
    With the SQL statement property set as an expression, the Snap can be exposed to SQL injection. Please use this feature with caution.
  • Oracle Insert: When a string value is entered into a date col, its successfully inserting into db with null
  • Oracle Stored Procedure: parameter type list was not populating even if a procedure had custom types defined.

MySQL Snap Pack

  • MySQL Insert: resolved issue with the Snap not handling out of range value properly
  • Dynamic DB queries now supported in the Execute Snap.
    The SQL statement property now can be set as an expression property. When it is an expression, it will be evaluated with each input document and  one SQL statement per each input document will be executed.
    Known issue: When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
    With the SQL statement property set as an expression, the Snap can be exposed to SQL injection. Please use this feature with caution.


SAP HANA Snap Pack

  • A - otd:6598 sap hana Snaps- When schema name entered in lower case- click on suggest for table name- says - no tables found
  • Dynamic DB queries now supported in the Execute Snap.
    The SQL statement property now can be set as an expression property. When it is an expression, it will be evaluated with each input document and  one SQL statement per each input document will be executed.
    Known issue: When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
    With the SQL statement property set as an expression, the Snap can be exposed to SQL injection. Please use this feature with caution.
  • SAP Hana Insert string into number no longer routes to error view - just inserts null


Postgres Snap Pack

  • A - otd:6828 Postgres Snap shows wrong data type in preview for timestamp withtime zone data type
  • Dynamic DB queries now supported in the Execute Snap.
    The SQL statement property now can be set as an expression property. When it is an expression, it will be evaluated with each input document and  one SQL statement per each input document will be executed.
    Known issue: When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
    With the SQL statement property set as an expression, the Snap can be exposed to SQL injection. Please use this feature with caution.


Redshift Snap Pack

  • NEW!: Redshift Bulk Unload Snap
  • Redshift Unload fails if values in the WHERE clause have single quote
  • Redshift - Bad error message when jcc can't reach redshift instance
  • Dynamic DB queries (affects all DB Snaps)


JMS

  •   Support for Amazon SQS added.


JDBC Snap Pack

  • JDBC Insert Snap fails to insert joda LocalTime object to PosgreSQL TIME data type
  • Dynamic DB queries now supported in the Execute Snap.
    The SQL statement property now can be set as an expression property. When it is an expression, it will be evaluated with each input document and  one SQL statement per each input document will be executed.
    Known issue: When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
    With the SQL statement property set as an expression, the Snap can be exposed to SQL injection. Please use this feature with caution. 


MongoDB Snap Pack

  • MongoDB FindL exception


Email Snap Pack

  • Email Reader: Resolved an error with concatenating file names in attachments


LDAP Snap Pack

  • LDAP Delete Attribute Value: Enhanced error handling and messages.


NetSuite Snap Pack

  • NEW!: NetSuite Update Snap
  • NetSuite Account now gets the datacenter URL's automatically.


OpenAir Snap Pack

  • Resolved an issue with error not routing to error view


Expensify Snap Pack

  • All Snaps: resolved an issued with all Snaps not getting any output or error view.


May 15, 2015

The following items were address in this release:

Binary Snap Pack

  • File writer Snap - Null pointer exception resolved - Better reporting on ftps errors
  • Directory Browser Snap listed wrong path for S3 sub-directories

Flow Snap Pack

  • ForEach: Error was not thrown on validation if the child pipeline was not provided

SOAP Snap Pack

  • SOAP Request failed for Hiperos WSDl
  • SOAP Execute: failure, resolution is not provided; Not loading issue
  • SOAP Snap failed for control character created by CSV Parser
  • SOAP Snap: updated error message when an invalid WSDL was selected
  • SOAP Snap output schema updated. Error and reason were added back to the output in addition to Fault code, detail entry, soap fault exception, and fault string.

SQL Server Snap Pack

  • SQL Server Select - failed if table contains a column of type "timestamp"
  • SQL server Insert- null value inserted when string is inserted into "Date" data type
  • datetimeoffset was not preserving timezone

Oracle Snap Pack

  • Oracle Execute error - no more documents will be written to SLFS
  • Oracle Execute Snap failing with maximum number of documents reached
  • Oracle Select Snap - Early dates are corrupted when reading data 
  • Oracle select- with date data type does not return Time(hh:mm:ss)
  • Oracle Stored Procedure  fails with error- Reason: invalid name pattern: TECTONIC.null
  • Oracle Stored Procedure - fails with - "invalid name pattern: TECTONIC.strarray32 " when type name given in lower case

Salesforce Snap Pack

  • Salesforce Upsert - intermittently throws ViewChannelException since document was send to the closed output view
  • Salesforce delete not using passthrough platform service

ServiceNow Snap Pack

  • ServiceNow Query: "Failure: invalid path" message is displayed
  • ServiceNow Insert: Snap Fails with Invalid credentials after some successful runs
  • Servicenow Insert: Error is not routing to Error view for table which doesn't have schema
  • ServiceNow Insert : An error occurred while executing the request or the connection was aborted
  • ServiceNow Update: Pipeline executes successfully without output or Error message shown for non existing record

NetSuite Snap Pack

  • NetSuite Search Snap returns error when trying to use custom field
  • Edits made to messages.

Openair Snap Pack

  • Operair Write: NPE while inserting/updating record with projectstagename

LDAP Snap Pack

  • LDAP Account Domain name Setting confusing
  • LDAP Search: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
  • LDAP Delete Attribute: Provision to provide attribute values in LDAP Delete Attribute Snap

Splunk Snap Pack

  • Splunk Write: Writer does not throw error if Index is disabled. Instead pipelines successfully runs, but no data inserted

May 2, 2015


New Snaps

  • Splunk Saved Search
  • Splunk Writer

Updated Snaps

  • SnapReduce: expression language support in all Snaps
  • Active Directory Create & Update Entry: added pagination of results
  • Active Directory Rename Snap: updated tooltips
  • Active Directory Search: added pagination of results
  • Binary Router: enhanced error handling
  • Directory Browser: added pass-through capability
  • Excel Parser: exception resolved
  • Expensify: fixed issue with Report download
  • File Delete: resolved an error writing to network stream
  • File Writer: The output view field "fileAction" has changed to "result", web HDFS enhancements
  • Filter: bug fixes
  • HDFS Reader: enhanced with expression support
  • Join: bug fixes for certain datasets in excess of 1million rows
  • JSON Generator: enhanced error handling
  • LDAP: pagination support added
  • LinkedIn: added pagination of results
  • Mapper (Data): bug fixes
  • MS-Exchange Account: validation option added
  • NetSuite: fixes for AccountPeriod Object
  • NetSuite: Custom field support in search Snaps
  • Oracle: enhancements in dealing with DATE type fields
  • Oracle Lookup: Pass-though on no lookup match property added to allow you to pass the input document through to the output view when there is no lookup matching.
  • PGP: enhanced error handling
  • PostgreSQL Insert: Enhanced data type support
  • PostgreSQL Lookup: bug fixes on lookup failures; Pass-though on no lookup match property added to allow you to pass the input document through to the output view when there is no lookup matching.
  • PostgreSQL Select Snap: added support for handling array types
  • Redshift Account: Enhanced error messaging
  • Redshift SCD2: Bug fixes with compound keys
  • RedShift Lookup: Bug fixes on lookup failures; Pass-though on no lookup match property added to allow you to pass the input document through to the output view when there is no lookup matching.
  • REST: Output views made options 
  • Router: bug fixes
  • Salesforce Account: added custom login URL (for support of CipherCloud)
  • Salesforce Read: various updates for errors and performance improvements for > 1m rows being retrieved in Bulk API
  • Salesforce Write in Bulk API: enhanced batching support
  • SAP HANA Write: enhanced support for datatype mapping
  • SAP HANA Stored Procedure enhancements
  • Sequence Snap: enhanced error handling
  • ServiceNow: Support for latest release and bug fixes
  • SOAP Snap: enhanced template generation
  • Sort:bug fixes for certain datasets in excess of 1m rows
  • SQL Server Lookup: Pass-though on no lookup match property added to allow you to pass the input document through to the output view when there is no lookup matching.
  • SQL Server Stored procedure enhancements and bug fixes 
  • Vertica Lookup: Pass-though on no lookup match property added to allow you to pass the input document through to the output view when there is no lookup matching.
  • XML Parser: enhancements supporting empty documents
  • ZipFile Writer: The output view field "fileAction" has changed to "result".

April 9, 2015

  • ServiceNow Snap Pack updates to support the Fuji release of ServiceNow.


Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.