Have created SQL adapters to connect Service Desk Manager MSSQL MDB database in CA BSI. Such adapters are not working eventhough its SQL QUERY is working fine in SQL server and getting records in the same.
1) First SQL adapter created, whose status showing in 'Started' state however no records found under Event Management eventhough I can see records are coming in adapterstatistics file and no errors found in log file.
2) Second SQL adapter created, whose status showing in 'Error' state post multiple attempts. I can see below errors in log file. Its Query is working fine and getting records in SQL Server.
<msg l="E" s="0" u="5" code="ffffffff" msg="Adapter message" o="Oblicore Adapter critical" f="Query.cpp" ln="606" t="07/09/2016 09:42:03" info="Error in Fill Data of "NewQuery" query. Caught COM ERROR in operation QUERY (Select DATEADD(ss, call_req.open_date,CONVERT(DATETIME,'01-01-1970 05:30:00', 121)) as OPEN_DATE, DATEADD(ss, call_req.resolve_date, CONVERT(DATETIME,'01-01-1970 05:30:00', 121)) as RESOLVE_DATE, datediff(n,(dateadd(ss,call_req.open_date,'01/01/1970 05:30:00 am')),dateadd(ss,call_req.resolve_date,'01/01/1970 05:30:00 am')) as [RESOLUTION_DURATION], call_req.ref_num, call_req.summary, call_req.status From call_req where call_req.resolve_date is not null and OPEN_DATE<CONVERT(datetime,'1/1/1970 12:00:00',104) order by OPEN_DATE desc) [[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type datetime. (HR: 0x80040e57) (IDispatch error #3159) (Source = Microsoft OLE DB Provider for ODBC Drivers)][(Error #80040e57) (Source = Microsoft OLE DB Provider for ODBC Drivers) (Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type datetime.) (SQLState = 22003) (NativeError: 1fb3)]"/> <msg l="I" s="0" u="5" code="ffffffff" msg="Adapter message" o="Oblicore Adapter critical" f="SqlInterface.cpp" ln="97" t="07/09/2016 09:42:03" info="Disconnect from critical"/>
Anyone faced similar issue in CA BSI. Appreciate Quick help on this.
Regards,
Manisha