rblog

Redneck repair

The wheel of the wheel barrow did actually explode a couple of weeks ago, scared the living h#”” out of Elin – she was pushing it while the wheel exploded with a huge bang. Anyhow, bought a new wheel with rim at Jula – the axle did fit, but the rim was a bit to small. But not to worry, did make these two spacers, works like a charm, redneck style!

Spinning to Kvelertak

Today, 47 minutes of rock’n roll, the new album Nattesferd by Kvelertak. Quite ok, I think I need to give it a few more times of playthrough before it really gets under my skin.

(Hike) Orienteering at Tukuhøgda

Last Friday I did map 1 of 4 from this years “Turorientering” – hike orientering (?) – in Aurskog Høland. It takes me places I for sure would not have gone otherwise, this time Tukuhøgda. Searching Google I find almost nothing about Tukuhøgda apart from weather reports and orienteering. But I what I did find was this article from 2012 about a couple out walking and meeting the wolf http://www.indre.no/lokale-nyheter/forfulgt-av-ulv/s/1-65-6142920 – so no doubt that turorientering is risky business.
.

Error during migration of Process Engine / Case Foundation

We are in the process of migrating our IBM Filenet 5.1 environment to 5.2. During migration of the process engine, while running the script rmove.bat the script failed while migrating the table with most data. The error was:
Creating Table PE_DB.VWLOG3_911
Exception occurred while executing SQL statement.
Exception = java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

We did not entierly believe that this was the root cause, but more suspected a timeout. After some investigation, one of our developers took a closer look into the .jar file used (regmove.jar). There he found out the following

The utility tries to create a temp table as a copy of all rows in the log. That probably fails due to out of space for extending the segments.
Then it tries to drop the temp table and fails here.


static final int DB_ORACLE = 4;

     if (srcDb.type == 4)
      {
        SQLHelper.execSQLStmt(srcDb.connection, "create table " + tmpTbl + " as " + "(select * from " + srcDb.schema + "." + sourceTableName + ")");

        srcRs = srcStmt.executeQuery("select * from " + tmpTbl);
      }
      else
      {
        srcRs = srcStmt.executeQuery("select * from " + srcDb.schema + "." + sourceTableName);
      }

      copyRows(srcDb, destDb, table, sourceTableName, destinationTableName, srcRs, batchSize);

      JDBCHelper.closeDBObject(srcStmt);
      JDBCHelper.closeDBObject(srcRs);
      JDBCHelper.closeDBObject(destStmt);
      if (srcDb.type == 4)
      {
        SQLHelper.dropTable(srcDb, tmpTbl);
      }

… This was also confirmed by the DBA. So he then increased the available space for the schema. We then had to drop all tables in the new schema and rerun the script, now with success. Or actually, it did fail yet another time, but this time the developers of the script had managed to provide the correct error message

*** Creating indices in destination region
Exception occurred while executing SQL statement.
Exception = java.sql.SQLException: ORA-01652: unable to extend temp segment by 1
28 in tablespace PE_DB_TS

Minjarudkollen

Actually almost two weeks ago, but we had the day off and together with friends and their kids we all went to Minjarudkollen http://www.ut.no/tur/2.15628/ A nice walk for all of us, about an hour each direction, highest point in Fetsund.