Execute Query: Object reference not set to an instance of an object

Help Studio
, ,
1

Hi,
I use Execute Query activity to retrieve data from a oracle database. this works in my machine without any error. but it doesn’t work in another machine.

2

Hey @dilii
Test the connection once and check if the table is specified properly.

3

Checked it. those are correct.

4

Are you using your system as a server or you have and ID and password?

5

I have a username and password

6

Okay, then maybe the table is not getting retrieved because this error comes when there is a null value.
Mind sharing screenshots?

7

Thanks @Parth_Doshi. it is not giving a null value.
image

8

So you’re problem is solved right? @dilii

If yes please mark it as solution.

9

no still the problem is there.
image

10

Did this get resolved? I’m having the same issue today. I know my connection is good and I’m connecting before executing my query. I’m passing a variable in my sql and i know it is passing but my new sql I keep getting the Object reference not set to an instance of an object. I have confirmed that my data table that I’m hitting has date for the item I’m looking for. And this is such a simple SQL:
“select birthdate from dbo.locust where tax_id_nbr =” + strSSN

I’ve tried it several ways and keep getting same error–
“select BIRTHDATE from dbo.locust where tax_id_nbr like '%”+strSSN+“%'”
“select birthdate from dbo.locust where tax_id_nbr like '%” + strSSN + “%’ limit 1”
“select birthdate from dbo.locust where birthdate and tax_id_nbr like '%” + strSSN + “%’ limit 1”
“select birthdate from dbo.locust where birthdate and tax_id_nbr =” + strSSN + “’ ;”
“select birthdate from dbo.locust where tax_id_nbr =” + strSSN + “’ ;”
“select birthdate from dbo.locust where tax_id_nbr =” + strSSN
“select BIRTHDATE from dbo.locust where TAX_ID_NBR like '%” + strSSN + "%’ "
“select BIRTHDATE from dbo.locust where TAX_ID_NBR =” + strSSN + "%’ "
“select BIRTHDATE from dbo.locust where TAX_ID_NBR like '%” + strSSN + “%’ limit 1”
“select BIRTHDATE from dbo.locust where TAX_ID_NBR like '%” + strSSN + “%'”

see very simple so don’t know what the deal is.

birthdate is the name of the column I’m needing to get. the table is dbo.locust and the column header that has the ssn is tax_id_nbr

Thanks for any assistance.

11

the problem that was there was no required permission given to the relevant tables.

12

Thanks, I had a team member help me out it was not a permission thing.
Have a great day.