
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
db time based flex connector
have an issue where our time based flex connector will not retereive data from the various fields. When I run the query string used against the database (same user) it returns the appriopriate data. Any ideas on what is causing it? logs below.
<CODE MAP: 'SYSTEM'>
<ArcSight Version: 5.1.1.5782.0>
[2011-03-19 00:05:15,691][FATAL][default.com.arcsight.agent.sdk.d.c.g][processQuery] Unable to get the value for a unique id field [descrp] in fields [{stat_cod=A, descrp=null, lname=lname1, evnt_descrp=Local Grant, panel_descrp=null, _DB_DSN=db_arcsight, comp_name=Group1, _DB_URL=jdbc:odbc:db_arcsight, _DB_DRIVER=sun.jdbc.odbc.JdbcOdbcDriver, evnt_addr=500, cardno=null, rec_dat=1300464464000, fname=Amber}]
[2011-03-19 00:05:15,691][FATAL][default.com.arcsight.agent.sdk.d.c.g][processQuery] Unable to get the value for a unique id field [descrp] in fields [{stat_cod=A, descrp=null, lname=lname2, evnt_descrp=Local Grant, panel_descrp=null, _DB_DSN=db_arcsight, comp_name=Group2, _DB_URL=jdbc:odbc:db_arcsight, _DB_DRIVER=sun.jdbc.odbc.JdbcOdbcDriver, evnt_addr=500, cardno=null, rec_dat=1300464465000, fname=Carolee}]
[2011-03-19 00:05:15,691][FATAL][default.com.arcsight.agent.sdk.d.c.g][processQuery] Unable to get the value for a unique id field [descrp] in fields [{stat_cod=A, descrp=null, lname=lname1, evnt_descrp=Local Grant, panel_descrp=null, _DB_DSN=db_arcsight, comp_name=Group1, _DB_URL=jdbc:odbc:db_arcsight, _DB_DRIVER=sun.jdbc.odbc.JdbcOdbcDriver, evnt_addr=500, cardno=null, rec_dat=1300464469000, fname=Amber}]
[2011-03-19 00:05:15,691][FATAL][default.com.arcsight.agent.sdk.d.c.g][processQuery] Unable to get the value for a unique id field [descrp] in fields [{stat_cod=A, descrp=null, lname=lname3, evnt_descrp=Local Grant, panel_descrp=null, _DB_DSN=db_arcsight, comp_name=Group3, _DB_URL=jdbc:odbc:db_arcsight, _DB_DRIVER=sun.jdbc.odbc.JdbcOdbcDriver, evnt_addr=500, cardno=null, rec_dat=1300464474000, fname=Dona}]
[2011-03-19 00:05:15,691][FATAL][default.com.arcsight.agent.sdk.d.c.g][processQuery] Unable to get the value for a unique id field [descrp] in fields [{stat_cod=A, descrp=null, lname=lname4, evnt_descrp=Local Grant, panel_descrp=null, _DB_DSN=db_arcsight, comp_name=Group4, _DB_URL=jdbc:odbc:db_arcsight, _DB_DRIVER=sun.jdbc.odbc.JdbcOdbcDriver, evnt_addr=500, cardno=null, rec_dat=1300464477000, fname=Mayci}]
[2011-03-19 00:05:15,691][FATAL][default.com.arcsight.agent.sdk.d.c.g][processQuery] Unable to get the value for a unique id field [descrp] in fields [{stat_cod=A, descrp=null, lname=lname5, evnt_descrp=Local Grant, panel_descrp=null, _DB_DSN=db_arcsight, comp_name=Group5, _DB_URL=jdbc:odbc:db_arcsight, _DB_DRIVER=sun.jdbc.odbc.JdbcOdbcDriver, evnt_addr=500, cardno=null, rec_dat=1300464478000, fname=Koren}]