9999:wm.tn.portal.queries:doQuery (docTypeQuery) encountered execution error. The main connection to the data store has not been initialized. Check the Trading Networks JDBC connection pool

vachaspati_Diwevedi1 · May 31, 2022, 9:16am

What product/components do you use and which version/fix level?

webMethods IS, TN, MWS 10.5

Are you using a free trial or a product with a customer license?

Licensed

What are trying to achieve? Please describe in detail.

Tring to query TN transactions

Do you get any error messages? Please provide a full error message screenshot and log file.

9999:wm.tn.portal.queries:doQuery (docTypeQuery) encountered execution error. The main connection to the data store has not been initialized. Check the Trading Networks JDBC connection pool.

Have you installed latest fixes for the products

Yes

Can you please suggest how to resolve this issue

Holger_von_Thomsen · May 31, 2022, 11:20am

Hi Vachaspati,

are there any further error messages in server.log indicating why the JDBC Pool could not be initialized?
Might require a shutdown and restart of IS to get a fresh server.log file.

Regards,
Holger

vachaspati_Diwevedi1 · June 1, 2022, 4:45am

Hi Thomsen,

On startup we got bellow error message in TN IS

[ISU.0000.9999C] (tid=1269) com.wm.app.tn.db.DatastoreException: null
(0) com.wm.app.tn.db.DatastoreException: Database with alias:TNS does not contain proper Trading Network db tables version, expected version:v10.5.fix2 got:v10.5.fix10

as per the empower blog after removing this jar /IntegrationServer/instances/default/packages/WmDeployer/code/jars/static/tncore.jar and starting the IS, the issue got resolved.

Holger_von_Thomsen · June 1, 2022, 11:28am

Hi Vachaspati,

not sure how the Deployer tncore jar is affecting the normal TN package.

From the error message this looks like a Fix version mismatch between TN packages and TN Database schema Fixes.
Looks like TN database was updated to a newer version, which was not applied to the IS/TN packages afterwards.