Sitemap

Amicuk Programming Answers

JDBC Adapter - Error Handling

-0001-11-30   Views:1

Advertisement

Hi, I have a question with JDBC Sender Adapter. In my scenario, SAP XI will retrieve input data using JDBC Sender Adapter. Here is my question, What would happen if input data is wrong and cannot pass mapping in XI? Would XI send success record to ta

Hi,
I have a question with JDBC Sender Adapter. In my scenario, SAP XI will retrieve input data using JDBC Sender Adapter. Here is my question, What would happen if input data is wrong and cannot pass mapping in XI? Would XI send success record to target system?
For example, If XI retrieves 50 records from JDBC sender adapter and 3 records are identified as error record in XI mapping, would XI send 47 records(success records) to target system or all 50 records will be marked as error and no data will be sent to target system?
Regards,
Pavin

The replay answer
Advertisement
Hi,
I'm using select query in Integration Directory to select input data from staging database. How would XI process input data? Would it see input data as one message or many messages according to no of records in staging database?
p.s. Currently, I don't have an access to XI system. So, I need help from someone who has been through this scenario before. Thank you.
Regards,
Pavin

Go to See the other 4 answers

JDBC Adapter - Error Handling

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a question with JDBC Sender Adapter. In my scenario, SAP XI will retrieve input data using JDBC Sender Adapter. Here is my question, What would happen if input data is wrong and cannot pass mapping in XI? Would XI send success record to ta[More]

Handling JDBC adapter errors in BPM

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am using BPM to insert data in SQL server using a snychronous send.However i am not able to trap the adapter errors like server is down or could not insert because of key violation. Hence i decided to use transport level ack. But i understand t[More]

Error in JDBC Adapter-"Error establishing socket"

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am getting an error in the seander JDBC adapter. PFB the error: Error during database connection to the database URL 'jdbc:microsoft:sqlserver://Server Name;DatabaseName=DB Name;SelectMethod=cursor' using the JDBC driver 'com.microsoft.jdbc.sql[More]

JDBC adapter error

Category:DefaultRelease time:2015-10-11Views:130

I am working on proxy to jdbc scenario where iam seeing error log  in jdbc adapter of communication channel monitering  like below: Kindly do the needful? Could not execute statement for table/stored proc. "ACU_LVL_ADDR_SRC" (structure "Sta[More]

Jdbc adapter error on confirmation message in message monitor (rwb)

Category:DefaultRelease time:2015-10-11Views:130

I have the scenario iDoc -> PI 7 - > jdbc (AS400 odbc driver). When I do INSERT statements, the data is stored in the Database and the RWB message monitoring shows status Successfull. However, for every insert, an other message shows up in the messa[More]

JDBC Adapter - transaction handling

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a question. I use graphical Message Mapping and standard documents formats for Receiver JDBC Adapter. Now I need to push a delete call and insert calls in one message looks like that one f.e.:   <?xml version="1.0" encoding="U[More]

Passing JDBC adapter error message back to SOAP fault message

Category:DefaultRelease time:2015-10-11Views:130

I have a JDBC adapter that is returning an error in the response message:   <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> - <!--  Inbound Message   --> - <SAP:Error SOAP:mustUnderstand="1"[More]

SENDER JDBC ADAPTER ERROR

Category:DefaultRelease time:2015-10-11Views:130

Hi all, We are having an extrange problem. We are trying to read some info from an oracle Database, but we have always this error : Error: SQLException during query 'SELECT * FROM XX': java.sql.SQLException: ORA-00942: table or view does not exist: S[More]

Reciever JDBC Adapter error (Oracle)

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying FILE-XI-JDBC Scenario to get data loaded in Oracle. I have configured the reciever adapter in Communication Channel but while sending the message i am getting the following error: <b>com.sap.aii.af.ra.ms.api.DeliveryException: JDBC A[More]

JDBC Adapter Error - SAPClassNotFoundException: oracle.jdbc.driver.OracleDr

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am trying to implement JDBC to File scenario. Trying to connect to Oracle Database. Oracle drivers are installed on XI server JDBC Adapter parameters: JDBC Driver  - oracle.jdbc.driver.OracleDriver Connection - jdbc:oracle:thin:@10.25.228.156:1[More]

JDBC Adapter error (sender) from MS Access

Category:DefaultRelease time:-0001-11-30Views:130

Hi. I have an error in a communication channel for an interface with MS Access Data Base. The log info error is: "#00144F46B52C00370000000000006B820034E8A65C6B9661#1232148827508#com.sap.aii.adapter.jdbc.JDBC2XI##com.sap.aii.adapter.jdbc.JDBC2XI.invok[More]

Hot
Just tried to download new audiobooks to my iPod Touch 3, and noted new iTunes. iPod won't sync ("iTunes is unable to load data class information from Sync Services"). Tried to Reset Sync History per Support Article, but it didn't work. My purch [More]
Hello Y'all, How do I store about 695 signs inventory photo images from a PDF file to an Oracle database table? We are using Oracle 10.2.0.2. What data type should I use for these images? How about the table space? What table space should I allocate [More]
Hello all, I am working in SRM 7.0 and when I try to replicate service master (DNL_CUST_SRVMAS) I have this error: Set type COMM_PR_UNIT is not allowed for product type What can I do? I think that is an ABAP problem Thanks in advance Rosa RodríguezRo [More]
I'm running OS 10.6.8 on a MacBook Pro. I installed Adobe Reader 10.1.3 and now can't open any pdf files on the Internet.  Before I spend $39 calling an Adobe tech, I wonder if anyone can help?Yachna:  Thank you for your post of April, 18, 2012.  You [More]
My wife and I each have an iPhone and we share the same desktop PC at home. iTunes sucessfully keeps our music and photos separate; however, contacts under info uses what ever was set last. I want to use Google contacts and my wife wants to use Outlo [More]
I need help! If I have a pdf file and I want to upload to iFS, should I convert it to html or test format and save to database with iFS feature? Or it's better to save as a pdf file and output as html with iFS feature. Also, if I a some images in the [More]
FF 5.0 There use to be an option to set new tabs to blank. How do I do that now that you removed the option. I tried the obvious (?) of setting the new tab to "about:blank" and it still comes up with what ever search engine is paying you money. [More]
My friend brought over his iphone,he doesn't have a computer but wanted to update to 2.0.It said that becuase this was not the computer he synced with originally that if he did update it would erase all music,video etc.He did it anyways.Then he wante [More]
Hi Gurus..    I found the standard BAPI and I want to copy the standard BAPI into ZBAPI(for my company purpose) and use it in SAP xMII.   Please give the steps for copying. Thanks R MHi, To copy the standard BAPI into ZBAPI. check this link: how to c [More]
So when I go to the app store and click 'update all' it will go back to my home screen like normal but then the apps that should update go grey, say 'Waiting' and have the loading bar underneath but the bar won't fill! I also can't delete them to try [More]