Missing Lft, Rght and Hierarchy Level columns

Jul 22, 2009 at 11:12 AM

Hi !

After activating SLAM, in The created table Shapes (from hierarchical list) is missing Lft, Rght and Hierarchy Level columns !

Here's my slam.config:

 

<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
  <TypeProfiles>
    <add Name="HierarchicalList" AssemblyQualifiedTypeName=
           "AWS.SLAM.Hierarchy.HierarchicalListTypeProfile, 
            AWS.SLAM.Hierarchy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=896136499185ddc1" />
    <add Name="HierarchicalContent" AssemblyQualifiedTypeName=
           "AWS.SLAM.Hierarchy.HierarchicalContentTypeTypeProfile, 
            AWS.SLAM.Hierarchy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=896136499185ddc1" />
  </TypeProfiles>
  <ConnectionStrings Default="SLAM">
    <add Name="SLAM" ConnectionString="Database=slam;Data Source=WIN-E5XXPZYPCVR\SQLEXPRESS;User Id=sa;Password=.mc123++" />
  </ConnectionStrings>
  <DataMapping DataSchema="SLAM">
    <List Name="Clientes" ActivationOrder="1">
      <Fields>
        <Field Name="Nome" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
      </Fields>
    </List>
    <List Name="Projectos" ActivationOrder="2">
      <Fields>
        <Field Name="Nome do Projecto" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
        <Field Name="Cliente" SPType="Lookup" AssociatedList="Clientes" AssociationName="ClientesToProjectos"></Field>
      </Fields>
    </List>
    <List Name="Tarefas" ActivationOrder="3">
      <Fields>
        <Field Name="Nome da Tarefa" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
        <Field Name="Projecto" SPType="Lookup" AssociatedList="Projectos" AssociationName="ProjectosToTarefas"></Field>
        <Field Name="Tempo Estimado" SqlType="decimal(18,2)" SPType="Number" Required="true"></Field>
        <Field Name="Notas" SqlType="varchar(max)" SPType="Note" Required="false"></Field>
      </Fields>
    </List>
    <List Name="Requisitos" TypeProfile="HierarchicalList" ActivationOrder="4">
      <Fields>
        <Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
      </Fields>
    </List>
    <List Name="Shapes" TypeProfile="HierarchicalList" ActivationOrder="5">
      <Fields>
        <Field Name="Title" TypeProfile="HierarchicalContent" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
      </Fields>
    </List>
  </DataMapping>
</Configuration>

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

<Configuration>

  <TypeProfiles>

    <add Name="HierarchicalList" AssemblyQualifiedTypeName=

           "AWS.SLAM.Hierarchy.HierarchicalListTypeProfile, 

            AWS.SLAM.Hierarchy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=896136499185ddc1" />

    <add Name="HierarchicalContent" AssemblyQualifiedTypeName=

           "AWS.SLAM.Hierarchy.HierarchicalContentTypeTypeProfile, 

            AWS.SLAM.Hierarchy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=896136499185ddc1" />

  </TypeProfiles>

  <ConnectionStrings Default="SLAM">

    <add Name="SLAM" ConnectionString="Database=slam;Data Source=WIN-E5XXPZYPCVR\SQLEXPRESS;User Id=sa;Password=.mc123++" />

  </ConnectionStrings>

  <DataMapping DataSchema="SLAM">

    <List Name="Shapes" TypeProfile="HierarchicalList" ActivationOrder="5">

      <Fields>

        <Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="true"></Field>

      </Fields>

    </List>

  </DataMapping>

</Configuration>

 

Developer
Jul 22, 2009 at 4:32 PM

And after saving an item they are still missing?

Jul 22, 2009 at 4:52 PM

After inserting item "Object", for example, and then trying to add "Polygon", they're still missing... as well as "root" is still the only parent avalilable !

Developer
Jul 30, 2009 at 9:11 PM

Are any errors logged in the Windows Event Log on save?  In the SLAMMessageLog Table? 

Also in the pasted slam.config it shows the "AssemblyQualifiedTypeName" attribute value as having a line break in it, does your config actually have that line break or is it just a product of pasting?  Attribute values can't have line breaks but I would expect validation to error if your config did have them so it would be a fairly obvious problem.

Jan 6, 2010 at 12:24 PM

Hello marcocarola and brjenkins,

Did you solve your issue ? For information, I have the same issue when I create the list as a custom list and not a hierarchical list. I think we need to create the list as a hierarchical list but I cannot on my side...The  system is prompting me the user/password again and again (I did a comment on a same post)

Regards

Mar 18, 2011 at 8:41 AM

Had the exact same issue, but thanks to brjenkins, it's now solved. Furthermore not only left,right columns where missing in database, but when creating hierarchial list, the SharePoint was unacessible until i deleted that list with SharePoint manager 2007.

So the issue was that attribute value had line break in it (I copied the code from Hierarchy - SLAM Extension page), althought SLAM Validation passed sucessfully.

I guess that page needs a note to remove linebreaks if the config example is being copied.

Im still having other issues to get it working, but at least database is now ok :)