cancel
Showing results for 
Search instead for 
Did you mean: 

Column 'key' does not exist in table

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos
 use key1 instead of key node in your data type for where conditions....
prateek
Active Contributor
0 Kudos

Ur receiver side datatype structure could be incorrect. Paste it here. Also check the name of the fields.

Regards,

Prateek

Former Member
0 Kudos

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'

prateek
Active Contributor
0 Kudos

As I said, the structure is incorrect.

Instead of

<key>

<UserID>26345</UserID>

</key>

</access>

Use

</access>

<key>

<UserID>26345</UserID>

</key>

i.e., close the access tab before starting of key.

Regards,

Prateek

Former Member
0 Kudos

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

Former Member
0 Kudos

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