I habe a problem with mein C# programm and mein trigger postgresql

Question

0.00/5 (No votes)

See more:

Hello, I have a program that should be used by several people and access the data with postgrelsql (NpgsqlCommand). When it comes to implementation, the program runs super well, but after installation, the program crashes for no reason.
There is also a trigger that does not work for all cases.
Could you please help me

What I have tried:

i have debbuging mein Pramm but not success

Posted 6-Mar-20 1:58am

Member 14655281

Updated 6-Mar-20 3:55am

Add a Solution

Comments

Richard Deeming 6-Mar-20 8:04am

We can't help you fix an error that we can't see in code that we also can't see.

You need to debug your program to find out what the problem is. If you're completely stuck, then click the green "Improve question" link and update your question to include the relevant parts of your code and the full details of the error. Remember to indicate which line of your code the error is thrown from.

Member 14655281 6-Mar-20 8:10am

I have already debugged my code but I found no error. Is there a program that hardly monitors the code in the event of a problem?

Stefan_Lang 6-Mar-20 10:29am

Solution 1 offers great advice, but there's one more thing you can try (if you haven't already): run the release build of your program on your own machine.

If it runs fine, then the only idea I have is that your program refers to a file or other resource that is available on your machine, but not on other machines,

If it doesn't run, then there is a difference between release and debug - then you can look for code that only runs in Debug mode, such as assert statements.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2020-03-06T02:23:00

Programs don't crash for no reason: they crash because a developer made a mistake in code, because an environment is different (or differently configured), because one or more access permissions are missing, because connections strings aren't valid in a new location, ...

There are as many reasons for a crash as there are developers writing software ... but no app has ever crashed for "no reason"!

Since it only fails in production, that rules out the easy way: using the debugger. Which means you need to fall back to pre-debugger days and get manual. Start adding code to your app to log exactly what it is doing to a log file, and run that version on the production machine. When it crashes, look at the log and add more specific logging code to start narrowing down what exactly is happening. Repeat this process until you know the method that it crashes in, and then work on where exactly and why it is crashing. Do not expect this to be a quick process - in a large app this can take days, and you still won't know what caused the crash - just where it crashed, and what data caused it to fail. Hopefully, you can then replicate the problem on your dev machine, or find a difference between them that is relevant to the area of code.

Good luck - but we can't do any of that for you!

TheRealSteveJudge · Answer 2 · 2020-03-06T03:56:00

Solution 2

In addition to the valuable hints in solution one I would like to suggest to debug your programme by means of remote debugging.
A detailed description of remote debugging is described here.
Remote Debug a C# or VB project - Visual Studio | Microsoft Docs[^]

Posted 6-Mar-20 3:56am

TheRealSteveJudge

Comments

Member 14655281 10-Mar-20 10:22am

thx

TheRealSteveJudge 11-Mar-20 3:00am

ur welcome