So is it a problem with the code ?

Wow, it worked. 🙂

select count(*), AVG(CAST(datalength(embedded_data) AS BIGINT)) from task_attach where id_task_user in (

select id

from task_user

where task_type = 2

and date_begin >= CAST(CAST(DATEADD(DAY,-180,GETDATE()) AS DATE) AS DATETIME)

)

The output is

0, NULL

When i run the whole query below i get error. The subquery runs successfully.

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type int.

select...

The sub query gets executed successfully.

Below script is of task_user

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[task_user](

[id] [uniqueidentifier] NOT NULL,

[id_acs_user] [uniqueidentifier] NOT NULL,

[task_type] [int] NOT NULL,

[name] [nvarchar](15) NOT NULL,

[status] [smallint] NULL,

[xoperation] [ntext] NULL,

[xparameters] [ntext] NULL,

[xreport] [ntext]...

Yes ID column is primary key and ID_TASK_USER is foreign key with unique identifiers. Below is the script

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[task_attach](

[id] [uniqueidentifier] NOT NULL,

[id_task_user] [uniqueidentifier] NOT NULL,

[detail]...

Its foreign key. Unique identifier Not Null.

Yes I used COUNT_BIG and got the same error. Also I don't use any other expression.

Yes the query gets executed successfully from SSMS apart from the third step where I get error Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to...

You mean to say like this.

JDBC URL: jdbc:sqlserver://srvrname.dbms.sqlservercentralcom:10000;SelectMethod=Direct;DatabaseName=TEST

??

Yes I have tried backing up keys and its good. No issues over there. I am looking out for a cause why its happening.

No there was no migration of report server DB's. It was implemented here on this server and its not a DEV -> PROD migration.

Yes I do have monitoring SCOM. But still from my side if I have some scripts it would be easy to extract the reports. Can you kindly share the scripts...

I use 32 bit os. Yes referred the links. Start-RUN-ODBCAD32-System DSN- Click Add- the driver DB2OLEDB is not appearing. Will this be an issue. However the same appears on SSMS-Linked...