COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: koteshwar on 06 Jun 2007 07:36:18 AM

Title: cogserver.log files
Post by: koteshwar on 06 Jun 2007 07:36:18 AM
Hi All,

        I need the help from u it's very urgent,My problem is when i run the report in Excel or Pdf
i got the following errors in cogserver.log file

<message code="888" severity="error" title="QE-DEF-0459 CCLException" type="general">

QFS-ERR-0139 the request has multiple errors.

RQP-DEF-0354 the query contains one or more unresolved prompts.

QE-DEF-0144 Prompt &apos;P_USER_ID&apos; has no substitution values.

</message>

   Can  any one help me to resolve  this problem in cogserver.log file


    Thanks in Advance.

Title: Re: cogserver.log files
Post by: Desperado on 06 Jun 2007 08:15:21 AM
Remove any trailing space in prompt name (the first parameter in the prompt macro) in Framework Manager.
Re-publish the package
Title: Re: cogserver.log files
Post by: koteshwar on 07 Jun 2007 06:47:11 AM
 Thanks Desperado for Immediate response on cogserver error,

  I have 3 Packages which has prompts in framework manager When i right click the package in frame work manger in Edit defination i got 3 Tabs(query defination,Test,--) i clicked on query defination it  displayed the promts about the package,When i clicked on right corner of each prompt value i removed the spaces, But even though iam getting the same errors in cogserver.log file

I hope u, Please provide me a alternate solution for the problem.

Thanks in advance.
Title: Re: cogserver.log files
Post by: JoeBass on 07 Jun 2007 07:20:56 AM
Do your parameter names in RN exactly match the names you defined in FM?