XQE-DAT-0001 Data source adapter error: java.sql.SQLDataException: [Amazon][JDBC

[vikdev]

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".

[MFGF]

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.

[the6campbells]

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.