Bom dia

Estou tentando realizar a instalação do citsmart e não estou conseguindo, o erro acontece no deploy da aplicação. Todas as configurações indicadas foram seguidas.

Qual versão do Citsmart você está fazendo a instalação?

R - citsmart_install_RH7_JB7_x86_64_V2.tar

Qual versão do seu BD?

R - postgresql 9.0

Qual ambiente (32Bits ou 64 Bits)?

R - 64 bits 

Qual SO (Linux ou Windows)?

R - Windows 7

Segue o erro:

 16:30:36,946 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) JBAS010404: Deploying non-JDBC-compliant driver class org.postgresql.Driver (version 9.1)

16:30:36,966 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) JBAS010400: Bound data source [java:/jdbc/citsmart]

16:30:37,081 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015876: Starting deployment of "citsmart-VC4R0.9-JB7.war"

16:31:34,749 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_cs.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,751 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_de_DE.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,753 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_es.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,755 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_fr.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,757 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_hu.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,759 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_it.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,761 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_ja_JP.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,763 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_ko_KR.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,764 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_pl.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,766 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_pt_BR.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,767 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_ru.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,769 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_zh_CN.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,771 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry derbyLocale_zh_TW.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/derby-10.5.3.0_1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,775 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry xbean.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/js-1.6R7.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,780 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry commons-beanutils.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/struts-1.2.9.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,782 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry commons-digester.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/struts-1.2.9.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,783 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry commons-fileupload.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/struts-1.2.9.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,785 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry commons-logging.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/struts-1.2.9.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,786 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry commons-validator.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/struts-1.2.9.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,788 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry jakarta-oro.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/struts-1.2.9.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,789 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry xercesImpl.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/xalan-2.5.1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,791 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) Class Path entry xml-apis.jar in "/D:/JavaTools/jboss-as-7.1.1/bin/content/citsmart-VC4R0.9-JB7.war/WEB-INF/lib/xalan-2.5.1.jar"  does not point to a valid jar for a Class-Path reference.

16:31:34,980 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015893: Encountered invalid class name 'org.xmlpull.mxp1.MXParser,org.xmlpull.mxp1_serializer.MXSerializer' for service type 'org.xmlpull.v1.XmlPullParserFactory'

16:31:34,989 INFO  [org.jboss.as.pojo] (MSC service thread 1-5) JBAS017000: Found legacy bean/pojo namespace: urn:jboss:bean-deployer:2.0 - might be missing some xml features (potential exceptions).

16:31:35,938 WARN  [org.jboss.jaxrs] (MSC service thread 1-6) JBAS011204: resteasy.scan found and ignored in web.xml. This is not necessary, as Resteasy will use the container integration in the JAX-RS 1.1 specification in section 2.3.2

16:31:36,073 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-6) JBAS010403: Deploying JDBC-compliant driver class org.apache.derby.jdbc.AutoloadedDriver (version 10.5)

16:31:36,082 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-6) JBAS010403: Deploying JDBC-compliant driver class com.microsoft.sqlserver.jdbc.SQLServerDriver (version 4.0)

16:31:36,191 INFO  [stdout] (MSC service thread 1-6) CITSMART --->>>> INICIANDO... 

16:31:36,204 INFO  [stdout] (MSC service thread 1-6) :::::: CITCorporeUtil.CAMINHO_SERVIDOR ---> 

16:31:36,205 INFO  [stdout] (MSC service thread 1-6) CITSMART - CAMINHO DA APP: D:/JavaTools/jboss-as-7.1.1/standalone/tmp/vfs/tempb89a0a2f1c4f4bca/citsmart-VC4R0.9-JB7.war-aa79661cba62ccb9/

16:31:36,206 INFO  [stdout] (MSC service thread 1-6) CITSMART - CAMINHO DO CONFIG: D:/JavaTools/conf/citsmart.cfg

