Sunday, February 15, 2015

Failed deployment on GRC (Oracle Governance, Risk, and Compliance Management)

Configuration :
GRCC application (Oracle Governance, Risk, and Compliance Management) on WLS 10.3.5 on linux6 (GRC connects directly to db does not use WLS Datasource, because it can be deployed on any container) 

Error :
Applicaiotn failed with error
<Error> <Deployer> <BEA-149231> <Unable to set the activation state to true for the application 'grc'.
weblogic.application.ModuleException: [HTTP:101216]Servlet: "OHWServlet" failed to preload on startup in Web application: "grc".
java.lang.IllegalStateException: unable to create global configuration:unable to create global configuration
        at oracle.help.web.rich.OHWServlet.init(Unknown Source)
        at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
       
Troubleshooting:
Found the below configuration under */middleware/grc864_2242/grc/WEB-INF/web.xml

        <servlet>
        <servlet-name>OHWServlet</servlet-name>
        <servlet-class>oracle.help.web.rich.OHWServlet</servlet-class>
        <init-param>
            <param-name>ohwConfigFileURL</param-name>
            <param-value>/helpsets/ohwconfig.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
     </servlet>

Solution :
renamed grcc folder which was deployment path in console.
created a new folder gave <chmod 777 grc864_2242> permission
copied the ear to the folder and unzipped it <unzip grcc.ear>
deployed in nostage mode, restarted jvm.
accessed url as http://ip:port/grc
Provided db details on the form and initialised the application.
But application could not initialise after 78% 

Error :
(..grc864_2242/grc/log/grc.log) in grc.log file of application found that application is trying to make db connection and after 2 min receiving connection reset on socket write.

2015-02-12 12:14:52,649 DEBUG [el.Default (self-tuning)'] DataSource:1112 connection string generated: jdbc:oracle:thin:@server:port:GRCM
2015-02-12 12:14:52,651 DEBUG [el.Default (self-tuning)'] DBConfigService:430 Connection URL: jdbc:oracle:thin:@server:port:GRCM
2015-02-12 12:14:52,759 DEBUG [el.Default (self-tuning)'] GrcSchema:68 canConnectToDb = true
2015-02-12 12:14:52,828 DEBUG [el.Default (self-tuning)'] LandingServiceImpl:49 getDatabaseUpgradeJob
2015-02-12 12:14:52,977 ERROR [el.Default (self-tuning)'] ApplicationResourceRequestFilter:308 Connection reset
java.net.SocketException: Connection reset
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
        at weblogic.utils.io.ChunkedOutputStream.writeTo(ChunkedOutputStream.java:193)
        at weblogic.servlet.internal.ServletOutputStreamImpl.writeHeader(ServletOutputStreamImpl.java:167)
        at weblogic.servlet.internal.ResponseHeaders.writeHeaders(ResponseHeaders.java:444)
       
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
2015-02-12 12:14:52,985 ERROR [el.Default (self-tuning)'] ApplicationResourceRequestFilter:308 Connection reset
java.net.SocketException: Connection reset
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
        at weblogic.utils.io.ChunkedOutputStream.writeTo(ChunkedOutputStream.java:193)

       
Solution :
Found at DB side that connections are at 49, while default DB connection in the grc form were 50.
redeployed the application and restarted jvm and increased db connections to 150 set
gave below values in grc form and issue was resolved.

refer : grc864_2242/grc/WEB-INF/conf/grc.properties
grc.report.repository.path = */oracle/middleware/grc_reports
grc.data.directory.name = */oracle/middleware/tcg_reports
grc.etl.home.path = */oracle/middleware/tcg_reports
app.server.library.path = */oracle/middleware/grc864_2242/grc/WEB-INF/lib
db conn : 150

No comments: