In this Page

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

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.
Only those customers using SQL Server with Windows authentication and SAP will need to restart their Groundplex instances.

4.6

Live on production 8/13/2016

For information on Snap Pack build versions, see Snap Pack Versions by Release.

New Snap Packs

• Teradata Snap Pack: this includes only Teradata extract functionality to move data out of Teradata database using the FastExport Utility. It does not include Snaps for load, select, insert, delete, execute or others at this time. It also does not utilize the Teradata Parallel Transporter to extract data.
• Hive Snap Pack: this includes only a Hive Execute Snap. Tested only on Cloudera CDH 5.3 & 5.5, Hortonworks HDP 2.3.4. Tested with Hive version 1.1.  It does not include Snaps for load, select, insert, delete, execute or others at this time.

Updated Snap Packs

Updates that Span Multiple Snaps Packs

• Enhanced Database Execute Snaps to fully support SQL statements with/without expressions & SQL bind variables.
• Enhanced error reporting in Database Snaps when relation pre-exists.
• Binary Snaps that work with AWS S3 accounts can now configure their accounts with IAM Role.

Active Directory

• Extended support for a der encoded representation of Anaplan Certificate for Anaplan account validation.
• Resolved an issue in Create Entry, Search, and Update Entry Snaps that caused certain attributes to not appear in suggestions.

Anaplan

• Extended support for a der encoded representation of Anaplan Certificate for Anaplan account validation.
• Anaplan Action Snap is enhanced to support handling of output during an import action. If an import operation is unsuccessful, rows without an error are written to the output view, and rows with an error are written to the error view. 

Binary

• Enhanced the File Writer Snap with an option to create a directory if the specified directory path does not exist.

Email

• Resolved an issue in Email Sender Snap that failed when attached a file that had spaces in the file name.
• Enhanced error handling in Email Reader Snap to appropriately route connection errors to error view.

Flow

• The following Snaps now support error view in Spark mode: Copy, Union.
• ForEach: The value for the Maximum instances property is limited to a maximum of 100. A value higher than 100 will automatically be limited down to 100 during pipeline execution.
• Pipeline Execute: Snaplex property added to let you specify the Snaplex on which to run the child pipeline.
• Resolved an issue in Task Execute Snap that caused an internal server error (status code: 500).
• Resolved an issue in Pipeline Execute Snap that did not show parameter suggestions when the pipeline is selected from another project.
• Resolved an issue in Copy Snap that showed errors on the UI while the Javascript was being executed.
• Resolved an issue in Filter Snap that failed with "could not filter the document" if upstream data for ServiceNow Query.

Google Analytics

• Enhanced the Google Analytics Snap to enabling sampling level.
• Resolved an issue in Google Analytics tooltip about an HTML link.

Hadoop

• The following Snaps now support error view in Spark mode: HDFS Reader, Sequence Parser.
• Resolved an issue in HDFS Writer Snap that sends the same data in output & error view.  

JDBC

• Enhanced Generic JDBC Execute Snap to fully support SQL statements with/without expressions & SQL bind variables.
• Resolved an issue in Generic JDBC Insert Snap that caused unexpectedly failures on Snowflake and connecting to DB2.
• Resolved an issue in Generic JDBC Select Snap that caused errors with Teradata database instance.
• Resolved an issue in Generic JDBC Select Snap with Snowflake account that caused an error when auto-commit was not selected.
• Resolved an issue in Generic JDBC Select Snap with Snowflake account that caused an error when a merge statement was used in the Snap.

MongoDB

• Resolved an issue in MongoDB Insert Snap that processed and inserted all numeric fields as strings.

MySQL

• Enhanced MySQL Execute Snap to fully support SQL statements with/without expressions & SQL bind variables.
• Extended support for MySQL Dynamic accounts.
• Resolved an issue in MySQL Select Snap that caused failures in the second output view when retrieving outputs from a table with a dot (.) character.
• Resolved an issue in MySQL Execute Snap that caused failures when passing expression ($variable_name) for stored procedures.
• Resolved an issue in MySQL Execute Snap that caused failures when an SQL statement had an inline comment.
• Resolved an issue in MySQL Execute Snap that ignored all statements after "--".  

NetSuite

• Enhanced the NetSuite Snap Pack to allow maximum request attempts and retry request interval configurations.
• Resolved an issue in NetSuite Snap Pack that caused Snaps to fail with read timeout errors.
• Enhanced the NetSuite Snaps to support custom fields on the following object types: VendorBill, VendorBillItem, VendorBillExpense, ExpenseReportExpense, PurchaseOrderExpense. Additionally, Address on Contact, Customer, Partner, Vendor, Job, & Employee are also supported when using WSDL version 2014.2 or later.
• Enhanced the NetSuite Search Snap to support the general object types Item and Transaction, rather than just their more specific subtypes.
• Resolved an issue with the NetSuite Upsert Snap that was incorrectly handling some failed requests as successful requests. Any response containing at least one error status is now written to the error view instead of the output view.

OpenAir

• OpenAir Read Snap is updated with a new field to enable retention of null values in date field or replacement of null values with system timestamp/date. 
• Resolved an issue with OpenAir Read Snap that caused unexpected results when working with End_Date column values.

