Hello.
Instead of using Category, we are using Scenario and have updated constants and system_constants. Everything works fine, except the web landing page when the Application selected is Application Not Set. In this case, an error is generated because funtion dbo.uf_GetCategoryMember does not exist. Here's the message from event log.
==============[System Error Tracing]==============
[System Name] : OSoftCPM
[Message Type] : ErrorMessage
[Job Name] : MetaData/GetDimensionListWeb
[DateTime] : 7/11/2008 10:35:01 AM
[UserId] : Appset:BPCDEMO,App:,UserID:CMUTUAL\mfa7236
[SqlException]
Type : System.Data.SqlClient.SqlException
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 16
LineNumber: 1
Message : {Invalid object name 'dbo.uf_GetCategoryMember'.}
Number : 208
Procedure :
Server : SMPBPCDBP01\BPC
State : 1
Source : .Net SqlClient Data Provider
TargetSite:
HelpLink :
==============[System Error Tracing End ]==============
I create the function by copying from Apshell, then the landing page with Application Not Set is fine. Is there something else that needs to change because of the Category rename? The solution of creating the function would be okay, except the function disappears. The day after I create it, it's gone. Don't know why.
Thanks, Nancy
Edited by: Nancy Eichinger on Jul 15, 2008 8:12 PM