JDBC Lookup Error

Hello,

I have a message mapping with a UDF that execute a JDBC Lookup:

sql = "SELECT....";

DataBaseAccessor accessor = null;

DataBaseResult resultSet = null;

try {

Channel channel = LookupService.getChannel(constantService, constantChannel);

accessor = LookupService.getDataBaseAccessor(channel);

resultSet = accessor.execute(sql);

}

catch (Exception e) {

..............

All looks well but when I test the scenario I get the following exception:

'Error during processing local bean: localejbs/CallSapAdapter'. Cause Exception: 'Exception thrown in method process. The transaction is marked for rollback.'.

I don't have any additional configuration on the module page of the communication channel.

Thanks for your help.

Yuvan.

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hi,

Print the stack trace using the following code. you will be able to debug the issue by using this. You can see the logs in Communication channel of the adapter.



AbstractTrace trace = container.getTrace();
trace.addWarning("DEBUG....");
try
{
trace.addWarning("BEFORE ACCESSOR GET CHANNEL");
accessor = LookupService.getRfcAccessor(channel);
}
catch (Exception e)
{
StackTraceElement stack= e.getStackTrace();
for(int i=0;i<stack.length;i++)
{
StackTraceElement stackTrace = stack;
trace.addWarning("Exception is at : "+stackTrace.toString());
}
}

thanks

amit

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Amit,

Thanks for your answer.

I already added the trace and I checked it in SXMB_MONI:

<Trace level="1" type="T">RuntimeException during appliction Java mapping com/sap/xi/tf/_OrdenesPrev_to_OrdenPrevtj_</Trace>

This is the trace according to your sugestion:

<Trace level="1" type="T">*** START APPLICATION TRACE ***</Trace>

<Trace level="1" type="T">DEBUG....</Trace>

<Trace level="1" type="T">BEFORE ACCESSOR GET CHANNEL</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.ibrun.server.lookup.AdapterProxyLocal.execute(AdapterProxyLocal.java:131)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.ibrun.server.lookup.SystemAccessorInternal.execute(SystemAccessorInternal.java:68)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.mapping.lookup.DataBaseAccessor.execute(DataBaseAccessor.java:62)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.xi.tf._OrdenesPrev_to_OrdenPrevtj_.selectResourceInfo$(_OrdenesPrev_to_OrdenPrevtj_.java:178)</Trace>

<Trace level="1" type="T">Exception is at : sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</Trace>

<Trace level="1" type="T">Exception is at : sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))</Trace>

<Trace level="1" type="T">Exception is at : sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))</Trace>

<Trace level="1" type="T">Exception is at : java.lang.reflect.Method.invoke(Method.java(Compiled Code))</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.mappingtool.tf3.rt.C2CFunctionWrapper.cacheContext(C2CFunctionWrapper.java:90)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.mappingtool.tf3.rt.C2CFunctionWrapper.gotoNextContext(C2CFunctionWrapper.java:46)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java:252)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java:312)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.mappingtool.tf3.AMappingProgram.start(AMappingProgram.java:401)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.mappingtool.tf3.Transformer.start(Transformer.java:142)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.mappingtool.tf3.AMappingProgram.execute(AMappingProgram.java:105)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.ibrun.server.mapping.JavaMapping.executeStep(JavaMapping.java:64)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.ibrun.server.mapping.Mapping.execute(Mapping.java:92)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.ibrun.server.mapping.MappingHandler.run(MappingHandler.java:90)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.ibrun.sbeans.mapping.MappingRequestHandler.handleMappingRequest(MappingRequestHandler.java:95)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.ibrun.sbeans.mapping.MappingRequestHandler.handleRequest(MappingRequestHandler.java:68)</Trace>

<Trace level="1" type="T">Exception is at : com.sap.aii.ibrun.sbeans.mapping.MappingServiceImpl.processFunction(MappingServiceImpl.java:79)</Trace> ......

Thanks.

Yuvan.

Hello,

Someone have any idea of this error. The Communication Channel works very well in other escenarios.Just fail with JDBC Lookup.

Thanks.

Yuvan.

Hi,

Can you paste the complete code here which has debugging trace you are using and also I would like to know what is the XI version and Service pack you are using.

Just to confirm, you are not using any custom adapter module, neither any Advanced settings, right?

thanks

amit

Hello Amit,

Yes I'm not using any Advanced settings.

Thanks for your help.

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Message canceled

-->

- <SAP:Trace xmlns:SAP="http://sap.com/xi/XI/Message/30">

<Trace level="1" type="T">Party normalization: sender</Trace>

<Trace level="1" type="T">Sender scheme external = XIParty</Trace>

<Trace level="1" type="T">Sender agency external = http://sap.com/xi/XI</Trace>;

<Trace level="1" type="T">Sender party external =</Trace>

<Trace level="1" type="T">Sender party normalized =</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">XMB was called with URL /sap/xi/engine?type=entry</Trace>

<Trace level="1" type="T">COMMIT is done by XMB !</Trace>

