JDBC commiunication channel error

[former_member270496]

I desighned a idoc-jdbc scenario.When I am triggedring idoc from sap r3,in 'we05' it's coming as sucess message and in sap pi in sxi_monitor txcode also it's showing 'processed sucessfully' message.but while i am doing 'communication channel testing' in RWB that time it's giving error message as:

Message processing failed. Cause: java.lang.NullPointerException

please suggest what needed ti be done.

[ note: here the non-sap database is: Oracle.

in receiver 'JDBC cc' configured: JDBC driver: oracle.jdbc.driver.OracleDriver

connection: jdbc:oracle:thin:@10.0.19.120:1527:IDS

(where ip/host : 10.0.19.120

port : 1527

*database name: IDS.)

(here the 'connection parameter' is in the form of: [ jdbc:oracle:thin:@<hostname>:<listner port number>:<database name> ] ]

please,suggest.

Regards,

Rasmiraj Tripathy.

Edited by: rasmiraj tripathy on Jul 14, 2011 3:56 PM

[Former Member]

Hi Tripathy,

I didnot understand how you are doing 'communication channel testing' ?

You mentioned that if you do from SAP it is working end to end and if we do from RWB you are having error. If I am correct then you are doing from RWB > Adapter engine> test. If you are doing this, then you are doing wrong.

Instead you should test from RWB --> Integration Engine --> Test then it should work. So please check accordingly.

Regards,

---Satish

[former_member270496]

Hi satish,

i tested from RWB --> Integration Engine --> Test then it should work.

here it is showing 'sucessfully message sent'.

but in communication channel monitoring,same problem is coming(*java lang null pointer exception)*

Please,suggest.

[baskar_gopalakrishnan2]

> Please suggest

You get message processing failed.

This shows problem might be due to data. Are you getting no error after configuring the communication channel (db connection string ) and activate the channel? If so then no problem with your configuration

Do the following...

a) See in your mapping you pass the data from idoc to jdbc variables properly... If your mapping during runtime does not pass data for your insert or update query then you will have this issue.

b) If possible test the SQL query using toad or sqlplus using mapping data directly in database.

c) Also in your communication channel add logSQLStatement = true as parameter in the advanced tab. This will help for debugging

[former_member270496]

Baskar,

I took each step as per your instruction.However,the problem still ersists.below is the error i am getting in 'Audit log'

of communication channel monitoring:

[ Audit Log for Message: 4e1fee13-5bc3-300c-e100-00000a001367

Time Stamp Status Description

15.07.2011 17:31:26 Success Message successfully received by messaging system. Profile: XI URL: http://deveppi103:50200/MessagingSystem/receive/AFW/XI Credential (User): PIISUSER

15.07.2011 17:31:26 Success Using connection JDBC_http://sap.com/xi/XI/System. Trying to put the message into the receive queue.

15.07.2011 17:31:26 Success Message successfully put into the queue.

15.07.2011 17:31:26 Success The message was successfully retrieved from the receive queue.

15.07.2011 17:31:26 Success The message status set to DLNG.

15.07.2011 17:31:26 Success Delivering to channel: JDBC_RCV_HCM_CH1

15.07.2011 17:31:26 Success MP: Entering module processor

15.07.2011 17:31:26 Error MP: Exception caught with cause java.lang.NullPointerException

15.07.2011 17:31:26 Error Exception caught by adapter framework: null

15.07.2011 17:31:26 Error Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: java.lang.NullPointerException. ]

please,suggest.

[former_member854360]

Hi Rasmi,

do you have access to NWA In PI?

[baskar_gopalakrishnan2]

>15.07.2011 17:31:26 Success MP: Entering module processor

>15.07.2011 17:31:26 Error MP: Exception caught with cause java.lang.NullPointerException

>15.07.2011 17:31:26 Error Exception caught by adapter framework: null

Please check few things..

1) Check whether database port you are using is valid one?

2) Have you checked the same connection string outside PI using toad and see whether you are able to query? Please answer for it?