Oracle

• Enhanced Oracle Execute Snap to fully support SQL statements with/without expressions & SQL bind variables.
• Extended support for Oracle Thin Dynamic accounts.
• Resolved an issue in Oracle Select Snap that caused failures in the second output view when retrieving outputs from a table with a dot (.) character.

PostgreSQL

• Enhanced PostgreSQL Execute Snap to fully support SQL statements with/without expressions & SQL bind variables.
• Resolved an issue in PostgreSQL Select and Execute Snap with array type returned a valid output but failed to validate (show the Snap as red).

Redshift

• Enhanced Redshift Execute Snap to fully support SQL statements with/without expressions & SQL bind variables.
• Resolved an issue in Redshift Execute Snap that caused errors when executing a command Select current_schemas(true).
• Resolved an issue in Redshift Execute Snap that caused errors when a Select * from <table_name> into statement was executed.
• Enhanced error reporting in Redshift Bulk Load Snap to provided appropriate resolution messages.  

SAP  HANA

• Enhanced SAP HANA Execute Snap to fully support SQL statements with/without expressions & SQL bind variables. 

Salesforce

• Doc Enhancement: Examples added to Salesforce Snap documentation.
• Resolved an issue in Salesforce Batch Create Snap that was unable to encode em dash.  
• Resolved an issue in Salesforce SOQL Snap that failed in Bulk API & JSON content type for large output document streams.
• Resolved an issue in Salesforce Snaps that prevented extraction of access tokens. 
• Resolved an issue in Salesforce Bulk API that caused errors when it was unable to encode elongated dash on Windows Groundplex.
• Resolved an issue in Salesforce Upsert that failed when updating a custom object.

ServiceNow

• A query in the ServiceNow Query Snap that finds no results now produces an empty document written to the output view.
• Resolved an issue in ServiceNow Update Snap that caused errors when updating records for tables such as usageanalytics_count.
• Resolved an issue in ServiceNow Insert Snap that disabled insertion of data for newly added fields if column names were manually added.  

SOAP

• Enhanced SOAP Execute Snap to handle a SOAP call with an empty response. 
• Resolved an issue in SOAP Execute Snap that failed with an error in returning a response but returns an empty response. 
• Resolved an issue in SOAP Execute Snap that caused the Snap to unsuccessfully parse XML schema from a valid WSDL when generating a SOAP envelope.  

SQL Server

• Enhanced SQL Server Execute Snap to fully support SQL statements with/without expressions & SQL bind variables.
• Resolved an issue in SQL Server Execute Snap that caused failures when executing merge statements.
• Resolved an issue in SQL Server Bulk Load Snap that caused BCP program related failures.
• Resolved an issue in SQL Server Execute Snap that assumed any query with "WITH" statement as a read operation.
• Resolved an issue in SQL Server Execute Snap that caused INSERT statements to fail when the input was a date-time type.
• Resolved an issue in SQL Server Execute Snap that caused failures with SELECT INTO statements.
• Resolved an issue in SQL Server Merge Snap when the input documents only contain one column of data.

Transform

• The following Snaps now support error view in Spark mode: Aggregate, CSV Parser, JSON Parser, Join, Unique.
• Added an option to enable output readability. The newly added option is Pretty-print.
• Resolved an issue in Excel Formatter Snap that formatted decimal numbers as text in the output XLS file.
• Resolved an issue in XML Generator Snap that expired the internal cache after 50 minutes.  
• Resolved an issue in Join Snap that caused unexpected failures while performing join or duplicated column values.
• Resolved an issue in Sort Snap that caused unexpected results when provided with multiple sort paths.

Tableau 9

• Doc Enhancement: Examples added to Tableau 9 Snap documentation.
• TDE Formatter Snap is enhanced to support Linux Snaplexes.
• Tableau REST Snap is enhanced to support chunking when publishing large files.
• Enhanced error handling to appropriately route errors in Tableau Write and TDE Formatter Snaps. 
• Enhanced error reporting in Tableau REST Snap when field are improperly mapped from input Snap.
• Resolved an issue in Tableau REST Snap that caused failures when publishing workbook and datasources. 
• Resolved an issue in TDE Formatter and Tableau REST Snap that cause errors on Windows Groundplex.
• Resolved an issue in Tableau REST Snap that only made available 100 entries of datasource.

Vertica

• Enhanced Vertica Execute Snap to fully support SQL statements with/without expressions & SQL bind variables.

Workday

• Resolved an issue in Snaps with Workday Dynamic account that caused an error when a pipeline parameter provided an empty value to the password field.
• Resolved an issue in Workday Read Snap that caused errors when the timeout field was set.
• Enhanced error reporting in Workday Read Snap when it is provided with incorrect tenant name as a pipeline property. 

Known Issues

JDBC Insert

• "The Maximum Possible Row Length in the Table is too Large" error message: You will see this message if trying to insert data into Teradata that is larger than Teradata can handle (rows are limited to approximately 64,000 bytes). Workaround: Use smaller default column size, e.g., 32000 bytes.

Splunk Snap Pack

