PCK Loopback SP14 Problem

[Former Member]

I've got a configuration problem that I can't seem to figure out. I followed the documentation:

1)XI Adapter properties:

xiadapter.internal=devModePCK

xiadapter.isconfig.username=pckreceiver

xiadapter.isconfig.password=pckadm

xiadapter.isconfig.url=http://localhost:50000/MessagingSystem/recieve/AFW/XI

2)The adapter shows green as do the channels in the adapter monitor application

3)I've defined a single party with the related service, channels, agreements. Defined a simple xml document to be sent.

4)The com.sap.aii.af.ms.app.*MessagingSystem component has the pckreceiver user associated with the xi_af_receive security role.

The message is not being sent and I'm not sure where to look next.

The applications.0.log has a number of entries, one of which being:

#1.5#0013CE2FA76D003E0000002D00000C0C0004088893181AE4#1135282583068#/Applications/ExchangeInfrastructure/AdapterFramework/ThirdPartyRoot/comsap/Server/Adapter Framework#sap.com/com.sap.aii.af.app#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.createManagedConnection(Subject subject, ConnectionRequestInfo info)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff8984600074]###d256e5c0732711da8a390013ce2fa76d#SAPEngine_Application_Thread[impl:3]_18##0#0#Error#1#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory#Plain###Cannot access the channel parameters of channel: 14dded0478ce1b82c6f535b8f64eff18. Defaults will be set.#

*****

The defaultTrace.0.trc file has the following (I've copied a lot of text so my apologies but I don't see any means to include attachments):

#1.5#0013CE2FA76D00550000012900000C0C0004088896A28557#1135282642463#com.sap.aii.af.service.idmap.MessageIDMapper#anonimus#com.sap.aii.af.service.idmap.MessageIDMapper.createIDMap(String, String, long, boolean, boolean)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff8984600077]###9ace7710732411dabf340013ce2fa76d#SAPEngine_Application_Thread[impl:3]_4##0#0#Error##Plain###Could not check for duplicate entry. Reason: Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "MSG_ID2" FROM "XI_AF_SVC_ID_MAP" WHERE "MSG_ID1" = ?".#

#1.5#0013CE2FA76D00540000005F00000C0C0004088896A3107A#1135282642503#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory#sap.com/com.sap.aii.af.app#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.createManagedConnection(Subject subject, ConnectionRequestInfo info)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff8984600078]###f5c26ed1732711dacaf50013ce2fa76d#SAPEngine_Application_Thread[impl:3]_25##0#0#Error#1#/Applications/ExchangeInfrastructure/AdapterFramework/ThirdPartyRoot/comsap/Server/Adapter Framework#Plain###Cannot access the channel parameters of channel: 14dded0478ce1b82c6f535b8f64eff18. Defaults will be set.#

#1.5#0013CE2FA76D00540000006100000C0C0004088896A31246#1135282642503#com.sap.aii.af.mp.ejb.ModuleProcessorBean#sap.com/com.sap.aii.af.app#com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(String , ModuleData)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff8984600078]###f5c26ed1732711dacaf50013ce2fa76d#SAPEngine_Application_Thread[impl:3]_25##0#0#Error##Plain###Error during processing local bean localejbs/ModuleProcessorExitBean#

#1.5#0013CE2FA76D00540000006200000C0C0004088896A3151E#1135282642503#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer#anonimus#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff8984600078]###f5c26ed1732711dacaf50013ce2fa76d#SAPEngine_Application_Thread[impl:3]_25##0#0#Error##Java###Rolling back transaction for message due to: #2#42d58820-7327-11da-a8b2-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null# #1.5#0013CE2FA76D00540000006300000C0C0004088896A319AC#1135282642503#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer##com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0####f5c26ed1732711dacaf50013ce2fa76d#SAPEngine_Application_Thread[impl:3]_25##0#0#Error##Java###Transaction rolled back for meesage due to: #2#42d58820-7327-11da-a8b2-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null# #1.5#0013CE2FA76D00510000003F00000C0C0004088896A392E9#1135282642533#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory#sap.com/com.sap.aii.af.app#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.createManagedConnection(Subject subject, ConnectionRequestInfo info)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff8984600079]###f5c88950732711dab7300013ce2fa76d#SAPEngine_Application_Thread[impl:3]_9##0#0#Error#1#/Applications/ExchangeInfrastructure/AdapterFramework/ThirdPartyRoot/comsap/Server/Adapter Framework#Plain###Cannot access the channel parameters of channel: 14dded0478ce1b82c6f535b8f64eff18. Defaults will be set.# #1.5#0013CE2FA76D00510000004100000C0C0004088896A394C9#1135282642533#com.sap.aii.af.mp.ejb.ModuleProcessorBean#sap.com/com.sap.aii.af.app#com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(String , ModuleData)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff8984600079]###f5c88950732711dab7300013ce2fa76d#SAPEngine_Application_Thread[impl:3]_9##0#0#Error##Plain###Error during processing local bean localejbs/ModuleProcessorExitBean# #1.5#0013CE2FA76D00510000004200000C0C0004088896A3978F#1135282642533#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer#sap.com/com.sap.aii.af.ms.app#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff8984600079]###f5c88950732711dab7300013ce2fa76d#SAPEngine_Application_Thread[impl:3]_9##0#0#Error##Java###Rolling back transaction for message due to: #2#f5bacdb0-7327-11da-b44c-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null#

