Problem with adding sections to program stage

Hi everyone,

I am having some challenges when trying to add sections to program stages for a tracker program. As you will see from the screenshot, the console does not really give me anything good to work off of. I tried this on the demo site and section management works fine, so I am guessing there is an issue with the specific instance I am working on. Has anyone come across this problem before, or have some guidance on where I can investigate this a bit further? I am using version 2.18.

Thanks,

Nick

image

Hi

Could you please give us the output from the log file? (catalina.out)

···

On Fri, Apr 10, 2015 at 12:13 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi everyone,

I am having some challenges when trying to add sections to program stages for a tracker program. As you will see from the screenshot, the console does not really give me anything good to work off of. I tried this on the demo site and section management works fine, so I am guessing there is an issue with the specific instance I am working on. Has anyone come across this problem before, or have some guidance on where I can investigate this a bit further? I am using version 2.18.

Thanks,

Nick


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Morten

Sorry I should have looked at the output more closely:
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ERROR: duplicate key value violates unique constraint “programstagesection_name_key”
Detail: Key (name)=(Patient Details) already exists.

It was because of the section name I was using. Sorry for the trouble everyone.

Nick

···

On Fri, Apr 10, 2015 at 1:17 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

Could you please give us the output from the log file? (catalina.out)


Morten

On Fri, Apr 10, 2015 at 12:13 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi everyone,

I am having some challenges when trying to add sections to program stages for a tracker program. As you will see from the screenshot, the console does not really give me anything good to work off of. I tried this on the demo site and section management works fine, so I am guessing there is an issue with the specific instance I am working on. Has anyone come across this problem before, or have some guidance on where I can investigate this a bit further? I am using version 2.18.

Thanks,

Nick


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Ok, great you figured it out :slight_smile:

···

On Fri, Apr 10, 2015 at 12:35 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Sorry I should have looked at the output more closely:
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ERROR: duplicate key value violates unique constraint “programstagesection_name_key”
Detail: Key (name)=(Patient Details) already exists.

It was because of the section name I was using. Sorry for the trouble everyone.

Nick


Morten

On Fri, Apr 10, 2015 at 1:17 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

Could you please give us the output from the log file? (catalina.out)


Morten

On Fri, Apr 10, 2015 at 12:13 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi everyone,

I am having some challenges when trying to add sections to program stages for a tracker program. As you will see from the screenshot, the console does not really give me anything good to work off of. I tried this on the demo site and section management works fine, so I am guessing there is an issue with the specific instance I am working on. Has anyone come across this problem before, or have some guidance on where I can investigate this a bit further? I am using version 2.18.

Thanks,

Nick


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Nick,

good catch. I have removed the section name uniqueness constraint in trunk now.

regards,

Lars

···

On Fri, Apr 10, 2015 at 7:35 AM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Sorry I should have looked at the output more closely:
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ERROR: duplicate key value violates unique constraint “programstagesection_name_key”
Detail: Key (name)=(Patient Details) already exists.

It was because of the section name I was using. Sorry for the trouble everyone.

Nick


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Fri, Apr 10, 2015 at 1:17 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

Could you please give us the output from the log file? (catalina.out)


Morten

On Fri, Apr 10, 2015 at 12:13 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi everyone,

I am having some challenges when trying to add sections to program stages for a tracker program. As you will see from the screenshot, the console does not really give me anything good to work off of. I tried this on the demo site and section management works fine, so I am guessing there is an issue with the specific instance I am working on. Has anyone come across this problem before, or have some guidance on where I can investigate this a bit further? I am using version 2.18.

Thanks,

Nick


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thanks Lars. Thats great for when we have inpatient/outpatient cases with similar details.

Nick

···

On Fri, Apr 10, 2015 at 7:35 AM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Sorry I should have looked at the output more closely:
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ERROR: duplicate key value violates unique constraint “programstagesection_name_key”
Detail: Key (name)=(Patient Details) already exists.

It was because of the section name I was using. Sorry for the trouble everyone.

Nick


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Fri, Apr 10, 2015 at 1:17 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

Could you please give us the output from the log file? (catalina.out)


Morten

On Fri, Apr 10, 2015 at 12:13 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi everyone,

I am having some challenges when trying to add sections to program stages for a tracker program. As you will see from the screenshot, the console does not really give me anything good to work off of. I tried this on the demo site and section management works fine, so I am guessing there is an issue with the specific instance I am working on. Has anyone come across this problem before, or have some guidance on where I can investigate this a bit further? I am using version 2.18.

Thanks,

Nick


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp