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.

[Ben Wagner]

Hi Tim/XNAT,

  I was wondering if you had a chance to try and reproduce this error?

Thanks,

Ben

[Timothy Olsen]

Apologies, Ben.  I haven't gotten back to this one.  

I was curious if maybe these were customized listings?  Or are they the 'auto-generated' ones that come on a project report?  Did you do a Save As on the ones that are broken?

Tim

Timothy R Olsen 

Founder, President

 t...@xnatworks.io

 xnatworks.io | Find us on LinkedIn! 

To view this discussion visit https://groups.google.com/d/msgid/xnat_discussion/CADVL1QyVB4Wzn6zeybSZce6v8Tornx5cTkO%2BW6DyAiDOu%3DrL9Q%40mail.gmail.com.

[Ben Wagner]

Hi Tim,

  Most have display documents (customized listings?).  Mainly these are xmllint --format of the build display as the build ones are ugly to look at.   Several contain simple additional fields (field references, not SQL).  I tried one without display docs for a fair trial and still get "Failed to create search results" and "org.postgresql.util.PSQLException: ERROR: column "sub_project_identifier_long" does not exist" in the SQL.log.  There are no saved/stored searches on the datatype trialled.

Ben

To view this discussion visit https://groups.google.com/d/msgid/xnat_discussion/CAOAXJbbs9vM_0s2y0zVibOfqX_pDeRDzmzD0x6X2aboLESvvuQ%40mail.gmail.com.