on 10-16-2006 1:42 PM
Hello,
I tried a JDBC call and also used some web blogs as information. But I received a error message I couldn't deal with. My request to JDBC looks like this (from sxmb_moni):
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_User_CMDB_request xmlns:ns0="http://com.namespace">
- <STATEMENT>
- <TABLENAME action="SELECT">
<TABLE>my_table</TABLE>
</TABLENAME>
- <access>
<lastname />
</access>
- <key>
<email compareOperation="LIKE">test@test.de</email>
</key>
</STATEMENT>
</ns0:MT_User_CMDB_request>
I received the following error:
<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbo.exp_isos_Usr' (structure 'STATEMENT'): java.sql.SQLException: FATAL ERROR document format: structure 'STATEMENT', key element 'lastname' contains no values</SAP:AdditionalText>
Does anybody know what it could be??
In sxmb_moni: In first column I had red lamps. When do I get a red lamp and when a red flag??
Thanks
chris
Hi ,
This is the correct structure....try this way
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_User_CMDB_request xmlns:ns0="http://com.namespace">
- <STATEMENT>
- <TABLENAME action="SELECT">
<TABLE>my_table</TABLE>
- <access>
<lastname />
</access>
- <key>
<email compareOperation="LIKE">test@test.de</email>
</key>
<b></TABLENAME></b>
</STATEMENT>
Sekhar
</ns0:MT_User_CMDB_request>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Damm. I just found it in another thread
It seem to be really a wrong structure where the table-tag close to early.
Thanks a lot. I just wasn't able to see it, even I compared it with the SAP documentation
(http://help.sap.com/saphelp_nw04/helpdata/de/43/65d4dab39b0398e10000000a1553f6/frameset.htm).
points are given..
Hi,
Like pointed out , this is how the strucutre should be.
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_User_CMDB_request xmlns:ns0="http://com.namespace">
- <STATEMENT>
- <TABLENAME action="SELECT">
<TABLE>my_table</TABLE>
- <access>
<lastname />
</access>
- <key>
<email compareOperation="LIKE">test@test.de</email>
</key>
<b></TABLENAME></b>
</STATEMENT>
</ns0:MT_User_CMDB_request>
Take a look at my blog for more info,
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1) Kindly check whether the Table has LAST NAME field.
2) If so see whether the FIELD LAST NAME made Mandatory
one.
3) As Martin Mentioned check whethere the value is
available for the FIELD LAST NAME,
4) The LAST NAME field might be mandatory one in the
JAVA code you are using .
Regards
Agasthuri Doss
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is this not the problem.
'key element 'lastname' contains no values'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.