I have a strange DD problem with 6.0 on W2k3 deploying to SQL Server 2000. In my dev environment, everything works, but I'm getting a couple of unexpected warnings. On the QA server, an identical dd_cfg is not working with the same template. For the moment, let's talk about the problem strictly in regard to QA. If someone wants to see some stuff from dev to clarify, I can drag that out later.
We have a column called AUTHOR, which stores the author's id. This column is not getting populated during deployment despite there being data for it in the tuple.
Here's the schema for it:
<dbschema name="knowledge_management_meeting">
<group name="CMS_TEAMSITE" root-group="yes">
<attrmap>
<column name="FILENAME" data-type="VARCHAR(100)" value-from-field="path" allows-null="yes" is-url="no"/>
<column name="AUTHOR" data-type="VARCHAR(25)" value-from-field="Left Nav Information/0/Author" allows-null="no" is-url="no"/>
<column name="DEPTHEAD_NAME" data-type="VARCHAR(50)" value-from-field="Left Nav Information/0/Department Head" allows-null="no" is-url="no"/>
<column name="DEPTHEAD_EMAIL" data-type="VARCHAR(75)" value-from-field="Left Nav Information/0/Department Head Email" allows-null="no" is-url="no"/>
<column name="MODIFY_DATE" data-type="DATETIME(8)" data-format="MM/dd/yyyy" value-from-field="Left Nav Information/0/Revision Date" allows-null="no" is-url="no"/>
<!-- Keyed values passed by deployMetadata.ipl file -->
<column name="TEAMSITE_URL" data-type="VARCHAR(200)" value="$teamsiteURL^" allows-null="no" is-url="no"/>
<column name="WEBSERVER_URL" data-type="VARCHAR(200)" value="$webserverURL^" allows-null="no" is-url="no"/>
<column name="EXPIRATION_DATE" data-type="DATETIME(8)" data-format="MM/dd/yyyy" value="$expDate^" allows-null="no" is-url="no"/>
<column name="EDITOR_NAME" data-type="VARCHAR(100)" value="$editors^" allows-null="no" is-url="no"/>
<column name="EDITOR_EMAIL" data-type="VARCHAR(200)" value="$emails^" allows-null="no" is-url="no"/>
<!-- .NET application will update this field - wont take a NULL so write a date to please it -->
<column name="LAST_EMAILSENT" data-type="DATETIME(8)" data-format="MM/dd/yyyy" value="01/01/0001" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="FILENAME"/>
</primary-key>
</keys>
</group>
</dbschema>
Here is a sample tuple, with the problem field highlighted in red:
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| TUPLE={IWOV_PROC_FLAG=true, state=Original, Left Nav Information/0/Revision Date=10/21/2004, Short Project Name=rednex, Topics/0=, Left Nav Information/0/Author=TWCCORP\V009272, Left Nav Information/0=, Topics/0/Links/0/Link URL=/tsg/docs/kmISCMTG/agenda04-04-13.doc, Topics/0/Links/0=, Left Nav Information/0/Department Head=asdfasdfa, Introduction=asdfasdf asdfasdf asdfasdfa
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| asdfasdfasdf asdfasdfasdf, Topics/0/Links/0/Link Caption=A link, Left Nav Information/0/Department Head Email=asdfasdfasdf@twcable.com, Left Nav Information/0/Left Nav Caption=leftnav, Headline=Rednex Online meeting schedule, Topics/0/Topic=asdfasdfasdf, path=templatedata\knowledge_management\meeting\data\rednex_meet}
And, here, a little later on in the log file are the warnings that bother me. Note: these are exactly the same warnings I get on dev, where it does work...
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| TTableSchemaHelper object for [CMS_TEAMSITE] found in cache.
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| Column AUTHOR not found in array
...
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| TTableSchemaHelper object for [CMS_TEAMSITE] found in cache.
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| Column AUTHOR not found in array
....
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| Column AUTHOR not found in array
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| WARNING:Value for [Author] exceeds column width [ 15 > -1]
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| Column AUTHOR not found in array
ENG: 2004-10-21 10:10:18 EDT GMT-04:00 DD| Column: Author, field: Left Nav Information/0/Author, Index: 1,Converting '......<Value Too large to be written to log file>.....' to LONGVARCHAR
We used to have an author_name and author_email column and replaced them with just the one column. I sort of suspect that we have the old table schema in the schemahelper cache, but I'm not sure how to clear that out. I've also attached a screenshot from the query analyzer so you can see that the table structure matches the schema.
The one difference I see is that the cases do not match. However, we have other schemas that are working in QA that have AUTHOR rather than Author. Just to be sure, I changed it and retested, with the same result. My colleague has opened a case with support, but I'm expecting that I'll get a quicker answer here.
Thanks
Rob
