on 05-15-2009 7:39 PM
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)?
try to execute the statement select * FROM MsdasdTRR(table name) where WOWO# eq '800051' in the DB and see if it returns any value
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
What the sender JDBC communication channel says in RWB->communication channel monitoring?
Thanx
Aamir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> 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.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.