I'm new to Compiere and I hope to implement CMPCS for my nesting doll manufacturing workshop.
Still I had no luck to add CMPCS.
I get java.lang.NullPointerException when logging. Is that because of the errors during DBRestore? I always get it finished with "7 rows selected". I also noticed that SuperUser/System doesn't work in my case.
Please help.
RK
Here's CLogFile:
13:29:04.145 Compiere.startup: Compiere(r) Release 2.5.1h_2005-01-12 - Smart ERP & CRM - (c) 1999-2005 Compiere (r); Implementation: ${env.COMPIERE_VERSION} 20050201-1135 - Supported
13:29:04.145 Compiere.startup: C:\Compiere - Java HotSpot(TM) Server VM 1.4.2_07-b05 - Windows XP 5.1 Service Pack 2
13:29:04.165 Ini.loadProperties: C:\Compiere\Compiere.properties #22
13:29:33.477 CLogMgt.setLevel: FINER
13:29:33.487 MSequence.getNextID: AC=false, RO=false - Isolation=8(8) - RSType=1005(1005), RSConcur=1008(1008)
13:29:33.688 PO.saveNew: AD_Session - AD_Session_ID=1012827
13:29:33.988 Env.setContext: Context #AD_Session_ID==1012827
13:29:34.038 MRole.get: get - AD_Role_ID=0, AD_User_ID=0, reload=false
13:29:34.269 MRole.loadOrgAccess: #1
13:29:34.289 MRole.loadTableAccess: #0
13:29:34.499 MRole.loadTableInfo: #556
13:29:34.569 MRole.loadColumnAccess: #0
13:29:34.609 MRole.loadRecordAccess: #0 - Dependent #0
13:29:34.609 MRole.get: get - MRole[0,System Administrator,UserLevel=S ,AD_Client_ID=0,AD_Org_ID=0]
13:29:47.137 MChangeLog.fillChangeLog: fillChangeLog - #32
13:29:47.137 PO.saveUpdate: AD_Session.AD_Session_ID=1012827
13:29:47.217 CompiereServerMgr.startServers:
13:29:47.568 CompiereServerGroup.<init>: CompiereServers - Parent=java.lang.ThreadGroup[name=jboss,maxpri=10]
13:29:47.568 Env.setContext: Context #AD_Client_ID==0
13:29:47.628 CompiereServer.run: run - pre-nap - 30 [11]
13:29:47.708 Env.setContext: Context #AD_Client_ID==0
13:29:47.778 CompiereServer.run: run - pre-nap - 60 [12]
13:29:47.838 Env.setContext: Context #AD_Client_ID==0
13:29:48.008 Env.setContext: Context #AD_Client_ID==0
13:29:48.119 Env.setContext: Context #AD_Client_ID==0
13:29:48.129 CompiereServerMgr.startServers: #0
13:29:48.129 CompiereServerMgr.startAll:
13:29:48.129 CompiereServerMgr.startAll: Alive: GardenWorld Accounting Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:18:34.0
13:29:48.129 CompiereServerMgr.startAll: Alive: GardenWorld Request Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:18:47.0
13:29:48.129 CompiereServerMgr.startAll: Alive: System Workflow Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:19:48.0
13:29:48.139 CompiereServerMgr.startAll: Alive: System Alert Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:20:48.0
13:29:48.139 CompiereServerMgr.startAll: Alive: Delete Old Notes,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:21:47.0
13:29:48.139 CompiereServerMgr.startAll: Running=5, Stopped=0
13:29:48.139 CompiereServerGroup.dump: CompiereServers
13:29:48.139 CompiereServerGroup.dump: - Parent=java.lang.ThreadGroup[name=jboss,maxpri=10]
13:29:48.149 CompiereServerGroup.dump: - Count=5
13:29:48.149 CompiereServerGroup.dump: -- GardenWorld Accounting Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:18:34.0
13:29:48.149 CompiereServerGroup.dump: -- GardenWorld Request Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:18:47.0
13:29:48.159 CompiereServerGroup.dump: -- System Workflow Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:19:48.0
13:29:48.159 CompiereServerGroup.dump: -- System Alert Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:20:48.0
13:29:48.159 CompiereServerGroup.dump: -- Delete Old Notes,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:21:47.0
13:29:48.159 CompiereServerMgr.get: CompiereServerMgr[Servers=5,ContextSize=2,Started=2005-02-09 13:29:33.077]
13:29:48.539 CompiereServer.run: run - pre-nap - 240 [13]
13:29:48.539 CompiereServer.run: run - pre-nap - 180 [14]
13:29:48.539 CompiereServer.run: run - pre-nap - 120 [15]
13:29:54.718 WebEnv.initWeb: Counter
13:29:54.788 WebEnv.initWeb: ProductServlet
13:29:54.798 WebEnv.initWeb: CheckOutServlet
13:29:54.878 WebEnv.initWeb: LoginServlet
13:29:54.888 WebEnv.initWeb: BasketServlet
13:30:14.026 WebEnv.initWeb: RegistrationServlet
13:30:14.036 WebEnv.initWeb: RequestServlet
13:30:39.552 WebEnv.initWeb: WorkflowServlet
13:30:39.573 WebEnv.initWeb: InvoiceServlet
13:30:39.583 WebEnv.initWeb: Click
13:30:42.226 CLogMgt.setLevel: FINER [11]
13:30:42.226 MSequence.getNextID: AC=false, RO=false - Isolation=8(8) - RSType=1005(1005), RSConcur=1008(1008) [11]
13:30:42.296 PO.saveNew: C_AcctProcessorLog - C_AcctProcessorLog_ID=1021939 [11]
13:30:45.551 WebEnv.initWeb: OrderServlet
13:30:45.571 WebEnv.initWeb: PaymentServlet
13:30:45.581 WebEnv.initWeb: RfQServlet
13:30:45.591 WebEnv.initWeb: InfoServlet
13:30:45.601 WebEnv.initWeb: AssetServlet
13:30:45.621 WebEnv.initWeb: ExpenseServlet
13:30:45.631 WebEnv.initWeb: AdvertisementServlet
13:30:45.641 WebEnv.initWeb: NoteServlet
13:30:45.661 PO.get_LOB: Value=null [11]
13:30:47.504 PO.saveUpdate: C_AcctProcessor.C_AcctProcessor_ID=100 [11]
13:30:47.564 CompiereServer.run: run - GardenWorld Accounting Processor: Run #1 - Last=29.242 - Total=29.242 - Next 09:59.940 [11]
13:30:47.564 CompiereServer.sleep: sleep - 10:00.0 [11]
13:30:48.195 CLogMgt.setLevel: FINER [12]
13:30:48.195 MSequence.getNextID: AC=false, RO=false - Isolation=8(8) - RSType=1005(1005), RSConcur=1008(1008) [12]
13:30:48.205 PO.saveNew: R_RequestProcessorLog - R_RequestProcessorLog_ID=1002382 [12]
13:30:48.365 PO.get_LOB: Value=null [12]
13:30:48.395 PO.saveUpdate: R_RequestProcessor.R_RequestProcessor_ID=100 [12]
13:30:48.455 CompiereServer.run: run - GardenWorld Request Processor: Run #1 - Last=00.531 - Total=00.531 - Next 59:59.940 [12]
13:30:48.455 CompiereServer.sleep: sleep - 01:00.0 [12]
13:31:23.285 StatusBean.ejbCreate: #1 [17]
13:31:23.315 StatusBean.getDbHost: getDbHost 1 [17]
13:31:23.446 StatusBean.getDateVersion: getDateVersion 1 [17]
13:31:40.600 ServerBean.ejbCreate: #ServerBean[1-Window=0,Post=0,Process=0,NextSeq=0,Workflow=0,Payment=0,RowSet=0,Update=0,CacheReset=0,UpdateLob=0] [19]
13:31:40.620 ServerBean.pstmt_getRowSet: [1] [19]
===========> CPreparedStatement.remote_getRowSet: CStatementVO[SELECT AD_User.AD_User_ID, AD_User.Description, AD_Role.AD_Role_ID, AD_Role.Name FROM AD_User, AD_User_Roles, AD_Role WHERE AD_User.AD_User_ID=AD_User_Roles.AD_User_ID AND AD_User_Roles.AD_Role_ID=AD_Role.AD_Role_ID AND AD_User.Name=? AND AD_User.IsActive='Y' AND AD_Role.IsActive='Y' AND AD_User_Roles.IsActive='Y' AND (AD_User.Password=? OR AD_User.Password=?) ORDER BY AD_Role.Name; #1=SuperUser; #2=Sustem; #3=bf00c9ebb1c9f57b6d54a6c7ea82ed75] [19]
java.lang.NullPointerException
at java.io.Reader.<init>(Reader.java:61)
at java.io.InputStreamReader.<init>(InputStreamReader.java:80)
at java.util.Properties.load(Properties.java:266)
at java.util.PropertyResourceBundle.<init>(PropertyResourceBundle.java:96)
at com.sun.rowset.JdbcRowSetResourceBundle.<init>(Unknown Source)
at com.sun.rowset.JdbcRowSetResourceBundle.getJdbcRowSetResourceBundle(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.<init>(Unknown Source)
at org.compiere.util.CPreparedStatement.remote_getRowSet(CPreparedStatement.java:964)
at org.compiere.session.ServerBean.pstmt_getRowSet(ServerBean.java:124)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)
at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
I had the same issue until I restored my own test database (assuming you have one...;-) and then the SuperUser id worked again and I could get into the modified GardenWorld Client, as well as my own.
Good luck!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I ran into same problem when trying to login using Portuguese as language. Found out there's a java bug that arises when Compiere uses CachedRowSet.
I found an workaround: changed Language.java so Portuguese language declares US as location, then recompiled,etc ... now it's working fine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I'm new to Compiere and I hope to implement CMPCS for my nesting doll manufacturing workshop.
Still I had no luck to add CMPCS.
I get java.lang.NullPointerException when logging. Is that because of the errors during DBRestore? I always get it finished with "7 rows selected". I also noticed that SuperUser/System doesn't work in my case.
Please help.
RK
Here's CLogFile:
13:29:04.145 Compiere.startup: Compiere(r) Release 2.5.1h_2005-01-12 - Smart ERP & CRM - (c) 1999-2005 Compiere (r); Implementation: ${env.COMPIERE_VERSION} 20050201-1135 - Supported
13:29:04.145 Compiere.startup: C:\Compiere - Java HotSpot(TM) Server VM 1.4.2_07-b05 - Windows XP 5.1 Service Pack 2
13:29:04.165 Ini.loadProperties: C:\Compiere\Compiere.properties #22
13:29:33.477 CLogMgt.setLevel: FINER
13:29:33.487 MSequence.getNextID: AC=false, RO=false - Isolation=8(8) - RSType=1005(1005), RSConcur=1008(1008)
13:29:33.688 PO.saveNew: AD_Session - AD_Session_ID=1012827
13:29:33.988 Env.setContext: Context #AD_Session_ID==1012827
13:29:34.038 MRole.get: get - AD_Role_ID=0, AD_User_ID=0, reload=false
13:29:34.269 MRole.loadOrgAccess: #1
13:29:34.289 MRole.loadTableAccess: #0
13:29:34.499 MRole.loadTableInfo: #556
13:29:34.569 MRole.loadColumnAccess: #0
13:29:34.609 MRole.loadRecordAccess: #0 - Dependent #0
13:29:34.609 MRole.get: get - MRole[0,System Administrator,UserLevel=S ,AD_Client_ID=0,AD_Org_ID=0]
13:29:47.137 MChangeLog.fillChangeLog: fillChangeLog - #32
13:29:47.137 PO.saveUpdate: AD_Session.AD_Session_ID=1012827
13:29:47.217 CompiereServerMgr.startServers:
13:29:47.568 CompiereServerGroup.<init>: CompiereServers - Parent=java.lang.ThreadGroup[name=jboss,maxpri=10]
13:29:47.568 Env.setContext: Context #AD_Client_ID==0
13:29:47.628 CompiereServer.run: run - pre-nap - 30 [11]
13:29:47.708 Env.setContext: Context #AD_Client_ID==0
13:29:47.778 CompiereServer.run: run - pre-nap - 60 [12]
13:29:47.838 Env.setContext: Context #AD_Client_ID==0
13:29:48.008 Env.setContext: Context #AD_Client_ID==0
13:29:48.119 Env.setContext: Context #AD_Client_ID==0
13:29:48.129 CompiereServerMgr.startServers: #0
13:29:48.129 CompiereServerMgr.startAll:
13:29:48.129 CompiereServerMgr.startAll: Alive: GardenWorld Accounting Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:18:34.0
13:29:48.129 CompiereServerMgr.startAll: Alive: GardenWorld Request Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:18:47.0
13:29:48.129 CompiereServerMgr.startAll: Alive: System Workflow Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:19:48.0
13:29:48.139 CompiereServerMgr.startAll: Alive: System Alert Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:20:48.0
13:29:48.139 CompiereServerMgr.startAll: Alive: Delete Old Notes,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:21:47.0
13:29:48.139 CompiereServerMgr.startAll: Running=5, Stopped=0
13:29:48.139 CompiereServerGroup.dump: CompiereServers
13:29:48.139 CompiereServerGroup.dump: - Parent=java.lang.ThreadGroup[name=jboss,maxpri=10]
13:29:48.149 CompiereServerGroup.dump: - Count=5
13:29:48.149 CompiereServerGroup.dump: -- GardenWorld Accounting Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:18:34.0
13:29:48.149 CompiereServerGroup.dump: -- GardenWorld Request Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:18:47.0
13:29:48.159 CompiereServerGroup.dump: -- System Workflow Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:19:48.0
13:29:48.159 CompiereServerGroup.dump: -- System Alert Processor,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:20:48.0
13:29:48.159 CompiereServerGroup.dump: -- Delete Old Notes,Prio=3,CompiereServers,Alive=true,Sleeping=false,Last=2005-02-09 13:21:47.0
13:29:48.159 CompiereServerMgr.get: CompiereServerMgr[Servers=5,ContextSize=2,Started=2005-02-09 13:29:33.077]
13:29:48.539 CompiereServer.run: run - pre-nap - 240 [13]
13:29:48.539 CompiereServer.run: run - pre-nap - 180 [14]
13:29:48.539 CompiereServer.run: run - pre-nap - 120 [15]
13:29:54.718 WebEnv.initWeb: Counter
13:29:54.788 WebEnv.initWeb: ProductServlet
13:29:54.798 WebEnv.initWeb: CheckOutServlet
13:29:54.878 WebEnv.initWeb: LoginServlet
13:29:54.888 WebEnv.initWeb: BasketServlet
13:30:14.026 WebEnv.initWeb: RegistrationServlet
13:30:14.036 WebEnv.initWeb: RequestServlet
13:30:39.552 WebEnv.initWeb: WorkflowServlet
13:30:39.573 WebEnv.initWeb: InvoiceServlet
13:30:39.583 WebEnv.initWeb: Click
13:30:42.226 CLogMgt.setLevel: FINER [11]
13:30:42.226 MSequence.getNextID: AC=false, RO=false - Isolation=8(8) - RSType=1005(1005), RSConcur=1008(1008) [11]
13:30:42.296 PO.saveNew: C_AcctProcessorLog - C_AcctProcessorLog_ID=1021939 [11]
13:30:45.551 WebEnv.initWeb: OrderServlet
13:30:45.571 WebEnv.initWeb: PaymentServlet
13:30:45.581 WebEnv.initWeb: RfQServlet
13:30:45.591 WebEnv.initWeb: InfoServlet
13:30:45.601 WebEnv.initWeb: AssetServlet
13:30:45.621 WebEnv.initWeb: ExpenseServlet
13:30:45.631 WebEnv.initWeb: AdvertisementServlet
13:30:45.641 WebEnv.initWeb: NoteServlet
13:30:45.661 PO.get_LOB: Value=null [11]
13:30:47.504 PO.saveUpdate: C_AcctProcessor.C_AcctProcessor_ID=100 [11]
13:30:47.564 CompiereServer.run: run - GardenWorld Accounting Processor: Run #1 - Last=29.242 - Total=29.242 - Next 09:59.940 [11]
13:30:47.564 CompiereServer.sleep: sleep - 10:00.0 [11]
13:30:48.195 CLogMgt.setLevel: FINER [12]
13:30:48.195 MSequence.getNextID: AC=false, RO=false - Isolation=8(8) - RSType=1005(1005), RSConcur=1008(1008) [12]
13:30:48.205 PO.saveNew: R_RequestProcessorLog - R_RequestProcessorLog_ID=1002382 [12]
13:30:48.365 PO.get_LOB: Value=null [12]
13:30:48.395 PO.saveUpdate: R_RequestProcessor.R_RequestProcessor_ID=100 [12]
13:30:48.455 CompiereServer.run: run - GardenWorld Request Processor: Run #1 - Last=00.531 - Total=00.531 - Next 59:59.940 [12]
13:30:48.455 CompiereServer.sleep: sleep - 01:00.0 [12]
13:31:23.285 StatusBean.ejbCreate: #1 [17]
13:31:23.315 StatusBean.getDbHost: getDbHost 1 [17]
13:31:23.446 StatusBean.getDateVersion: getDateVersion 1 [17]
13:31:40.600 ServerBean.ejbCreate: #ServerBean[1-Window=0,Post=0,Process=0,NextSeq=0,Workflow=0,Payment=0,RowSet=0,Update=0,CacheReset=0,UpdateLob=0] [19]
13:31:40.620 ServerBean.pstmt_getRowSet: [1] [19]
===========> CPreparedStatement.remote_getRowSet: CStatementVO[SELECT AD_User.AD_User_ID, AD_User.Description, AD_Role.AD_Role_ID, AD_Role.Name FROM AD_User, AD_User_Roles, AD_Role WHERE AD_User.AD_User_ID=AD_User_Roles.AD_User_ID AND AD_User_Roles.AD_Role_ID=AD_Role.AD_Role_ID AND AD_User.Name=? AND AD_User.IsActive='Y' AND AD_Role.IsActive='Y' AND AD_User_Roles.IsActive='Y' AND (AD_User.Password=? OR AD_User.Password=?) ORDER BY AD_Role.Name; #1=SuperUser; #2=Sustem; #3=bf00c9ebb1c9f57b6d54a6c7ea82ed75] [19]
java.lang.NullPointerException
at java.io.Reader.<init>(Reader.java:61)
at java.io.InputStreamReader.<init>(InputStreamReader.java:80)
at java.util.Properties.load(Properties.java:266)
at java.util.PropertyResourceBundle.<init>(PropertyResourceBundle.java:96)
at com.sun.rowset.JdbcRowSetResourceBundle.<init>(Unknown Source)
at com.sun.rowset.JdbcRowSetResourceBundle.getJdbcRowSetResourceBundle(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.<init>(Unknown Source)
at org.compiere.util.CPreparedStatement.remote_getRowSet(CPreparedStatement.java:964)
at org.compiere.session.ServerBean.pstmt_getRowSet(ServerBean.java:124)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)
at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
13:31:40.871 ServerBean.ejbRemove: ejbRemove ServerBean[1-Window=0,Post=0,Process=0,NextSeq=0,Workflow=0,Payment=0,RowSet=1,Update=0,CacheReset=0,UpdateLob=0] [19]
I had the same issue until I restored my own test database (assuming you have one...;-) and then the SuperUser id worked again and I could get into the modified GardenWorld Client, as well as my own.
Good luck!
Hi!
Can you send the log of RUN_DBRestore.sh please?
note: the dump is for Oracle 10g
Victor
Can you please advise on how to find the log of RUN_DBRestore.bat? Sorry for the stupid question :)
RK
Hi, I ran into same problem when trying to login using Portuguese as language. Found out there's a java bug that arises when Compiere uses CachedRowSet.
I found an workaround: changed Language.java so Portuguese language declares US as location, then recompiled,etc ... now it's working fine.
follows a code snippet:
new Language ("Portuguese (BR)", AD_Language_pt_BR, new Locale("pt","US"), new Boolean(false), "dd/MM/yyyy", MediaSize.ISO.A4),