4 Replies Latest reply on Apr 25, 2014 2:42 PM by Ramesh Reddy

    teiid admin api createdatasource not working in 8.7

    ravi katkar Newbie

      While adding a datasource using teiid admin api createdatasource getting below error messages, its was working fine in 8.6 but fails in 8.7

       

      below is the data-source details

      <?xml version="1.0" encoding="UTF-8"?>

      <connection-factories>

         <no-tx-connection-factory>

            <jndi-name>-EXAMPLE-FILE-DS-my</jndi-name>

            <rar-name>custom-connector-2.0.0-SNAPSHOT.rar</rar-name>

            <connection-definition>com.ca..my-custom.VirtualFileManagedConnectionFactory</connection-definition>                  

            <config-property name="ParentDirectory"

                     type="java.lang.String">1.0/metadata/</config-property>           

          </no-tx-connection-factory>

      </connection-factories>

       

       

       

      25 Apr 2014 11:45:24,685 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-7)  IJ020001: Required license terms for file:/C:/EUI_latest/parent/server/chorus-server-run/target/chorus/jboss/modules/system/layers/base/com/ca/chorus/translators/teiid-connector-virtual-file/main/./

      25 Apr 2014 11:45:25,065 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-8)  IJ020001: Required license terms for file:/C:/EUI_latest/parent/server/chorus-server-run/target/chorus/jboss/modules/system/layers/base/com/ca/chorus/translators/teiid-connector-virtual-file/main/./

      25 Apr 2014 11:45:25,071 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-8)  MSC000001: Failed to start service jboss.ra.deployment.SDK-CITY-EXAMPLE-FILE-DS-my_1: org.jboss.msc.service.StartException in service jboss.ra.deployment.SDK-CITY-EXAMPLE-FILE-DS-my_1: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [SDK-CITY-EXAMPLE-FILE-DS-my]

        at org.jboss.as.connector.services.resourceadapters.deployment.ResourceAdapterXmlDeploymentService.start(ResourceAdapterXmlDeploymentService.java:131)

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

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

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

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

        at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]

      Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [SDK-CITY-EXAMPLE-FILE-DS-my]

        at org.jboss.as.connector.services.resourceadapters.deployment.ResourceAdapterXmlDeploymentService.start(ResourceAdapterXmlDeploymentService.java:115)

        ... 5 more

      Caused by: org.jboss.jca.deployers.common.DeployException: IJ020060: Unable to inject: org.teiid.virtualfile.VirtualFileManagedConnectionFactory property: jndi-name value: SDK-CITY-EXAMPLE-FILE-DS-my

        at org.jboss.jca.deployers.common.AbstractResourceAdapterDeployer.createObjectsAndInjectValue(AbstractResourceAdapterDeployer.java:1913)

        at org.jboss.as.connector.services.resourceadapters.deployment.ResourceAdapterXmlDeploymentService$AS7RaXmlDeployer.doDeploy(ResourceAdapterXmlDeploymentService.java:183)

        at org.jboss.as.connector.services.resourceadapters.deployment.ResourceAdapterXmlDeploymentService.start(ResourceAdapterXmlDeploymentService.java:108)

        ... 5 more

       

       

      25 Apr 2014 11:45:25,080 INFO  [org.jboss.as.controller] (management-handler-thread - 18)  JBAS014774: Service status report

      JBAS014777:   Services which failed to start:      service jboss.ra.deployment.SDK-CITY-EXAMPLE-FILE-DS-my_1: org.jboss.msc.service.StartException in service jboss.ra.deployment.SDK-CITY-EXAMPLE-FILE-DS-my_1: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [SDK-CITY-EXAMPLE-FILE-DS-my]

       

       

      25 Apr 2014 11:45:25,085 IST ERROR [com.ca.chorus.cfar.DataSourceDeploymentHandler] (Worker9_QueryProcessorQueue177) ETJCF010E Error occured while adding the data source ERROR msg :TEIID70006 {"JBAS014671: Failed services" => {"jboss.ra.deployment.SDK-CITY-EXAMPLE-FILE-DS-my_1" => "org.jboss.msc.service.StartException in service jboss.ra.deployment.SDK-CITY-EXAMPLE-FILE-DS-my_1: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [SDK-CITY-EXAMPLE-FILE-DS-my]

          Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [SDK-CITY-EXAMPLE-FILE-DS-my]

        • 1. Re: teiid admin api createdatasource not working in 8.7
          Steven Hawkins Master

          Are you sure that is the XML config?  Based upon:

           

          ... org.teiid.virtualfile.VirtualFileManagedConnectionFactory property: jndi-name value: SDK-CITY-EXAMPLE-FILE-DS-my

           

          It seems like your config has jndi-name as a config property:

           

          <?xml version="1.0" encoding="UTF-8"?>

          <connection-factories>

             <no-tx-connection-factory>

                ...

                <config-property name="jndi-name"

                         type="java.lang.String">SDK-CITY-EXAMPLE-FILE-DS-my</config-property>

              </no-tx-connection-factory>

          </connection-factories>

           

          It also looks like you are using an org.teiid package for custom code, which should be avoided if possible.

          • 2. Re: teiid admin api createdatasource not working in 8.7
            ravi katkar Newbie

            below is the connection

            <connection-factories>

               <no-tx-connection-factory>

                  <jndi-name>-EXAMPLE-FILE-DS-my</jndi-name>

                  <rar-name>custom-connector-2.0.0-SNAPSHOT.rar</rar-name>

                  <connection-definition> org.teiid.virtualfile.VirtualFileManagedConnectionFactory</connection-definition>                 

                  <config-property name="ParentDirectory"

                           type="java.lang.String">1.0/metadata/</config-property>          

                </no-tx-connection-factory>

            </connection-factories>

             

            jnid-name is not part of config property.

             

            this was working fine in teiid 8.6 but fails in 8.7

            • 3. Re: teiid admin api createdatasource not working in 8.7
              Steven Hawkins Master

              I still don't see where the "SDK-CITY-EXAMPLE-FILE-DS-my" value is coming from.  Since this is directly from the JCA layer, I don't think this would have anything to do with 8.7 vs. 8.6.  Can you revalidate with 8.6?  And did you make any platform/AS changes between the two versions.

              • 4. Re: teiid admin api createdatasource not working in 8.7
                Ramesh Reddy Master

                Are you sure it worked in 8.6? that does not look like the configuration at all in the JBoss 7.x and Teiid 8.x. It is more looks like JBoss 5.x forat which Teiid 7.x based on.

                 

                If you are deploying "-ds.xml" file from that era, that will not work with Admin API "createDatasource" method.