You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Aswath Satrasala (JIRA)" <ji...@apache.org> on 2009/07/02 17:29:47 UTC
[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
Posted by "Aswath Satrasala (JIRA)" <ji...@apache.org>.
[ 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] Closed: (OFBIZ-2690) Click on Trial Balance - seems to Hang
or takes a long time
Posted by "Aswath Satrasala (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (OFBIZ-2690) Click on Trial Balance - seems to
Hang or takes a long time
Posted by "Aswath Satrasala (JIRA)" <ji...@apache.org>.
[ 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] Commented: (OFBIZ-2690) Click on Trial Balance - seems to
Hang or takes a long time
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ 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
Posted by "Aswath Satrasala (JIRA)" <ji...@apache.org>.
[ 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.