Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
31 replies
Answers
1 answer
Subscribers
6 subscribers
Views
14599 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Trying to install Appian 7.10 standalone .Getting error while starting JBOSS.
RajHasti
over 10 years ago
Trying to install Appian 7.10 standalone .Getting error while starting JBOSS.
An unexpected error occurred while trying to initialize and validate the primary data source. (APNX-1-4179-004)
Caused by: javax.persistence.PersistenceException: Unable to build EntityManagerFactory
Caused by: org.hibernate.HibernateException: Could not find datasource
Caused by: javax.naming.NameNotFoundException: jdbc/AppianPrimaryDS -- service jboss.naming.context.java.jdbc.AppianPrimaryDS
Please check attached zip file for all the configuration followed as well as I followed following link also
forum.appian.com/.../Configuring_Relational_Databases.html
Followed all the steps mentioned in the installation guide.
Not sure why this error is getting triggered.Any help.
appian710.zip
OriginalPostID-166464
OriginalPostID-166464
Discussion posts and replies are publicly visible
0
RajHasti
over 10 years ago
log file
server.log
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jonathan Katora
Appian Employee
over 10 years ago
I haven't looked over everything, but your standalone.xml file is missing the h2 driver in the datasource subsystem in the profiles tag. I can't remember if this will throw your error or not. Also, check the security subsystem datasource hashed password. Your pwd has a negative symbol in it's expression. This would through a data source error in you app server log
Additionally, the apian-MySQL-ds.xml file you provided defines the primary and business schema as apppian_primarydata and appian_businessdata respectively. Can you confirm that this is the name of you schema on your local RDBMS.
Last thing, I noticed that you said you were installing Appian 7.10, but referenced the 7.9 product docs. Are you using the configure script? If not, I would recommend using the Quick Start tutorial found in the 710 docs. It contains step-by-step instructions how to perform a local install using the configure script:
forum.appian.com/.../Quick_Start_Installation_Guide_for_Windows_and_JBoss.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jim Schweitzer
Certified Lead Developer
over 10 years ago
Check to see if a appian-ds.xml.undeployed file (or any other .marker file) got created in the standalone/deployments folder. If so, delete it and try starting again.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
RajHasti
over 10 years ago
@Jonathan - thanks for the response
1.I did followed the jboss configurations listed in the below link for 7.10 https://forum.appian.com/suite/help/7.10/Configuring_Relational_Databases.html#For_JBoss
2.Yes,apppian_primary and appian_businessdata are respective schema names in my local sql server
3.Encoded password that generated by the utility has negative symbol,so I used the same
4.I followed all the instructions given in the link https://forum.appian.com/suite/help/7.10/Quick_Start_Installation_Guide_for_Windows_and_JBoss.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
RajHasti
over 10 years ago
@Jim - thanks for the reply - I deleted appian-ds.xml.undeployed file and restarted the server ..this time I did nt recieve datasource errors...but this time I got following errors -
01:51:03,149 INFO [stdout] (ServerService Thread Pool -- 79) com.appiancorp.kougar.driver.exceptions.SafeRetryException: Unable to acquire a Read connection. Safe to retry.
When i do http://usl03396.persistent.co.in:8080/suite in browser ...it gives me JBWEB000065: HTTP Status 404 - /suite
Please check my latest servler.log file
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
RajHasti
over 10 years ago
latest Server log file
server.log
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
+1
RajHasti
over 10 years ago
Caused by: com.appiancorp.kougar.driver.exceptions.SafeRetryException: Unable to acquire a Read connection. Safe to retry.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
You first need to fix the "Unable to acquire a Read connection. Safe to retry." error. This error indicates your app server is unable to communicate with the engines. Remember you need to start the engines first.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
RajHasti
over 10 years ago
My Appian engines are running fine..
C:\\appian\\appian710\\server\\_scripts>start-suite.bat
k3.lic
New Appian Engine Monitor process has been started.
C:\\appian\\appian710\\search-server\\bin>start.bat
Calling start.conf.bat
SS_JAVA_OPTS: -Xms1024m -Xmx1024m -XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -Djava.awt.headless=tr
Appian Search Server process has been started.
Any I restarted everything ...Now i am getting datasource exceptions
server.log
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
RajHasti
over 10 years ago
Caused by: javax.persistence.PersistenceException: Unable to build EntityManagerFactory
Caused by: org.hibernate.HibernateException: Could not find datasource
Caused by: javax.naming.NameNotFoundException: jdbc/AppianPrimaryDS -- service jboss.naming.context.java.jdbc.AppianPrimaryDS
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>