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
hello, I just lost my phone and I have the app find my Iphone, but I have no idea how you use the program on my laptop to track down the phone. Can someone please tel me how this works? ThanksGo to www.iCloud.com and log in. Find my iPhone app must b [More]
Hi The Error is as follows: sqlplus: Error while loading shared libraries: libsqlplus.so: cannot open shared object file: no such file or directory Installed R12 with RUP2. User Oracle already exists. I tried to create a user appsdev as follows: #add [More]
If you followed the other thread, I just got hosed by installing 4.1 on a Matrox system. I've got a fresh install of 4.0.0 now, and I need the 4.0.1 update. The automatic updater doesn't give me that option. Any ideas? Thaks a million, JonathanI'm so [More]
I am using Docs2Go and when I save a document, a see an option to save on "local"; thats where I save them. finding these documents is becoming difficult. How can I create sub folders in local disk so that documents can be organised. Secondly, a [More]
1. FTP client that shows you your progress. If it's going to be 1/2 an hour, it makes sense to something else. Currently, I often use FTPVoyager because it shows me the progress per file and overall. and shows the percent complete so I can estimate t [More]
I am using Release 10.2.0.1.0 version of oracle. I am getting a special character, but i suspect it as any other language caharacter. Its appearing in my 'TOAD editor/Sql prompt editor' as 'A?'. but when i am selecting it from the table using below q [More]
Dear Experts, How can we make only single currency to be allowed to enter in the sales documents - sales orde / invoice ??? Eg. If we want to create order only in INR and should not be created for any other currency  than INR, how we can achieve this [More]
Hello, We want to make the view of Complaints non-editable after succesful save of the Complaint. I think I must add some code in method EH_ONSAVE of component BT120H_CPL/ OVViewset. Do you have any idea of how to achieve this? Best Regards.Thanx for [More]
In oracle payroll we have an option to run quick pay for particular employee,and select the element as much as you want to process by standar type run type,my question is that how can we create our customize run type and link with our selected elemen [More]
Your support is highly neededChaging your user name is easy. I can see you haven't upgraded to ios7, but that is okay. Go to the gamecenter app> click your email> sign in> and scroll down until you see your user name> Then you can cahnge it fr [More]