LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: GreggB

In some of my graphs I generate a list of keys then do database queries to get data for those keys. I then add the data returned by the query using a lookup node. Occasionally, the query will not find data for any of the keys, resulting in an empty lookup data set going into the lookup node. This causes an error in the lookup node - stopping the graph.

Since, in the context of my graph, this is not an error condition, I need to find a way of having the graph continue, either by bypassing the lookup or having the lookup node continue to successful completion in spite of the empty lookup input. The only solution I've been able to think of so far is to merge a dummy row into the results of the query. I'm hoping there is a more elegant solution.

Thanks,
Gregg.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

Hi Gregg,

You could
1. Have a dummy record in created in a static node with the appropriate columns and is filtered later in the graph

or

2. Have a metacheck on it on record count and go a different path.

Thats my suggestions.

Regards
Wayne

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: GreggB

Hi Wayne,
I was able to run one path or another depending upon a row count. But I got stuck when I came to bringing the two paths together again. I can't see a node that will let me take one i/p or the other, even if one did not run.

Gregg.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

EmptyJDBCQueryOutput.brgEmptyJDBCQueryOutput.brpGregg, here is an example I got from Ernest at Lavastorm a while ago when we had a similiar issue.

Does that help?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: GreggB

I just couldn't get it to work... I kept running into the same dead end where I had something that would not run if a previous step failed.

I ended up just adding a dummy row to the lookup data. I probably could have used an xref instead of a lookup (xref is quite happy with empty i/p) but I didn't want to do the analysis and testing to ensure that I always got the same results as the lookup.

Gregg.