Unknown error while try to disable a datasource in EAP 6
Issue
- The datasource is enabled on all servers/groups and when try to disable an already enabled datasource getting below error.
Error Message:
Unknown error
Unexpected HTTP response: 500
Request
{
"password" => "***",
"driver-name" => "jtds-1.3.1.jar",
"enabled" => true,
"transaction-isolation" => "",
"user-name" => "***",
"query-timeout" => 0L,
"allocation-retry" => 0,
"valid-connection-checker-class-name" => "",
"check-valid-connection-sql" => "SELECT 1 FROM abc",
"background-validation" => false,
"stale-connection-checker-class-name" => "",
"exception-sorter-class-name" => "",
"prepared-statements-cache-size" => -1L,
"share-prepared-statements" => false,
"use-try-lock" => 0L,
"pool-name" => "",
"jta" => false,
"background-validation-millis" => -1L,
"validate-on-match" => false,
"new-connection-sql" => "select 1",
"security-domain" => "",
"connection-url" => "jdbc:jtds:sqlserver://xyz.ch:1111/abc",
"jndi-name" => "java:jboss/jdbc/test2012",
"driver-class" => "net.sourceforge.jtds.jdbc.Driver",
"datasource-class" => "",
"use-ccm" => false,
"blocking-timeout-wait-millis" => 0L,
"idle-timeout-minutes" => 0L,
"set-tx-query-timeout" => false,
"allocation-retry-wait-millis" => 0L,
"name" => "vstinfows",
"operation" => "disable",
"address" => [
("profile" => "default"),
("subsystem" => "datasources"),
("data-source" => "vstinfows")
],
"operation-headers" => {"allow-resource-service-restart" => true}
}
Response
Internal Server Error
{
"outcome" => "failed",
"result" => undefined,
"failure-description" => "JBAS010839: Operation failed or was rolled back on all servers.",
"rolled-back" => true,
"server-groups" => {
"int-prd-j2ee-be-01-8080" => {"host" => {
"svrl1j2ee6p51" => {"sc-prd-p51-01-8080" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"rolled-back" => true
}}},
"svrl1j2ee6p52" => {"sc-prd-01-8080" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"rolled-back" => true
}}}
}},
"int-prd-j2ee-be-04-8480" => {"host" => {
"svrl1j2ee6p51" => {"sc-prd-p51-04-8480" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"failure-description" => "JBAS010455: Data-source service [vstinfows] is not enabled",
"rolled-back" => true
}}},
"svrl1j2ee6p52" => {"sc-prd-p52-04-8480" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"failure-description" => "JBAS010455: Data-source service [vstinfows] is not enabled",
"rolled-back" => true
}}}
}},
"int-prd-j2ee-bs-01-8080" => {"host" => {
"svrl1j2ee6p01" => {"sc-prd-p01-01-8080" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"rolled-back" => true
}}},
"svrl1j2ee6p02" => {"sc-prd-p02-01-8080" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"rolled-back" => true
}}}
}},
"int-prd-j2ee-bs-04-8480" => {"host" => {
"svrl1j2ee6p01" => {"sc-prd-p01-04-8480" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"rolled-back" => true
}}},
"svrl1j2ee6p02" => {"sc-prd-p02-04-8480" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"rolled-back" => true
}}}
}},
"prd-intern-soa-00" => {"host" => {
"svrl1soa6p51" => {"sc-prd-p51-00" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"rolled-back" => true
}}},
"svrl1soa6p52" => {"sc-prd-p52-00" => {"response" => {
"outcome" => "failed",
"result" => undefined,
"rolled-back" => true
}}}
}}
}
}
- Is there any way to allow changes to active datasources without a restart ?
Environment
- RedHat JBoss Enterprise Application Platform (EAP)
- 6.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.