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 ?