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
As I said, the other day I had downloaded the latest version of Firefox and after doing so none of the icons for the different websites that normally go to are no longer there. Websites such as MSNBC, MSN, Most visited, that entire strip is no longer [More]
Helo everyone, I need wht are the common fields between table of KONV and J_1IEXCHDR,EKKO,EKPO,MSEG. Pls give me details thanks in advance sureshcheck out LIFNR,KUNNR ETCRead other 2 answers [More]
Hi all I am using BAPI_BILLINGDOC_CREATEMULTIPLE and passing all the values correctly. I am getting values in error and return tables, if there are any errors. My problem is that, suppose for an order there are 2 line items. Then for the line items t [More]
how do i add a second ipod device (ipod touch 4th gen) to my account?  http://support.apple.com/kb/HT4627Read other 2 answers [More]
Hi... I have a report which shows list of Titles in the first column and the corresponding amounts based on several account and profit center restrictions in the further columns.  Titles basically are movie names. Titles have navigational attributes [More]
hi expert, i want to import goods recipt PO through DTW .is it possiable in SAP B1 to import GRPO data through template?which template shuld i use and how.Please give me detail about it I want add GRPo of the having in stock reagrd sachin Edited by: [More]
I have been using Logic Pro for several years now. I recently bought a version of ProTools 9. Will both of these programs coexsist together on the same Mac without creating problems for each other? Do I need to run them on different computers? I know [More]
Hi all, When I have copied journals to another category or time, and want to change some of its content, I cannot save the journal, as the button 'Save' is not activated. When I post the journal, it does change back to the original entries. We curren [More]
Hi gurus, i want to create the auto-increasing counter for the records in my message mapping.But during my testing,the sequence number always pops up "1" which means it don't calculate based on the cache value. The code as below: =============== [More]
Hello, I am using 10.7.5 and ARD 3.6.1 and cannot figure out how to remotely log in to another computer I wish to remotely log in using ARD to multiple computers in my network, up to 30 at a time for elementary students.  I can observe, control and s [More]