• State Not Answered
  • Replies 4 replies
  • Subscribers 12 subscribers
  • Views 71 views
  • Users 0 members are here
Options
Related

SQL DataGrid Issues

Caroline Czyzewski

I am having some issues with the SQL DataGrid object to actually display anything. Through SSMS on the server, I can access a database I am trying to get to on a different ip. These are the properties I have filled in: ConfiguredServer_dg, ConfiguredDatabase_dg SQLQuery_dg, ConfiguredUser_dg, ConfiguredPassword_dg, Authentication_dg, and ConfiguredCredentials_dg. 

I have Authentication_dg set to "SQL Server" and ConfiguredCredentials_dg set to "username and password"

Are there any other configurations that I need or is the string for Authentication or ConfiguredCredentials wrong at all? When I preview it in my OMI View App, there is no data. It also doesn't have any of the buttons displayed when you place the SQL DataGrid object on a graphic or layout. I didn't update any of the other properties. 

  • 0

    What does the SMC ( or OCMC ) log say ? I have had multiple issues with SQL Data Grid, I'm curious that theres an option called $SQLData and link that to attribute , anyone tried that ? 

  • 0 in reply to RAINER CARLTON DSOUZA

    This is the error message I have on the OCMC:

    Exception Type: CommitFailedException
    Message: An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server. See the inner exception and go.microsoft.com/.../ for more information.
    Source: SentinelSystemMonitor.DataModel
    TargetSite: Void InsertAlert(SentinelSystemMonitor.DataModel.Entities.InsertAlertParameters, System.String)
    Stack trace: at SentinelSystemMonitor.DataModel.UnitOfWork.UnitOfWork.InsertAlert(InsertAlertParameters entity, String userName)__ at SentinelSystemMonitor.Business.Services.AlertServices.InsertAlert(AlertInsertEntity entity, String userName)__ at SentinelSystemMonitor.Console.WebApi.AlertController.InsertAlert(AlertInsertEntity entity)
    Inner Exception Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    Operation cancelled by user.
    Inner Exception Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalTransaction.Commit()
    at System.Data.SqlClient.SqlTransaction.Commit()
    at System.Data.Entity.Infrastructure.Interception.DbTransactionDispatcher.<>c.<Commit>b__6_0(DbTransaction t, DbTransactionInterceptionContext c)
    at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)

  • 0 in reply to Caroline Czyzewski

    Looks like its not able to login to the SQL server in OMI , can you check if you are able to login into the SQL server in the IDE, see this link and see if you are able to login

    www.youtube.com/watch

  • 0 in reply to RAINER CARLTON DSOUZA

    Also you may need to raise a Tech support ticket with AVEVA 

© 2024 AVEVA Group Limited or its subsidiaries. All Rights Reserved.