Re: XML from URL Causes Internal Server Error (500) - C# Discussion Boards

turbosupramk321-Dec-11 9:08

turbosupramk3

21-Dec-11 9:08

Hi,

Thanks for the reply. That'd be great, but they are not programs I wrote and have to use human interaction, so I have to have them run under a logged in session.

fjdiewornncalwe21-Dec-11 9:48

fjdiewornncalwe

21-Dec-11 9:48

If it requires human interaction and such, then why is it being run on the server? Why can it not be run from your local computer? You have the credentials, so it shouldn't be access to the server for data that is an issue.

I wasn't, now I am, then I won't be anymore.

turbosupramk321-Dec-11 10:01

turbosupramk3

21-Dec-11 10:01

Thanks for the reply, there is no trust between the domains.

If there are any more questions about why it can't be done a different way, I will answer them all with one answer and say that this is the way I would prefer to do it, so the thread isn't derailed.

There has to be a way to prevent this, has anyone ever written code to do that?

Dave Kreskowiak21-Dec-11 10:22

Dave Kreskowiak

21-Dec-11 10:22

There is no system event for this, as you call it.

There is also no way for you to prevent being kicked off. If another admin wants to boot you off, there's nothing you can do to stop it.

The only solution I can come up with to your problem is to build, in the other domain, a virtual server dedicated to you so nobody will touch it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

turbosupramk321-Dec-11 10:45

turbosupramk3

21-Dec-11 10:45

Thanks Dave

You are right, I may have to move this from integration to my own private lab Frown | :(

XML from URL Causes Internal Server Error (500)

jschell22-Dec-11 8:15

jschell

22-Dec-11 8:15

Restating the problem since I got confused.

You have an APP - call it A.
You want to run A on box Z and it takes a while. So while it is running you are not paying attention to Z.

Then another user comes along and logs into Z, which terminates your user session and terminates A.

So possible solutions.
1. Pretty sure another log in will already tell you that someone else is there. So you want an additional message to pop. And I am pretty sure that to have that pop during log in is going to require some very specific internal windows code. Not just a random app. And in terms of complexity and intrusiveness (including security) it is much higher than a windows service.
2. Create a windows service to run it - specific to the App.
3. Use the windows scheduler to run it.
4. Create a generic windows service, basically like 3, that allows you to run a task (like scheduler). More code than 2/3, but less complex to use.
5. Send an email telling people not to log in to the box.

For items 2/3/4 there is complexity in dealing with user input. For console IO you can use IO redirects. Either via cmd or via Process class. For a GUI it is certain to be more complicated since I would suspect you would need to intercept everything. Certainly something is possible since "Remote Desktop Connection" works.

turbosupramk3 wrote:
I'm in a large organization,

Why not just have a virtual box and it is 'yours' so no one just randomly logs in?

Enochs21-Dec-11 5:41

Enochs

21-Dec-11 5:41

I use a web based look-up service to obtain detailed information on IP addresses. It works great until the service goes down and the URL fails to render proper XML.

The error (when the service is down) occurs on the "xDoc = XDocument.Load(url)" statement but does NOT throw an XmlException that I can catch...instead the server (I use a host) locks up with an internal (500) error. Since this error is from the server and not my application, I get no stack trace.

All of my XML validation methods are predicated on the fact that I have the XDocument loaded first....then validate against an XML schema. But it's the load that fails so I have no chance to validate the XML. Any Ideas?

string url = String.Format("http://www.ipgp.net/api/xml/{0}/{1}", sourceIP, password);
try
{   /* This returns an internal server
     * error (500) if the url fails to 
     * render proper xml. No error 
     * gets thrown.  */
     xDoc = XDocument.Load(url);
}
catch (XmlException ex)
{
    /* This is a safe xml document
     * that I would like to load if
     * the load fails.  */
     xDoc = XDocument.Load(safe);
}

UPDATE:
I figured out this UGLY hack to get around the problem for now. The following code first reads the webpage into a variable and then checks the variable for an XML tag that I know should be present. If XML tag can't be found then my default (safe) xml loads. I hope someone can PLEASE give me a better fix...thanks

HttpWebRequest myRequest =(HttpWebRequest)WebRequest.Create(url);
myRequest.Method = "GET";
WebResponse myResponse = myRequest.GetResponse();
StreamReader sr = new StreamReader(myResponse.GetResponseStream(), System.Text.Encoding.UTF8); 
string result = sr.ReadToEnd();
sr.Close();
myResponse.Close();          
            
if (ExactMatch(result, "<Country>"))
   xDoc = XDocument.Load(url);
else
   xDoc = XDocument.Load(Safe);

modified 21-Dec-11 18:13pm.

Re: XML from URL Causes Internal Server Error (500)

fjdiewornncalwe21-Dec-11 7:10

fjdiewornncalwe

21-Dec-11 7:10

To see what is going on, you could just load the document from the url into a string first so that you can see if it is an issue with the request or response first. Once you have the string you just need to parse it into your XmlDocument. It adds a line of code, but it makes debugging and viewing your variables much easier.

I wasn't, now I am, then I won't be anymore.

Re: XML from URL Causes Internal Server Error (500)

Enochs21-Dec-11 9:02

Enochs

21-Dec-11 9:02

That is what my "Ugly Hack" that I posted does. Using 7 lines of code, it reads the XML into a string and looks at that string before deciding if the XML is to be loaded. Just seems like a terrible waste of time/resources. I don't understand why it doesn't simple kick out an XmlException as the documentation says it should. The server 500 error gets me every time.

Thanks for responding.

Re: XML from URL Causes Internal Server Error (500)

fjdiewornncalwe21-Dec-11 9:08

fjdiewornncalwe

21-Dec-11 9:08

My hunch is that the error isn't coming from your own code. Are you running this code in a web application? If so, then maybe, but if your application isn't a web application then the likely source of the 500 error is the site you are trying to hit. If the source site is working properly when you enter your full url into a browser, then you may have an issue with how your url is constructed as well.

I wasn't, now I am, then I won't be anymore.

Re: XML from URL Causes Internal Server Error (500)

Enochs21-Dec-11 12:07

Enochs

21-Dec-11 12:07

Yes, my site is an asp.net web application. The error occurs anytime I try to load something using XDocument.load() that isn't in proper XML format. Wrapping it in a try block like I show above does no good. You can't validate the XML against an XML schema util you have it loaded...kind of a catch 22 in my case. I don't like the idea that XDocument(url) can stop my web-application from functioning (internal 500 error). The error does not come from my web-app code, it comes from the server running my web-application anytime I try to load fouled-up XML.

My hack has it working for now but I am certain that I am overlooking something simple. I guess if there were a simple fix, someone would have posted it by now.

Thanks again,

modified 21-Dec-11 18:20pm.

Re: XML from URL Causes Internal Server Error (500)

jschell22-Dec-11 8:20

jschell

22-Dec-11 8:20

Enochs wrote:
catch (XmlException ex)

What makes you think that that is the only possible exception that can be thrown? If another exception is thrown then it is going to result in some error response to the client (which is what you are seeing.)

Also maybe your url in the catch is failing.

Also shouldn't you log something if it fails?

modified 23-Dec-11 15:55pm.

Issues of Making MS-Access Schema

Rajesh Singh00721-Dec-11 3:19

Rajesh Singh007

21-Dec-11 3:19

Hello Everyone,
Actually I am facing one problem, please help me...

How to create schema in ms-access database using C# code?

Thanks in advance!!

Luc Pattyn21-Dec-11 3:47

Luc Pattyn

21-Dec-11 3:47

Your question isn't very clear to me, however this[^] could be the answer.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Rajesh Singh00721-Dec-11 4:06

Rajesh Singh007

21-Dec-11 4:06

Actually I want to create ms-access database with some schema name with the help of c# code.

Luc Pattyn21-Dec-11 4:21

Luc Pattyn

21-Dec-11 4:21

Sorry, can't help you there; I have been using both Access and SQLServer, but always migrating away from Access, never creating one.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

riced21-Dec-11 11:31

riced

21-Dec-11 11:31

Using Interop you should be able to do this. That assumes you know how to create databases, tables etc using Access objects. You might be able to do it running SQL queries in Access - again assuming you know the required SQL. You can pick up some of it in the Access designer for queries - just create a make table one then switch to SQL view.

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.

Wrong Target set in Desktop shortcut

SilimSayo22-Dec-11 13:09

SilimSayo

22-Dec-11 13:09

Here is my suggestion. IF you have a copy of access, use it create the tables and views that you need. After doing that, you can write your C# application to use the Access database. I think you will find it a lot easier to create the database within MS Access that try to create it using C#.

iamdking21-Dec-11 0:57

21-Dec-11 0:57

Hi all,
I have created setup for my program . This setup creates shortcut icon on my desktop. But this icon have wrong target set. Target shown is 'MyInstaller' ( where 'MyInstaller' is deployment project name ). When I check other shortcuts available on my desktop, I found Target is set to '"C:\Program Files\Beyond Compare 3\BCompare.exe"' (for example). Why all the shortcuts created by me do not have such target? I wanted to use the target to process my documents.
Do I miss some settings here?
Thanks in advance !!

Amit

Richard MacCutchan21-Dec-11 3:06

Richard MacCutchan

21-Dec-11 3:06

Show the code you use to create the shortcut, there is probably something wrong in it.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

iamdking21-Dec-11 19:24

21-Dec-11 19:24

Hi Richard,
Thanks for the reply.
I haven't write any code for this. I followed below steps 1) add 'Setup Project' to the solution. 2) right click on Project, select 'View' => 'file system' 3) add 'primary output' to the Application Folder 4) create shortcut by right clicking on the primary output file 5) move this shortcut to the 'User's Desktop' folder Any idea how this can be handled?

Amit

Richard MacCutchan21-Dec-11 21:56

Richard MacCutchan

21-Dec-11 21:56

Sorry, I have not used this process so cannot offer any suggestions, other than to suggest you check carefully that each step is referring to the correct object.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

iamdking21-Dec-11 23:56

21-Dec-11 23:56

ok...do you have any example of 'using Installer class' for deploying windows projects? or any other way for installation process?

Amit

Richard MacCutchan22-Dec-11 0:55

Richard MacCutchan

22-Dec-11 0:55

iamdking wrote:
do you have any example

I'm afraid not, that's why I said "cannot offer any suggestions". However, you could try a Google search for 'using Installer class' and see what that comes up with.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

iamdking22-Dec-11 3:09