What happens if you go into the SQLExecutor and go to Attributes to Expose and choose Populate from SQL Query?

@ebygomm​ 

it shows 6 columns, but when you click ok, it changes to one row of attributes, separated by comma.

It works perfect - if you leave it at version(8) of sqlexcutor, but as soon as you upgrade it or use a new one , it makes all the columns, as 1 row of columns, with comma seprated, and shows values as missing

That's weird, I've never seen that before.

Can you show us the SQL, or at the very least the SELECT part?

Yuck, that's not fun at all. Maybe it's better to delete the transformer and re add a fresh one. Sounds nasty

Hi @rudy_v​ ,

I'm sorry that you have encountered this issue. I was able to reproduce it so I have filed a ticket (FMEDESKTOP-10650) to request this fix.

In the meantime I'd recommend either stick to working with Version 8 for now, or alternatively with Version 9 rather than exposing attributes within the SQLExecutor you can use the AttributeExposer after the 'Result' output.

In this particular workflow, since you are using Creator > SQLExecutor, swapping this out with the SQLCreator might be a third option. I have confirmed this does not have the same issue.

UPDATE: This issue has been fixed for FME 2020.1.2.

@hollyatsafe​ 

Thanks - i thought it was an issue, but you cannot use it with new work benches, as it only has version 9, but i have used FME 2019, created it with version 8, and then open with 2020 to continue

My example is just one of many we have - probably over a 100+

So i have send to all developers to not upgrade the sqlexcutor to version 9

Regards

Rudy

Another possibility is to simply copy/paste the transformer between FME versions.

Good Day,

Thanks - SQLExecutor are working correctly now with the updated release of 2020.1.2

Rudy