Designing and Running Pipelines

Explain this log

I was looking at jcc_output.log and was looking to find the meaning of this log: WARNING: several same elements exists: optimistic result => take the first element line 1:10 mismatched input ‘as’ expecting {FROM, ‘,’} line 1:102 mismatched input ‘3’ ...

Output from script snap (Python) is writing incorrect

Hi, I am using script snap (python) to split comma separated values within one of my source column and making a dynamic update statement from it. However, when I am doing a preview of script output, all the values looks correct but if I look the prev...

Logging to custom file

We would like to pipe logs of a job ( including all pipelines executed by the job) to a job specific log file. has anyone done anything like this, if yes, can you share your experience please?

Mapping Question... Map to dynamic names?

I have source data that looks like below, with certain “known” fields with values, and then an array of “custom” data with name/value fields: knownfield1: value1 knownfield2: value2 knownfield3: value3 customDataSets: customData: name: customna...

Stored procedure versus multiple sql execute snaps

I have a SQLServer stored procedure snap with mostly SELECTs from several tables (not in an ultra pipeline). If I break up the stored procedure and substitute the SQLServer stored procedure snap with a series of sequential SQL execute and mapper comb...

Rerun Pipeline until success

Hi guys, Would you know if it is possible, in case of scheduled pipeline run failure, to rerun it until it’s successful? A Kind of retry until completes successful. Thanks,

Pipeline Parameter being last run's date

Hi everyone, There is another interesting case I need to work on. Is there a way to schedule a run of a pipeline passing it, as parameter (to be used inside the new run) the last successful run date? In pseudo algorithm, this would be: Oracle Data Se...

All Python Function is not working in Script task

I have perfectly executed python code in my computer. However, same code does not execute in Script task. For instance, I used parse() function to format datetime. parse(“2017-08-27T00:00:00.000”).date() works in my computer, but not in script task....

SnapLogic - Integration Nation

Forum Posts

Explain this log

Output from script snap (Python) is writing incorrect

Logging to custom file

Mapping Question... Map to dynamic names?

Stored procedure versus multiple sql execute snaps

Rerun Pipeline until success

Pipeline Parameter being last run's date

All Python Function is not working in Script task

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...