Is it a best practice to add indexes to TN tables?( as they are wM tables)
the doQuery is done on documents ie query type ‘1’.
Where wud I have more information on what exact tables will the query search & what exact tables to have index.
Also One more question.
When I run the service which has the doquery in it and is taking forever and when it is stopped/close from developer window ,wud it bring the server down. Looks like It happened to twice …dont know if it is a coincidence.
Server log :
[ISS.0098.0036E] DefaultProducer encountered Transport Exception:
com.wm.app.b2b.server.dispatcher.exceptions.EndpointUnavailableException:
[ISS.0098.9014] BrokerException: Timeout (112-1450): The request timed out.
[ISC.0063.9998E] Exception →
java.sql.SQLException: [wm-cjdbc40-0034][Oracle JDBC Driver]Login has timed out.
There are no issues with adding indexes to wM-defined tables. At places where we’ve done so performance improved dramatically.
The tables can be viewed in the DB. Visio can reverse engineer them if you find ER diagrams helpful.
The TN creation and execution scripts used to be in a directory in your installation. That may have changed with 7 or 8 so I’m not sure if they are still there. If they are there you can see the table definitions and such.