# No errors but VERY incomplete mapped Postgres virtual graph

**URL:** <https://community.stardog.com/t/no-errors-but-very-incomplete-mapped-postgres-virtual-graph/2409>\
**Category:** Bug\
**Created:** [April 29, 2020, 9:10pm UTC](https://community.stardog.com/t/no-errors-but-very-incomplete-mapped-postgres-virtual-graph/2409 "2020-04-29T21:10:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![arwesterinen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/arwesterinen/32/40_2.png) [@arwesterinen](https://community.stardog.com/u/arwesterinen)\
**Post date:** [April 29, 2020, 9:10pm UTC](https://community.stardog.com/t/no-errors-but-very-incomplete-mapped-postgres-virtual-graph/2409/1 "2020-04-29T21:10:29Z")

</div>

We have a virtual graph mapping defined that executes against a 50M record table in Postgres DB. We have tried both a CONSTRUCT query and a SELECT query using this virtual graph (with the same results). Our mapping file defines 26 triples including the predicate, rdf:type, and different ontology-specific predicates, across 3 different individuals.

When we execute the queries, we get triples with only 3 of the predicates and don't get any triples for the remainder of the predicates (including rdf:type).

This is a very significant problem for us. Any help would be appreciated.

I can send you our mapping file (privately).

Andrea

---

<div class="post-metadata">

**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\
**Post date:** [April 29, 2020, 10:35pm UTC](https://community.stardog.com/t/no-errors-but-very-incomplete-mapped-postgres-virtual-graph/2409/2 "2020-04-29T22:35:41Z")

</div>

Please send the mappings to [paul.jackson@stardog.com](mailto:paul.jackson@stardog.com).

Thank you.

-Paul

---

<div class="post-metadata">

**Author:** ![arwesterinen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/arwesterinen/32/40_2.png) [@arwesterinen](https://community.stardog.com/u/arwesterinen)\
**Post date:** [April 30, 2020, 2:47am UTC](https://community.stardog.com/t/no-errors-but-very-incomplete-mapped-postgres-virtual-graph/2409/3 "2020-04-30T02:47:27Z")

</div>

Just sent. Thanks.

Andrea