Communication channel error

[Former Member]

Hi All,

I am getting following error for jdbc communication channel in RWB.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. UPD_STYLE_PKG. XI_UPD_STYLE_EXP_DTE ' (structure 'Statement'): java.sql.SQLException: ORA-00001: unique constraint (ADE.STYLE_U1) violated ORA-06512: at "UPD_STYLE_PKG", line 618 ORA-01403: no data found ORA-06512: at line 1

Can someone tell how to fix this?

Thanks

[Former Member]

Hi

Check if you are not trying to insert a record whose unique/primary key already exists.

Thanks

[Former Member]

http://www.techonthenet.com/oracle/errors/ora01403.php

/wg

[Former Member]

the error shows no data found. could you check if the data that u want to extract is available in D/B

[Former Member]

it is a reciver jdbc adapter.

i am inserting values into a stored procedure and stored procedure inserts into the oracle database.

[Former Member]

Hi,

Error Message says, you are trying to insert a data for which foreign key data is missing hence insertion of data in table is failing.

Check out the data which you are trying to insert...either it is with duplicate key data or foreign key data is missing.

Nilesh

[Former Member]

in this case have u checked that u r not inserting a duplicate record

also check if the unique key in the table is being populated by XI when it sends data

also check the validity of data type for the unique key

[Former Member]

if there is a duplicate key data ,then stored procedure should ideally update the record.

since key data might be same but some other non key data might be different in the other insert.so record should be updated.

[Former Member]

so the problem is with you stored procedure

[Former Member]

No....In storeprocedure you have to take care of that...

Store procedures is nothing but group of SQL statements in compiled form. If you try to insert duplicate record with primary key in database you will get an error .

Nilesh