ALERT! The community will be read-only on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only on April 19, 8am Pacific as the migration begins.Read more for important details.
Captain
Captain
295 views

Have Issue With Flex connector and MsSQL 2012 (Unable to detect database version)

Jump to solution

Hi everyone

I have issue with flex for MsSQL 2012.

In agent.log i see:

[2016-11-21 19:48:17,503][ERROR][default.com.arcsight.loadable.soap.v1.CWSAPIImpl][toResult] Parameter Verification Result [

Total Errors [1]:

Error[1]: [Unable to detect database version.

]

in agent.out.wrapper:

INFO   | jvm 1| 2016/11/21 19:18:13 | [Full GC (Metadata GC Threshold)  75629K->28636K(1035520K), 0.1045320 secs]
INFO   | jvm 1| 2016/11/21 19:18:15 | ====> Stopping ArcSight SmartAgent with exit code: 0.
INFO   | jvm 1| 2016/11/21 19:18:16 | [Mon Nov 21 19:18:15 AST 2016] [INFO ] Processing request from [127.0.0.1] for service method [login]
INFO   | jvm 1| 2016/11/21 19:18:16 | FATAL EXCEPTION:
INFO   | jvm 1| 2016/11/21 19:18:16 | No password has been defined.  Will use default.
INFO   | jvm 1| 2016/11/21 19:18:16 | [Mon Nov 21 19:18:16 AST 2016] [INFO ] Processing request from [127.0.0.1] for service method [login]
INFO   | jvm 1| 2016/11/21 19:18:16 | [Mon Nov 21 19:18:16 AST 2016] [INFO ] Shutting Down Agent Framework Version [7.3.0.7886.0]
INFO   | jvm 1| 2016/11/21 19:18:16 |
INFO   | jvm 1| 2016/11/21 19:18:16 | Shutting down Agent Modules now...

i have small config for timebase db (name: base.sdktbdatabase.properties)

My SQL DB - is MsSQL 2012

I see here version of MsSQL here https://support.microsoft.com/en-us/kb/321185

I used a config checker Flex ODBC config checker v1.2(x64).exe and I doesn't see any mistakes.

In logs Flex ODBC config checker v1.2 i have:

11/21/16 20:01:09| ------------Program started------------

11/21/16 20:01:09| [Image painted] Type: *

11/21/16 20:01:10| [Image painted] Type: *

11/21/16 20:01:12| [DB based on] Selected: Time

11/21/16 20:01:14| [*sdktbdatabase.properties file selected] C:\Program Files\ArcSightSmartConnectors\current\user\agent\flexagent\mssql\base.sdktbdatabase.properties

11/21/16 20:01:14| [version.order=] version.order=1

11/21/16 20:01:14| [SQL query original with ?] SELECT Date,Time,CTRno,CTRdoorNo,Location,HolderName,CardNo,Division,EntryExit FROM newskuddbv2.dbo.EntryExitFile WHERE Date>=? Order BY Date

11/21/16 20:01:14| [SQL query (after apply)] SELECT Date,Time,CTRno,CTRdoorNo,Location,HolderName,CardNo,Division,EntryExit FROM newskuddbv2.dbo.EntryExitFile WHERE Date>= Order BY Date;

11/21/16 20:01:14| [timestamp.field=] timestamp.field=Date

11/21/16 20:01:14| [uniqueid.fields=] uniqueid.fields=Time

11/21/16 20:01:14| [Image painted] Type: >=?

11/21/16 20:01:16| [DB Soft] Selected: MsSQL

11/21/16 20:01:19| [DNS odbcad32.exe] odbcad32.exe has been started

11/21/16 20:01:25| [Image painted] Type: >=?

11/21/16 20:01:25| [Image painted] Type: >=?

11/21/16 20:01:36| [Checkbox has been selected]

11/21/16 20:01:36| [Image painted] Type: >=?

11/21/16 20:01:39| [Checkbox has been selected]

11/21/16 20:01:39| [Image painted] Type: >=?

11/21/16 20:01:43| [? symbol was replaced with your start value]

11/21/16 20:01:43| [DB based on] Selected: Time

11/21/16 20:01:44| [version.order=] version.order=1

11/21/16 20:01:44| [SQL query original with ?] SELECT Date,Time,CTRno,CTRdoorNo,Location,HolderName,CardNo,Division,EntryExit FROM newskuddbv2.dbo.EntryExitFile WHERE Date>=? Order BY Date

11/21/16 20:01:44| [SQL query (after apply)] SELECT Date,Time,CTRno,CTRdoorNo,Location,HolderName,CardNo,Division,EntryExit FROM newskuddbv2.dbo.EntryExitFile WHERE Date>='' Order BY Date;

11/21/16 20:01:44| [timestamp.field=] timestamp.field=Date

11/21/16 20:01:44| [uniqueid.fields=] uniqueid.fields=Time

11/21/16 20:01:44| [Image painted] Type: >=?

11/21/16 20:01:47| [DB connect] Connect string: DSN=mssql_for_flex;UID=sa;PWD=AFcnELku-QvM

11/21/16 20:01:47| [DB query] SELECT Date,Time,CTRno,CTRdoorNo,Location,HolderName,CardNo,Division,EntryExit FROM newskuddbv2.dbo.EntryExitFile WHERE Date>='' Order BY Date;

11/21/16 20:01:49| [DB query result] Result list:

2009-11-27 00:00:00 | 06:17:17 | 0003 | 2 | Вход/основной/Мет | Username | 06151572 | Сектор АХС | Вход |

2009-11-27 00:00:00 | 06:18:24 | 0003 | 1 | Выход/основной/Мет | Username | 02127126 | Сектор АХС | Выход |

2009-11-27 00:00:00 | 06:18:32 | 0003 | 4 | Выход/основной | НUsername | 02127126 | Сектор АХС | Выход |

2009-11-27 00:00:00 | 06:19:48 | 0004 | 1 | Вход 5 этаж | Username | 02127126 | Сектор АХС | Вход |

2009-11-27 00:00:00 | 06:35:53 | 0004 | 4 | Кабинет | Username | 02127126 | Сектор АХС | Вход |

2009-11-27 00:00:00 | 06:40:46 | 0003 | 5 | Вход основной | Username | 00525481 | Сектор АХС | Вход |

2009-11-27 00:00:00 | 06:40:51 | 0003 | 2 | Вход/основной/Мет | Username | 00525481 | Сектор АХС | Вход |

2009-11-27 00:00:00 | 06:54:27 | 0001 | 7 | Комната302 | Username | 02120550 |  | Вход |

2009-11-27 00:00:00 | 06:55:10 | 0002 | 1 | Экономический сектор | Username | 02120550 |  | Вход |

2009-11-27 00:00:00 | 06:57:16 | 0002 | 2 | Бухгалтерия | Username | 02120550 |  | Вход |

11/21/16 20:01:49| [Image painted] Type: >=?

11/21/16 20:01:53| [Image painted] Type: >=?

11/21/16 20:01:54| [Image painted] Type: >=?

11/21/16 20:01:54| [Image painted] Type: >=?

11/21/16 20:01:54| [Image painted] Type: >=?

11/21/16 20:01:55| [Image painted] Type: >=?

11/21/16 20:01:55| __page selected__1

11/21/16 20:01:56| [Create table button was pressed]

11/21/16 20:01:56| Your mapping table:

event.deviceCustomDate1 | TimeStamp | Date

event.deviceCustomDate2 | TimeStamp | Time

event.deviceCustomString1 | String | CTRno

event.deviceCustomString2 | String | CTRdoorNo

event.deviceCustomString3 | String | Location

event.deviceCustomString4 | String | CardNo

event.deviceCustomString5 | String | Division

event.message | String | EntryExit

event.destinationUserName | String | HolderName

event.deviceVendor | String | __getVendor("MsSQL")

11/21/16 20:01:59| ------------Program finished------------

version.order=1

version.id=6.03

version.query=SELECT count(Date) from newskuddbv2.dbo.EntryExitFile

query.limit=5

query=SELECT Date,Time,CTRno,CTRdoorNo,Location,HolderName,CardNo,Division,EntryExit FROM newskuddbv2.dbo.EntryExitFile WHERE Date>=? Order BY Date

maxid.query=select max(Date) from newskuddbv2.dbo.EntryExitFile

#id.field=Date

timestamp.field=Date

uniqueid.fields=Time

event.deviceCustomDate1=Date

event.deviceCustomDate2=Time

event.deviceCustomString1=CTRno

event.deviceCustomString2=CTRdoorNo

event.deviceCustomString3=Location

event.deviceCustomString4=CardNo

event.deviceCustomString5=Division

event.message=EntryExit

event.destinationUserName=HolderName

event.deviceVendor=__getVendor("MsSQL")

Anybody can show me where my mistake? I can give more information if need.

0 Likes
1 Solution

Accepted Solutions
Captain
Captain

I understand where was my mistake.

When configure connector need to insert in row with folder dir name where is properties file

Example:

have c:\Program Files\ArcSightSmartConnectors\current\user\agent\flexagent\mssql\base.sdktbdatabase.properties

need to write only mssql (It is dir that i create when make a config base.sdktbdatabase.properties)

View solution in original post

0 Likes
1 Reply
Captain
Captain

I understand where was my mistake.

When configure connector need to insert in row with folder dir name where is properties file

Example:

have c:\Program Files\ArcSightSmartConnectors\current\user\agent\flexagent\mssql\base.sdktbdatabase.properties

need to write only mssql (It is dir that i create when make a config base.sdktbdatabase.properties)

View solution in original post

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.