#1.5#0013CE2FA76D00510000004300000C0C0004088896A39828#1135282642533#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer#sap.com/com.sap.aii.af.ms.app#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0####f5c88950732711dab7300013ce2fa76d#SAPEngine_Application_Thread[impl:3]_9##0#0#Error##Java###Transaction rolled back for meesage due to: #2#f5bacdb0-7327-11da-b44c-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null# #1.5#0013CE2FA76D00640000003A00000C0C000408889A30A544#1135282702097#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory#sap.com/com.sap.aii.af.app#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.createManagedConnection(Subject subject, ConnectionRequestInfo info)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007a]###19494810732811daa2c60013ce2fa76d#SAPEngine_Application_Thread[impl:3]_30##0#0#Error#1#/Applications/ExchangeInfrastructure/AdapterFramework/ThirdPartyRoot/comsap/Server/Adapter Framework#Plain###Cannot access the channel parameters of channel: 14dded0478ce1b82c6f535b8f64eff18. Defaults will be set.# #1.5#0013CE2FA76D00640000003C00000C0C000408889A30A718#1135282702097#com.sap.aii.af.mp.ejb.ModuleProcessorBean#sap.com/com.sap.aii.af.app#com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(String , ModuleData)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007a]###19494810732811daa2c60013ce2fa76d#SAPEngine_Application_Thread[impl:3]_30##0#0#Error##Plain###Error during processing local bean localejbs/ModuleProcessorExitBean# #1.5#0013CE2FA76D00640000003D00000C0C000408889A30AAC0#1135282702097#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer#anonimus#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007a]###19494810732811daa2c60013ce2fa76d#SAPEngine_Application_Thread[impl:3]_30##0#0#Error##Java###Rolling back transaction for message due to: #2#00bfc410-7326-11da-b01b-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null# #1.5#0013CE2FA76D00640000003E00000C0C000408889A30AE43#1135282702097#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer##com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0####19494810732811daa2c60013ce2fa76d#SAPEngine_Application_Thread[impl:3]_30##0#0#Error##Java###Transaction rolled back for meesage due to: #2#00bfc410-7326-11da-b01b-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null#

#1.5#0013CE2FA76D00640000003F00000C0C000408889A30C94D#1135282702107#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer##com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.onMessage(QueueMessage, boolean)#Guest#0####19494810732811daa2c60013ce2fa76d#SAPEngine_Application_Thread[impl:3]_30##0#0#Error##Java###Failed to transmit message due to .#2#00bfc410-7326-11da-b01b-0013ce2fa76d(INBOUND)#com.sap.aii.af.ra.ms.api.RecoverableException: Adapter call failed. Reason: null: java.lang.Exception: Adapter call failed. Reason: null# #1.5#0013CE2FA76D00640000004100000C0C000408889A30E7ED#1135282702117#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer##com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.onMessage(QueueMessage, boolean)#Guest#0####19494810732811daa2c60013ce2fa76d#SAPEngine_Application_Thread[impl:3]_30##0#0#Error##Java###Retries exceded, set message to status NON_DELIVERED.#1#00bfc410-7326-11da-b01b-0013ce2fa76d(INBOUND)#

#1.5#0013CE2FA76D003F0000002B00000C0C000408889A317E82#1135282702157#com.sap.aii.af.service.alerting.Connection##com.sap.aii.af.service.alerting.Connection.newJcoClientForCentralMonitoringServer()#Guest#0####19526fd0732811dacfb80013ce2fa76d#SAPEngine_Application_Thread[impl:3]_19##0#0#Error##Plain####

