Tasks crash after changing BAM admin password

Question

After changing the default password for the admin user in WSO2 BAM 4.1.0, the tasks fail with the following error:

TID: [0] [BAM] [2013-06-20 16:56:15,464] ERROR {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} - Error while executing Hive script. Query returned non-zero code: 9, cause: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189) at org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:355) at org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:250) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) TID: [0] [BAM] [2013-06-20 16:56:15,467] ERROR {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while executing script : am_stats_analyzer_460 {org.wso2.carbon.analytics.hive.ta sk.HiveScriptExecutorTask} org.wso2.carbon.analytics.hive.exception.HiveExecutionException: Error while executing Hive script.Query returned non-zero code: 9, cause: FAILED: Execution Error, return code 2 from org.apache.hado op.hive.ql.exec.MapRedTask at org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl.execute(HiveExecutorServiceImpl.java:117) at org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask.execute(HiveScriptExecutorTask.java:60) at org.wso2.carbon.ntask.core.impl.TaskQuartzJobAdapter.execute(TaskQuartzJobAdapter.java:56) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) 

Resetting the password to its original value solves the problem.

How to change password for admin user and save work tasks?

Answer 1

To solve the problem, I had to follow these steps:

• edit the file [BAM_HOME]/repository/conf/etc/cassandra-auth.xml and change the password to a new password .
• edit the [BAM_HOME]/repository/conf/datasources/master-datasources.xml and change the password value of the WSO2BAM_CASSANDRA_DATASOURCE data WSO2BAM_CASSANDRA_DATASOURCE to a new password .
• restart BAM: Hive tasks now run without errors.

where the new password is the password that I assigned to the admin user.

In addition, the Main \ Manage \ Cassandra Keyspaces \ List page in the BAM interface is now fixed, which raises the following error:

 org.wso2.carbon.cassandra.mgt.ui.CassandraAdminClientException: Error retrieving keyspace names ! (...) Caused by: org.apache.axis2.AxisFault: InvalidRequestException(why:You have not logged in) (...) 

Answer 2

Have you changed the username, password in the hive script am_stats_analyzer? By default admin / admin are used, check the hive script and update the password accordingly. The property is as follows:

"cassandra.ks.username" = "admin", "cassandra.ks.password" = "xxxxx",

Check if this problem fixes.

Answer 3

Sorry, I could not answer this question before, anyway, I'm glad that your problem is sorted now.! Keep trying BAM and feel free to scream if you have any problems.

Thanks, Shariq.