cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Oracle DB Error: ORA-01555

I am importing data from Orcle BD using ODBC connecor. I didn't have any problem importing data from the same table before but now running into issues. The data is fairly large, more than million rows and about 25 columns. It starts out good but after several hours of import, I get below error: 

 

"Failed to save modifications to teh server. Error returned: ' OLD DB or ODBC error: [Datasource.error] Oracle: ORA-01555: snapshot too old: rollback segment number 76 with name" _SYSSMU76_1882479614$" too small".

 

I have no idea what this cryptic error means. I found this about ORA-01555 but don't understand it either. 

 

I can use DirectQuery without any issues but the DirectQuery is very very slow. 

 

Can somebody please help? 

 

Thanks, 

S.P

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Responsive Resident
Responsive Resident

Re: Oracle DB Error: ORA-01555

That error is coming from the oracle database.

 

It is an issue with the length of time that your transaction has been open. Oracle is trying to preserve the read context (What the database looked like when you started the query), but the data it needs has aged out of the UNDO Tablespace.

 

You have two options:

 

  1. Tune your query so that the data is returned quicker.
  2. Talk to your DBA about increasing the size of the UNDO tablespace.

 

http://www.orafaq.com/wiki/ORA-01555

View solution in original post

2 REPLIES 2
Highlighted
Responsive Resident
Responsive Resident

Re: Oracle DB Error: ORA-01555

That error is coming from the oracle database.

 

It is an issue with the length of time that your transaction has been open. Oracle is trying to preserve the read context (What the database looked like when you started the query), but the data it needs has aged out of the UNDO Tablespace.

 

You have two options:

 

  1. Tune your query so that the data is returned quicker.
  2. Talk to your DBA about increasing the size of the UNDO tablespace.

 

http://www.orafaq.com/wiki/ORA-01555

View solution in original post

Highlighted
Resolver I
Resolver I

Re: Oracle DB Error: ORA-01555

Thanks.. I will reduce the Query size and try it over the weekend. Hopefully, it will work. 

 

Is there a limit in Power BI on query time and table size? 

 

Thanks

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

August Community Highlights

Check out a full recap of the month!

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors