AnsweredAssumed Answered

SQL DB Replication Support?

Question asked by TomConnery on May 4, 2009
Latest reply on Sep 23, 2009 by TomConnery
Has any other company or individual out there setup SQL replication of the niku DB?   We are really struggeling with replication as when we have it setup, the replication works but some of the essential datamart based job fail because and NBI table is published for replication.  See the error below....   We use MS SQL 2005.   So far I know the Rate Matrix, datamart extract, and rollup fails...  Any advice?!?!?   Thanks!      Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot truncate table 'NBI_PROJ_RES_RATES_AND_COSTS' because it is published for replication. Executed:  {call CMN_JOB_RATE_MATRIX_SP ( ?, ?, ? , ? , ? ) } Derived from statement:         @dynamic@         Referenced by: Using input: {P_SCHEDULER_PREP=1, P_COPY_RECORDS=1, P_JOB_RUN_ID=6489343, P_CREATE_RECORDS=1, P_JOB_USER_ID=5003036}  at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:1744)  at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:1797)  at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2255)  at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:692)  at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:601)  at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:450)  at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)  at com.niku.njs.listeners.SPJob.scheduledEventFired(SPJob.java:137)  at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:248)  at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)  at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot truncate table 'NBI_PROJ_RES_RATES_AND_COSTS' because it is published for replication.  at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)  at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)  at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)  at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)  at com.ca.clarity.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)  at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)  at com.ca.clarity.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)  at com.ca.clarity.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)  at com.ca.clarity.jdbc.base.BaseStatement.postImplExecute(Unknown Source)  at com.ca.clarity.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)  at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)  at com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)  at com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)  at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)  at java.lang.reflect.Method.invoke(Method.java:585)  at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)  at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$e3b18892.execute( )  at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2234)  ... 8 more  

Outcomes