TIBCO add user error

昨天开始接到用户提报，说是iprocess没有同步个人账号。这个简单，在我们本身的程序上跑一下就可以添加。所以很简单运行一下。com.staffware.sso.data.vException: SAL system error what？报错了？我晕，当时简单的认为，这个应该是我们本身服务可能有点问题。于是在周末的时候重启了iprocess的服务。重新添加新用户还是不行。这下子问题大了。 查看详细的输出日志是 2012-03-10 06:00:20,181-234966391[Thread-4]ERROR com.comwave.ww_oa.daemon.processor.impl.AccountSyncProcessorImpl - create new iprocess account fail, account:[00121350]
INFO | jvm 1 | 2012/03/10 06:00:20 | 2012-03-10 06:00:20,181-234966391[Thread-4]ERROR com.comwave.ww_oa.daemon.processor.impl.AccountSyncProcessorImpl - com.staffware.sso.data.vException: SAL system error.
INFO | jvm 1 | 2012/03/10 06:00:20 | com.comwave.staffware.sso.SSOException: com.staffware.sso.data.vException: SAL system error.
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.staffware.sso.UserCore.createUser(UserCore.java:83)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.staffware.sso.SSOCore.createUser(SSOCore.java:751)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.ww_oa.daemon.processor.impl.AccountSyncProcessorImpl.createNewUser(AccountSyncProcessorImpl.java:134)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.ww_oa.daemon.processor.impl.AccountSyncProcessorImpl.createAllNewUsers(AccountSyncProcessorImpl.java:117)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.ww_oa.daemon.processor.impl.AccountSyncProcessorImpl.process(AccountSyncProcessorImpl.java:52)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.ww_oa.daemon.SyncAccountInfoDaemon.processAccountSync(SyncAccountInfoDaemon.java:132)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.ww_oa.daemon.SyncAccountInfoDaemon.processSync(SyncAccountInfoDaemon.java:84)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.ww_oa.daemon.SyncAccountInfoDaemon.process(SyncAccountInfoDaemon.java:61)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.daemon.TimerThread.run(TimerThread.java:55)
INFO | jvm 1 | 2012/03/10 06:00:20 | Caused by: com.staffware.sso.data.vException: SAL system error.
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.staffware.sso.jbase.sNode.createUser(Native Method)
INFO | jvm 1 | 2012/03/10 06:00:20 | at com.comwave.staffware.sso.UserCore.createUser(UserCore.java:76)
INFO | jvm 1 | 2012/03/10 06:00:20 | ... 8 more 看了报错信息是同步账号出错，一步一步追查下去是本身TIBCO的东东 然后去查了iprocess本身DB发现 select * from USER_NAMES order by user_id desc 最大user_id到了99999，这个数字这个奇怪。难道是到了5位数就报错了？重新删除最大的一笔，然后新增就可以了。但是在增加就报错了。看来的确是99999的极限啦！ 初步是想，难道这个会有限制。目前还在追踪如何解决。先记录一下排查过程