Get View Full Infos
  • 28 Dec 2022
  • 1 Minute to read
  • Dark
    Light

Get View Full Infos

  • Dark
    Light

Article summary

Step Details

Introduced in Version4.0.0
Last Modified in Version5.0.0
LocationIntegration > Database > ODBC

The Get View Full Infos step runs a query that returns the full view information from an ODBC database.



Properties

Inputs

PropertyDescriptionData Type
Connection StringConnection String to connect to the ODBC databaseString

Outputs

PropertyDescriptionData Type
DoneList of view informationList of DBFullTableInfo

Example Inputs and Outputs


Common Errors

The ConnectionString property has not been initialized

If the Connection String value is not mapped correctly or is null, an error will occur.

To correct this, ensure that the Connection String is entered or mapped correctly.

Exception Message:

Exception Stack Trace: DecisionsFramework.Design.Flow.ErrorRunningFlowStep: Error running step Get View Full Infos 1[GetViewFullInfos] in flow [Flow 4]: Exception invoking method GetViewFullInfos on class ExcelSteps
 ---> DecisionsFramework.LoggedException: Exception invoking method GetViewFullInfos on class ExcelSteps
 ---> System.InvalidOperationException: The ConnectionString property has not been initialized. at System.Data.Odbc.OdbcConnection.PermissionDemand(
 at System.Data.Odbc.OdbcConnectionFactory.PermissionDemand(DbConnection outerConnection
 at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions
 at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions
 at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory
 at System.Data.Odbc.OdbcConnection.Open(
 at DecisionsFramework.ServiceLayer.Services.DatabaseIntegration.FlowSteps.ODBCSteps.ExcelSteps.GetViewFullInfos(String connectionString)
   --- End of inner exception stack trace --- at DecisionsFramework.Design.Flow.StepImplementations.InvokeMethodStep.Run(StepStartData data
 at DecisionsFramework.Design.Flow.FlowStep.RunStepInternal(String flowTrackingID, String stepTrackingID, KeyValuePairDataStructure[] stepRunDataValues, AbstractFlowTrackingData trackingData
 at DecisionsFramework.Design.Flow.FlowStep.Start(String flowTrackingID, String stepTrackingID, FlowStateData data, AbstractFlowTrackingData trackingData, RunningStepData currentStepData)
   --- End of inner exception stack trace ---


The ConnectionString property has not been initialized

If the Connection String value is not formatted correctly, an error will occur.

To correct this, ensure that the Connection String is entered correctly.

Exception Message:

Exception Stack Trace: DecisionsFramework.Design.Flow.ErrorRunningFlowStep: Error running step Get View Full Infos 1[GetViewFullInfos] in flow [Flow 4]: Exception invoking method GetViewFullInfos on class ExcelSteps
 ---> DecisionsFramework.LoggedException: Exception invoking method GetViewFullInfos on class ExcelSteps
 ---> System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0. at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue
 at System.Data.Common.DbConnectionOptions.ParseInternal(Dictionary`2 parsetable, String connectionString, Boolean buildChain, Dictionary`2 synonyms, Boolean firstKey
 at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Dictionary`2 synonyms, Boolean useOdbcRules
 at System.Data.Odbc.OdbcConnectionString..ctor(String connectionString, Boolean validate
 at System.Data.Odbc.OdbcConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous
 at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions
 at System.Data.Odbc.OdbcConnection.ConnectionString_Set(DbConnectionPoolKey key
 at DecisionsFramework.ServiceLayer.Services.DatabaseIntegration.FlowSteps.ODBCSteps.ExcelSteps.GetViewFullInfos(String connectionString)
   --- End of inner exception stack trace --- at DecisionsFramework.Design.Flow.StepImplementations.InvokeMethodStep.Run(StepStartData data
 at DecisionsFramework.Design.Flow.FlowStep.RunStepInternal(String flowTrackingID, String stepTrackingID, KeyValuePairDataStructure[] stepRunDataValues, AbstractFlowTrackingData trackingData
 at DecisionsFramework.Design.Flow.FlowStep.Start(String flowTrackingID, String stepTrackingID, FlowStateData data, AbstractFlowTrackingData trackingData, RunningStepData currentStepData)
   --- End of inner exception stack trace ---



Was this article helpful?