I am getting below exception when it runs hive scripts in BAM and this is when using oracle for statdb. I followed [1] and only bam-datasource.xml
[1] https://docs.wso2.com/display/AM170/Publishing+API+Runtime+Statistics#PublishingAPIRuntimeStatistics-ConfiguringWSO2BAM [2015-01-16 16:08:48,303] ERROR {org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBOperation} - Failed to write data to database java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBOperation.isRowExisting(DBOperation.java:149) at org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBOperation.writeToDB(DBOperation.java:59) at org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBRecordWriter.write(DBRecordWriter.java:35) at org.apache.hadoop.hive.ql.exec.FileSinkOperator.processOp(FileSinkOperator.java:589) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:467) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:758) at org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:84) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:467) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:758) at org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:84) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:467) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:758) at org.apache.hadoop.hive.ql.exec.GroupByOperator.forward(GroupByOperator.java:964) at org.apache.hadoop.hive.ql.exec.GroupByOperator.closeOp(GroupByOperator.java:1016) at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:553) at org.apache.hadoop.hive.ql.exec.ExecReducer.close(ExecReducer.java:304) at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:528) at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:419) at org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:257) I tried the below and couldn't solve this. - manually deleting all virtual tables from bam mgt console. - grant admin privileges to user in oracle. create user spstatdb identified by spstatdb; grant connect,resource to spstatdb with admin option; commit; - cleared all cassandra and h2 tables and restarted bam with -Dsetup. - tried once invoked apis as well(cassandra db exists data to publish) - Below datasource been placed in bam-datasource.xml * <datasource>* * <name>WSO2AM_STATS_DB</name>* * <description>The datasource used for API Manager database</description>* * <jndiConfig>* * <name>jdbc/WSO2AM_STATS_DB</name>* * </jndiConfig>* * <definition type="RDBMS">* * <configuration>* * <url>jdbc:oracle:thin:@192.168.18.77:1521/ora11g <http://jdbc:oracle:thin:@192.168.18.77:1521/ora11g></url>* * <username>uname</username>* * <password>pword</password>* * <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName>* * <maxActive>50</maxActive>* * <maxWait>60000</maxWait>* * <testOnBorrow>false</testOnBorrow>* * <validationQuery>SELECT 1</validationQuery>* * <validationInterval>30000</validationInterval>* * </configuration>* * </definition>* * </datasource>* Any help please? -- Thanks & Regards *Chaminda Jayawardena* Senior Software Engineer - QA WSO2 Inc. - http://wso2.com +94-77-7725234
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev