Product, version and build:2015 4.2.99
32 or 64 bit version of product:64
Operating system:win server 2008 r2 standard sp1 (in VM)
32 or 64 bit OS:64
PowerShell Version:2
About once a week under heavy editing/run cycles of a winform app, the app will execute but for no apparent reason will no longer make any connection to db. No error, but none of the db queries will execute. I am not changing the connection code or sql query code when this happens.
I have to restore from backup. This usually happens after I abort a run attempt, or if the app encounters a run time error.
thanks,
ken
DB functionality failing for no apparent reason
Forum rules
Do not post any licensing information in this forum.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
Do not post any licensing information in this forum.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
- LtMandella
- Posts: 61
- Last visit: Mon May 07, 2018 4:03 pm
Re: DB functionality failing for no apparent reason
[TOPIC MOVED TO THE POWERSHELL GUIS FORUM BY MODERATOR]
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- LtMandella
- Posts: 61
- Last visit: Mon May 07, 2018 4:03 pm
Re: DB functionality failing for no apparent reason
powershell studio winform app. I will try again in that forum. thanks.jvierra wrote:What app. This is a scripting forum for PowerShell. Are you asking about a PowerShell Windows Forms script?
- LtMandella
- Posts: 61
- Last visit: Mon May 07, 2018 4:03 pm
winform script will not make db connection, must restore from backup
Product, version and build: powershell studio 2015 4.2.99
32 or 64 bit version of product:64
Operating system:win server 2008 r2 standard sp1 (in VM)
32 or 64 bit OS:64
PowerShell Version:2
About once a week under heavy editing/run cycles of a winform app, the app will execute but for no apparent reason will no longer make any connection to db. No error, but none of the db queries will execute. I am not changing the connection code or sql query code when this happens.
I have to restore from backup. This usually happens after I abort a run attempt, or if the app encounters a run time error.
thanks,
ken
32 or 64 bit version of product:64
Operating system:win server 2008 r2 standard sp1 (in VM)
32 or 64 bit OS:64
PowerShell Version:2
About once a week under heavy editing/run cycles of a winform app, the app will execute but for no apparent reason will no longer make any connection to db. No error, but none of the db queries will execute. I am not changing the connection code or sql query code when this happens.
I have to restore from backup. This usually happens after I abort a run attempt, or if the app encounters a run time error.
thanks,
ken
Re: DB functionality failing for no apparent reason
You are in the correct forum but I do not understand your question. You are saying that something doesn't work but there is no detail and no code illustrating the issue.
Without some information there is no way to even guess t what the issue is.
Provide a minimal piece of code that demonstrates the issue along with any errors.
Without some information there is no way to even guess t what the issue is.
Provide a minimal piece of code that demonstrates the issue along with any errors.
Re: DB functionality failing for no apparent reason
This sounds like something is corrupting your disk. Running an EXE cannot change the exe. Try running disk and system diagnostics.LtMandella wrote:I have to restore from backup. This usually happens after I abort a run attempt, or if the app encounters a run time error.
thanks,
ken
Re: winform script will not make db connection, must restore from backup
[TOPIC MOVED TO POWERSHELL GUI FORUMS]
This is probably happening because the connections aren't properly closed (possibly because you hit the stop button in debug) and you end up running out of available connections. Without any error messages or code it is hard to tell what is happening.
This is probably happening because the connections aren't properly closed (possibly because you hit the stop button in debug) and you end up running out of available connections. Without any error messages or code it is hard to tell what is happening.
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- LtMandella
- Posts: 61
- Last visit: Mon May 07, 2018 4:03 pm
Re: DB functionality failing for no apparent reason
thanks guys,
I will see if I can record any error messages. I can't recall seeing any in the output window of powershell studio when this happens.
I will run some sql on the db server side to examine the open connections next time this happens.
I will see if I can record any error messages. I can't recall seeing any in the output window of powershell studio when this happens.
I will run some sql on the db server side to examine the open connections next time this happens.