Origam Architect - Create new project with PostgresSQL database fail on missing System.Numeric.Vectors.dll

david.pochobradsky · May 11, 2022, 8:16pm

I was trying to …

Create new project with database PostgresSQL using New Project wizard.

I was expecting …

The new project would be created.

Instead I’ve got …

Exception of missing dll library System.Numerics.Vectors.dll

Further examinations

I have tried to compile architect from current source code. I ran Origam Architect and I was able to create new project.
I have tried to copy all dlls from Debug folder to Origam Architect installation.
I ran the New Project wizard again and I was able to successfully create project (using project template of version 2022.1.0) - 2022.2.0 ended up with an error creating User that the column IsLockedOut is missing - that would be probably different versions of model and Architect.

Suggestions

Compile Origam Architect to include proper dlls and distribute it to support PostgresSQL with no troubles.

david.pochobradsky · May 30, 2022, 9:54pm

I can try to fix it but I would need some information how to use WIX to create OrigamSetup.msi file to test it locally before commit. I see that OrigamSetup.wsx does not contain reference to System.Numerics.Vectors.

I need to solve this issue because it complicates sharing the model with my collegues as I need development on PostgreSQL database.

tvavrda · May 31, 2022, 1:34pm

You are right that you need to add it to OrigamSetup.wsx among the other dependencies. Each dependency has a component and a feature so you need to add it in two places.

Example of a component (you need to generate a unique Guid):

<Component Id="ORIGAM.SECURITY.COMMON.DLL" DiskId="1" 
   Guid="453d8088-1083-4aca-8c8c-397d9dfccc76">
   <File 
        Id="ORIGAM.SECURITY.COMMON.DLL" 
        Name="Origam.Security.Common.dll" 
        Source="source\Origam.Security.Common.dll">
   </File>
</Component>

and a component reference to an existing “Architect” feature node:

<Feature Id="Architect" Level="1">
    <ComponentRef Id="ORIGAM.SECURITY.COMMON.DLL">
    </ComponentRef>
</Feature>

david.pochobradsky · May 31, 2022, 4:51pm

Great! And any hint how can I test the result? How to build msi installer and test weather it works?

I can add System.Numerics.Vectors but I can get into other errors, so I would like to test the scenario completely before I will commit changes.

tvavrda · May 31, 2022, 5:19pm

Basically you have to install the wix toolset and have all the source files the setup requires in the source folder (as you can see in the example) and a zipped model in model_root_source\DefaultModel.zip file. A the moment we are using WIX version 3.11.

You can see the whole build procedure here. But basically it starts with copying the Architect build results to sources, compressing the model and running the wix commands candle and light.

github.com

origam/origam/blob/d3c8a2656cd3a8fe96c30798af389a32270b5aec/build/build-monorepo.yaml#L177

      
        
              inputs:
                SourceFolder: '$(build.artifactstagingdirectory)\origam-client'
                Contents: |
                  **\*.*
                RemoveSourceFolder: true
              displayName: 'origam-client clean up'
            - powershell: |
               (Get-Content $(Agent.BuildDirectory)\s\backend\OrigamSetup\ArchitectSetup.wxs).replace("@product_version@", "$(PRODUCT_NUMBER)") | Set-Content $(Agent.BuildDirectory)\s\backend\OrigamSetup\ArchitectSetup.wxs
               (Get-Content $(Agent.BuildDirectory)\s\backend\OrigamSetup\ArchitectSetup.wxs).replace("@branch@", "$(PRODUCT_VERSION)") | Set-Content $(Agent.BuildDirectory)\s\backend\OrigamSetup\ArchitectSetup.wxs
              displayName: 'Prepare ArchitectSetup.wxs'
            - powershell: |
               xcopy $(Agent.BuildDirectory)\s\model-root\l10n model_template\l10n /i /e /y
               xcopy $(Agent.BuildDirectory)\s\model-root\model model_template\model /i /e /y
               & { Add-Type -A 'System.IO.Compression.FileSystem'; [IO.Compression.ZipFile]::CreateFromDirectory('model_template', '$(Agent.BuildDirectory)\s\backend\OrigamSetup\model_root_source\DefaultModel.zip'); }
               xcopy model_template $(build.artifactstagingdirectory)\origam-model /i /e /y
               xcopy $(build.artifactstagingdirectory)\origam-architect $(Agent.BuildDirectory)\s\backend\OrigamSetup\source /i /e /y
              displayName: 'Prepare sources for setup (model)'
            - powershell: |
               & "$(WIX)bin\candle.exe" -ext WixSqlExtension -ext WixUtilExtension ArchitectSetup.wxs
               & "$(WIX)bin\light.exe" -ext WixSqlExtension -ext WixUtilExtension -ext WixNetFxExtension -sice:ICE20 -cultures:en-us -loc resources.en-us.wxl -out OrigamSetup.msi ArchitectSetup.wixobj
               New-Item -ItemType File -Path $(build.artifactstagingdirectory)\origam-setup\OrigamSetup.msi -Force

