Welcome Guest! Log in

Topic-icon Solved Error while testing Log Database connection

  • Shamil
  • Shamil's Avatar Topic Author
  • Away
More
06 Oct 2016 09:26 - 06 Oct 2016 16:44 #1 by Shamil
Error while testing Log Database connection was created by Shamil
I have a new Analytics setup. The first thing I do is to set the Log Database connection. It's an Oracle connection. The user I use to connect is the schema owner.
While testing the connection - following message appears:

Connection to the data source could not be established
Reason: Could not connect to the data source

Java output in attachment.

WHat can be the problem?
Attachments:
Last edit: 06 Oct 2016 16:44 by Shamil.

Please Log in or Create an account to join the conversation.

  • Shamil
  • Shamil's Avatar Topic Author
  • Away
More
06 Oct 2016 10:12 #2 by Shamil
Replied by Shamil on topic Error while testing Log Database connection
Well, what I figured out is that Log Database connection does not work UNLESS I define at least one Runtime O_o

Removing Runtime definition keeps Log Database connection working. This is the behavior of 2.2.0_RC4.

Not blocking anymore :)

Please Log in or Create an account to join the conversation.

More
07 Oct 2016 14:29 #3 by Thomas BLETON
Replied by Thomas BLETON on topic Error while testing Log Database connection
Hi,
This is normal: Analytics tests that the connection to the database works, AND that the Runtime's log tables exist in this database Schema.
At first the tables do not exist.
Once you have setup a Runtime to use this log schema, the Runtime creates the 15 STB_LOG% tables, and Analytics is happy :)

Please Log in or Create an account to join the conversation.