Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
14 replies
Subscribers
9 subscribers
Views
3215 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Hi, I am trying to install Appian 7.11 on a windows environment. I ha
aswinb93
over 8 years ago
Hi,
I am trying to install Appian 7.11 on a windows environment. I have granted all privileges to my user who is using the MySQL primary database. but I keep getting an error saying that could not modify foreign key constraint on a table called client_cert_chains. I am attaching the server.log file...any help would be deeply appreciated.
server.log
OriginalPostID-174465
OriginalPostID-174465
Discussion posts and replies are publicly visible
0
Alok Mohare
Appian Employee
over 8 years ago
What is the version of MySQL Server you are using?
Per the System Requirements for Appian 7.11, we recommend using MySQL 5.6.x with InnoDB engine.
The following post should help you address this issue:
forum.appian.com/.../e-152223
Hope this helps. Thanks!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aswinb93
over 8 years ago
I updated mysql and mysql connector java to the latest version. But i still get error saying that it cannot add foriegn key to some table. I saw while it was running that it got bounded to all the DB's. I have granted permission to all databases for root and thats the user i am using. Attaching server.log....pls help....thanks,
server.log
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Alok Mohare
Appian Employee
over 8 years ago
What is the version of MySQL Server you are using?
Which MySQL driver are you using?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aswinb93
over 8 years ago
connector j 5.1.37
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Alok Mohare
Appian Employee
over 8 years ago
What is the version of MySQL Server you are using?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aswinb93
over 8 years ago
same....
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Alok Mohare
Appian Employee
over 8 years ago
The latest MySQL Server version is 5.7.9. Is that what you are using?
dev.mysql.com/.../
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Alok Mohare
Appian Employee
over 8 years ago
The support version of MySQL Server for Appian 7.11 is 5.6.X with InnoDB Engine.
That should resolve your issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Alok Mohare
Appian Employee
over 8 years ago
supported*
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aswinb93
over 8 years ago
the latest version of odbc available is 5.3.4 and connector java is 5.1.37 and workbench is 6.3.5....I have all the latest versions.....but still it doesn't work....
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>