воскресенье, марта 31, 2013

Converting SVN to Mercurial

At citeck.ru we needed to migrate couple of our legacy projects from old subversion to mercurial.
We use mercurial from bitbucket .

Hg convert doesn't work at all with password protected svn repositories - "http authorization required".
It's a known problem:
http://stackoverflow.com/questions/3119058/how-can-i-get-hg-to-prompt-for-my-http-auth-username-password-on-cygwin-wind
http://www.grumpydev.com/2010/03/01/moving-a-repository-from-svn-to-mercurial-with-full-history/

So after some time googling and trying different workarounds I gave up and did the next steps.

1. Dumped repository backup I downloaded from our svn server:
svnadmin dump c:/svnbak/myrepo > repo_dump

2. Loaded repo dump to local svn server without http authoriation running on my pc:
svnadmin load c:\Repositories\myrepo < repo_dump

3. Converted and loaded to mercurial without "http authorization required":
hg convert http://localhost/myrepo
cd myrepo-hg
hg push https://bitbucket.org/myuser/myrepo

And as a result the nice mercurial repo with all the revisions from svn.

воскресенье, октября 16, 2011

IBM BPM Process Center database clean up

Cleaning IBM Business Process Manager 7.5 Process Center database will improve performance.
At first you need to export latest snapshots of process applications and toolkits you want to have after cleaning.
Than do something like described below.
Backup everything: database, profile, ec2 volume, make vm snapshot etc.

1. Stop server:
c:\BPM\75\profiles\ProcCtr01\bin\stopServer.bat server1 -username admin -password admin

2. Drop performance and process center schemas:
sqlplus sys/oracle@orcl as sysdba
drop user perfusr cascade;
drop user procusr cascade;

3. Create new ones and grant privileges:
create user procusr identified by procusr123;
create user perfusr identified by perfusr123;
grant execute on dbms_system to procusr;
grant execute on dbms_system to perfusr;
grant connect,resource,dba to procusr;
grant connect,resource,dba to perfusr;

4. Create tables and procedures for Process Center user from previously generated sql scripts for created at installation profile:
sqlplus procusr/procusr123@orcl
@C:\BPM\75\profiles\ProcCtr01\dbscripts\ProcessServer\Oracle\ORCL\createTable_ProcessServer.sql
@C:\BPM\75\profiles\ProcCtr01\dbscripts\ProcessServer\Oracle\ORCL\createProcedure_ProcessServer.sql

5. Create tables for Performance Server:
sqlplus perfusr/perfusr123@orcl
@C:\BPM\75\profiles\ProcCtr01\dbscripts\PerformanceDW\Oracle\ORCL\createTable_PerformanceDW.sql

6. Load bootstrap data(user attributes, system apps and toolkits, updates etc.):
c:\BPM\75\profiles\ProcCtr01\bin>bootstrapProcessServerData.bat

7. Start server and check logs for errors:
c:\BPM\75\profiles\ProcCtr01\bin\startServer.bat server1

Then import apps and toolkits from Process Center console.

WTRN0037W: The transaction service encountered an error on an xa_recover operation

Problem:
[10/15/11 19:24:25:755 EDT] 00000007 XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@42a542a5. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:638)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:1086)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:141)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:626)
at com.ibm.tx.jta.PartnerLogTable.recover(PartnerLogTable.java:389)
at com.ibm.tx.jta.RecoveryManager.resync(RecoveryManager.java:1530)
at com.ibm.tx.jta.RecoveryManager.performResync(RecoveryManager.java:2265)
at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:114)
at com.ibm.tx.jta.RecoveryManager.run(RecoveryManager.java:2218)
at java.lang.Thread.run(Thread.java:736)
Solution:
Exception occurs during recovery of Oracle database transactions
Error while starting a transaction on Oracle
Short solution:
grant select on DBA_PENDING_TRANSACTIONS to PUBLIC

суббота, августа 20, 2011

World eating software

They've got brilliant set of articles at Linkedin Today.

I like Marc Andreessen's article(Why Software Is Eating The World) at wall street journal very much.

"
...
American economy, in particular. It's not an accident that many of the biggest recent technology companies—including Google, Amazon, eBay and more—are American companies. Our combination of great research universities, a pro-risk business culture, deep pools of innovation-seeking equity capital and reliable business and contract law is unprecedented and unparalleled in the world.
...
"

IMHO theese are some of reasons why we will see no Sillicon Valley's in Russia.

среда, июля 27, 2011

Future of Software Engineering Career

"
..
"What we have found is you need product-oriented people," says Arvind Srinivasan, chief technology officer and co-founder of ZL Technologies. "They need to be able to work on a project from A to Z and solve problems at every level, not just be able to write code. We hire people with a mathematical background and a strong engineering sense." Srinivasan says one of the main things he wants to see from a job candidate is if they have already shipped a product. "If not, it doesn't matter how well you write code."
..
"

Career Focus: Software Engineering
BY JOHN R. PLATT


Interesting