[jira] Created: (OFBIZ-2690) Click on Trial Balance - seems to Hang or takes a long time
Locked
[jira] Created: (OFBIZ-2690) Click on Trial Balance - seems to Hang or takes a long time
 
|
Click on Trial Balance - seems to Hang or takes a long time
----------------------------------------------------------- Key: OFBIZ-2690 URL: https://issues.apache.org/jira/browse/OFBIZ-2690 Project: OFBiz Issue Type: Bug Components: accounting Affects Versions: SVN trunk Reporter: Aswath Satrasala I did the following * Accounting * Organization GL Setting * Click on the Accounting for 'Company' * click on Trial Balance The response did not come back even after waiting or 1-2 minutes. It is taking long time, but seems to be doing something when I see the output in the console [java] 2009-07-02 20:54:27,836 (default-invoker-Thread-7) [ ServiceDispatc her.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [235 ] milliseconds [java] 2009-07-02 20:54:28,091 (default-invoker-Thread-10) [ Generi cDAO.java:806:INFO ] Ran query in 163 milli-seconds: SELECT PRODUCT_ID, PRODUCT_ MAINT_SEQ_ID, PRODUCT_MAINT_TYPE_ID, MAINT_NAME, MAINT_TEMPLATE_WORK_EFFORT_ID, INTERVAL_QUANTITY, INTERVAL_UOM_ID, INTERVAL_METER_TYPE_ID, REPEAT_COUNT, LAST_U PDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ. PRODUCT_MAINT WHERE ((PRODUCT_ID = ? AND INTERVAL_UOM_ID LIKE ?)) [java] 2009-07-02 20:54:28,098 (default-invoker-Thread-10) [ ServiceDispat cher.java:586:INFO ] Sync service [JobDispatcher/createMaintsFromTimeInterval] f inished in [536] milliseconds [java] 2009-07-02 20:54:28,098 (http-0.0.0.0-8443-1) [ GenericDAO.j ava:806:INFO ] Ran query in 166 milli-seconds: SELECT PARTY_ID_FROM, PARTY_ID_TO , ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE, THRU_DATE, STATUS_ID, RELATIONS HIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMI SSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_ST AMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY_RELATIONSHIP WHERE (((THRU _DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2690) Click on Trial Balance - seems to Hang or takes a long time
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726564#action_12726564 ] Jacopo Cappellato commented on OFBIZ-2690: ------------------------------------------ The log entries are not related to the report; you probably have jobs in the queue that are slowing down the system. > Click on Trial Balance - seems to Hang or takes a long time > ----------------------------------------------------------- > > Key: OFBIZ-2690 > URL: https://issues.apache.org/jira/browse/OFBIZ-2690 > Project: OFBiz > Issue Type: Bug > Components: accounting > Affects Versions: SVN trunk > Reporter: Aswath Satrasala > > I did the following > * Accounting > * Organization GL Setting > * Click on the Accounting for 'Company' > * click on Trial Balance > The response did not come back even after waiting or 1-2 minutes. It is taking long time, but seems to be doing something when I see the output in the console > [java] 2009-07-02 20:54:27,836 (default-invoker-Thread-7) [ ServiceDispatc > her.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [235 > ] milliseconds > [java] 2009-07-02 20:54:28,091 (default-invoker-Thread-10) [ Generi > cDAO.java:806:INFO ] Ran query in 163 milli-seconds: SELECT PRODUCT_ID, PRODUCT_ > MAINT_SEQ_ID, PRODUCT_MAINT_TYPE_ID, MAINT_NAME, MAINT_TEMPLATE_WORK_EFFORT_ID, > INTERVAL_QUANTITY, INTERVAL_UOM_ID, INTERVAL_METER_TYPE_ID, REPEAT_COUNT, LAST_U > PDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ. > PRODUCT_MAINT WHERE ((PRODUCT_ID = ? AND INTERVAL_UOM_ID LIKE ?)) > [java] 2009-07-02 20:54:28,098 (default-invoker-Thread-10) [ ServiceDispat > cher.java:586:INFO ] Sync service [JobDispatcher/createMaintsFromTimeInterval] f > inished in [536] milliseconds > [java] 2009-07-02 20:54:28,098 (http-0.0.0.0-8443-1) [ GenericDAO.j > ava:806:INFO ] Ran query in 166 milli-seconds: SELECT PARTY_ID_FROM, PARTY_ID_TO > , ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE, THRU_DATE, STATUS_ID, RELATIONS > HIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMI > SSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_ST > AMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY_RELATIONSHIP WHERE (((THRU > _DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2690) Click on Trial Balance - seems to Hang or takes a long time
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726780#action_12726780 ] Aswath Satrasala commented on OFBIZ-2690: ----------------------------------------- I did a update of the svn. I performed "ant clean-data run-install run" Hence, i think there are no jobs in the queue. I will try again today. > Click on Trial Balance - seems to Hang or takes a long time > ----------------------------------------------------------- > > Key: OFBIZ-2690 > URL: https://issues.apache.org/jira/browse/OFBIZ-2690 > Project: OFBiz > Issue Type: Bug > Components: accounting > Affects Versions: SVN trunk > Reporter: Aswath Satrasala > > I did the following > * Accounting > * Organization GL Setting > * Click on the Accounting for 'Company' > * click on Trial Balance > The response did not come back even after waiting or 1-2 minutes. It is taking long time, but seems to be doing something when I see the output in the console > [java] 2009-07-02 20:54:27,836 (default-invoker-Thread-7) [ ServiceDispatc > her.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [235 > ] milliseconds > [java] 2009-07-02 20:54:28,091 (default-invoker-Thread-10) [ Generi > cDAO.java:806:INFO ] Ran query in 163 milli-seconds: SELECT PRODUCT_ID, PRODUCT_ > MAINT_SEQ_ID, PRODUCT_MAINT_TYPE_ID, MAINT_NAME, MAINT_TEMPLATE_WORK_EFFORT_ID, > INTERVAL_QUANTITY, INTERVAL_UOM_ID, INTERVAL_METER_TYPE_ID, REPEAT_COUNT, LAST_U > PDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ. > PRODUCT_MAINT WHERE ((PRODUCT_ID = ? AND INTERVAL_UOM_ID LIKE ?)) > [java] 2009-07-02 20:54:28,098 (default-invoker-Thread-10) [ ServiceDispat > cher.java:586:INFO ] Sync service [JobDispatcher/createMaintsFromTimeInterval] f > inished in [536] milliseconds > [java] 2009-07-02 20:54:28,098 (http-0.0.0.0-8443-1) [ GenericDAO.j > ava:806:INFO ] Ran query in 166 milli-seconds: SELECT PARTY_ID_FROM, PARTY_ID_TO > , ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE, THRU_DATE, STATUS_ID, RELATIONS > HIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMI > SSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_ST > AMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY_RELATIONSHIP WHERE (((THRU > _DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2690) Click on Trial Balance - seems to Hang or takes a long time
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726796#action_12726796 ] Aswath Satrasala commented on OFBIZ-2690: ----------------------------------------- I tried again on r790783 It get stuck at: [java] 2009-07-03 11:07:16,269 (http-0.0.0.0-8443-1) [ Log.j ava:110:INFO ] [CommonPermissionServices.xml#genericBasePermissionCheck] Checkin g for primary permission ACCTG_PREF_VIEW > Click on Trial Balance - seems to Hang or takes a long time > ----------------------------------------------------------- > > Key: OFBIZ-2690 > URL: https://issues.apache.org/jira/browse/OFBIZ-2690 > Project: OFBiz > Issue Type: Bug > Components: accounting > Affects Versions: SVN trunk > Reporter: Aswath Satrasala > > I did the following > * Accounting > * Organization GL Setting > * Click on the Accounting for 'Company' > * click on Trial Balance > The response did not come back even after waiting or 1-2 minutes. It is taking long time, but seems to be doing something when I see the output in the console > [java] 2009-07-02 20:54:27,836 (default-invoker-Thread-7) [ ServiceDispatc > her.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [235 > ] milliseconds > [java] 2009-07-02 20:54:28,091 (default-invoker-Thread-10) [ Generi > cDAO.java:806:INFO ] Ran query in 163 milli-seconds: SELECT PRODUCT_ID, PRODUCT_ > MAINT_SEQ_ID, PRODUCT_MAINT_TYPE_ID, MAINT_NAME, MAINT_TEMPLATE_WORK_EFFORT_ID, > INTERVAL_QUANTITY, INTERVAL_UOM_ID, INTERVAL_METER_TYPE_ID, REPEAT_COUNT, LAST_U > PDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ. > PRODUCT_MAINT WHERE ((PRODUCT_ID = ? AND INTERVAL_UOM_ID LIKE ?)) > [java] 2009-07-02 20:54:28,098 (default-invoker-Thread-10) [ ServiceDispat > cher.java:586:INFO ] Sync service [JobDispatcher/createMaintsFromTimeInterval] f > inished in [536] milliseconds > [java] 2009-07-02 20:54:28,098 (http-0.0.0.0-8443-1) [ GenericDAO.j > ava:806:INFO ] Ran query in 166 milli-seconds: SELECT PARTY_ID_FROM, PARTY_ID_TO > , ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE, THRU_DATE, STATUS_ID, RELATIONS > HIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMI > SSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_ST > AMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY_RELATIONSHIP WHERE (((THRU > _DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2690) Click on Trial Balance - seems to Hang or takes a long time
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726797#action_12726797 ] Aswath Satrasala commented on OFBIZ-2690: ----------------------------------------- It is the same with 'Income statement' and 'balance sheet' reports also. > Click on Trial Balance - seems to Hang or takes a long time > ----------------------------------------------------------- > > Key: OFBIZ-2690 > URL: https://issues.apache.org/jira/browse/OFBIZ-2690 > Project: OFBiz > Issue Type: Bug > Components: accounting > Affects Versions: SVN trunk > Reporter: Aswath Satrasala > > I did the following > * Accounting > * Organization GL Setting > * Click on the Accounting for 'Company' > * click on Trial Balance > The response did not come back even after waiting or 1-2 minutes. It is taking long time, but seems to be doing something when I see the output in the console > [java] 2009-07-02 20:54:27,836 (default-invoker-Thread-7) [ ServiceDispatc > her.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [235 > ] milliseconds > [java] 2009-07-02 20:54:28,091 (default-invoker-Thread-10) [ Generi > cDAO.java:806:INFO ] Ran query in 163 milli-seconds: SELECT PRODUCT_ID, PRODUCT_ > MAINT_SEQ_ID, PRODUCT_MAINT_TYPE_ID, MAINT_NAME, MAINT_TEMPLATE_WORK_EFFORT_ID, > INTERVAL_QUANTITY, INTERVAL_UOM_ID, INTERVAL_METER_TYPE_ID, REPEAT_COUNT, LAST_U > PDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ. > PRODUCT_MAINT WHERE ((PRODUCT_ID = ? AND INTERVAL_UOM_ID LIKE ?)) > [java] 2009-07-02 20:54:28,098 (default-invoker-Thread-10) [ ServiceDispat > cher.java:586:INFO ] Sync service [JobDispatcher/createMaintsFromTimeInterval] f > inished in [536] milliseconds > [java] 2009-07-02 20:54:28,098 (http-0.0.0.0-8443-1) [ GenericDAO.j > ava:806:INFO ] Ran query in 166 milli-seconds: SELECT PARTY_ID_FROM, PARTY_ID_TO > , ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE, THRU_DATE, STATUS_ID, RELATIONS > HIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMI > SSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_ST > AMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY_RELATIONSHIP WHERE (((THRU > _DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-2690) Click on Trial Balance - seems to Hang or takes a long time
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aswath Satrasala closed OFBIZ-2690. ----------------------------------- Resolution: Fixed Fix Version/s: SVN trunk looking good at r790793 > Click on Trial Balance - seems to Hang or takes a long time > ----------------------------------------------------------- > > Key: OFBIZ-2690 > URL: https://issues.apache.org/jira/browse/OFBIZ-2690 > Project: OFBiz > Issue Type: Bug > Components: accounting > Affects Versions: SVN trunk > Reporter: Aswath Satrasala > Fix For: SVN trunk > > > I did the following > * Accounting > * Organization GL Setting > * Click on the Accounting for 'Company' > * click on Trial Balance > The response did not come back even after waiting or 1-2 minutes. It is taking long time, but seems to be doing something when I see the output in the console > [java] 2009-07-02 20:54:27,836 (default-invoker-Thread-7) [ ServiceDispatc > her.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [235 > ] milliseconds > [java] 2009-07-02 20:54:28,091 (default-invoker-Thread-10) [ Generi > cDAO.java:806:INFO ] Ran query in 163 milli-seconds: SELECT PRODUCT_ID, PRODUCT_ > MAINT_SEQ_ID, PRODUCT_MAINT_TYPE_ID, MAINT_NAME, MAINT_TEMPLATE_WORK_EFFORT_ID, > INTERVAL_QUANTITY, INTERVAL_UOM_ID, INTERVAL_METER_TYPE_ID, REPEAT_COUNT, LAST_U > PDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ. > PRODUCT_MAINT WHERE ((PRODUCT_ID = ? AND INTERVAL_UOM_ID LIKE ?)) > [java] 2009-07-02 20:54:28,098 (default-invoker-Thread-10) [ ServiceDispat > cher.java:586:INFO ] Sync service [JobDispatcher/createMaintsFromTimeInterval] f > inished in [536] milliseconds > [java] 2009-07-02 20:54:28,098 (http-0.0.0.0-8443-1) [ GenericDAO.j > ava:806:INFO ] Ran query in 166 milli-seconds: SELECT PARTY_ID_FROM, PARTY_ID_TO > , ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE, THRU_DATE, STATUS_ID, RELATIONS > HIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMI > SSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_ST > AMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY_RELATIONSHIP WHERE (((THRU > _DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |