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 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 result in error 'Incorrect syntax near ')'' 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 will see the following error: =================================================== [13/11/13 02:05:24:240 GMT] 00000036 SystemOut O [11/13/13 02:05:24 GMT] CRRAM0001E 293224 ERROR web pagecode.error.ErrorMigrate - Failed to migrate repository. com.ibm.ram.repository.core.IRepositoryAccess$RepositoryExceptio n: Incorrect syntax near ')'. at com.ibm.ram.repository.core.sdo.RAMSchemaAccess751.migrate751(RA MSchemaAccess751.java:1168) 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: Incorrect syntax near ')'. 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:1153) ... 56 more WORKAROUND: None
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * RAM * **************************************************************** * PROBLEM DESCRIPTION: * * After attempting to migrate to RAM v7.5.2 from v7.5.0.2, * * during RAM repository * * migration step,Client unable to continue with * * migration,Encounters the "Incorrect syntax near ')'" error * * on the procedure. * * This is caused by the additional ")" in the code. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Fixed in https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem. WorkItem/99794
Temporary fix
Comments
APAR Information
APAR number
PI06179
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-14
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
Document Information
Modified date:
28 April 2022