Fixes are available
Rational Asset Manager Fix Pack 1 (7.5.2.1) for 7.5.2
Rational Asset Manager Fix Pack 2 (7.5.2.2) for 7.5.2
Rational Asset Manager Interim Fix 9 for 7.5.2
Rational Asset Manager Fix Pack 3 (7.5.2.3) for 7.5.2
Rational Asset Manager Fix Pack 4 (7.5.2.4) for 7.5.2
Rational Asset Manager 7.5.3
Rational Asset Manager 7.5.3.1
Rational Asset Manager 7.5.3.2
Rational Asset Manager 7.5.3.3
Rational Asset Manager 7.5.4
Rational Asset Manager 7.5.4.1
Rational Asset Manager 7.5.4.2
Rational Asset Manager 7.5.4.3
Rational Asset Manager 7.5.4.4
Rational Asset Manager 7.5.4.5
Rational Asset Manager 7.5.4.6
Rational Asset Manager 7.5.4.7
Rational Asset Manager 7.5.4.9
Rational Asset Manager 7.5.4.8
Rational Asset Manager 7.5.4.10
APAR status
Closed as program error.
Error description
Abstract: Attempts to migrate to IBM Rational Asset Manager 7.5.2 when using Microsoft SQL Server DB may result in error 'Failed to migrate due to there is already an object named 'ASSETREL_UPDATED' in the database.' Error Description: Environment: - Microsoft Windows - IBM Rational Asset Manager 7.5.2 Reproducible Y/N: Y Description of problem: Migration of the repository after installation fails with the following error: Steps to reproduce Installed IBM Rational Asset Manager 7.5.2. After installation, when prompted with the 'Migration required' message, Press the 'Migrate' button. The migration will fail with the following error Upon inspection of the RAMDebug.log, you may see the following error: =================================================== [11/18/13 20:19:01 GMT] CRRAM0001E 311238 ERROR web pagecode.error.ErrorMigrate - Failed to migrate repository. com.ibm.ram.repository.core.IRepositoryAccess$RepositoryExceptio n: There is already an object named 'ASSETREL_UPDATED' in the database. at com.ibm.ram.repository.core.sdo.RAMSchemaAccess751.migrate751(RA MSchemaAccess751.java:1346) at com.ibm.ram.repository.core.sdo.RAMSchemaAccess72.migrate72(RAMS chemaAccess72.java:2114) at com.ibm.ram.repository.core.sdo.RAMSchemaAccess71.migrateCurrent (RAMSchemaAccess71.java:3151) at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.migrateRepos itory(BaseRAMSchemaAccess.java:12884) at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.migrateRepos itory(BaseRAMSchemaAccess.java:12846) at pagecode.error.ErrorMigrate.doMigrate(ErrorMigrate.java:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor Impl.java:48) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:600) at org.apache.el.parser.AstValue.invoke(AstValue.java:159) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.j ava:276) at com.sun.faces.application.MethodBindingMethodExpressionAdapter.i nvoke(MethodBindingMethodExpressionAdapter.java:88) at com.sun.faces.application.ActionListenerImpl.processAction(Actio nListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:387) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java :458) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.j ava:763) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApp licationPhase.java:82) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java :118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWr apper.java:1667) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWr apper.java:1602) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebApp FilterChain.java:149) at com.ibm.ram.repository.web.security.RAMServletFilter.doFilter(RA MServletFilter.java:591) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(Fi lterInstanceWrapper.java:190) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebApp FilterChain.java:125) at com.ibm.ram.repository.web.filters.CSRFSecurityFilter.doFilter(C SRFSecurityFilter.java:66) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(Fi lterInstanceWrapper.java:190) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebApp FilterChain.java:125) at com.ibm.ram.repository.web.filters.JavascriptSecurityFilter.doFi lter(JavascriptSecurityFilter.java:29) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(Fi lterInstanceWrapper.java:190) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebApp FilterChain.java:125) at com.ibm.ram.repository.web.filters.GZipFilter.doFilter(GZipFilte r.java:42) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(Fi lterInstanceWrapper.java:190) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebApp FilterChain.java:125) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAp pFilterChain.java:80) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebA ppFilterManager.java:908) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(Ser vletWrapper.java:939) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(Ser vletWrapper.java:507) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest (ServletWrapperImpl.java:181) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleReques t(CacheServletWrapper.java:91) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer. java:878) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContai ner.java:1592) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLin k.java:191) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscr imination(HttpInboundLink.java:453) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRe quest(HttpInboundLink.java:515) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequ est(HttpInboundLink.java:306) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complet e(HttpICLReadCallback.java:84) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureComp leted(AioReadCompletionListener.java:175) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyn cFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncC hannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHand ler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'ASSETREL_UPDATED' in the database. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabase Error(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQ LServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStateme nt(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doEx ecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:40 26) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand( SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(S QLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement (SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQ LServerStatement.java:642) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate(WSJdbcSt atement.java:1115) at com.ibm.ram.repository.core.sdo.RAMSchemaAccess751.migrate751(RA MSchemaAccess751.java:1328) ... 56 more WORKAROUND: None
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * RAM * **************************************************************** * PROBLEM DESCRIPTION: * * In RATLC02846833, at first the customer met an error said * * there is an "Incorrect syntax near ')'" during migration, we * * figure out that it is a defect ,defect 99794, we fix that * * defect ,then the next time when the customer try to migrate * * they met an error that there is already an object named * * 'ASSETREL_UPDATED' in the database. * * * * Here is the stack trace: * * at * * com.ibm.ram.repository.core.sdo.RAMSchemaAccess751.migrate75 * * 1(RAMSchemaAccess751.java:1346) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.core.sdo.RAMSchemaAccess72.migrate72( * * RAMSchemaAccess72.java:2114) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.core.sdo.RAMSchemaAccess71.migrateCur * * rent(RAMSchemaAccess71.java:3151) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.migrateR * * epository(BaseRAMSchemaAccess.java:12884) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.migrateR * * epository(BaseRAMSchemaAccess.java:12846) * * ¶ ¶ ¶ ¶ at * * pagecode.error.ErrorMigrate.doMigrate(ErrorMigrate.java:134) * * ¶ ¶ ¶ ¶ at * * sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) * * ¶ ¶ ¶ ¶ at * * sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce * * ssorImpl.java:48) * * ¶ ¶ ¶ ¶ at * * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe * * thodAccessorImpl.java:25) * * ¶ ¶ ¶ ¶ at java.lang.reflect.Method.invoke(Method.java:600) * * ¶ ¶ ¶ ¶ at * * org.apache.el.parser.AstValue.invoke(AstValue.java:159) * * ¶ ¶ ¶ ¶ at * * org.apache.el.MethodExpressionImpl.invoke(MethodExpressionIm * * pl.java:276) * * ¶ ¶ ¶ ¶ at * * com.sun.faces.application.MethodBindingMethodExpressionAdapt * * er.invoke(MethodBindingMethodExpressionAdapter.java:88) * * ¶ ¶ ¶ ¶ at * * com.sun.faces.application.ActionListenerImpl.processAction(A * * ctionListenerImpl.java:102) * * ¶ ¶ ¶ ¶ at * * javax.faces.component.UICommand.broadcast(UICommand.java:387 * * ) * * ¶ ¶ ¶ ¶ at * * javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot. * * java:458) * * ¶ ¶ ¶ ¶ at * * javax.faces.component.UIViewRoot.processApplication(UIViewRo * * ot.java:763) * * ¶ ¶ ¶ ¶ at * * com.sun.faces.lifecycle.InvokeApplicationPhase.execute(Invok * * eApplicationPhase.java:82) * * ¶ ¶ ¶ ¶ at * * com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) * * ¶ ¶ ¶ ¶ at * * com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl. * * java:118) * * ¶ ¶ ¶ ¶ at * * javax.faces.webapp.FacesServlet.service(FacesServlet.java:26 * * 5) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.servlet.ServletWrapper.service(Servl * * etWrapper.java:1667) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.servlet.ServletWrapper.service(Servl * * etWrapper.java:1602) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(We * * bAppFilterChain.java:149) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.web.security.RAMServletFilter.doFilte * * r(RAMServletFilter.java:591) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilte * * r(FilterInstanceWrapper.java:190) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(We * * bAppFilterChain.java:125) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.web.filters.CSRFSecurityFilter.doFilt * * er(CSRFSecurityFilter.java:66) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilte * * r(FilterInstanceWrapper.java:190) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(We * * bAppFilterChain.java:125) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.web.filters.JavascriptSecurityFilter. * * doFilter(JavascriptSecurityFilter.java:29) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilte * * r(FilterInstanceWrapper.java:190) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(We * * bAppFilterChain.java:125) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.web.filters.GZipFilter.doFilter(GZipF * * ilter.java:42) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilte * * r(FilterInstanceWrapper.java:190) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(We * * bAppFilterChain.java:125) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(W * * ebAppFilterChain.java:80) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter( * * WebAppFilterManager.java:908) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest * * (ServletWrapper.java:939) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest * * (ServletWrapper.java:507) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleReq * * uest(ServletWrapperImpl.java:181) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRe * * quest(CacheServletWrapper.java:91) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContai * * ner.java:878) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebCo * * ntainer.java:1592) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChanne * * lLink.java:191) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleD * * iscrimination(HttpInboundLink.java:453) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleN * * ewRequest(HttpInboundLink.java:515) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.process * * Request(HttpInboundLink.java:306) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.com * * plete(HttpICLReadCallback.java:84) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.future * * Completed(AioReadCompletionListener.java:175) * * ¶ ¶ ¶ ¶ at * * com.ibm.io.async.AbstractAsyncFuture.invokeCallback(Abstract * * AsyncFuture.java:217) * * ¶ ¶ ¶ ¶ at * * com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(As * * yncChannelFuture.java:161) * * ¶ ¶ ¶ ¶ at * * com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) * * ¶ ¶ ¶ ¶ at * * com.ibm.io.async.ResultHandler.complete(ResultHandler.java:2 * * 04) * * ¶ ¶ ¶ ¶ at * * com.ibm.io.async.ResultHandler.runEventProcessingLoop(Result * * Handler.java:775) * * ¶ ¶ ¶ ¶ at * * com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656) * * Caused by: * * com.microsoft.sqlserver.jdbc.SQLServerException: There is * * already an object named 'ASSETREL_UPDATED' in the database. * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.SQLServerException.makeFromData * * baseError(SQLServerException.java:196) * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResul * * t(SQLServerStatement.java:1454) * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteSta * * tement(SQLServerStatement.java:786) * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd. * * doExecute(SQLServerStatement.java:685) * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.jav * * a:4026) * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.SQLServerConnection.executeComm * * and(SQLServerConnection.java:1416) * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.SQLServerStatement.executeComma * * nd(SQLServerStatement.java:185) * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.SQLServerStatement.executeState * * ment(SQLServerStatement.java:160) * * ¶ ¶ ¶ ¶ at * * com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdat * * e(SQLServerStatement.java:642) * * ¶ ¶ ¶ ¶ at * * com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate(WSJd * * bcStatement.java:1115) * * ¶ ¶ ¶ ¶ at * * com.ibm.ram.repository.core.sdo.RAMSchemaAccess751.migrate75 * * 1(RAMSchemaAccess751.java:1328) * * ¶ ¶ ¶ ¶ ... 56 more * * * * * * This is a defect in RAM. The first time it went * * through the first migration and it set a flag (just a local * * flag 'did7510v20110401Migration') saying it went through * * that migration. And later on for the migration step at 1328 * * it had checked this flag and if it was set it then bypasses * * the migration. But because it went down between the two * * steps it didn't see that it had already did the migration * * because the flag was set to false on the second run. * * Then it will go through the code where the exception * * is throw ,but it is not caught by the right error code. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Fixed in https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem. WorkItem/100370
Temporary fix
Comments
APAR Information
APAR number
PI06576
Reported component name
RATL ASSET MGR
Reported component ID
5724R4200
Reported release
750
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-11-20
Closed date
2014-06-15
Last modified date
2014-06-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
RATL ASSET MGR
Fixed component ID
5724R4200
Applicable component levels
R752 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUS84","label":"Rational Asset Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
28 April 2022