Have setup the following: Appian 7.7 w/ JBoss EAP 6.3 + Oracle 11G database

nicholasw over 9 years ago

Have setup the following: Appian 7.7 w/ JBoss EAP 6.3 + Oracle 11G database
Cleared most of the connection/config related hurdles through basic understanding and troubleshooting but stumped on this one:

21:54:37,959 INFO [stdout] (ServerService Thread Pool -- 80) Caused by: com.appiancorp.type.model.DatatypeModelNotFoundException: Type definitions could not be found in the primary data source for the following type ids: 34 (APNX-1-4047-008)

It seems to be missing something when it initializes the DB for the first time which I have no control over.
This repeats everytime and is repeatable after performing the following steps to simulate a fresh install (at least think this works!):

1. Delete _appian\\shared, _appian\\search-local folders
2. Delete <jboss>\\standalone\ mp folders
3. (optional) stop and re-start appian engines - doesn't seem to make a difference...
4. Removed the oracle user and added back in as follows:

*****
DROP U...

application-server.log

Discussion posts and replies are publicly visible

0 nicholasw over 9 years ago

...SER appian7user CASCADE;

create user appian7user identified by <my pwd>
default tablespace USERS temporary tablespace temp;

grant connect, resource, dba, create session to appian7user;
GRANT UNLIMITED TABLESPACE TO appian7user;
******
Have attached full server log.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

This indicates that your design engine is not in sync with your Primary Data Source, probably because of the troubleshooting you've been doing.

Simply create a blank primary DS and re-install Appian now that you have more experience configuring the environment
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nicholasw over 9 years ago

Well, did at fresh install of Appian and copied back in all my config files - started it up and away it went!

The take away from this is that there is clearly a bunch of automated startup which is expecting a happy path and if the installation is not clean - then better to refresh.

Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel