Honored Contributor.. Karlo_Luiten Honored Contributor..
Honored Contributor..
613 views

Partition Manager fails to run: "Sequence ARC_AGENT_ID could not be found."

I have to clean up old partitions, the partitionmanager.log says: "Found more partitions that should be purged as they are outside of the Retention Period (30)!".  Problem is that the partitionmanager fails. Who has an idea?

[oracle@esm bin]$ ./arcsight database pm -i standalone -cn manage

Assuming ARCSIGHT_HOME: /opt/arcsight/database

Assuming JAVA_HOME: /opt/arcsight/database/jre

WARNING: Never run the Partition Manager in STANDALONE mode if the ArcSight Manager is connecting to the same database!

Are you sure you want to continue? (y|n) [n] y

Status: Starting at Fri Jan 31 09:26:35 CET 2014 ...

Status: Initializing configuration ...

Status: The default connection pool has been initialized successfully.

Info: User = sys AS SYSDBA

Info: Connection URL = jdbc:oracle:thin:@10.x.x.94:1521:arcsight

Info: Max Size = 64; Max Idle Time = 5 minutes; Max Checkout Time = 10 minutes; Max Reuse = 30

Status: The event connection pool has been initialized successfully.

Info: User = sys AS SYSDBA

Info: Connection URL = jdbc:oracle:thin:@10.x.x.94:1521:arcsight

Info: Max Size = 64; Max Idle Time = 10 minutes; Max Checkout Time = 10 hours; Max Reuse = 200

Default persistence broker factory: oracle

Initializing data space: [FileSystemDataSpace]

Can not find sree properties in /opt/arcsight/database/reports/sree.properties

Error: Cannot initialize the configuration!

com.arcsight.common.InitializationException: Exception initializing 'com.arcsight.common.persist.PersistenceConfigurationAdapter': Unable to initialize persistence subsystem: Unable to get sequence generator for com.arcsight.event.AgentDescriptor: Sequence ARC_AGENT_ID could not be found.

  at com.arcsight.common.persist.PersistenceConfigurationAdapter.initializePersistence(PersistenceConfigurationAdapter.java:231)

  at com.arcsight.common.persist.PersistenceConfigurationAdapter.initializePersistence(PersistenceConfigurationAdapter.java:117)

  at com.arcsight.tools.database.PartitionManagerHelper.initStandAloneMode(PartitionManagerHelper.java:122)

  at com.arcsight.tools.database.PartitionManagerBase.<init>(PartitionManagerBase.java:263)

  at com.arcsight.tools.database.oracle.OraclePartitionManager.<init>(OraclePartitionManager.java:86)

  at com.arcsight.tools.database.oracle.OraclePartitionManager.main(OraclePartitionManager.java:704)

Caused by: java.lang.IllegalArgumentException: Unable to get sequence generator for com.arcsight.event.AgentDescriptor: Sequence ARC_AGENT_ID could not be found.

  at com.arcsight.common.persist.DBSideTableManagerRegistry.getSideTableManager(DBSideTableManagerRegistry.java:88)

  at com.arcsight.common.introspection.IntrospectorDatabaseHelper.setupCommonFieldTranslators(IntrospectorDatabaseHelper.java:995)

  at com.arcsight.common.persist.DBSecurityEventBrokerBase.setupCommonSecurityEventFieldTranslators(DBSecurityEventBrokerBase.java:3137)

  at com.arcsight.common.persist.DBSecurityEventBrokerBase.<init>(DBSecurityEventBrokerBase.java:429)

  at com.arcsight.common.persist.UnifiedDBSecurityEventBrokerBase.<init>(UnifiedDBSecurityEventBrokerBase.java:34)

  at com.arcsight.common.persist.oracle.OracleSecurityEventBroker.<init>(OracleSecurityEventBroker.java:57)

  at com.arcsight.common.persist.oracle.OracleSecurityEventBroker.<init>(OracleSecurityEventBroker.java:43)

  at com.arcsight.common.persist.oracle.OracleBrokerFactory.getSecurityEventBroker(OracleBrokerFactory.java:466)

  at com.arcsight.common.persist.BrokerFactory.getDefaultSecurityEventBroker(BrokerFactory.java:784)

  at com.arcsight.common.persist.PersistenceConfigurationAdapter.initializePersistence(PersistenceConfigurationAdapter.java:157)

  ... 5 more

Labels (1)
0 Likes
Reply
3 Replies
ramakrshn1 Trusted Contributor.
Trusted Contributor.

Re: Partition Manager fails to run: "Sequence ARC_AGENT_ID could not be found."

Hi Karlo,

Check whether the connector for partition archiver is running or not. Re register the same and restart the connector service from DB server.

then run the partition manager manually.

Regards,

Ramakrishnan

Ramakrishnan E
ArcSight,Splunk,LogRhythm
0 Likes
Reply
Highlighted
njanardhanan@ny1 Absent Member.
Absent Member.

Re: Partition Manager fails to run: "Sequence ARC_AGENT_ID could not be found."

Hi,

Similar the above issue i came across one today on our arcsight manager server.log file can anyone help me in this Error ..

[2014-01-31 09:13:02,629][ERROR][default.com.arcsight.common.simplerulesengine.engine.MultiZoneEngineEntryNode][multiEvaluateThreadLocal]

com.arcsight.common.introspection.dependentvariable.FunctionExecutionException: com.arcsight.common.tuple.TupleException: com.arcsight.common.persist.PersistenceException: Cannot persist a reference with all the attribute values null '<Resource/>'

