Report Problem

BraiN
BraiN Member Posts: 13
edited 2007-12-03 in Navision e-Commerce
Hi, i'm having some problems showing reports in the ep.
I had added a Action to the Table using this parameters:

Show Report » Current » SHOWREPORT » 122 » 206

Table 122 = Purch. Inv. Header
Report 206 = Sales-Invoice

I had added the new code to the Codeunit 6828 ( EP Report Mgt. ).

When i click on the "link" to get the report it just opens a ie window with a error saying that the page is not avaible. I had tryied to track the xml messages that the nas returns to nav from sharepoint and i dont get any response when i click the link. Has this happen to anyone before?

Best regards,
Rafael Fontes

Comments

  • IHateLinux
    IHateLinux Member Posts: 223
    Hi,

    sorry but correct me if i am wrong, but if you want to print the purchase invoice report (do not know the id currently), this report must be based on table 122, if you want to print the sales invoice report (206), you have to set the table 112 - Sales Invoice Header (not 122).

    HTH,

    Rainer
  • BraiN
    BraiN Member Posts: 13
    Yes your are right. I had the table 112 defined... :P i just wrote 122 by mistake.

    I solve the problem be reading your post:
    http://mibuso.com/forum/viewtopic.php?t=8887&highlight=report+problem&sid=93c34e71fea3990745a26859f8c562c0

    But now have a weird problem....

    Parser Error Message: File or assembly name Microsoft.Navision.EmployeePortal.UserControlLibrary, or one of its dependencies, was not found.

    i got the dll where it should be, i have tryied to give the full path to the dll file and got the same problem :X
  • IHateLinux
    IHateLinux Member Posts: 223
    Hi,

    please provide a little bit more information about your installation:
    - Which NAV version?
    - Which EP version?
    - Which WSS version / MOSS / SPS?

    Thanks.

    KR
    Rainer
  • BraiN
    BraiN Member Posts: 13
    Versions:
    - Nav 4.0 SP3
    - EP 4.0 SP3
    - WSS 2003
    - Microsoft .NET Framework Version:1.1.4322.2300
    - ASP.NET Version:1.1.4322.2300

    This is weird... i have checked the lines from report.aspx and its equal to some that i saw in the forum.

    Parser Error
    Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

    Parser Error Message: File or assembly name Microsoft.Navision.EmployeePortal.UserControlLibrary, or one of its dependencies, was not found.

    Source Error:


    [No relevant source lines]


    Source File: report.aspx Line: 1

    Report.aspx: 
    <%@ Register TagPrefix="cc" Namespace="Microsoft.Navision.EmployeePortal.CustomControlLibrary" Assembly="Microsoft.Navision.EmployeePortal.UserControlLibrary" %>
<%@ Page language="c#" Codebehind="Report.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.Navision.EmployeePortal.UserControlLibrary.ReportPage" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
	<HEAD>
		<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
		<meta name="CODE_LANGUAGE" Content="C#">
		<meta name="vs_defaultClientScript" content="JavaScript">
		<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
		<link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/ows.css">
		<script language="javascript">
			window.focus();
		</script>
	</HEAD>
	<body class="ms-WPBody">
		<form id="Form1" method="post" runat="server">
			<cc:Report runat="server" id="report" />
			<asp:Label id="label1" runat="server" />
		</form>
	</body>
</HTML>
  • IHateLinux
    IHateLinux Member Posts: 223
    Hi,

    can you check the web.config and see what trust level your site is using?
    Can you verify, that the folder "UserControls" is an Excluded Path in SharePoint?

    HTH,
    Rainer
  • BraiN
    BraiN Member Posts: 13 
    <trustLevel name="WSS_Medium" policyFile="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\config\wss_mediumtrust.config" />
      <trustLevel name="WSS_Minimal" policyFile="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\config\wss_minimaltrust.config" />
      <trustLevel name="WSS_NEP_Minimal" policyFile="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Config\wss_NEP_minimaltrust.config" />

    The UserControls is a excluded path.
  • IHateLinux
    IHateLinux Member Posts: 223
    Hi,

    can you please send a list of all files in the bin folder of the website?

    KR,
    Rainer
  • BraiN
    BraiN Member Posts: 13
    Microsoft.Navision.EmployeePortal.Communication.dll
    Microsoft.Navision.EmployeePortal.Connector.dll
    Microsoft.Navision.EmployeePortal.DataStorage.dll
    Microsoft.Navision.EmployeePortal.dll
    Microsoft.Navision.EmployeePortal.ErrorLibrary.dll
    Microsoft.Navision.EmployeePortal.UserControlLibrary.dll

    The file is there in the Bin.

    Best Regards.
  • BraiN
    BraiN Member Posts: 13
    Well, i solved the previous problem, by copying the Bin folder with all files inside to the directory UserControls. For some reason IIS wasnt getting to the directory in the root of the homepage.
    Now i have another error.

    Unable to initialize data storage. Please close this window and reload the Web Page. (10035)

    This is getting tricky :X

    Best regards,
    Rafael Fontes
  • IHateLinux
    IHateLinux Member Posts: 223
    Hi,

    this indicates that the enableSession is not set to true.

    Please inspect the web.config file. There is one entry in the PAGES node (i think, sorry i have currently no EP portal at hand) the enableSessionState must be set to true as well as a node which is normally commented named SessionState - not 100% sure, search for session in the web.config, there should be not that many entries.

    HTH,
    Rainer
  • BraiN
    BraiN Member Posts: 13
    Hi, i have checked the web.config. The session was already set to true :X
    <httpModules>
      <clear />
      <add name="OutputCache" type="System.Web.Caching.OutputCacheModule" />
      <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />
      [b]<add name="Session" type="System.Web.SessionState.SessionStateModule" />[/b]
    </httpModules>
    <globalization fileEncoding="utf-8" />
    <compilation batch="false" debug="false" />
    <pages [b]enableSessionState="true"[/b] enableViewState="true" enableViewStateMac="true" validateRequest="true" />

    Still getting the same problem :x
  • IHateLinux
    IHateLinux Member Posts: 223
    Hi,

    this sounds really like a weird problem.

    Can you do two other tests?
    The "normal" EP web parts are working?

    Can you create a second portal and try the configuration there as well?

    From my point of view something really strange happens with either your IIS and/or with that web site (because the BIN folder is accessible anywhere in a site).

    KR
    Rainer
  • BraiN
    BraiN Member Posts: 13
    Yes the other web parts works fine.
    This is getting quiet weird :X
    I will try that.

    Thanks :)
  • BraiN
    BraiN Member Posts: 13
    I got the weekend to do more trys to fix this problem. But the result is still the same.
    I had made another Page and start the config from scratch. Still getting the same problem.

    If someone else gets to this error please tell me something.

    Thanks IHateLinux for the help.

    Best regards.

Categories