SQL Variable Error

[Dillon McMahon]

I am trying to use the SQL variable object. At the moment, I am trying to return a table of "persons" from my database. When I click "preview" with the sql statement "select * from Persons", I get "The Login object 'LOGIN.DB.AGENT1' does not include a matching entry for the object 'VARA.SQL.NEW.1' in host 'ZY-AUTOMIC-WIN' ('SQL')". I not sure why I am getting this error. What can I do to resolve this?

[shani kushwaha]

Hi Dillon,

If I understand your query right, You will need to include the CONN object for DB in SQL tab and Login Object will not be needed.

Thanks
Shani

[Dillon McMahon]

Hi Shani,

Thanks for the reply. I have already tried that but still it does not work. When I try to run preview I get "no items available". Additionally, if I try to use the variable in a workflow I get "U02012053 RunID: '1022031/1': Failed to create a connection to the database.". The table exists in the database and the connection object works if I am trying to run a SQL job. Weirdly enough, in my connection object, when I run test connection, I get "U00052010 UCUCM: Login 'LOGIN.DB.AGENT1' for connection 'CONN.SQL.EXAMPLE' could not be resolved. Reason: 'no_Login_Entry'". Although I get this test connection error, I am still able to run SQL jobs on my database.

[shani kushwaha]

Hi Dillon,

PLease check this.

https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=b5045e92-6b29-46c2-9313-3bf1e5e36471&CommunityKey=1030d6fe-23f2-4e23-9a34-45ef6d9dfb7b&tab=digestviewer#bmb5045e92-6b29-46c2-9313-3bf1e5e36471

PLease raise a case with Support if workaround does not work. 

BTW, which version you are on?

Thanks 
Shani