New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE
Highlighted
Cadet 3rd Class
Cadet 3rd Class
402 views

Flex ID-Based - sqlException - invalid column index

Dear All,

 

Appreciate your help in below case.

I have Oracle DB and I need to collect Application logs from Custom Table within this DB, I am using Oracle Flex ID Based .

we build the query and run it over DB Direct and successfully get needed result ,afterthat I go to apply within sdid file for Flex and got the error  "invalid column index",we try all different syntax for the query and none of changes successfully gave us any valid data.

this took long time and I did ot have any new thing to add ,so appreciate if any one have a valid soluton for that .

---------sdkidfilereader.prop----------------------

version.id=1
version.order=1
version.query=SELECT * from V$VERSION
query=select * from AUD_LOG a,AUD_COLUMNS b where a.seqno=b.seqno and b.oldvalue is not null
id.field=SEQNO
maxid.query=select max(AUD_LOG.SEQNO) from AUD_LOG

 

token.count=12

token[0].name=SEQNO
token[0].type=String
token[1].name=TABNAME
token[1].type=String
token[2].name=PKSTRING
token[2].type=String
token[3].name=OPERTYPE
token[3].type=String
token[4].name=TIMESTAMP
token[4].type=String
token[5].name=USERNAME
token[5].type=String
token[6].name=OS_USERNAME
token[6].type=String
token[7].name=TERMINAL
token[7].type=String
token[8].name=SEQNO_1
token[8].type=String
token[9].name=COLNAME
token[9].type=String
token[10].name=OLDVALUE
token[10].type=String
token[11].name=NEWVALUE
token[11].type=String

event.deviceEventClassId=SEQNO
event.deviceCustomString3=TIMESTAMP
event.deviceAction=COLNAME
event.deviceProduct=__stringConstant("ATM Application")
event.deviceCustomString3=__stringConstant("10.1.17.228")
event.deviceCustomString3Label=__stringConstant("ATM Application DB Address")
event.deviceCustomString2=NEWVALUE
event.deviceCustomString2Label=__stringConstant("Application After Changes")
event.categoryObject=SEQNO_1
event.deviceCustomString1=OLDVALUE
event.deviceCustomString2Label=__stringConstant("Application Before Changes")
event.sourceUserName=OS_USERNAME
event.deviceVendor=__getVendor("ATM")
event.message=PKSTRING
event.originator=OPERTYPE
event.destinationUserName=USERNAME
event.deviceHostName=TERMINAL
event.name=TABNAME

------------------------------------------------------------------------------

 

Thanks,

 

0 Likes
2 Replies
Highlighted
Admiral
Admiral

Hello

For DB's you should use another format in your parser. No need for tokens

Try this method

your query will look like this

select columnA,columnB,columnC from AUD_LOG a,AUD_COLUMNS b where a.seqno=b.seqno and b.oldvalue is not null
id.field=SEQNO

 

event.deviceEventClassId=columnA
event.deviceCustomString3=columnB
event.deviceAction=columnC

This should do the trick

Best regards

David

0 Likes
Highlighted
Cadet 3rd Class
Cadet 3rd Class

Many Thanks David ,I have excluded the AUD_COLUMNS from query and make some changes on Select query ,then this go fine .

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.