david.pochobradsky · July 27, 2022, 1:31pm

I was able to fix the behaviour, there were also additional troubles I have found, so here is the list

Origam Architect: Create new Project with Postgres SQL database:
- Added missing dlls needed for Postgres connection
- Fixing rollback when creating Postgres project on the database where there is no user named postgres => it was failing and the user created by wizard was not removed from database
  
  Fix of Origam Architect for PostgresSql: by davidpochobradsky · Pull Request #730 · origam/origam · GitHub
Origam Architect: Create new Project with Postgres SQL database or MS SQL Database:
- Wizard was failing in Create web user step because IsLockedOut column was not found in the database
  
  Fix of Origam Architect for PostgresSql: by davidpochobradsky · Pull Request #730 · origam/origam · GitHub

In addition:

I included powershell script extracted from origam/build-monorepo.yaml at d3c8a2656cd3a8fe96c30798af389a32270b5aec · origam/origam · GitHub to create OrigamSetup.msi locally for local test.

washi · July 28, 2022, 10:45am

github.com/origam/origam

Fix of Origam Architect for PostgresSql:

origam:2022.2 ← davidpochobradsky:dp-2022.2

opened 09:35AM - 25 Jul 22 UTC

davidpochobradsky

+71 -10

1. Postgresql => Create New Project on PostgresSQL database terminated in ERROR:… https://community.origam.com/t/origam-architect-create-new-project-with-postgressql-database-fail-on-missing-system-numeric-vectors-dll/1735/6 * By fixing this issue, I have found on my local postgresql installation that user <dbname> which has been created by installation is not removed in case if the create new project fails (rollback didn't work because in my database there was no user postgres). I fixed this by updating a script for rollback. 2. Postges + MS SQL: * New project could not be created because of failing step **Create new Web User** => there was remove of column `IsLockedOut` column in the model but this column remained in `CreateOrigamUserInsert` in both adapters - MS SQL and Postgres Note: I included powershell script for local wix testing => build-msi.ps1 and build-msi.bat to run it with specific parameters.

github.com/origam/origam

Fix of Origam Architect for PostgresSql: (#730)

origam:master ← origam:architect-postgre-fix

opened 08:59AM - 28 Jul 22 UTC

washibana

+71 -10

* Fix of Origam Architect: 1. Postgresql => Create New Project on PostgresSQL… database terminated in ERROR: https://community.origam.com/t/origam-architect-create-new-project-with-postgressql-database-fail-on-missing-system-numeric-vectors-dll/1735/6 * By fixing this issue, I have found on my local postgresql installation that user <dbname> which has been created by installation is not removed in case if the create new project fails (rollback didn't work because in my database there was no user postgres). I fixed this by updating a script for rollback. 2. Postges + MS SQL: * New project could not be created because of failing step **Create new Web User** => there was remove of column `IsLockedOut` column in the model but this column remained in `CreateOrigamUserInsert` in both adapters - MS SQL and Postgres Note: I included powershell script for local wix testing => build-msi.ps1 and build-msi.bat to run it with specific parameters. * #730 - https://github.com/origam/origam/pull/730 https://community.origam.com/t/origam-architect-create-new-project-with-postgressql-database-fail-on-missing-system-numeric-vectors-dll/1735 - Removing comments as requested by washibana

system · August 24, 2022, 11:23am

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.