1. Seng Chee Chong
  2. SnapDevelop
  3. Tuesday, 2 March 2021 05:38 AM UTC

Dear All, 

I encountered issue below, after I published Web API to Windows 10 IIS server:

But I have no problem to call the Web API as below when Run Test(s) and Debug Test(s). 

Note: The d_dddw_supplier_list is converted from PB code. 

 

 

Note 2: No issue to call the Web API which run SQL Script instead of PB Script. 

Please kindly advise, thanks. 

 

Regards,

Alvin

 

 

 

 
 
Seng Chee Chong Accepted Answer Pending Moderation
  1. Thursday, 4 March 2021 01:16 AM UTC
  2. SnapDevelop
  3. # 1

Hi Sam, 

Do you have solution for File System method to publish Web API instead of Web Deploy method? Currently I am using Windows 10's IIS server, not Windows Server. 

Regards,

Alvin

Comment
  1. Seng Chee Chong
  2. Friday, 5 March 2021 09:54 AM UTC
Hi Armeen,

I had tried to correct Database Connection String in the .pubxml.user file, but, no luck, still not working.

I think I should wait for the next release.



Thanks for your help. :)



Best Regards,

Alvin
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 5 March 2021 14:43 PM UTC
Hi Alvin, new version coming end of next month. Try that will be much better. This one was an alpha version. Next one is beta version.
  1. Helpful
  1. Seng Chee Chong
  2. Monday, 8 March 2021 01:02 AM UTC
Hi Armeen, thanks.
  1. Helpful
There are no comments made yet.
Sam Song @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 2 March 2021 11:11 AM UTC
  2. SnapDevelop
  3. # 2

Hi Alvin,

Sorry, there is this bug in SnapDevelop R3, it saves wrong database connection string to the Web Deploy profile.

To work around it, please fix the database connection string saved in properties - PublishProfiles - YOUR_WEB_DEPLOY_PROFILE_NAME.pubxml.user file, and then use Web Deploy to publish it again.

BTW: We have fixed this bug in an internal test build. We can verify it in the next release.

Regards,

Sam

 

 

 

Comment
  1. Seng Chee Chong
  2. Wednesday, 3 March 2021 05:29 AM UTC
Hi Sam,

Thanks for your reply, but I cannot use Web Deploy method to publish Web API to IIS server because I am using Windows 10 OS instead of Windows Server OS right now. Currently I am using Files System method to publish Web API to local folder, after that copy the folder to C:\inetpub\wwwroot\SnapDevelop. Do you have any idea to fix this issue?

Regards,

Alvin
  1. Helpful
  1. Sam Song @Appeon
  2. Thursday, 4 March 2021 10:34 AM UTC
Hi Alvin,



For File System, you also need to correct the Database Connection String in the .pubxml.user file to work around it.

The default file name is FolderProfile.pubxml.user



Regards,

Sam
  1. Helpful
There are no comments made yet.
Marco Meoni Accepted Answer Pending Moderation
  1. Tuesday, 2 March 2021 08:32 AM UTC
  2. SnapDevelop
  3. # 3

Hi Seng,

can you check if DB connection string in appsetting.json is correct?

Best,

.m

 

Comment
  1. Seng Chee Chong
  2. Wednesday, 3 March 2021 05:19 AM UTC
Hi Marco,

I confirm the DB connection string in appsetting.json is correct because I use two methods to call web api. 1st method is calling d_dddw_supplier_list object which is converted from PB datawindow; 2nd method is running the SQL script. Both method are using same DB connection string in appsetting.json.

  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.