Failed to initialize pool from Default.xml reason: 'Password cannot be null or empty'

Hi All,
While starting the analytic engine, i am getting the following errors. What happened is, initially DB password is changed. Accordingly i changed pool config for MWS in mws-db.xml. It was successfully started. But the same way, i tried to change pool config in softwareag/optimize/analysis/conf/JDBC/pools default.xml, i replaced existing password with plaintext password( It gets encripted after its run). But still its saying password is null. Appreciate any pointers in this.

Error Info:
jvm 5 | () [JDBCPools.admin.3312] 2012-10-26 15:43:23.615 IST ERROR: Failed to initialize pool from file ‘DefualutPool.xml’; reason: ‘Password cannot be null or empty’
jvm 5 | () [JDBCPools.admin.3310] 2012-10-26 15:43:23.624 IST WARN: Could not locate connection pool ‘DefualutPool’, assigned to alias ‘analysis.engine’
jvm 5 | (OPTIMIZE) [Prediction Engine v8.2.1.0.PredictionEngineProperties.configFileLoadComplete] 2012-10-26 15:43:23.734 IST INFO: Configuration file PredictionEngineProperties loaded.

Regards,
Niteesh :slight_smile:

Niteesh,
Were you able to resolve this error? I am also receiving this error even though the connection information and configuration was deployed from MWS > define environments > deploy to file.
Any experience you had in resolving this would be appreciated.

Thank You,
Ian

Resolved this error - This may be related to JDBC Pools Database Passwords being changed, or a copy of bad files referencing wrong connection information in the [saghome]/analysis/conf/components or [saghome]/analysis/conf/JDBC/pools directories.
These errors may also be related or fixed in this manner:

  • com.webmethods.sc.security.passman.PasswordManagerException: Wrapped Exception

  • (OPTIMIZE) [Analytic Engine v8.0.3.0.DimensionDefinitionCacheLoader.[SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00904: “DISPLAY_NAME”: invalid identifier

  • org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘definitionCache’ defined in file [saghome/optimize/analysis/conf/spring/core.spring.xml]: Invocation of init method failed;

  • (OPTIMIZE) [Analytic Engine v8.0.3.0.ConfigMigrator.configFileLoadPropertyError] 2013-01-13 11:38:29.968 EST WARN: Could not set property DDLStatementsOutputDirectory in configuration file DatabaseProperties

  • com.webmethods.bpo.database.SCGConnectionManager.getDriverType(SCGConnectionManager.java:208)

Solution

The first problem is that the analysis/conf files were corrupt or incorrect. To correct this issue, go into MWS and do the following:
Deploy Environment to File
Applications > Administration > System-Wide > Environments > Define Environments
Click on the “Deploy” action (Green Arrow)
Click on “Deploy To File” button
Save the “DeployedEnvironments.zip” file to local machine
Backup all files referenced within the zip file in the [saghome]/analysis/conf directory and sub-directories
Copy all files from the zip file to the [saghome]/analysis/conf directory
(NOTE: Be aware that there are two config directories in the zip file, the first directory is usually for analysis, the second is usually for dataCollector)

Upon starting Analytic Engine, we no longer received the Oracle error referencing “DISPLAY_NAME”
This was when we applied the following file fix.

Edit EndpointRegistry.xml

Edit the file: [saghome]/analysis/conf/system/EndpointRegistry.xml

The file will look as below.

<?xml version="1.0" encoding="UTF-8"?>

Edit the file, so that only the ‘Configuration Agent’ line is still in place. See the below example -
(NOTE: Ensure that the port numbers used match your particular installation)

<?xml version="1.0" encoding="UTF-8"?>

Start Analytic Engine

After modifying the file, start analytic engine.
If analytic engine does not start at this point there is another problem, if it does, then you must follow the step and redeploy the environment as follows:

Deploy Environment
Applications > Administration > System-Wide > Environments > Define Environments
Click on the “Deploy” action (Green Arrow)
Click on the “Deploy All” button
If all environments deploy successfully click the “Close” button