3) Provide your jdbc target structure here. I suspect the target structure seems to be not in proper order... Are you using sap help document to construct structure?

[former_member270496]

yes,we have access to the NWA.

[former_member270496]

BHASKAR,

WHAT MEANS BY: Have you checked the same connection string outside PI using toad and see whether you are able to query? Please answer for it?(HOW TO ACHIEVE IT?)

PLEASE,EXPLAIN.

[former_member854360]

You can see it in Netweaver Adaministrator(NWA) under log section (Alert Java)

For this you have to login to NWA.

All error messages from J2EE applications are written to the applications.<number>.log file. The file can be found in the file system under.j2ee\cluster\server<number>\log.

To analyze the logs, use the LogViewer plug-in in the SAP NetWeaver Administrator.

1. To start SAP NetWeaver Administrator, choose the URL http://<server:port>/nwa.

2. Choose Problem Management -> Logs and Traces -> Log Viewer.

[Former Member]

Just check if you are passing all the values to all required fields and check the primary key compatibility. No need to go to NWA. you can check the SQL command in the CC audit log. check it properly.

--Naresh

[former_member854360]

@Naresh: it is a connectivity issue not related to SQL Command. he is getting NULL ponter exception.

For seeing the source of this NULLPonter we need to Check in NWA logs.

[naveen_chichili]

HI Rashmiraj,

Could youbplease crosscheck if you have provided the right connection parameters in the channel level configuration.

Note: try to check the ping connectivity from your pi server to JDBC .

Regards,

Naveen.

[baskar_gopalakrishnan2]

I want to make sure that SQL command returns values using toad or some db client tool. Since you get null pointer exception, I suspect problem might be due missing or invalid target structure or so. If you have connection string problem, you get errors such as "connection could not be established" and so

[former_member270496]

i saw the traces in the 'NWA'.the traces are mentioned below:

[ Details Severity Date Time Message Category Location Application Host Node

error 2011-07-27 15:13:31:842 Retries exceded, set message 4e2fa9e8-2af2-2a8c-e100-00000a001367(INBOUND) to status NON_DELIVERED.

n/a com.sap.aii.af.ra.ms.impl.core.queue.consumer.ReceiveConsumer.handleRetriesOnException(MessagingException, QueueMessage, MessageController) n/a deveppi103.vsp.rinl.in Server 0 2_58766

Full Message Text

Retries exceded, set message 4e2fa9e8-2af2-2a8c-e100-00000a001367(INBOUND) to status NON_DELIVERED.

error 2011-07-27 15:13:31:834 Failed to transmit message 4e2fa9e8-2af2-2a8c-e100-00000a001367(INBOUND) due to com.sap.aii.af.ra.ms.api.RecoverableException: java.lang.NullPointerException.

n/a com.sap.aii.af.ra.ms.impl.core.queue.consumer.ReceiveConsumer.handleRetriesOnException(MessagingException, QueueMessage, MessageController) n/a deveppi103.vsp.rinl.in Server 0 2_58766

Full Message Text

Failed to transmit message 4e2fa9e8-2af2-2a8c-e100-00000a001367(INBOUND) due to com.sap.aii.af.ra.ms.api.RecoverableException: java.lang.NullPointerException.

error 2011-07-27 15:13:31:822 Transaction rolled back for meesage 4e2fa9e8-2af2-2a8c-e100-00000a001367(INBOUND) due to: <null>

n/a com.sap.aii.af.ra.ms.impl.core.queue.consumer.ReceiveConsumer.invokeHandler(QueueMessage, MessageController) n/a deveppi103.vsp.rinl.in Server 0 2_58766

Full Message Text

Transaction rolled back for meesage 4e2fa9e8-2af2-2a8c-e100-00000a001367(INBOUND) due to: <null>

error 2011-07-27 15:13:31:821 Rolling back transaction for message 4e2fa9e8-2af2-2a8c-e100-00000a001367(INBOUND) due to: <null>

n/a com.sap.aii.af.ra.ms.impl.core.queue.consumer.ReceiveConsumer.invokeHandler(QueueMessage, MessageController) n/a deveppi103.vsp.rinl.in Server 0 2_58766

Full Message Text

Rolling back transaction for message 4e2fa9e8-2af2-2a8c-e100-00000a001367(INBOUND) due to: <null> ]

