Edgard L. Riba
Nov 17, 2001 9:46:00 AM

How to load winsql to run a given query

I want to call WinSQL from a batch file, and have it execute a given script. For example winSql myscript.sql I tried, but this only loads the script into winsql, it stops to get the user name and password, plus then I have to run it. Is there a way to do what I want?


IndusSoft support engineer
Nov 18, 2001 10:52:00 AM

How to load winsql to run a given query

Hello Edgard, This feature is only supported in the Professional version of WinSQL. Please refer to the WinSQL User's guide (http://www.indus-soft.com/WinHelp/MainDoc.pdf), which has some examples that shows how to do that. Thanks, IndusSoft support >I want to call WinSQL from a batch file, and have it execute a given script. For example > winSql myscript.sql > >I tried, but this only loads the script into winsql, it stops to get the user name and password, plus then I have to run it. > >Is there a way to do what I want?


mezzeddini
Feb 6, 2023 2:19:05 PM

Issue while updating Syncrify Clients

Hello,


After updating the Syncrify server to Version: 5.6 - build 1140, some clients are unable to update, and below is what we get in the logs of one of them; endless attempts to download the .jar file, which is jamming the network and the same errors:


2023-02-06 12:55:12,234 {INFO Thread-96} [ServiceHelper] - Server has a newer copy of Syncrify Client based on LMD
2023-02-06 12:56:12,242 {INFO Thread-98} [ServiceHelper] - Server has a newer copy of Syncrify Client based on LMD
2023-02-06 12:57:12,426 {INFO Thread-100} [ServiceHelper] - Server has a newer copy of Syncrify Client based on LMD
2023-02-06 12:58:13,586 {INFO Thread-102} [ServiceHelper] - Server has a newer copy of Syncrify Client based on LMD
2023-02-06 12:58:52,631 {ERROR Thread-88} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar
2023-02-06 12:59:52,460 {ERROR Thread-86} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar
2023-02-06 13:00:26,532 {ERROR Thread-90} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar
2023-02-06 13:02:11,423 {ERROR Thread-92} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar
2023-02-06 13:03:18,979 {ERROR Thread-94} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar
2023-02-06 13:04:24,851 {ERROR Thread-96} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar
2023-02-06 13:05:19,635 {ERROR Thread-100} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar
2023-02-06 13:05:24,443 {ERROR Thread-98} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar
2023-02-06 13:05:44,065 {ERROR Thread-102} [ServiceHelper] - Unable to download http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar


I had to manually patch by using this method: https://web.synametrics.com/syncrifyclientautoupgrade.htm#:~:text=Manually%20Patching%20Clients,log%20for%20errors.

However, I cannot find out why the client didn't update automatically. There was no firewall or antivirus involved.

 

Any idea about what could cause this? Thanks!



Synametrics support engineer
Feb 6, 2023 2:24:59 PM

Issue while updating Syncrify Clients

Hi,

Could you please paste http://xxxxxxxxxx:xxxxx/app?operation=dnci&type=jar in your browser and see if you're able to download the file. If not, what is the error.

Navigation

Social Media

Powered by 10MinutesWeb.com