#1.5#0013CE2FA76D003F0000002C00000C0C000408889A31820E#1135282702157#com.sap.aii.af.service.alerting.Alert##com.sap.aii.af.service.alerting.Alert.run()#Guest#0####19526fd0732811dacfb80013ce2fa76d#SAPEngine_Application_Thread[impl:3]_19##0#0#Error##Plain###JCoClient connection missingHost:PaulWLaptop_J2E_00|AdapterType:null|Sender:Party_A:Service_A|Receiver:Party_A:Service_A|Interface:IF_XML:http://IF|MsgID:00bfc410-7326-11da-b01b-0013ce2fa76d#

#1.5#0013CE2FA76D005A0000002A00000C0C000408889A342C12#1135282702327#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory#sap.com/com.sap.aii.af.app#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.createManagedConnection(Subject subject, ConnectionRequestInfo info)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007b]###196c6070732811dab0530013ce2fa76d#SAPEngine_Application_Thread[impl:3]_36##0#0#Error#1#/Applications/ExchangeInfrastructure/AdapterFramework/ThirdPartyRoot/comsap/Server/Adapter Framework#Plain###Cannot access the channel parameters of channel: 14dded0478ce1b82c6f535b8f64eff18. Defaults will be set.#

#1.5#0013CE2FA76D005A0000002C00000C0C000408889A342F25#1135282702327#com.sap.aii.af.mp.ejb.ModuleProcessorBean#sap.com/com.sap.aii.af.app#com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(String , ModuleData)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007b]###196c6070732811dab0530013ce2fa76d#SAPEngine_Application_Thread[impl:3]_36##0#0#Error##Plain###Error during processing local bean localejbs/ModuleProcessorExitBean#

