Invalid object name 'dbo.Stores' ?

Jun 16, 2009 at 12:14 PM

Hi anrea,

with 3.6.0.0 release, I get this error  (" Invalid object name 'dbo.Stores' ") NetSqlAzman generic exception when I run checkaccess method . I tried it with netSqlAzman manager console checkAccess test utility and it gives same error.

 

Jun 16, 2009 at 1:11 PM

Hi,

as indicated in the Download Notes (large font) … you must upgrade your Database schema before.

I have renamed all the database objects (netsqlazman_ prefix added).

Regards,

Andrea.

__________________________________
Andrea Ferendeles
NetSqlAzMan - Project Coordinator

http://netsqlazman.codeplex.com

Jun 16, 2009 at 1:38 PM

I know.. I installed new database.. even created new items, users, etc.  and tested in this condition. I will check it again now.

Jun 16, 2009 at 2:10 PM

this error (" Invalid object name 'dbo.Stores' ") is reported by mistake.  But I think there is another error when I debugged 3.6.0.0 source.

In SqlAzmanStorage.InternalCheckAccess() method, it s trying to invoke "DirectCheckAccess" Stored Proc. While it must me "netSqlAzman_DirectCheckAccess"

method is like below ..

 

private AuthorizationType internalCheckAccess(string StoreName, string ApplicationName, string ItemName, IAzManDBUser dbUser, DateTime ValidFor, bool OperationsOnly, bool retrieveAttributes, out List<KeyValuePair<string, string>> attributes, params KeyValuePair<string, object>[] contextParameters)
        {
            int userGroupsCount = 0;
            SqlConnection conn = new SqlConnection(this.db.Connection.ConnectionString);
            conn.Open();
            System.Data.SqlClient.SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "DirectCheckAccess";
            cmd.CommandType = CommandType.StoredProcedure;

 

 

Jun 16, 2009 at 3:19 PM

Congratulations ... you have found the first bug release 3.6.0.0.  J

I fix it now.

Do you need a beta that fixed the problem ?

Regards,

Andrea.

__________________________________
Andrea Ferendeles
NetSqlAzMan - Project Coordinator

http://netsqlazman.codeplex.com

Jun 16, 2009 at 3:34 PM

thanks.. I m building here, using unsigned version.

 

Jun 16, 2009 at 3:35 PM

Ok.

Thanks for you feedback.

Fixed source code is also available and checked in.

__________________________________
Andrea Ferendeles
NetSqlAzMan - Project Coordinator

http://netsqlazman.codeplex.com

Jun 17, 2009 at 2:36 PM

Hi,

I have published now the 3.6.0.1 release that fix this issue.

Regards,
Andrea.

Aug 14, 2009 at 7:38 PM

I have similar issue on v3.5.1.1 on SqlAzManStorage.GetStore(string).

 

Suggestion?

Aug 14, 2009 at 9:16 PM

Yes … upgrade to the latest NetSqlAzMan release.