So the DBAs took a data file offline last night and it’s wrecking havoc with some, but not all, of our reports. There’s another data file out there, but for some reason BO seems stuck on the one that’s gone.
The actual error is: ORA-00372: file 3 cannot be modified at this time :ORA-01110: data file 3: ‘/u09/oradata/crisprod/cris_temp01.dbf’ :-372
The Oracle solution is to keep trying to run the query because, eventually, it’ll look to the other data file. Not working. In fact, I recreated a much smaller query in a brand new .rep file and still got the error… I couldn’t narrow it down to an object either… it was just certain combinations that went all haywire.
I really doubt it…so your DBAs can’t restore things back to how there were. My only idea and its a real long shot is you know how you can specify that a certain connection should always use a certain oracle hint? In this Custom tab there tend to be a few different parameters…now I don’t know how you add ones to it…but maybe that could an approach. Or, if you can get some SQL from the DBAs which in essence says ignore this data file or use this other data file, maybe you could put this in an object and add it to a query as the first object, just like you do if you use oracle hints in objects?
Thanks for the ideas, Nick. “Luckily” it’s more of an Oracle issue than a Business Objects one… All of our stuff is breaking now. Of course I say luckily because it makes it not my problem.
You’re stuck – if a query requires data from that datafile then there’s nothing you can do about it. Having a data file offline is not a normal operating environment for Oracle.
(BOB member since 2002-06-25)
(BOB member since 2002-08-15)
(BOB member since 2002-09-10)