JSON validation error for special characters inbwagent_db.json andbwagent_as.json .

JSON validation error for special characters inbwagent_db.json andbwagent_as.json .

book

Article ID: KB0092913

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
In BW6.x, If the values in bwagent_db.json and bwagent_as.json contain some special characters and they are not enclosed in double quotes, then you will hit a validation error.


Here is sample entry : 

dbpassword: abcd#123

This entry will throw the Validation error.



Symptoms:
Validation error : 

TIBCO-BW-ADMIN-CLI-500043: Failed to configure bwagent, <CausedBy> Invalid input file. Not a proper JSON file, <CausedBy> org.codehaus.jettison.json.JSONException: Expected a ',' or '}' at character 4
33 of {
adminmode: enterprise,
adminpersistencetype: dbems,
httpport: 8079,
httphost: 0.0.0.0,
httpaccesslogconfig: bwagent-access.xml,
teaagenthost: 0.0.0.0,
teaagentport: 9091,
bwagentnetworkname: BW6Network,
membername: "tsvcsl201uat.fmrco.com",
db: true,
dbtype: oracle,
dbdriver: "oracle.jdbc.OracleDriver",
dbconnectionurl: "jdbc:oracle:thin:@asdbsl17dev.fmrco.com:1521:CSD11UTF",
dbuser: IDS_MDDMFT,
dbpassword: abcd\\#123,
emsserverurl: "tcp://tsmdsl01qa.fmrco.com:7222",
emsusername: admin,
tea: true,
teaserverurl: "http://%HOSTADDRESS%:8777/tea",
governanceenabled: false,
governancejmsserverurl: "tcp://localhost:7222",
governancejmsusername: admin,
governancejmsuserpassword: "",
governancejmsstoretype: JKS,
governancejmsstorelocation: "",
governancejmsstorepassword: "",
governancejmsreconnectcount: 120,
governancejmsreconnecttimeout: 500,
governancejmsreconnectdelay: 500,
governancejmsqueuepdreceivername: "governance.de.bw.default"
}


Cause:
JSON parser requires it.

Resolution

If any value has special characters, such as a pond sign ("#"), then enclose the value in double quotes. For example: dbpassword: "abcd#123"

Issue/Introduction

JSON validation error for special characters inbwagent_db.json andbwagent_as.json .