cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Filter snap throwing error

Sekhar2019
New Contributor

Iam getting below error ,please correct me.image

Message error as below :
Failure: Could not filter document., Reason: Filter expression: Sales is undefined. Perhaps you meant: parseFloat, isNaN, snap, jsonPath, Resolution: Please check the spelling of the variable

Please help.

11 REPLIES 11

anubhav_nautiya
Contributor

the pipeline which you are running, is it in shared folder? or some other folder, the files will be written in the same project space where pipeline is residing unless you have specifically provided a particular path in file write snap

Sekhar2019
New Contributor

I think it is in projects folder.
image

anubhav_nautiya
Contributor

your pipeline is in your folder(Sanath), could you please show the setting of the two file writer Snaps.

Regards
Anubhav

File1setting1 File1-setting2 File2-setting1 File2%20-setting2

stephenknilans
Contributor

BTW Maybe this is variable, or can be avoided in some way, but it is a good idea to determine where the files are wanted, and what space you can use.

For example, at least with reltioโ€™s implementation, you are limited to something like 100K. I might be wrong, and it may be 100M, but these days you are likely to exceed EITHER!

I ended up using MY ORGS shared folder for files, and that was only for SMALL files that were a good deal smaller than even 100K. The actual sources varied, but some were FTP files that I moved to S3 and read from there. If I had to write out โ€œflatโ€ files, INCLUDING REPORTS, I did THOSE to S3 also. Some of those files are over 100GB.

ALSO, watch out on shared folders. It looks like you only have two, so as long as the pipeline is in a folder underneath the projects fold, and you still only have two levels like that, for local files, you can put the file under โ€ฆ/shared/filename, with โ€œfilenameโ€ being what you want to call the file. THEN, your file will always be in the shared folder right under projects. REMEMBER though, make sure the admin and user are OK with that, and you donโ€™t exceed a quota.

ANOTHER thing, just so you know. White space, like that on the reader in your picture, indicates the snap isnโ€™t connected. So if you arenโ€™t getting any data, that is why. One neat feature SnapLogic just added, in the last release that you should have already, is an option to disable a snap. It does the SAME thing as idsconnection, but:

  1. Disables the snap.
  2. Puts a red circle with a slash through it, to be more obvious
  3. Is FAR easier to set and reset.

It is under the execute options for the snap. Instead of an enable preview option, it has a list. โ€œRUNโ€,โ€œRUN&PREVIEWโ€,โ€œDISABLEโ€โ€ฆ