Unable to invoke adapter serviceUnable to get connection factory from connection

, ,
1

Try restarting webMethods server …

2

HI Chandra,

I tried restarting WM server also. Do you see any other reason?

Thank You,
Priyatham Porika
System Analyst/Process Analyst - Integration in DIA
Kansas State University
2323 Anderson Avenue, Suite 400W
Manhattan, KS 66502

3

Hi Guys,

I am getting the following error when I start the IS. I now solved all the above mentioned problems.

2005-03-04 14:43:10 CST wm.art.ns:getAdapterServiceTemplateList
com.wm.pkg.art.error.DetailedServiceException:
[ART.118.5040] Adapter Runtime (Connection): Unable to get adapter
service templates for connection connections:
OracleAppsDB. [ART.118.5048] Adapter Runtime
(Connection): Unable to get adapter service templates for connection resource connections:
OracleAppsDB. Stack trace data … 05809c008cee11d9a5b2ba1dbee7e14f NULL 05809c008cee11d9a5b2ba1dbee7e14f

2005-03-04 14:43:10 CST wm.art.ns:getAdapterServiceTemplateList [ART.118.5040] Adapter Runtime (Connection):
Unable to get adapter service templates for connection connectionsracleAppsDB. [ART.118.5048] Adapter Runtime (Connection):
Unable to get adapter service templates for connection resource connectionsracleAppsDB.
Stack trace data … 05809c008cee11d9a5b2ba1dbee7e14f NULL 05809c008cee11d9a5b2ba1dbee7e14f

2005-03-04 14:43:10 CST connectionsracleAppsDB [ART.118.5048] Adapter Runtime (Connection):
Unable to get adapter service templates for connection resource connectionsracleAppsDB.
Stack trace data … 05809c008cee11d9a5b2ba1dbee7e14f NULL 05809c008cee11d9a5b2ba1dbee7e14f

2005-03-04 14:41:20 CST wm.art.ns:getAdapterServiceTemplateList com.wm.pkg.art.error.DetailedServiceException:
[ART.118.5040] Adapter Runtime (Connection): Unable to get adapter service templates for connection connectionsracleAppsDB.
[ART.118.5013] Adapter Runtime (Connection): Unable to find connection connectionsracleAppsDB.
Stack trace data … c3b336208ced11d9a56fba1dbee7e14f NULL c3b336208ced11d9a56fba1dbee7e14f

2005-03-04 14:41:20 CST wm.art.ns:getAdapterServiceTemplateList [ART.118.5040] Adapter Runtime (Connection):
Unable to get adapter service templates for connection connectionsracleAppsDB.
[ART.118.5013] Adapter Runtime (Connection): Unable to find connection connectionsracleAppsDB.
Stack trace data … c3b336208ced11d9a56fba1dbee7e14f NULL c3b336208ced11d9a56fba1dbee7e14f

2005-03-04 14:41:20 CST connectionsracleAppsDB [ART.118.5013] Adapter Runtime (Connection):
Unable to find connection connectionsracleAppsDB.
Stack trace data … c3b336208ced11d9a56fba1dbee7e14f NULL c3b336208ced11d9a56fba1dbee7e14f

Any idea?

Thanks,
priyatham Porika

4

Hi Guys,

I am having a new error now. The above mentioned error is gone somehow . The new error is as follows:

2005-03-07 09:35:55 CST wm.art.metadata:resourceDomainLookupValues
com.wm.pkg.art.error.DetailedServiceException:
[ART.114.205] Adapter Runtime (Metadata): Unable to lookup the resource domain values. [ADA.400.111] SQL Exception caught:
execSQL: SELECT ORGANIZATION_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE 1=2 AND ORGANIZATION_NAME = ‘’ Io exception: Broken pipe Stack trace data … 98a2feb08f1e11d985c5de1cba2d6032 NULL 98a2feb08f1e11d985c5de1cba2d6032

2005-03-07 09:35:55 CST wm.art.metadata:resourceDomainLookupValues [ART.114.205] Adapter Runtime (Metadata): Unable to lookup the resource domain values. [ADA.400.111] SQL Exception caught: execSQL:
SELECT ORGANIZATION_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE 1=2 AND ORGANIZATION_NAME = ‘’ Io exception: Broken pipe Stack trace data … 98a2feb08f1e11d985c5de1cba2d6032 NULL 98a2feb08f1e11d985c5de1cba2d6032

