{"id":7805,"date":"2016-05-26T16:20:00","date_gmt":"2016-05-26T16:20:00","guid":{"rendered":""},"modified":"2026-04-18T22:31:30","modified_gmt":"2026-04-18T22:31:30","slug":"error-during-migration-of-process-engine-case-foundation","status":"publish","type":"post","link":"https:\/\/hellem.org\/wblog\/?p=7805","title":{"rendered":"Error during migration of Process Engine \/ Case Foundation"},"content":{"rendered":"<p>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:<br \/>\n<code>Creating Table  PE_DB.VWLOG3_911<br \/>\nException occurred while executing SQL statement.<br \/>\nException = java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist<br \/>\n<\/code><br \/>\nWe 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 <\/p>\n<blockquote><p>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.<br \/>\nThen it tries to drop the temp table and fails here.<br \/>\n<!-- codeblock lang= line=1 --><\/p>\n<pre class=\"codeblock\"><code>\r\nstatic final int DB_ORACLE = 4;\r\n\r\n     if (srcDb.type == 4)\r\n      {\r\n        SQLHelper.execSQLStmt(srcDb.connection, \"create table \" + tmpTbl + \" as \" + \"(select * from \" + srcDb.schema + \".\" + sourceTableName + \")\");\r\n\r\n        srcRs = srcStmt.executeQuery(\"select * from \" + tmpTbl);\r\n      }\r\n      else\r\n      {\r\n        srcRs = srcStmt.executeQuery(\"select * from \" + srcDb.schema + \".\" + sourceTableName);\r\n      }\r\n\r\n      copyRows(srcDb, destDb, table, sourceTableName, destinationTableName, srcRs, batchS<code><\/code>ize);\r\n\r\n      JDBCHelper.closeDBObject(srcStmt);\r\n      JDBCHelper.closeDBObject(srcRs);\r\n      JDBCHelper.closeDBObject(destStmt);\r\n      if (srcDb.type == 4)\r\n      {\r\n        SQLHelper.dropTable(srcDb, tmpTbl);\r\n      }<\/code><\/pre>\n<p><!-- \/codeblock -->\n<\/p><\/blockquote>\n<p>&#8230; 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 <!-- codeblock lang= line=1 --><\/p>\n<pre class=\"codeblock\"><code>*** Creating indices in destination region\r\nException occurred while executing SQL statement.\r\nException = java.sql.SQLException: ORA-01652: unable to extend temp segment by 1\r\n28 in tablespace PE_DB_TS<\/code><\/pre>\n<p><!-- \/codeblock --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[],"class_list":["post-7805","post","type-post","status-publish","format-standard","hentry","category-work-geek"],"_links":{"self":[{"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/posts\/7805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7805"}],"version-history":[{"count":1,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/posts\/7805\/revisions"}],"predecessor-version":[{"id":9774,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/posts\/7805\/revisions\/9774"}],"wp:attachment":[{"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}