• Sign In
  1. Messages

Error in clicking "EDIT" or "DETAILS" of a ETL created table

LabKey Support Forum

View Message

view list print
Error in clicking "EDIT" or "DETAILS" of a ETL created table marcia hon  2018-06-06 08:19
Status: Closed
 

I created a table via ETL module and I populate it via a StoredProcedure module.

However, when I try to Edit / see Details of the records, I get this error:

An unexpected error occurred
ExecutingSelector; uncategorized SQLException for SQL []; SQL state [XX000]; error code [0]; ERROR: failed to find conversion function from unknown to text; nested exception is org.postgresql.util.PSQLException: ERROR: failed to find conversion function from unknown to text

I look forward to your response.

Thanks,
Marcia
 
 
marcia hon responded:  2018-06-06 09:36

I solved it.

Apparently, my primary key was spelled incorrectly.

Also, I did casting to integer when inserting/updating.

Thanks,
Marcia