This project is read-only.

Unable to Validate Slam.config

Dec 13, 2011 at 2:51 AM

I have been trying over 5 hours just to get my slam.config file to validate and activate.
Here’s the scenario (machine name replaced for security reasons):

Server: Local SharePoint Foundation Server Installation with SQL Server
Site URL: http:/localmachinename:15432/slam

List1 :: Name= Clients; ID= 6D793B6C-3F9B-4C88-9209-3E046DEE54DA; Fields ={Title – Single Text Line, Location – Multi-Value Lookup Colum to “Locations”}

List2 :: Name= Locations; ID= 73FFE399-7F3E-4F45-9A57-79C6EAD45A06; Fields = {Title – Single Text Line}

<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<ConnectionStrings Default="SLAM">
<add Name="SLAM" ConnectionString="Database=slam_database;Data Source=localservername\instancename;User Id=slamuser;Password=isissunwings" />
</ConnectionStrings>

<DataMapping DataSchema="SLAM">
<List Site="slam" Name="Clients" ID="73ffe399-7f3e-4f45-9a57-79c6ead45a06"  ActivationOrder="2">
<Fields>
<Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
<Field Name="Location" SPType="Lookup" AssociatedTypeName="Locations" Required="false"></Field>
</Fields>
</List>
<List Site="slam" Name="Locations" ID="6d793b6c-3f9b-4c88-9209-3e046dee54da" ActivationOrder="1">
<Fields>
<Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
</Fields>
</List>
</DataMapping>
</Configuration>

 

When I click to validate my slam.config, I get the following errors:

Type: slam - 6d793b6c-3f9b-4c88-9209-3e046dee54da - Locations
Exception: System.NullReferenceException: Object reference not set to an instance of an object. at AWS.SLAM.Configuration.XmlTypeIdDefinitionSection.get_Default() at AWS.SLAM.Configuration.XmlSqlDataMapping.GetTypeFields(String id, String typeName) at AWS.SLAM.Administration.Configuration.<>c__DisplayClass3.b__0()Type: slam - 73ffe399-7f3e-4f45-9a57-79c6ead45a06 - Clients
Exception: System.NullReferenceException: Object reference not set to an instance of an object. at AWS.SLAM.Configuration.XmlTypeIdDefinitionSection.get_Default() at AWS.SLAM.Configuration.XmlSqlDataMapping.GetTypeFields(String id, String typeName) at AWS.SLAM.Administration.Configuration.<>c__DisplayClass3.b__0()

Matched Types

slam - 6d793b6c-3f9b-4c88-9209-3e046dee54da - Locations

slam - 73ffe399-7f3e-4f45-9a57-79c6ead45a06 - Clients

Unmatched Types

slam - 6d793b6c-3f9b-4c88-9209-3e046dee54da - Locations

slam - 73ffe399-7f3e-4f45-9a57-79c6ead45a06 - Clients

 The only tables that were created are the following

  • Site
  • List
  • MessageLog
  • SiteCollection

In the diagnostic log,  the following exeptions are repeated for both "cleints" and "locations" lists:

System.NullReferenceException: Object reference not set to an instance of an object. at AWS.SLAM.Configuration.XmlTypeIdDefinitionSection.get_Default() at AWS.SLAM.Configuration.XmlSqlDataMapping.GetTypeFields(String id, String typeName) at AWS.SLAM.Activation.SqlDataSynchronizeTypeProcessor.Process(String sharepointSiteLocation, IDictionary`2 parameters) at AWS.SLAM.Administration.Synchronization.DoSynchronization(String siteCollectionUrl, String typeName, String typeId, String typeSiteCollection, String typeSite)

What could I possibly be doing wrong?  I really hope to get this product working so we can use the data with SSRS becuase its dang near oimpobbsible to generate any Chart WebParts with lists that have lookup columns and more difficult to do aggregations.

 

Thank you!

Developer
Dec 13, 2011 at 3:52 PM

Sorry about this, I have updated the release and source.  Please download the SLAM_2_2010 zip again and update the wsp.

Dec 13, 2011 at 5:27 PM

I removed and uninstalled the wsp from yesterday and installed the wsp from today.  I still receive the same errors.  If I created the tables and populated the Site, SiteCollection, and List tables, would this put me further along in the activation process?  If so what is the DLL to create the tables related to "Clients" and "Locations"

Developer
Dec 13, 2011 at 5:30 PM

Hm, I was able to reproduce the issue and resolved it with the fix included in the latest build.  You're still getting the error on validate?  I'm assuming IIS was reset in the process since you reinstalled it (because that would have been my immediate suggestion).

Dec 13, 2011 at 9:42 PM
Edited Dec 13, 2011 at 9:42 PM

Ok.  I debug the new source code and whatever I am doing, the applications crashes at the following Configuration.aspx.cs, line 348:

 

List<Field> typeFields = currentDataMapping.GetTypeFields(type.Id, configuredTypeName).ToList();
Developer
Dec 13, 2011 at 10:20 PM

OK, I needed to update 2 places instead of one.  Please update the solution with the latest wsp.

Dec 13, 2011 at 10:30 PM

Hi.  When I click on the "ok" button to download the zip with the WSP, the page returns "http://www.codeplex.com/site/invalidquerystring".

 

Thank you so much for your help!

Dec 16, 2011 at 6:41 PM

There are some other bugs that I found but I am going to create a new Issue.

 

Thanks!