- <!-- ************************************

-->

- <!-- ************************************

-->

<Trace level="1" type="T">XMB entry processing</Trace>

<Trace level="1" type="T">system-ID = D21</Trace>

<Trace level="1" type="T">client = 100</Trace>

<Trace level="1" type="T">language = E</Trace>

<Trace level="1" type="T">user = YDBETANC</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">Message-GUID = 7557A9407A0411DDA07400145E48FE14</Trace>

<Trace level="1" type="T">PLNAME = CENTRAL</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">Get definition of external pipeline = CENTRAL</Trace>

<Trace level="1" type="T">Get definition of internal pipeline = SAP_CENTRAL</Trace>

<Trace level="1" type="T">Queue name : XBTI0000</Trace>

<Trace level="1" type="T">Generated prefixed queue name = XBTI0000</Trace>

<Trace level="1" type="T">Schedule message in qRFC environment</Trace>

<Trace level="1" type="T">Setup qRFC Scheduler OK!</Trace>

<Trace level="1" type="T">----

</Trace>

<Trace level="1" type="T">Going to persist message</Trace>

<Trace level="1" type="T">NOTE: The following trace entries are always lacking</Trace>

<Trace level="1" type="T">- Exit WRITE_MESSAGE_TO_PERSIST</Trace>

<Trace level="1" type="T">- Exit CALL_PIPELINE_ASYNC</Trace>

<Trace level="1" type="T">Async barrier reached. Bye-bye !</Trace>

<Trace level="1" type="T">----

</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">--start sender interface action determination</Trace>

<Trace level="1" type="T">select interface oa_OrdenesPrev*</Trace>

<Trace level="1" type="T">select interface namespace urn:hilanet:pp:planord:a_prd</Trace>

<Trace level="1" type="T">no interface found</Trace>

<Trace level="1" type="T">Note: the following trace entry is written delayed (after read from persist)</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">----

</Trace>

<Trace level="1" type="T">Starting async processing with pipeline CENTRAL</Trace>

<Trace level="1" type="T">system-ID = D21</Trace>

<Trace level="1" type="T">client = 100</Trace>

<Trace level="1" type="T">language = E</Trace>

<Trace level="1" type="T">user = YDBETANC</Trace>

<Trace level="1" type="T">----

</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">Get definition of external pipeline CENTRAL</Trace>

<Trace level="1" type="T">Corresponding internal pipeline SAP_CENTRAL</Trace>

- <Trace level="1" type="B" name="PLSRV_RECEIVER_DETERMINATION">

- <Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

- <Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

- <Trace level="1" type="B" name="CL_RD_PLSRV-ENTER_PLSRV">

<Trace level="1" type="T">Cache Content is up to date</Trace>

</Trace>

- <Trace level="1" type="B" name="PLSRV_INTERFACE_DETERMINATION">

- <Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

- <Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

- <Trace level="1" type="B" name="CL_ID_PLSRV-ENTER_PLSRV">

<Trace level="1" type="T">Cache Content is up to date</Trace>

</Trace>

- <!-- ************************************

-->

- <Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

- <!-- ************************************

-->

- <!-- ************************************

-->

<Trace level="1" type="T">number of receivers: 1</Trace>

<Trace level="1" type="T">Single-receiver split case</Trace>

<Trace level="1" type="T">Post-split internal queue name = XBTOP___0001</Trace>

<Trace level="1" type="T">----

</Trace>

<Trace level="1" type="T">Persisting single message for post-split handling</Trace>

<Trace level="1" type="T">Going to persist message + call qRFC now...</Trace>

<Trace level="1" type="T">NOTE: The following trace entries are always lacking</Trace>

<Trace level="1" type="T">- Exit WRITE_MESSAGE_TO_PERSIST</Trace>

<Trace level="1" type="T">Async barrier reached. Bye-bye !</Trace>

<Trace level="1" type="T">----

</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">Note: the following trace entry is written delayed (after read from persist)</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">----

</Trace>

<Trace level="1" type="T">Starting async processing with pipeline CENTRAL</Trace>

<Trace level="1" type="T">system-ID = D21</Trace>

<Trace level="1" type="T">client = 100</Trace>

<Trace level="1" type="T">language = E</Trace>

<Trace level="1" type="T">user = YDBETANC</Trace>

<Trace level="1" type="T">----

</Trace>

- <!-- ************************************

-->

<Trace level="1" type="T">Get definition of external pipeline CENTRAL</Trace>

<Trace level="1" type="T">Corresponding internal pipeline SAP_CENTRAL</Trace>

<Trace level="1" type="T">Start with pipeline element PLEL= 5EC3C53B4BB7B62DE10000000A1148F5</Trace>

- <!-- ************************************

-->

- <!-- ************************************

-->

- <!-- ************************************

-->

- <!-- ************************************

-->

<Trace level="1" type="T">Interface Mapping urn:hilanet:pp:planord:a_prd OrdenesPrev_to_OrdenPrevtj</Trace>