at com.arcsight.common.introspection.dependentvariable.ServerSessionFunctionField.doFunctionHelper(ServerSessionFunctionField.java:233)

        at com.arcsight.common.introspection.dependentvariable.ServerSessionFunctionField.doFunction(ServerSessionFunctionField.java:175)

        at com.arcsight.common.introspection.dependentvariable.ServerSessionFunctionField.doFunction(ServerSessionFunctionField.java:144)

        at com.arcsight.common.introspection.dependentvariable.FunctionField.doFunction(FunctionField.java:374)

        at com.arcsight.common.introspection.dependentvariable.DependentVariableIntrospector.getValue(DependentVariableIntrospector.java:818)

        at com.arcsight.common.introspection.dependentvariable.DependentVariableIntrospector.getValue(DependentVariableIntrospector.java:778)

        at com.arcsight.common.introspection.IntrospectorBase.isNull(IntrospectorBase.java:337)

        at com.arcsight.common.simplerulesengine.rules.c.isNull(c.java:125)

        at com.arcsight.common.simplerulesengine.engine.n.evaluate(n.java:38)

        at com.arcsight.common.simplerulesengine.engine.CachingBaseConditionNode.evaluate(CachingBaseConditionNode.java:47)

        at com.arcsight.common.simplerulesengine.engine.g.evaluate(g.java:39)

        at com.arcsight.common.simplerulesengine.engine.g.evaluate(g.java:39)

        at com.arcsight.common.simplerulesengine.engine.MultiZoneEngineEntryNode.multiEvaluateThreadLocal(MultiZoneEngineEntryNode.java:79)

        at com.arcsight.server.dashboard.FilterOptimizedMultiCPUCapableDataMonitorProbeConnectable.addEventsToAllQueues(FilterOptimizedMultiCPUCapableDataMonitorProbeConnectable.java:832)

        at com.arcsight.server.dashboard.FilterOptimizedMultiCPUCapableDataMonitorProbeConnectable.onSingleEvent(FilterOptimizedMultiCPUCapableDataMonitorProbeConnectable.java:909)

        at com.arcsight.common.flow.InputConnector.notifyListener(InputConnector.java:119)

        at com.arcsight.common.flow.stock.a.safeNotify(a.java:39)

        at com.arcsight.common.flow.InputConnector.notify(InputConnector.java:163)

        at com.arcsight.common.flow.stock.b.safeSend(b.java:38)

        at com.arcsight.common.flow.OutputConnector.send(OutputConnector.java:130)

        at com.arcsight.rulesengine.RulesEngineConnectable.send(RulesEngineConnectable.java:64)

        at com.arcsight.rulesengine.opsj.OPSJRulesEngine.insert(OPSJRulesEngine.java:1169)

        at com.arcsight.rulesengine.RulesEngineConnectable.onEventList(RulesEngineConnectable.java:139)

        at com.arcsight.common.flow.InputConnector.notifyListener(InputConnector.java:113)

        at com.arcsight.common.flow.stock.a.safeNotifyList(a.java:52)

        at com.arcsight.common.flow.InputConnector.notify(InputConnector.java:158)

        at com.arcsight.common.flow.stock.b.safeSend(b.java:38)

        at com.arcsight.common.flow.OutputConnector.send(OutputConnector.java:130)

        at com.arcsight.common.flow.stock.Processor.onEventList(Processor.java:123)

        at com.arcsight.common.flow.queue.BoundedQueueInputConnector$1.process(BoundedQueueInputConnector.java:69)

        at com.arcsight.common.flow.queue.AsyncEventProcessor$ProcessorThread.run(AsyncEventProcessor.java:334)

Caused by: com.arcsight.common.tuple.TupleException: com.arcsight.common.persist.PersistenceException: Cannot persist a reference with all the attribute values null '<Resource/>'

        at com.arcsight.common.sessionlist.entry.tuple.DefaultSessionListTuple.checkValue(DefaultSessionListTuple.java:96)

        at com.arcsight.common.tuple.DefaultTuple.checkValues(DefaultTuple.java:203)

        at com.arcsight.common.tuple.DefaultTuple.initialize(DefaultTuple.java:141)

        at com.arcsight.common.tuple.DefaultTuple.<init>(DefaultTuple.java:86)

        at com.arcsight.common.sessionlist.entry.tuple.DefaultSessionListTuple.<init>(DefaultSessionListTuple.java:37)

        at com.arcsight.common.introspection.dependentvariable.ServerSessionFunctionField.doFunctionHelper(ServerSessionFunctionField.java:205)

        ... 30 more

Caused by: com.arcsight.common.persist.PersistenceException: Cannot persist a reference with all the attribute values null '<Resource/>'

        at com.arcsight.common.persist.DBResourceReferenceBrokerBase.getPersistedResourceReference(DBResourceReferenceBrokerBase.java:610)

        at com.arcsight.common.tuple.ResourceReferenceID.<init>(ResourceReferenceID.java:74)

        at com.arcsight.common.sessionlist.entry.tuple.DefaultSessionListTuple.checkValue(DefaultSessionListTuple.java:92)

        ... 35 more

Bcoz we are unsure abt the error type!!

Thanks,

naveen.

0 Likes
Reply
njhawar1 Absent Member.
Absent Member.

Re: Partition Manager fails to run: "Sequence ARC_AGENT_ID could not be found."

Naveen,

Were you able to fix the above issue? If yes, can you please share some details please?

Thanks!

0 Likes
Reply
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.