Hi,
First Time I am using Amazon Redshift as a Data Source for my Cognos model . I imported almost 35 Query Subjects into Database View and try to validate and all of them are validated. After validating I was trying to test the each and every Query Subject with Sample Test data to see any data loaded. I was successfully tested 25 QS's and 10 of them I got the below error. Can Any one give some suggestion how do I resolve the Issue.
XQE-DAT-0001 Data source adapter error: java.sql.SQLDataException: [Amazon][JDBC](10140) Error converting value to short. - when processing query: SELECT
"Conversation_Dim"."id" AS "Id",
"Conversation_Dim"."canvas_id" AS "Canvas_Id",
"Conversation_Dim"."has_attachments" AS "Has_Attachments",
"Conversation_Dim"."has_media_objects" AS "Has_Media_Objects",
"Conversation_Dim"."subject" AS "Subject",
"Conversation_Dim"."course_id" AS "Course_Id",
"Conversation_Dim"."group_id" AS "Group_Id",
"Conversation_Dim"."account_id" AS "Account_Id"
FROM
"public"."conversation_dim" "Conversation_Dim".
Quote from: vikdev on 17 May 2017 04:10:47 PM
Hi,
First Time I am using Amazon Redshift as a Data Source for my Cognos model . I imported almost 35 Query Subjects into Database View and try to validate and all of them are validated. After validating I was trying to test the each and every Query Subject with Sample Test data to see any data loaded. I was successfully tested 25 QS's and 10 of them I got the below error. Can Any one give some suggestion how do I resolve the Issue.
XQE-DAT-0001 Data source adapter error: java.sql.SQLDataException: [Amazon][JDBC](10140) Error converting value to short. - when processing query: SELECT
"Conversation_Dim"."id" AS "Id",
"Conversation_Dim"."canvas_id" AS "Canvas_Id",
"Conversation_Dim"."has_attachments" AS "Has_Attachments",
"Conversation_Dim"."has_media_objects" AS "Has_Media_Objects",
"Conversation_Dim"."subject" AS "Subject",
"Conversation_Dim"."course_id" AS "Course_Id",
"Conversation_Dim"."group_id" AS "Group_Id",
"Conversation_Dim"."account_id" AS "Account_Id"
FROM
"public"."conversation_dim" "Conversation_Dim".
I might be wrong, but that error sounds to me like a problem with the JDBC driver? Have you checked to see if there are any updated drivers you can use?
MF.
I suggest you add the Redshift JDBC driver tracing onto the connection.
It implies that the JDBC driver has failed to convert a value in the data in response to a get request on a column in the Result set the JDBC driver has returned.
For example, might you have a boolean column in the database which the driver is describing as a JDBC BIT TYPE (not boolean).
Hence, an attempt to bind that value as short causes the driver to fail.
Your "has" fields at a guess are booleans.