Showing posts with label quot. Show all posts
Showing posts with label quot. Show all posts

Tuesday, March 27, 2012

A Dimension Attribute with Double DataType converts a zero member to "(blank)"

In one of our SSAS 2005 sp2 cubes, we have a Dimension sourced from an Oracle table, with an Attribute that has a DataType of Double. When we process the Dimension and browse the Attribute, we see the following members:

All

-.01

-.002

.00000000001

.0000000001

Unknown

Notice how its blank where the '0' (zero) member should be. The underlying Oracle table does have '0' (zero) values for this column (you can see them when you explore the data in the DSV). To make things even more confusing,

the Unique_Name for this blank member is: [Dimension].[Attribute].&[0]

its Member_Value is: 0

its Member_Caption is: Null

its Member_Key is: 0

Has anyone seen this behaviour before? If so, how do we fix it?

Thank you.

Hi,

Have you set the NameColumn to look at the same field? And is it a datatype of WChar?

Matt|||

Hi Matt,

Thanks for the reply. Yes, setting the NameColumn to the field was one of the things i tried. The database field is NUMERIC(15,9), the KeyColumn is a datatype of Double and the NameColumn is a datatype of WChar. Even with the NameColumn set to the same field, I still get a blank where the 0 value should be.

-Robbie

Monday, February 13, 2012

403 error: The remote server returned an error: (403) Forbidden.

When I try to view the report, I got the error "The remote server returned an error: (403) Forbidden. ". And in the event log , I got the detaiil excception:


Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2007-7-16
Time: 11:28:29
User: N/A
Computer: WEIGUANG
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2007-7-16 11:28:29
Event time (UTC): 2007-7-16 3:28:29
Event ID: 3c4daa414c89430786c106f3c9085b56
Event sequence: 10
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-2-128290300818412520
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: WEIGUANG
Process information:
Process ID: 4152
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.
Request information:
Request URL: http://localhost/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 127.0.0.1
User: ASIAPACIFIC\liweig
Is authenticated: True
Authentication Type: NTLM
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'm using reporting service 2005, does anybody know the reason?

Many thanks.

Kevin

we encounter the same problem. did you already resolved it? can you give us a hint?

thx in advance,
rainer
|||

IIS permissions.

403?

You're not even touching the Report Server.

You need to get your IIS admin to allow your group/users permission to see the RS folders

|||well i am getting the following entry in the eventlog:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 24.07.2007
Time: 12:37:38
User: N/A
Computer: HERAS75
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 24.07.2007 12:37:38
Event time (UTC): 24.07.2007 10:37:38
Event ID: f6730dc158f640c7924c590d73226477
Event sequence: 112
Event occurrence: 5
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/root/AdminReports-1-128297459440092913
Trust level: RosettaMgr
Application Virtual Path: /AdminReports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: HERAS75

Process information:
Process ID: 5052
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.

Request information:
Request URL: http://heras75/AdminReports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /AdminReports/Reserved.ReportViewerWebControl.axd
User host address: 10.101.7.26
User: HER\admin_arnken
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


if am opening a report page it starts rendering the page but then throws the following error and no data is shown:
  • The remote server returned an error: (403) Forbidden.|||Admin tools -> IIS
    directory security
    edit
    select 'integrated windows authentication'
    ok

    right click 'permissions'
    from here you can see which groups/users have access

    it is better to administer with groups as that way, when someone bothers you to see a report, you can tell them to go and see the helpdesk/whoever manages AD groups instead, and get them to add them to the group

  • 403 error: The remote server returned an error: (403) Forbidden.

    When I try to view the report, I got the error "The remote server returned an error: (403) Forbidden. ". And in the event log , I got the detaiil excception:


    Event Type: Warning
    Event Source: ASP.NET 2.0.50727.0
    Event Category: Web Event
    Event ID: 1309
    Date: 2007-7-16
    Time: 11:28:29
    User: N/A
    Computer: WEIGUANG
    Description:
    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 2007-7-16 11:28:29
    Event time (UTC): 2007-7-16 3:28:29
    Event ID: 3c4daa414c89430786c106f3c9085b56
    Event sequence: 10
    Event occurrence: 1
    Event detail code: 0
    Application information:
    Application domain: /LM/W3SVC/1/Root/Reports-2-128290300818412520
    Trust level: RosettaMgr
    Application Virtual Path: /Reports
    Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
    Machine name: WEIGUANG
    Process information:
    Process ID: 4152
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
    Exception information:
    Exception type: WebException
    Exception message: The remote server returned an error: (403) Forbidden.
    Request information:
    Request URL: http://localhost/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
    Request path: /Reports/Reserved.ReportViewerWebControl.axd
    User host address: 127.0.0.1
    User: ASIAPACIFIC\liweig
    Is authenticated: True
    Authentication Type: NTLM
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Thread information:
    Thread ID: 5
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: True
    Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
    at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
    at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
    at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    I'm using reporting service 2005, does anybody know the reason?

    Many thanks.

    Kevin

    we encounter the same problem. did you already resolved it? can you give us a hint?

    thx in advance,
    rainer
    |||

    IIS permissions.

    403?

    You're not even touching the Report Server.

    You need to get your IIS admin to allow your group/users permission to see the RS folders

    |||well i am getting the following entry in the eventlog:

    Event Type: Warning
    Event Source: ASP.NET 2.0.50727.0
    Event Category: Web Event
    Event ID: 1309
    Date: 24.07.2007
    Time: 12:37:38
    User: N/A
    Computer: HERAS75
    Description:
    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 24.07.2007 12:37:38
    Event time (UTC): 24.07.2007 10:37:38
    Event ID: f6730dc158f640c7924c590d73226477
    Event sequence: 112
    Event occurrence: 5
    Event detail code: 0

    Application information:
    Application domain: /LM/W3SVC/1/root/AdminReports-1-128297459440092913
    Trust level: RosettaMgr
    Application Virtual Path: /AdminReports
    Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
    Machine name: HERAS75

    Process information:
    Process ID: 5052
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE

    Exception information:
    Exception type: WebException
    Exception message: The remote server returned an error: (403) Forbidden.

    Request information:
    Request URL: http://heras75/AdminReports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
    Request path: /AdminReports/Reserved.ReportViewerWebControl.axd
    User host address: 10.101.7.26
    User: HER\admin_arnken
    Is authenticated: True
    Authentication Type: Negotiate
    Thread account name: NT AUTHORITY\NETWORK SERVICE

    Thread information:
    Thread ID: 7
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: True
    Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
    at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
    at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
    at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


    if am opening a report page it starts rendering the page but then throws the following error and no data is shown:
  • The remote server returned an error: (403) Forbidden.|||Admin tools -> IIS
    directory security
    edit
    select 'integrated windows authentication'
    ok

    right click 'permissions'
    from here you can see which groups/users have access

    it is better to administer with groups as that way, when someone bothers you to see a report, you can tell them to go and see the helpdesk/whoever manages AD groups instead, and get them to add them to the group

  • 400: Bad Request

    I am getting an "The request failed with HTTP status 400: Bad Request " Error in Report Manager Webpage. http://servername/Reports
    The Reportserver itself and reports works fine (http://servername/reportserver).
    Reports render OK and i am still able to connect to reportserver by management studio.

    The environment is a W2K3 Standard with SQL 2005 (Build 2153) - and the server is a domain controller.

    Reporting Service Configuration does not mention any issues - I have reapplied default settings - no change.
    There are no errors in the eventlog.

    I need some help - please

    HANNESI have already checked the following posts

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=284929&SiteID=1
    (I did not understend the "RSWebApplication.config" file - as soon as i write in the a reportserver url the website returns an execption - so this config must be empty I guess)

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=479636&SiteID=1|||This post gave me the finale hint (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=165851&SiteID=1) - but I do not habe a specific IP address bound to the website - but I had specific hostheaders and it seems the reportmanager needs at least one binding with no hosthader in my environment - therefor I added a fifth binding with no hosthander, no specific IP and default Port

    Hannes