Get View Full Infos
- 28 Dec 2022
- 1 Minute to read
- Print
- DarkLight
Get View Full Infos
- Updated on 28 Dec 2022
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Step Details | |
Introduced in Version | 4.0.0 |
Last Modified in Version | 5.0.0 |
Location | Integration > Database > ODBC |
The Get View Full Infos step runs a query that returns the full view information from an ODBC database.
Properties
Inputs
Property | Description | Data Type |
---|---|---|
Connection String | Connection String to connect to the ODBC database | String |
Outputs
Property | Description | Data Type |
---|---|---|
Done | List of view information | List 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?