No .deployed Files

[Jack B]

Hi all,

Glad to find this group. My team and I are working to upgrade our 1.7.12a instance to 1.7.13. When I deploy wildfly-17.0.1, no .deployed files are being generated (e.g. crc-ds.xml.deployed), unlike with 1.7.12a. Things look to be up and running at localhost/i2b2/services/listServices, but if someone could confirm this change for .13 I would appreciate it. I could not find anything in the release notes or install guides.

Thanks,

Jack B

[Vidhya Asuri]

Good morning!

I may have a similar problem to this.

Gist of my problem: The deployment of *-ds.xml files in the /standalone/deployment folder is failing.

Error in server.log: 

2023-06-12 17:54:09,934 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "work-ds.xml")]) - failure description: {
    "WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.mssql-jdbc-11_2_0_jre8_jar"],
    "WFLYCTL0180: Services with missing/unavailable dependencies" => [
        "jboss.data-source.\"jboss.naming.context.java.WorkplaceBootStrapDS\" is missing [jboss.jdbc-driver.mssql-jdbc-11_2_0_jre8_jar]",
        "jboss.data-source.\"jboss.naming.context.java.WorkplaceDemoDS\" is missing [jboss.jdbc-driver.mssql-jdbc-11_2_0_jre8_jar]"
    ]
}

Java version: "1.8.0_201" (Java(TM) SE Runtime Environment (build 1.8.0_201-b09) )

Wildfly Home:  /opt/i2b2-1.17.13/wildfly-17.0.1.Final/

Location of SQL JDBC jar file: /opt/i2b2-1.17.13/wildfly-17.0.1.Final/modules/system/layers/base/com/microsoft/sqlserver/jdbc/main
The folder /opt/i2b2-1.17.13/wildfly-17.0.1.Final/modules/system/layers/base/com/microsoft/sqlserver/jdbc/main
Contains module.xml and mssql-jdbc-11.2.0.jre8.jar
Contents of module.xml
<module name="com.microsoft.sqlserver.jdbc" xmlns="urn:jboss:module:1.5">
    <resources>
        <resource-root path="mssql-jdbc-11.2.0.jre8.jar"/>
    </resources>
    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
        <module name="javax.servlet.api" optional="true"/>
    </dependencies>
</module>
Location of standalone.xml: /opt/i2b2-1.17.13/wildfly-17.0.1.Final/standalone/configuration
I edited the ‘drivers’ tag in standalone.xml to add the sql server config.
                <drivers>
                    <driver name="h2" module="com.h2database.h2">
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
                    <driver name="sqlserver" module="com.microsoft.sqlserver.jdbc">
                        <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
                    </driver>
                </drivers>
I have the following driver-class and driver tags in *-ds.xml in /opt/i2b2-1.17.13/wildfly-17.0.1.Final/standalone/deployments
                <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                <driver>mssql-jdbc-11.2.0.jre8.jar</driver>

The deployment of the xml files fails. I see the standalone.xml file has an 'xa-satasource-class'. Should that be changed?

Thanks for sharing any pointers you may have.

-Vidhya

[Vidhya Asuri]

I copied the jar file into the deployments folder and the error about the jdbc jar file went away from server.log.

This is the listing of files in my deployments folder.

$ cd wildfly-17.0.1.Final/standalone/deployments
$ ls
README.txt                           ojdbc8.jar
crc-ds.xml                           ojdbc8.jar.deployed
crc-ds.xml.deployed                  ont-ds.xml
i2b2.war                             ont-ds.xml.deployed
i2b2.war.deployed                    pm-ds.xml
im-ds.xml                            pm-ds.xml.deployed
im-ds.xml.deployed                   postgresql-42.3.2.jar
mssql-jdbc-11.2.0.jre8.jar           postgresql-42.3.2.jar.deployed
mssql-jdbc-11.2.0.jre8.jar.deployed  work-ds.xml
mssql-jdbc-9.2.0.jre8.jar            work-ds.xml.deployed
mssql-jdbc-9.2.0.jre8.jar.deployed

More than a little confusing, since all those configuration/set up work done on standalone.xml and creating the folder structure (com/microsoft/...) seems unnecessary.

May I please suggest that a little more documentation help be provided for WildFly in the i2b2 documentation.

I understand Wildfly is a separate application, but there are path changes that need to be made (say in launch.sh) in i2b2 versions greater than 1.17.12, since these i2b2 versions come packaged with Wildfly.

Hope you have a good day!

[Jeff Klann]

Hi, I'd be happy to make sure we fix the docs if you could explain in a little more detail.

I don't see a reference to mssql-jdbc-11.2.0.jre8.jar in the GitHub, so I wonder if you are changing this in your local configuration?

Can you provide a link to the "standalone.xml and creating the folder structure (com/microsoft/...)" that seems unnecessary?

Thanks!

Jeff Klann, PhD

[Srividhya Asuri]

Hi Jeff,

  So, the one thing that I needed to do that is different from the steps in the documentation is that I'm copying the *ds.xml files in the standalone/deployment  folder from an existing older installation of i2b2 that has Wildfly 10. 

The reference to mssql-jdbc-11.2.0.jre8.jar came from the copied xml files.

After seeing this error(about the missing jar file), I Googled for a way to provide that missing jar file.

From what I saw, I needed to create this folder structure, /opt/i2b2-1.17.13/wildfly-17.0.1.Final/modules/system/layers/base/com/microsoft/sqlserver/jdbc/main, and then place the missing jar (mssql-jdbc-11.2.0.jre8.jar) file and a module.xml in that folder. I did that but the error about the missing jar file remained. A colleague suggested that I place the jar file in the deployments folder and that worked. So, maybe my problem was that I needed some help with providing the jar files that were referenced in the xml files.

All this may be just my growing pains dealing with Wildfly.

Thanks for taking the time to reply. Hope you had a good weekend so far! 

- Vidhya

--
You received this message because you are subscribed to the Google Groups "i2b2 Install Help" group.
To unsubscribe from this group and stop receiving emails from it, send an email to i2b2-install-h...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/i2b2-install-help/b3dd0a24-853c-4f1c-bd89-1c85fe6a60fen%40googlegroups.com.