Activate Fails

Aug 18, 2010 at 7:00 PM

I've create a dummy sharepoint site to test SLAM v.1.3 before production.  WSS 3.0 with Sql 2000 as the db.  When I validate the config it works fine.  However when I activate it fails with the following error message:

Line 5: Incorrect syntax near 'max'.   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.SqlLogDataRepository.CreateMessageTable(String tableSchema)
   at AWS.SLAM.Logging.SqlLogger..ctor(IConfigurationManager configuration)
   at AWSSLAMLoggingSqlLoggerInstanceBuilderbf8b4a5dafdf43a6a7f9987c0acab52b.BuildInstance(IConfiguredInstance , BuildSession )
   at StructureMap.Pipeline.ConfiguredInstanceBase`1.StructureMap.Pipeline.IConfiguredInstance.Build(Type pluginType, BuildSession session, InstanceBuilder builder)

Here is my config.  You can see it is a simple dummy config to test and see if SLAM will provide what we need in our environment.  Any assistance would be greatly appreciated.

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

  <ConnectionStrings Default="SLAM">
    <add Name="SLAM" ConnectionString="Database=SLAM;Data Source=SERVER;User Id=user;Password=password" />
  </ConnectionStrings>

  <DataMapping DataSchema="SLAM">

    <List Name="test" ActivationOrder="1">
      <Fields>
        <Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
      </Fields>
    </List>

    <List Name="test2" ActivationOrder="2">
      <Fields>
        <Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
        <Field Name="test title" SPType="Lookup" AssociatedList="test" AssociationName="testTotest2"></Field>
      </Fields>
    </List>

  </DataMapping>
</Configuration>

Thanks.

Developer
Sep 2, 2010 at 9:14 PM

SLAM requires that the database it uses is at least SQL Server 2005.  For its message logs table it creates a column of type varchar(max).