Error when running RpmgrInitializeLandscape in Spectrum 10.4.1

book

Article ID: 145599

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

Error when running RpmgrInitializeLandscape in Spectrum 10.4.1:

Got Exception initializing all landscapes
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'instant_event_sync_time = DATE_ADD( TIMESTAMP(DATE(NOW())), interval -50 day )' at line 1
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1648)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1567)
        at com.aprisma.spectrum.app.repmgr.util.RpmgrInitializeLandscape.truncateAllTables(RpmgrInitializeLandscape.java:325)
        at com.aprisma.spectrum.app.repmgr.util.RpmgrInitializeLandscape.main(RpmgrInitializeLandscape.java:203)

Environment

Release : 10.4.1

Component : Spectrum Report Manager

Resolution

This issue is addressed in the 10.04.01.PTF_10.4.107 patch.

If specific landscapes need to be deleted in a DSS environment (not all) then please request 10.04.01.PTF_10.4.116 patch from Support.

It is also scheduled to be addressed in the Spectrum 10.4.1_BMP patch when released. No projected release date at the time of the publishing of this knowledge article.

Additional Information

Usage for Report Manager Initialize Landscape

Report Manager Initialize