0 Replies Latest reply on Oct 18, 2012 8:47 AM by NitroCircus

    Host IPS Property Translator task Failed

    NitroCircus

      Hello,

       

      I recently update the ePO server from 4.5.5 to 4.6.4, since this change the Host IPS Property Translator task is not running ok, the error message at the orion.log is :

       

      2012-10-18 15:11:06,304 ERROR [mfs:pool-2-thread-6] scheduler.Engine  - Traductor de propiedades de IPS de host] failed with exception

      java.util.concurrent.ExecutionException: com.mcafee.orion.core.cmd.CommandException: java.sql.SQLException: Conversion failed when converting the nvarchar value 'False' to data type int.

      at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)

      at java.util.concurrent.FutureTask.get(FutureTask.java:83)

      at com.mcafee.orion.scheduler.Engine.runTasks(Engine.java:348)

      at com.mcafee.orion.scheduler.engine.EngineTask.run(EngineTask.java:57)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)

      at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)

      at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (ScheduledThreadPoolExecutor.java:98)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(ScheduledThreadPoolExecutor.java:180)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Schedu ledThreadPoolExecutor.java:204)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java: 886)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

      at java.lang.Thread.run(Thread.java:662)

      Caused by: com.mcafee.orion.core.cmd.CommandException: java.sql.SQLException: Conversion failed when converting the nvarchar value 'False' to data type int.

      at com.mcafee.entercept.propertytranslator.PropertyTranslator.invoke(PropertyTrans lator.java:74)

      at com.mcafee.orion.core.cmd.CommandInvoker.invoke(CommandInvoker.java:989)

      at com.mcafee.orion.core.cmd.CommandInvoker.invokeCommand(CommandInvoker.java:762)

      at com.mcafee.orion.core.cmd.CommandInvoker.invoke(CommandInvoker.java:751)

      at com.mcafee.orion.core.cmd.CommandInvoker.invoke(CommandInvoker.java:723)

      at com.mcafee.orion.scheduler.chainable.Chain.invokeChain(Chain.java:289)

      at com.mcafee.orion.scheduler.chainable.Chain.invokeChain(Chain.java:314)

      at com.mcafee.orion.scheduler.chainable.Chain.invokeChain(Chain.java:230)

      at com.mcafee.orion.scheduler.chainable.Chain.invoke(Chain.java:42)

      at com.mcafee.orion.core.cmd.CommandInvoker.invoke(CommandInvoker.java:989)

      at com.mcafee.orion.core.cmd.CommandInvoker$AsyncCommandRunner.call(CommandInvoker .java:900)

      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

      at java.util.concurrent.FutureTask.run(FutureTask.java:138)

      ... 3 more

      Caused by: java.sql.SQLException: Conversion failed when converting the nvarchar value 'False' to data type int.

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)

      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)

      at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)

      at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)

      at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)

      at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedState ment.java:504)

      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPre paredStatement.java:102)

      at com.mcafee.entercept.propertytranslator.RuleProcessor.deleteLastRule(RuleProces sor.java:185)

      at com.mcafee.entercept.propertytranslator.FWRuleProcessor.doDeleteLastRule(FWRule Processor.java:127)

      at com.mcafee.entercept.propertytranslator.RuleProcessor.doProcessing(RuleProcesso r.java:85)

      at com.mcafee.entercept.propertytranslator.PropertyTranslator.invoke(PropertyTrans lator.java:65)

      ... 15 more

      2012-10-18 15:11:36,054 ERROR [mfs:pool-2-thread-8] propertytranslator.PropertyTranslator  - com.mcafee.orion.core.cmd.CommandException: java.sql.SQLException: Conversion failed when converting the nvarchar value 'False' to data type int.

       

      The HIPS extension is 7.0.5.106, I tried to solve the problem installing the 8.0.0.563 extensions, but I've had bad luck...