Print Page | Close Window

blking of database Printed From: Crystal Reports Book Category: General Information Forum Name: Talk with the Author Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know! URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14450 Printed Date: 01 May 2024 at 12:28am Topic: blking of database Posted By: ankita Subject: blking of database Date Posted: 22 Sep 2011 at 3:18am plese tell em why crystal report blocks the database when we run it Replies: Posted By: CircleD Date Posted: 22 Sep 2011 at 7:59pm What do you mean blocking the database?What kind of error message are you getting? Posted By: ankita Date Posted: 23 Sep 2011 at 7:23am Blocking on the HPSM Database Database gives the log that is due to running of crystal reports it blocks the database of HPSM. Posted By: ankita Date Posted: 23 Sep 2011 at 7:29am SPID ------------111    BlockingSPID --- 112 DatabaseName--- HPSM Duration (Min)--- 49 BlockingStatement ---- SELECT "PROBSUMMARYM1"."NUMBER", "PROBSUMMARYM1"."OPEN_TIME", "PROBSUMMARYM1"."SUBCATEGORY", "PROBSUMMARYM1"."ASSIGNMENT", "PROBSUMMARYM1"."PROBLEM_STATUS", "CONTCTSM1"."FULL_NAME", "PROBSUMMARYM2"."ZCIRCLE", "PROBSUMMARYM1"."CONTACT_PHONE", "PROBSUMMARYM1"."CONTACT_LOCATION", "PROBSUMMARYM1"."OPENED_BY", "PROBSUMMARYM1"."PRIORITY_CODE", "PROBSUMMARYM2"."LAST_UPDATE", "PROBSUMMARYM1"."RESOLVED_TIME", "PROBSUMMARYM1"."CLOSE_TIME", "PROBSUMMARYM1"."UPDATE_TIME", "PROBSUMMARYM1"."INCIDENT_ID", "PROBSUMMARYM1"."UPDATED_BY", "PROBSUMMARYM1"."ASSIGNEE_NAME", "PROBSUMMARYM1"."PRODUCT_TYPE", "PROBSUMMARYM1"."PROBLEM_TYPE", "PROBSUMMARYM2"."CALL_LOGGING_MODE", "PROBSUMMARYM1"."CLOSED_BY", "PROBSUMMARYM1"."RESOLVED_BY", "PROBSUMMARYM1"."RESOLUTION", "PROBSUMMARYM1"."ACTION" FROM ("SM7"."dbo"."PROBSUMMARYM1" "PROBSUMMARYM1" INNER JOIN "SM7"."dbo"."PROBSUMMARYM2" "PROBSUMMARYM2" ON "PROBSUMMARYM1"."NUMBER"="PROBSUMMARYM2"."NUMBER") INNER JOIN "SM7"."dbo"."CONTCTSM1" "CONTCTSM1" ON "PROBSUMMARYM1"."CONTACT_NAME"="CONTCTSM1"."CONTACT_NAME" WHERE NOT ("CONTCTSM1"."FULL_NAME"='Jennifer Falcon' OR "CONTCTSM1"."FULL_NAME"='Test User' OR "CONTCTSM1"."FULL_NAME"='TEST USER UNITECH' OR "CONTCTSM1"."FULL_NAME"='Test09 Test09') AND NOT ("PROBSUMMARYM1"."OPENED_BY"='Jennifer Falcon' OR "PROBSUMMARYM1"."OPENED_BY"='Sachin Nehra' OR "PROBSUMMARYM1"."OPENED_BY"='Soniya Gupta' OR "PROBSUMMARYM1"."OPENED_BY"='Test User' OR "PROBSUMMARYM1"."OPENED_BY"='TEST USER UNITECH' OR "PROBSUMMARYM1"."OPENED_BY"='Test09 Test09')        Progaram Name ---crystal report    Login Name---- emsadmin

Print Page | Close Window