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.