membership provider

membership provider

Postby PeterL » Fri 05 Dec 2014 16:52

hello. currently trying to convert and exist site from MS SQL to Oracle and devart was recommend to me. on convertion i get the following when trying to login on my site

ORA-00942: table or view does not exist



[OracleException (0x80004005): ORA-00942: table or view does not exist]
Devart.Data.Oracle.cc.d() +1518
Devart.Data.Oracle.bu.m() +95
Devart.Data.Oracle.bu.a() +2942
Devart.Data.Oracle.l.a(Int32 A_0, ci A_1) +4465
Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) +4113
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) +1182
Devart.Common.DbCommandBase.ExecuteScalar() +28
Devart.Common.Web.Providers.DbExtendedMembershipProvider.a(DbDatabaseManager A_0, String A_1) +325
Devart.Common.Web.Providers.DbExtendedMembershipProvider.b(DbDatabaseManager A_0, String A_1, Boolean A_2) +31
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +164

[ProviderException: Error validating user]
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +549
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +105
System.Web.UI.WebControls.Login.AttemptLogin() +160
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +93
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804


I have the devart version 8.4.293.4

I have run the scripts provided by devart to create oracle tables but would like to use existing ones if possible.

web.config
Code: Select all
<roleManager enabled="true" defaultProvider="OracleExtendedRoleProvider" cacheRolesInCookie="true" cookieName=".localV4AdminWibbleEURoles" cookieTimeout="7200" cookiePath="/"
                 cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="All" createPersistentCookie="false" maxCachedResults="25">
      <providers>
        <clear />
        <remove name="OracleExtendedRoleProvider"/>
        <add connectionStringName="OracleAdminConnection" name="OracleExtendedRoleProvider" type="Devart.Data.Oracle.Web.Providers.OracleExtendedRoleProvider, Devart.Data.Oracle.Web, Version=8.4.293.4, Culture=neutral, PublicKeyToken=09af7300eec23701" useridcolumn="UserId" usernamecolumn="UserName" usertablename="ORA_ASPNET_USERS" />
        <!--<add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" />-->
      </providers>
    </roleManager>
    <profile enabled="true" defaultProvider="TableProfileProvider" inherits="Wibble.Common.Admin.ProfileCommon, Wibble.Common.Admin">
      <providers>
        <clear />
      <add name="TableProfileProvider" type="Wibble.Common.Admin.SqlTableProfileProvider, Wibble.Common.Admin" connectionStringName="OracleAdminConnection" table="PCS_CRM_AdminProfile" applicationName="WibbleEuropeAdministration" />       
      </providers>
    </profile>
    <membership defaultProvider="OracleExtendedMembershipProvider">
      <providers>
        <clear />
        <remove name="OracleExtendedMembershipProvider"/>
        <add name="OracleExtendedMembershipProvider" type="Devart.Data.Oracle.Web.Providers.OracleExtendedMembershipProvider, Devart.Data.Oracle.Web, Version=8.4.293.4, Culture=neutral,  PublicKeyToken=09af7300eec23701"
             connectionStringName="OracleAdminConnection" applicationName="WibbleEuropeAdministration"
             enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="true"
      passwordFormat="Hashed" maxInvalidPasswordAttempts="4" minRequiredPasswordLength="9" passwordAttemptWindow="8" useridcolumn="UserId" usernamecolumn="UserName" usertablename="ORA_ASPNET_USERS" />       
      </providers>
    </membership>
PeterL
 
Posts: 2
Joined: Fri 05 Dec 2014 16:46

Re: membership provider

Postby Shalex » Mon 08 Dec 2014 12:00

PeterL wrote:[OracleException (0x80004005): ORA-00942: table or view does not exist]
Devart.Data.Oracle.cc.d() +1518
...

Please run the dbMonitor tool (documentation, download link) and specify the exact SQL statement which fails to execute.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: membership provider

Postby PeterL » Tue 09 Dec 2014 12:01

Thanks. Found the misspelt table.

now on to the next error on login

[InvalidCastException: Unable to cast object of type 'System.Byte[]' to type 'System.IConvertible'.]
System.Convert.ToInt32(Object value) +24
Devart.Common.Web.Providers.DbExtendedMembershipProvider.a(DbDatabaseManager A_0, String A_1) +363
Devart.Common.Web.Providers.DbExtendedMembershipProvider.b(DbDatabaseManager A_0, String A_1, Boolean A_2) +31
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +164

[ProviderException: Error validating user]
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +549
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +105
System.Web.UI.WebControls.Login.AttemptLogin() +160
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +93
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804
PeterL
 
Posts: 2
Joined: Fri 05 Dec 2014 16:46

Re: membership provider

Postby Shalex » Tue 09 Dec 2014 15:17

Please give us an additional information:
1) according to your *.config you are using Devart.Data.Oracle.Web.dll with *.4 revision number. Try running your application with standard tables supplied with provider in C:\Program Files (x86)\Devart\dotConnect\Oracle\Web\ASP.NET 4\InstallExtendedWebTables.sql . Does it work?
2) specify the datatypes of the UserId and UserName columns in your ORA_ASPNET_USERS table
3) are there any errors in dbMonitor logs?
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle