An error occured while retrieving the InformationSchemaTable information

[Bea1906]

An error occured while retrieving the InformationSchemaTable information

[JonathanMagnan]

Hello @Bea1906 ,

This exception should have an inner exception, is it possible to get the inner exception message as well?

That will for sure give us some information to better understand what is happening in your case.

Best Regards,

Jon

[Bea1906]

Hello Jonathan, I am using the Visual Studio as an OutSystems extension, it works the same but is harder to debug, I found the inner Exception:

System.Exception: An error occured while retrieving the InformationSchemaTable information. See the inner exception for details. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.
at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at .(DbCommand , CommandBehavior , BulkOperation , Int32 )
at .(Boolean , String[] )
at Z.BulkOperations.BulkOperation.()
--- End of inner exception stack trace ---
at Z.BulkOperations.BulkOperation.()
at Z.BulkOperations.BulkOperation.Execute()
at OutSystems.NssBirdlyData.CssBirdlyData.MssMigrate(RCMigrationConfigRecord ssConfig, Boolean& ssIsSuccess, String& sserrorMessage)

[Bea1906]

Hello JonathanMagnan , using this Visual studio version connected to Outsystems is hard to debug but since I could print the innerException I knew what the error was and it is fixed.
I want to thank you for the help, even if it was just to print the inner exception, you reply really fast and I am really thankful for that !

[JonathanMagnan]

Awesome ;)

No problem, I'm glad you find out about this issue.

Have a great weekend,

Best Regards,

Jon