1. Sivaprakash BKR
  2. SnapDevelop
  3. Friday, 7 May 2021 11:01 AM UTC

Hello,

Using SnapDevelop 2019 R3 Build 2703 & Visual Studio Community 2019

Project: .Net-DataStore-Example 

Trying to publish it in a Win 10 computer from both SnapDevelop and Visual Studio.   Works fine when published from Visual Studio and NOT when published from Snapdevelop.   

I did it from the same computer, from the same project folder, to the same target folder.  No difference.

I get the following error, when published from Snapdevelop

*************************************
192.168.1.66 is currently unable to handle this request
HTTP ERROR 500

Reload
************************************

Any thing should we do in Snapdevelop to work ?

Happiness Always
BKR Sivaprakash

 

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 7 May 2021 13:47 PM UTC
  2. SnapDevelop
  3. # 1

Did you start SnapDevelop using “Run as administrator” option?  By default it won’t run as admin.

Comment
  1. Sivaprakash BKR
  2. Saturday, 8 May 2021 04:46 AM UTC
Thanks Armeen,

Same issue even when started SnapDevelop in Administrator mode.
  1. Helpful
There are no comments made yet.
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Saturday, 8 May 2021 17:03 PM UTC
  2. SnapDevelop
  3. # 2

Hi Sivaprakash,

Could you start .Net-DataStore-Example in SnapDevelop successfully?

1) In SnapDevelop, right-click on your project, select Publish - File System, check whether any "Databases" setting is used and whether it is correct. 

 

2) In your publishing folder, please check the database connection string in appsettings.json and appsettings.Production.json. If the connection is not correct, you may get a 500 HTTP Status Code.

Note that appsettings.Production.json configuration overwrites values found in appsettings.json in the production environment.

Regards,

Logan

 

 

 

 

Comment
  1. Sivaprakash BKR
  2. Sunday, 9 May 2021 02:56 AM UTC
Thanks Logan

1. Could you start .Net-DataStore-Example in SnapDevelop successfully?

Yes. It's working perfect with database connection.

2. 1) In SnapDevelop, right-click on your project, select Publish - File System, check whether any "Databases" setting is used and whether it is correct.

Yes, database settings used.

Data Source=EliteJava\\SQL2012;Initial Catalog=AdventureWorks2012;Integrated Security=False;User ID=sa;Password=pass;Pooling=True;Min Pool Size=0;Max Pool Size=100;ApplicationIntent=ReadWrite



Datasource is having '\\' (two) instead of one ('\'). Still I tried with both single slash and double slash. It's not working.



3. appsettings.production.json had four slashes, I corrected it with 2 slashes, still not working.

"AdventureWorks": "Data Source=EliteJava\\\\SQL2012;Initial Catalog=AdventureWorks2012;Integrated Security=False;User ID=sa;Password=pass;Pooling=True;Min Pool Size=0;Max Pool Size=100;ApplicationIntent=ReadWrite"

  1. Helpful
  1. Sivaprakash BKR
  2. Sunday, 9 May 2021 03:05 AM UTC
Everything works fine when I publish the same project from the same computer, to the same target folder from VS. IN VS published project, Data source in appsettings.production.json got only two slashes.
  1. Helpful
  1. Logan Liu @Appeon
  2. Monday, 10 May 2021 11:19 AM UTC
Yes. There is this slash difference but it didn't affect the database connection. Please report this slash bug via our support ticketing system to ensure it is being properly received by our tech support and tracked at: https://www.appeon.com/standardsupport/.

  1. Helpful
There are no comments made yet.
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Monday, 10 May 2021 11:13 AM UTC
  2. SnapDevelop
  3. # 3

Hi Sivaprakash,

Are you using IIS? If yes, have you ever followed the steps in this tutorial?

https://docs.appeon.com/snapdevelop2019r3/Publish/index.html#publishing-to-iis

Please check the IIS log file to get more details about the exception:

https://docs.microsoft.com/en-us/aspnet/core/test/troubleshoot-azure-iis?view=aspnetcore-3.1#aspnet-core-module-stdout-log-iis

Regards,

Logan

Comment
There are no comments made yet.
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Tuesday, 11 May 2021 14:34 PM UTC
  2. SnapDevelop
  3. # 4

Thanks Logan,
Already gone through the links you have provided and I hope all IIS settings done properly. Since I could work successfully when published from Visual Studio, I hope IIS settings should be right.

I face two issues in using snapdevelop in this machine.
1. First I could not connect to SQL Server from DB Server. Tried with two slashes and single slash as suggested by you. [ See the attached image]
2.  Could connect to SQL server from script and works fine.  When run from snapdevelop, everything works fine.
3.  Could not successfully work from published website [publishing done from snapdevelop]
4.  Could work successfully when published from Visual studio.

I hope the IIS settings should be correct, otherwise it won't work even when published from VS.

Happiness Always
BKR Sivaprakash

 

Attachments (1)
Comment
  1. Logan Liu @Appeon
  2. Friday, 14 May 2021 05:39 AM UTC
Hi Sivaprakash,

1) "First I could not connect to SQL Server from DB Server. "

Have you ever checked your Database server? Please enable both TCP and Named Pipes and try again.

There is a topic about this:

https://community.appeon.com/index.php/qna/q-a/snapdevelop-sql-server-db-connection



2) "Could not successfully work from published website [publishing done from snapdevelop]"

Please report your issue via our support ticketing system to ensure it is being properly received by our tech support and tracked at: https://www.appeon.com/standardsupport/.



Regards,

Logan
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.