Skip to Content
0
Former Member
Jan 18, 2008 at 07:20 PM

RFC to JDBC Sync. Scenario

21 Views

Hello Guys,

I'm trying to set up a RFC - XI - JDBC Scenario. Where the RFC sends some parameters and the JDBC performs a SELECT Query.

I have a RFC that already was imported with the following definition:

IMPORTING

VALUE(LOGIN) TYPE STRING

VALUE(VIGENCIA) TYPE STRING

EXPORTING

VALUE(LOGIN_RES) TYPE STRING

VALUE(ID_USUARIO) TYPE STRING

VALUE(FECHA_CREACION) TYPE STRING

VALUE(VIGENCIA_RES) TYPE STRING

VALUE(PERFIL) TYPE STRING

I already define the JDBC Request Structure as:

<Statement_Select>

<TableName Action="SELECT">

<Table>USUARIO_WEB2</Table>

<Access>

<ID_USUARIO_WEB/>

<LOGIN/>

<FECHA_CREACION/>

<VIGENCIA/>

<PERFIL/>

</Access>

<Key>

<LOGIN>value1</LOGIN>

<VIGENCIA>value2</VIGENCIA>

</Key>

</TableName>

</Statement_Select>

After testing the RFC I'm getting the following error in the CC monitor:

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'null' (structure 'LOGIN'): java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

Can anyone please help me with this? I'm not sure where the error migth be.

Thanks!

Felipe