2005-03-07 09:35:55 CST wm.art.metadata:resourceDomainLookupValues [ADA.400.111] SQL Exception caught: execSQL: SELECT ORGANIZATION_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE 1=2 AND ORGANIZATION_NAME = ‘’ Io exception: Broken pipe Stack trace data … 98a2feb08f1e11d985c5de1cba2d6032 NULL 98a2feb08f1e11d985c5de1cba2d6032

2005-03-07 09:35:55 CST wm.art.metadata:resourceDomainLookupValues Io exception: Broken pipe Stack trace data … 98a2feb08f1e11d985c5de1cba2d6032 NULL 98a2feb08f1e11d985c5de1cba2d6032
2005-03-07 09:35:55 CST wm.art.metadata:resourceDomainLookupValues [ADA.400.111] SQL Exception caught: execSQL: SELECT ORGANIZATION_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE 1=2 AND ORGANIZATION_NAME = ‘’ Io exception: Broken pipe Stack trace data … 98a2feb08f1e11d985c5de1cba2d6032 NULL 98a2feb08f1e11d985c5de1cba2d6032

2005-03-07 09:35:55 CST wm.art.metadata:resourceDomainLookupValues Io exception: Broken pipe

Does anybody know how to fix this problem. Why is this problem arising?
Any solution for this?

Thanks in advance for your help guys.

Priyatham Porika
porikap@yahoo.com

5

Hi Priyatham - A “broken pipe” implies that your connection to the backend resource is stale. Maybe the database was bounced over the weekend? Just 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.

  • Rajesh
6

If the database is bounced, shouldn’t the connection be restored automatically as soon as the database comes back up.

Also, if some webMethods thread hoses up the connection, another invocation of the same adapter service can cause ‘broken pipe’ errors.

7

“If the database is bounced, shouldn’t the connection be restored automatically as soon as the database comes back up.”

It depends. What often happens is the JDBC connection pool is set to min connections of 1 or more. In trying to maintain this number of connections at all times, the adapter sometimes fails. Also, the connections it maintains can be “stale”–that is they exist but the first use of them causes a failure that is returned to the caller.

A common practice to avoid this is to set min connections to 0. This practice may be applicable/advisable for non-database connection pools too.

8

Rob/Vijay/Rajesh/chandra/RMG

Thanks everybody for your valuable suggestions. I solved the problem. I have to recreate the Adapter service, bounce back the IS and set min connections to 0 etc… I did all of these and I was able to overcome the problem.

Thank you.
Priyatham Porika

9

Glad you solved it.

10

Guys,

Quick question for you all.

I have the field AS_OF_DATE in the format like “040601” and AS_OF_TIME like '0000".

For the field AS_OF_DATE I am trying to convert it into right format. Current pattern as “MMddyy” and the New Pattern as “MM/dd/yyyy”.

For the field AS_OF_TIME I am trying to convert it into right format. Current pattern as “HHmm” and the New Pattern as “HHmmss”.

And later in my flow service I am concatenating these two fields into one and inserting.

But while executing the package it throws me an exception like:

2005-03-11 09:15:38 CST cashManagement1157.intoOA.bankStatement.custom:bizDocMapping com.wm.app.b2b.server.ServiceException: [ISS.0086.9189] Invalid date pattern or input Stack trace data … 6c4f7850924011d99b04f6c0f513d54b 6c4f7850924011d99b04f6c0f513d54b 6c5ce5d0924011d99b07f6c0f513d54b

2005-03-11 09:15:37 CST commonOA1157.custom:convertToDateObject com.wm.app.b2b.server.ServiceException: [ISS.0086.9189] Invalid date pattern or input Stack trace data … 6c4f7850924011d99b04f6c0f513d54b 6c5ce5d0924011d99b07f6c0f513d54b 6c5d33f0924011d99b08f6c0f513d54b

2005-03-11 09:15:37 CST commonOA1157.utils:dateTimeFormat com.wm.app.b2b.server.ServiceException: [ISS.0086.9189] Invalid date pattern or input Stack trace data … 6c4f7850924011d99b04f6c0f513d54b 6c5d33f0924011d99b08f6c0f513d54b 6c5d33f0924011d99b09f6c0f513d54b

2005-03-11 09:15:37 CST pub.date:dateTimeFormat com.wm.app.b2b.server.ServiceException: [ISS.0086.9189] Invalid date pattern or input

I am I doing anything wrong. Can anybody give me the right format please.

Thanks,
Priyatham Porika

11

I have the field AS_OF_DATE in the format like “040601” and AS_OF_TIME like '0000".

For the field AS_OF_DATE I am trying to convert it into right format. Current pattern as “MMddyy” and the New Pattern as “MM/dd/yyyy”. — this returns 04/06/2001 as expected.