• Splunk accounts do not validate on Snaplexes using Java 1.8. As of 4.6, all Cloudplex instances use Java 1.8. Workaround: Use the older Snaplex installer to install the Snaplex, then let it autoupdate to the current war file. On Windows, you can manually install JRE 7.

Hive Snap Pack

• Hive Execute Snap has not been tested with Kerberos enabled.

4.5.1

Live on production 6/18/2016

New Snap Packs

For information on Snap Pack build versions, see Snap Pack Versions by Release.

Tableau 9

• The Tableau 9 Snap Pack contains a REST, Write, & TDE Formatter Snap. It supports Tableau 9.1 version of Tableau server. For more information, see Tableau Snap 9 Pack Overview.

Updated Snap Packs

Updates that span multiple Snaps Packs

• Fixed an error when building Snap Zip files that caused the zip file to include an unintended jar file.
• Fixed an error that disabled loading pipelines from the pipeline picker property. 
• Enhanced error handling during pipeline execution when reuse is enabled and the pipeline path is an expression whose result is not a constant.
• Enhanced error handling during pipeline execution to report runtime ID and state related details to the error view.

Binary Snap Pack

• File Reader, ZipFile Read, Multi File Reader Snaps are updated with the Execute during preview field to execute the Snap during the Save operation so that the output view can produce the preview data. For more information, see File Reader, ZipFile Read, & Multi File Reader.
• File Delete & File Writer Snaps are updated with an option to validate file deletion & file writing after Snap execution. For more information, see File Delete & File Writer.
• ZipFile Write Snap is updated with an option to enable sequential file naming of files added to zip file. For more information, see ZipFile Write.
• Fixed an error in File Reader Snap that exposed account credentials in an error message.
• Fixed an error in File Writer & File Delete Snap to ensure consistent error handling for all the protocols. 

Box

• Box Permissions Snap is updated to allow removing collaboration from a Box folder. For more information, see Box Permissions.
• Box File Operations Snap is updated to route failures due to invalid source file/folder name to error view.
• Fixed an error in Box Permissions Snap execution that caused failure in adding collaboration when the Box folder accepted a user as a collaborator.
• Fixed an error in Box Read Snap that caused unexpected missing property values failure.

Cassandra

• Resolved an issue in the Cassandra Select Snap unexpectedly failing with a Failure: 0 error.
• Resolved an issue in the Cassandra Select Snap that caused unexpectedly failure for valid SQL queries.
• Resolved an an issue in the Cassandra Select Snap that caused correctly configured Snaps to fail while execution.

Email

• BCC field added to the Email Sender Snap.
• Retries added to the Email Sender Snap.

Flow

• Resolved an issue with Pipeline Execute not able to load pipeline selected from the pipeline picker property.
• Enhanced error handling in Pipeline Execute for when Reuse is enabled and the pipeline path is an expression whose result is not constant.
• Resolved an issue in Pipeline Execute not including the runtime ID and state in error documents.

Google Analytics

• Automatic pagination added.

Google DFA

• Updated tooltips and error messages to reflect current API version.

JDBC

• Resolved an issue with JDBC Select failing with a syntax error when special characters were used.

MongoDB

• Resolved and issue with MongoDB Insert with an empty input view failed.
• Resolved an issue with MongoDB Insert that changed a numeric type field in MongoDB as String.
• Resolved an issue that caused Snap execution failures when accessing MongoDB using a Replica Set account.

MySQL

• Fixed an error in a tooltip for MySQL - Select Snap.

NetSuite

• NetSuite Search Snap is updated to support advanced searches. This enables you to execute a saved search using its ID & search for relevant records in it.
• Fixed an error in NetSuite Update Snap that restricted access to a custom field in the addressbook sublist of a contact object. 

Oracle

• Oracle - Bulk Load Snap is updated with a new field, Use direct path load, to enhance bulk loading performance. For more information, see Oracle - Bulk Load.
• Resolved an issue with Oracle Select Snap failing if the table name included a dot (.) character.

PostgreSQL

• Resolved an issue in the PostgreSQL - Execute Snap that resulted from restrictions on the 'with' operator in conjunction with an 'insert' statement.
• Resolved an issue in the PostrgeSQl Snaps that resulting from restrictions on the 'with' operator in conjunction with the RECURSIVE keyword.

RabbitMQ

• Resolved an issue with the Producer and Consumer Snaps not releasing connections.

Redshift

• A new Snap, Redshift S3 Upsert, has been added to load/copy Amazon S3 data to a specified location. For more information, see Redshift - S3 Upsert.
• Resolved an issue that occurred while inserting mismatched data type values in Redshift Insert Snap.

REST

• A new property was added to the REST Get Snap to specify the iteration interval for pagination.
• All Snaps now have at most one input and one output view.

SAP HANA

• Fixed an error in a tooltip for SAP HANA Upsert.

Salesforce

• Salesforce Read Snap is updated to support Output fields and Where clause specifications. For more information, see Salesforce Read.
• Salesforce Read & SOQL Snaps are updated to support JSON representation of Bulk API result data and a parsing issue encountered (in Bulk API mode) has been rectified.
• Fixed errors around upload and output preview for Salesforce Wave Analytics Snap. 

ServiceNow

• Extended support for the latest ServiceNow releases through Helsinki. For more information, see ServiceNow Snap Pack Overview.
• Fixed an error in record insertion for ServiceNow Insert Snap. 
• Enhanced error reporting in ServiceNow Delete Snap when sys_id is invalid.

SOAP

• SOAP Execute Snap is updated to terminate a SOAP request after a number of attempts, and to successfully execute the Snap only if a success condition is met. The fields added are Maximum request attempts, Retry interval, & Success condition. For more information, see SOAP Execute.
• Enhanced error handling in SOAP Execute Snap when generating customize envelope.

Transform Snap Pack

• XML Formatter is enhanced to transform an XML output to canonical XML. For more information, see XML Formatter. 
• Join Snap is updated to support a new join type, Merge. For more information, see Join.
• Fixed an error in XML Parser Snap that caused the Snap to fail for a valid specification, an hierarchy with an XPath expression.
• Fixed an error in CSV Parser Snap that cause skip lines option to not take effect in Spark mode.
• Fixed an error in Join Snap that caused unintended values in the output document if one of the inputs has zero documents. 
• Fixed an error that throws incorrect resolution for a failure when a Join Snap has unconnected input views.
• Fixed an error in Sort Snap that occurred because the upstream Snap was producing Long instead of Big integer. 
• Fixed an error in Sort Snap to ensure appropriate error handling. 
• Fixed an error in Join Snap, in Ultra mode, that that caused execution failure due to lineage information. 
• The version of the Join Snap deprecated in 4.4.1 is no longer available in the catalog.
• CSV Parser Snap is updated to ensure appropriate parsing of input data. The Snaps that worked prior to 4.4.1 were failing in 4.4.2 version. This has been rectified. 

Tableau

• Fixed an error in Tableau Write Snap that caused extra rows with NULL values.
• Fixed an error in Tableau Write Snap that prevented users from writing to a specific project.
• Fixed an error in Tableau REST Snap that caused extra rows with NULL values.
• Fixed an error in Tableau TDE Formatter Snap that prevented .tde files from being downloaded from Manager. Now, you can download the file using File Writer Snap or from Manager.
• Enhanced error handling in Tableau Write Snap to report invalid project name errors.

Twitter

• Updated the Twitter Streaming Search Snap with a timeout of 10 seconds for preview if the original value provided is zero or more than 30 seconds. For more information, see Twitter Streaming Search.

Workday

• New account type added for dynamic account creation & authentication. For more information, see Workday Account. 

Spring 2016 (4.5)

Live on production 5/14/2016.

New Snap Packs

Azure SQL

• This new Snap Pack contains the Azure SQL Bulk Load Snap.

Kafka

• The Kafka Snap Pack contains a Reader and a Writer Snap.

SnapLogic Metadata

• This new Snap Pack provides the ability to list assets in any project and update operations on pipelines, accounts, tasks.

Updated Snap Packs

All Database Snap Packs

• All database Snaps have had updates in connection pooling.

Anaplan

• Resolved an issue with some Anaplan Snaps stopping on error even when an error view was enabled.
• Improved error handling and output information to the Snaps in the Anaplan Snap Pack.
• Support for Upload only operation in Anaplan Write Snap to upload a file to a server without running an import job.
• Doc Enhancement: Examples added to Anaplan Snap documentation.

Azure SQL

• Resolved an issue with Azure SQL Bulk Load Snap to ensure datatypes errors appropriately route to an error view.
• Resolved an issue with Azure SQL Bulk Load Snap that occurred when certain load operations gave a success message even when an error was reported.

Binary

• File Reader, File Writer, S3 File Writer, ZipFile Read, Directory Browser, Multi File Reader, File Poller, F-le Delete, ZipFile Write, HDFS Reader and HDFS Writer updated to support IAM Roles for Amazon EC2.
• Support for Google Storage added to File Reader, File Writer, Directory Browser, Multi File Reader, File Poller, File Delete, ZipFile Read, and ZipFile Write Snaps.
• Resolved an issue in File Writer Snap that occurred when writing to an SFTP file with an SSH account.
• Resolved an issue in Multi File reader Snap that occurred when adding error views and performing binary data streaming.
• Doc Enhancement: Example added to File Delete Snap.

Box

• Box Permissions Snap updated to allow for future removal of collaboration permissions.
• Box Permissions Snap updated to disallow assigning a user as an owner.

Concur

• Resolved an issue in Concur Write Snap to enable insertion of data from Salesforce/Workday.

Expensify

• Enhanced the error view output to include error, reason, and resolution.

Flow

• NEW! Pipeline Execute: This Snap provides a way to flexibly and efficiently execute pipelines and flowing documents into and out of these executions.
• Resolved an issue in Task Execute Snap to ensure JAVA 7 and JAVA 8 Snaplex give the same output.
• Resolved an issue with the Router Snap routing to the wrong output when used in Spark mode.

Flurry

• Enabled expression support in fields and added an optional input view.

Foursquare

• Doc Enhancement: Example added to Foursquare Snap Pack.

Google DFA

• Enabled suggestions for user profile name and campaign ID fields in Google DFA Reports Snap.

Hadoop

• The HBase Snaps are not available in this release.
• Spark Mode enabled for Parquet Reader, Parquet Writer.

JDBC

• Verified Generic JDBC Snaps connections to Hive. See JDBC Account for configuration information. SELECT and INSERT are supported. SnapLogic does not support UPDATE, DELETE, or MERGE due to limitations in the drivers. 
• Resolved an issue in Generic JDBC Insert Snap that occurred when inserting records in batches. 
• Resolved an issue in Generic JDBC Insert Snap that occurred because of an SQL execution (internal) error.
• Resolved an issue in Generic JDBC Select Snap that occurred because of an SQL query execution. 

JMS

• Resolved an issue in JMS Consumer Snap that occurred when the Snap is set with SQS account on a client_acknowledge mode.
• Resolved an issue in JMS Consumer Snap that occurred when the Snap was used in the middle of a pipeline.

Microsoft Exchange

• Resolved an issue in Exchange Create Account Snap that occurred during account validation.
• Resolved an issue in Exchange Read Snap to show appropriate attendee availability.

MongoDB

• Optional output view added to MongoDB Insert.

MySQL 

• Resolved an issue in MySQL Insert Snap to ensure an error is reported when table column is set to NOT NULL.

NetSuite

• Item and Inventory Item added as options for the Object property in NetSuite Search.
• Token Based Authentication for SuiteTalk web services added.
• Resolved an issue in NetSuite Snaps to ensure appropriate handling and display of error messages during failure.
• Resolved an issue in NetSuite Snaps that occurred when different values were entered for a custom field.
• Resolved an issue in NetSuite Search Snap to ensure all records are returned when the input search criteria is empty.
• NetSuite Snaps are enhanced to support the APIs from 2016 (version 2016). Starting from SnapLogic 4.5 release, only APIs from 2014 or later are supported.
• MIGRATION IMPACT: Note that the accounts have changed for NetSuite. The existing NetSuite account was renamed to NetSuite Credentials Account; the properties of WSDL Release and WSDL Patch were added and the Testdrive account option was removed. A NetSuite Token Account was also added.

OpenAir

• OpenAir Read was updated with a new error condition. A data exception error view document is created if more than one document is received by input2.

Oracle

• Resolved an issue in Oracle Insert Snap to ensure that a string value, when inserted in a date column, is not converted to Null in Oracle database.
• Resolved an issue in Oracle Stored Procedure Snap that occurred while loading stored procedure name field's suggestions. 

PostgreSQL

• NEW! PostgreSQL - Table List: This Snap outputs a list of tables in a database.

Redshift

• Resolved an issue in Redshift Bulk Upsert Snap that occurred when purging temp tables.
• Resolved an issue in Redshift Upload/Upsert Snap that occurred when using IAM credentials in an EC2 instance with an S3 bucket.

Reltio

• Resolved an issue in the Reltio Write Snap that occurred during template generation.

SAP HANA

• Output fields property added to SAP HANA Select Snap.
• NEW! SAP HANA - Table List: This Snap outputs a list of tables in a database.
• Resolved an issue in SAP HANA Write Snap to disallow insertion of unsupported data types as NULLs in HANA tables.
• Resolved an issue in SAP HANA Execute Snap that occurred when errors were reported even when table creation was successful.

Salesforce

• Pass through and Ignore empty results added to Salesforce SOQL, Read and SOSL Snaps.
• Resolved an issue in Salesforce Batch Create Snap to appropriately create multiple records in REST API.

ServiceNow

• Support for Geneva added.
• Resolved an issue in ServiceNow Insert & Update Snap to ensure correct target schema generation for the tables.  
• Resolved an issue in ServiceNow Query Snap that occurred when validating account details.
• Resolved an issue in ServiceNow Insert Snap that occurred when record insertion.  

SOAP

• Resolved an issue in SOAP Execute Snap that occurred when connecting to ServiceNow.

Splunk

• Resolved an issue in Splunk Search Snap to ensure that the same errors are reported on Java 7 and Java 8 Snaplexes.

SQL Server

• Resolved an issue in SQL Server Execute Snap that erroneously reported a database/schema mismatch during Snap/pipeline execution. 
• Resolved an issue in SQL Server Lookup Snap that occurred when handling case-insensitive field values.

Tableau

• Resolved an issue with not being able to download a .tde format file from Manager.

Transform

• Spark Mode enabled for Join, JSON Splitter, JSON Formatter, JSON Parser.
• Resolved an exception in the Join Snap.
• Resolved an issue with the Mapper Snap that occurred while evaluating an expression and reporting its error.
• Resolved an issue with CSV Formatter adding extra data to output when used in Spark mode.
• Resolved an issue with CSV Parser Snap that occurred when second input view did not contain a header.

Twitter

• Doc Enhancement: Examples added to Twitter Snap documentation.

Vertica

• Resolved an issue in Vertica Bulk Upsert Snap that occurred during loading.

Workday

• Resolved issues in Workday Snaps to ensure appropriate errors are routed to the error views.

Zuora

• Zuora Read Snap now has an option to remove the namespace prefixes from the Snap output.

Migration Impacts

• Changes have been made so that Snaps and scripts need to fully consume input records passed to them. If the Snap or script fails, then input does not need to fully consumed. If the Snap or script is going to succeed, then all the records from the input view need to be read before the Snap or script completes. Review your scripts to see if they need to be updated to accommodate this behavior.

4.4.1

Live on production 3/18/2016.

UI Updates

Changes in this area will require you to log out to refresh.

• Resolved an issue with Mapper filtering output schema with mapping root.
• Resolved an issue with Redshift trial user getting a permission error when loading Manager.

New Snap Packs

RabbitMQ

• This Snap Pack contains a Consumer and a Producer Snap.

Updated Snap Packs

Anaplan

• Anaplan Action Snap updated to include "resolution" in error output.

Binary

• A new Snap property Write empty file has been added to File Writer and S3 File Writer Snaps to allow for creation of zero byte files. 
• Resolved an exception in File Writer when 'file name' has no value.  
• ZipFile Read: "zip-filename" was added to the header of the output binary document.

Hadoop

• Resolved an issue with Sequence Formatter not working in Spark mode.
• Resolved an issue with HDFSReader not using the filter set when configuring SparkExec paths.

JIRA

• JIRA Search now has the Ignore empty result option.

JMS

• JMS Producer: The file header is now passed through to the output view.
• JMS Acknowledge: JMS MessageID is now optional for the input.
• JMS Consumer: Expressions are now supported for Client ID and Subscription Name.

NetSuite

• SnapLogic's pre-assigned NetSuite Application ID is now in every header sent for NetSuite Calls
• Resolved an issue with a  memory leak in this Snap Pack.
• Resolved an issue that occurred while collecting JSON schema information.
• Resolved an issue with setting a custom field to blank in the Update, Create, and Upsert Snaps.
• Resolved an issue with not being able to clear standard fields that have a value in Update and Upsert Snaps.
• Resolved an issue with "custom field" suggest showing an error when using a standard type with only one active custom field definition.
• Resolved an issue with NetSuite Search Snap not producing contact address info as output.
• In validation/preview mode only, WSDL versions are checked for consistency between the Snap and the Account.

Oracle

• Oracle Select: Resolved an issue with database access error occurring while iterating over table name result set when using an uploaded driver with a different version than the bundled driver.
• Resolved an issue with Oracle Stored Procedure Snap not accepting CLOB data.
• Made improvements to JDBC auto-commit consistency.

REST

• Resolved an issue with REST SSL Accounts with Username not send the Authorization header with the HTTP request.

Redshift

• Resolved an issue with numeric precision when trying to use create table if not present in Redshift Insert Snap.

SQL Server

• NEW! SQL Server Bulk Load
• Resolved an issue with SQL Server insert showing different output counts between validation and runtime.
• Resolved an issue with database connection pool creating too many threads.
• Made improvements to JDBC auto-commit consistency.
• Resoled an issue with SQL Server Stored Procedure failing when "boolean" data was inserted into a "bit" column.

Salesforce

• Resolved an issue with Connection pool times out with Salesforce Snaps.
• Salesforce Lookup: Resolve a 'The session ID or OAuth token used has expired or is invalid' exception when running in an Ultra Task.

Script

• Updated default generated template to ensure compatibility with both JDK 7 and 8 JSR-223 Script Engines.

Splunk

Splunk Search

• Resolved an issue with the message presented when a non-JavaScript expression was used in a Search.
• Resolved an issue with the input schema not populating after enabling an expression.

SumoLogic

• Resolved an issue with Sumo Execute Search Job when returning over 10000 records.
• Snap Pack enhanced to support non-US1 Sumo Logic API Environments.

Transform

• NEW! Excel Multi Sheet Formatter
• NEW! In-Memory Lookup
• Deprecated: The Join Snap has been deprecated and is labeled as such. Existing pipelines using this Join Snap (which is now deprecated) will continue to function as-is without any issues, including pipeline execution or while pipeline deployment across orgs. This Snap will continue to be supported for two Platform Level (x.x) Sprints, which is approximately six months. After that point no bug fixes will be applied to the Snap. It is recommended to move to use the new Snaps (Join and In-Memory Lookup), which together have significant performance and efficiency benefits.
• Name change: The Multi-Join Snap has been renamed to Join.
• Aggregate: Resolved an issue with Sum and Avg Functions not returning correct output in Spark mode.
• CSV Parser: A second optional input view was enabled to add the ability to associate an external schema file.
• CSV Formatter: A new property, Quote mode, specifies how the quote character should be used in formatting the CSV data.
• JSON Formatter: Resolved an issue with Ignore Empty Streams option not working.
• JSON Parser: Resolved an issue with error handling when an empty file is passed in an Ultra task.
• Resolved an issue with XSLT Snap incorrectly completing successfully when a truncated xml document was passed.
• ZipFile Read:
  • Resolved an issue with Content-length, content-location showing differently for different protocols.
  • Resolved an issue with spaces in file and folder names displaying as "%20".

Zuora

• Zuora Read Snap updated to include ProductRatePlan added to Object list.

4.4

Live on production 2/6/2016

Updated Snap Packs

All Database Snaps

• Added expression support to the Where clause property for Select Snaps.

Anaplan

• Resolved a "String index out of range" issue in the Anaplan Write Snap. 

