Garrett
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: SQL Bulk load truncating data
Hi Mohit. You cannot use nvarchar unless you define the schema with the mapper. I do not want to define all of the fields. I want SnapLogic to send them over as nvarchar instead of varchar but it doesn’t have that option. It says you can use a mapper as an input to provide a mapping but I don’t know how to define it or set it up. In other words I may be able to define the mapper programmatically but I do not see out to use the second input view to do that.3.8KViews0likes2CommentsWeird pipeline execution issue
I have an issue with the SnapLogic interface where I and only I cannot execute a pipeline after loading. I always have to edit a Snap, save it, verify it and then I can execute the pipeline. Others on my team don’t have this issue and I"m not sure how else to describe it. I’ve tried a bunch of settings options for Autosave etc but nothing seems to fix it.3.9KViews0likes8CommentsRe: Error Zero date value prohibited querying MySQL Database with MySQL snap
Some info I found: Here are two simple and short solution which could resolve this error for you. You could possibly change your database schema, to allow NULL values. UPDATE table SET datefield = NULL WHERE datefield = ‘0000-00-00 00:00:00’; In your datasource configuration, you can edit JDBC URL by setting a parameter called ‘zeroDateTimeBehavior’ to ‘convertToNull’. jdbc:mysql://localhost:3306/yourMySqlDatabase?zeroDateTimeBehavior=convertToNull Is there a way I can set that convertToNull piece into the call on the Snap?3.6KViews0likes0CommentsError Zero date value prohibited querying MySQL Database with MySQL snap
I am pulling a MySQL query that works when querying the database but I am getting the following error in SnapLogic. Zero date value prohibited Pipeline did not complete successfully Resolution: Fix the child pipeline errors and try again Reason: Snap errors: {ruuid=84507a5f-350c-4e73-9412-696d2af1199a, label=MySQL - Execute, failure=Failed to execute query, reason=SQL [SELECT * FROM my$table]; Zero date value prohibited, resolution=Please address reported issue.} There are no Null dates in the data set that I can find. And I am not converting these to a date field I am converting them to JSON. Thanks for your help.4.1KViews0likes1Comment