using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using FormOA;
public partial class _Default : System.Web.UI.Page
{
string ViewType = "";
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.QueryString["n"].Length > 0)
{
ViewType = Request.QueryString["n"].ToString();
GetTickets();
}
}
catch
{
}
}
private void GetTickets()
{
string orgid = "XXX";
FormOA.CommenceDB CommenceData = new FormOA.CommenceDB();
int mode = 0;
int flags = 0;
string search = "Closed";
string search2 = "Not Equal to";
string CMview = "Ticket";
string BuildTheTickets = "";
if (ViewType == "Closed")
{
search = "Closed";
search2 = "Equal to";
}
if (ViewType == "Open")
{
search = "Closed";
search2 = "Not Equal to";
}
if (ViewType == "All")
{
search = "Pending RMA";
search2 = "Not Equal to";
}
FormOA.ICommenceCursor MyCommenceCursor;
try
{
MyCommenceCursor = CommenceData.GetCursor(mode, CMview, flags);
MyCommenceCursor.SetFilter("[ViewFilter(1,F,,Status, " + search2 + ", " + search + ")]", 0);
string s2 = @"[ViewFilter(2,CTCF,, Relates to, Account, accountKey, Contains, """ + orgid + @""",)]";
MyCommenceCursor.SetFilter(s2, 0);
//MyCommenceCursor.SetFilter("[ViewFilter(2,CTCF,, Relates To, Account, accountKey, Equal To, " + orgid + ",)]", 0);
MyCommenceCursor.SetSort("[ViewSort(Refers To Applications, ascending)]", 0);
MyCommenceCursor.SetRelatedColumn(0, "Relates To", "Account", "Ticker", 0);
MyCommenceCursor.SetColumn(1, "ticketKey", 0);
MyCommenceCursor.SetColumn(2, "dateNew", 0);
MyCommenceCursor.SetColumn(3, "Problem", 0);
MyCommenceCursor.SetRelatedColumn(4, "Relates To", "Account", "accountKey", 0);
MyCommenceCursor.SetColumn(5, "Status", 0);
MyCommenceCursor.SetColumn(6, "Source", 0);
MyCommenceCursor.SetRelatedColumn(7, "Relates To", "Employee", "properName", 0);
MyCommenceCursor.SetRelatedColumn(8, "Relates To", "Contact", "properName", 0);
MyCommenceCursor.SetColumn(9, "Resolution", 0);
MyCommenceCursor.SetColumn(10, "Refers To Applications", 0);
int RowCount = MyCommenceCursor.RowCount;
FormOA.ICommenceQueryRowSet ars = MyCommenceCursor.GetQueryRowSet(RowCount, 0);
}
}
ars = null;
MyCommenceCursor = null;
CommenceData = null;
}
catch (Exception Ex)
{
}
}
}
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
by: alimuPosted on 2009-10-08 at 19:53:30ID: 25532052
In Visual Studio because it's not really launching as part of a website, it's probably all executing under your credentials (which I'd guess are a member of the Administrators group on the local machine).
Administrators will have launch and activation permissions by default.
Going from the error you're seeing in Event Viewer, you should be going to the object in Component Services --> DCOM Config -->"Object Name".
Right Click on it --> properties --> Security Tab.
Under "Launch and Activation Permissions" select "Customize" and click on the Edit button.
Add <servername>\ASPNET to the list and make sure "Local Activation" is allowed.
If you're still having issues, go back and check the event log again.
You'll probably have to unload/kill remaining processes from your .NET application before testing the change to force a restart of the application and so that the changes take effect. (This is different to an IISRESET)
Additional note: your website files and anything done using standard html or asp code will use the IUSR_computername account if you are using anonymous BUT your .NET code will still be executing using the aspnet account (think of it as a distinct application within an application).. Sidenote: I'm not a developer and will probably not be able to assist with coding related issues.
If still having problems, could you please post your current Launch and Activation permissions and any errors that are still showing up in the event log when you try to kick this off.