CAST Console - Application Scan - Prepare Analysis Data Error - SQL Problem: All Analysis units are inactive

Follow

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

 

 

Release

Yes/No
>1.20.x (tick)

 

 

 

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

 

Ticket #35320

 

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk