Error when running RpmgrInitializeLandscape in Spectrum 10.4.1
search cancel

Error when running RpmgrInitializeLandscape in Spectrum 10.4.1


Article ID: 145599


Updated On:


CA Spectrum


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(
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
        at java.lang.reflect.Constructor.newInstance(
        at com.mysql.jdbc.Util.handleNewInstance(
        at com.mysql.jdbc.Util.getInstance(
        at com.mysql.jdbc.SQLError.createSQLException(
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(
        at com.mysql.jdbc.MysqlIO.sendCommand(
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
        at com.mysql.jdbc.ConnectionImpl.execSQL(
        at com.mysql.jdbc.StatementImpl.executeUpdate(
        at com.mysql.jdbc.StatementImpl.executeUpdate(


Release : 10.4.1

Component : Spectrum Report Manager


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