MDM (Secondary) Sync / DB Issue CPM Process fails to start post upgrade to R81.20 from R81.10

[racse271]

Post upgrading to R81.20 MDM Secondary R81.20 it is down and CPM process is not starting.

Partial domain check error 

There are domains without a directory in $MDSDIR/customers
In case you can't fully delete/create the domain - address sk113134. If the issue wasn't resolved - open CFG task.

** There is a domain listed without directory

FWM Ports Check

Lists FWM is active and doesn't listen on port 18221 / 18190... etc...

There are errors also with SIC _FILE_CHECK.


CPM process doesn't start
1036 /opt/CPsuite-R81.20/fw1/log/cpm.elg.26:Caused by: java.net.ConnectException: Connection refused (Connection refused)
950 /opt/CPsuite-R81.20/fw1/log/cpm.elg.26:Caused by: java.net.ConnectException: ConnectException invoking https://127.0.0.1:8084/smartview/queryrfl/queryRFL: Connection refused (Connection refused)
74 /opt/CPsuite-R81.20/fw1/log/cpm.elg.25:Caused by: org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: ""
74 /opt/CPsuite-R81.20/fw1/log/cpm.elg.25:Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20140809-296a69f): org.eclipse.persistence.exceptions.DatabaseException
74 /opt/CPsuite-R81.20/fw1/log/cpm.elg.25:Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20140809-296a69f): org.eclipse.persistence.exceptions.DatabaseException
56 /opt/CPsuite-R81.20/fw1/log/cpm.elg.25:Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
47 /opt/CPsuite-R81.20/fw1/log/cpm.elg.26:Caused by: javax.xml.bind.MarshalException
42 /opt/CPsuite-R81.20/fw1/log/cpm.elg.3:Caused by: javax.xml.bind.MarshalException
39 /opt/CPsuite-R81.20/fw1/log/cpm.elg.25:Caused by: org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20140809-296a69f): org.eclipse.persistence.exceptions.DatabaseException
34 /opt/CPsuite-R81.20/fw1/log/cpm.elg.3:Caused by: java.net.ConnectException: Connection timed out (Connection timed out)
34 /opt/CPsuite-R81.20/fw1/log/cpm.elg.3:Caused by: com.ctc.wstx.exc.WstxIOException: Connection timed out (Connection timed out)
34 /opt/CPsuite-R81.20/fw1/log/cpm.elg.25:Caused by: java.net.ConnectException: Connection refused (Connection refused)
30 /opt/CPsuite-R81.20/fw1/log/cpm.elg.25:Caused by: java.net.ConnectException: ConnectException invoking https://127.0.0.1:8084/smartview/queryrfl/queryRFL: Connection refused (Connection refused)
29 /opt/CPsuite-R81.20/fw1/log/cpm.elg.2:Caused by: javax.xml.bind.MarshalException
29 /opt/CPsuite-R81.20/fw1/log/cpm.elg.2:Caused by: java.net.ConnectException: Connection timed out (Connection timed out)
29 /opt/CPsuite-R81.20/fw1/log/cpm.elg.2:Caused by: com.ctc.wstx.exc.WstxIOException: Connection timed out (Connection timed out)
27 /opt/CPsuite-R81.20/fw1/log/cpm.elg.26:Caused by: java.net.ConnectException: ConnectException invoking https://127.0.0.1:999/ILogsWs: Connection refused (Connection refused)
14 /opt/CPsuite-R81.20/fw1/log/cpm.elg.12:Caused by: com.checkpoint.infrastructure.utils.runtime.CpAssertionError: Trying to activate admin session for non-existing domain:
14 /opt/CPsuite-R81.20/fw1/log/cpm.elg.10:Caused by: com.checkpoint.infrastructure.utils.runtime.CpAssertionError: Trying to activate admin session for non-existing domain:
12 /opt/CPsuite-R81.20/fw1/log/cpm.elg.25:Caused by: javax.xml.bind.MarshalException

[PhoneBoy]

I’m presuming you’ve opened a TAC case here?

[racse271]

Yes, But not going anywhere. We are seeing domain check error for one particular domain. Just wondering if migrate and import DB from the Primary to the secondary manually will work.

[Vikas_Kakkar]

Were you able to fix this issue? We are experiencing the same issue as well.

[racse271]

As of now. issue is not yet resolved. TAC until this point were able to recreate the issue in LAB. We tried to rebuild Secondary MDM completely still it couldn't fix the issue. TAC is working on a Fix now.