Troubleshooting

Restart the data migration

For troubleshooting purposes, it is possible to restart the data migration.

  1. Stop the services SnowLicenseManagerEventStoreService and SnowLicenseManagerAdobeCCService.

  2. Execute the SQL script:

    USE SNOWLICENSEMANAGER exec Sp_msforeachtable @command1='Truncate Table ?',@whereand='and Schema_Id=Schema_id(''adobecc'')'
  3. Start the service SnowLicenseManagerEventStoreService.

  4. Wait for about a minute to allow all health checks in the EventStore to complete.

  5. Check that SnowEventWarehouseService is up and running.

  6. Start the service SnowLicenseManagerAdobeCCService.

Restart when the migration does not complete

If the migration stops and does not complete, perform the following steps:

  1. Stop the Adobe CC service.

  2. Navigate to the appsettings.json file located in C:\Program Files\Snow Software\Snow License Manager\Services\AdobeCC.

  3. Lower the values for ReadingEventsBatchSize, WritingEventsBatchSize, and SQLBatchSize.

  4. Save the file.

  5. Restart the Adobe CC service.

Event Warehouse service crashes with TCP/UDP error

The Snow Event Warehouse service connects to the MS SQL database using a TCP/IP connection.

If the following error messages appear in your Event Warehouse logging, try the respective suggested solution.

Error messages:

  • [Date and time stamp] FTL Failed to connect to the database: Unable to open tcp connection with host [Host Name]: dial tcp [GUID]:1433: connectex: No connection could be made because the target machine actively refused it.

  • [Date and time stamp] FTL Failed to connect to the database: Unable to get instances from Sql Server Browser on host [Host Name]: read udp 10.xx.xx.xx:xxxx->10.xx.xx.xx:xxxx: i/o timeout

Solution:

  1. Enable TCP/IP for your SQL Server.

    Refer to the article Enable or Disable a Server Network Protocol in Microsoft documentation for more information on how to enable TCP/IP.

  2. Restart Snow EventWarehouse service and Adobe Creative Cloud service.

Error message:

  • [Date and time stamp] FTL Failed to connect to the database: Unable to get instances from Sql Server Browser on host [Host Name]: read udp 10.195.18.75:61007->10.195.17.43:1434:

Solution:

  1. Enable TCP/IP for your SQL Server.

  2. Restart Snow EventWarehouse service and Microsoft 365 service.

    Refer to the article Enable or Disable a Server Network Protocol in Microsoft documentation for more information on how to enable TCP/IP.

  3. Set the Firewall setting UnicastResponsesToMulticastBroadcastDisabled to FALSE (default). The setting is a property of the INetFwProfile interface.

    Note

    The setting is set to false to be able to perform a request to the SQL Server Engine on the 1434 port. If the connection string contains a named instance, e.g. Data Source=[XYZ]\sam, and the port number assigned to this instance is not provided, the driver tries to get the TCP port number via an UDP connection.

    Refer to the article INetFwProfile::get_UnicastResponsesToMulticastBroadcastDisabled method (netfw.h) in Microsoft documentation for more information on how to change this setting.

If enabling the Firewall setting did not work, there can be an error message like:

  • Failed to connect to the database: Unable to get instances from Sql Server Browser on host XXXXXXXXX: read udp X.X.X.X:61007->X.X.X.X:1434: i/o timeout

The suggested solution is then to:

  1. Provide a fixed port for a named instance.

    Use TCP port 1433, since it is the most common port allowed through the firewall.

    Refer to the article Configure a Server to Listen on a Specific TCP Port in Microsoft documentation for more information on how to change these settings.

  2. Open the port in Firewall.

    Note

    The TCP port has to be opened in the Windows Firewall (even if a default instance is used). It applies to routine connections to the default installation of the Database Engine, or a named instance that is the only instance running on the computer. Be aware that named instances can have special considerations in the firewall setting.

    Refer to the article Configure a Windows Firewall for Database Engine Access in Microsoft documentation for more information on how to change these settings.

  3. Add the port to the SLM connection string.

    The connection string, with a named instance, can be configured to something similar to Data Source=[XYZ]\sam,60000.

With this solution, the driver does not need to go over UDP but will instead open a TCP connection directly.

NATS timeout issue

Error message:

  • Message bus request failed with timeout Timeout occurred. SnowSoftware.Platform.EventBus.Abstractions.Exceptions.EventBusTimeoutException: Message bus request failed with timeout Timeout occurred.

    ---> NATS.Client.NATSTimeoutException: Timeout occurred. at NATS.Client.Connection.<>c__DisplayClass132_0.<<requestAsync>b__0>d.MoveNext()

    --- End of stack trace from previous location where exception was thrown --- at SnowSoftware.Platform.EventBus.Nats.Generic.NatsRequester.<>c__DisplayClass9_0`1.

Solution:

  1. Stop the SnowLicenseManagerDataAccessService and the SnowLicenseManagerAdobeCCService services.

  2. Increase the db timeout in DataAccessService.

    Adobe_Nats_1.png
  3. Increase the db timeout and NATS timeout in AdobeCC.

    Adobe_Nats_2.png
  4. Check that EventWarehouse and NATS are working.

  5. Start the SnowLicenseManagerDataAccessService and the SnowLicenseManagerAdobeCCService services.

  6. Aggregate a new import.

AdobeCC database timeout issue

  1. Stop the service SnowLicenseManagerAdobeCCService.

  2. Increase the db timeout in AdobeCC.

    Adobe_db_timeout.png
  3. Start the service SnowLicenseManagerAdobeCCService.

  4. Aggregate a new import.

AdobeCC BFF database timeout issue

  1. Stop the service SnowLicenseManagerAdobeCCBFF.

  2. Increase the db timeout in AdobeCCBFF.

    Adobe_BFF_timeout.png
  3. Start the service SnowLicenseManagerAdobeCCBFF.