Error importing questionnaire from Designer

[ashwinikalantri]

We are trying to import our questionnaire in the server, but are getting the following error:

The process displays Receiving questionnaire data for a while before showing this error. This is happening with multiple questionnaire. Including those that imported successfully in the past.

[ashwinikalantri]

We have been having internet outages throughout the day and the firewall would switch to the redundant internet. This seemed to be causing the issue. The server has full internet access on both lines. But, even when the main internet connection was restored, the issue remained. A server restart fixed it.

[sergiy]

Hello @ashwinikalantri ,

thank you very much for reporting the issue. Unfortunately, I can do little in this case, since the cause of the problem is probably somewhere deep in the configuration of your server, network, firewall, or some other appliance in the middle, rather then the Survey Solutions software itself.

If this happens to anyone else I’d suggest:

1. Check with the uptime robot:
   

   
   
   If the Designer is down there - there is nothing you can do really - alert us through the forum (though we may be already notified by the same service )

2. If the Designer appears to be online - try importing to another server (e.g. located in a different network, organization, cloud, etc). If it imports there successfully, it points heavily to your network configuration as the culprit, of which outsiders won’t know anything. Contact your system admin / network admin for additional explanations.

Best, Sergiy

[ashwinikalantri]

@sergiy, Thank you for your input. I am also attaching the server error log. Does that point to any specific issue? I have alerted the network admin, and they have whitelisted designer. But I doubt that was the issue. I was able to access and login to designer from the server. Only imports failed.

Could this be a temporary error that the restart fixed?

2022-12-31 11:46:28.082 +05:30 [ERR] Failed to import questionnaire from designer. id: #b093882c-1559-42db-97c0-3d0354ceaf2e
NHibernate.Exceptions.GenericADOException: could not execute native bulk manipulation query:select pg_advisory_xact_lock(51658156);[SQL: select pg_advisory_xact_lock(51658156);]
 ---> Npgsql.NpgsqlException (0x80004005): Exception while reading from stream
 ---> System.TimeoutException: Timeout during reading attempt
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|211_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQueryAsync(DbCommand cmd, CancellationToken cancellationToken)
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdateAsync(QueryParameters queryParameters, ISessionImplementor session, CancellationToken cancellationToken)
   --- End of inner exception stack trace ---
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdateAsync(QueryParameters queryParameters, ISessionImplementor session, CancellationToken cancellationToken)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdateAsync(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters, CancellationToken cancellationToken)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdateAsync(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters, CancellationToken cancellationToken)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdateAsync(CancellationToken cancellationToken)
   at WB.Core.BoundedContexts.Headquarters.Implementation.Services.QuestionnaireImportService.ImportImpl(RestCredentials credentials, IServiceLocator serviceLocator, Guid userId, String userName, Guid questionnaireId, QuestionnaireImportResult questionnaireImportResult, String name, Boolean isCensusMode, String comment, String requestUrl, Boolean shouldMigrateAssignments, QuestionnaireIdentity migrateFrom, Boolean includePdf)