Cannot activate...

Jun 22, 2010 at 9:54 PM

Greetings,

1 test server with MOSS 2007 & SQL 2005 Express both onboard.

My SLAM installation went without incident. I edited my slam.config as best as I could determine - using the "Illustrated Guide to SLAM" (I must be missing some more training materials and/or examples, right?). The contents of this config file are listed below. I ran the configuration/validation without incident. However, when I try to activate I got an "Unknown error" message.

So I checked the discusstions and adjusted the web.config file so that the customErrors mode was set to off, and set the SafeControls CallStack value to true.

Now when I try to activate I get the following...

   
Incorrect syntax near 'end'.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo methodInfo, Object[] parameters)
   at System.Data.Linq.DataContext.ExecuteCommand(String command, Object[] parameters)
   at AWS.SLAM.Data.SqlDataRepository.UpdateContentTable(String tableSchema, String tableName, IEnumerable`1 fields)
   at AWS.SLAM.Activation.SqlDataSynchronizeTypeProcessor.Process(String sharepointSiteLocation, IDictionary`2 parameters)
   at AWS.SLAM.Activation.DataSynchronizer.Synchronize(String sharepointSiteLocation)
   at AWS.SLAM.Activation.Activator.Activate(String siteCollectionName)
   at AWS.SLAM.Administration.Activation.btnAttachEvents_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Here's the Control Panel diagnostics...

Date Type Message
6/22/2010 4:38:09 PM Information Update Table: begin end
6/22/2010 4:38:09 PM Information Processing EmpLoc
6/22/2010 4:38:09 PM Information Attached Event Handlers for List: JobDesc
6/22/2010 4:38:09 PM Information Attached Event Handlers for List: CtrNameAddr
6/22/2010 4:38:09 PM Information Attached Event Handlers for List: HRPERSNL3
6/22/2010 4:38:09 PM Information Attached Event Handlers for List: EmpLoc
6/22/2010 4:38:09 PM Information Activation Initiated
6/22/2010 4:38:09 PM Information Deactivation Complete
6/22/2010 4:38:09 PM Information Detached Event Handlers for List: - 3782cd1d-2de9-49b0-bc7b-944a4d6b641a - JobDesc
6/22/2010 4:38:09 PM Information Detached Event Handlers for List: - e61c1898-a74f-44e7-b361-67db3e7c3fe4 - HRPERSNL3
6/22/2010 4:38:09 PM Information Detached Event Handlers for List: - 527e3c5e-aae0-4c21-8440-1cfe60699019 - EmpLoc
6/22/2010 4:38:09 PM Information Detached Event Handlers for List: - 7433ea55-cc1c-4408-8acf-f654881c8601 - CtrNameAddr
6/22/2010 4:38:09 PM Information Deactivation Initiated


And here's my slam.config file...

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

   <ConnectionStrings Default="SLAM">
      <add Name="SLAM" ConnectionString="Database=SLAMTEST;Data Source=SHAREPOINT-TEST\OFFICESERVERS;User Id=XXXXX;Password=XXXXX" />
   </ConnectionStrings>

   <DataMapping DataSchema="SLAM">

      <List Name="EmpLoc" ActivationOrder="1">

         <Fields>
            <Field Name="Fullname" SPType="Lookup" AssociatedList="HRPERSNL3" AssociationName="EmpLoc_HRPERSNL3"></Field>
            <Field Name="Center" SPType="Lookup" AssociatedList="CtrNameAddr" AssociationName="EmpLoc_CtrNameAddr"></Field>
            <Field Name="Position" SPType="Lookup" AssociatedList="JobDesc" AssociationName="EmpLoc_JobDesc"></Field>
         </Fields>

      </List>

      <List Name="HRPERSNL3" ActivationOrder="2">

         <Fields>
            <Field Name="P_EMPNO" SqlType="varchar(4)" SPType="text" Required="true"></Field>
            <Field Name="P_LNAME" SqlType="varchar(25)" SPType="text" Required="true"></Field>
            <Field Name="P_FNAME" SqlType="varchar(15)" SPType="text" Required="true"></Field>
            <Field Name="Fullname" SqlType="varchar(40)" SPType="Text" Required="true"></Field>
         </Fields>

      </List>

      <List Name="CtrNameAddr" ActivationOrder="3">

         <Fields>
            <Field Name="CtrName" SqlType="varchar(25)" SPType="text" Required="true"></Field>
            <Field Name="Street" SqlType="varchar(25)" SPType="text" Required="true"></Field>
            <Field Name="City" SqlType="varchar(15)" SPType="text" Required="true"></Field>
            <Field Name="State" SqlType="varchar(2)" SPType="text" Required="true"></Field>
            <Field Name="Zip" SqlType="varchar(10)" SPType="text" Required="true"></Field>
         </Fields>

      </List>

      <List Name="JobDesc" ActivationOrder="4">

         <Fields>
            <Field Name="JobDescAbbr" SqlType="varchar(20)" SPType="text" Required="true"></Field>
         </Fields>

      </List>

   </DataMapping>