Pleae,suggest.

[former_member270496]

hi chi,

i check the jdbc config parameters and all are correct.

Morover i checked the ping to jdbc,it is working fine.

[naveen_chichili]

Hi Rasmiraj,

Did you check the ping connectivity to DB server from you PI Server as said above.

Regards,

Naveen.

[former_member270496]

Naresh,

i provided the 'NWA LOGS' in my previpus post.please,suggest.

[former_member270496]

Baskar,

I provided the JDBC target structure as per the SAP convention(i tooj\k the help of 'help.sap.com').so,no doubt of wrong format structure.but,only one doubt of Me is there for the message mapping.can You guide me on the 'Message mapping' part for the idoc2jdbc(this scenario)(node-to-node) mapping.

Eagerly waiting for the valuable suggsetion.Thank You.

[former_member270496]

Hi Baskar,

please find My data structure,Mapping & receiver communication channel confrig in : http://www.4shared.com/file/s-l5i9Lh/guidance_on_data_mapping_idoc2.html

please suggest me on these prospectives.

[former_member270496]

hi Chi,

We checked the ping connectivity from the pi server and it is working fine.

[former_member270496]

Dear Experts,

Eagerly waiting for the response about the mapping.

[Former Member]

Is any of the columns in the DB table of type BLOB? Check SAP note [https://service.sap.com/sap/support/notes/1283089] if that is the case.

[baskar_gopalakrishnan2]

In the communication channel advanced tab do the following. Add the parameter as below and the value is true. This might help for log tracing the error.

logSQLStatement value is true

a) Problem might be mismatch field name between structure and table

b) value is mapped from idoc to jdbc field elements completely.

c) Basically some mandatory field elements of jdbc structure is not getting values at run time.

Hope that helps

[former_member270496]

Hi,

here no column in target structure is having type 'BLOB'.Moroover,can you tell me what type 'BLOB' signifies?

