10 Replies Latest reply on Jan 6, 2016 8:07 AM by Alaa Alarfaj

    Error in deploying a data source

    Alaa Alarfaj Newbie

      Hello everyone.

       

      I am trying to deploy a data source file but I am getting the following error:

       

      ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"crc-ds.xml\".PARSE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"crc-ds.xml\".PARSE: Failed to process phase PARSE of deployment \"crc-ds.xml\""}}}}

       

      What does this mean?

       

      Thanks a lot

      Alaa

        • 1. Re: Error in deploying a data source
          Wolfgang Mayer Master

          You should find some more messages in the server.log which give some more details to the root cause.

          What kind of data source are you deploying? Did you make sure that the JDBC driver is installed?

          • 2. Re: Error in deploying a data source
            Alaa Alarfaj Newbie

            First, In the server.log:

             

            INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "crc-ds.xml"

            ERROR [org.jboss.msc.service.fail] (MSC service thread 1-7) MSC00001: Failed to start service jboss.deployment.unit."crc-ds.xml".PARSE: org.jboss.msc.service.StartException in service jboss.deployment.unit."crc-ds.xml".PARSE: Failed to process phase PARSE of deployment "crc-ds.xml"

                at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45]

                at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]

            Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: Received non-all-whitespace CHARACTERS or CDATA event in nextTag(). at [row,col {unknown source}]: [95,0]

                at org.jboss.as.connector.deployers.processors.DsXmlDeploymentParsingProcessor.deploy(DsXmlDeploymentParsingProcessor.java:85)

                at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]

                ... 5 more

            Caused by: com.ctc.wstx.exc.WstxParsingException: Received non-all-whitespace CHARACTERS or CDATA event in nextTag(). at [row,col {unknown-source}]: [95,0]

                at com.ctc.wstx.sr.StreamScanner.constructWfcException(StreamScanner.java:606)

                at com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:479)

                at com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:464)

                at com.ctc.wstx.sr.BasicStreamReader.nextTag(BasicStreamReader.java:1137)

                at org.jboss.jca.common.metadata.ds.DsParser.parseDataSources(DsParser.java:145)

                at org.jboss.jca.common.metadata.ds.DsParser.parse(DsParser.java:119)

                at org.jboss.jca.common.metadata.ds.DsParser.parse(DsParser.java:82)

                at org.jboss.as.connector.deployers.processors.DsXmlDeploymentParsingProcessor.deploy(DsXmlDeploymentParsingProcessor.java:80)

                ... 6 more

            INFO  [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015877: Stopped deployment crc-ds.xml in 54ms

            INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015870: Deploy of deployment "crc-ds.xml" was rolled back with failure message {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"crc-ds.xml\".PARSE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"crc-ds.xml\".PARSE: Failed to process phase PARSE of deployment \"crc-ds.xml\""}}

            INFO  [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report

            JBAS014777:   Services which failed to start:      service jboss.deployment.unit."crc-ds.xml".PARSE: org.jboss.msc.service.StartException in service jboss.deployment.unit."crc-ds.xml".PARSE: Failed to process phase PARSE of deployment "crc-ds.xml"

             

            ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"crc-ds.xml\".PARSE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"crc-ds.xml\".PARSE: Failed to process phase PARSE of deployment \"crc-ds.xml\""}}}}

             

            Second, I am trying install i2b2 platform that contain many plug-in cells. Each cell has a data source file. The following is the data source file for the cell that I want to deploy:

             

            <datasource jta="false" jndi-name="java:/CRCBootStrapDS"

                    pool-name="CRCBootStrapDS" enabled="true" use-ccm="false">

                    <connection-url>jdbc:sqlserver://localhost:1433;databaseName=i2b2hive</connection-url>

                    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

                    <driver>sqljdbc4.jar</driver>

                    <security>

                        <user-name>i2b2hive</user-name>

                        <password>demouser</password>

                    </security>

                    <validation>

                        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>

                        <validate-on-match>false</validate-on-match>

                    </validation>

                    <statement>

                        <share-prepared-statements>false</share-prepared-statements>

                    </statement>

                </datasource>

                <datasource jta="false" jndi-name="java:/QueryToolDemoDS"

                    pool-name="QueryToolDemoDS" enabled="true" use-ccm="false">

                    <connection-url>jdbc:sqlserver://localhost:1433;databaseName=i2b2demodata</connection-url>

                    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

                    <driver>sqljdbc4.jar</driver>

                    <security>

                        <user-name>i2b2demodata</user-name>

                        <password>demouser</password>

                    </security>

                    <validation>

                        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>

                        <validate-on-match>false</validate-on-match>

                    </validation>

                    <statement>

                        <share-prepared-statements>false</share-prepared-statements>

                    </statement>

                </datasource>

             

            Third, How can I test the JDBC installation?

             

            Thank you

            Alaa

            • 3. Re: Error in deploying a data source
              Wolfgang Mayer Master

              In your log you should find entries like:

               

              FLYJCA0005: Deploying non-JDBC-compliant driver ...

              INFO  .... WFLYJCA0018: Started Driver service with driver-name = ...

               

              The driver should either be installed as module or as deployment JDBC Driver / DataSource Setup | HAL Management Console

              You may also check via jboss-cli if your driver is successfully installed:

              For example enter /subsystem=datasources/jdbc-driver=

              then press the tab-key.

              • 4. Re: Error in deploying a data source
                Alaa Alarfaj Newbie

                Sorry but, I am new to JBOSS.

                Where shall I enter /subsystem=datasources/jdbc-driver=?


                Thank you

                Alaa

                • 5. Re: Error in deploying a data source
                  Wolfgang Mayer Master

                  For configuring / analyzing the application server JBoss (Wildfly) provides as well an online tool (web console) as a command line tool (jboss-cli).

                  If you are new to JBoss (WildFly) you should first get a general understanding.

                  A good starting point might be to read the documentation (Documentation - WildFly 9 - Project Documentation Editor)

                  Which version are you using?

                  • 7. Re: Error in deploying a data source
                    Jay SenSharma Master

                    [Received non-all-whitespace CHARACTERS or CDATA event in nextTag(). at [row,col {unknown-source}]: [95,0]]

                     

                    The parsing error indicates that your XML is not correct.  You need to really check if there is any hidden character in your crc-ds.xml file.  Specially the line number  "95" is the culprit.  (even though the pasted XML snippet is having less than 95 lines,  But i am suspecting that there is some special character in your XML file please check carefully)

                     

                    Your datasource XML(crc-ds.xml) does not have the root element as <datasources></datasources>  in the "crc-ds.xml" file.

                    It does not look right.

                     

                    Can you try creating a fresh DataSource file as following and see if it works:

                     

                    <datasources xmlns="http://www.jboss.org/ironjacamar/schema">
                        <datasource jta="false" jndi-name="java:/CRCBootStrapDS" pool-name="CRCBootStrapDS" enabled="true" use-ccm="false">
                            <connection-url>jdbc:sqlserver://localhost:1433;databaseName=i2b2hive</connection-url>
                            <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                            <driver>sqljdbc4.jar</driver>
                            <security>
                                <user-name>i2b2hive</user-name>
                                <password>demouser</password>
                            </security>
                            <validation>
                                <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>
                                <validate-on-match>false</validate-on-match>
                            </validation>
                            <statement>
                                <share-prepared-statements>false</share-prepared-statements>
                            </statement>
                        </datasource>
                        <datasource jta="false" jndi-name="java:/QueryToolDemoDS" pool-name="QueryToolDemoDS" enabled="true" use-ccm="false">
                            <connection-url>jdbc:sqlserver://localhost:1433;databaseName=i2b2demodata</connection-url>
                            <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                            <driver>sqljdbc4.jar</driver>
                            <security>
                                <user-name>i2b2demodata</user-name>
                                <password>demouser</password>
                            </security>
                            <validation>
                                <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>
                                <validate-on-match>false</validate-on-match>
                            </validation>
                            <statement>
                                <share-prepared-statements>false</share-prepared-statements>
                            </statement>
                        </datasource>
                    </datasources>
                    

                     

                    Also make sure that the "sqljdbc4.jar"  is placed inside the "deployments" directory of your JBossAS7

                     

                     

                     

                     

                    Regards

                    Jay SenSharma

                    • 8. Re: Error in deploying a data source
                      Alaa Alarfaj Newbie

                      Thank you for replying Jay.

                      My data source is correct but I did not copy the first line in the file in this post.

                      sqljdbc4.jar in inside the deployment folder.

                       

                      Thank you

                      • 9. Re: Error in deploying a data source
                        Jay SenSharma Master

                        This issue is because of your -ds.xml  file has some bad characters that is causing the issue here.  That's what JBossAS7 is also reporting

                        [Received non-all-whitespace CHARACTERS or CDATA event in nextTag(). at [row,col {unknown-source}]: [95,0]]

                         

                        If you really want this issue to get solved soon, then either paste the complete datasource here Or better attach the file to this thread so that we can have a look at whats special in your XML which is causing the parsing failure.

                        • 10. Re: Error in deploying a data source
                          Alaa Alarfaj Newbie

                          The problem is solved. There was a --> character in the end of the data source file and I did not see it.

                          The data source is deployed successfully.


                          Thanks all.

                          Alaa