need some help

Hi All,

Attached is a message i get when I try to delete repeated facilities
in my database. What can I do?

Thanks

Screenshot.docx (256 KB)

Hi

This means that data has been collected for the facility you want to delete.

Check the datavalue table for datavalues that have source = facilityId

···

--
Morten

On Fri, Jan 6, 2012 at 3:07 PM, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi All,

Attached is a message i get when I try to delete repeated facilities
in my database. What can I do?

Thanks

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

Hi Morten,

Where can I go to do this?

Stephen

···

On 1/6/12, Morten Olav Hansen <mortenoh@gmail.com> wrote:

Hi

This means that data has been collected for the facility you want to delete.

Check the datavalue table for datavalues that have source = facilityId

--
Morten

On Fri, Jan 6, 2012 at 3:07 PM, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi All,

Attached is a message i get when I try to delete repeated facilities
in my database. What can I do?

Thanks

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

Replying to the list.

···

---------- Forwarded message ----------
From: Knut Staring knutst@gmail.com

Date: Fri, Jan 6, 2012 at 4:03 PM
Subject: Re: [Dhis2-users] need some help
To: Stephen Gbanyan mambu9@gmail.com

Hi Stephen,

You can do this in PgAdmin - but of course you really should be careful that you only delete exactly what you want to delete.

In PgAdmin, click on the database, then click on the SQL icon in the toolbar.

Assuming the orgunit you want to remove is ACFI Clinic, you can then run the following query (by hitting the green arrow button):

SELECT organisationunitid, name FROM organisationunit WHERE name=‘ACFI Clinic’;

Now that you are certain of the organisatoinunitid (e.g. 12345), you can replace 12345 into the following statement:

DELETE FROM datavalue WHERE sourceid=12345;

Knut

On Fri, Jan 6, 2012 at 3:27 PM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi Morten,

Where can I go to do this?

Stephen

On 1/6/12, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

This means that data has been collected for the facility you want to delete.

Check the datavalue table for datavalues that have source = facilityId

Morten

On Fri, Jan 6, 2012 at 3:07 PM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi All,

Attached is a message i get when I try to delete repeated facilities

in my database. What can I do?

Thanks


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


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

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

Hi All,

I just got one of our counties computer with the DHIS2 not working on
properly I have tried to uninstall and install the entire software.
When I go through the installation almost to the end I get this
message:

Warning: Problem running post-install step. Installation may not
complete correctly. The database cluster initialisation failed.

Thanks

Stephen

···

On 1/6/12, Knut Staring <knutst@gmail.com> wrote:

Hi Stephen,

You can do this in PgAdmin - but of course you really should be careful
that you only delete exactly what you want to delete.

In PgAdmin, click on the database, then click on the SQL icon in the
toolbar.

Assuming the orgunit you want to remove is ACFI Clinic, you can then run
the following query (by hitting the green arrow button):

SELECT organisationunitid, name FROM organisationunit WHERE name='ACFI
Clinic';

Now that you are certain of the organisatoinunitid (e.g. 12345), you can
replace 12345 into the following statement:

DELETE FROM datavalue WHERE sourceid=12345;

Knut

On Fri, Jan 6, 2012 at 3:27 PM, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi Morten,

Where can I go to do this?

Stephen

On 1/6/12, Morten Olav Hansen <mortenoh@gmail.com> wrote:
> Hi
>
> This means that data has been collected for the facility you want to
delete.
>
> Check the datavalue table for datavalues that have source = facilityId
>
> --
> Morten
>
>
>
> On Fri, Jan 6, 2012 at 3:07 PM, Stephen Gbanyan <mambu9@gmail.com> >> wrote:
>> Hi All,
>>
>> Attached is a message i get when I try to delete repeated facilities
>> in my database. What can I do?
>>
>> Thanks
>>
>> _______________________________________________
>> Mailing list: DHIS 2 Users in Launchpad
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : DHIS 2 Users in Launchpad
>> More help : ListHelp - Launchpad Help
>>
>

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

Stephen, I think you mean PostgreSQL, not DHIS2. Is this on Windows Vista or Windows 7?

It looks as though the issue might be permissions. Try to install PostgreSQL in another folder that is not inside Program Files. Please read this post and the follow-ups:

http://forums.enterprisedb.com/posts/list/1891.page;jsessionid=EE9E7172F5C0CAAF48A7FB16E06D6FE6#10942

Please let us know how it goes,

Knut

···

On Fri, Jan 6, 2012 at 4:25 PM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi All,

I just got one of our counties computer with the DHIS2 not working on

properly I have tried to uninstall and install the entire software.

When I go through the installation almost to the end I get this

message:

Warning: Problem running post-install step. Installation may not

complete correctly. The database cluster initialisation failed.

Thanks

Stephen

On 1/6/12, Knut Staring knutst@gmail.com wrote:

Hi Stephen,

You can do this in PgAdmin - but of course you really should be careful

that you only delete exactly what you want to delete.

In PgAdmin, click on the database, then click on the SQL icon in the

toolbar.

Assuming the orgunit you want to remove is ACFI Clinic, you can then run

the following query (by hitting the green arrow button):

SELECT organisationunitid, name FROM organisationunit WHERE name='ACFI

Clinic’;

Now that you are certain of the organisatoinunitid (e.g. 12345), you can

replace 12345 into the following statement:

DELETE FROM datavalue WHERE sourceid=12345;

Knut

On Fri, Jan 6, 2012 at 3:27 PM, Stephen Gbanyan mambu9@gmail.com wrote:

Hi Morten,

Where can I go to do this?

Stephen

On 1/6/12, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

This means that data has been collected for the facility you want to

delete.

Check the datavalue table for datavalues that have source = facilityId

Morten

On Fri, Jan 6, 2012 at 3:07 PM, Stephen Gbanyan mambu9@gmail.com > > >> wrote:

Hi All,

Attached is a message i get when I try to delete repeated facilities

in my database. What can I do?

Thanks


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


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

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


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


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

Hi Knut,

Thanks it work.

Stephen

···

On 1/6/12, Knut Staring <knutst@gmail.com> wrote:

Stephen, I think you mean PostgreSQL, not DHIS2. Is this on Windows Vista
or Windows 7?

It looks as though the issue might be permissions. Try to install PostgreSQL
in another folder that is not inside Program Files. Please read this post
and the follow-ups:
http://forums.enterprisedb.com/posts/list/1891.page;jsessionid=EE9E7172F5C0CAAF48A7FB16E06D6FE6#10942

Please let us know how it goes,
Knut

On Fri, Jan 6, 2012 at 4:25 PM, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi All,

I just got one of our counties computer with the DHIS2 not working on
properly I have tried to uninstall and install the entire software.
When I go through the installation almost to the end I get this
message:

Warning: Problem running post-install step. Installation may not
complete correctly. The database cluster initialisation failed.

Thanks

Stephen

On 1/6/12, Knut Staring <knutst@gmail.com> wrote:
> Hi Stephen,
>
> You can do this in PgAdmin - but of course you really should be careful
> that you only delete exactly what you want to delete.
>
> In PgAdmin, click on the database, then click on the SQL icon in the
> toolbar.
>
> Assuming the orgunit you want to remove is ACFI Clinic, you can then run
> the following query (by hitting the green arrow button):
>
> SELECT organisationunitid, name FROM organisationunit WHERE name='ACFI
> Clinic';
>
> Now that you are certain of the organisatoinunitid (e.g. 12345), you can
> replace 12345 into the following statement:
>
> DELETE FROM datavalue WHERE sourceid=12345;
>
> Knut
>
>
>
>
>
>
>
>
> On Fri, Jan 6, 2012 at 3:27 PM, Stephen Gbanyan <mambu9@gmail.com> >> wrote:
>
>> Hi Morten,
>>
>> Where can I go to do this?
>>
>> Stephen
>>
>> On 1/6/12, Morten Olav Hansen <mortenoh@gmail.com> wrote:
>> > Hi
>> >
>> > This means that data has been collected for the facility you want to
>> delete.
>> >
>> > Check the datavalue table for datavalues that have source =
>> > facilityId
>> >
>> > --
>> > Morten
>> >
>> >
>> >
>> > On Fri, Jan 6, 2012 at 3:07 PM, Stephen Gbanyan <mambu9@gmail.com> >> >> wrote:
>> >> Hi All,
>> >>
>> >> Attached is a message i get when I try to delete repeated facilities
>> >> in my database. What can I do?
>> >>
>> >> Thanks
>> >>
>> >> _______________________________________________
>> >> Mailing list: DHIS 2 Users in Launchpad
>> >> Post to : dhis2-users@lists.launchpad.net
>> >> Unsubscribe : DHIS 2 Users in Launchpad
>> >> More help : ListHelp - Launchpad Help
>> >>
>> >
>>
>> _______________________________________________
>> Mailing list: DHIS 2 Users in Launchpad
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : DHIS 2 Users in Launchpad
>> More help : ListHelp - Launchpad Help
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org