kandi background
Explore Kits

CromwellOnAzure | Microsoft Genomics supported implementation of the Broad | BPM library

 by   microsoft C# Version: 3.0.0 License: MIT

 by   microsoft C# Version: 3.0.0 License: MIT

Download this library from

kandi X-RAY | CromwellOnAzure Summary

CromwellOnAzure is a C# library typically used in Automation, BPM applications. CromwellOnAzure has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.
Microsoft Genomics supported implementation of the Broad Institute's Cromwell workflow engine on Azure
Support
Support
Quality
Quality
Security
Security
License
License
Reuse
Reuse

kandi-support Support

  • CromwellOnAzure has a low active ecosystem.
  • It has 94 star(s) with 39 fork(s). There are 24 watchers for this library.
  • There were 1 major release(s) in the last 12 months.
  • There are 45 open issues and 125 have been closed. On average issues are closed in 46 days. There are 9 open pull requests and 0 closed requests.
  • It has a neutral sentiment in the developer community.
  • The latest version of CromwellOnAzure is 3.0.0
CromwellOnAzure Support
Best in #BPM
Average in #BPM
CromwellOnAzure Support
Best in #BPM
Average in #BPM

quality kandi Quality

  • CromwellOnAzure has no bugs reported.
CromwellOnAzure Quality
Best in #BPM
Average in #BPM
CromwellOnAzure Quality
Best in #BPM
Average in #BPM

securitySecurity

  • CromwellOnAzure has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
CromwellOnAzure Security
Best in #BPM
Average in #BPM
CromwellOnAzure Security
Best in #BPM
Average in #BPM

license License

  • CromwellOnAzure is licensed under the MIT License. This license is Permissive.
  • Permissive licenses have the least restrictions, and you can use them in most projects.
CromwellOnAzure License
Best in #BPM
Average in #BPM
CromwellOnAzure License
Best in #BPM
Average in #BPM

buildReuse

  • CromwellOnAzure releases are available to install and integrate.
  • Installation instructions, examples and code snippets are available.
CromwellOnAzure Reuse
Best in #BPM
Average in #BPM
CromwellOnAzure Reuse
Best in #BPM
Average in #BPM
Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample Here

Get all kandi verified functions for this library.

Get all kandi verified functions for this library.

CromwellOnAzure Key Features

Microsoft Genomics supported implementation of the Broad Institute's Cromwell workflow engine on Azure

CromwellOnAzure Examples and Code Snippets

See all related Code Snippets

Optional: build the executable yourself

copy iconCopydownload iconDownload
wget https://packages.microsoft.com/config/ubuntu/18.04/packages-microsoft-prod.deb -O packages-microsoft-prod.deb
sudo dpkg -i packages-microsoft-prod.deb
rm packages-microsoft-prod.deb
sudo apt-get update && \
sudo apt-get install -y apt-transport-https && \
sudo apt-get update && \
sudo apt-get install -y dotnet-sdk-5.0

Run the deployment executable

copy iconCopydownload iconDownload
.\deploy-cromwell-on-azure.exe --SubscriptionId <Your subscription ID> --RegionName <Your region> --MainIdentifierPrefix <Your string> 

Hello World WDL test

copy iconCopydownload iconDownload
task hello {
  String name

  command {
    echo 'Hello ${name}!'
  }
  output {
	File response = stdout()
  }
  runtime {
	docker: 'ubuntu:16.04'
  }
}

workflow test {
  call hello
}

See all related Code Snippets

Community Discussions

Trending Discussions on BPM
  • Camunda embedded with H2: Cockpit Login fails
  • Plot line from dataframe
  • Camunda Application not starting up on docker container
  • Renaming some part of columns of dataframe with values from another dataframe
  • How to separate Camunda tables to a different schema?
  • How to convert json MySQL data into rows and column
  • Using pyaudio to build a Metronome; wrong timing
  • Why am I getting "Error processing transaction request: intrinsic gas too low" error when trying to add tUSDT to a particular account?
  • getting a KeyNotFoundException on a key that appears to exist in a dictionary
  • Webaudio timing performance
Trending Discussions on BPM

QUESTION

Camunda embedded with H2: Cockpit Login fails

Asked 2022-Mar-09 at 08:50

I'm currently wokring on a product with the following conditions:

  • Spring-Boot (2.6) with Camunda embedded (7.16)
  • Connection to Camunda configured to use H2 (2.1.210) embedded with the following is configured in application.yml:
app:
  datasource-camunda:
    jdbcUrl: jdbc:h2:./h2/test;MODE=LEGACY
camunda:
  bpm:
    database:
      schema-update: true
    auto-deployment-enabled: true

and as Java-Configuration:

@Bean("camundaBpmDataSource")
@ConfigurationProperties
public DataSource camundaDataSource() {
  return DataSourceBuilder.create().build();
}

@Bean
public PlatformTransactionManager camundaBpmTransactionManager(DataSource datasource) {
  return new DataSourceTransactionManager(datasource)
}

The camunda engine is not configured explicitly since I used the appropriate starter and let Spring auto configured it. As a result the resulting setup should look very similar to the embedded camunda h2 configuration showed here: https://docs.camunda.org/get-started/spring/embedded-process-engine/

The application runs good with this setup. No problems with the application at all, but I faced an issue while logging in to the camunda cockpit. Login succeeds but then I see an error in the login mask saying:

Login Failed

An exception occured in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace



Caused by: org.h2.jdbc.JdbcSQLNonTransientException: Unbekannter Datentyp: "?2"

Unknown data type: "?2"; SQL statement:

SELECT

    CASE

 

     

       

        WHEN

          

           

          EXISTS

          

            (SELECT

                    A.RESOURCE_ID_

             FROM

                    ACT_RU_AUTHORIZATION A

             WHERE

                    A.TYPE_ = 1

             AND

                    A.USER_ID_ = ?

             AND

                    BITAND(A.PERMS_,?) = ?

             AND

                    A.RESOURCE_TYPE_ = ?

             AND

                    A.RESOURCE_ID_ =  ? )

        THEN 1

      

 

     

       

 

     

      WHEN

        EXISTS

          (SELECT

                  ID_

           FROM

                  ACT_RU_AUTHORIZATION A

           WHERE

                  A.TYPE_ = 1

           AND

                  A.USER_ID_ = ?

           AND

                  BITAND(A.PERMS_,?) = ?

           AND

                  A.RESOURCE_TYPE_ = ?

           AND

                  A.RESOURCE_ID_ = '*')

        THEN 1

 

     

       

 

      ELSE

          (

          SELECT

            CASE

              

 

               

                 

                  WHEN

                    

                     

                    EXISTS

                    

                      (SELECT

                              A.RESOURCE_ID_

                       FROM

                              ACT_RU_AUTHORIZATION A

                       WHERE

                              A.TYPE_ = 1

                       AND

                              A.GROUP_ID_ IN  (  ? )

                       AND

                              BITAND(A.PERMS_,?) = ?

                       AND

                              A.RESOURCE_TYPE_ = ?

                       AND

                              A.RESOURCE_ID_ =  ? )

                  THEN 1

                

 

               

                 

 

               

                WHEN

                  EXISTS

                    (SELECT

                            ID_

                     FROM

                            ACT_RU_AUTHORIZATION A

                     WHERE

                            A.TYPE_ = 1

                     AND

                            A.GROUP_ID_ IN  (  ? )

                     AND

                            BITAND(A.PERMS_,?) = ?

                     AND

                            A.RESOURCE_TYPE_ = ?

                     AND

                            A.RESOURCE_ID_ = '*')

                  THEN 1

 

               

                 

 

                ELSE (

                      SELECT

                        CASE

              

                          

                           

                            WHEN

                              

                               

                              EXISTS

                              

                                (SELECT

                                        A.RESOURCE_ID_

                                 FROM

                                        ACT_RU_AUTHORIZATION A

                                 WHERE

                                        A.TYPE_ = 0

                                 AND

                                        A.USER_ID_ = '*'

                                 AND

                                        BITAND(A.PERMS_,?) = ?

                                 AND

                                        A.RESOURCE_TYPE_ = ?

                                 AND

                                        A.RESOURCE_ID_ =  ? )

                            THEN 1

                          

 

                         

                           

 

                         

                          WHEN

                            EXISTS

                              (SELECT

                                      ID_

                               FROM

                                      ACT_RU_AUTHORIZATION A

                               WHERE

                                      A.TYPE_ = 0

                               AND

                                      A.USER_ID_ = '*'

                               AND

                                      BITAND(A.PERMS_,?) = ?

                               AND

                                      A.RESOURCE_TYPE_ = ?

                               AND

                                      A.RESOURCE_ID_ = '*')

                            THEN 1

 

                          

                           

 

                         

                          ELSE

                          

                           

                            null

                          

 

              

                        END

                )

              

            END

      )

    END [50004-210]

            at org.h2.message.DbException.getJdbcSQLException(DbException.java:573) ~[h2-2.1.210.jar:2.1.210]

            at org.h2.message.DbException.getJdbcSQLException(DbException.java:496) ~[h2-2.1.210.jar:2.1.210]

            at org.h2.message.DbException.get(DbException.java:227) ~[h2-2.1.210.jar:2.1.210]

I already took a look into the database and saw all tables where created sucesfully, so does anybody faced a similar issue?

ANSWER

Answered 2022-Mar-09 at 08:50

Remove the "MODE=LEGACY" from the url. Here is a working example:

https://github.com/rob2universe/vanilla-camunda-template/blob/4625376bf3a5eed9cd1f2853cdf07fe5eca46685/src/main/resources/application.yaml#L17

Also ensure you use a supported H2 version. That is 1.4.x fro 7.16.x: https://docs.camunda.org/manual/7.16/introduction/supported-environments/

The BOM will inclcude H2 1.4.200.

Source https://stackoverflow.com/questions/71391717

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install CromwellOnAzure

Download the required executable from Releases. Choose the runtime of your choice from win-x64, linux-x64, osx-x64. On Windows machines, we recommend using the win-x64 runtime (deployment using the linux-x64 runtime via the Windows Subsystem for Linux is not supported).
Note: Build instructions only provided for the latest release. Preqrequisites: .NET 5 SDK for Linux. Get instructions for your Linux distro and version to install the SDK.
Clone the Cromwell on Azure repository
Build the solution using dotnet build on bash or Powershell. For Windows, you can choose to build and test using VS 2019
Run tests using dotnet test on bash or Powershell
Publish the deploy-cromwell-on-azure project as a self-contained deployment with your target runtime identifier (RID) to produce the executable

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

DOWNLOAD this Library from

Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
over 430 million Knowledge Items
Find more libraries
Reuse Solution Kits and Libraries Curated by Popular Use Cases
Explore Kits

Save this library and start creating your kit

Explore Related Topics

Share this Page

share link
Reuse Pre-built Kits with CromwellOnAzure
Consider Popular BPM Libraries
Try Top Libraries by microsoft
Compare BPM Libraries with Highest Support
Compare BPM Libraries with Highest Quality
Compare BPM Libraries with Highest Security
Compare BPM Libraries with Permissive License
Compare BPM Libraries with Highest Reuse
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
over 430 million Knowledge Items
Find more libraries
Reuse Solution Kits and Libraries Curated by Popular Use Cases
Explore Kits

Save this library and start creating your kit

  • © 2022 Open Weaver Inc.