Hello,
I have installed BRM 7.5, PDC 11.1.0.2, and BRM Integration Pack, now doing some PDC post-installation jobs.
When starting the batch transformation engine, some error messages pop up, and the engine stops.
There seems to be 2 types of errors, one for Java security, another is an Oracle error says "ORA-01031: insufficient privileges"
About the Java security error, someone says that adding some lines to the ${JAVA_HOME}/jre/lib/security/java.policy could solve this problem, though I don't know why.
About the Oracle error, it really confuses me, because I am sure I have given correct account/password combinations when installing PDC.
How can I solve this problem? I am using a Virtualbox VM running RHEL 6.2 x64.
Here are the error logs:
pin@kylewen-rhel62(/BRM/opt/brmpdc_integhome/apps/bin) 728> ./startBRETransformer
Checking for existing process ...
Creating PID file ..
Starting BRE Transformation engine ...
Jul 26, 2014 2:29:55 PM oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine initializeSetup
INFO: ConfigHandler [breBDHostName=192.168.137.196, breBDPort=1521, breDBSID=brmtde, breDBUserName=pin, breTransformLogFileLocation=/BRM/opt/brmpdc_integhome/apps/log/transformation/bre, configMap={SERVICE_CLASS=DEF, EDRC_DESC=ALL_RATE}, hibernateInterval=10000, maxHibernate=1, maxRetries=1, pricingServerHostName=192.168.137.196, pricingServerLoginName=weblogic, pricingServerPort=7001, retryInterval=10000, rreTransformLogFileLocation=/BRM/opt/brmpdc_integhome/apps/log/transformation/rre, persistOutFiles=disabled, sslTagValue=disabled, sleepInterval=10000, sleepRetries=0, xrefDBHostName=192.168.137.196, xrefDBPort=1521, xrefDBSID=pdcdb, xrefDBUserName=xref]
Jul 26, 2014 2:29:55 PM oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine initializeSetup
INFO: Successfully loaded configuration information
PLEASE ENTER KEY PASSWORD TO DECRYPT THE PASSWORD(S) :
Jul 26, 2014 2:30:02 PM oracle.communications.brm.pdc.server.transformation.util.QueueHandler initializeQueue
INFO: Initializing queue connection :
Jul 26, 2014 2:30:02 PM oracle.communications.brm.pdc.server.transformation.util.QueueHandler initializeQueue
INFO: Queue connection esatblished successfully :
Jul 26, 2014 2:30:03 PM oracle.jdbc.driver.OracleDriver registerMBeans
SEVERE: Error while registering Oracle JDBC Diagnosability MBean.
java.security.AccessControlException: access denied ("javax.management.MBeanTrustPermission" "register")
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:372)
at java.lang.SecurityManager.checkPermission(SecurityManager.java:585)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.checkMBeanTrustPermission(DefaultMBeanServerInterceptor.java:1848)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:322)
at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:522)
at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:309)
at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:213)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:209)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at oracle.communications.brm.pdc.server.transformation.util.DatabaseConnectionObj.initializeConnection(DatabaseConnectionObj.java:104)
at oracle.communications.brm.pdc.server.transformation.util.DatabaseConnectionObj.<init>(DatabaseConnectionObj.java:87)
at oracle.communications.brm.pdc.server.transformation.util.DatabaseConnectionObj.getCrossRefDBConnection(DatabaseConnectionObj.java:58)
at oracle.communications.brm.pdc.server.transformation.SupportedConfig.<init>(SupportedConfig.java:92)
at oracle.communications.brm.pdc.server.transformation.bre.config.xref.BRESupportedConfig.<init>(BRESupportedConfig.java:74)
at oracle.communications.brm.pdc.server.transformation.bre.config.xref.BRESupportedConfig.getInstance(BRESupportedConfig.java:124)
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformer.<init>(BRETransformer.java:77)
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine.createWorkItemProcessors(BRETransformationEngine.java:119)
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine.main(BRETransformationEngine.java:173)
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.util.DatabaseConnectionObj initializeConnection
INFO: Connection established with DB.
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.util.DatabaseConnectionObj initializeConnection
INFO: Connection established with DB.
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.SupportedConfig loadSupportedConfigObjects
INFO: loading Supported config Objects information from Database
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.SupportedConfig loadSuppConfObjNameIdMap
INFO: loading Supported config Objects name and id map from Database
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.bre.config.xref.BRESupportedConfig loadBRETables
SEVERE: SQL Error: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
1031 42000
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.bre.BRETransformer <init>
SEVERE: Error in transformation
oracle.communications.brm.pdc.server.transformation.TransformationException: Error updating cross reference table : [BRESupportedConfig]
at oracle.communications.brm.pdc.server.transformation.bre.config.xref.BRESupportedConfig.loadBRETables(BRESupportedConfig.java:175)
at oracle.communications.brm.pdc.server.transformation.bre.config.xref.BRESupportedConfig.<init>(BRESupportedConfig.java:116)
at oracle.communications.brm.pdc.server.transformation.bre.config.xref.BRESupportedConfig.getInstance(BRESupportedConfig.java:124)
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformer.<init>(BRETransformer.java:77)
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine.createWorkItemProcessors(BRETransformationEngine.java:119)
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine.main(BRETransformationEngine.java:173)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)
at oracle.communications.brm.pdc.server.transformation.bre.config.xref.BRESupportedConfig.loadBRETables(BRESupportedConfig.java:165)
... 5 more
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine main
SEVERE: Error in BRE Transformation Engine
oracle.communications.brm.pdc.server.transformation.TransformationException: Error initializing transformation engine
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformer.<init>(BRETransformer.java:130)
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine.createWorkItemProcessors(BRETransformationEngine.java:119)
at oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine.main(BRETransformationEngine.java:173)
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine main
INFO: Clearing temporary files
Jul 26, 2014 2:30:03 PM oracle.communications.brm.pdc.server.transformation.bre.BRETransformationEngine main
INFO: ########### exiting BRETransformationEngine ###########
Removing /BRM/opt/brmpdc_integhome/apps/transformation/bre.pid