Error when executing statement for table/stored proc

[Former Member]

Hi,

I am doing a IDOC to JDBC scenario. Every thing is fine in SXMB_MONI messages.

But in message monitoring and component monitoring this is the error showing...

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'COGRP_TMP_PROC' (structure 'Statement'): java.sql.SQLException: General error

Here is the mapping from IDOC to Stored Procedure...

*RTACOGRP_RECEIVER_MT

*COGRP01 -

---

> *Statement

• IDOC *COGRP_TMP_PROC

• BEGIN action

• EDI_DC40 *IDOCNUMBER

SEGMENT isInput(TRUE)

TABNAME type(CHAR)

-

---

-

---

-

---

*E1COGH -

---

>E1COGH_MSGFN

SEGMENT

MSGFN

Note: Please find my previous threads....

Is there any error in mapping to Statement...

Can any body please let me know the error

Thanks in Advance

Murthy

[Former Member]

Hi,

In ur receiver jdbc adapter, go to advanced mode and in additional parameters tab add logSQLStatement attribute and set value to true.Now execute ur scenario and inthe audit log what sql statement is generated.May be u will be able to trace the error generated in the sql statement.

Reward points if helpfull.

[bhavesh_kantilal]

Murthy,

1. Make sure that the Order of the Parameters and there names are same as int he Stored procedure.

2. Like i mentioned earlier try to look into your DB logs and try to check if there are any inputs.

Regards

Bhavesh

[Former Member]

Bhavesh,

I have compared with the structure for Stored procedure to Sql Stored procedure, all the parameters are same and are in the same order.

I tried to run Stored procedure in Sql Server and was running fine.

Can you please tell me how to check DB logs...

Thanks,

Murthy

[bhavesh_kantilal]

> Can you please tell me how to check DB logs...

Your DB admin should be able to help you in this.

Regards

Bhavesh

[Former Member]

Hi narasimha

can you check the Default Trace Logs in the visual admin, it will give us more info on the sqlexception

regards

krishna

[Former Member]

Krishna,

I did mapping from COGRP01 -

---

>Statement. Is that correct. Any way i will check in visual admin for trace logs.

Thanks,

Murthy