Posted By: ankita — 22 Sep 2011 at 3:18am
plese tell em why crystal report blocks the database when we run it
Posted By: CircleD — 22 Sep 2011 at 7:59pm
What do you mean blocking the database?What kind of error message are you getting?
Posted By: ankita — 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 — 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
