Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
Developer Community
  • Posts
    • InterSystems Official
    • Articles
    • Questions
    • Announcements
    • Discussions
    • Tags
  • Events
    • Tech Article Contest
    • Programming Contest
    • InterSystems Ideas Contest
    • Event Calendar
  • Products
    • InterSystems IRIS
    • InterSystems IRIS for Health
    • HealthShare
    • TrakCare
    • Caché
    • Ensemble
    • InterSystems Analytics (DeepSee)
    • InterSystems Text Analytics (iKnow)
  • Jobs
    • Job Opportunity
    • Job Wanted
  • Members
  • About
    • About Us
    • FAQ
    • Feedback
    • Report an Issue
    • Share an Idea
    • Code of Conduct
    • Contact Us

EN

Search by posts, members, tags
Language
EN|
ESPTJPCNFREN
New post
  • Profile page
  • Posts (2)
  • Replies (6)
  • Mentions (0)
  • Official certification & Credly badges (0)
  • Global Masters badges (0)
  • Followers (0)
  • Following (0)
AllAccepted answers
    go to post
Phuc Nguyen · Oct 29, 2020

We found the query that is causing CSP to timeout: "group by xyz" , the sorting was taking too long even with resultset just a handful.
adding the ID helps avoid timeout "ID like '%%%' group by xyz"

0 0 https://community.intersystems.com/post/does-sql-query-csp-causes-web-pages-timeout-get-logged-sql-statements#comment-136436
    go to post
Phuc Nguyen · Oct 29, 2020

The compiled class for the csp file.

0 0 https://community.intersystems.com/post/does-sql-query-csp-causes-web-pages-timeout-get-logged-sql-statements#comment-136431
    go to post
Phuc Nguyen · Oct 28, 2020

Thanks... giving this a try but not sure why MONLBL is always returning '(routine not found)' when entering any routine name. Using wildcard * is accepted but after executing csp, detail report written is empty. Will try other report and see...

Looks like csp.INT is not detected for monitoring:

0 0 https://community.intersystems.com/post/does-sql-query-csp-causes-web-pages-timeout-get-logged-sql-statements#comment-136366
    go to post
Phuc Nguyen · Oct 28, 2020

Average Time column from Intersystems SQL Statements tab is in seconds

0 0 https://community.intersystems.com/post/does-sql-query-csp-causes-web-pages-timeout-get-logged-sql-statements#comment-136361
    go to post
Phuc Nguyen · Oct 26, 2020

The link in the above post, https://beta.learning.intersystems.com/course/view.php?id=55, is not available. Is there an updated link? Thanks 

0 0 https://community.intersystems.com/post/global-summit-2016-find-and-fix-slow-query#comment-136196
    go to post
Phuc Nguyen · May 2, 2016

Error is because Atelier was launched using java from JRE not java from JDK.  

You need to have JDK and JAVA_HOME to run Eclipse/Atelier. 

Try installing JDK and add JAVA_HOME variable to your system and launch Atelier again.

2 0 https://community.intersystems.com/post/cannot-start-atelier-java-was-started-returned-exit-code-13#comment-84301
Phuc Nguyen
@Phuc.Nguyen
Follow

User statistics

Posts
2
Replies
6
Likes
5
Applications
0
Badges
0
Followers
0
People reached
758
Accepted answers
1
  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2025 InterSystems Corporation, Cambridge, MA. All rights reserved.

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up