Oracle Abort Code

ScottSandison · Post by **ScottSandison** » Fri Oct 20, 2006 11:47 am

Having a bit of bother running some Datastage. DBA/Sysprogs involved.

Error message is :

"AL_F_00111_MEDICAL_FEES_DIRECT_CREDIT_PROCESSED_DETAIL..TABLES: ORA-01114: IO error writing block to file 85 (block # 107641)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 131072
ORA-01114: "

DBAs have increased the temp table space up 5 Gb (10 times the size of the db). Also increased file space considerably.

The SQL we run has been running fine for the last 9 months, then it hit us with this yesterday.

Any pointers?

Cheers.

kcbland · Post by **kcbland** » Fri Oct 20, 2006 12:00 pm

Welcome aboard! Your problem is related to the database, not DataStage. A quick google on "ORA-27063: skgfospo:" found a lot of hits, I'm sure metalink has some tips as well. Sorry, but if DataStage can't get results from a query, it's usually the database. DataStage just issues SQL.

chulett · Post by **chulett** » Fri Oct 20, 2006 12:01 pm

Welcome. That should be all the information your DBAs need to solve the problem. It is strictly an Oracle problem, not anything to do with DataStage directly.

You ran out of space, nothing more to it. Or are you trying to nail down why you ran out of space? If so, would need more information to help - was this a temp space issue? A select query or one doing insert/updates?

ScottSandison · Post by **ScottSandison** » Fri Oct 20, 2006 4:55 pm

Thanks for replys guys, I'll get my DBAs to speak to Oracle and take it from there.

Cheers,

Scott.