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
8 subscribers
Views
11957 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 8 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 8 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 8 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 8 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 8 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 8 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 8 years ago
latest Server log file
server.log
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
+1
RajHasti
over 8 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 8 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 8 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 8 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
>