cancel
Showing results for 
Search instead for 
Did you mean: 

system error tracing

Former Member
0 Kudos

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 ]==============

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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;"/>

Answers (1)

Answers (1)

former_member186498
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Robert

On the application server there is the log file where continually there is this error as you can see below, but BPC works correctly

I don't understand!!!

#2.0 #2013 09 05 10:08:07:049#+1:00#ERROR#OSoftUserManage##EPM-BPC-MS##30b48451-13b5-414e-9d97-3c7277964b46###IsAdmin()#########Plain##

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

[System  Name] : OSoftUserManage

[Message Type] : ErrorMessage

[Job Name]     : IsAdmin()

[DateTime]     : 05/09/2013 10:08:06

[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 05 10:08:07:158#+1:00#ERROR#OSoftUserManage##EPM-BPC-MS##8b93d179-0f2b-4f9b-b96a-0b770671fb2a###IsAdmin()#########Plain##

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

[System  Name] : OSoftUserManage

[Message Type] : ErrorMessage

[Job Name]     : IsAdmin()

[DateTime]     : 05/09/2013 10:08:07

[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 05 10:08:08:283#+1:00#ERROR#OSoftUserManage##EPM-BPC-MS##135c9717-878c-48ae-9d56-6d1774c00de4###IsAdmin()#########Plain##

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

[System  Name] : OSoftUserManage

[Message Type] : ErrorMessage

[Job Name]     : IsAdmin()

[DateTime]     : 05/09/2013 10:08:07

[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 05 10:08:08:752#+1:00#ERROR#OSoftUserManage##EPM-BPC-MS##0c77ed0f-82d7-4873-bda9-12b9b6d160b7###IsAdmin()#########Plain##

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

[System  Name] : OSoftUserManage

[Message Type] : ErrorMessage

[Job Name]     : IsAdmin()

[DateTime]     : 05/09/2013 10:08:08

[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 ]==============

former_member186498
Active Contributor
0 Kudos

Hi Michele,

I think there is a machine or a service wrong configurated (with wrong parameters) that try to login.

You should ask to your BASIS, they have the instruments (net and web analyzer) e.g. fiddler to understand who try to connect and after where is the issue.

Regards,

     Roberto