Error with SPICE incremental refresh from Oracle Database view with joins

Question & Answer
, , ,
1

Hello all,

I’m using quicksight to visualize some data from on premise Oracle Database but SPICE incremental refresh fails.

I’m creating a view that joins two Oracle tables (left join) and uploading the data from that view into SPICE, but everytime the incremental refresh runs, fails with this error:

Error type:

SQL_EXCEPTION Learn more

This is a general SQL error. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.

Error details:

ORA-25137: Data value out of range

If the view consists of just one table, it works perfectly, but with a left join on it, it fails.

Any advice how to solve that problem?

Thank you

2

Hi @rjaraya -
I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!