Commerce Server General - Error with Analysis Reports

Author

Error with Analysis Reports

bkelly3@gmail.com

2006-10-13, 7:33 pm

This problem seemed to appear out of thin air as these reports have
been working just fine since the beginning of the year. It's kind of a
strange one at that. Here's what's going on. When I go to access our
analysis reports (analysis_dynamic_reporting10.asp) I get a pop up
dialog with the following message. "Problems with this page might have
prevented it from functioning properly. Please contact your system
administrator." Not very helpful. So I go into the application from
the desktop icon on the server. When it starts up it says it is
restarting the bizdesk application. OK...not sure why that is, but
fine. So after it restarts and and I do nothing else, I go to the page
from my desktop and I get an error message that it can't find the
database associated with the metrics. If I do an iisreset on my
server, it goes back to the "Problems with this page..." error message.
With these steps it is 100% consistent going back and forth with the
error messages. Yet the most confounding issue is this. The pages
work just fine from the local web server. I can see all my analysis
reports. Anyone know what could be happening here?

Thanks,
Bill

bkelly3@gmail.com

2006-10-13, 7:33 pm

As added information I see the following errors in my application logs
whenever people try to access the site.

1. Error: failure in catalog resolve, hr: -2147483326

2. Catalog Load failed catalog: Profile Definitions (-2147483326)

3. DataSource::Init(DS-18[Class Factory]DS-19-Profile Definitions)
failed on catalog load (-904429548)

These are new errors. I can't seem to find much on these errors
anywhere.

Thanks,
Bill

bkelly3@gmail.com wrote:
> This problem seemed to appear out of thin air as these reports have
> been working just fine since the beginning of the year. It's kind of a
> strange one at that. Here's what's going on. When I go to access our
> analysis reports (analysis_dynamic_reporting10.asp) I get a pop up
> dialog with the following message. "Problems with this page might have
> prevented it from functioning properly. Please contact your system
> administrator." Not very helpful. So I go into the application from
> the desktop icon on the server. When it starts up it says it is
> restarting the bizdesk application. OK...not sure why that is, but
> fine. So after it restarts and and I do nothing else, I go to the page
> from my desktop and I get an error message that it can't find the
> database associated with the metrics. If I do an iisreset on my
> server, it goes back to the "Problems with this page..." error message.
> With these steps it is 100% consistent going back and forth with the
> error messages. Yet the most confounding issue is this. The pages
> work just fine from the local web server. I can see all my analysis
> reports. Anyone know what could be happening here?
>
> Thanks,
> Bill

Brian Blum [MSFT]

2006-10-16, 7:26 pm

Has there been a recent change to one of the Profile defintions?

The messages below indicate that there is a problem with the Profiles
system. All three errors are probably related to the same failure. The
'lowest' level failure is the catalog resolve error. Unfortuneatly, the
error code relates to creating some map, but it's not clear which map.

There are a couple of things you can do. First, you can use the profile
validation tool to check your profiles. You get to this tool through the
CS Manager console. Navigate to the profiles and right click on a profile
you want to check. One word of caution though; this tool is known to throw
'false positive' messages, ie, it may report issues that aren't errors.

The other thing that you can do is to use the csdwdbgsrv.exe trace tool to
get more information. You invoke this tool by specifying a file to capture
the output: 'csdwdbgsrv -f trace'. This will create a file in the current
directory with trace as the prefix, a time stamp as the rest of the file
name and .txt as the file extension.

If the trace file doesn't yield any clues, you can get more trace
information by setting different environment settings. The easiest way to
set the environment variables is go to the 'My Computer' icon on the
desktop, right click and select Properties, then go to the Advanced tab.
There's a button at the bottom of this tab marked 'Environment Variables'.
When setting a value for an CS DW trace variable, you can use 'T', 't',
'True', 'true', or 1 to enable the setting.

For the catalog resolve, you can try setting the following flags:
TraceCreateRelMaxtix
TraceParentChildMemberMappingNotMatched
TraceMemberMapping
TraceKeyMemberMappingNotMatched

and rerun the profile system or the report page while capturing this
information. Hopefully, there should be more useful troubleshooting
information in the trace file.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBuisness Server Team
--------------------
From: bkelly3@gmail.com
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: Error with Analysis Reports
Date: 13 Oct 2006 11:05:57 -0700
Organization: http://groups.google.com
Lines: 41
Message-ID: <1160762757.716672.44570@f16g2000cwb.googlegroups.com>
References: <1160757497.309637.278680@k70g2000cwa.googlegroups.com>
NNTP-Posting-Host: 131.107.0.106
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160762762 25638 127.0.0.1 (13 Oct 2006
18:06:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 13 Oct 2006 18:06:02 +0000 (UTC)
In-Reply-To: <1160757497.309637.278680@k70g2000cwa.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 RED-PRXY-29
Complaints-To: groups-abuse@google.com
Injection-Info: f16g2000cwb.googlegroups.com; posting-host=131.107.0.106;
posting- account=H4pdeQ0AAACXytwviGUvL2hDckWajAKB

Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!msrtrans!n
ewsfeed.media.kyoto-u.ac.jp!postnews.google.com!f16g2000cwb.googlegroups.com
!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18700
X-Tomcat-NG: microsoft.public.commerceserver.general

As added information I see the following errors in my application logs
whenever people try to access the site.

1. Error: failure in catalog resolve, hr: -2147483326

2. Catalog Load failed catalog: Profile Definitions (-2147483326)

3. DataSource::Init(DS-18[Class Factory]DS-19-Profile Definitions)
failed on catalog load (-904429548)

These are new errors. I can't seem to find much on these errors
anywhere.

Thanks,
Bill

bkelly3@gmail.com wrote:
> This problem seemed to appear out of thin air as these reports have
> been working just fine since the beginning of the year. It's kind of a
> strange one at that. Here's what's going on. When I go to access our
> analysis reports (analysis_dynamic_reporting10.asp) I get a pop up
> dialog with the following message. "Problems with this page might have
> prevented it from functioning properly. Please contact your system
> administrator." Not very helpful. So I go into the application from
> the desktop icon on the server. When it starts up it says it is
> restarting the bizdesk application. OK...not sure why that is, but
> fine. So after it restarts and and I do nothing else, I go to the page
> from my desktop and I get an error message that it can't find the
> database associated with the metrics. If I do an iisreset on my
> server, it goes back to the "Problems with this page..." error message.
> With these steps it is 100% consistent going back and forth with the
> error messages. Yet the most confounding issue is this. The pages
> work just fine from the local web server. I can see all my analysis
> reports. Anyone know what could be happening here?
>
> Thanks,
> Bill

bkelly3@gmail.com

2006-10-18, 7:28 pm

Thanks Brian! It was indeed a result of the KB article you mentioned
to me offline. Posting the resolution for the rest of the world.

http://support.microsoft.com/kb/926509/

Thanks!
Bill

Brian Blum [MSFT] wrote:
> Has there been a recent change to one of the Profile defintions?
>
> The messages below indicate that there is a problem with the Profiles
> system. All three errors are probably related to the same failure. The
> 'lowest' level failure is the catalog resolve error. Unfortuneatly, the
> error code relates to creating some map, but it's not clear which map.
>
> There are a couple of things you can do. First, you can use the profile
> validation tool to check your profiles. You get to this tool through the
> CS Manager console. Navigate to the profiles and right click on a profile
> you want to check. One word of caution though; this tool is known to throw
> 'false positive' messages, ie, it may report issues that aren't errors.
>
> The other thing that you can do is to use the csdwdbgsrv.exe trace tool to
> get more information. You invoke this tool by specifying a file to capture
> the output: 'csdwdbgsrv -f trace'. This will create a file in the current
> directory with trace as the prefix, a time stamp as the rest of the file
> name and .txt as the file extension.
>
> If the trace file doesn't yield any clues, you can get more trace
> information by setting different environment settings. The easiest way to
> set the environment variables is go to the 'My Computer' icon on the
> desktop, right click and select Properties, then go to the Advanced tab.
> There's a button at the bottom of this tab marked 'Environment Variables'.
> When setting a value for an CS DW trace variable, you can use 'T', 't',
> 'True', 'true', or 1 to enable the setting.
>
> For the catalog resolve, you can try setting the following flags:
> TraceCreateRelMaxtix
> TraceParentChildMemberMappingNotMatched
> TraceMemberMapping
> TraceKeyMemberMappingNotMatched
>
> and rerun the profile system or the report page while capturing this
> information. Hopefully, there should be more useful troubleshooting
> information in the trace file.
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> From: bkelly3@gmail.com
> Newsgroups: microsoft.public.commerceserver.general
> Subject: Re: Error with Analysis Reports
> Date: 13 Oct 2006 11:05:57 -0700
> Organization: http://groups.google.com
> Lines: 41
> Message-ID: <1160762757.716672.44570@f16g2000cwb.googlegroups.com>
> References: <1160757497.309637.278680@k70g2000cwa.googlegroups.com>
> NNTP-Posting-Host: 131.107.0.106
> Mime-Version: 1.0
> Content-Type: text/plain; charset="iso-8859-1"
> X-Trace: posting.google.com 1160762762 25638 127.0.0.1 (13 Oct 2006
> 18:06:02 GMT)
> X-Complaints-To: groups-abuse@google.com
> NNTP-Posting-Date: Fri, 13 Oct 2006 18:06:02 +0000 (UTC)
> In-Reply-To: <1160757497.309637.278680@k70g2000cwa.googlegroups.com>
> User-Agent: G2/1.0
> X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
> rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe)
> X-HTTP-Via: 1.1 RED-PRXY-29
> Complaints-To: groups-abuse@google.com
> Injection-Info: f16g2000cwb.googlegroups.com; posting-host=131.107.0.106;
> posting- account=H4pdeQ0AAACXytwviGUvL2hDckWajAKB

> Path:
> TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!msrtrans!n
> ewsfeed.media.kyoto-u.ac.jp!postnews.google.com!f16g2000cwb.googlegroups.com
> !not-for-mail
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18700
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> As added information I see the following errors in my application logs
> whenever people try to access the site.
>
> 1. Error: failure in catalog resolve, hr: -2147483326
>
> 2. Catalog Load failed catalog: Profile Definitions (-2147483326)
>
> 3. DataSource::Init(DS-18[Class Factory]DS-19-Profile Definitions)
> failed on catalog load (-904429548)
>
>
> These are new errors. I can't seem to find much on these errors
> anywhere.
>
> Thanks,
> Bill
>
>
>
> bkelly3@gmail.com wrote:
>
>
> ------=_NextPart_0001_171EB96B
> Content-Type: text/x-rtf
> X-Google-AttachSize: 5598
>
> & #123;\rtf1\ansi\ansicpg1252\deff0\deflan
g1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
> \viewkind4\uc1\pard\f0\fs20 Has there been a recent change to one of the Profile defintions?
> \par
> \par The messages below indicate that there is a problem with the Profiles system. All three errors are probably related to the same failure. The 'lowest' level failure is the catalog resolve error. Unfortuneatly, the error code relates to creating s
ome map, but it's not clear which map.
> \par
> \par There are a couple of things you can do. First, you can use the profile validation tool to check your profiles. You get to this tool through the CS Manager console. Navigate to the profiles and right click on a profile you want to check. One wo
rd of caution though; this tool is known to throw 'false positive' messages, ie, it may report issues that aren't errors.
> \par
> \par The other thing that you can do is to use the csdwdbgsrv.exe trace tool to get more information. You invoke this tool by specifying a file to capture the output: 'csdwdbgsrv -f trace'. This will create a file in the current directory with trace a
s the prefix, a time stamp as the rest of the file name and .txt as the file extension.
> \par
> \par If the trace file doesn't yield any clues, you can get more trace information by setting different environment settings. The easiest way to set the environment variables is go to the 'My Computer' icon on the desktop, right click and select Proper
ties, then go to the Advanced tab. There's a button at the bottom of this tab marked 'Environment Variables'. When setting a value for an CS DW trace variable, you can use 'T', 't', 'True', 'true', or 1 to enable the setting.
> \par
> \par For the catalog resolve, you can try setting the following flags:
> \par TraceCreateRelMaxtix
> \par TraceParentChildMemberMappingNotMatched
> \par TraceMemberMapping
> \par TraceKeyMemberMappingNotMatched
> \par
> \par and rerun the profile system or the report page while capturing this information. Hopefully, there should be more useful troubleshooting information in the trace file.
> \par
> \par
> \par This posting is provided "AS IS" with no warranties, and confers no rights.
> \par
> \par EBuisness Server Team
> \par \pard\li720 --------------------
> \par From: bkelly3@gmail.com
> \par Newsgroups: microsoft.public.commerceserver.general
> \par Subject: Re: Error with Analysis Reports
> \par Date: 13 Oct 2006 11:05:57 -0700
> \par Organization: http://groups.google.com
> \par Lines: 41
> \par Message-ID: <1160762757.716672.44570@f16g2000cwb.googlegroups.com>
> \par References: <1160757497.309637.278680@k70g2000cwa.googlegroups.com>
> \par NNTP-Posting-Host: 131.107.0.106
> \par Mime-Version: 1.0
> \par Content-Type: text/plain; charset="iso-8859-1"
> \par X-Trace: posting.google.com 1160762762 25638 127.0.0.1 (13 Oct 2006 18:06:02 GMT)
> \par X-Complaints-To: groups-abuse@google.com
> \par NNTP-Posting-Date: Fri, 13 Oct 2006 18:06:02 +0000 (UTC)
> \par In-Reply-To: <1160757497.309637.278680@k70g2000cwa.googlegroups.com>
> \par User-Agent: G2/1.0
> \par X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe)
> \par X-HTTP-Via: 1.1 RED-PRXY-29
> \par Complaints-To: groups-abuse@google.com
> \par Injection-Info: f16g2000cwb.googlegroups.com; posting-host=131.107.0.106;
> \par posting- account=H4pdeQ0AAACXytwviGUvL2hDckWajAKB

