on 09-03-2013 10:36 AM
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 ]==============
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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;"/>
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ]==============
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.