Ad Widget

Collapse

Value should be a JSON object - UNDERLINE character

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • avecch
    Junior Member
    • Sep 2018
    • 1

    #1

    Value should be a JSON object - UNDERLINE character

    Good Morning

    I am getting a JSON validation error in the following result:

    {
    "data":[
    { "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "BI01" },
    { "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "CIGAM01" },
    { "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "META01" },
    { "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL03", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL03", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL04", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL04", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "CIGAM05" },
    { "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "CIGAMTESTE05" },
    { "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "magicxpi_1" },
    { "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "MGXPI4_1" },
    { "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAM06" },
    { "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAMBI06" },
    { "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAMHOMOLOGACAO06" },
    { "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAM07" },
    { "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAMHOMOLOGACAO07" },
    { "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAMTESTE07" },
    { "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAM08" },
    { "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAMHOMOLOGACAO08" },
    { "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAMTESTE08" },
    { "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "CIGAM09" },
    { "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "CIGAM10" },
    { "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "CIGAM11" },
    { "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "CIGAM12" },
    { "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "CIGAMHOMOLOGACAO12" },
    { "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "CIGAM13" },
    { "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAM02" },
    { "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAMHOMOLOGACAO02" },
    { "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAMTESTE02" },
    { "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "CIGAM14" },
    { "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "msdb" },
    { "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "CIGAM15" },
    { "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "master" },
    { "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "msdb" }
    ]}


    I have this same discovery rule on other servers and all are working, the only difference I noticed in this case was the underline in the name of some bases. Is that the problem? If it is, how to solve? I can not change the base name ...

    My Zabbix is in version: 3.4

    thanks a lot for any help.
Working...