Sync: manual works, auto doesn't

Dec 1, 2009 at 7:47 PM

My slam.config validated without any apparent error.  Also, activation and the initial manual synchronization proceeded without apparent errors.  Everything seemed fine until a new item hit the list.  The new item was not added to the slam database table.  Here is the only error I found, in the server application event log:

System.NullReferenceException: Object reference not set to an instance of an object.

at AWS.SLAM.StructureMap.XmlTypeProfileSection.GetTypeProfileName(String siteCollection, String site, String id, String typeName)

at AWS.SLAM.StructureMap.ComponentFactory.GetInstance[T](String siteCollection, String site, String id, String typeName)

at AWS.SLAM.ComponentService.GetInstance[T](String siteCollection, String site, String id, String typeName)

at AWS.SLAM.ListItemEventManager.<>c__DisplayClass4.<ItemAdded>b__0()

at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)

at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()

at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)

at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)

at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)

at AWS.SLAM.ListItemEventManager.ItemAdded(SPItemEventProperties properties)

 

Any ideas about what is happening here would be much appreciated.

Developer
Dec 4, 2009 at 7:08 PM

Do you have a TypeProfiles section defined at all in your slam.config?  If not, does the version on the SLAM Control Panel say 1.2.0.7?

Dec 7, 2009 at 1:44 PM

There are no TypeProfiles in the slam.config file.  SLAM Control Panel says Version: 1.2.0.6

I was, however, able to get auto sync to work finally, by adding in a SiteCollection parameter.

John E Egan

Systems Administrator/Developer

Informatics and Development

Division of Informatics and Information Technology

New York City Department of Health and Mental Hygiene

22 Cortlandt Street, 28th Floor, CN 1

New York, NY 10007

212-313-5129

From: brjenkins [mailto:notifications@codeplex.com]
Sent: Friday, December 04, 2009 2:09 PM
To: John Egan
Subject: Re: Sync: manual works, auto doesn't [SLAM:76747]

From: brjenkins

Do you have a TypeProfiles section defined at all in your slam.config? If not, does the version on the SLAM Control Panel say 1.2.0.7?

Read the full discussion online.

To add a post to this discussion, reply to this email (SLAM@discussions.codeplex.com)

To start a new discussion for this project, email SLAM@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

**********************************************************************
The New York City Department of Health & Mental Hygiene is now offering information important for the health of all New Yorkers.  To sign up for these new and valuable updates, log-on to our website at http://www.nyc.gov/health/email and select the NYC DOHMH updates you'd like to receive.
IMPORTANT NOTICE:  This email is meant only for the use of the intended recipient.  It may contain confidential information that is legally privileged or otherwise protected by law.  If you have received this communication in error, please notify me immediately by replying to this message and please delete it from your computer.  Thank you for your cooperation.
Mar 2, 2010 at 10:33 AM

I have the same issue can you tell me who you solve it and what you mean by sitecollection parameter.

Thank you,

Mar 2, 2010 at 1:45 PM

I modified the slam.config file to include the SiteCollection="sites/MTDT" parameter in the DataMapping section, which fixed the broken sync issue:

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

<Configuration>

  <ConnectionStrings Default="SLAM">

    <add Name="SLAM" ConnectionString="Database=SLAM;Data Source=spserver\spsql;User Id=useidr;Password=password" />

  </ConnectionStrings>

  <DataMapping DataSchema="SLAM" SiteCollection="sites/MTDT">

    <List Name="Blackberry Requests" ActivationOrder="1">

      <Fields>

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

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

                                <Field Name="Address" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                <Field Name="Question 1" SqlType="varchar(255)" SPType="Choice" Required="false"></Field>

                                <Field Name="Question 2" SqlType="varchar(255)" SPType="Choice" Required="false"></Field>

                                <Field Name="Question 3" SqlType="varchar(255)" SPType="Choice" Required="false"></Field>

                                <Field Name="Question 4" SqlType="varchar(255)" SPType="Choice" Required="false"></Field>

                                <Field Name="Current Phone No" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                <Field Name="Question 5" SqlType="varchar(255)" SPType="Choice" Required="false"></Field>

                                <Field Name="Question 6" SqlType="varchar(255)" SPType="Choice" Required="false"></Field>

                                <Field Name="DataFeature" SqlType="varchar(255)" SPType="Yes/No" Required="false"></Field>

                                <Field Name="TetheringFeature" SqlType="varchar(255)" SPType="Yes/No" Required="false"></Field>

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

                                <Field Name="Division" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                <Field Name="Bureau" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                <Field Name="Email" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                <Field Name="CreatedDate" SqlType="datetime" SPType="DateTime" Required="false"></Field>

                                <Field Name="CompletedDate" SqlType="datetime" SPType="DateTime" Required="false"></Field>

                                <Field Name="WF_Result" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                <Field Name="Activation Date" SqlType="datetime" SPType="DateTime" Required="false"></Field>

                                <Field Name="New Cell Phone" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                  </Fields>

    </List>

                  <List Name="BlackberryRequests" TableName="BlackberryReqFormLib" ActivationOrder="1">

                                  <Fields>

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

                                                  <Field Name="JobTitle" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="OfficeAddress" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Requester" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Division" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Bureau" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="RequesterEmail" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Created" SqlType="datetime" SPType="DateTime" Required="false"></Field>

                                                  <Field Name="Modified" SqlType="datetime" SPType="DateTime" Required="false"></Field>

                                                  <Field Name="Blackberry WFv2" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Modified By" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="DC_Comment" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                  </Fields>

                  </List>

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

                                  <Fields>

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

                                                  <Field Name="AssistantComissionerApproval" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="AssistantCommissioner" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="WorkPhone" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="WebPageChangeRequestWF2" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="WebPagechangeRequestWF3" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Requestor" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Division" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Bureau" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Office" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="Created" SqlType="datetime" SPType="DateTime" Required="false"></Field>

                                                  <Field Name="Modified" SqlType="datetime" SPType="DateTime" Required="false"></Field>

                                                  <Field Name="Modified By" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="OnlineReviewStaff" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="OnlineEditor" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                                  <Field Name="OnlineEditorApproval" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

                                  </Fields>

                  </List>

  </DataMapping>

               

</Configuration>

**********************************************************************
The New York City Department of Health & Mental Hygiene is now offering information important for the health of all New Yorkers.  To sign up for these new and valuable updates, log-on to our website at http://www.nyc.gov/health/email and select the NYC DOHMH updates you'd like to receive.
IMPORTANT NOTICE:  This email is meant only for the use of the intended recipient.  It may contain confidential information that is legally privileged or otherwise protected by law.  If you have received this communication in error, please notify me immediately by replying to this message and please delete it from your computer.  Thank you for your cooperation.
Jan 26, 2011 at 2:04 PM

Hi

I have the same problem.

However I am not sure what to write for SiteCollection="".

I have this local url-add for the web application: http://sharepoint-demo

and has only a root site collection: "/"

the external web add is http://spdemo.maqis.dk

I have tried all 3, the IP address and http://localhost...

Do you have any suggestions?

Thanks!