Broken datatype displays.

[Ben Wagner]

Hello XNAT gurus,

  XNAT 1.9.3 and I'm having difficulty with "Failed to create search results" when trying to load the default tab for many custom datatypes.  Error in SQL.log is always the same:

org.postgresql.util.PSQLException: ERROR: column "sub_project_identifier_XXX" does not exist

XXXX is the project identifier.  sub_project_identifier_XXX seems to be an auto generated field.  Sometimes the log shows this possibly helpful tidbit (but I expect not):

Hint: Perhaps you meant to reference the column "search.mr_project_identifier_XXX".

I've attached one of the bad schemas.  This is affecting multiple shemas...some that haven't been touch in several years and XNAT versions.  

What is odd is I can access the data through the Brows >> Data  menu and through some existing custom searches in projects.

Any ideas would be appreciated.

Ben

[Timothy Olsen]

I think I'd need to see the search xml that the page is using for the failed listings (available in Dev Tools).  If it's easier to hop on a call and look at it together you could grab some time on my calendar here: Calendly

Tim

Timothy R Olsen 

Founder, President

 t...@xnatworks.io

 xnatworks.io | Find us on LinkedIn! 

--
You received this message because you are subscribed to the Google Groups "xnat_discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xnat_discussi...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/xnat_discussion/83616925-2e2f-40c6-8ca4-f7fde25a254bn%40googlegroups.com.

[Ben Wagner]

Hi Tim,

  I think I'm attaching what you want.  Also I've included the SQL statement that's failing.  I'm decent at SQL, but this computer generated statement a bit much for me.

Ben

To view this discussion visit https://groups.google.com/d/msgid/xnat_discussion/CAOAXJbaZ%3DOKybjaTYjtHn9bu3a8%3D1SUuUNK44-mn%3D1u_5c6_Yg%40mail.gmail.com.