RE: [sqr-users] 6.2 -> 8.3 Upgrade problems

["Joe R. Jah" <jjah@cloud.ccsf.cc.ca.us>]

On Fri, 17 Jun 2005, Alexander, Steve wrote:

> Date: Fri, 17 Jun 2005 09:19:27 -0700
> From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
> Reply-To: This list is for discussion about the SQR database reporting
    language from Hyperion Solutions. <sqr-users@sqrug.org>
> To: 'This list is for discussion about the SQR database reportinglanguage
    from Hyperion Solutions.' <sqr-users@sqrug.org>
> Subject: RE: [sqr-users] 6.2 -> 8.3 Upgrade problems
> 
> I know this isn't what you asked, but this looks like "write-only" code,
> never intended to be maintained.  It's joining nine tables, and some with
> outer joins.  (That probably runs slowly.)  The tables seem to be far from
> normalized.  Most of the tables don't have aliases, so you can't tell which
> fields belong to which tables.  The elaborate decode statements suggest
> either that the contents of the tables are not really what you wished them
> to be or the SQR program was written without regard for the actual data.
> 
> The mystery is why "SCRATTR_ATTR_CODE" is an invalid identifier.  You didn't
> mention any change to the tables or to the Oracle software.  Perhaps this
> very long SQL statement got truncated when SQR sent it to the database
> server, and the table containing SCRATTR_ATTR_CODE was omitted from the FROM
> clause.

Thank you for your astute observation; the problem in "SCRATTR_ATTR_CODE"
had been created by a FIX, (it has been reversed,) to fix the original
problem caused by the 6.2 -> 8.3 upgrade:

 Hyperion SQR Server 8.3
 Copyright (c) 1994-2004 Hyperion Solutions Corporation.  All Rights Reserved.

 Executing SWRMC07 report
 (SQR 5528) ORACLE OCIStmtFetch error 1406 in cursor 9:
    ORA-01406: fetched column value was truncated

 Error on line 434:
    (SQR 3725) Bad return fetching row from database.

 SQR: Program Aborting.

There aren't any changes to the tables or to the Oracle software:

  Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
  With the Partitioning, OLAP and Oracle Data Mining options
  JServer Release 9.2.0.5.0 - Production

Best regards,

Joe
-- 
     _/   _/_/_/       _/              ____________    __o
     _/   _/   _/      _/         ______________     _-\<,_
 _/  _/   _/_/_/   _/  _/                     ......(_)/ (_)
  _/_/ oe _/   _/.  _/_/ ah        jjah@cloud.ccsf.cc.ca.us


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users