Jump to content

Getting "Internal error" in TIBCO Data Virt on query that has UNPIVOT clause


Recommended Posts

We are getting a Internal error in TDV (QA) when trying to run queries that have UNPIVOT clause.

"An internal error has occurred."

"Unable to load data source with id "0" from repository. [datasrc-1234567] [Log ID: abcdefgh-abcd-abcd-abcd-acbdefghijkl]"

How do we find out why this error is coming

 

-------- The query is of the form as shown below ---------

SELECT

col_1, col_2, col_3

FROM

tbl

UNPIVOT

(

(col_1, col_2, col_3)

FOR

seq_nbr

IN

(

(tbl.col_1_1, tbl.col_1_2, tbl.col_1_3),

(tbl.col_2_1, tbl.col_2_2, tbl.col_2_3),

(tbl.col_3_1, tbl.col_3_2, tbl.col_3_3)

)

) alias_name

Link to comment
Share on other sites

×
×
  • Create New...