Escape from boredom

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

Since Google did not return any hits for the error we had on one of our servers I add it here for future references. The error logged in SystemOut.log was

ContainerHelp E WSVR0501E: Error creating component
com.ibm.ws.runtime.component.CompositionUnitMgrImpl@593e2ce7 com.ibm.ws.exception.RuntimeWarning:
com.ibm.ws.exception.RuntimeError: java.lang.RuntimeException: java.lang.VerifyError: JVMVRFY024 arguments are not type compatible; class=”com”/ibm/ws/webcontainer/srt/SRTRequestContext…

The solution was to clear the WebSphere class caches as described in this IBM technote http://www-01.ibm.com/support/docview.wss?uid=swg21607887

First one up this morning, nothing else to do than enjoying myself with a bit of Powershell-scripting. Got stuck for a while, my script did not run due to the error “Bad numeric constant error”. Turned out that I had a variable starting with a number…which apperantly is bad. Removed the number and voila, all fine.

My iPhone 6 seems to be a bit crappy when it comes to do what you expect a phone to do – that is being able to call someone. The most obvious reason seems to be the antenna being…crappy. I wondered if I could be able to see the signal strength as a number, so as always Google to the rescue. The solution which worked for me was found here Numbers instead of signal dots?

1. Dial *3001#12345#* on your iPhone then press Call.
2. You’ll now enter Field Test mode. You’ll notice a signal strength indicator on the upper left hand corner of your screen. You can toggle between signal strength bars and a number by simply taping on it
3. At this point, press the home button to exit the app or if you would like the feature to be permanent, continue on. Don’t worry, the process is completely reversible.
4. Hold down on the Power button until you see the ‘slide to power off’ bar. Do not power off the device
5. Press down on the Home button until the app closes and you return to your home screen.

Note

• You can switch between signal as dots or numbers by double clicking on the indicator
• Note that the number is negative, the closer you are to 0, the better, all explained here at Stackoverflow in full details “What is meaning of negative dbm in signal strength.“

Now running 5.2.2, latest stable. Upgraded in less than 30 minutes with the _help_ of my youngest son. Easy as always…http://b2evolution.net/

Trying to stay connected with my laptop, did actually not manage. The distance from the router was to long, so have to stay inside for a while before the outdoor antenna arrives.

Using log4net in this example to write output, replace with Write-Host etc if needed. Piping to Out-String being the magic here, or else you just get the object class

 foreach ($m in $matches.GetEnumerator()) {
    $log.debugFormat("Matches are {0}", ($m | Out-String))
 }
			

Last week when in Copenhagen, having dinner at the Reef N´Beef, eating the crocodile tail filet. Along with it drinking aussie beer: Little Creatures Pale Ale and Rogers Beer (also from Little Creatures). All good. Before that I had the Tuborg Julebrygg in the hotel lobby.

The day after we all meet at Charlies bar before eating at Madklubben Steak

Small clip I found on Youtube from Charlies
[video:youtube:4dPId7d0b5U]

For those who understands Norwegian
Test-Path : Sotter ikke formatet i angitt bane.

Sotter?

Since I fear being hunted down by the Apple fanboys I know I have to behave when describing what I feel about my iPhone 5c right now which has a clock that does not work (the clock, how hard can it be?) And if you do not believe me, look at this link.

I do actually have my second phone now in just two weeks, both have the same issue, the whole medical history can be found posted here