Can only Create new Custom Entities, can't seem to query them via Connect API

Foss Tighe

I have created a new custom entity, I can use the API to create new entries, but I can't seem to query the custom entities via the API. 

The custom Entity is called test. When I create a new one I use the entity name test_obj, and when I query it I use select * from test_obj. But on the query I get the error message:

 Error #208: Invalid object name 'dbo.v_a400149_test_OBJ'. on line 1. 

 Any ideas?

 

Eric Pecoraro

Foss Tighe:

I have created a new custom entity, I can use the API to create new entries, but I can't seem to query the custom entities via the API. 

The custom Entity is called test. When I create a new one I use the entity name test_obj, and when I query it I use select * from test_obj. But on the query I get the error message:

 Error #208: Invalid object name 'dbo.v_a400149_test_OBJ'. on line 1. 

 Any ideas?

 

Not that this helps much, but I can query against our Custom Entities in the same manner with success.



Two possibilities, I think:



1. Because CEs are different animal, it's possible they may take a while to propogate (if you just created).



2. It's a specific customer db error. In that case you'd need to open a ticket/case.



Can you see the records from Sphere Admin?:



Contacts > Database Management > Manage Custom Entities >