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

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

Sign in to reply

Verify Answer

Cancel

Reply

0 georgep169 over 8 years ago

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

Sign in to reply

Verify Answer

Cancel

Children

No Data