Question
Infosys
IN
Last activity: 1 Jul 2021 15:52 EDT
Index-DataAgents is not having any records in Pega 8.4.4
Hi Team,
We are using the below java code to get the agent lists to check whether the Agent is enabled/ Disabled on a particular node in our earlier pega version 7.1.9. It was working in Pega 7 because index-dataagents has records, but recently we migrated to pega 8 where we are seeing issue with the below code
I raised an SR and got to know that this class 'index-dataagents' is deprecated after pega version 7.2 Could you please help me for any alternate solution here. The purpose of that code is to get Agents which are in Disabled status as an email , so that team can check the email and make that Agent enabled before business starts or during business hours
StringBuilder SQL = new StringBuilder(); SQL.append("SELECT da.pyNodeName AS \"pyNodeName\", da.pyEnableAgent AS \"pyEnableAgent\", da.pyAgentName AS \"pyAgentName\" ") .append("FROM {CLASS:Index-DataAgents} da , {CLASS:System-Status-Nodes} ssn") .append(" WHERE UPPER(da.pyNodeName) = UPPER(ssn.pySysNodeID) AND UPPER(ssn.pySystemName) = '" ) .append(clustername.toUpperCase()).append("'");
final ClipboardPage listPage = tools.getThread().createPage("Index-DataAgents", "agentData"); listPage.putString("pyObjClass", "Index-DataAgents"); listPage.putString("pyMaxRecords", String.valueOf(0));
Hi Team,
We are using the below java code to get the agent lists to check whether the Agent is enabled/ Disabled on a particular node in our earlier pega version 7.1.9. It was working in Pega 7 because index-dataagents has records, but recently we migrated to pega 8 where we are seeing issue with the below code
I raised an SR and got to know that this class 'index-dataagents' is deprecated after pega version 7.2 Could you please help me for any alternate solution here. The purpose of that code is to get Agents which are in Disabled status as an email , so that team can check the email and make that Agent enabled before business starts or during business hours
StringBuilder SQL = new StringBuilder(); SQL.append("SELECT da.pyNodeName AS \"pyNodeName\", da.pyEnableAgent AS \"pyEnableAgent\", da.pyAgentName AS \"pyAgentName\" ") .append("FROM {CLASS:Index-DataAgents} da , {CLASS:System-Status-Nodes} ssn") .append(" WHERE UPPER(da.pyNodeName) = UPPER(ssn.pySysNodeID) AND UPPER(ssn.pySystemName) = '" ) .append(clustername.toUpperCase()).append("'");
final ClipboardPage listPage = tools.getThread().createPage("Index-DataAgents", "agentData"); listPage.putString("pyObjClass", "Index-DataAgents"); listPage.putString("pyMaxRecords", String.valueOf(0));
try { tools.getThread().getDatabase() .executeRDB(SQL.toString(), listPage); } catch (DatabaseException e) { oLog.error("Failed while fetching data agents - "+e.toString()); }
***Edited by Moderator Kayla to update Platform Capability tags***