WmOAAdapter selecting Transaction Definition issue

[satya2k2]

Hi All,

I'm trying to create an Adapter service to insert data into Oracle Applications.

I do have sample Transaction Definitions in the webMethods repository. While trying to associate Transaction Definition in the Adapter(insert SQL) Service, I'm getting the following error...

com.wm.app.b2b.server.ServiceException: [ART.114.205] Adapter Runtime (Metadata): Unable to lookup the resource domain values.
[ADA.400.110] Exception caught: Transaction Names are not Available
on txnName [Ljava.lang.String;@1bf039d

java.lang.Exception: Adapter values are not available.

Please help...

Thanks in advance,
SATYA.

[leonlee]

Hi Satya,

Just try to disable and re-enable the connection to the Oracle Apps db. If that doens't re-establish the connection, you may have to bounce the IS explicitly and set min connections to 0.

Leon

[satya2k2]

Hi Lewis,

Tried all the options you said, still no luck, not able to see the transaction definitions and getting the same error.

Thanks,
SATYA.

[leonlee]

Hey are you using BatchInsert JDBC Adapter service? What is yur JDBC connection type ? Is it LOCAL_TRANSACTION or NO_TRANSACTION connection?

[satya2k2]

Leon,

I'm not using the JDBC Adapter. I'm using WmOAAdapter to connect to Oracle Applications and its making use of LOCAL_TRANSACTION.

Thanks,
SATYA.

[jyothi]

Hi,

Have you imported the sample transactions (.txp files) into webMethods IS? You can only make use of them after importing them into webMethods.

Usha

[satya2k2]

Jyothi,

Yes, they are imported into webMethods IS. Looks like its a strange error, not able to figure it out.

Thanks,
SATYA.