1 2 3 4 Previous Next 47 Replies Latest reply: Aug 20, 2012 12:33 PM by karthik chopperla Go to original post RSS
      • 15. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
        SUBHASISH_319401
        Dear Praveer,


        I have already done the same, but still it is not happening.


        Many Thanks for your help.

        Best regards,
        • 16. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
          Gurvinder
          Try this...
          open cim.bat in edit mode and add ojdbc.jar path in the CIM_CLASSPATH.

          save and try again.


          ~Gurvinder
          • 17. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
            SUBHASISH_319401
            Dear All,



            Many Thanks to Nitin, Karthik, Praveer, Gurvinder,


            Finally I am able to solve that problem.

            But now I am facing another problem while setting up datasource with ATG 9.4 inbuild MySQL server.

            It is throwing as error

            *>> Not able to connect to database jdbc:mysql://localhost:3306/*
            production_core @ prod+


            and in CIM log I found the below exception.



            ***** Warning     Wed Aug 01 15:57:01 GMT05:30 2012     1343816821656     atg.cim.worker.status.StatusUpdateValidator     Status id nonswitchingCore-DatasourceConnectionTemplateStep is unknown.*+
            ***** Error     Wed Aug 01 15:57:04 GMT05:30 2012     1343816824859     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator     Not able to connect to database jdbc:mysql://localhost:3306/production_core : atg.service.resourcepool.ResourcePoolException: java.sql.SQLException: Access denied for user 'prod'@'localhost' (using password: YES)atg.service.resourcepool.ResourcePoolException: java.sql.SQLException: Access denied for user 'prod'@'localhost' (using password: YES)*+
            ***** Error     Wed Aug 01 15:57:04 GMT05:30 2012     1343816824859     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator     Error initializing connection from parameters. Test for jdbc connection failed*+



            I am trying to setup a demo application for starting learning ATG from the below link.

            http://docs.oracle.com/cd/E26180_01/Platform.94/QuincyDemoDoc/QuincyDemoDoc.pdf


            Could you please help me on this regards.


            Thanks again to all for giving your valueable time and help.

            Best regards,
            • 18. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
              Urmib-Oracle
              Hello

              If you look at the supported environment for 9.4

              Knowledge Solution
              Oracle Art Technology Group (ATG) Commerce Supported Environments - Release 9.x (Doc ID 1342327.1)

              MySQL 5.5.11 (dev only, JBoss only)

              It won't work with Weblogic

              Thanks
              Urmi
              • 19. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                Nitin Khare
                java.sql.SQLException: Access denied for user 'prod'@'localhost' (using password: YES)
                It clearly shows that you are not able to connect to mysql using user 'prod' and provided password. Make sure that your mysql server is running. If not then you can start mysql server daemon (mysqld.exe) from <ATG_INSTALL_DIR>\MySQL\win32\bin. Also check if you can connect to the mysql server and access "mysql>" prompt by starting mysql client utility from <ATG_INSTALL_DIR>\MySQL\win32\bin as: mysql –u prod –p
                when prompted for password enter your password. If you can access "mysql>" prompt then you should not have any issue in connecting to mysql from CIM with same credentials.
                • 20. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                  SUBHASISH_319401
                  Dear Nitin,

                  The Access denied problem got resolved, actually another MySQL server was installed in the system that was causing problem for ATG 9.4 inbuild MySQL server.

                  Now, I have run all the DDLs for DAS,DPS,DCS,B2BCommerce...

                  Could you please confirm what I need to do to progress to set up Dynamo Server Admin, ATG Control center, ATG Business Control center and any demo applications like MotorPriseJSP or Quincy fund.


                  Thanks and regards,

                  Edited by: SUBHASISH_319401 on Aug 2, 2012 1:41 AM
                  • 21. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                    Nooruddin Shaik
                    For production server: DafEar.Admin MotorPriseJSP
                    For BCC: DafEar.Admin PubPortlet MotorPriseJSP

                    Make sure you have versioned tables installed in BCC DB and localconfig changes to point the datasources.
                    If you need merchandising then add DCS-UI

                    Peace
                    Shaik
                    • 22. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                      SUBHASISH_319401
                      Dear Shaik,


                      Do I need to deploy any EAR files in the Weblogic to run ATG Dynamo Server Admin, ATG Control center, ATG Business control center?

                      When I am clicking ATG9.4 >> Tools >> ATG Dynamo Server Admin or  ATG Control center or ATG Business control center+ it is getting 404 page not found.


                      Thanks and regards,
                      • 23. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                        Nitin Khare
                        You would also have to ensure that the initial data for ATG and applications that you want to run has been imported if you are setting up on a fresh DB. Once all the DB part done, you will have to create the EAR using runAssembler utility consisting of ATG application modules which you want to run like
                        runAssembler earfilename –m modules

                        For more details you can refer to Assembling Application section in the ATG Programming Guide documentation.
                        http://docs.oracle.com/cd/E26180_01/Platform.94/ATGProgGuide/html/s0304assemblingapplications01.html

                        Within the same documentation you will find a summary of various ATG application modules.
                        http://docs.oracle.com/cd/E26180_01/Platform.94/ATGProgGuide/html/s2301appendixeatgmodules01.html

                        After this you would typically need to do following steps:
                        1. Configure ATG datasources. You can do it from <ATG>\home\localconfig if you are not creating your ATG EAR as standalone otherwise you can configure ATG datasources first and then create your EAR.
                        2. Start weblogic server from your domain.
                        3. Deploy the ATG EAR to weblogic and create required datasources from weblogic console.
                        4. Activate your changes and you should should be able to access your ATG applications once Nucleus startup is complete.

                        Also note that even if you don't specify it explicitly, runAssembler itself includes DafEar.Admin module which contains the web-app for Dynamo Server Admin (dyn/admin). You can start ACC either from dyn/admin or from <ATG>\home\bin\startACC script. For accessing BCC, you will have to setup ATG content administration (CA) environment and its schema. Once done, you will have o create another EAR for your CA server which will run on different Weblogic instance along with your production server instance. For CA and BCC details you can refer to ATG documentation. You can also try setting up CRS using CIM to get an idea of how various things are being setup and interact with each other.
                        • 24. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                          SUBHASISH_319401
                          Dear All,

                          While running importQuincyFunds.bat,i am getting the following error.


                          */atg/dynamo/service/jdbc/DirectJTdataSource --- javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial*



                          and



                          Invalid combination for your Transaction Manager (class atg.dtm.TransactionManagerImpl) and Data source (class atg.service.jdbc.WatcherDataSource) implementations. This repository is configured with a Data Source that does not know about its Transaction Manager. Both the Transaction Manager and Data Source implementations must belong to the same J2EE container.+



                          I am trying the setup with weblogic and created a Datasource in weblogic server with MySQL database.

                          URL=jdbc:mysql://localhost:3306/production_core
                          user=prod
                          password=Welcome1
                          driver=com.mysql.jdbc.Driver

                          and also put JTDatasource and DirectJTDatasource.properties file in localconfig\atg\dynamo\service\jdbc folder.



                          Thanks and regards,
                          • 25. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                            SUBHASISH_319401
                            Dear All,

                            While running importQuincyFunds.bat,i am getting the following error.


                            */atg/dynamo/service/jdbc/DirectJTdataSource --- javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial*



                            and



                            Invalid combination for your Transaction Manager (class atg.dtm.TransactionManagerImpl) and Data source (class atg.service.jdbc.WatcherDataSource) implementations. This repository is configured with a Data Source that does not know about its Transaction Manager. Both the Transaction Manager and Data Source implementations must belong to the same J2EE container.+



                            I am trying the setup with weblogic and created a Datasource in weblogic server with MySQL database.

                            Weblogic server Datasource JNDI ATGProductionDS

                            URL=jdbc:mysql://localhost:3306/production_core
                            user=prod
                            password=Welcome1
                            driver=com.mysql.jdbc.Driver

                            JNDI ATGProductionDS

                            and also put JTDatasource and DirectJTDatasource.properties file in localconfig\atg\dynamo\service\jdbc folder.



                            Thanks and regards,

                            Edited by: SUBHASISH_319401 on Aug 2, 2012 6:59 AM
                            • 26. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                              Nitin Khare
                              importQuincyFunds.bat or any other data import typically uses ATG's startSQLRepository utility which runs in its own java process outside the context of application server. So any datasources that you defined in your app server will not be available. To handle this type of situation, ATG provides a "fake" XADataSource which is implemented on top of the old JDBC architecture or a non-XA DataSource. You can use it by creating a "FakeXADataSource.properties" in the path /atg/dynamo/service/jdbc under <ATG>\home\localconfig. Its content will be like:

                              $class=atg.service.jdbc.FakeXADataSource
                              URL=jdbc:mysql://localhost:3306/production_core
                              user=prod
                              password=Welcome1
                              driver=com.mysql.jdbc.Driver

                              Then change your /atg/dynamo/service/jdbc/JTDataSource and /atg/dynamo/service/jdbc/DirectJTDataSource to use the defined FakeXADataSource as:

                              $class=atg.service.jdbc.MonitoredDataSource
                              dataSource=/atg/dynamo/service/jdbc/FakeXADataSource
                              #min number of connections
                              min=10
                              #max number of connections
                              max=100

                              Also ensure that mysql connector JAR is present in your classpath when importing the data.

                              Once you are done with data import then you may remove FakeXADataSource.properties and can change your /atg/dynamo/service/jdbc/JTDataSource and /atg/dynamo/service/jdbc/DirectJTDataSource as following to use your datasources defined in weblogic.
                              $class=atg.nucleus.JNDIReference
                              JNDIName=java:comp/env/ATGProductionDS

                              But anytime you need to run a command based utility like startSQLRepository you may need to redo above things so one of the way is that you can create a separate dynamo server say "tools" and put the FakeXADataSource based data source configurations under <ATG>\home\servers\tools\localconfig and while running any ATG command based utility specify the server "tools" to be used.

                              Hope it helps.
                              • 27. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                                SUBHASISH_319401
                                Hi All,

                                While running http://hostname:port/dyn/admin+

                                getting the following error.



                                Error 500--Internal Server Error+

                                java.lang.NullPointerException+
                                *     at atg.userdirectory.account.AccountUserDirectory.getPrincipal(AccountUserDirectory.java:162)*
                                *     at atg.userdirectory.account.AccountUserDirectory.findUserByPrimaryKey(AccountUserDirectory.java:218)*
                                *     at atg.userdirectory.account.AccountUserDirectory.findUserByLogin(AccountUserDirectory.java:239)*
                                *     at atg.userdirectory.UserDirectoryLoginUserAuthority.login(UserDirectoryLoginUserAuthority.java:348)*
                                *     at atg.servlet.pipeline.UserAuthorityAuthenticator.authenticate(UserAuthorityAuthenticator.java:342)*
                                *     at atg.servlet.pipeline.BasicAuthenticationPipelineServlet.service(BasicAuthenticationPipelineServlet.java:434)*
                                *     at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)*
                                *     at atg.servlet.pipeline.DynamoPipelineServlet.service(DynamoPipelineServlet.java:469)*
                                *     at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)*
                                *     at atg.dtm.TransactionPipelineServlet.service(TransactionPipelineServlet.java:227)*
                                *     at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)*
                                *     at atg.servlet.pipeline.HeadPipelineServlet.passRequest(HeadPipelineServlet.java:1097)*
                                *     at atg.servlet.pipeline.HeadPipelineServlet.service(HeadPipelineServlet.java:779)*
                                *     at atg.servlet.pipeline.PipelineableServletImpl.service(PipelineableServletImpl.java:250)*
                                *     at atg.nucleus.servlet.NucleusProxyServlet.service(NucleusProxyServlet.java:215)*
                                *     at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)*
                                *     at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)*
                                *     at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)*
                                *     at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)*
                                *     at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)*
                                *     at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3717)*
                                *     at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)*
                                *     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)*
                                *     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)*
                                *     at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)*
                                *     at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)*
                                *     at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)*
                                *     at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)*
                                *     at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)*
                                • 28. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                                  Nitin Khare
                                  Seems like your default user accounts data is not proper. You can try deleting data from das_account table and then restart your server. This post may be useful to you:
                                  Re: How to reset dyn/admin password for admin/admin account
                                  • 29. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
                                    karthik chopperla
                                    Are there any more errors in console before accessing dyn/admin???