2 Replies Latest reply on Sep 19, 2008 11:20 AM by Shafiur Rahman Mohammad

    Every transaction logs as "ERROR" in Log file

    Shafiur Rahman Mohammad Newbie

      Hi everyone,
      I have copied "all" configuration and created "atcc_default" configuration.

      When I am trying to run the application(web), the Login runs fine and I am able to login to the website(I created).
      But when I go back at look at the log file in the server at server->atcc_defailt->system.log, I find all transactions as "ERROR".

      Is there some thing I messed up in Jboss configuration? I don't now ? please suggest me?

      HEre is the System.lo file

      ers (in jboss.xml or standardjboss.xml).

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss.j2ee:service=EjbModule,module=erpproxy-1.2.jar
      State: FAILED
      Reason: org.jboss.deployment.DeploymentException: Missing or invalid Container Invokers (in jboss.xml or standardjboss.xml).

      ObjectName: jboss.mq:service=PersistenceManager
      State: FAILED
      Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: [JDBC Progress Driver]:Invalid host name in connect string); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: [JDBC Progress Driver]:Invalid host name in connect string)))
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=DefaultDS
      Depends On Me:
      jboss.mq:service=DestinationManager


      2008-09-18 14:16:52,280 ERROR [STDERR] Sep 18, 2008 2:16:52 PM org.atcc.erpproxy.services.ErpProxyServices getCountryStateMap
      INFO: Country/state map = [null]
      2008-09-18 14:16:52,280 ERROR [STDERR] Sep 18, 2008 2:16:52 PM org.atcc.erpproxy.services.ErpProxyServices getCountryStateMap
      INFO: Country/state map = [null]
      2008-09-18 14:16:52,280 ERROR [STDERR] Sep 18, 2008 2:16:52 PM org.atcc.erpproxy.services.ErpProxyServices getCountryStateMap
      INFO: Country/state map = [null]
      2008-09-18 14:16:52,280 ERROR [STDERR] Sep 18, 2008 2:16:52 PM org.atcc.erpproxy.services.ErpProxyServices getCountryStateMap
      INFO: Country/state map = [null]
      2008-09-18 14:16:52,280 ERROR [STDERR] Sep 18, 2008 2:16:52 PM org.atcc.erpproxy.services.ErpProxyServices getCountryStateMap
      INFO: Country/state map = [null]
      2008-09-18 14:16:52,280 ERROR [STDERR] Sep 18, 2008 2:16:52 PM org.atcc.erpproxy.services.ErpProxyServices getCountryStateMap
      INFO: Country/state map = [null]
      2008-09-18 14:16:52,296 ERROR [STDERR] Sep 18, 2008 2:16:52 PM org.atcc.erpproxy.services.ErpProxyDataValidator
      INFO: services = org.atcc.erpproxy.services.ErpProxyServices@477b4e
      2008-09-18 14:18:13,293 ERROR [STDERR] Sep 18, 2008 2:18:13 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getQadWebDbConnection
      INFO: Get new QAD/web connection
      2008-09-18 14:18:13,293 ERROR [STDERR] Sep 18, 2008 2:18:13 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO connectToDatabase
      INFO: url = jdbc:JdbcProgress:T:QAD3.atcc.org:15330:trnwebeb2 username = webproxy for db web
      2008-09-18 14:18:13,293 ERROR [STDERR] Sep 18, 2008 2:18:13 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO connectToDatabase
      INFO: before loading the driver: com.progress.sql.jdbc.JdbcProgressDriver
      2008-09-18 14:18:13,293 ERROR [STDERR] Sep 18, 2008 2:18:13 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO connectToDatabase
      INFO: the database I'm connecting to is : jdbc:JdbcProgress:T:QAD3.atcc.org:15330:trnwebeb2
      2008-09-18 14:18:13,293 ERROR [STDERR] Sep 18, 2008 2:18:13 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO connectToDatabase
      INFO: after loading the driver: com.progress.sql.jdbc.JdbcProgressDriver
      2008-09-18 14:18:14,465 ERROR [STDERR] Sep 18, 2008 2:18:14 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getQadWebDbConnection
      INFO: Connected to QAD/WEB
      2008-09-18 14:18:14,777 ERROR [STDERR] Sep 18, 2008 2:18:14 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getProxyDbConnection
      INFO: Create a new proxy connection - primary
      2008-09-18 14:18:14,777 ERROR [STDERR] Sep 18, 2008 2:18:14 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO connectToDatabase
      INFO: url = jdbc:JdbcProgress:T:QAD3.atcc.org:16600:prodproxy username = webproxy for db proxy
      2008-09-18 14:18:14,777 ERROR [STDERR] Sep 18, 2008 2:18:14 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO connectToDatabase
      INFO: before loading the driver: com.progress.sql.jdbc.JdbcProgressDriver
      2008-09-18 14:18:14,777 ERROR [STDERR] Sep 18, 2008 2:18:14 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO connectToDatabase
      INFO: the database I'm connecting to is : jdbc:JdbcProgress:T:QAD3.atcc.org:16600:prodproxy
      2008-09-18 14:18:14,777 ERROR [STDERR] Sep 18, 2008 2:18:14 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO connectToDatabase
      INFO: after loading the driver: com.progress.sql.jdbc.JdbcProgressDriver
      2008-09-18 14:18:15,605 ERROR [STDERR] Sep 18, 2008 2:18:15 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getProxyDbConnection
      INFO: Connected to proxy primary
      2008-09-18 14:18:15,918 ERROR [STDERR] Sep 18, 2008 2:18:15 PM org.atcc.erpproxy.services.ErpProxyServices healthCheck
      INFO: Health Check - OK 2625 ms
      2008-09-18 14:18:15,949 ERROR [STDERR] Sep 18, 2008 2:18:15 PM org.atcc.erpproxy.services.ErpProxyServices getProfileMap
      INFO: inside the getProfileMap() of erpServices
      2008-09-18 14:18:15,949 ERROR [STDERR] Sep 18, 2008 2:18:15 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getStatement
      INFO: stmt: com.progress.sql.jdbc.JdbcProgressStatement@1e0bf98
      2008-09-18 14:18:15,949 ERROR [STDERR] Sep 18, 2008 2:18:15 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getStatement
      INFO: stmt: com.progress.sql.jdbc.JdbcProgressStatement@42bb13
      2008-09-18 14:18:15,949 ERROR [STDERR] Sep 18, 2008 2:18:15 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getUserFromUserTable
      INFO: sql0: select * from pub.zzappu_user where zzappu_applicationusername ='muddu_rahman@yahoo.com' and zzappu_applicationname = 'atccWeb'
      2008-09-18 14:18:16,230 ERROR [STDERR] Sep 18, 2008 2:18:16 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getStatement
      INFO: stmt: com.progress.sql.jdbc.JdbcProgressStatement@11fb8c6
      2008-09-18 14:18:16,230 ERROR [STDERR] Sep 18, 2008 2:18:16 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getStatement
      INFO: stmt: com.progress.sql.jdbc.JdbcProgressStatement@19bd1ca
      2008-09-18 14:18:16,246 ERROR [STDERR] Sep 18, 2008 2:18:16 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getUserFromUserTable
      INFO: sql0: select * from pub.zzappu_user where zzappu_applicationusername ='muddu_rahman@yahoo.com' and zzappu_applicationname = 'atccWeb'
      2008-09-18 14:18:16,855 ERROR [STDERR] Sep 18, 2008 2:18:16 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO createNewWebProfile
      INFO: applicationUserId in createNewProfile(): 51195204
      2008-09-18 14:18:16,965 ERROR [STDERR] Sep 18, 2008 2:18:16 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO createNewWebProfile
      INFO: SQL inside the ErpDao in createNewProfile(): INSERT into pub.zzappu_user (zzappu_applicationuserid, zzappu_applicationname, zzappu_applicationusername) VALUES ('51195204', 'atccWeb', 'muddu_rahman@yahoo.com')
      2008-09-18 14:18:17,902 ERROR [STDERR] Sep 18, 2008 2:18:17 PM org.atcc.erpproxy.services.ErpProxyServices healthCheck
      INFO: Health Check - OK 625 ms
      2008-09-18 14:18:17,902 ERROR [STDERR] Sep 18, 2008 2:18:17 PM org.atcc.erpproxy.services.ErpProxyServices getProfileMap
      INFO: inside the getProfileMap() of erpServices
      2008-09-18 14:18:17,918 ERROR [STDERR] Sep 18, 2008 2:18:17 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getStatement
      INFO: stmt: com.progress.sql.jdbc.JdbcProgressStatement@1e0ef94
      2008-09-18 14:18:17,918 ERROR [STDERR] Sep 18, 2008 2:18:17 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getStatement
      INFO: stmt: com.progress.sql.jdbc.JdbcProgressStatement@910477
      2008-09-18 14:18:17,918 ERROR [STDERR] Sep 18, 2008 2:18:17 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getUserFromUserTable
      INFO: sql0: select * from pub.zzappu_user where zzappu_applicationusername ='muddu_rahman@yahoo.com' and zzappu_applicationname = 'atccWeb'
      2008-09-18 14:18:18,183 ERROR [STDERR] Sep 18, 2008 2:18:18 PM org.atcc.erpproxy.services.dao.progress.ErpProxyProgressDAO getProfileMap
      INFO: profile sql: select zzapp_fieldname, zzapp_fieldvalue from pub.zzapp_profile where zzapp_applicationuserid = '51195204'
      2008-09-18 14:18:18,558 ERROR [STDERR] Sep 18, 2008 2:18:18 PM org.atcc.erpproxy.services.ErpProxyServices getProfileMap
      INFO: map: {APPLICATIONUSERID=51195204, USERNAME=muddu_rahman@yahoo.com}
      2008-09-18 14:18:18,558 ERROR [STDERR] Sep 18, 2008 2:18:18 PM org.atcc.webuser.services.WebUserServices getWebProfile
      INFO: map: {APPLICATIONUSERID=51195204, USERNAME=muddu_rahman@yahoo.com}
      2008-09-18 14:18:18,558 ERROR [STDERR] Sep 18, 2008 2:18:18 PM org.atcc.webuser.services.WebUserServices getWebProfile
      INFO: applicationUserId: 51195204
      2008-09-18 14:18:18,558 ERROR [STDERR] Sep 18, 2008 2:18:18 PM sun.reflect.NativeMethodAccessorImpl invoke0
      INFO: just before creating session.webuserui
      2008-09-18 14:18:18,683 ERROR [STDERR] Sep 18, 2008 2:18:18 PM sun.reflect.NativeMethodAccessorImpl invoke0
      INFO: just after creating session.webuserui
      2008-09-18 14:18:18,683 ERROR [STDERR] Sep 18, 2008 2:18:18 PM sun.reflect.NativeMethodAccessorImpl invoke0
      INFO: just after creating atccSession
      2008-09-18 14:18:18,699 ERROR [STDERR] Sep 18, 2008 2:18:18 PM org.atcc.webuser.services.WebUserServices populateFromErp
      INFO: Top of populateFromErp()
      2008-09-18 14:18:31,573 ERROR [STDERR] Sep 18, 2008 2:18:31 PM org.atcc.erpproxy.services.ErpProxyServices healthCheck
      INFO: Health Check - OK 609 ms
      2008-09-18 14:18:31,589 ERROR [STDERR] Sep 18, 2008 2:18:31 PM org.atcc.webuser.services.WebUserServices populateFromErp
      INFO: Top of populateFromErp()