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 |  |
Observed in RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS3 | |
| CSS2 | |
Step by Step scenario
- Add new version in AIP Console
- 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.
- Once the file is placed in the path %programdata%/AIPNode/, restart both Console and Node Services.
- Add new version and run analysis.
- 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
- CAST AIP Console Logs CAST Management Studio - Information - How to find logs
- Detail of specific steps done
- Any applicable screenshots
Notes/comments
Ticket #35320
Related Pages