> \par Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!msrtrans!newsfeed.media.kyoto-u.ac.jp!postnews.google.com!f16g2000cwb.googlegroups.com!not-for-mail
> \par Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18700
> \par X-Tomcat-NG: microsoft.public.commerceserver.general
> \par
> \par As added information I see the following errors in my application logs
> \par whenever people try to access the site.
> \par
> \par 1. Error: failure in catalog resolve, hr: -2147483326
> \par
> \par 2. Catalog Load failed catalog: Profile Definitions (-2147483326)
> \par
> \par 3. DataSource::Init(DS-18[Class Factory]DS-19-Profile Definitions)
> \par failed on catalog load (-904429548)
> \par
> \par
> \par These are new errors. I can't seem to find much on these errors
> \par anywhere.
> \par
> \par Thanks,
> \par Bill
> \par
> \par
> \par
> \par bkelly3@gmail.com wrote:
> \par > This problem seemed to appear out of thin air as these reports have
> \par > been working just fine since the beginning of the year. It's kind of a
> \par > strange one at that. Here's what's going on. When I go to access our
> \par > analysis reports (analysis_dynamic_reporting10.asp) I get a pop up
> \par > dialog with the following message. "Problems with this page might have
> \par > prevented it from functioning properly. Please contact your system
> \par > administrator." Not very helpful. So I go into the application from
> \par > the desktop icon on the server. When it starts up it says it is
> \par > restarting the bizdesk application. OK...not sure why that is, but
> \par > fine. So after it restarts and and I do nothing else, I go to the page
> \par > from my desktop and I get an error message that it can't find the
> \par > database associated with the metrics. If I do an iisreset on my
> \par > server, it goes back to the "Problems with this page..." error message.
> \par > With these steps it is 100% consistent going back and forth with the
> \par > error messages. Yet the most confounding issue is this. The pages
> \par > work just fine from the local web server. I can see all my analysis
> \par > reports. Anyone know what could be happening here?
> \par >
> \par > Thanks,
> \par > Bill
> \par
> \par \pard
> \par
> \par }
> ------=_NextPart_0001_171EB96B--