jdbc2file scenario ?

[Former Member]

hi experts

as/400 to file scenario . i have configured the everything. adapter showing green. but i am unable to see the messages on the message monitoring.

1.data type for receiver .(REV_FILE)

2.ed(table definition)(ED_TAB)

1.receiver message type.

1.outbound(ED,table)

2,inbound (file Message type)

Message Mapping

sender mt to ED( Table Definition)

Interface Mapping

And ID

Sender Communication Channel

Data base Connection Parameters

sqlstatement : select * FROM MsdasdTRR(table name) where WOWO# eq '800051'

Document Name : ED_TAB

Namesapce :http://ns_Jdbc_2_file

Update : commit; or ( Update MsdasdTRR set WOWO# eq '800052' where '800051'

My problem and question.

1. I am Unable to pick the data from the data base. ?

2. where to test is the data base connection is perfect or not ?

3. What is syntax to communicate as/400 data base connection ( execution of equerry)?

4. can i use external definition as a message type (in message mapping and communication channel Document Name)?

[Shabarish_Nair]

try to execute the statement select * FROM MsdasdTRR(table name) where WOWO# eq '800051' in the DB and see if it returns any value

[Former Member]

hi

i used

select * From tablename.

it picuping the data (8000) Records > But in moni it showing error "EXCEPTION_DURING_EXECUTE"

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Request Message Mapping

-->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="">

<SAP:Category>Application</SAP:Category>

<SAP:Code area="MAPPING">EXCEPTION_DURING_EXECUTE</SAP:Code>

<SAP:P1>com/sap/xi/tf/_MM_Work_Order1_</SAP:P1>

<SAP:P2>com.sap.aii.utilxi.misc.api.BaseRuntimeException:</SAP:P2>

<SAP:P3>Element type "WOWO" must be followed by either att</SAP:P3>

<SAP:P4>ribute specifications, ">" or "/>".</SAP:P4>

<SAP:AdditionalText />

<SAP:Stack>Runtime exception occurred during application mapping com/sap/xi/tf/_MM_Work_Order1_; com.sap.aii.utilxi.misc.api.BaseRuntimeException:Element type "WOWO" must be followed by either attribute specifications, ">" or "/>".</SAP:Stack>

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

[Shabarish_Nair]

i think the issue is because of the # after WOWO field.

Is you table structure defined with a field called WOWO# ???

I am not sure if XI will accept such a special character in its field name.

[former_member200962]

check the inbound message in SXMB_MONI and see what the payload is...especially check for the element WOWO...may be some tags are missing

[Former Member]

What the sender JDBC communication channel says in RWB->communication channel monitoring?

Thanx

Aamir

[Former Member]

rwb->jdbc sender adapter -> status it showing green .

[Former Member]

doesn't it shows any polling?

if it just shows green but doesn't shows any polling,then it means that its unable to pick any data from database,it could be that the select query you have given is not satisfying any value in the data.

Thanx

Aamir

[Former Member]

it is not showing any poling

it showing

"Server 00 00_38942 Functioning "

Processing started.

[former_member200962]

>

> it is not showing any poling
> 
> it showing  
> 
>   "Server 00 00_38942 Functioning  "
> 
> Processing started.

If your adapter processing is not showing anything other than Processing started then it may have happened that the adapter has got locked..

go to visual administration......cluster......locking adapter....and look for a log for JDBC...if you find one then it means that your JDBC adapter is locked...just reset the lock....and then check in RWB....

Regards,

Abhishek.