We are trying to collect Accounts and EMP id's in the below format from the CSV file.
I am using below query to fetch only emp id in the string. It is working fine in Oracle database but failing in the Aveksa ADC collector.
select distinct substr(substr(column2,(instr(column2,'--'))+2),1,instr(substr(column2,(instr(column2,'--'))+2),'--')-1) as UserID from Tet_UserToRoles where column1 not like '%Account%'
Test failed with the follwoing error:
Can someone please help on this to work the collector.