[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Exceptions in SQR
- Subject: RE: [sqr-users] Exceptions in SQR
- From: "Bob Buford" <Bob.Buford@ccci.org>
- Date: Tue, 12 Jul 2005 07:23:49 -0400
- Delivery-date: Tue, 12 Jul 2005 06:25:15 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcWG1CzSDZfbmhpiSeCdge8DN5Vv7A==
- Thread-topic: [sqr-users] Exceptions in SQR
Hi Tam,
Try fully qualifying the filename with complete path - it's possible
that the file is being created in a folder that you didn't expect to be
used.
Also you could get the status value when opening the 'output.properties'
file and print that to the log.
Code looks valid and you should have 2 files created:
- output.properties
- sqr.log, with 1 line entry 'testing exceptions'. Note that
sqr.log might be named and located differently if you run it at batch
server vs. client.
Bob Buford
-----Original Message-----
From: tam kag [mailto:kaghdot@hotmail.com]
Sent: Monday, July 11, 2005 9:43 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Exceptions in SQR
Hello,
I'm trying to write an exception report, I have copied this code from
the Brio Manual. then published the file in Brio Portal and allowed
exceptions to occur then subscribed to receive exceptions, then ran the
job but I have not received the exception report.
the code used:
begin-program
print 'testing exceptions' (5,5)
move 'testing exceptions in SQR' to $excpetion_text do exception
end-program
begin-procedure exception
open 'output.properties' as 0 for-append record=32767:vary
write 0 from 'rating=high_priority'
write 0 from 'exception.default=on'
write 0 from $excpetion_text
close 0
end-procedure
Please advice.
Thank you
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users