Business-central is no more available after changing default datasource to PostgreSQL

[juleshoueto]

Hello all,

as mention in the title, I decide to test Jboss BRMS 6.4  by changing the default JBoss BRMS H2 datasource to PostgreSQL.

I follow the official Red Hat documentation for achieving this operation.

After exeucting the ./standalone.sh script, I receive this message  error

02:21:43,255 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 2) JBAS015003: Found business-central.war in deployment directory. To trigger deployment create a file called business-central.war.dodeploy

02:21:47,918 WARN  [org.kie.server.services.impl.controller.DefaultRestControllerImpl] (KieServer-ControllerConnect) Exception encountered while syncing with controller at http://orc-brms3:8080/business-central/rest/controller/server/default-kieserver error Error while sending PUT request to http://orc-brms3:8080/business-central/rest/controller/server/default-kieserver response code 403

I check the kieserver user and password, but the value were correct.

Business-central web page is displaying  this :

JBWEB000065: HTTP Status 404 - /business-central

---

JBWEB000309: type JBWEB000067: Status report

JBWEB000068: message /business-central

JBWEB000069: description JBWEB000124: The requested resource is not available.

---

JBoss Web/7.5.7.Final-redhat-1

I am sending you as attached my standalone.xml file.

For my environment, I am running JBoss BRMS 6.4 on CentOS 7.

Thank you for your time reading my post and helping me.

Regards

[juleshoueto]

I am still troubleshooting, and this are the errors that I am facing,

18:46:05,170 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014612: Operation ("enable") failed - address: ([

    ("subsystem" => "datasources"),

    ("data-source" => "PostgresqlDS")

]) - failure description: {"JBAS014879: One or more services were unable to start due to one or more indirect dependencies not being available." => {

    "Services that were unable to start:" => [

        "jboss.data-source.reference-factory.PostgresqlDS",

        "jboss.naming.context.java.jboss.datasources.PostgresqlDS"

    ],

    "Services that may be the cause:" => ["jboss.jdbc-driver.postgresql-9_4-1202_jdbc42_jar"]

}}

18:46:05,175 WARN  [org.kie.server.services.impl.controller.DefaultRestControllerImpl] (KieServer-ControllerConnect) Exception encountered while syncing with controller at http://orc-brms3:8080/business-central/rest/controller/server/default-kieserver error Error while sending PUT request to http://orc-brms3:8080/business-central/rest/controller/server/default-kieserver response code 403

18:46:05,228 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 29) JBAS015859: Deployed "kie-server.war" (runtime-name : "kie-server.war")

18:46:05,230 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

JBAS014775:    New missing/unsatisfied dependencies:

      service jboss.jdbc-driver.postgresql-9_4-1202_jdbc42_jar (missing) dependents: [service jboss.data-source.java:jboss/datasources/PostgresqlDS, service jboss.driver-demander.java:jboss/datasources/PostgresqlDS]

Can anyone please help me ?

[dmarrazzo]

Hi Jules,

I suggest you to double check the docs:

Chapter 3. Persistence Setups - Red Hat Customer Portal

Pay attention to:

• module.xml
• /business-central.war/WEB-INF/classes/META-INF/persistence.xml

Then configure even the dashbuilder and the kieserver.

If it doesn't work try to reset the filesystem content (delete or move the directories):

• git repo `.niogit` (Remember to backup the important projects)
• maven `repositories/kie`
• index `.index`

[mccloud]

Have you installed the PostgreSQL driver onto the JBoss EAP platform? The error seems to indicate that EAP can't find the database driver JAR ....

Cheers,

Duncan

[juleshoueto]

Hello Duncan,

please, did you mean that i need to install manuay the postgresql-9.4-1206-jdbc42.jar file ?

Thank you for your answer

[dmarrazzo]

If you spend some minutes of your time reading the manual, you will find how to set up the PostgreSQL driver.

Chapter 3. Persistence Setups - Red Hat Customer Portal

Your browser has a nice feature to find text in a page, look for "driver"