Same Generic SQL Agent not working in other host - Foglight for Databases - Foglight for Databases - Dell Community

Same Generic SQL Agent not working in other host

Same Generic SQL Agent not working in other host

This question is not answered

Hi all,

I have a interesting situation here.

We had created a Generic SQL agent in our development host with a list of queries(30 sql statements). Now we created the same agent with same queries in other(UAT) host. Ideally it should give the same results as in our development host but unfortunately its collecting data only for 1 query.Thus we can see only 1 table which is working fine.

We have also depolyed the functions in development host database to the UAT host and also checked if the sql statements are returning data, which they do as in the development host.

One more thing I would like to mention is that we have also created a new agent in our development host with same queries but this time its pointing to the UAT database and its collecting the data properly and all the tables are available in that agent.

Could anyone please help me out on this if they have faced the same issue or have any knowledge on this topic?

Also I would like to know whether there is any setting by which the agent only returns 1 table?

All Replies
  • Please reply to this question...Its highly important for me

  • Parikshit,

    Are there any messages in the agent log on your UAT environment?

    Are there any difference between the 2 Foglight server environments?

    The trouble here is the Generic SQL Agent is technically an unsupported custom agent. So we are left to figure this out on our own.

    </Ryan>

  • The logs are proper and their is no difference in the server environments .

    Only once there was an error for 10 min that the agent is running unexpectedly. Tats it ...no other difference or error.

    Thanks,

    Parikshit

  • We use the Generic SQL Agent extensively in our envirorment. We've found that the best way to use this agent is using it run Stored Procedures on the server, which returns values to the FMS. This works perfect as per our requirements.

  • @sin

    Even we have used functions on the server, which returns values to the FMS and its working perfect for us also but in dev host and not in UAT host.

    Can you tell us about the way you deploy your agent on other host? May be that will give us some hint....

    Thanks,

    Parikshit

  • We just add the GSQL agent onto the SQL database servers as agents (prod/uat/dev databases) and then use the JDBC connect string to connect to the database. Within the ASP's we use the execute stored proc name and then the return values that matches the topology objects.

    How are you guys connecting ?

  • Even we do the same thing. But what I am asking is how do you use the same agent in uat and prod?

    Do you create the same agent in uat and prod manually or use a script or any other technique?

  • We use the different agents. We create the agents manually and they report into different FMSs. It's the same method we use in both environments

  • Hi all,

    I just deleted the agent permanently and recreated it again with the same name and this time it worked....

    Dont know the reason yet but happy that it worked.

  • Hi sin/brian,

    Now that I have created the agent (properly working) in UAT do I have to go in each and every view(which collects the data from the generic sql agent) which was deployed through a cartridge file and change the data in it or it gets automatically done.

    Name of both the agents is same, only host name is changed but still the views are giving error as

    "An error has occured. Please check your logs."

    Please let me know at the earliest.

    Thanks,

    Parikshit

  • If the (custom) view is generating an message like "An error has occured. Please check your logs", it usually means that the view is expecting information to be present in the data model, but the expected information is not there.

    But as the message says, you should check the FMS log to determine the nature of the error.

    You can view and download the FMS log from the (Foglight) Management Server/Diagnostic/Log Analyzer dashboard.

    You can post a screenshot of the view that says "An error has occured" together with the exception trace from the logs and the definition of the WCF view that triggers the error.

    Regards,

    Brian Wheeldon

  • I am getting the below errors in the log....Can you tell me where the problem is and how it can be solved...

    # Time Severity Source Description

    16,007 Tue, 2011-06-07 11:26:44.494 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_Feed_count

    15,877 Tue, 2011-06-07 11:26:44.493 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_Feed_count

    14,533 Tue, 2011-06-07 11:26:44.490 ERROR [http-0.0.0.0-8200-111] com.quest.wcf.components.table2.BaseRowTable com.quest.wcf.portal.components.table.TableModelException: com.quest.wcf.portal.components.tree.TreeModelException: com.quest.wcf.core.module.runtimevalue.RuntimeValueException: com.quest.wcf.data.DataSourceException: com.quest.nitro.service.topology.TopologyObjectNotFoundException: Topology Object Not Found: 81ae7413-575c-488c-a6b1-f1b3c3d8fa3a in view: 'system:ib_reconhub_cmdr.13' in top-level view: 'system:ib_reconhub_cmdr.158' for user: 'foglight'

    6,552 Tue, 2011-06-07 11:26:44.327 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_Feed_endtime

    6,421 Tue, 2011-06-07 11:26:44.327 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_Feed_breach

    6,290 Tue, 2011-06-07 11:26:44.326 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_Feed_breach

    6,159 Tue, 2011-06-07 11:26:44.326 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_Defensive_check

    6,028 Tue, 2011-06-07 11:26:44.325 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key cmdr_defensive_check

    5,766 Tue, 2011-06-07 11:26:44.324 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_defensive_check

    5,635 Tue, 2011-06-07 11:26:44.322 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_Feed_count

    5,504 Tue, 2011-06-07 11:26:44.322 WARN [http-0.0.0.0-8200-111] com.quest.wcf.portal.viewcomponents.BaseViewComponent Error evaluating runtime value in context entry with key CMDR_Feed_count

    4,150 Tue, 2011-06-07 11:26:44.294 ERROR [http-0.0.0.0-8200-111] com.quest.wcf.components.table2.BaseRowTable com.quest.wcf.portal.components.table.TableModelException: com.quest.wcf.portal.components.tree.TreeModelException: com.quest.wcf.core.module.runtimevalue.RuntimeValueException: com.quest.wcf.data.DataSourceException: com.quest.nitro.service.topology.TopologyObjectNotFoundException: Topology Object Not Found: 81ae7413-575c-488c-a6b1-f1b3c3d8fa3a in view: 'system:ib_reconhub_cmdr.158' for user: 'foglight'

    3,792 Tue, 2011-06-07 11:25:47.753 WARN [http-0.0.0.0-8200-32] com.quest.wcf.core.module.ModuleManager Found more than one function marked as a converter from type "foglight-5:Double" to type "wcf:Severity", ignoring definition: system:ib_reconhub_cmdr.140 (CMDR_FEED_COUNT)

  • The log file is telling you that there is something wrong with the this view:

    'system:ib_reconhub_cmdr.13'

    The view appears to have context keys with the following names:

    CMDR_Feed_count

    CMDR_Feed_endtime

    CMDR_Feed_breach

    CMDR_Defensive_check

    cmdr_defensive_check

    CMDR_defensive_check

    These keys are not resolving properly in the context of the data returned by your custom agent.

    In addition, there is a function "system:ib_reconhub_cmdr.140" that converts a Double to a Severity that may be faulty or a duplicate of an existing function.

    It's not clear if the source of the problem is invalid data coming from your custom Generic SQL agent, or a (set of) invalid definitions in the custom WCF module "system:ib_reconhub_cmdr".

    I would recommend some consulting services to sort out the mess.

    Regards,

    Brian Wheeldon

  • Hello everybody!

    COuld you tell me where I can find this agent (Generic SQL Cartrige)? 

  • Hello everybody!

    Got the cartrige, but have an issue with delivering metrics to FMS.

    So I have small query like this one

    SELECT AttributeSyntax.OmSyntax, AttributeSyntax.ValueTypeID

      FROM ChangeAuditor11.[Event].AttributeSyntax AttributeSyntax

    WHERE     (AttributeSyntax.OmSyntax = 22)

    Which returns the next output

    I use this mapping

    OmSyntax:String.id,ValueTypeID:count

    But when I looking for this data in data browser, I can see only Table has been created without any metrics from database.

    Thanks in advance for your help