Binary

• Resolved an issue with File Writer failing to timeout when attempting to connect to an SFTP location that was unreachable.
• Resolved an issue with File Reader failing validation is FTP connection password had special characters.
• Support for WASB and WASBS in Directory Browser, Multi File Reader, File Delete, File Poller, ZipFile Read, and ZipFile Write Snaps.

DynamoDB

• Resolved an issue with the DynamoDB account not validating if credentials did not have access to ListTables operation.

Flow

• Resolved an issue with Exit Snap hanging during validation if threshold is not met.
• Spark support added to the Copy, Filter, Router, and Union Snaps.

Google BigQuery

• Resolved an issue with the auto refresh token not working in BigQuery accounts.

Google Spreadsheet

• Improved performance of the Worksheet Writer Snap.

Hadoop

• NEW! Parquet Reader and Writer Snaps
• NEW! ORC Reader and Writer Snaps
• Spark support added to the HDFS Reader, HDFS Writer, Sequence Formatter, and Sequence Parser Snaps.
• Behavior change: HDFS Writer in SnapReduce mode now requires the File property to be blank.

JDBC

• Resolved an issue with the JDBC Select Snap failing with Teradata because of a Limit Offset.
• Resolved an issue with JDBC Execute failing to execute a create or replace table statement with Snowflake.
• Resolved issues with JDBC Insert Snap:
  • Failing to create a table when Create table if not present is selected.
  • An exception occurred when attempting to insert record containing date columns into Teradata.

NetSuite

• Resolved an issue with NetSuite Search Snap ignoring criteria from an input document if any custom field criteria was specified in the Snap.
• Support for Custom Records added.
• Support for additional object types added.
• Support for custom fields for all Transaction types added.
• Support for custom fields of type Checkbox (boolean) added to the Search, Create, and Update Snaps.
• Support for custom fields of type Date and Decimal added to the Create and Update Snaps.
• Resolved an issue with the consistency of the output schema when Search returned more than one page.

PostgreSQL

• Resolved an issue with PostgreSQL Select Snap not parsing JSON data type correctly.

Note: The fix for this issue required updating libraries that impacted all database Snaps except those for MongoDB.

REST

• REST Get now supports using parameters from an input document in the Next URL Setting.

Salesforce

• Resolved an issue with Salesforce Query returning inconsistent result sets.

ServiceNow

• Resolved an issue with an empty result set in ServiceNow Query.

Transform

• NEW! Pivot Snap
• Resolved an issue with JSON Splitter modifying documents that were already sent out.
• Spark support added to the Aggregate, CSV Formatter, CSV Parser, Mapper, Sort and Unique Snaps.

Workday

• Resolved an exception in Workday Read.

4.3.2

Live on UAT on 1/4/2016

Live on production 1/15/2016

Deprecated Snap Packs

The Trillium services used by the Trillium Snap Pack are no longer available. As such, the Snap Pack has been deprecated.

Updated Snap Packs

Active Directory

• Resolved an issue in Active Directory Search resulting in an error using a port value in the server URI.

Anaplan

• NEW! Anaplan Upload Snap
• Anaplan Write now outputs more details to error view.
• Resolved an issue in the Anaplan Read Snap where the suggested values for Export ID came back null.
• Resolved an issue with the Anaplan Write Snap failing when writing to the error output view.
• Resolved an issue with the Anaplan Action Snap not showing a list of the processes during Suggest.

Binary

