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

georgep169 over 8 years ago

Hello,

When trying to bring up one of our appian environments we are getting these type of errors :

09:11:45,681 INFO [stdout] (ServerService Thread Pool -- 86) Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for jdbc/AppianBusinessDS

09:11:45,685 INFO [stdout] (ServerService Thread Pool -- 86) Caused by: java.sql.SQLException: ORA-28000: the account is locked

09:11:45,697 INFO [stdout] (ServerService Thread Pool -- 86) 2016-05-27 09:11:45,697 [ServerService Thread Pool -- 86] WARN com.appiancorp.rdbms.config.UserDataSourcesConfig - Invalid data source: jdbc/AppianBusinessDS: The data source is not accessible: [APNX-2-4054-000{jdbc/AppianBusinessDS,Cannot connect to the database.}]

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

We can access the DB trough SQL Developer with the same config settings as in our appia...

Discussion posts and replies are publicly visible

Parents

0 georgep169 over 8 years ago

...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-...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 georgep169 over 8 years ago

...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-...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data