#1.5#0013CE2FA76D005A0000002D00000C0C000408889A34320B#1135282702327#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer#anonimus#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007b]###196c6070732811dab0530013ce2fa76d#SAPEngine_Application_Thread[impl:3]_36##0#0#Error##Java###Rolling back transaction for message due to: #2#b3b92de0-7326-11da-bb73-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null# #1.5#0013CE2FA76D005A0000002E00000C0C000408889A3435A6#1135282702327#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer##com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0####196c6070732811dab0530013ce2fa76d#SAPEngine_Application_Thread[impl:3]_36##0#0#Error##Java###Transaction rolled back for meesage due to: #2#b3b92de0-7326-11da-bb73-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null# #1.5#0013CE2FA76D00550000012C00000C0C000408889A36BF3C#1135282702498#com.sap.sql.jdbc.common.CommonPreparedStatement#anonimus#com.sap.sql.jdbc.common.CommonPreparedStatement#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007c]###9ace7710732411dabf340013ce2fa76d#SAPEngine_Application_Thread[impl:3]_4##0#0#Error#1#/System/Database/sql/jdbc/common#Java#com.sap.sql.jdbc.common_1104##Cannot assign NULL to host variable 1. The corresponding column "MSG_ID1" in table "XI_AF_SVC_ID_MAP" is defined as NOT NULL. The statement is "INSERT INTO "XI_AF_SVC_ID_MAP" ("MSG_ID1","MSG_ID2","PERSIST_UNTIL") VALUES (?,?,?)".#4#1#MSG_ID1#XI_AF_SVC_ID_MAP#INSERT INTO "XI_AF_SVC_ID_MAP" ("MSG_ID1","MSG_ID2","PERSIST_UNTIL") VALUES (?,?,?)# #1.5#0013CE2FA76D00550000012D00000C0C000408889A36C180#1135282702498#com.sap.sql.jdbc.common.CommonPreparedStatement#anonimus#com.sap.sql.jdbc.common.CommonPreparedStatement#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007c]###9ace7710732411dabf340013ce2fa76d#SAPEngine_Application_Thread[impl:3]_4##0#0#Error#1#/System/Audit#Java###Exception #1#com.sap.sql.log.OpenSQLException: Cannot assign NULL to host variable 1. The corresponding column "MSG_ID1" in table "XI_AF_SVC_ID_MAP" is defined as NOT NULL. The statement is "INSERT INTO "XI_AF_SVC_ID_MAP" ("MSG_ID1","MSG_ID2","PERSIST_UNTIL") VALUES (?,?,?)". at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85) at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124) at com.sap.sql.jdbc.common.CommonPreparedStatement.setNull(CommonPreparedStatement.java:379) at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:573) at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setString(PreparedStatementWrapper.java:341) at com.sap.aii.af.service.idmap.MessageIDMapper.createIDMap(MessageIDMapper.java:245) at com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.sendMessageFromFile(SPIManagedConnectionFactory.java:1321) at com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.run(SPIManagedConnectionFactory.java:965) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) # #1.5#0013CE2FA76D00550000012E00000C0C000408889A36C245#1135282702498#com.sap.sql.jdbc.common.CommonPreparedStatement#anonimus#com.sap.sql.jdbc.common.CommonPreparedStatement#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007c]###9ace7710732411dabf340013ce2fa76d#SAPEngine_Application_Thread[impl:3]_4##0#0#Error##Plain###com.sap.sql.log.OpenSQLException: Cannot assign NULL to host variable 1. The corresponding column "MSG_ID1" in table "XI_AF_SVC_ID_MAP" is defined as NOT NULL. The statement is "INSERT INTO "XI_AF_SVC_ID_MAP" ("MSG_ID1","MSG_ID2","PERSIST_UNTIL") VALUES (?,?,?)". at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85) at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124) at com.sap.sql.jdbc.common.CommonPreparedStatement.setNull(CommonPreparedStatement.java:379) at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:573) at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setString(PreparedStatementWrapper.java:341) at com.sap.aii.af.service.idmap.MessageIDMapper.createIDMap(MessageIDMapper.java:245) at com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.sendMessageFromFile(SPIManagedConnectionFactory.java:1321) at com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.run(SPIManagedConnectionFactory.java:965) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) # #1.5#0013CE2FA76D00550000013000000C0C000408889A36C7D0#1135282702498#com.sap.sql.jdbc.common.CommonPreparedStatement#anonimus#com.sap.sql.jdbc.common.CommonPreparedStatement#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007c]###9ace7710732411dabf340013ce2fa76d#SAPEngine_Application_Thread[impl:3]_4##0#0#Error#1#/System/Database/sql/jdbc/common#Java#com.sap.sql.jdbc.common_1127##Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "MSG_ID2" FROM "XI_AF_SVC_ID_MAP" WHERE "MSG_ID1" = ?".#2#1#SELECT "MSG_ID2" FROM "XI_AF_SVC_ID_MAP" WHERE "MSG_ID1" = ?# #1.5#0013CE2FA76D00550000013100000C0C000408889A36C99C#1135282702498#com.sap.sql.jdbc.common.CommonPreparedStatement#anonimus#com.sap.sql.jdbc.common.CommonPreparedStatement#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007c]###9ace7710732411dabf340013ce2fa76d#SAPEngine_Application_Thread[impl:3]_4##0#0#Error#1#/System/Audit#Java###Exception #1#com.sap.sql.log.OpenSQLException: Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "MSG_ID2" FROM "XI_AF_SVC_ID_MAP" WHERE "MSG_ID1" = ?". at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85) at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124) at com.sap.sql.jdbc.common.CommonPreparedStatement.setNull(CommonPreparedStatement.java:384) at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:573) at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setString(PreparedStatementWrapper.java:341) at com.sap.aii.af.service.idmap.MessageIDMapper.createIDMap(MessageIDMapper.java:265) at com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.sendMessageFromFile(SPIManagedConnectionFactory.java:1321) at com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.run(SPIManagedConnectionFactory.java:965) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) # #1.5#0013CE2FA76D00550000013200000C0C000408889A36CA5A#1135282702498#com.sap.sql.jdbc.common.CommonPreparedStatement#anonimus#com.sap.sql.jdbc.common.CommonPreparedStatement#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007c]###9ace7710732411dabf340013ce2fa76d#SAPEngine_Application_Thread[impl:3]_4##0#0#Error##Plain###com.sap.sql.log.OpenSQLException: Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "MSG_ID2" FROM "XI_AF_SVC_ID_MAP" WHERE "MSG_ID1" = ?". at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85) at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124) at com.sap.sql.jdbc.common.CommonPreparedStatement.setNull(CommonPreparedStatement.java:384) at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:573) at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setString(PreparedStatementWrapper.java:341) at com.sap.aii.af.service.idmap.MessageIDMapper.createIDMap(MessageIDMapper.java:265) at com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.sendMessageFromFile(SPIManagedConnectionFactory.java:1321) at com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.run(SPIManagedConnectionFactory.java:965) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159) # #1.5#0013CE2FA76D00550000013300000C0C000408889A36CB03#1135282702498#com.sap.aii.af.service.idmap.MessageIDMapper#anonimus#com.sap.aii.af.service.idmap.MessageIDMapper.createIDMap(String, String, long, boolean, boolean)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007c]###9ace7710732411dabf340013ce2fa76d#SAPEngine_Application_Thread[impl:3]_4##0#0#Error##Plain###Could not check for duplicate entry. Reason: Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "MSG_ID2" FROM "XI_AF_SVC_ID_MAP" WHERE "MSG_ID1" = ?".# #1.5#0013CE2FA76D00650000001C00000C0C000408889A372037#1135282702518#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory#sap.com/com.sap.aii.af.app#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.createManagedConnection(Subject subject, ConnectionRequestInfo info)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007d]###19898560732811daa3790013ce2fa76d#SAPEngine_Application_Thread[impl:3]_27##0#0#Error#1#/Applications/ExchangeInfrastructure/AdapterFramework/ThirdPartyRoot/comsap/Server/Adapter Framework#Plain###Cannot access the channel parameters of channel: 14dded0478ce1b82c6f535b8f64eff18. Defaults will be set.# #1.5#0013CE2FA76D00650000001E00000C0C000408889A37237A#1135282702528#com.sap.aii.af.mp.ejb.ModuleProcessorBean#sap.com/com.sap.aii.af.app#com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(String , ModuleData)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007d]###19898560732811daa3790013ce2fa76d#SAPEngine_Application_Thread[impl:3]_27##0#0#Error##Plain###Error during processing local bean localejbs/ModuleProcessorExitBean# #1.5#0013CE2FA76D00650000001F00000C0C000408889A37265A#1135282702528#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer#anonimus#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007d]###19898560732811daa3790013ce2fa76d#SAPEngine_Application_Thread[impl:3]_27##0#0#Error##Java###Rolling back transaction for message due to: #2#669e2550-7327-11da-b89c-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null#

