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
i need to upload the open Purchase Order using the BAPI function BAPI_PO_CREATE1., below is the given fileds blod are for Header, header will Repeat for the line items,can any one help me out  using the BAIP's for upload the PO, i need sample code fo [More]
Hi all, I recently set up an Airport Extreme on our office network to offer wireless network access piggybacked on our wired router. I then purchased an Airport Express which I was planning on using as a wireless print server for our Canon i9900 for [More]
When I deploy the cube which is sitting on my PC (local) the following 4 errors come up: Error 1 The datasource , 'AdventureWorksDW', contains an ImpersonationMode that that is not supported for processing operations.  0 0  Error 2 Errors in the high [More]
Hello. I am using an HP F2280 to print lecture slides that have been prepared as PDF files. There are 6 slides to a sheet. When I print, a random "strip" of a lecture slide is printed twice; once in it's correct, original position and the second [More]
Hi Experts, I have created the below objects for the Webservice to JDBC BPM scenario. Data Type 1. DT_SOAPRequest 2. DT_SOAPResponse 3. DT_JDBCRequest 4. DT_JDBCResponse MessageType 1. MT_SOAPRequest 2. MT_SOAPResponse 3. MT_JDBCRequest 4. MT_JDBCRes [More]
I have problem with Twitter last 2 days like this; http://i767.photobucket.com/albums/xx319/MetalMan20/TwitterProblem_zps5aa4fc79.pngHello, Many site issues can be caused by corrupt cookies or cache. In order to try to fix these problems, the first s [More]
Hi I have a problem installing msi live update. I have tried with the utility cd and downloadet the newest version for MSI. When I click the exe i run shortly and then disappears. Nothing happens - I can see the Live Update process in the taskbar. My [More]
I am having problems accessing the IPhoto Library through Photoshop 4.0. Before I upgraded my IPhoto the library was considered an ordinary folder but now it is "greyed" out. It seems I can only access my pictures through IPhoto itself. What sho [More]
HP Compaq Presario CQ70-116EA : P/N NG504EA Windows Vista 32-bit 2 Issues Device : BCD-CD V 01.02.01.01 1.11 USB Device Error : Windows cannot load the device driver for this hardware. The driver may be corrupted or missing. (Code 39) Device : TSSTco [More]
Hi, I've made a proxy Service in aqualogic, that contacts another webservice, with a different WSDL than the proxy. How do i define the messageflow for this? I need to map the proxy requestxml to the business service xmlschema, for which I have build [More]