Education & Training
Services & Support
to create and rate content, and to follow, bookmark, and share content with other members.
Wily DB Schema
Question asked by
on May 4, 2011
on Mar 6, 2013 by TieZheng.Sun
Show 0 Likes
We want to use Wily's record to database capability, wondering if there is a schema that is published that we can use to create the DB tables etc ?
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 4 comments
(Required, will not be published)
May 4, 2011 9:49 PM
Can you give us some details about what you're attempting to do?
Show 1 Like
May 6, 2011 6:32 PM
We want to utilize Wily data extraction feature. We understand it provides Flat File and DB options for that. For DB i.e sending data over to external oracle DB am assuming it would need tables etc to be created ... Wily supported pointed me to "example" folder to look for info. I believe I got something there but once I open the following line in the EM property file
# SQL Database Settings
# Introscope records traced data to a relational database as
# specified here. Comment out these properties
# if you want to turn off database recording
I get class not found on OracleDriver, wondering if I need to supply my own oracle driver ??
Show 0 Likes
May 6, 2011 9:23 PM
Which version of Introscope server your using?. If your using APM 9 you will find all the database drivers in product/enterprisemanager/plugins folder. If the drivers are not there,please copy your driver in this folder and restart the EM.I think it will work.
We are using APM 9 (postgresql) for storing Introscope data into relational database.
Here are the drivers that are present in product/enterprisemanager/plugins folder
Here is the config which i did.
Hope this Info will help.Let me know are you success with this or not.
Show 2 Likes
Mar 6, 2013 9:57 AM
I did the settings as you did. But i can not find anything table or data in postgres db. Need i create some tables in postgres db in advance?
There are some errors in logs as below:
[ERROR] [Database Connection Handler] [Manager.Database] Table WT_VERSIONLIST does not exist in database.
Show 0 Likes
Retrieving data ...
[REPLAY] Improve Planning and Resource Allocation with Capacity Planning + Plan Progression – August 15, 2018
[WEBCAST] Improve Planning and Resource Allocation with Capacity Planning + Plan Progression – August 15, 2018 @1 p.m. ET
Scoreboard nodes doesn't update the count of tickets inside
Scoreboard showing incorrect count
Scoreboard Node count not updated