TDP Workbook 5.3 database connection error

Getting an error in TDP 5.3 when I open certain queries and try to change the database connection to my user id:

The objects that are used in your workbook flows... do they exist in the other database connection? Or, if it's the same database, but just a different user login, does your other user have the privs to see those objects?

Hi Gary, my user id and the other user id both have access to the objects used in the workbook.

OK... might need to take this one to Support, Steve.

Hi Steve,
do you use fully qualified queries?
Potentially your default db for both connections might not be the same as what you set in your Query Builder.

Hi Dan, I checked and the query in question is fully qualified. Also checked the default db connections and they were different, but since the query is fully qualified this shouldn't matter right? I tried changing the default db for the user to match mine, then had her open the query, process and re-save, but I'm still getting the same error when I open it.

FYI this error occurs in TDP version 5.3.0.333. I'm not getting this error in version 5.2.1.299.

Hi, I tried to reproduce but I didn't get any errors when switching users on Oracle.

  1. Can you try the isolated query in Editor so we can see whether it is connected to Toad or only Workbook?
  2. Can you send us the query file?
    Thanks!

Dan, the query runs fine in Editor with my user id. Attached is the query file (zipped .twf file and changed extension to PDF).

Legal costs.pdf (51.9 KB)

1 Like

Hello,

End users at our organization are experiencing the same issue with 5.3.0.333. We are currently on 5.0 and if this occurs, we are able to remove the tables we may not have access to and then execute the query. With 5.3.0.333, we are not able to proceed to alter the query at all.

image

Thank you,
Jeana

HI Dan, any updates on this issue?

Our devs are focussed on this. To my knowledge we still haven't been able to reproduce it, we'll let you know asap.

Hi Dan,

Is there an open SR for this item? Our organization will not proceed with an upgrade until this is resolved.

Thank you,
Jeana

Hi Steve,
we have fixed it but until the new release is out, you could try a workaround.
The new connection needs to have the same default schema as is in your query. On this condition it should be fine.
@jeanaf Yes - 16141 is the task number.

Hi Dan, is the new release out that fixes this issue? I'm running 5.3.0.333 and am still having this problem.

Steve

This is still happening in version 5.7.0.405. Is there a work around? Thank you.