AnsweredAssumed Answered

ADC collector configuration TEST Failed

Question asked by Muneendra Sriram on Oct 26, 2017
Latest reply on Oct 26, 2017 by Pradeep Kadambar

Hello All,

 

We are trying to collect Accounts and EMP id's in the below format from the CSV file.

 

--11223--  User1

--11443--  User2

 

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.

 

Thank you!

Outcomes