Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

No response was generated by the content providor

edited October 2005 in Server
Hello,

Sind 9.03 (but i had it also with the patch on 9.02 for the tree not
created) i'm getting a error when switching from page 1 to another page.

TrsWebTier.ProcessRequest: No response was generated by the content
provider.

Strange thing is that when we print the report to pdf all pages are
generated !!

Any suggestion on where to start searching for this behaviour.

Comments

  • edited October 2005
    Some Extra Logging & Code.
    As you can see the request arrives at the reportserver and he seems to be
    generating the page.

    =========================================================================
    This is my code of the ProcessDefaultRequest (With some logging)
    =========================================================================
    function TwmMain.ProcessDefaultRequest(aWebRequest: TrsWebRequest): String;
    begin
    // Logging
    if Debug then LogIt('ProcessDefaultRequest - Start');
    // Log To Database in Arcihex Report
    if aWebRequest.VolumeName = 'Archived Reports' then
    begin
    qryInsert_RB_Logging_RunRep.Parameters.ParamByName('xUser').Value :=
    aWebRequest.SessionParameters['AccountName'].Value;
    qryInsert_RB_Logging_RunRep.Parameters.ParamByName('xReport').Value :=
    aWebRequest.ReportName;
    qryInsert_RB_Logging_RunRep.Parameters.ParamByName('xSP').Value :=
    '';
    qryInsert_RB_Logging_RunRep.Parameters.ParamByName('xRP').Value :=
    '';
    qryInsert_RB_Logging_RunRep.Parameters.ParamByName('xASV').Value :=
    'Archive';
    qryInsert_RB_Logging_RunRep.ExecSQL;
    end;
    // Process
    if Debug then LogIt('ProcessDefaultRequest - Pass 1');
    Try
    if not rsWebTier.SessionExists(aWebRequest) then
    begin
    if Debug then LogIt('ProcessDefaultRequest - Pass 2.11');
    Result := GetLoginPage(aWebRequest);
    if Debug then LogIt('ProcessDefaultRequest - Pass 2.19');
    end
    else
    begin
    if Debug then LogIt('ProcessDefaultRequest - Pass 2.20');
    if rsWebTier.RequiresAutoSearchParameters(aWebRequest) then
    begin
    if Debug then LogIt('ProcessDefaultRequest - Pass 2.21');
    Result := GetAutoSearchParametersPage(aWebRequest);
    if Debug then LogIt('ProcessDefaultRequest - Pass 2.29');
    end
    else
    begin
    if Debug then LogIt('ProcessDefaultRequest - Pass 2.31');
    Result := rsWebTier.ProcessWebRequest(aWebRequest);
    if Debug then LogIt('ProcessDefaultRequest - Pass 2.39');
    end;
    end;
    Except
    on E: Exception do
    begin
    LogIt('ProcessDefaultRequest :: ' + E.Message);
    if E is EServerError then
    begin
    if Pos('Access denied', E.Message) > 0 then
    begin
    Result := 'Gij Nie';
    end
    else
    Result := rsWebTier.HandleException(aWebRequest, E);
    end
    else
    Result := rsWebTier.HandleException(aWebRequest, E);
    end;
    End;
    // Logging
    if Debug then LogIt('ProcessDefaultRequest - End');
    end;


    =========================================================================
    This is the logging Created by the WebTier
    =========================================================================
    00:15:30:363 WebTier3744 : D_KINEGROUP\HLEBOEUF :GET:
    content=viewer&volume=Online%20Reports&name=Ticket%20Sales%5CFeature%20Reports%5CFeatures%20By%20Performance%20%28Pay%20vs%20Free%29&folder=v1d4d2&SessionID=%7B2872F5E7%2D14D0%2D4FFF%2D8459%2D76EDCE100A35%7D&zoom=100
    00:15:30:363 WebTier3744 : wmMainwaDefaultAction - Start
    00:15:30:373 WebTier3744 : ProcessDefaultRequest - Start
    00:15:30:373 WebTier3744 : ProcessDefaultRequest - Pass 1
    00:15:30:373 WebTier3744 : ProcessDefaultRequest - Pass 2.20
    00:15:30:744 WebTier3744 : ProcessDefaultRequest - Pass 2.21
    00:15:30:744 WebTier3744 : GetAutoSearchParametersPage - Start
    00:15:30:764 WebTier3744 : GetSelect_Page (2) - Start
    00:15:30:764 WebTier3744 : BuildComplexSelectList - Start
    00:15:30:774 WebTier3744 : BuildComplexSelectList - End
    00:15:30:774 WebTier3744 : GetSelect_Page - End
    00:15:30:774 WebTier3744 : GetAutoSearchParametersPage - End
    00:15:30:774 WebTier3744 : ProcessDefaultRequest - Pass 2.29
    00:15:30:774 WebTier3744 : ProcessDefaultRequest - End
    00:15:30:774 WebTier3744 : wmMainwaDefaultAction - End
    00:15:38:816 WebTier3744 : D_KINEGROUP\HLEBOEUF :POST:
    COMP_ID=KMAD&FromDay=01%2F01%2F2005&ToDay=17%2F10%2F2005&content=viewer&volume=Online+Reports&name=Ticket+Sales%5CFeature+Reports%5CFeatures+By+Performance+%28Pay+vs+Free%29&folder=v1d4d2&SessionID=%7B2872F5E7-14D0-4FFF-8459-76EDCE100A35%7D&zoom=100
    00:15:38:816 WebTier3744 : wmMainwaSearchParamsAction - Start
    00:15:38:816 WebTier3744 : ProcessAutoSearchRequest - Start
    00:15:38:886 WebTier3744 : Params-4 :: DaySalBuffer- Comp_Id
    00:15:38:886 WebTier3744 : Params-4 :: DaySalBuffer- Dsh_Date
    00:15:38:886 WebTier3744 : ProcessAutoSearchRequest-COMP_ID=KMAD
    00:15:38:886 WebTier3744 : ProcessAutoSearchRequest-DSH_DATE=01/01/2005,"
    17/10/2005"
    00:15:38:886 WebTier3744 : ProcessAutoSearchRequest - Parameters Set
    00:15:38:886 WebTier3744 : ProcessAutoSearchRequest - SessParams :
    AccountName=D_KINEGROUP\HLEBOEUF AccountPassword= BuildTree=False
    00:15:38:886 WebTier3744 : ProcessAutoSearchRequest - SrvcParams :
    ppRepCode=REP_004 ppSelCode=2 ppRepDate=1/01/2004
    00:15:38:886 WebTier3744 : ProcessAutoSearchRequest - AutoSVal :
    COMP_ID:KMAD DSH_DATE:01/01/2005," 17/10/2005"
    00:15:38:886 WebTier3744 : ProcessAutoSearchRequest - Run Logged
    00:15:38:896 WebTier3744 : ProcessAutoSearchRequest - Start Generate
    00:15:48:980 WebTier3744 : ProcessAutoSearchRequest - End
    00:15:48:980 WebTier3744 : wmMainwaSearchParamsAction - End
    00:16:07:567 WebTier3744 : D_KINEGROUP\HLEBOEUF :GET:
    content=viewer&pageframe=1&page=2&volume=Online%20Reports&name=Ticket%20Sales%5CFeature%20Reports%5CFeatures%20By%20Performance%20%28Pay%20vs%20Free%29&folder=v1d4d2&SessionID=%7B2872F5E7%2D14D0%2D4FFF%2D8459%2D76EDCE100A35%7D
    00:16:07:567 WebTier3744 : wmMainwaDefaultAction - Start
    00:16:07:577 WebTier3744 : ProcessDefaultRequest - Start
    00:16:07:577 WebTier3744 : ProcessDefaultRequest - Pass 1
    00:16:07:577 WebTier3744 : ProcessDefaultRequest - Pass 2.20
    00:16:07:587 WebTier3744 : ProcessDefaultRequest - Pass 2.31
    00:16:12:354 WebTier3744 : ProcessDefaultRequest - Pass 2.39
    00:16:12:354 WebTier3744 : ProcessDefaultRequest - End
    00:16:12:354 WebTier3744 : wmMainwaDefaultAction - End


    =========================================================================
    This is the logging Created by the ReportServer
    =========================================================================
    "20051018 00:15:30:423","Request AutoSearch parameters: Online
    Reports\Ticket Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceRequest,1183,GetAutoSearchParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:30:734","Send AutoSearch parameters: Online Reports\Ticket
    Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceResponse,1309,GetAutoSearchParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:30:744","Request report parameters: Online Reports\Ticket
    Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceRequest,1179,GetReportParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:30:764","Send report parameters: Online Reports\Ticket
    Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceResponse,1023,GetReportParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:38:836","Request AutoSearch parameters: Online
    Reports\Ticket Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceRequest,1183,GetAutoSearchParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:38:836","Send AutoSearch parameters: Online Reports\Ticket
    Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceResponse,1309,GetAutoSearchParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:38:866","Request report parameters: Online Reports\Ticket
    Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceRequest,1179,GetReportParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:38:866","Send report parameters: Online Reports\Ticket
    Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceResponse,1023,GetReportParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:38:916","Request report parameter validation: Online
    Reports\Ticket Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceRequest,1296,ValidateReportParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:38:916","Send report parameter validation response: Online
    Reports\Ticket Sales\Feature Reports\Features By Performance (Pay vs
    Free)",seServiceResponse,1052,ValidateReportParameters,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:38:956","Request page 1: Online Reports\Ticket Sales\Feature
    Reports\Features By Performance (Pay vs
    Free)",seServiceRequest,1843,PublishReport,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:15:47:278","Send page 1: Online Reports\Ticket Sales\Feature
    Reports\Features By Performance (Pay vs
    Free)",seServiceResponse,98345,PublishReport,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:16:07:617","Request page 2: Online Reports\Ticket Sales\Feature
    Reports\Features By Performance (Pay vs
    Free)",seServiceRequest,1844,PublishReport,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}
    "20051018 00:16:10:070","Send page 2: Online Reports\Ticket Sales\Feature
    Reports\Features By Performance (Pay vs
    Free)",seServiceResponse,97059,PublishReport,"Report
    Publishing",{058EBFA3-9ED1-4599-8C8F-567A8D6E39A0}




  • edited October 2005

    You and Ruud Bernards have both reported this error. Thus far I cannot
    recreate on my machine here. I am running the RB WebTier demos.

    Can you try running the demos on your machine?




    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited October 2005
    I've been testing with the Demo apps !!
    And yes, able to create the error.
    I've mailed you a screen shot as is seems to be the policy not to post
    binaries here.


  • edited October 2005
    Some additional Info

    OS :Win XP Pro SP2
    Browser : IE 6.0.2900.2180


    Again, if you want me to start looking more in detail, just mail the .pas
    (as last time) and i'll start the drill down.


  • edited October 2005
    Nard !!!!!

    =============================================
    My Logging Result
    =============================================
    14:46:07:779 rsWebCacheStorage.ReadHTML - Start
    14:46:07:779 rsWebCacheStorage.ReadHTML - Result Length(1) = 304826
    14:46:07:789 rsWebCacheStorage.ReadHTML - Result Length(2) = 0
    14:46:07:789 rsWebCacheStorage.ReadHTML - Start

    =============================================
    My Modified rb Code
    =============================================
    function TrsWebCacheStorage.ReadHTML(aElementName: String): String;
    var
    lsHTML: String;
    begin
    JakkertDaOpDienenDisk('rsWebCacheStorage.ReadHTML - Start');
    lsHTML := ReadText(aElementName);
    JakkertDaOpDienenDisk('rsWebCacheStorage.ReadHTML - Result Length(1) =
    '+IntToStr(Length(lsHTML)));
    Result := UTF8ToAnsi(lsHTML);
    JakkertDaOpDienenDisk('rsWebCacheStorage.ReadHTML - Result Length(2) =
    '+IntToStr(Length(Result)));
    JakkertDaOpDienenDisk('rsWebCacheStorage.ReadHTML - Start');
    end;


    Problem is that the UTF8ToAnsi zeroes the string !!!!
    Don't forget that in europe we have another characterset !!!
    In my reports i'm having french signs such as ? ? ?, spanish sings such as ?
    and even polisch characters !!

    I've seen that de decoding is in the system.pas, so i don't feel the export
    to start modifying delphi native code !!
  • edited October 2005
    I've mailed hou the generated html that becomes a empty-string in the
    conversion routine.
    Somewhere there must have been a change in the way html was generated
    because i didn't have this problem before 9.02/'patch for problem that
    explorer-html wasn't generated'
  • edited October 2005
    Nard, any progress ??

    This problem is really killing us, our users are forced to convert/print
    every report to pdf in order to see all pages !!
  • edited October 2005
    Nard, couldn't test in in production but on my testserver that also had the
    problem is seems to be gone.
    I'm in a traning course till tomorrow, thursday i'm at the office and will
    test it life.
    I'll let you know.

    Thanks already for the effort of sending the files and the adapted files.

    Ruud, if this problem puts you also in severe problems, just ask te
    temporary files from Nard. I suppose these will result into a patch.


  • edited October 2005
    Hello Nard

    ye, please, could you send me the temporary files Harry is talking about?
    Are these file 9.3 or 9.2 files?
    I should have delevered reports to a asp project last monday but was waiting
    for this problem to be solved.

    thanx in advance

    Ruud

  • edited October 2005
    Nard

    I've put it in production but, you no longer respect international character
    sets.
    Special signs are changed.
    Example: The ? (U+OOE9: Lattin Small Letter E With Acute, Alt 0233
    (Charmap.exe in Arial font) is changed to (U+00C3 : Latin Capital Latter A
    With Tilde, Keystore Alt+0195).

    This causes problems for end-users reading the reports
This discussion has been closed.