</configuration>


Please help.
Thanks!

Developer
Jun 24, 2010 at 10:40 PM
So it fails on the list that has only associations configured. What if you try adding a field entry, say, for Title? If it works then clearly it's a bug (expecting that at least one non-association field is always configured to be slammed, which clearly is not a valid assumption here).
Jun 25, 2010 at 2:48 PM

>>  What if you try adding a field entry  <<

Yep. That does it. It now successfully activates and synchronizes. Thanks!

Here's the final slam.config...

 

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

   <ConnectionStrings Default="SLAM">
      <add Name="SLAM" ConnectionString="Database=SLAMTEST;Data Source=SHAREPOINT-TEST\OFFICESERVERS;User Id=XXXXX;Password=XXXXX$" />
   </ConnectionStrings>

   <DataMapping DataSchema="SLAM">

      <List Name="EmpLoc" ActivationOrder="1">

         <Fields>
            <Field Name="Fullname" SPType="Lookup" AssociatedList="HRPERSNL3" AssociationName="EmpLoc_HRPERSNL3"></Field>
            <Field Name="Center" SPType="Lookup" AssociatedList="CtrNameAddr" AssociationName="EmpLoc_CtrNameAddr"></Field>
            <Field Name="Position" SPType="Lookup" AssociatedList="JobDesc" AssociationName="EmpLoc_JobDesc"></Field>
            <Field Name="Comment" SqlType="varchar(25)" SPType="text"></Field>
         </Fields>

      </List>

      <List Name="HRPERSNL3" ActivationOrder="2">

         <Fields>
            <Field Name="P_EMPNO" SqlType="varchar(4)" SPType="text" Required="true"></Field>
            <Field Name="P_LNAME" SqlType="varchar(25)" SPType="text" Required="true"></Field>
            <Field Name="P_FNAME" SqlType="varchar(15)" SPType="text" Required="true"></Field>
            <Field Name="Fullname" SqlType="varchar(40)" SPType="Text" Required="true"></Field>
         </Fields>

      </List>

      <List Name="CtrNameAddr" ActivationOrder="3">

         <Fields>
            <Field Name="CtrName" SqlType="varchar(25)" SPType="text" Required="true"></Field>
            <Field Name="Street" SqlType="varchar(25)" SPType="text" Required="true"></Field>
            <Field Name="City" SqlType="varchar(15)" SPType="text" Required="true"></Field>
            <Field Name="State" SqlType="varchar(2)" SPType="text" Required="true"></Field>
            <Field Name="Zip" SqlType="varchar(10)" SPType="text" Required="true"></Field>
         </Fields>

      </List>

      <List Name="JobDesc" ActivationOrder="4">

         <Fields>
            <Field Name="JobDescAbbr" SqlType="varchar(20)" SPType="text" Required="true"></Field>
         </Fields>

      </List>

   </DataMapping>

</configuration>