Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: kfree on July 13, 2021, 06:37:41 am

Title: Pro Cloud Server 4.2 stops working
Post by: kfree on July 13, 2021, 06:37:41 am
Hi,
I've been having an issue with the Pro Cloud Server randomly stopping listening on the assigned port.  If I stop the Sparx server and restart it.  It begins working again.

A partial log looks like this:
2021-07-06 12:47:47 [INFO]:    [AUDIT] Start. Period: 2021-07-06 11:47:47 to 2021-07-06 12:47:47 (0d, 1h 0m 0s)
2021-07-06 12:47:47 [INFO]:    [AUDIT] msdasql.1:anonymous@enterprise_architect                          | Free:   0 | Max Active:   0 | Acquisitions:      0 |
2021-07-06 12:47:47 [INFO]:    [AUDIT] End.
2021-07-06 13:33:30 [INFO]: ** Service Stop request received.
2021-07-06 13:33:30 [INFO]: ** Received service stop signal


Startup info is as follows:
2021-06-28 12:47:41 [INFO]:    #####################################################################################################
2021-06-28 12:47:41 [INFO]:    #                                   Sparx Systems Pro Cloud Server                                  #
2021-06-28 12:47:41 [INFO]:    #####################################################################################################
2021-06-28 12:47:41 [INFO]:    # Versions                                                                                          #
2021-06-28 12:47:41 [INFO]:    #   Cloud    : 4.02.0064                                                                            #
2021-06-28 12:47:41 [INFO]:    #   Protocol : 6.0                                                                                  #
2021-06-28 12:47:41 [INFO]:    #   OS       : Windows 6.02                                                                         #
2021-06-28 12:47:41 [INFO]:    #                                                                                                   #
2021-06-28 12:47:41 [INFO]:    # Start Time : 2021-06-28 12:47:41                                                                  #
2021-06-28 12:47:41 [INFO]:    #                                                                                                   #
2021-06-28 12:47:41 [INFO]:    # Folders                                                                                           #
2021-06-28 12:47:41 [INFO]:    #   Service  : D:\apps\Sparx Systems\Service                                                        #
2021-06-28 12:47:41 [INFO]:    #   Logging  : D:\apps\Sparx Systems\Service\Logs                                                   #
2021-06-28 12:47:41 [INFO]:    #   Temp     : D:\apps\Sparx Systems\Service\Temp                                                   #
2021-06-28 12:47:41 [INFO]:    #                                                                                                   #
2021-06-28 12:47:41 [INFO]:    # Cloud License                                                                                     #
2021-06-28 12:47:41 [INFO]:    #   Path     : D:\apps\Sparx Systems\Service\Licenses\                                              #
2021-06-28 12:47:41 [WARNING]: #   Error    : Failed to find any license certificate (*.crt) files                                 #
2021-06-28 12:47:41 [INFO]:    #   Edition  : Free                                                                                 #
2021-06-28 12:47:41 [INFO]:    #                                                                                                   #
2021-06-28 12:47:41 [INFO]:    # Floating License Server                                                                           #
2021-06-28 12:47:41 [INFO]:    #   Store    : D:\apps\Sparx Systems\Service\sskeys.dat                                             #
2021-06-28 12:47:41 [INFO]:    #   Group    : D:\apps\Sparx Systems\Service\ssflsgroups.config                                     #
2021-06-28 12:47:41 [INFO]:    #                                                                                                   #
2021-06-28 12:47:41 [INFO]:    #####################################################################################################
2021-06-28 12:47:41 [INFO]: ** Starting up!
2021-06-28 12:47:41 [INFO]:    SUCCESS Added  Database Manager
2021-06-28 12:47:41 [INFO]:                ConnectionStr:      Provider=MSDASQL.1;Persist Security Info=False;Data Source=Enterprise_Architect;DMAlias=Postgresql EA Model Repository;
2021-06-28 12:47:41 [INFO]:                DB Manager ID:      msdasql.1:anonymous@enterprise_architect
2021-06-28 12:47:41 [INFO]:                DBMS:               POSTGRES
2021-06-28 12:47:41 [INFO]:                DBMS Name:          PostgreSQL
2021-06-28 12:47:41 [INFO]:                DBMS Version:       11.0.8
2021-06-28 12:47:41 [INFO]:                Driver:             PSQLODBC35W.DLL
2021-06-28 12:47:41 [INFO]:                Driver Version:     13.00.0000
2021-06-28 12:47:41 [INFO]:                DB Alias:           Postgresql EA Model Repository
2021-06-28 12:47:41 [INFO]:                GUID:               {D247F7BB-5E64-4046-9B90-988A87978AA3}
2021-06-28 12:47:41 [INFO]:                Enabled:            True
2021-06-28 12:47:41 [INFO]:                Active:             True
2021-06-28 12:47:41 [INFO]:                Pro Features:       False
2021-06-28 12:47:41 [INFO]:                Read Only:          False
2021-06-28 12:47:41 [INFO]:                Requires Secure:    False
2021-06-28 12:47:41 [INFO]:                Chart Gen:          Disabled
2021-06-28 12:47:41 [INFO]:                Worker State:       Disabled
2021-06-28 12:47:41 [INFO]:    Loading Floating License Group File.
2021-06-28 12:47:41 [INFO]:  ** Now listening for connections

