Unable to invoke adapter serviceUnable to get connection factory from connection

[RATNESH_RAI]

hi guys ,

I’m using JDBC Adapter Version 6.0.3 with Integration Server 6.5.
i’ve successfully configured the JDBC Connection and also configured InsertSQL adapter service using this connection .Design time flow is like this -

1. Parent service receives the canonical document from broker.
2. MAP canonical fields to the target database columns(adapter
   service input).
3. Adapter Service expected to insert the data into the database.

But when i run the Parent service with the data stored in the pipeline, I get the following error ; but I’m mapping the valid data for all the non nullable field.

ERROR-

---

Could not run ‘subscribeShowItemMaster’.
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service SCOPE_ShowItemMaster_sub.adapter:insertShowItemMaster.
[ADA.1.316] Cannot execute the SQL statement “INSERT INTO SCOPE_MAGIC_PRODUCT_STG(PHARMNO, PRODUCT_FAMILY, PRODUCT_GROUP, PART_TYPE, STAT_TYPE, REPORT_TYPE, REPLACED_PHARMNO, PART_DESCRIPTION, PRODUCER_NO, STATUS, UPDATED, SIGNED, MARKET_RESP, UNIT_PACK, QTY_PACK, VENDNO, INFOTYPE, INCL_CATALOGUE, BASIC_PRODUCT_CODE, RELATED_PRODUCTS, PRODUCT_CATEGORY, SPARE_PART_CAT, NY_PRODUCT_GROUP, TARIFF_NO, EMBALLAGE_CODE, TEMP_ZONE, WEIGHT, WIDTH, HEIGHT, LENGTH, VOLUME, VOC_FLAG, VOC_WEIGHT, PBECC, FDASTAT, EXPIRETOLERANCE, PARTDANGER, MSDS, LOTTYPE, LOT_NO_DATE, SERIALNO, ORG_COUNTRY, COA_FLAG, US_ECCN, EU_ECCN, MADE_TO_ORDER, RECD_DATE_TIME, COMPANY_ID, STORAGE_TABLE_STATUS, MAGIC_SEQ_NO, FROM_DATE, BPC_DESCRIPTION, PED_DATE, VENDNAME1, MAIL_FLAG) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”. "
(23000/1400) ORA-01400: cannot insert NULL into (“PM_OWNER”.“SCOPE_MAGIC_PRODUCT_STG”.“PHARMNO”)
"
ORA-01400: cannot insert NULL into (“PM_OWNER”.“SCOPE_MAGIC_PRODUCT_STG”.“PHARMNO”)

---

I’m mapping the valid data for all the non nullable field.

Your help would be highly appreciated , thanks in advance.

[netmac123]

Hi Ratesh,

    Please make sure You are not inserting null values and check the datatype of your adapet service.  

Thanks

[Brett_Pierce]

@reamon;32089

“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.

Reamon, could you explain what type of behavior setting the min connections to 0 will do? Does that allow an unlimited number of simultaneous connections to the database?

_brett.

[reamon]

Setting the min connection value to 0 permits the pool to close all connections in the pool after the idle/expiration time has passed. This is the recommended setting for production environments. This avoids keeping unused connections too long and helps avoid stale connections–connections that the adapter thinks are still good but the resource has closed.

This setting does not control the number of simultaneous connections allowed. That is controlled by the max connections setting. I don’t believe that this can be set to a value (e.g. 0) that allows unlimited connections, but I may be wrong.

[Brett_Pierce]

Thank you. I will test those settings and see if it resolves my “broken pipe” issue that crops up every once and a while.

_brett.