Skip to Content
author's profile photo Former Member
Former Member

system error tracing

Hola BPC Friends

On the BPC application server in the folder PC_MS\Logging\Log I have this extract LOG FILE

What does it mean?

What is it the problem?

thanks

Michele

==============[System Error Tracing]==============

[System Name] : OSoftUserManage

[Message Type] : ErrorMessage

[Job Name] : IsAdmin()

[DateTime] : 03/09/2013 09:34:35

[UserId] :

[Exception]

DetailMsg : {System.InvalidOperationException: ExecuteScalar requires an open and available Connection. The connection's current state is closed.

at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)

at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)

at OSoft.Services.Application.UserManage.Security.IsAdmin(String AppsetID, String UserID)}

==============[System Error Tracing End ]==============

#

#2.0 #2013 09 03 09:35:07:315#+1:00#ERROR#WorkStatus##EPM-BPC-MS##070601eb-6ffe-4f64-b457-75df692c0cf5###Handler.CheckLockTableIndex#########Plain##

==============[System Error Tracing]==============

[System Name] : WorkStatus

[Message Type] : ErrorMessage

[Job Name] : Handler.CheckLockTableIndex

[DateTime] : 03/09/2013 09:35:07

[UserId] :

[SqlException]

Type : System.Data.SqlClient.SqlException

Errors : System.Data.SqlClient.SqlErrorCollection

Class : 16

LineNumber: 498

Message : {Invalid column name 'TimeID'.

Invalid column name 'TimeID'.

Invalid column name 'TimeID'.

Invalid column name 'TimeID'.

Invalid column name 'TimeID'.

Invalid column name 'TimeID'.

Invalid column name 'TimeID'.}

Number : 207

Procedure : up_CreateWorkStatusProcedure1

Server : PLUKHUBSQL11

State : 1

Source : .Net SqlClient Data Provider

TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)

HelpLink :

==============[System Error Tracing End ]==============

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2013 at 05:39 PM

    Hi Michele,

    Please refer note 1820002.

    Cause

    The outlooksoft.config file located under the \Websrvr\bin folder specifies an incorrect SQL server TCP port number.

    Resolution

    Verify that the SQL Server instance name and port specified in the Database_AppServerDBConn key under the <appSettings> section in the OutlookSoft.config are correct and match the actual SQL Server instance name and TCP port where the database engine is running.

    Here is a sample Database_AppServerDBConn key under the <appSettings> section:

    <add key="Database_AppServerDBConn"
    value="Server=LMW03R2SP2,1433;Database=AppServer;Trusted_Connection=True;"/>

    Note that the value 1433 in the above string represents the TCP port where there application server will try to establish a connection with the database engine.

    If the SQL server instance is configured to use dynamic ports, the port number should not be specified in the OutlookSoft.config file as the actual port where the SQL server instance is running can change over time.

    The port number should be specified only if the SQL server instance uses static ports.

    Regards,

    Kalyan.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kalyan

      I have this in the outlooksoftconfigfile

      what does it mean?

      <?xml version="1.0" encoding="utf-8"?>

      <configuration>

      <!--

      The appSettings keys should use a naming convention so their purpose is clear

      syntax : WhoItBelongsTo_WhatItMeans

      -->

      <appSettings>

      <!-- base locations of servers -->

      <add key="Encoding" value="ISO-8859-1"/>

      <add key="Database_AppServerDBConn" value="Server=PLUKHUBSQL11;Database=AppServer;Trusted_Connection=True;"/>

  • Posted on Sep 03, 2013 at 05:24 PM

    Hi Michele,

    this seems a connection error with the server.

    Where you received this error, during the access to the launch page?

    Only one machine receive this error or all the machines?

    Regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.