1 2 Previous Next 15 Replies Latest reply on Oct 26, 2018 12:19 PM by rareddy

    Data Sources Missing - Data Source Creation Error

    rakeshjain1

      Hello Experts,

       

      I have connected to flat file and the xml file and created two Tables successfully. After selecting one of the the table, I am clicking on the running man icon, it is giving two consecutive errors:

       

      Error1:

       

      Data Sources Missing

      Required data sources are not deployed on the server. Do you wish to create them?

       

      After clicking on Yes.

      Error2

      Data Source Creation Error

      A data source with the JNDI name "java:/ProductTxtSourceModel_DS" failed to deploy.

       

      Please advise.

       

      Thanks

      Rakesh Jain

        • 1. Re: Data Sources Missing - Data Source Creation Error
          rareddy

          Sometimes Designer gets out of sync and has these kinds of issues. If you right click and select "modeling" on left side window, you have options to create datasource. Do that and see if that helps. If not delete the data source and re-create it.

          • 2. Re: Data Sources Missing - Data Source Creation Error
            rakeshjain1

            Hello Ramesh,

            Datasource is now created, after selecting on the empinfo table and clicking on the running man icon, it is showing the sql query in the Custom Preview Data dialog box, once I click OK, it is again giving two consecutive errors:

            Error 1

            VDB Deployment Error

            Error occured during the deployment of VDB:

            PREVIEW-76c50c2f-826e-40db-a7ba-b4b097eeb46b

             

             

            Error 2

            Error Creating JDBC connection

            Validate the JDBC username and password in the default Teiid Instance.

            See log for more information.

             

             

            Under Teiid Instance, Test Administration Connection is working on port 9999(mm://localhost:9999)

            Whereas Test JDBC Connection is giving error like Unable to establish a jdbc connection to server

            I tried various combinations of user name and pwd and port, but still not working.

            Even while creating the data source Test connection was failing to ping.

            Please advise.

            Thanks

            Rakesh Jain

            • 3. Re: Data Sources Missing - Data Source Creation Error
              rareddy

              After you installed the server did you create any users? if not you would need to use "/bin/adduser.sh" or "/bin/adduser.bat" script to add an "application" user first. Then use those same credentials in JDBC Connection panel in the Designer nad make sure that works correctly as without it preview will NOT work.

               

              Ramesh..

              • 4. Re: Data Sources Missing - Data Source Creation Error
                rakeshjain1

                Hi Ramesh,

                 

                I have created the application user using the command add-user.bat. and used the same credentials on the Teiid Instance for JDBC Connection.

                On clicking the Test Administration connection, it is giving OK, however on clicking Test JDBC Connection, it is giving the below error.:

                Unable to establish a jdbc connection to server

                “jdbc:teiid:ping@mm://localhost:31000”

                 

                Please advise.

                Thanks

                Rakes Jain

                • 5. Re: Data Sources Missing - Data Source Creation Error
                  rareddy

                  There should be another error reasoning why the connection did not succeed. Please post it.

                  • 6. Re: Data Sources Missing - Data Source Creation Error
                    rakeshjain1

                    Hi Ramesh,

                     

                    There is not error as such, below is what I am getting in the console :

                     

                    19:45:51,457 INFO  [org.jboss.as.repository] (management-handler-thread - 9) JBAS014900: Content added at location C:\jbossdata\eap64\standalone\data\content\fc\f324141fb233a0401624dc0982576eb4a8fed2\content

                    19:45:51,490 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "ping-vdb.xml" (runtime-name: "ping-vdb.xml")

                    19:45:51,712 INFO  [org.jboss.as.server] (management-handler-thread - 9) JBAS015859: Deployed "ping-vdb.xml" (runtime-name : "ping-vdb.xml")

                    19:45:52,834 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015877: Stopped deployment ping-vdb.xml (runtime-name: ping-vdb.xml) in 3ms

                    19:45:53,096 INFO [org.jboss.as.repository] (management-handler-thread - 9) JBAS014901: Content removed from location C:\jbossdata\eap64\standalone\data\content\fc\f324141fb233a0401624dc0982576eb4a8fed2\content

                    19:45:53,097 INFO  [org.jboss.as.server] (management-handler-thread - 9) JBAS015858: Undeployed "ping-vdb.xml" (runtime-name: "ping-vdb.xml")

                     

                     

                    • 7. Re: Data Sources Missing - Data Source Creation Error
                      rakeshjain1

                      JDBC Test connection

                      • 8. Re: Data Sources Missing - Data Source Creation Error
                        rakeshjain1

                        Hi Ramesh,

                         

                        I have executed the below steps to create the application user:

                        1.Type the command add-user and hit the Enter key.

                        2.This time when prompted, enter the single letter b, which will allow you to add an

                        application user, specifically, the user user.

                        3.When prompted with Username:, enter user and hit the Enter key.

                        4.When prompted with Password:, enter an appropriate password (must be at least 8

                        characters, have at least 1 alphabetic character, at least 1 digit, and at least 1 nonalphanumeric

                        symbol). When done, hit the Enter key.

                        5.When asked What groups do you want this user to belong to?, just hit the Enter key.

                        6.When asked Is this correct yes/no?, enter in yes and hit the Enter key.

                        7.When asked Is this new user going to be used for one AS process to connect to another

                        AS process?, enter in no and hit the Enter key.

                        8.At this point, you will be asked to press any key to continue. Doing so will bring you back to

                        the command prompt.

                        9.Exit out of the command prompt.

                         

                        After creating the application user, I have added that in the Teiid Instance under JBDC Test Connection.But still the same issue on the Error Log:

                        Error Log :

                        The teiid driver failed to connect to jdbc:teiid:PREVIEW-52594f1f-a19b-47da-84aa-e146e45b561c@mm://localhost:31000 with the given username and password

                        Stack Trace:

                        1. java.lang.Exception: The teiid driver failed to connect to jdbc:teiid:PREVIEW-52594f1f-a19b-47da-84aa-e146e45b561c@mm://localhost:31000 with the given username and password

                                        at org.teiid.datatools.connectivity.TeiidJDBCConnection.connect(TeiidJDBCConnection.java:45)

                                        at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:126)

                                        at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

                                        at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

                         

                         

                        • 9. Re: Data Sources Missing - Data Source Creation Error
                          rareddy

                          How are you starting the server? In the server installation in "standalone/logs/server.log" there will be more details.

                          • 10. Re: Data Sources Missing - Data Source Creation Error
                            rakeshjain1

                            Hi Ramesh,

                             

                            In the server.log file I am getting the below error:

                             

                            17:09:15,496 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss Red Hat JBoss Data Virtualization 6.4.0 (AS 7.5.18.Final-redhat-1) started in 4455ms - Started 245 of 283 services (62 services are lazy, passive or on-demand)

                            17:09:41,609 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 4) JBAS014612: Operation ("read-attribute") failed - address: ([{"subsystem" => "teiid"}]): org.jboss.msc.service.ServiceNotFoundException: Service service jboss.teiid.query-engine not found

                            at org.jboss.msc.service.ServiceContainerImpl.getRequiredService(ServiceContainerImpl.java:627) [jboss-msc-1.1.7.SP1-redhat-1.jar:1.1.7.SP1-redhat-1]

                            at org.jboss.as.controller.OperationContextImpl$OperationContextServiceRegistry.getRequiredService(OperationContextImpl.java:1774) [jboss-as-controller-7.5.18.Final-redhat-1.jar:7.5.18.Final-redhat-1]

                            at org.teiid.jboss.TeiidOperationHandler.getService(TeiidOperationHandler.java:134)

                            at org.teiid.jboss.TeiidOperationHandler.getService(TeiidOperationHandler.java:108)

                            • 11. Re: Data Sources Missing - Data Source Creation Error
                              rareddy

                              That shows that you never installed Teiid on the Wildfly server you are using. What installation scripts you followed?

                              • 12. Re: Data Sources Missing - Data Source Creation Error
                                rakeshjain1

                                Hi Ramesh,

                                 

                                Below are the high level steps I have followed:

                                1. Install JDK 1.8 and setup the path variable

                                2. Install apache-maven-3.5.4-bin and setup the path variable

                                3. Install/run the command -> java -jar jboss-dv-6.4.0-installer.jar

                                4. Install/run the command -> java -jar devstudio-11.0.0.GA-installer-standalone.jar

                                5. Install Teiid Designer software from Jboss developer studio using the zip file -> jbosstools-teiid-designer-11.1.0.Final-updatesite

                                6. Add jar file h2.jar and Test the database connection

                                7. Create the application user using add-user.bat

                                8. Configure the Data Virtualization server as Teiid default server and in Teiid Instance, test the administration connection with admin user and JDBC Test connection using application user.

                                 

                                All software/tools versions I have followed as indicated above. It is working fine in my personal laptop. I am able to create the teiid model project, connect the flat file and preview the table.

                                Whereas when I am trying the same in the company laptop or desktop, it is failing on the third step above.

                                 

                                Is there any installation scripts that you can share.

                                 

                                Thanks

                                Rakesh Jain

                                • 13. Re: Data Sources Missing - Data Source Creation Error
                                  rareddy

                                  What is the error in step (3)?

                                  • 14. Re: Data Sources Missing - Data Source Creation Error
                                    rakeshjain1

                                    It is saying Processing Failed, below is the complete error log:

                                     

                                    IzPack variable state written to C:\jbossdatanew\installation\InstallationLog.txt

                                    Successfully moved source: C:\jbossdatanew\bin\jboss-cli.bat to destination: C:\jbossdatanew\bin\jboss-cli-COPY.bat

                                    Running command:[C:\jbossdatanew\bin\jboss-cli-COPY.bat, "patch apply C:\jbossdatanew\jboss-eap-6.4.9-patch.zip"]

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    {

                                        "outcome" : "success",

                                        "result" : {}

                                    }

                                    Exit code: 0

                                    Command success: [C:\jbossdatanew\bin\jboss-cli-COPY.bat, "patch apply C:\jbossdatanew\jboss-eap-6.4.9-patch.zip"] completed successfully.

                                    Running command:[C:\jbossdatanew\bin\jboss-cli-COPY.bat, "patch apply C:\jbossdatanew\jboss-eap-6.4.18-patch.zip"]

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    {

                                        "outcome" : "success",

                                        "result" : {}

                                    }

                                    Exit code: 0

                                    Command success: [C:\jbossdatanew\bin\jboss-cli-COPY.bat, "patch apply C:\jbossdatanew\jboss-eap-6.4.18-patch.zip"] completed successfully.

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    Exit code: 0

                                    Command completed successfully.

                                    Replacing text: com.sun.script.javascript.RhinoScriptEngineFactory with text: jdk.nashorn.api.scripting.NashornScriptEngineFactory in file:

                                    C:\jbossdatanew/modules/system/layers/base/sun/jdk/main/service-loader-resources/META-INF/services/javax.script.ScriptEngineFactory

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    Exit code: 0

                                    Command completed successfully.

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    Exit code: 0

                                    Command completed successfully.

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    Exit code: 0

                                    Command completed successfully.

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    Exit code: 0

                                    Command completed successfully.

                                    Starting operation: -genseckey with keystore: C:\jbossdatanew\vault.keystore

                                     

                                     

                                    Warning:

                                    The JCEKS keystore uses a proprietary format. It is recommended to migrate to PKCS12 which is an industry standard format using "keytool -importkeystore -srckeystore C:\jbossdatanew/vault.keystore -destkeystore C:\jbossdatanew/vault.keystore -deststoretype pkcs12".

                                    Operation: -genseckey with keystore: C:\jbossdatanew\vault.keystore was successful.

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    Exit code: 0

                                    Command completed successfully.

                                    JBOSS_HOME adjusted to: C:\jbossdatanew

                                    Starting standalone Server using .xml config.

                                    Calling "C:\jbossdatanew\bin\standalone.conf.bat"

                                    JAVA_HOME is not set. Unexpected results may occur.

                                    Set JAVA_HOME to the directory of your local JDK to avoid this message.

                                    ===============================================================================

                                     

                                     

                                      JBoss Bootstrap Environment

                                     

                                     

                                      JBOSS_HOME: "C:\jbossdatanew"

                                     

                                     

                                      JAVA: "java"

                                     

                                     

                                      JAVA_OPTS: "-verbose:gc -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=5 -XX:GCLogFileSize=3M -XX:-TraceClassUnloading -XX:+UseCompressedOops -Dprogram.name=standalone.bat -Xms1G -Xmx1G -XX:MaxPermSize=256M -Djava.net.preferIPv4Stack=true  -Djboss.modules.policy-permissions=true  -Djboss.modules.system.pkgs=org.jboss.byteman"

                                    ===============================================================================

                                    18:18:16,609 INFO  [org.jboss.modules] (main) JBoss Modules version 1.3.10.Final-redhat-1

                                    18:18:17,335 INFO  [org.jboss.msc] (main) JBoss MSC version 1.1.7.SP1-redhat-1

                                    18:18:17,567 INFO  [org.jboss.as] (MSC service thread 1-7) JBAS015899: JBoss Red Hat JBoss Data Virtualization 6.4.0 (AS 7.5.18.Final-redhat-1) starting

                                    Waiting for server to be ready. This could take up to 40 seconds.

                                    .

                                    .

                                    18:18:22,677 INFO  [org.xnio] (MSC service thread 1-7) XNIO Version 3.0.16.GA-redhat-1

                                    18:18:22,689 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)

                                    18:18:22,713 INFO  [org.xnio.nio] (MSC service thread 1-7) XNIO NIO Implementation Version 3.0.16.GA-redhat-1

                                    18:18:23,117 INFO  [org.jboss.remoting] (MSC service thread 1-7) JBoss Remoting version 3.3.12.Final-redhat-1

                                    18:18:23,154 INFO  [org.jboss.as.remoting] (MSC service thread 1-6) JBAS017100: Listening on 127.0.0.1:9999

                                    18:18:23,477 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management

                                    18:18:23,479 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015954: Admin console is not enabled

                                    [ Server code detected: JBAS015874 ]

                                    Application Server successfully started.

                                    Trying to connect to Management Interface...(1/5).

                                    Connected to Management Interface.

                                    jboss.server.data.dir = C:\jbossdatanew\standalone\data

                                    jboss.home.dir = C:\jbossdatanew

                                    Trying to connect to Management Interface...(1/5).

                                    Connected to Management Interface.

                                    Script C:\jbossdatanew\cli-scripts\disable-welcome-root.cli ran successfully.

                                    Trying to connect to Management Interface...(1/5).

                                    Connected to Management Interface.

                                    Advanced configuration command failed: undefined

                                    {

                                        "outcome" => "failed",

                                        "failure-description" => "JBAS014749: Operation handler failed: org.jboss.as.server.services.security.VaultReaderException: org.jboss.security.vault.SecurityVaultException: java.lang.RuntimeException: PBOX000140: Unable to get keystore (C:\\jbossdatanew/vault.keystore)",

                                        "rolled-back" => true,

                                        "command" => undefined

                                    }

                                    Running on-fail server check.

                                    Shutting server down.

                                    Trying to connect to Management Interface...(1/5).

                                    Connected to Management Interface.

                                    Application Server successfully stopped.

                                    Successfully moved source: C:\jbossdatanew\standalone\log\server.log to destination: C:\jbossdatanew\installation\server-logs

                                    The configured source file: C:\jbossdatanew\domain\log\host-controller.log doesn't exist.

                                    The configured source file: C:\jbossdatanew\domain\log\process-controller.log doesn't exist.

                                    1 2 Previous Next