[NOTE: PLEASE GO THROUGH THE 4SHARED LINK TO SEE ALL MY STRUCTURES,THAT WAY WE'LL HAVE BETTER VISIBILITY]

[former_member270496]

Hi Bhaskar,

1. here as per your instruction i did the settings in receiver JDBC comm ch in 'advance' tab. please go through link for detail view: http://www.4shared.com/file/3w1kzJZR/JDBC_comm_ch_settings_advance_.html.

however,please explain me how we can see the detail description of the error by setting the above instructed parameter.

2. please go through my data type,message type and mapping for a better clarity in the below mentioned link:

http://www.4shared.com/file/s-l5i9Lh/guidance_on_data_mapping_idoc2.html

3. i checked about field name matching of database structure,it's perfectly right.

please,suggest.

[former_member854360]

Hi rasmi,

i think you are looking for this

AP XI/PI: Storing BINARIES (Images, PDFs etc.) in the Database (BLOBs) Using JDBC Adapter

/people/praveen.gujjeti/blog/2010/03/28/sap-xipi-storing-binaries-images-pdfs-etc-in-the-database-blobs-using-jdbc-adapter

[former_member854360]

Hi rasmi,

i think you are looking for this

AP XI/PI: Storing BINARIES (Images, PDFs etc.) in the Database (BLOBs) Using JDBC Adapter

/people/praveen.gujjeti/blog/2010/03/28/sap-xipi-storing-binaries-images-pdfs-etc-in-the-database-blobs-using-jdbc-adapter

[former_member270496]

hi debasis,

can you provide me some input about my data type,message type & mapping by going about the following link:

http://www.4shared.com/file/s-l5i9Lh/guidance_on_data_mapping_idoc2.html

Edited by: rasmiraj tripathy on Aug 5, 2011 7:31 AM

[former_member270496]

Hi all,

the issue got resolved by updating sdome of the patches and deleting some trace fileas from 'j2ee_admin' user.

thanks all for the support.

regards,

raj.

[former_member854360]

Hi Rasmi,

Message processing failed. Cause: java.lang.NullPointerException

Please provide the detail error message from audit log.

[former_member270496]

Dear Debasis,

Which 'audit log' you are talking about.from which path can i get that?

[in 'communi channel monitoring' ,in 'cluster node' tab i am getting these details:

Cluster Node Details for Channel JDBC_RCV_HCM_CH

In the Last 10 Seconds Server 0 2_58766 Functioning

Line 1 / 1

Processing Details for Cluster Node Server 0 2_58766

7/15/11 10:15:21 AM 4e1fdeec-5bc3-300c-e100-00000a001367 Message processing failed. Cause: java.lang.NullPointerException

7/15/11 10:15:21 AM 4e1fdeec-5bc3-300c-e100-00000a001367 Message processing started

7/15/11 10:14:54 AM 4e1f5334-5b96-300b-e100-00000a001367 Message processing failed. Cause: java.lang.NullPointerException

7/15/11 10:14:54 AM 4e1f5334-5b96-300b-e100-00000a001367 Message processing started

7/15/11 10:09:54 AM 4e1f5334-5b96-300b-e100-00000a001367 Message processing failed. Cause: java.lang.NullPointerException

7/15/11 10:09:54 AM 4e1f5334-5b96-300b-e100-00000a001367 Message processing started

7/15/11 10:04:54 AM 4e1f5334-5b96-300b-e100-00000a001367 Message processing failed. Cause: java.lang.NullPointerException ]

please,suggest.

[rajasekhar_reddy14]

Hi,

i think its because of Jar file. could you please check the Jar files what you deployed correct or not. Please deploy comptaible Jar files.

Regards,

Raj

[former_member270496]

Debasis,

I got the detail 'Audit Log' file, which is mentioned below:

Audit Log for Message: 4e1fe1e8-5bc3-300c-e100-00000a001367

[

Time Stamp Status Description

15.07.2011 11:52:13 Success Message successfully received by messaging system. Profile: XI URL: http://deveppi103:50200/MessagingSystem/receive/AFW/XI Credential (User): PIISUSER

15.07.2011 11:52:13 Success Using connection JDBC_http://sap.com/xi/XI/System. Trying to put the message into the receive queue.

15.07.2011 11:52:13 Success Message successfully put into the queue.

15.07.2011 11:52:13 Success The message was successfully retrieved from the receive queue.

15.07.2011 11:52:13 Success The message status set to DLNG.

15.07.2011 11:52:13 Success Delivering to channel: JDBC_RCV_HCM_CH1

15.07.2011 11:52:13 Success MP: Entering module processor

15.07.2011 11:52:13 Error MP: Exception caught with cause java.lang.NullPointerException

15.07.2011 11:52:13 Error Exception caught by adapter framework: null

15.07.2011 11:52:13 Error Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: java.lang.NullPointerException. ]

please,suggest.

regrads,

Rasmiraj Tripathy

[former_member854360]

Hi rashmi,

This error is because of NULl poiter exception.

but you need to know the real cause of this NULLPOINTER exception.

You can see detail error in NWA

Check the LOGS--->Alert Java in NWA under operation tab.

[former_member270496]

Debasis,

I didn't get where I can see the detail description?Plese,explain this elaborately.

[former_member854360]

You can see it in Netweaver Adaministrator(NWA) under log section (Alert Java)

For this you have to login to NWA.

All error messages from J2EE applications are written to the applications.<number>.log file. The file can be found in the file system under.j2eeclusterserver<number>log.

To analyze the logs, use the LogViewer plug-in in the SAP NetWeaver Administrator.

1. To start SAP NetWeaver Administrator, choose the URL http://<server:port>/nwa.

2. Choose Problem Management -> Logs and Traces -> Log Viewer.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e05829a5-55aa-2a10-f694-ba8e30c3c...