Highlighted
Honored Contributor.
Honored Contributor.
111 views

Universal Discovery: MySQL Connection by SQL

We use HP uCMDB 10.11.CUP4 build: 410, CP 15

 

MySQL Connection by SQL fails with

 

< Progress message, Severity: Error>>
Failed executing script, details: Traceback (most recent call last):
  File "<string>", line 2, in <module>
  File "SQL_Connection", line 429, in DiscoveryMain
java.lang.NullPointerException

java.lang.NullPointerException: java.lang.NullPointerException

 

We want to discover a MySQL Database running on Windows Win2k8 R2.

 

We cannot find this Discovery Job in the Documentation

0 Likes
4 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Universal Discovery: MySQL Connection by SQL

Hello Sanjit,

 

I hope you are doing well .

 

Please review this guide https://softwaresupport.hp.com/group/softwaresupport/search-result/-/facetsearch/document/KM00642633 .  This guide has all the information of this job .

 

Best Regards ,

Melissa Carranza Mejias
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation. “
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Universal Discovery: MySQL Connection by SQL

Hi,

 

Can you please attach the entire comunication log to review it.

 

Thanks,

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: Universal Discovery: MySQL Connection by SQL

Thanks Melissa, I know this document, but I cannot find the information about "MySQL Connection by SQL" in it.

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: Universal Discovery: MySQL Connection by SQL

Communication Log is here:

 

<execution jobId="MySQL Connection by SQL" destinationid="bfca88c7416939153ac275687f38230c" max_store_sent_results="2147483647">
    <destination>
        <destinationData name="id">bfca88c7416939153ac275687f38230c</destinationData>
        <destinationData name="application_ip">NA</destinationData>
        <destinationData name="sid">NA</destinationData>
        <destinationData name="ip_address">192.168.105.91</destinationData>
        <destinationData name="sa_port">3306</destinationData>
        <destinationData name="application_port">NA</destinationData>
        <destinationData name="sa_ip">192.168.105.91</destinationData>
    </destination>
    <params>
        <param param_name="maxThreadRuntime" param_value="900000" />
        <param param_name="protocolType" param_value="mysql" />
        <param param_name="taskType" param_value="runNowRecordResults" />
        <param param_name="JOB_ID" param_value="MySQL Connection by SQL" />
    </params>
    <log start="09:51:11" severity="info">Execution current time:2015/04/13 09:51:11</log>
    <log start="09:51:12" severity="info">Execution current time:2015/04/13 09:51:12</log>
</execution>

 

 

Error is here:

 

< Progress message, Severity: Error>>
Failed executing script, details: Traceback (most recent call last):
  File "<string>", line 2, in <module>
  File "SQL_Connection", line 429, in DiscoveryMain
java.lang.NullPointerException

java.lang.NullPointerException: java.lang.NullPointerException

 

 

 

Thanks for feedback

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.