Error occured while creating a mount smb:///
I am encountering a error with my file writer snap while trying to write to a file share on a different server. The error is as follows: Error occured while creating a mount smb:///. I dont think this is a permissions issue as I have granted access to the account I am using on the server I am trying to write to. That got me past an access denied error that I had encountered earlier in testing. I am also open to any suggestions you may have to help me better troubleshoot. Thank you for any help in advance, it is greatly appreciated!
Programmatically get SLPROPZ contents and write to a file
Within a pipeline, how can I programmatically access the SLPROPZ file for a snaplex, and write the contents of the file out to the local hard drive? We have over 500 snaplexes that we need to do this for, so manually downloading them all is not a good solution. Also, for various reasons I won’t go into, we cannot employ an outside task that just pings each download endpoint. This HAS to be done from within a set of pipelines. The SnapLogic Metadata snaps give me the ability to list Snaplexes and to read them as a set of JSON attributes. But there seems no way to obtain (or reconstruct) the SLPROPZ file. Any help that can be provided will be much appreciated!
Create a file path with a date in File Writer snap
I have a pipeline that generates an output file that I would like to save in S3 with a file path of YYYY/MM/dd/file_name… e.g. S3://bucket/2023/08/09/file_name.csv. When I do this: “s3:///bucket/”+Date.now().getFullYear()+“/”+Date.now().getMonth()+“/”+Date.now().getDate()+“/fil_name.csv” It generates a path of 2023/8/9, How can I programmatically determine when to pad it with a ‘0’ for single digit months and days without including this data in the document being saved?Reading BLOB data from SQL and write it to file share
Dear Community, I am successful in creating a pipeline that read blob data from SQL server and writing the file in SLDB. Now, I wanted to write the file on an SFTP server using File Writer - validation is okay but failed during execution. protocol: smb file name, = enable: targetDir + ‘/’ + $ID+ '’ + $[‘last-modified’] + ‘.jpg’ write empty file: check error: Failed to open output stream for … Reason: Unable to create/open Thanks in advance for the help.Writing files to on-premise servers
I am trying to write a file that gets created in a pipeline to one of our on-premise servers (i.e. sftp://ourschool:22/directory/filename.txt) and am getting the following error message: Unable to create filesystem object for sftp://ourschool:22/directory/filename.txt, Reason: Failed to get SFTP session connected Has anyone had any luck with this. I am trying to login with Basic Auth (username and password).
Partial File Creation using File Writer on FTP Destination
Hi, I am getting this weird issue of partial file creation while using ftp as destination. File size is less than 3 MB. I have tried below things but none of them seem to work: Changed FTP Destination server to rule out if issue was on specific FTP destination. Tried changing file format from .txt to .csv, .dat but same issue. Loaded content of file in DB and then reading the data from table and creating the file but again output file is sometimes partial file. File is getting created perfectly fine on sldb. Tried pushing it from sldb but again at destination its creating partial file. Only data getting truncated is at the last. Does anyone faced such issue? If yes, how you handled it.Append data to csv file with out repeating the header row
hi there, i am trying to append all the records for the day to that days CSV file which has date in the file name. all works fine, if it doesnt fnds the file for the day it creates the file. if it finds the files then it appends the data to the file. But one thing is keeps adding the column names as well to the file. How can i have the only data be appended and not the column headers? Thanks Manohar
