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
7 subscribers
Views
5283 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
HI. I am starting up for the first time the JBoss server. My database is a
sergiod
over 11 years ago
HI.
I am starting up for the first time the JBoss server. My database is a SQL server 2008 and I am using the sqljdbc4.jar. This installation is on Linux.When processing the file "appian-ds.xml" following error occurs.
"10:06:55,459 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "appian-ds.xml"
10:09:31,705 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.suite.ear" is using a private module ("com.sun.jsf-impl:main") which may be changed or removed in future versions without notice.
10:09:31,825 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.suite.ear" is using a private module ("com.sun.jsf-impl:main") which may be changed or removed in future versions without notice.
10:09:32,065 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:...
OriginalPostID-81718
OriginalPostID-81718
Discussion posts and replies are publicly visible
0
sergiod
over 11 years ago
.../usr/local/appian/ear/suite.ear/email-poller.rar/
10:09:32,627 INFO [org.jboss.as.ejb3] (MSC service thread 1-3) JBAS014142: Started message driven bean 'JmsTransientTopicHandlerBean' with 'hornetq-ra' resource adapter
10:09:34,010 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020002: Deployed: file:/usr/local/appian/ear/suite.ear/email-poller.rar/
10:09:34,069 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/usr/local/appian/ear/suite.ear/unattended-request-poller.rar/
10:09:42,293 INFO [stdout] (MSC service thread 1-4) 2013-09-19 10:09:42,293 [MSC service thread 1-4] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Validating and initializing the primary data source: java:/jdbc/Appian_Admin_DS
10:09:43,388 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (MSC service thread 1-4) IJ000604: Throwable while attempting to get a new connection: nu...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sergiod
over 11 years ago
...ll: javax.resource.ResourceException: Could not create connection
at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:447)
.............................................."
Any suggestions??
Thanks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 11 years ago
Most of the above lines are Warnings (Not errors) Your real issue is the last one where it says could not create connection and I believe this is due to some mis-configuration in your DS file. Which version of Appian are you using? Make sure you take an example available on Appian Forum under the correct version of your Appian instance (By default, you'll see the documentation for the latest version of Appian). It is quite likely that your JNDI name is using javaContext=true() and your JNDI name being referenced has java:/jdbc.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sergiod
over 11 years ago
Thanks sathya. In file "appian-ds.xml" i have nex configuration:
<xa-datasource
jndi-name="jdbc/Appian_Admin_DS"
pool-name="SqlServerDS"
use-java-context="false">
On the odre hand in file ../suite.ear/conf/custom.properties I have the following:
conf.data.primary.datasource=java:/jdbc/Appian_Admin_DS
Can you help me, please??
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 11 years ago
Your configuration seems to be correct. The only difference is that I have an additional attribute called enabled="true" after use-java-context attribute.
The next thing to check would be the rest of your config. Check your configuration of the connection parameters are correct and working.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 11 years ago
I'd also recommend you look at this thread
forum.appian.com/.../e-79072
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sergiod
over 11 years ago
Thank you very much. I will look at the thread.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 11 years ago
Sergio, just to add more information to what has been discussed here, I'd like to point out that there's a mismatch between your appian-ds.xml and your custom.properties.
If you look at your appian-ds.xml you will see that you have:
use-java-context="false"
which means you are telling JBoss not to pre-append the "java:" context to your JNDI name, therefore your JNDI name will only be jdbc/Appian_Admin_DS but later in custom.properties you are telling Appian exactly the opposite since you are appending the java: context.
My suggestion would be:
1. Stop JBoss
2. Delete <JBOSS_HOME>\\server\\log
3. Edit custom.properties to look like this
conf.data.primary.datasource=jdbc/Appian_Admin_DS
4. Start JBoss
5. Make sure JBoss is deploying your data source looking at the log from top to bottom and find a line like this:
INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) JBAS010400: Bound data source [jdbc/Appian_Admin_DS]
6. Then review that Appian can "see" this data source by scrolling down and making sure there's no longer an error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sergiod
over 11 years ago
Thank you very much. The problem was that the sql server port was closed at the firewall.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sergiod
over 11 years ago
Hi Eduardo, Can you help me??? Also I have to perform a pre-authentication. The documentation is not very clear on this point. Could you give me information about this?. Any information that might help, paths where I leave the files, which files should be created and how to make them, ......
Many thanks
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>