Page tree
Skip to end of metadata
Go to start of metadata
Purpose (problem description)

The page will help you to resolve the error - "SQL Problem: All Analysis units are inactive" when trying to run analysis from AIP Console -

Observed in CAST Version


Release

Yes/No

>1.20.x(tick)
Observed in RDBMS

RDBMS

Yes/No

Oracle Server(error)
Microsoft SQL Server(error)
CSS3(tick)
CSS2(tick)
Step by Step scenario
  1. Add new version in AIP Console
  2. Initiate the Analysis.

Error stack is shown below

ERR: 2022-04-06 11:03:49: Internal error occurred.
                            The application is closing. Call CAST support now providing the log file at C:\ProgramData\CAST\AipConsole\AipNode\logs\external_logs\96b5ab8a-b0f9-4dd8-8291-7620702794d1\prepare_analysis_data\prepare_analysis_data-20220406-110340.txt
                            com.castsoftware.java.MessageRuntimeException:Internal error occurred.
    The application is closing. Call CAST support now providing the log file at C:\ProgramData\CAST\AipConsole\AipNode\logs\external_logs\96b5ab8a-b0f9-4dd8-8291-7620702794d1\prepare_analysis_data\prepare_analysis_data-20220406-110340.txt
                              com.castsoftware.java.IOMonitor.fail(IOMonitor.java:252)
                              com.castsoftware.java.IOMonitor.throwGeneralError(IOMonitor.java:194)
                              com.castsoftware.mda.run.ConfiguredApplication$2.call(ConfiguredApplication.java:257)
                              com.castsoftware.mda.run.ConfiguredApplication$2.call(ConfiguredApplication.java:234)
                              com.castsoftware.util.logger.Logging.execute(Logging.java:527)
                              com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:415)
                              com.castsoftware.mda.run.ConfiguredApplication.run(ConfiguredApplication.java:233)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication.executeInLogContext(CLIPMCConfiguredApplication.java:107)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication$1.call(CLIPMCConfiguredApplication.java:73)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication$1.call(CLIPMCConfiguredApplication.java:68)
                              com.castsoftware.util.logger.Logging.execute(Logging.java:527)
                              com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:415)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication.execute(CLIPMCConfiguredApplication.java:67)
                              com.castsoftware.pmc.CLI.main(CLI.java:34)
                            Source Server / SQL-Problem: All Analysis Units are inactive
                            com.castsoftware.mda.validations.ValidationException:Source Server / SQL-Problem: All Analysis Units are inactive
                              com.castsoftware.mda.validations.ValidationQuery.<init>(ValidationQuery.java:44)
                              com.castsoftware.mda.validations.ValidationQuery.<init>(ValidationQuery.java:55)
                              com.castsoftware.mda.transactions.SectionAction.runInternal(SectionAction.java:37)
                              com.castsoftware.mda.transactions.Section.runInTransaction(Section.java:192)
                              com.castsoftware.mda.transactions.Section.run(Section.java:137)
                              com.castsoftware.mda.transactions.Section.runHeadless(Section.java:308)
                              com.castsoftware.mda.run.ConfigurationManager.runVerb(ConfigurationManager.java:566)
                              com.castsoftware.mda.run.ConfiguredApplication.onTreatment(ConfiguredApplication.java:393)
                              com.castsoftware.pmc.run.PMCConfiguredApplication.onTreatment(PMCConfiguredApplication.java:530)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication.onTreatment(CLIPMCConfiguredApplication.java:185)
                              com.castsoftware.mda.run.ConfiguredApplication$2.call(ConfiguredApplication.java:244)
                              com.castsoftware.mda.run.ConfiguredApplication$2.call(ConfiguredApplication.java:234)
                              com.castsoftware.util.logger.Logging.execute(Logging.java:527)
                              com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:415)
                              com.castsoftware.mda.run.ConfiguredApplication.run(ConfiguredApplication.java:233)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication.executeInLogContext(CLIPMCConfiguredApplication.java:107)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication$1.call(CLIPMCConfiguredApplication.java:73)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication$1.call(CLIPMCConfiguredApplication.java:68)
                              com.castsoftware.util.logger.Logging.execute(Logging.java:527)
                              com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:415)
                              com.castsoftware.pmc.run.CLIPMCConfiguredApplication.execute(CLIPMCConfiguredApplication.java:67)
                              com.castsoftware.pmc.CLI.main(CLI.java:34)
INF: 2022-04-06 11:03:49: Return value: 1000
Action Plan

The issue occurs because the file - analyzer-config.properties is missing in the %programdata%\AIP Node\  folder. 

To solve the issue you need to make sure that this file exists and the contents are present by default. If it does not exist, you can copy it from a different AIP Node installation or request Support to provide it to you. 

  1. Once the file is placed in the path %programdata%/AIPNode/, restart both Console and Node Services. 
  2. Add new version and run analysis. 
  3. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input for CAST Technical Support to carry out further investigation.        

 

Relevant input

Notes/comments

Ticket #35320

Related Pages


  • No labels