[Bug 1608644] [NEW] DHIS2 Tracker API Not inserting Relationships

Public bug reported:

I am trying to send a json payload to update relationships for several hundred thousand tracked entities when I test with 10 records, I am getting a psql exception that null failed for column relationship typeid. I have set the column to NULL and succeeded in sending the JSON payload. I suspect the API CODE IS NOT setting the relationship typeid in the relationship table. The version of DHIS2 that I am using is 2.24 and build version is 23530.
rgds
David

** Affects: dhis2
     Importance: Undecided
         Status: New

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  New

Bug description:
  I am trying to send a json payload to update relationships for several hundred thousand tracked entities when I test with 10 records, I am getting a psql exception that null failed for column relationship typeid. I have set the column to NULL and succeeded in sending the JSON payload. I suspect the API CODE IS NOT setting the relationship typeid in the relationship table. The version of DHIS2 that I am using is 2.24 and build version is 23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

Download the hoji app then go to nascop@hoji.co.ke

···

On Aug 1, 2016 21:40, "generale" <1608644@bugs.launchpad.net> wrote:

Public bug reported:

I am trying to send a json payload to update relationships for several
hundred thousand tracked entities when I test with 10 records, I am getting
a psql exception that null failed for column relationship typeid. I have
set the column to NULL and succeeded in sending the JSON payload. I suspect
the API CODE IS NOT setting the relationship typeid in the relationship
table. The version of DHIS2 that I am using is 2.24 and build version is
23530.
rgds
David

** Affects: dhis2
     Importance: Undecided
         Status: New

--
You received this bug notification because you are subscribed to DHIS.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  New

Bug description:
  I am trying to send a json payload to update relationships for several
hundred thousand tracked entities when I test with 10 records, I am getting
a psql exception that null failed for column relationship typeid. I have
set the column to NULL and succeeded in sending the JSON payload. I suspect
the API CODE IS NOT setting the relationship typeid in the relationship
table. The version of DHIS2 that I am using is 2.24 and build version is
23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  New

Bug description:
  I am trying to send a json payload to update relationships for several hundred thousand tracked entities when I test with 10 records, I am getting a psql exception that null failed for column relationship typeid. I have set the column to NULL and succeeded in sending the JSON payload. I suspect the API CODE IS NOT setting the relationship typeid in the relationship table. The version of DHIS2 that I am using is 2.24 and build version is 23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

Sawa Mumo.
rgds
David

···

On 2 Aug 2016 09:25, "Jeremiah M.Mumo" <1608644@bugs.launchpad.net> wrote:

Download the hoji app then go to nascop@hoji.co.ke

On Aug 1, 2016 21:40, "generale" <1608644@bugs.launchpad.net> wrote:

> Public bug reported:
>
> I am trying to send a json payload to update relationships for several
> hundred thousand tracked entities when I test with 10 records, I am
getting
> a psql exception that null failed for column relationship typeid. I have
> set the column to NULL and succeeded in sending the JSON payload. I
suspect
> the API CODE IS NOT setting the relationship typeid in the relationship
> table. The version of DHIS2 that I am using is 2.24 and build version is
> 23530.
> rgds
> David
>
> ** Affects: dhis2
> Importance: Undecided
> Status: New
>
> --
> You received this bug notification because you are subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1608644
>
> Title:
> DHIS2 Tracker API Not inserting Relationships
>
> Status in DHIS:
> New
>
> Bug description:
> I am trying to send a json payload to update relationships for several
> hundred thousand tracked entities when I test with 10 records, I am
getting
> a psql exception that null failed for column relationship typeid. I have
> set the column to NULL and succeeded in sending the JSON payload. I
suspect
> the API CODE IS NOT setting the relationship typeid in the relationship
> table. The version of DHIS2 that I am using is 2.24 and build version is
> 23530.
> rgds
> David
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions
>

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  New

Bug description:
  I am trying to send a json payload to update relationships for several
hundred thousand tracked entities when I test with 10 records, I am getting
a psql exception that null failed for column relationship typeid. I have
set the column to NULL and succeeded in sending the JSON payload. I suspect
the API CODE IS NOT setting the relationship typeid in the relationship
table. The version of DHIS2 that I am using is 2.24 and build version is
23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  New

