Created some option set (Certified On: ABC, MNO;
Certified by: UVW, XYZ)
Created some data elements with Domain Type: Tracker and
Option set for data value Certified on and Certified By.
Created a Tracked Entity as ‘Service Provider’
Created a Program ‘Certification’ with Type: Multiple
Events with Registration; Tracked Entity: Service Provider; No for Show
Incidence Date; and with above two Attributes both were checked for Displaying
them on list.
Added a program stage for above program and both above
data elements were added to the program stage.
Assigned the program to above orgi unit
Assigned the program to super user group (i am using
super user group as well)
I went to the “Tracker Capture” Application
and select above orgi unit from orgi tree. Selected the program and register a
Provider.
As i tried to list all registered provider. system is
throwing am error. It shows
Failed to load resource: the server responded with a status
of 500 (Invalid column name; nested exception is java.sql.SQLException: Invalid
column name)
I don’t know where did i did the mistake. Please help me to
solve this issue. Thanking everyone in advance.
Created some option set (Certified On: ABC, MNO; Certified by: UVW, XYZ)
Created some data elements with Domain Type: Tracker and Option set for data value Certified on and Certified By.
Created a Tracked Entity as ‘Service Provider’
Created a Program ‘Certification’ with Type: Multiple Events with Registration; Tracked Entity: Service Provider; No for Show Incidence Date; and with above two Attributes both were checked for Displaying them on list.
Added a program stage for above program and both above data elements were added to the program stage.
Assigned the program to above orgi unit
Assigned the program to super user group (i am using super user group as well)
I went to the “Tracker Capture” Application and select above orgi unit from orgi tree. Selected the program and register a Provider.
As i tried to list all registered provider. system is throwing am error. It shows
Failed to load resource: the server responded with a status of 500 (Invalid column name; nested exception is java.sql.SQLException: Invalid column name)
I don’t know where did i did the mistake. Please help me to solve this issue. Thanking everyone in advance.
I am using version 2.18 and did experimented with 2.19 as well. I have downloaded the DHIS 2 Live (for windows) from dhis2.org and i am confused if i have to configure anything.
Ok, sounds strange. I’m not sure if live is 100% compatible with tracker or not, but I’m sure there are others that can answer that (it uses a different database)
I am using version 2.18 and did experimented with 2.19 as well. I have downloaded the DHIS 2 Live (for windows) from dhis2.org and i am confused if i have to configure anything.
Created some option set (Certified On: ABC, MNO; Certified by: UVW, XYZ)
Created some data elements with Domain Type: Tracker and Option set for data value Certified on and Certified By.
Created a Tracked Entity as ‘Service Provider’
Created a Program ‘Certification’ with Type: Multiple Events with Registration; Tracked Entity: Service Provider; No for Show Incidence Date; and with above two Attributes both were checked for Displaying them on list.
Added a program stage for above program and both above data elements were added to the program stage.
Assigned the program to above orgi unit
Assigned the program to super user group (i am using super user group as well)
I went to the “Tracker Capture” Application and select above orgi unit from orgi tree. Selected the program and register a Provider.
As i tried to list all registered provider. system is throwing am error. It shows
Failed to load resource: the server responded with a status of 500 (Invalid column name; nested exception is java.sql.SQLException: Invalid column name)
I don’t know where did i did the mistake. Please help me to solve this issue. Thanking everyone in advance.
I have deployed the system on ubuntu machine and followed the exact same steps and its working perfectly over there. I think there is some issue in Dhis2 Live for windows. Does anyone has got any workaround. And Thankx morten for your quick response.
Regards,Asiz