16:31:36,207 INFO  [stdout] (MSC service thread 1-6) CITSMART - CAMINHO DA CONFIG: D:/JavaTools/conf/citsmart.cfg - ARQUIVO NAO EXISTE!!!!!!!!!!!!!!!!!!!! ASSUMINDO CONFIGURACOES PADRAO...

16:31:36,208 INFO  [stdout] (MSC service thread 1-6) CITSMART - START_MODE_INVENTORY: null - (true)

16:31:36,208 INFO  [stdout] (MSC service thread 1-6) CITSMART - START_MODE_DISCOVERY: null - (true)

16:31:36,209 INFO  [stdout] (MSC service thread 1-6) CITSMART - START_MODE_RULES: null - (true)

16:31:36,210 INFO  [stdout] (MSC service thread 1-6) CITSMART - START_MODE_ITSM: null - (true)

16:31:36,211 INFO  [stdout] (MSC service thread 1-6) CITSMART - NATIVE_PING: null - (true)

16:31:36,211 INFO  [stdout] (MSC service thread 1-6) CITSMART - PING_TIMEOUT: null - (6000)

16:31:36,213 INFO  [stdout] (MSC service thread 1-6) CITSMART - NUM_THREADS_DISCOVERY: null - (5)

16:31:36,215 INFO  [stdout] (MSC service thread 1-6) CITSMART - NUM_THREADS_INVENTORY: null - (1)

16:31:36,215 INFO  [stdout] (MSC service thread 1-6) CITSMART - JDBC_ALIAS_INVENTORY: null - ()

16:31:36,216 INFO  [stdout] (MSC service thread 1-6) CITSMART - JDBC_ALIAS_REPORTS: null - ()

16:31:36,217 INFO  [stdout] (MSC service thread 1-6) CITSMART - IP_RANGE_DISCOVERY: null - ()

16:31:36,217 INFO  [stdout] (MSC service thread 1-6) CAMINHO SERVER: 

16:31:36,356 INFO  [stdout] (MSC service thread 1-6) CITSMART --->>>> SGBD DA CONEXAO PRINCIPAL: postgres

16:31:36,381 INFO  [stdout] (MSC service thread 1-6) CITSMART - Executando rotina de scripts... iniciando.

16:31:36,715 INFO  [stdout] (MSC service thread 1-6) CITFRAMEWORK --->>>> IDENTIFICANDO O SGBD: POSTGRES

16:31:36,718 INFO  [stdout] (MSC service thread 1-6) XmlReadDBItemConvertion :: InputStream ioos IS NULL!!!

16:31:36,734 SEVERE [br.com.citframework.integracao.JdbcEngine] (MSC service thread 1-6) SQL ERROR:  select IDVERSAO,NOMEVERSAO,IDUSUARIO from VERSAO where NOMEVERSAO = ? 

parameters: 2.0.4, 

*** ERROR: ERRO: coluna "nomeversao" não existe

  Posição: 18: org.postgresql.util.PSQLException: ERRO: coluna "nomeversao" não existe

  Posição: 18

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)

at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

at br.com.citframework.integracao.JdbcEngine.execSQL(JdbcEngine.java:86) [classes:]

at br.com.citframework.integracao.PersistenceEngine.findNotNull(PersistenceEngine.java:267) [classes:]

at br.com.citframework.integracao.CrudDaoDefaultImpl.find(CrudDaoDefaultImpl.java:92) [classes:]

at br.com.centralit.citcorpore.integracao.VersaoDao.buscaVersaoPorNome(VersaoDao.java:25) [classes:]

at br.com.centralit.citcorpore.negocio.ScriptsServiceEjb.executaRotinaScripts(ScriptsServiceEjb.java:107) [classes:]

at br.com.centralit.citcorpore.util.CorporeContextListener.contextInitialized(CorporeContextListener.java:236) [classes:]

at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:3392) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.StandardContext.start(StandardContext.java:3850) [jbossweb-7.0.13.Final.jar:]

at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_21]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_21]

at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_21]

Autor: Luis Alberto Santos de Sousa