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

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

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")

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)

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)

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

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.