Data expression error

Thu, 16 Oct 2003 11:10:52 -0700

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C39410.A7CB5D7A
Content-Type: text/plain;
	charset="iso-8859-1"

yes, thnx, I do understand this.   What I was hoping for was if someone knew
of some "trick" that would let me track down the offending bit of code (in
amounst thousands of lines of code) without having to put in info statements
all over the place.

-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: 2003 October 16 10:26 AM
To: Johnson, Harold A EDUC:EX; Powerhouse List (E-mail)
Subject: RE: Data expression error

Sorry if this is obvious but this message comes from the expression
processor. So look at the expressions in the screen which includes all data
sources, not just things that use functions. For example, if you have a LET
verb (LET A = B), the source (B) is treated as an expression. If A is
numeric and you've substructured B (or B is in a substructure) such that B
has non-numeric data, you'll get a data expression error. Other than that,
things like division by zero, nested functions where the function result is
invalid, etc. are the things I'd look for. Note that if your message verbs
use the = option, the source is an expression.

Hope this helps. 

Bob Deskin              
Product Manager, Application Development Tools, Cognos Inc. 
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178 
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA 

-----Original Message----- 
From: Johnson, Harold A EDUC:EX 
[ mailto:Harold.A.Johnson@gems1.gov.bc.ca
<mailto:Harold.A.Johnson@gems1.gov.bc.ca> ] 
Sent: Thursday, October 16, 2003 12:55 PM 
To: Powerhouse List (E-mail) 
Subject: Data expression error 

Hi all.  Does anyone know of an easy method of tracking down these "Data 
Expression Errors" in a quick program?  The message only seems to come out 
when either an Info/Warning/etc statement is issued or the quick program 
ends. 

thnx 

= = = = = = = = = = = = = = = = = = = = = = = = = = = = 
Mailing list: powerh-l@lists.swau.edu 
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu 
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu 
http://lists.swau.edu/mailman/listinfo/powerh-l
<http://lists.swau.edu/mailman/listinfo/powerh-l>  
This list is closed, thus to post to the list you must be a subscriber. 

Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum. Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03
<http://www.cognos.com/enterprise03> for more details.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

------_=_NextPart_001_01C39410.A7CB5D7A
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Data expression error</TITLE>

<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV>yes, 
thnx, I do understand this.&nbsp;&nbsp; What I was hoping for was if someone 
knew of some "trick" that would let me track down the offending bit of code (in 
amounst thousands of lines of code) without having to put in info statements all 
over the place.</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
 <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Deskin, Bob 
 [mailto:Bob.Deskin@Cognos.COM] Sent: 2003 October 16 10:26 
 AM To: Johnson, Harold A EDUC:EX; Powerhouse List 
 (E-mail) Subject: RE: Data expression error </DIV>
 Sorry if this is obvious but this message comes from the 
 expression processor. So look at the expressions in the screen which includes 
 all data sources, not just things that use functions. For example, if you have 
 a LET verb (LET A = B), the source (B) is treated as an expression. If A is 
 numeric and you've substructured B (or B is in a substructure) such that B has 
 non-numeric data, you'll get a data expression error. Other than that, things 
 like division by zero, nested functions where the function result is invalid, 
 etc. are the things I'd look for. Note that if your message verbs use the = 
 option, the source is an expression.
 Hope this helps. 
 Bob 
 Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 Product Manager, Application Development Tools, Cognos 
 Inc. bob.deskin@cognos.com (613) 738-1338 ext 7268 
 FAX: (613) 727-1178 3755 Riverside Drive P.O. Box 9707 
 Stn. T, Ottawa ON K1G 4K9 CANADA 
 -----Original Message----- From: 
 Johnson, Harold A EDUC:EX [<A 
 href="mailto:Harold.A.Johnson@gems1.gov.bc.ca">mailto:Harold.A.Johnson@gems1.gov.bc.ca</A>] 
 Sent: Thursday, October 16, 2003 12:55 PM To: Powerhouse List (E-mail) Subject: Data 
 expression error 
 Hi all.&nbsp; Does anyone know of an easy method of tracking 
 down these "Data Expression Errors" in a quick 
 program?&nbsp; The message only seems to come out when 
 either an Info/Warning/etc statement is issued or the quick program 
 ends. 
 thnx 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Mailing list: powerh-l@lists.swau.edu Subscribe: "subscribe" in message body to 
 powerh-l-request@lists.swau.edu Unsubscribe: 
 "unsubscribe &lt;password&gt;" in message body to 
 powerh-l-request@lists.swau.edu <A 
 href="http://lists.swau.edu/mailman/listinfo/powerh-l" 
 target=_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A> 
 This list is closed, thus to post to the list you must be a 
 subscriber. 
 Join us at Cognos' biggest event of the year Enterprise 
 2003, The Cognos Business Forum.&nbsp; Taking place in over 25 cities 
 around the world, it's an opportunity for Business and IT leaders to learn 
 about strategies for driving performance. Visit <A 
 href="http://www.cognos.com/enterprise03" 
 target=_blank>http://www.cognos.com/enterprise03</A> for more details. 
 
 This message may contain privileged and/or confidential 
 information.&nbsp; If you have received this e-mail in error or are not the 
 intended recipient, you may not use, copy, disseminate or distribute it; do 
 not open any attachments, delete it immediately from your system and notify 
 the sender promptly by e-mail that you have done so.&nbsp; Thank 
 you.</BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C39410.A7CB5D7A--