The following error is displayed in application server log:
IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
Caused by: java.net.SocketException: Connection reset
When using an Oracle database, the following information is printed after enabling extra logging:
Caused by: java.lang.IllegalStateException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATABASECHANGELOGLOCK (ID INTEGER NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:oracle:thin:@ipaddress:port/sid INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, 0): ORA-01950: no privileges on tablespace 'APPIAN01'
Note: The logging is increased in appian_log4j.properties located in <APPIAN_HOME>/ear/suite.ear/resources by setting log4j.logger.liquibase=DEBUG.
The user configured for that data source does not have privileges to allocate an extent in the specified tablespace.
Grant the user the appropriate system privileges or grant the user space resource on the tablespace by running one of the following commands (these commands are specific to Oracle; consult your DBA for commands specific to your RDBMS):
ALTER USER <username> QUOTA 100M ON <tablespace name>;
GRANT UNLIMITED TABLESPACE TO <username>;
This article applies to all versions of Appian using Oracle as a database.
Last Reviewed: February 2017
© 2021 Appian. All rights reserved.