Designer - Too much time to open an adapter service

[Renan_Lopes1 (Renan Kaic Lopes)]

Product/components used and version/fix level:

Integration Server 10.3
Designer 10.3
JDBC Adapter 10.3 Fix #20

Detailed explanation of the problem:

Hello!
We have a JDBC adapter set and connected in our Integration Server.
I created some adapter services that will make use of it.
It works but, for some reason, it takes a very very long time to load in Designer and I stick with the following situation:

I don’t know why this is happening. When pinging from our I.S server to the Database destination server, I get only 200-300ms of ping. It’s not the best scenario, but isn’t the worse.

Please ,is there anything that I could do to solve this issue? This is happening with a specific database, the other ones are OK and loads really fast.

Error messages / full error message screenshot / log file:

No error but I get frequent “Not Responding” status in SAG Designer

Question related to a free trial, or to a production (customer) instance?

Production (Customer)

[Senthilkumar_G]

Check this old thread, similar issue reported in Designer 10.3. There is a network connection preference that we could change and verify.

Designer 10.3 loosing session, services getting read-only

Hi folks, Did anyone bumped into this? In the midst on a session, the Designer (10.3), out of blue, loses the session (“connection lost”) or you simply are not allowed to apply any change on an already locked service (eg. add a variable into the pipeline, or adding a new step into the flow? These are the fixes applied into the IS (IS Admin | About | Software | Updates): IS_10.3_SPM_Fix1 IS_10.3_Core_Fix8 IS_10.3_SPM_Fix4 The Designer runs on my computer (a Windows -based machine) and the…

Also, have latest fixes for designer as well.

[Dave_Laycock1 (Dave Laycock)]

Does your database have a very large number of objects? I have found that some of the design-time metadata SQL queries performed by the adapter perform incredibly poorly for certain databases. E.g. Oracle E-Business Suite has almost 200,000 tables/synonyms/views. The adapter can freeze Designer for over 24 hours looking up the table/column metadata for this database.

If that is the case, you can use the TableFilter connection property to limit the metadata lookup
https://documentation.softwareag.com/webmethods/adapters_estandards/Adapters/JDBC/JDBC_10-3/10-3_Adapter_for_JDBC_webhelp/index.html#page/jdbc-webhelp/to-config_conn_tablefilter.html

However, I found maintaining that property cumbersome. I just create CustomSQL adapter services, which do not do metadata lookups

[Renan_Lopes1 (Renan Kaic Lopes)]

Hello Dave!

Yes, the database that our IS is connecting to is really big and it’s a TIBERO database.
I’ll try the TableFilter property soon and I’ll let you know if it improved.
Unfortunately, even using the customSQL it takes a lot of time to load the adapter in Designer.

Thank you very much!