Hi,
I am trying to deploy replicant container items to SQL Server db. Here is an extract from log file which indicate incorrect syntax. The SQL statement it generates has WHERE keyword but missing condition checking causing failures. Has anyone encountered issues similar to this?
Log extract:
AS: SELECT
ELECT userid,locator_id,advisor_type_cd,title,first_name,middle_initial,last_name,work_phone,mobile_phone,fax,pager,toll_free_phone,email_address,background,additional_languages,specialty_programs,image_filename,manager_name,manager_phone,manager_id,active_flag,advisor_id FROM ADVISOR WHERE ORDER BY ADVISOR.advisor_id
DAS:
DAS: *******************************************************
DAS: SQLException occured in TDbSchemaGroupInfoNode
DAS: Exception Message: [COLUMBCMSOP1]Incorrect syntax near the keyword 'ORDER'.
DAS: Vendor Error Code: 156
DAS: SQL state: 01000
DAS: *******************************************************
Here is the code from my dbschema.cfg file:
<?xml version="1.0" encoding="ISO-8859-1" standalone="yes" ?>
<dbschema>
<group name="Advisor" table="Advisor" root-group="yes">
<attrmap>
<column name="advisor_id" data-type="INT" value-from-field="locator/0/advisors/[0-50]/id" allows-null="no" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="userid" data-type="CHAR(10)" value-from-field="locator/0/advisors/[0-50]/userid" allows-null="yes" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="advisor_type_cd" data-type="CHAR(1)" value-from-field="locator/0/advisors/[0-50]/advisor_type_cd" allows-null="no" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="title" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/title" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="first_name" data-type="VARCHAR(30)" value-from-field="locator/0/advisors/[0-50]/first_name" allows-null="no" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="middle_initial" data-type="CHAR(1)" value-from-field="locator/0/advisors/[0-50]/middle_initial" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="last_name" data-type="VARCHAR(30)" value-from-field="locator/0/advisors/[0-50]/last_name" allows-null="no" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="work_phone" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/work_phone" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="mobile_phone" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/mobile_phone" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="fax" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/fax" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="pager" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/pager" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="toll_free_phone" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/toll_free_phone" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="email_address" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/email_address" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="background" data-type="VARCHAR(1000)" value-from-field="locator/0/advisors/[0-50]/background" allows-null="yes" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="additional_languages" data-type="VARCHAR(30)" value-from-field="locator/0/advisors/[0-50]/additional_languages" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="specialty_programs" data-type="VARCHAR(200)" value-from-field="locator/0/advisors/[0-50]/specialty_programs" allows-null="yes" is-url="no" is-replicant="yes"/>
<column name="image_filename" data-type="VARCHAR(200)" value-from-field="locator/0/advisors/[0-50]/image_filename" allows-null="yes" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="manager_name" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/manager_name" allows-null="no" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="manager_phone" data-type="VARCHAR(50)" value-from-field="locator/0/advisors/[0-50]/manager_phone" allows-null="no" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="manager_id" data-type="INT" value-from-field="locator/0/advisors/[0-50]/manager_id" allows-null="yes" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
<column name="active_flag" data-type="CHAR(1)" value-from-field="locator/0/advisors/[0-50]/active_flag" allows-null="no" is-url="no" is-replicant="yes"/> <!-- NOT NULL -->
</attrmap>
<keys>
<primary-key>
<key-column name="advisor_id"/>
</primary-key>
</keys>
</group>
</dbschema>
Thanks in advance,
Harsh
Edited by Harsh_SVRN on 01/25/06 11:13 AM (server time).