For the field AS_OF_TIME I am trying to convert it into right format. Current pattern as “HHmm” and the New Pattern as “HHmmss”. —this returns ouput 000000 as expected

The above you shown is working fine tested with dateTimeFormat service.Plese make sure again if you are putting any spaces or typo in the format.it happens.

HTH,
RMG.

12

Thanks Ram!!!

This problem is fixed.

Have a nice weekend!!!

Priyatham Porika

13

I am getting the following error , when i am trying to configure a Insertnotifiaction having where condition on a sybase Database using a JDBC driver .

The error message is as under

"com.wm.app.b2b.server.ServiceException: [ART.114.205] Adapter Runtime (Metadata): Unable to lookup the resource domain values.
[ADA.1.310] The database vendor “Adaptive Server Enterprise” does not support the database trigger condition.
on when.leftExpr [Ljava.lang.String;@17828eb

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

The JDBC driver class I am using is com.sybase.jdbc2.jdbc.SybDataSource

14

Hi guys,

Need to know how to create notification using oracleapps adapter. I am trying to create notification to extract data from OracleApps. while creating notifications it is asking transaction name. What we should create transactions to give notifications. Please let me know if any body having idea on this problem.

Thanx & Regards
Govindh

15

Hi guys,

Need to know how to create notification using oracleapps adapter. I am trying to create notification to extract data from OracleApps. while creating notifications it is asking transaction name. What we should create transactions to give notifications. Please let me know if any body having idea on this problem.

Thanx & Regards
babu

16

HI ,

For creating a notification , we have to configure a JDBC adapter first …When creating this adapter it asks for transaction type , which can be specified as per requirement . For details on this u could check WmJDBCAdapterUserGuide.pdf from documentation.
As far as i recall there are 3 types , No_Transaction , Local_Transaction or XA_Transaction …specify this and proced.

sachin

17

Hi Sachin & all

To interact with Oracle database, we can use jdbc adapter. But, here I need to create notification on OracleApps Enterprise System. While creating notification using OracleApps Adapter, it is allowing only select transaction to asssociate to notifications. If I want to monitor on insert, update and delete transactions in OracleApps Server, What is the procedure to create notifications? Please let me know the solution of this question if any body knows.

Thanks & Regards
babu

18

The JDBC adapter user’s guide explains this.

However…

Be very careful.

Of course you would never write to the Oracle apps database through the JDBC adapter because you know you would be bypassing all of the data integrity logic built into the Oracle apps. This is a path to eternal torment.

But even if you are technically successful at ONLY reading the data, you must be certain you understand the (perhaps undocumented) rules associated with the data relationships/values. You have no assurance that Oracle will not modify the database structure for the next release of Oracle apps you go up on.

Finally, if your JDBC adapter starts throwing a lot of SQL at the database that it’s indexing/aggregation structure hasn’t anticipated, your DBAs are going to want to have a chat with you.

If you choose to proceed and you are having problems with setting up adapter notifications as described in the guide, please let us know the specifics.

Regards

19

Hi All,

 We are trying to integrate OracleApps11i with an external application.For that we are using the WebMethods provided OracleApps Adapter(WMOAAdapter 6.0).We are actually trying to create an insert notification on the base table of the oracle database.For that we had created a transaction defination with a select query on the base table(since it is not allowing us to create a transaction defination with an insert query for a notification).Once u create a notification and select a transaction a publishable document automatically gets generated with the specified fields in the select statement.Now if u go and create a record at Oracle Apps it ideally should publish that record to WM.This is not happening. 
In the OracleAppsAdapter user guide it has not mentioned clearly as to how the notification works,how does the monitoring on the database happen and where the buffer tables get created.How the notification internally works?

It would be really great if u can share the solution for this particular problem.

thnx
babu

20

Hi All,

We are trying to integrate OracleApps11i with an external application.For that we are using the webMethods provided OracleApps Adapter(WMOAAdapter 6.0).We are actually trying to create an insert notification on the base table of the oracle database.For that we had created a transaction defination with a select query on the base table(since it is not allowing us to create a transaction defination with an insert query for a notification).Once u create a notification and select a transaction a publishable document automatically gets generated with the specified fields in the select statement.Now if u go and create a record at Oracle Apps it ideally should publish that record to WM.This is not happening.
In the OracleAppsAdapter user guide it has not mentioned clearly as to how the notification works,how does the monitoring on the database happen and where the buffer tables get created.How the notification internally works?
It would be really great if u can share the solution for this particular problem.

thnx
Girish