Bug description:
  I am trying to send a json payload to update relationships for several hundred thousand tracked entities when I test with 10 records, I am getting a psql exception that null failed for column relationship typeid. I have set the column to NULL and succeeded in sending the JSON payload. I suspect the API CODE IS NOT setting the relationship typeid in the relationship table. The version of DHIS2 that I am using is 2.24 and build version is 23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

Hi

Sorry, the API is not very clear here. What you need to do, is to
reference a relation ship type using the "relationship" property, if you
don't have any relationship types in the system, they can be created
through /api/relationshipTypes

So the full payload should be something like this:

{ trackedEntityInstanceA: "UID", trackedEntityInstanceB: "UID",
relationship: "UID }

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  New

Bug description:
  I am trying to send a json payload to update relationships for several hundred thousand tracked entities when I test with 10 records, I am getting a psql exception that null failed for column relationship typeid. I have set the column to NULL and succeeded in sending the JSON payload. I suspect the API CODE IS NOT setting the relationship typeid in the relationship table. The version of DHIS2 that I am using is 2.24 and build version is 23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

Hi Morten,
This explains why the payload was not working, the earlier json syntax you
sent to me did not have relationship: "UID" part. I will use the new one
sent so this is not a bug.
rgds
David

···

On 3 Aug 2016 13:10, "Morten Olav Hansen" <1608644@bugs.launchpad.net> wrote:

Hi

Sorry, the API is not very clear here. What you need to do, is to
reference a relation ship type using the "relationship" property, if you
don't have any relationship types in the system, they can be created
through /api/relationshipTypes

So the full payload should be something like this:

{ trackedEntityInstanceA: "UID", trackedEntityInstanceB: "UID",
relationship: "UID }

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  New

Bug description:
  I am trying to send a json payload to update relationships for several
hundred thousand tracked entities when I test with 10 records, I am getting
a psql exception that null failed for column relationship typeid. I have
set the column to NULL and succeeded in sending the JSON payload. I suspect
the API CODE IS NOT setting the relationship typeid in the relationship
table. The version of DHIS2 that I am using is 2.24 and build version is
23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  New

Bug description:
  I am trying to send a json payload to update relationships for several hundred thousand tracked entities when I test with 10 records, I am getting a psql exception that null failed for column relationship typeid. I have set the column to NULL and succeeded in sending the JSON payload. I suspect the API CODE IS NOT setting the relationship typeid in the relationship table. The version of DHIS2 that I am using is 2.24 and build version is 23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

Yes, sorry.. I left out the relationship part, hope you will get it
working now

closing this bug

** Changed in: dhis2
       Status: New => Invalid

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  Invalid

Bug description:
  I am trying to send a json payload to update relationships for several hundred thousand tracked entities when I test with 10 records, I am getting a psql exception that null failed for column relationship typeid. I have set the column to NULL and succeeded in sending the JSON payload. I suspect the API CODE IS NOT setting the relationship typeid in the relationship table. The version of DHIS2 that I am using is 2.24 and build version is 23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

Many thanks, I will it worked when I set relationshiptypeid to null and
tested.
Rgds
David

···

On 3 Aug 2016 13:35, "Morten Olav Hansen" <1608644@bugs.launchpad.net> wrote:

Yes, sorry.. I left out the relationship part, hope you will get it
working now

closing this bug

** Changed in: dhis2
       Status: New => Invalid

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  Invalid

Bug description:
  I am trying to send a json payload to update relationships for several
hundred thousand tracked entities when I test with 10 records, I am getting
a psql exception that null failed for column relationship typeid. I have
set the column to NULL and succeeded in sending the JSON payload. I suspect
the API CODE IS NOT setting the relationship typeid in the relationship
table. The version of DHIS2 that I am using is 2.24 and build version is
23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1608644

Title:
  DHIS2 Tracker API Not inserting Relationships

Status in DHIS:
  Invalid

Bug description:
  I am trying to send a json payload to update relationships for several hundred thousand tracked entities when I test with 10 records, I am getting a psql exception that null failed for column relationship typeid. I have set the column to NULL and succeeded in sending the JSON payload. I suspect the API CODE IS NOT setting the relationship typeid in the relationship table. The version of DHIS2 that I am using is 2.24 and build version is 23530.
  rgds
  David

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1608644/+subscriptions