This discussion is archived
1 2 3 4 Previous Next 47 Replies Latest reply: Aug 20, 2012 10:33 AM by karthik chopperla Go to original post RSS
  • 15. Re: ATG 9.4 installation problem with weblogic 10.0.2 MP2
    SUBHASISH_319401 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    Are there any more errors in console before accessing dyn/admin???

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points