LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  DB Node Query - Access

    Employee
    Posted 04-02-2014 08:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Brad Brezinski

    Issue is that user GH0309, with full access to the tables being queried, retrieves no data when using her id, but running the same node with CC4211, data is retrieved. GH0309 is able to retrieve accurate data using same query in Teradata.

    GH0309 is able to retrieve data using BRE from a different table in same Database View (ecars.pc_manual_adjustment).

    We have attached the node debugs files. What should be try next.

    Thanks in advance,
    Brad
    Attachments:
    Nodes_by_Status.zip


  • 2.  RE: DB Node Query - Access

    Employee
    Posted 04-03-2014 13:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: DanRosenblatt

    Is the node running successfully and returning zero rows, or is it giving an error message? Are you using CLI or ODBC?

    This sounds somewhat similar to the issue reported here: http://community.lavastorm.com/threa...ed-using-my-id , where a user was able to get data with Teradata SQL Assistant, but not through BRE. Although from the post it is unclear whether or how this was resolved, any remaining documentation on your end of this problem may help in revealing a solution. Otherwise you may to open a case with Support for further investigation.