Eservice Error with MSCRM VPC

Dec 17, 2008 at 11:08 AM
I am getting the following error when trying to access the Eportal with the autogenerated email link:  Any ideas?

Server Error in '/' Application.
--------------------------------------------------------------------------------

Keyword not supported: 'moss'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Keyword not supported: 'moss'.

Source Error:

Line 44:   _contactId = new Guid(plainText);
Line 45:   CreateUserWizard1.CreatedUser += new EventHandler(CreateUserWizard1_CreatedUser);
Line 46:   ProfileInfoCollection allProfiles = ProfileManager.GetAllProfiles(ProfileAuthenticationOption.Authenticated);
Line 47:   foreach (ProfileInfo profileInfo in allProfiles)
Line 48:   {
 

Source File: c:\Program Files\Microsoft Dynamics Crm Customer Portal\Controls\CreateUserAccount.ascx.cs    Line: 46

Stack Trace:

[ArgumentException: Keyword not supported: 'moss'.]
   System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +1481474
   System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +102
   System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +52
   System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24
   System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +125
   System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +56
   System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +4
   System.Data.SqlClient.SqlConnection..ctor(String connectionString) +21
   System.Web.DataAccess.SqlConnectionHolder..ctor(String connectionString) +40

[ArgumentException: An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax.
Parameter name: connectionString]
   System.Web.DataAccess.SqlConnectionHolder..ctor(String connectionString) +123
   System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +108
   System.Web.Profile.SqlProfileProvider.GetProfilesForQuery(SqlParameter[] args, ProfileAuthenticationOption authenticationOption, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) +930
   System.Web.Profile.SqlProfileProvider.GetAllProfiles(ProfileAuthenticationOption authenticationOption, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) +40
   System.Web.Profile.ProfileManager.GetAllProfiles(ProfileAuthenticationOption authenticationOption) +170
   Controls_CreateUserAccount.OnLoad(EventArgs e) in c:\Program Files\Microsoft Dynamics Crm Customer Portal\Controls\CreateUserAccount.ascx.cs:46
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

 

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

Dec 24, 2008 at 12:53 PM
I think there is something wrong in the SQLConnectionstring in your web.config of the portal.

This is how mine looks like:
<?xml version="1.0"?>
<configuration>
 <!-- Register a new config section-->
 <configSections>
  <section name="SmallBusinessDataProviders" type="SmallBusinessDataProvidersSection" requirePermission="false"/>
 </configSections>
 <!-- Connection string, currently configured for SQL Express-->
 <connectionStrings>
  <remove name="SQLConnectionString"/>
  <remove name="LocalSqlServer"/>
  <add name="SQLConnectionString" connectionString="Data Source=.\SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|SmallCompanyDB.mdf;user instance=true"/>
  <!--This setting is for the asp.net membership store db-->
  <add name="LocalSqlServer" connectionString="Server=localhost;Database=aspnetdb;integrated security=true;"/>
 </connectionStrings>
 <appSettings>
  <!--
  These settings are for the portal pages and controls to call the
  crm web services. If you are setting this up on the stndard vpc image then
  set the domain value to "." if you are having problems.
  -->
  <add key="msa.CRMOrganizationName" value="OrgName"/>
  <add key="msa.CRMServerUrl" value="http://localhost:5555/MSCRMServices"/>
  <add key="msa.CRMWebServicesUser" value="administrator"/>
  <add key="msa.CRMWebServicesPassword" value="Pass1234"/>
  <add key="msa.CRMDomain" value="DOMAIN"/>
 </appSettings>
 <!-- Register the providers and specify which ones to use for data access for each of the 4 pages-->
 <SmallBusinessDataProviders peopleProviderName="xmlProvider" testimonialsProviderName="xmlProvider" catalogProviderName="xmlProvider" newsProviderName="xmlProvider">
  <!-- Register providers for People - Similarly for other pages-->
  <PeopleProviders>
   <add name="sqlProvider" type="SqlPeopleProvider" connectionStringName="SQLConnectionString"/>
   <add name="xmlProvider" type="XmlPeopleProvider" schemaFile="People.xsd" dataFile="People.xml"/>
  </PeopleProviders>
  <TestimonialsProviders>
   <add name="sqlProvider" type="SqlTestimonialProvider" connectionStringName="SQLConnectionString"/>
   <add name="xmlProvider" type="XmlTestimonialProvider" schemaFile="Testimonials.xsd" dataFile="Testimonials.xml"/>
  </TestimonialsProviders>
  <CatalogProviders>
   <add name="sqlProvider" type="SqlCatalogProvider" connectionStringName="SQLConnectionString"/>
   <add name="xmlProvider" type="XmlCatalogProvider" schemaFile="Items.xsd" dataFile="Items.xml"/>
  </CatalogProviders>
  <NewsProviders>
   <add name="sqlProvider" type="SqlNewsProvider" connectionStringName="SQLConnectionString"/>
   <add name="xmlProvider" type="XmlNewsProvider" schemaFile="News.xsd" dataFile="News.xml"/>
  </NewsProviders>
 </SmallBusinessDataProviders>
  <system.net>
 <!--These mail settings are used if the send kb setting is set to SMTP-->
    <mailSettings>
      <smtp from="administrator@domain.com" deliveryMethod="Network">
        <network host="localhost" port="25" />
      </smtp>
    </mailSettings>
  </system.net>
  <system.web>
  <globalization culture="auto" uiCulture="auto" enableClientBasedCulture="true"/>
  <profile>
   <properties>
    <add name="ContactId" allowAnonymous="false" type="System.Guid"/>
   </properties>
  </profile>
  <identity impersonate="true"/>
  <authentication mode="Forms">
   <forms loginUrl="CustomerLogin.aspx"/>
  </authentication>
  <customErrors mode="Off" />
  <pages theme="Standard">
   <!--This registers the user controls fr use in the web portal-->
   <controls>
    <add tagPrefix="msa" tagName="NotesEditor" src="~/Controls/NotesEditor.ascx" />
    <add tagPrefix="msa" tagName="CasesGrid" src="~/Controls/CasesGrid.ascx" />
    <add tagPrefix="msa" tagName="CaseEditor" src="~/Controls/CaseEditor.ascx" />
    <add tagPrefix="msa" tagName="KBSearch" src="~/Controls/KBSearch.ascx" />
    <add tagPrefix="msa" tagName="NewEntity" src="~/Controls/NewEntity.ascx" />
    <add tagPrefix="msa" tagName="ViewKBArticle" src="~/Controls/ViewKBArticle.ascx" />
    <add tagPrefix="msa" tagName="ServiceScheduler" src="~/Controls/ServiceScheduler.ascx" />
    <add tagPrefix="msa" tagName="ScheduledServicesGrid" src="~/Controls/ScheduledServicesGrid.ascx" />
    <add tagPrefix="msa" tagName="ProfileEditor" src="~/Controls/ProfileEditor.ascx" />
    <add tagPrefix="msa" tagName="CreateUserAccount" src="~/Controls/CreateUserAccount.ascx" />
    <add tagPrefix="msa" tagName="Login" src="~/Controls/LoginControl.ascx" />
   </controls>
  </pages>  
  <httpHandlers>
   <remove verb="*" path="*.asmx"/>
  </httpHandlers>
  <compilation debug="true"/></system.web>
 <system.codedom>
 </system.codedom>
 <system.webServer>
  <validation validateIntegratedModeConfiguration="false"/>
  <modules>
   <remove name="ScriptModule"/>
  </modules>
  <handlers>
   <remove name="WebServiceHandlerFactory-Integrated"/>
   <remove name="ScriptHandlerFactory"/>
   <remove name="ScriptHandlerFactoryAppServices"/>
   <remove name="ScriptResource"/>
  </handlers>
 </system.webServer>
 <location path="eService" >
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location> 
</configuration>