OHDSI Home | Forums | Wiki | Github

WebAPI Installation problem

Hi.

I am trying to install WebAPI and ATLAS in my server and following the instruction of WebAPI Installation Guide in Wiki.
In Tomcat, deploy the war file. This should automatically create a large number of tables in the webapi schema. But in my case, this did not create tables in the webapi schema. And, I cannot find out any differences in sql server database before and after deployment of the war file.
Here I send the script of deployment of .war file.
Thank you
Yeesuk

C:\Users\Administrator\WebAPI>mvn clean package -s WebAPIConfig/settings.xml -P webapi-mssql
[INFO] Scanning for projects…
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building WebAPI 1.0.0-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] — maven-clean-plugin:2.5:clean (default-clean) @ WebAPI —
[INFO] Deleting C:\Users\Administrator\WebAPI\target
[INFO]
[INFO] — maven-resources-plugin:2.6:resources (default-resources) @ WebAPI —
[INFO] Using ‘UTF-8’ encoding to copy filtered resources.
[INFO] Copying 1 resource
[INFO] Copying 398 resources
[INFO] Copying 1 resource
[INFO] Copying 0 resource
[INFO]
[INFO] — maven-compiler-plugin:2.5.1:compile (default-compile) @ WebAPI —
[INFO] Compiling 354 source files to C:\Users\Administrator\WebAPI\target\classes
[INFO]
[INFO] — maven-resources-plugin:2.6:testResources (default-testResources) @ WebAPI —
[INFO] Using ‘UTF-8’ encoding to copy filtered resources.
[INFO] Copying 1 resource
[INFO]
[INFO] — maven-compiler-plugin:2.5.1:testCompile (default-testCompile) @ WebAPI —
[INFO] Compiling 7 source files to C:\Users\Administrator\WebAPI\target\test-classes
[INFO]
[INFO] — maven-surefire-plugin:2.18.1:test (default-test) @ WebAPI —
[INFO] Tests are skipped.
[INFO]
[INFO] — maven-war-plugin:2.2:war (default-war) @ WebAPI —
[INFO] Packaging webapp
[INFO] Assembling webapp [WebAPI] in [C:\Users\Administrator\WebAPI\target\WebAPI]
[INFO] Processing war project
[INFO] Copying webapp resources [C:\Users\Administrator\WebAPI\src\main\webapp]
[INFO] Webapp assembled in [6081 msecs]
[INFO] Building war: C:\Users\Administrator\WebAPI\target\WebAPI.war
[INFO]
[INFO] — miredot-plugin:1.5.1:restdoc (default) @ WebAPI —
[WARNING] Miredot is unable to document the status codes of rest interfaces, unless a statusCodes-block is specified in pom.xml
[INFO] Building reflective model of API and reading annotations…
[WARNING] Unknown annotation on service method: skipped @javax.annotation.PostConstruct()
[WARNING] Unknown annotation on service method: skipped @javax.transaction.Transactional(value=REQUIRED, rollbackOn=[], dontRollbackOn=[])
[WARNING] Unknown annotation on service method: skipped @javax.transaction.Transactional(value=REQUIRED, rollbackOn=[], dontRollbackOn=[])
[WARNING] Unknown annotation on service method: skipped @javax.transaction.Transactional(value=REQUIRED, rollbackOn=[], dontRollbackOn=[])
[WARNING] Unknown annotation on service method: skipped @javax.annotation.PostConstruct()
[WARNING] Unknown annotation on service method: skipped @javax.transaction.Transactional(value=REQUIRED, rollbackOn=[class java.lang.Exception], dontRollbackOn=[class org.springframework.dao.EmptyResultDataAccessException])
[WARNING] Unknown annotation on service method: skipped @javax.transaction.Transactional(value=REQUIRED, rollbackOn=[], dontRollbackOn=[])
[WARNING] Unknown annotation on service method: skipped @javax.transaction.Transactional(value=REQUIRED, rollbackOn=[], dontRollbackOn=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=true, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=true, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.context.annotation.Bean(name=[], initMethod=, destroyMethod=(inferred), value=[], autowire=NO)
[WARNING] Unknown annotation on service method: skipped @javax.transaction.Transactional(value=REQUIRED, rollbackOn=[], dontRollbackOn=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=true, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=true, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @org.springframework.transaction.annotation.Transactional(propagation=REQUIRED, rollbackForClassName=[], readOnly=false, isolation=DEFAULT, transactionManager=, noRollbackForClassName=[], noRollbackFor=[], value=, timeout=-1, rollbackFor=[])
[WARNING] Unknown annotation on service method: skipped @javax.transaction.Transactional(value=REQUIRED, rollbackOn=[], dontRollbackOn=[])
[INFO] Built.
[INFO] Reading javadoc comments from sourcefiles…
[INFO] Read.
[INFO] Merging reflective and javadoc models…
[WARNING] Limited support for jdk8 (@link, @see, @linkplain javadoc tags won’t format properly)
[INFO] Merged.
[INFO] Performing issue analysis…
[INFO] Analysis done.
[INFO] Constructing Html documentation
[WARNING] Could not find html intro file file: miredot.htmlintro.html
[INFO] MireDot: Completed
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 21.938 s
[INFO] Finished at: 2018-01-21T07:01:12+09:00
[INFO] Final Memory: 53M/295M
[INFO] ------------------------------------------------------------------------

Hi @estone96
I am facing an issue while deploying the war of webapi on tomcat. When i deployed i got a sqlserver error on startup logs.

Are you using sqlserver as your database? If yes what changes did you make in settings.xml file and the pom file?

t