6/30/2025 9:29:00 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
I REALLY NEED HELP! DB_SEC_E_AUTH_FAILED 
Posted: 16 Apr 10 11:54 AM
|
We are experiencing problems with a Web SLX installation. It is throwing this error. When the users sees the error, they only need to press the "back" button of the explorer and can continue working.
There are only 25 users workings, and the error is consistently at time intervals from 3 to 15 minutes. all the day.
The error:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 4/16/2010 11:07:45 AM
Event time (UTC): 4/16/2010 4:07:45 PM
Event ID: 709edac0a24743129afc78c585c88d0f
Event sequence: 30915
Event occurrence: 62
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/3/Root/slxclient-1-129158513784375000
Trust level: Full
Application Virtual Path: /slxclient
Application Path: C:\Inetpub\wwwroot\slxclient\
Machine name: SERVERCASHFLOW
Process information:
Process ID: 3636
Process name: aspnet_wp.exe
Account name: SERVERCASHFLOW\ASPNET
Exception information:
Exception type: OleDbException
Exception message: No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D).
Request information:
Request URL: http://192.168.64.133:3333/slxclient/ACCOUNT.ASPX?modeid=list
Request path: /slxclient/ACCOUNT.ASPX
User host address: 192.168.35.144
User: mcalderon
Is authenticated: True
Authentication Type: Forms
Thread account name: SERVERCASHFLOW\ASPNET
Thread information:
Thread ID: 14
Thread account name: SERVERCASHFLOW\ASPNET
Is impersonating: False
Stack trace: at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.WebControls.SqlDataSource.Select(DataSourceSelectArguments arguments)
at SmartParts_Account_AccountControl.Page_PreRender(Object sender, EventArgs e) in c:\Inetpub\wwwroot\slxclient\SmartParts\Account\AccountControl.ascx.cs:line 128
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnPreRender(EventArgs e)
at Sage.Platform.WebPortal.SmartParts.EntityBoundSmartPart.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) |
|
|
|
Re: I REALLY NEED HELP! DB_SEC_E_AUTH_FAILED
Posted: 29 Apr 10 7:43 AM
|
The code in the page described at AccountControl.ascx.cs line 128 is ok, let me show it:
String constring = service.GetConnection().ConnectionString.ToString();
SqlDataSource dsMyD = new SqlDataSource();
dsMyD.ProviderName = "System.Data.OleDb";
dsMyDataSource.ConnectionString = constring;
string sqlCmp = "SELECT C.CAMPAIGNID,C.CAMPAIGNNAME FROM CAMPAIGN C inner join campaigntarget T on C.CAMPAIGNID=T.CAMPAIGNID INNER JOIN CONTACT O ON
T.ENTITYID=O.CONTACTID INNER JOIN ACCOUNT A ON O.ACCOUNTID = A.ACCOUNTID INNER JOIN SECCODEJOINS SCC_JO ON (C.TARGETAUDIENCELOCATION=SCC_JO.parentseccodeid)
INNER JOIN SECRIGHTS SCC_DE ON (SCC_DE.seccodeid= scc_jo.childseccodeid AND scc_de.accessid='" + userService.GetUser().Id.ToString().Trim() + "') WHERE C.STATUS='Active' AND C.CAMPAIGNID<>'Q6UJ9A00T4TA' AND C.CAMPAIGNID<>'Q6UJ9A003IF9' AND (A.ESTADOPROGRAMAR<>'2' OR nvl(A.ESTADOPROGRAMAR,'NUL')='NUL') GROUP BY C.CAMPAIGNID, C.CAMPAIGNNAME";
dsMyD.DataSourceMode = System.Web.UI.WebControls.SqlDataSourceMode.DataReader;
dsMyD.SelectCommand = sqlCmp;
System.Data.OleDb.OleDbDataReader readerc;
readerc = (System.Data.OleDb.OleDbDataReader)dsMyD.Select(DataSourceSelectArguments.Empty);
if (this.dpCampaign.Items.Count == 0)
{
while (readerc.Read())
{
this.dpCampaign.Items.Add(new ListItem(readerc["CAMPAIGNNAME"].ToString(), readerc["CAMPAIGNID"].ToString()));
}
string strIDs = Request["ZCMPID"];
if (!string.IsNullOrEmpty(strIDs))
{
this.dpCampaign.SelectedValue = strIDs;
}
}
dsMyD.SelectCommand = "SELECT COUNT(T.CAMPAIGNTARGETID) ENESTA FROM CAMPAIGN C inner join campaigntarget T on C.CAMPAIGNID=T.CAMPAIGNID INNER JOIN CONTACT O ON T.ENTITYID=O.CONTACTID INNER JOIN ACCOUNT A ON O.ACCOUNTID = A.ACCOUNTID WHERE C.CAMPAIGNID='" + this.dpCampaign.SelectedValue.ToString() + "'";
readerc = (System.Data.OleDb.OleDbDataReader)dsMyD.Select(DataSourceSelectArguments.Empty); **** LINE 128
while (readerc.Read())
{
this.TextBox1.Text =readerc["ENESTA"].ToString();
}
This works fine, but when there are 10 or more users running the form with the avobe code, the asp start to fail on different lines where the page try to read from the SLX OLEDB Provider.
I think this reader losses its connectionstring between reads but only when more than 1 user is accessing the application.
I changed the code to only call the datasource 1 time and changed the connectionstring assignment to avoid problems with the " caracter:
ds.ConnectionString = service.GetConnectionString().Replace("\"","'").ToString(); |
|
|
| |
|
Re: I REALLY NEED HELP! DB_SEC_E_AUTH_FAILED
Posted: 07 May 10 1:12 PM
|
Ok, the form was taking all the SLX licences.
I assume, the way i'm making the connection is not the proper way.
I have 3 smartparts that loads when account is in detail mode. What's the better way to connect to the DB? |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|