I am getting error While using the In-Database

[Vishnusai]

Hi All,

I am getting the below error while using the filter in In-Database tool. any suggestion plz

[saveeshkumar]

Hi @Vishnusai ,

Are you able to fetch sample records from Connect IN-DB Tools without filter ??
Source DB ???

[Vishnusai]

I am Able Fetch records from DB, But when i am applying the Filter getting the error

[saveeshkumar]

@Vishnusai ,

Source DB ??
Are you using CTE ??

[Vishnusai]

i am using the Source DB

[saveeshkumar]

Hi @Vishnusai ,

Are you using CTE..

below sql like this .???

with ExpressionName as (Select * from TableName2) 

[Vishnusai]

I am using the below Query

select * from Tablename

[saveeshkumar]

Hi @Vishnusai ,

I am trying to replicate the above error but not able to get it..

CTE error is showing in the IN-DB browse tool..stilll checking on it.

Could you please try by adding datastream out tool and browse tool to check the output.

[Vishnusai · Accepted solution]

Hi @saveeshkumar 

Issue resolved automatically, After the restarting the system.