Error in wm.tn.query:profileQuery

, ,
1

Hi,

I am trying to configure my TN 7.1.2. I have a Oracle DB on my system and TN related tables has been created in it. I was able to create Enterprise Profile. I can also creat Partner Profiles and in the backend they are visible in the table “PARTNER” (i.e. select * from PARTNER).

But when I run a search for Partner Profiles using the TNConsole it gives me the below error :confused::

ErrorMessage: ErrorDialog TRNCONS.000000.000003 ERROR partner.PartnerQueryResult doQuery Tue Nov 15 17:59:28 GMT+05:30 2011 java.lang.ClassCastException: com.webMethods.sc.caching.config.LocalSchemeConfig
com.wm.ui2.UiException: wm.tn.query:profileQuery com.wm.app.b2b.server.ServiceException java.lang.ClassCastException: com.webMethods.sc.caching.config.LocalSchemeConfig null wm.tn.query:profileQuery com.wm.app.b2b.server.ServiceException java.lang.ClassCastException: com.webMethods.sc.caching.config.LocalSchemeConfig null null

com.wm.ui2.UiException: wm.tn.query:profileQuery com.wm.app.b2b.server.ServiceException java.lang.ClassCastException: com.webMethods.sc.caching.config.LocalSchemeConfig at com.wm.ui2.UiException.handle(UiException.java:215) at com.wm.ui2.UiException.handle(UiException.java:184) at com.wm.app.tn.ui.Server.invoke(Server.java:379) at com.wm.app.tn.ui.profile.partner.PartnerQueryResult.doQuery(PartnerQueryResult.java:118) at com.wm.app.tn.ui.profile.partner.PartnerQueryResult.(PartnerQueryResult.java:93) at com.wm.app.tn.ui.profile.partner.TradingPartnerPanel$12.run(TradingPartnerPanel.java:861) at com.wm.app.tn.ui.util.swing.TNProgressThread.runSelf(TNProgressThread.java:42) at com.wm.ui2.UiProgressThread.run(UiProgressThread.java:52)

wm.tn.query:profileQuery com.wm.app.b2b.server.ServiceException java.lang.ClassCastException: com.webMethods.sc.caching.config.LocalSchemeConfig com.wm.app.b2b.server.ServiceException: java.lang.ClassCastException: com.webMethods.sc.caching.config.LocalSchemeConfig at com.wm.app.tn.db.QueryResult.getCache(QueryResult.java:922) at com.wm.app.tn.db.QueryResult.isQueryCancelled(QueryResult.java:523) at com.wm.app.tn.db.QueryResult.processPaging(QueryResult.java:202) at com.wm.app.tn.db.QueryResult.(QueryResult.java:144) at com.wm.app.tn.db.QueryResult.RunQuery(QueryResult.java:169) at com.wm.app.tn.db.QueryResult.RunQuery(QueryResult.java:158) at com.wm.app.tn.profile.ProfileStore.queryProfiles(ProfileStore.java:2199) at wm.tn.query.profileQuery(query.java:795) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403) at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:631) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237) at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119) at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:151) at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:186) at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:327) at com.wm.util.pool.PooledThread.run(PooledThread.java:118) at java.lang.Thread.run(Thread.java:595)

I have tried dropping and recreating TN tables using Database Component Configurator even reistalling TN but nothing has worked.

Please help.

2

Are you getting this error every time you query any section in TNC? or is it just intermittent?

I believe you should be OK even you get with this error:

HTH,
RMG

3

Everytime I search this error comes. And Once I click “OK” on the error report the search stops without displaying any result.

4

If the error still persists…you should also contact SAG tech support for a quick turn around:

Also do you have this service scheduled?

wm.tn.enumerate:deleteQueryResults

5

Drop the TN SQL scripts from your database and create/recreate once again than

Use Database Configuration Tool

6

It seems he did tried that options aswell:

7

Hi…
I applied some fixes to the TN and it started working fine :slight_smile:

Thanks

8

It Sounds good :slight_smile:

9

Glad to hear Issue resolved…I am sure fixes are there for this:

10

Hi Shilpa kumar,

we are facing the same kind of issue.
what are the fixes you applied ?

thanks,
Venkat

11

Hi Venkat,

make sure you have latest Fixes for TNS (Trading Networks Server), TN_MWS (Trading Networks UI on MWS) as well as latest DC_DBS Fixes for wM Version applied.

After applying the DC_DBS-Fixes run Database Configurator and select TradingNetworks Component as “migrate” to “latest” for your TN schema.

Additional Fix which might be helpful in this case:
SCG_DataDirect

Which Version of wM are you running on?

Regards,
Holger

12

Hi Holger,

we are doing this activity on wm8.0.
Trying to export from wm8.0 .

thanks,
Venkat