1. Marco Meoni
  2. PowerServer
  3. Tuesday, 19 September 2023 09:06 AM UTC

Hello,

I'm deploying a PowerServer 2022 R2 project from a dedicated build server, running PBAutoBuild220.

PowerServer toolkit is unable to find the required Oracle NET data provider, which is usually downloaded automatically in PB/Snap when selecting the DB type (https://www.nuget.org/packages/Oracle.ManagedDataAccess.Core/3.21.100).

The standard dotnet package installation request from command line (dotnet add package Oracle.ManagedDataAccess.Core --version 3.21.110) cannot work because the C# project is not yet built, it is in fact up to the AutoBuild220 tool.

The error, at the very end of the project build:

Any clues?

Thanks,

Marco

 

Accepted Answer
Tracy Huang @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 September 2023 08:04 AM UTC
  2. PowerServer
  3. # Permalink
Hi Marco, You should open PowerServer Help (not PB Help). Click the PowerServer Help icon from the PowerServer toolbar (the last but one icon, next to Close), and then navigate through PowerServer 2022 R2 Help > Tutorials > Tutorial 12: Building your PowerServer project with commands > Task 2: Building with commands > Preparing the environment > Step 2. You can also view this page from online help: https://docs.appeon.com/ps2022r2/Preparing_for_building_with_commands.html Which I have added more details to the instructions yesterday (you may refresh the online web page to see the changes). Our engineering team also has a plan to improve the product in R3, based on your feedback. Thanks for the help! Regards Tracy
Comment
There are no comments made yet.
Tracy Huang @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 September 2023 08:04 AM UTC
  2. PowerServer
  3. # 1
Hi Marco, You should open PowerServer Help (not PB Help). Click the PowerServer Help icon from the PowerServer toolbar (the last but one icon, next to Close), and then navigate through PowerServer 2022 R2 Help > Tutorials > Tutorial 12: Building your PowerServer project with commands > Task 2: Building with commands > Preparing the environment > Step 2. You can also view this page from online help: https://docs.appeon.com/ps2022r2/Preparing_for_building_with_commands.html Which I have added more details to the instructions yesterday (you may refresh the online web page to see the changes). Our engineering team also has a plan to improve the product in R3, based on your feedback. Thanks for the help! Regards Tracy
Comment
There are no comments made yet.
Marco Meoni Accepted Answer Pending Moderation
  1. Tuesday, 19 September 2023 12:54 PM UTC
  2. PowerServer
  3. # 2

Hi,

got a hint from Appeon, the driver must be copied under %USERPROFILE%\.netdbdrives. Then PBAutobuild goes through.

Maybe the build tool could be improved to allow for a (silent) download of the dll like PB and Snap when prompting for this window:

https://docs.appeon.com/ps2022r2/Installing_Oracle_driver.html

In fact, in my case the build server is accessed by many sysadmins willing to trigger the build ( :-D ) and must copy the driver under all %USERPROFILE% dirs (apparently dotnet.exe doesnt provide a command line option to install dependencies in a "global nugget cache").

Cheers,

.m

 

Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 20 September 2023 16:41 PM UTC
Hi Marco, please take a look at documentation “Prepare the database driver if the DB2, MySQL, Oracle, or Informix database connection is required” in the documentation: https://docs.appeon.com/ps2022r2/Preparing_for_building_with_commands.html
  1. Helpful 1
  1. Marco Meoni
  2. Thursday, 21 September 2023 16:25 PM UTC
Hi Armeen,

has that html page updated/extended as a consequence of this ticket ?

PB 2022 R2 Help -> Contents (F1) doesnt contain the DB sections (step 2), but only step 1.

Best,

.m
  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.