Author Topic: beta3 civiCASE creating but not displaying cases (Read 2831 times)

creea1 · February 27, 2009, 04:36:47 pm

I have just installed beta3 on a Drupal6 ubuntu server, and configured civiCASE config files, case types, and activity types.

I can run through the process of creating a case, I can associate a case coordinator and click "done" but whe I return to the individual and click on "Case" tab no cases are displayed. I can see a number of cases in the civicrm_case table so I can see they are being created just not displayed.

However, if run through the process of creating a case, and I add a case activity "follow up" click "done", when I return to the individual and click on "Case" tab the case is displayed. However if I click on manage case it takes forever and returns a blank page.

The activities do not show up on case dashboard.

Unable to test any further now so would appreciate suggestions on this
Many thanks

Dave Greenberg · February 27, 2009, 04:58:32 pm

First guess is that the jquery / ajax functionality which is responsible for displaying the Case Activities under Manage Case and Case Dashboard is failing for some reason. I would get Firebug going in a Firefox browser and see if errors are reported when you try to load the Manage Case screen.

creea1 · February 27, 2009, 06:03:01 pm

Already have Firebug and there are no errors on Manage Case and Case Dashboard.

I had the problem of using "default" rather the "all" site, but I had already fixed that one.

Dave Greenberg · February 28, 2009, 05:24:39 pm

Blank page often indicates PHP / Apache error of some sort. Have you checked Drupal's watchdog / logs and your webserver logs for error messages?

Another thing to check is whether the AJAX url which grabs the case activities loads without errors.
On my localhost - the URL for this is:

http://localhost/dgg/drupal6t/civicrm/ajax/activity?snippet=4&caseID=3&cid=8

Swap in your civicrm URL, repladce caseId with a valid case.id from your site and cid with the contact.id of the contact whose case it is.
You should see a serialized set of data in your browser like this:

Code: [Select]

{ page: , total: 11, rows: [ {id:'14',cell:['February 12th, 2009 9:55 AM','','','Confirm expected admission date','Greenberg, Dave','Scheduled','Edit | Delete','1234461359']}, {id:'16',cell:['February 19th, 2009 9:55 AM','','','Follow up','Greenberg, Dave','Scheduled','Edit | Delete','1235066159']}, {id:'15',cell:['February 19th, 2009 9:55 AM','','','Confirm actual admission','Greenberg, Dave','Scheduled','Edit | Delete','1235066159']}, {id:'17',cell:['March 5th, 2009 9:55 AM','','','Confirm expected discharge date','Greenberg, Dave','Scheduled','Edit | Delete','1236275759']}, {id:'18',cell:['April 2nd, 2009 9:55 AM','','','Confirm actual discharge date','Greenberg, Dave','Scheduled','Edit | Delete','1238691359']}, {id:'20',cell:['','February 5th, 2009 10:35 AM','Need to get Dr. Smith into SFGH today - copy sent to ','Email','Greenberg, Dave','Completed','Edit | Delete','0']}, {id:'22',cell:['','February 5th, 2009 10:44 AM','Bed available in SFGH Psych Ward - copy sent to ','Email','Greenberg, Dave','Completed','Edit | Delete','0']}, {id:'21',cell:['','February 5th, 2009 10:44 AM','Bed available in SFGH Psych Ward - copy sent to John Caseman','Email','Greenberg, Dave','Completed','Edit | Delete','0']}, {id:'13',cell:['February 5th, 2009 9:55 AM','February 5th, 2009 10:42 AM','Bed available in SFGH Psych Ward','Plan inpatient admission','Greenberg, Dave','Completed','Edit | Delete','1233856559']}, {id:'12',cell:['February 5th, 2009 9:55 AM','February 5th, 2009 9:55 AM','Possible psychotic break triggered by death of spouse','Open Case','Greenberg, Dave','Completed','Edit | Delete','1233856559']}] }

creea1 · March 02, 2009, 01:20:17 am

Nothing of note in either apache2 logs or drupal logs

I ran
http://ec2-67-202-48-225.compute-1.amazonaws.com/drupal/civicrm/ajax/activity?snippet=4&caseID=8&cid=103
for each case.

Seven of the 8 cases I created came back with

Quote

{ page: , total: 0, rows: [] }

case 8 came back with

