Skip to Content
0
Former Member
Jul 15, 2008 at 06:12 PM

Rename Category Dimension

33 Views

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