These errors were previously received:
2021-06-22 13:45:45 [WARNING]: Thread 4117627  GrowFile failed to allocate 524288 bytes.
2021-06-22 13:45:45 [WARNING]: Thread 4117627  Exception in CFileStream::Write while attempting to write to memory file
2021-06-22 13:45:45 [WARNING]: Exception in CFileStream::Write while swapping to temp file
2021-06-22 13:45:45 [WARNING]: Thread 4117627  Unable to serialize recordset.
2021-06-22 13:45:45 [WARNING]: Microsoft OLEDB Persistence Provider [-2147418113]
2021-06-22 13:45:45 [WARNING]: Catastrophic failure
2021-06-22 13:45:45 [WARNING]: Thread 4117627  ::ffff:xxx.xx.xxx.xx REQUEST_QUERY on msdasql.1:anonymous@enterprise_architect FAIL. Error (4): Unable to serialize recordset to file
2021-06-22 13:45:46 [WARNING]: Thread 4117626  an error occurred in Thread::Run.
2021-06-22 13:45:46 [WARNING]: Thread 4117625  GrowFile failed to allocate 524288 bytes.
2021-06-22 13:45:46 [WARNING]: Thread 4117625  Exception in CFileStream::Write while attempting to write to memory file
2021-06-22 13:45:46 [WARNING]: Exception in CFileStream::Write while swapping to temp file
2021-06-22 13:45:46 [WARNING]: Thread 4117625  Unable to serialize recordset.
2021-06-22 13:45:46 [WARNING]: Microsoft OLEDB Persistence Provider [-2147418113]
2021-06-22 13:45:46 [WARNING]: Catastrophic failure
2021-06-22 13:45:46 [WARNING]: Thread 4117625  ::ffff:xxx.xx.xxx.xx REQUEST_QUERY on msdasql.1:anonymous@enterprise_architect FAIL. Error (4): Unable to serialize recordset to file
2021-06-22 13:45:46 [WARNING]: Thread 4117627  GrowFile failed to allocate 524288 bytes.
2021-06-22 13:45:46 [WARNING]: Thread 4117627  Exception in CFileStream::Write while attempting to write to memory file
2021-06-22 13:45:46 [WARNING]: Exception in CFileStream::Write while swapping to temp file
2021-06-22 13:45:46 [WARNING]: Thread 4117627  Unable to serialize recordset.
2021-06-22 13:45:46 [WARNING]: Microsoft OLEDB Persistence Provider [-2147418113]
2021-06-22 13:45:46 [WARNING]: Catastrophic failure
2021-06-22 13:45:46 [WARNING]: Thread 4117627  ::ffff:xxx.xx.xxx.xx REQUEST_QUERY on msdasql.1:anonymous@enterprise_architect FAIL. Error (4): Unable to serialize recordset to file
2021-06-22 13:45:46 [WARNING]: Thread 4117621  an error occurred in Thread::Run.
2021-06-22 13:45:47 [WARNING]: Thread 4117624  GrowFile failed to allocate 524288 bytes.
2021-06-22 13:45:47 [WARNING]: Thread 4117624  Exception in CFileStream::Write while attempting to write to memory file
2021-06-22 13:45:47 [WARNING]: Exception in CFileStream::Write while swapping to temp file
2021-06-22 13:45:47 [WARNING]: Thread 4117624  Unable to serialize recordset.
2021-06-22 13:45:47 [WARNING]: Microsoft OLEDB Persistence Provider [-2147418113]
2021-06-22 13:45:47 [WARNING]: Catastrophic failure
2021-06-22 13:45:47 [WARNING]: Thread 4117624  ::ffff:xxx.xx.xxx.xx REQUEST_QUERY on msdasql.1:anonymous@enterprise_architect FAIL. Error (4): Unable to serialize recordset to file
2021-06-22 13:45:50 [WARNING]: Thread 5  an error occurred in Thread::Run.
2021-06-22 13:50:35 [INFO]:    [AUDIT] Start. Period: 2021-06-22 12:50:35 to 2021-06-22 13:50:35 (0d, 1h 0m 0s)
2021-06-22 13:50:35 [INFO]:    [AUDIT] msdasql.1:anonymous@enterprise_architect                          | Free:   3 | Max Active:  10 | Acquisitions:   9010 |
2021-06-22 13:50:35 [INFO]:    [AUDIT] End.
2021-06-22 13:58:07 [INFO]: ** Service Stop request received.
2021-06-22 13:58:07 [INFO]: ** Received service stop signal

Any assistance to resolve this issue would be welcome.

Thanks