• NEW! S3 File Writer
• Implemented wasbs:// protocol support in Binary Snap Pack.

  • Note: In the SnapLogic 4.3.2 release, WASB (Windows Azure Storage Blob) or WASBS protocol (wasb:/// or wasbs:///) support has been added to the Binary Snaps.

    In the WASB and WASBS file URL, the top directory should be the name of the 'Azure Storage container'.
    The follow line should be added to global.properties file and the jcc restarted to have the Azure Storage support available:
                jcc.jvm_options = -DDEFAULT_URL_PATTERN=.*.core.windows.net.*

• Resolved an issue with Directory Browser Snap returning Invalid Path.

Cassandra

• Resolved an issue with Execute and Select Snaps failing when querying table with user-defined types (UDT).
• Resolved an issue when ordering db column names using TreeMap versus HashMap caused Cassandra's use of emptyString fields to break.

DynamoDB

• DynamoDB Bulk Write Snap now has Batch size and Request delay properties to help control the speed of the bulk write.

Eloqua

• NEW! Create, Delete, Query Activities, and Update Snaps added.
• Added core object types to support all remaining REST 1.0 and 2.0 endpoints in Read and Query Snaps.
• Read Snap now supports expressions for Search setting and an input view.
• Resolved an issue with Eloqua Snaps not correctly obtaining the base URL from the login id endpoint.
• Resolved an issue with Eloqua Snaps not handling Additional Parameters correctly.
• Resolved an issue with Eloqua Read settings listing core object types that aren't applicable for this Snap and will always fail.
• Resolved an issue with Eloqua Read and Query Snap not able read or query External Asset object type.
• Resolved an exception with Eloqua Query when Activities returns no content.
• Resolved an exception with Eloqua Query when Activities returns content.
• Resolved an issue with Eloqua Read returning duplicate items when Count was greater than 1000.

Expensify

• Resolved an issue with Expensify Update Employee not taking the input data completely.

Facebook

• Resolved an issue with Facebook Query where the error was not routing to error view for "com.restfb.exception.FacebookJsonMappingException".

Flow

• Resolved an issue with Task Execute where java.math.BigInteger cannot be cast to java.lang.String exception if input document variable was a numeric type.
• Resolved an issue with Task Execute failing with expression enabled.
• Resolved an issue with data preview not working in the ForEach Snap.
• Resolved an issue with Execute during Preview functionality broken in the ForEach Snap.
• Resolved an issue with ForEach Snap not representing the output schema correctly during preview.

Google Analytics

• Resolved an exception when no results were found when trying to recreate Google's Site Search - Search Terms example.

Google BigQuery

• Resolved the following issues with the Google BigQuery Execute Snap:
  • throwing binary data in stacktrace and two error messages.
  • improve error handling for suggestions
  • improve error handling on bad queries
  • suggestion bubble missing for Destination table ID
• Resolved an issue with Auto refresh token not working in Google BigQuery account.

Hadoop

• Implemented wasbs:// protocol support in Hadoop Snap Pack.
• Resolved an issue with HDFS Read unable to read all files under a folder (including all files under its subfolders) using the ** filter.

JDBC

• Resolved an issue with Generic JDBC Update updating null into database when an invalid string value is provided as input for time datatype.

JMS

• Resolved an issue with JMS Consumer Snap consuming only 1 message when count set to none.
• Resolved an issue with JMS Consumer Snap failing with "Setting clientID on a used Connection is not allowed" when using Durable Subscriber option with ActiveMQ.

MongoDB

• Resolved an issue with MongoDB Find returning nothing when nothing was found.

MySQL

• NEW! MySQL Lookup Snap
• Improved performance of the MySQL Execute Snap.

NetSuite

• Resolved an issue with custom fields not appearing in the Update Snap.
• Resolved an issue with NetSuite Create with custom field not showing in the output payload.
• Improved performance of the NetSuite Snap Pack.

Oracle

• Resolved an issue with Oracle Select not reading table names: Database access error occurred while iterating over table name result set.
• Resolved an issue with Oracle Bulk load failure: String index out of range: -1.

PostgreSQL

• This Snap Pack is now compatible with the PostgreSQL drivers available in 4.3 Patch mrc222.

Redshift

• Redshift Select Where clause property now has expression support.
• Redshift Update Update condition property now has expression support.
• Resolved an issue with Redshift Select Table metadata being empty if the casing is different from the suggested one for table name

Salesforce

• SalesForce Lookup Snap: Implemented Pass-through on no lookup match property
• Resolved an issue with Salesforce Upsert Snap failing with an error 'not valid for the type xsd:double'.
• Resolved an issue with Salesforce SOQL Snap returning fewer results than SFDC returns.
• Performance improvements made to Salesforce Read/SOQL Snaps with Bulk API in PK Chunking mode.

ServiceNow

• Resolved an issue with only Success data coming, not Failure, under ServiceNow Query Snap when API Type - Default.

SOAP

• Soap Execute Snap now returns HTTP header in output
• Support WS-Security Draft 13 for a SOAP WSSE Account
• Resolved an issue with SOAP WSSE Account. Authentication was rejected because <wsu:Created> DateTime value is not being correctly converted to UTC timezone.

Splunk

• Added SSL support to the Splunk Account.

SQL Server

• Resolved an issue with SQL Server Insert failing with Error-Failure: fromIndex = -27.
• Resolved an issue with SQL Server Delete failing with Failure: SQL operation failed.
• Resolved an issue with SQL Server Select Snap where table metadata was empty if the casing is different from the suggested one for table name.

Transform

• NEW! Group By Fields and Group By N Snaps added.
• Behavior change: CSV Formatter: Expression support added to Delimiter and Quote Character properties. You will need to toggle on the expression button to use an expression in this field.
• Behavior change: CSV Parser: Expression support added to Delimiter, Quote Character, and Escape Character properties. You will need to toggle on the expression button to use an expression in this field.
• Resolved an issue with Encrypt and Compress showing 352 bytes of data when CSV Formatter has Ignore empty stream enabled.
• Resolved an issue with Sequence Snap failing if trying to read parameters from upstream.
• Resolved an issue with Sort Snap not failing with warning/error when incorrect (non-existent) field is referenced in the Sort path.
• Resolved an issue with CSV Formatter failing with error Input length = 1. 
• (Data) removed from the Mapper Snap name.
• Resolved an issue with Excel Parser Snap ignoring a column if it contained null values when selecting the Contains headers option.
• Resolved an issue with Excel formatter truncating leading zero in string type.
• Resolved an issue with Binary to Document Snap not routing the Content into the error view.
• The Multi Join Snap has been pulled from the Snap catalog when in SnapReduce mode as it is not yet supported.

Workday

• Resolved an issue with Workday Read not showing the operations for External_Integrations service
• Resolved an issue with Workday read pagination pulling same first records for each page.

Xactly

• Added "Xactly" to Delete, Search and Upsert Snap names.