Receiver JDBC error:Can't start a cloned connection

[Former Member]

Experts -

During the run of Receiver JDBC adapter I am getting the following error.

*********************************************************

Unable to execute statement for table or stored procedure. 'prc_FC_InsertStagingJournalEntries' (Structure 'StatementName') due to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

*********************************************************

I am trying to run a Stored Procedure at the Database side of it.

Pls advice any clue ?

Cheers,

Amrish.

[Former Member]

Ok Moorthy... Pt#15 in note helped the current error [points assigned for that ) ]

however, I am getting anothe error, in my stored procedure which i am trying to run the single parameter is defined as "@JournalData" but I have created my data type as "JournalData" in XI (since I can not create as "@JournalData" because its an Invalida character for XI.

The error Which I am getting now in Adapter Monitor as

"- 2006-11-07 16:13:59 EST: Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'prc_FC_InsertStagingJournalEntries' (structure 'StatementName'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Procedure 'prc_FC_InsertStagingJournalEntries' expects parameter '@JournalData', which was not supplied.

- 2006-11-07 16:13:59 EST: Processing started"

Any clue ?

Cheers,

Amrish.

[moorthy]

HI,

Did you go thru this blog- /people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

if not glance thru that.

Regards,

moorthy

[Former Member]

Yes... Not helpful in this case... in fact I went through almost all the weblogs related to this topic in sdn. No luck so far..

Basically, my stored procedure is expecting parameter name as "@JournalData" rather I can have the parameter name as "JournalData" only due to its an Invalid name in XI Integration builder. I think, this is the reason its throwing this error.

Not sure If I have to use approach with "StatementName6" with "Action=SQL_QUERY" at the following sap help link:

http://help.sap.com/saphelp_nw2004s/helpdata/en/96/791c42375d5033e10000000a155106/frameset.htm

Cheers,

Amrish.

[moorthy]

Hi,

did you check the given blog.. It has 2 inputs User name and Password. did you check the Target message type in this blog.. i.e it is used as a Attribute.. just check it..

Regards,

moorthy

[Former Member]

Well, Moorthy it was my bad. I had a different Data Type structure than I was suppose to have. I changed the data type and it ran Thanks for all your help.

Cheers,

Amrish.

[moorthy]

Hi,

check out the document format of the mapped xml structure , before it clls to the JDBC receiver adpter.

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Also look into SAP Note - 831162 , question no 15.

Regards,

Moorthy