on 07-28-2008 9:17 AM
Hi ,
I am doing an Idoc to JDBC scenario . In my database table i have defined primary key constraint for coln 'Userid' and have used the same coln as key in Design. When iam testing , I am getting the err : Column 'key' does not exist in table in RWB.
Thanks,
Laawanya
use key1 instead of key node in your data type for where conditions....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ur receiver side datatype structure could be incorrect. Paste it here. Also check the name of the fields.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Everyone !
The receiver datatype in XI matches the database field names exactly.The primary key constraint is also defined in database for column UserID. Here is the receiver structure below.
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:SLRM_MT xmlns:ns0="http://shine_to_slrm">
- <Statement>
- <tbl_ShineUser action="UPDATE_INSERT">
- <access>
<UserID>26345</UserID>
<UserName>INDRANI</UserName>
<CircleID>VTIM</CircleID>
<SubCircleID>VTIM</SubCircleID>
<Status>0</Status>
<JoiningDate>20010605</JoiningDate>
<ReportingManagerID>00441020</ReportingManagerID>
<LevelCode>N</LevelCode>
<Designation>N9</Designation>
<UserEmail>NAV</UserEmail>
<CircleEffectiveDate>20060826</CircleEffectiveDate>
<SubCircleEffectiveDate>20030217</SubCircleEffectiveDate>
<LocationID>CAN</LocationID>
<CountryCode>CA</CountryCode>
<Code>Constant</Code>
<Billable>NAV</Billable>
<RelievingDate>20060826</RelievingDate>
- <key>
<UserID>26345</UserID>
</key>
</access>
</tbl_ShineUser>
</Statement>
</ns0:SLRM_MT>
FATAL ERROR: Column 'key' does not exist in table 'tbl_ShineUser'
use key1 for where conditions....
check for "key" fields in Database Tables, whether exists or nt???
Edited by: ragu r on Jul 28, 2008 10:22 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
U dont have any Column with Name "key" in ur database.
N thats why this error is coming.
Ur Data type should match exactly with ur Field names in Database.
Make it Userid in Design.
Thanks,
Mahi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.