Smart Grid Applications Overview > Smart Operations Solution > Troubleshooting > Troubleshooting: Rx_globalid_xref Warning Appears in Event Log |
Version: 10.1 |
You may find the following in your Event Log:
2009-01-27 11:31:19,924 [STA Worker Thread] WARN Miner.Data.Access.DataSource [(null)] - Error in ExecuteScalar: SELECT count(*) FROM rx_globalid_xref WHERE fcid < 0 System.Data.OracleClient.OracleException: ORA-00942: table or view does not exist at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciRowidDescriptor& rowidDescriptor) at System.Data.OracleClient.OracleCommand.ExecuteScalar() at Miner.Data.Access.DataSource.ExecuteScalar(DataSession session, IDbOperation operation) in D:\93r2\source\Miner.Responder\Miner.Data\Miner.Data.Access\DataSource.cs:line 505
This is not an error, but instead a warning that indicates the Rx_globalid_xref table does not exist. This table is NOT required in order for SOS to function properly. However, adding this table and performing the configuration that goes with it will improve performance when transferring data between Responder, OASyS, and DMS. Refer to the Optional Configurations page (Set Up GlobalID Support).