Quote

{ page: , total: 1, rows: [ {id:'544',cell:['27 Februaryth, 2009 7:24 PM','27 Februaryth, 2009 7:24 PM','okoko','Follow up','alistair@simplysolutions.co.nz','Scheduled','Edit | Delete','1235780699']}] }

Any more suggestions I am a bit stumped here.

Dave Greenberg · March 02, 2009, 02:22:48 pm

I've asked some others on the team for suggestions. In the meantime - can you zip up your case configuration directory and the .sql you used to populate case types, activity types and relationship types - and attach here or email to me dave at civicrm dot org .

demeritcowboy · March 02, 2009, 07:13:17 pm

One thing you can try is increasing these values in php.ini and restarting the web server and see if it makes a difference:
max_execution_time = 30 ; Maximum execution time of each script, in seconds
memory_limit = 16M

The default memory is rarely enough to run Drupal properly.

Note these values might also be found in your Drupal installation's settings.php, in which case those will override php.ini.

And it might be obvious but if you're ok with wiping the data and re-entering any custom settings you can try rebuilding the database from scratch. Maybe something got mixed up somewhere. Just make sure to log out of Drupal first because otherwise weird things happen.

cd <civi_root>/sql
mysql -u username -p
drop database civicrm_db; -- or whatever you've called your database
create database civicrm_db;
use civicrm_db;
source civicrm.mysql;
source civicrm_data.mysql;

creea1 · March 03, 2009, 02:28:34 am

I have done a complete reinstall of drupal 6.9 and civicrm 2.2b3 on a different server. However, the behavior continued. So I figured it must be my xml configuration.

I noticed I had no activity sets in my xml, so I added the following activity set from ReferralToCouncellor.xml

Code: [Select]

 
 <ActivitySets>
    <ActivitySet>
      <name>standard_timeline</name>
      <label>Standard Timeline</label>
      <timeline>true</timeline>
      <ActivityTypes>
        <ActivityType>
          <name>Open Case</name>
          <status>Closed</status>
        </ActivityType>
      </ActivityTypes>
    </ActivitySet>

It seems obvious now but without this activity set and activity type it did not create an "Open Case" activity, which must be needed for some case features.

Thanks for your assistance with this. My xml now is

Code: [Select]

  <name>Brief Intervention</name>
  <ActivityTypes>
    <ActivityType>
      <name>Open Case</name>
      <max_instances>1</max_instances>
     </ActivityType>
    <ActivityType>
      <name>Follow up</name>
    </ActivityType>
    <ActivityType>
      <name>Close Case</name>
    </ActivityType>
  </ActivityTypes>
  <ActivitySets>
    <ActivitySet>
      <name>standard_timeline</name>
      <label>Standard Timeline</label>
      <timeline>true</timeline>
      <ActivityTypes>
        <ActivityType>
          <name>Open Case</name>
          <status>Closed</status>
        </ActivityType>
      </ActivityTypes>
    </ActivitySet>

 </ActivitySets>
  <CaseRoles>
    <RelationshipType>
        <name>Case Coordinator</name>
        <creator>1</creator>
    </RelationshipType>
  </CaseRoles>
</CaseType>

demeritcowboy · March 03, 2009, 07:51:12 am

Yes the activity set is used to prepopulate a sequence of activities that act like "prompts" to the case manager to do those activities. Typically a case of a given type always has the same sequence, for example every intervention always has activities that need to be done like "Obtain consent forms", "Arrange intervention date and time", "Rehearse intervention", etc...

CiviCRM Community Forums (archive)

News:

Author Topic: beta3 civiCASE creating but not displaying cases (Read 2831 times)

creea1

beta3 civiCASE creating but not displaying cases

Dave Greenberg

Re: beta3 civiCASE creating but not displaying cases

creea1

Re: beta3 civiCASE creating but not displaying cases

Dave Greenberg

Re: beta3 civiCASE creating but not displaying cases

creea1

Re: beta3 civiCASE creating but not displaying cases

Dave Greenberg

Re: beta3 civiCASE creating but not displaying cases

demeritcowboy

Re: beta3 civiCASE creating but not displaying cases

creea1

Re: beta3 civiCASE creating but not displaying cases

demeritcowboy

Re: beta3 civiCASE creating but not displaying cases