Hello, When trying to bring up one of our appian environments we are

...n-ds.xml file but not being able to connect to the data stored with the deployed config.

------------------------------------------------------------------------------------------------------------------------

This is our appian-ds.xml file :


<datasources
xmlns:xsi="www.w3.org/.../XMLSchema-instance"
xsi:noNamespaceSchemaLocation="www.jboss.org/.../datasources_1_0.xsd">
<xa-datasource
jndi-name="jdbc/AppianPrimaryDS"
pool-name="AppianPrimaryDS"
use-java-context="false">
<xa-datasource-property name="URL">jdbc:oracle:thin:@xxxxx.xxxx.com:25881:xxxxxx</xa-datasource-property>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<driver>oracle.jdbc</driver>
<security>
<security-domain>AppianPrimaryDS-security</security-domain>
</security>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<xa-pool>
<min-pool-siz...

...e>5</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</xa-datasource>
<xa-datasource
jndi-name="jdbc/AppianBusinessDS"
pool-name="AppianBusinessDS"
use-java-context="false">
<xa-datasource-property name="URL">xxxxx.xxxx.com:25881:xxxxxx</xa-datasource-property>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<driver>oracle.jdbc</driver>
<security>
<security-domain>AppianBusinessDS-security</security-domain>
</security>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<xa-pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-...

... timeout-minutes>
</timeout>
</xa-datasource>
</datasources>

------------------------------------------------------------------------------------------------------------------------


09:12:51,456 INFO [stdout] (ServerService Thread Pool -- 86) Caused by: HornetQException[errorType=SECURITY_EXCEPTION message=HQ119031: Unable to validate user: null]

09:13:26,814 INFO [stdout] (ServerService Thread Pool -- 86) 2016-05-27 09:13:26,814 [ServerService Thread Pool -- 86] ERROR com.appiancorp.common.initialize.PingJMS - Could not send ping to JMS: javax.jms.JMSSecurityException: HQ119031: Unable to validate user: null

09:13:50,850 ERROR [org.hornetq.core.server] (Old I/O server worker (parentId: -1785487551, [id: 0x95939f41, /0.0.0.0:5445])) HQ224018: Failed to create session: HornetQException[errorType=SECURITY_EXCEPTION message=HQ119031: Unable to validate user: null]

In the application-roles.properties file the guest=guest is also present.

We've cleaned t...

... he jboss tmp and data folders and retried. Situation remains the same.

09:12:51,456 INFO [stdout] (ServerService Thread Pool -- 86) Caused by: HornetQException[errorType=SECURITY_EXCEPTION message=HQ119031: Unable to validate user: null]

09:13:26,814 INFO [stdout] (ServerService Thread Pool -- 86) 2016-05-27 09:13:26,814 [ServerService Thread Pool -- 86] ERROR com.appiancorp.common.initialize.PingJMS - Could not send ping to JMS: javax.jms.JMSSecurityException: HQ119031: Unable to validate user: null

09:13:50,850 ERROR [org.hornetq.core.server] (Old I/O server worker (parentId: -1785487551, [id: 0x95939f41, /0.0.0.0:5445])) HQ224018: Failed to create session: HornetQException[errorType=SECURITY_EXCEPTION message=HQ119031: Unable to validate user: null]

Unable to get managed connection for jdbc/AppianBusinessDS means that you have run out of database connection. You can ask DBA to either kill the database connections or restart the database. This should temporarily resolve the issue. If you have installed plugins, check for connection leaks.

The relevant error is:

Caused by: java.sql.SQLException: ORA-28000: the account is locked

that is the reason why you cannot get more connections. The DBA needs to unlock user that you specified in standalone.xml as part of security-domain AppianBusinessDS-security

Good catch Eduardo! I missed that.

I will check with the DBA admins today. Thanks Eduardo