Issue on configuring Insert Adapter Service

, ,
1

Hi,

Based on the requirement from the User, we were to reconfigure the insert adapter service to insert date for new fields created on the DB table.

When i edit the adapter service to enter a new field, i am getting the below error.

com.wm.app.b2b.server.ServiceException: [ART.114.205] Adapter Runtime (Metadata): Unable to lookup the resource domain values.
34
on update.inputColumn [Ljava.lang.String;@16e3ecd java.lang.Exception: Adapter values are not available.

The fields already confirgured on the adapter service are having the correct values when compaired with the Table structure.

Any idea, why this would be happening and a possible solution would be appriciated.

IS version - 6.1
Files present in library

/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entbase.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entcertlist.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entcms.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entjsse.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entmisc.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entnsext.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entp10.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entp11.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entp12.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entp5.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entp7.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entserverlogin.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entsmime.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entsmimev3.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entssl.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/enttunnel.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entuser.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entroaming.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/entrust/entxml.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/jars/sl53_cj33.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/jars/ojdbc14.jar
/eai08/e001/webMethods6a/IntegrationServer/lib/jars/mfapi611.jar

2

Is the adapter connection enabled?

3

Yes, the connection is enabled with the below mentioned connection settings.

Connection Type JDBC Adapter Connection
Package Name GE_FRMT_JDBC_Adapter
Connection Properties
Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName gpsfrx82.energy.ge.com
user gepswm
password ******
databaseName gpsfrx82
portNumber 1564
networkProtocol tcp
Other Properties driverType=thin;connectionProperties={oracle.jdbc.V8Compatible=true}
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 0
Maximum Pool Size 20
Pool Increment Size 1
Block Timeout (msec) 30000
Expire Timeout (msec) 60000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

Infact… on further debugging the issue. I realize that i am getting the above error when i am accessing tables that come under one schema - GEPSWM. However when i am accessing tables in different schema, i dont see any issues (inspite of using the same connection).

What could be possible reason for this anomalous behaviour. As the login credentials have read/write access to the above mentioned tables.

Regards,
Yathindra

4

If you changed the DB structure after created insert service, I guess the adapter is caching the columns in IS, so they are out of sync.
Did you try to click the button on the top of the service: “Reload values from the adapter”? it still not working,
try to restart the IS, restarting should refresh the cache,
HTH,
Tong