#1.5#0013CE2FA76D00650000002000000C0C000408889A3729E2#1135282702528#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer##com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0####19898560732811daa3790013ce2fa76d#SAPEngine_Application_Thread[impl:3]_27##0#0#Error##Java###Transaction rolled back for meesage due to: #2#669e2550-7327-11da-b89c-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null# #1.5#0013CE2FA76D00500000003400000C0C000408889A38BC4B#1135282702628#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory#sap.com/com.sap.aii.af.app#com.sap.aii.af.sample.adapter.ra.SPIManagedConnectionFactory.createManagedConnection(Subject subject, ConnectionRequestInfo info)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007e]###199a4e40732811daa4500013ce2fa76d#SAPEngine_Application_Thread[impl:3]_8##0#0#Error#1#/Applications/ExchangeInfrastructure/AdapterFramework/ThirdPartyRoot/comsap/Server/Adapter Framework#Plain###Cannot access the channel parameters of channel: 14dded0478ce1b82c6f535b8f64eff18. Defaults will be set.# #1.5#0013CE2FA76D00500000003600000C0C000408889A38BE3D#1135282702628#com.sap.aii.af.mp.ejb.ModuleProcessorBean#sap.com/com.sap.aii.af.app#com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(String , ModuleData)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007e]###199a4e40732811daa4500013ce2fa76d#SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain###Error during processing local bean localejbs/ModuleProcessorExitBean# #1.5#0013CE2FA76D00500000003700000C0C000408889A38C119#1135282702628#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer#sap.com/com.sap.aii.af.ms.app#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0#SAP J2EE Engine JTA Transaction : [0ffffff898460007e]###199a4e40732811daa4500013ce2fa76d#SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Java###Rolling back transaction for message due to: #2#1981e440-7328-11da-b1da-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null# #1.5#0013CE2FA76D00500000003800000C0C000408889A38C1B4#1135282702628#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer#sap.com/com.sap.aii.af.ms.app#com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(QueueMessage, MessageController, Services)#Guest#0####199a4e40732811daa4500013ce2fa76d#SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Java###Transaction rolled back for meesage due to: #2#1981e440-7328-11da-b1da-0013ce2fa76d(INBOUND)#Adapter call failed. Reason: null#

****

End of log.

Any help is greatly appreciated!

thanks

Paul

[Former Member]

1. did you test the url in browser

2. does the sap sample adpater's namespace map with namespace in sap xi adapter xi in visual admin?

3. the jndi is something like deployedAdapters/<adaptername>/shareable/<adaptername>

the adapter name is the name of your archive, if your archive is myadapter.sda, and your jndi is deployedAdapters/myadapter/shareable/myadapter

4. can you try the file apdater in pck first

Message was edited by: Spring Tang

Message was edited by: Spring Tang