3 Replies Latest reply on Mar 24, 2008 6:17 AM by 247514

    SQR 5402

    606910
    606910 Mar 18, 2008 7:08 AM
      Hey there,

      We're trying to migrate off of a server 'OLD' to server 'NEW'.
      Both are running the same instance of Oracle 9.2.0.5.0 (32 bit)
      running on a 64 bit Solaris machine and both are running the same version
      of SQR (8.1)
      OLD has Solaris version 8
      NEW has Solaris version 10

      We're just trying to replicate the environment for now to prepare
      for upgrades soon.

      So the problem is.. we have a shell-script that first, sets environment
      variables and then executes an SQR.

      The script runs without errors on server-OLD, but I get this error
      message on server-NEW:

      Error on line 103:
      (SQR 5402) String cannot be placed on page: <...string...>
      -- placement specified is out of range. (0,1,0)

      SQR: Program Aborting.

      I can't find any differences between the SQR or Oracle installations.
      (Same installations, same patches) - but I'm obviously missing something.

      We don't want to modify the data itself (although that would fix
      this case) because it obviously runs fine on 'OLD'.
      I've kind of run out of ideas and was hoping someone might have
      a clue as to why.

      any ideas would be most appreciated!

      thanks in advance
      • 3224 Views
      • Tags:
        • 1. Re: SQR 5402
          Barry Mcgillin-Oracle
          Barry Mcgillin-Oracle Mar 22, 2008 8:44 PM (in response to 606910)
          Raman, what is SQR, is that the old SQL Reports?
          B
          • 2. Re: SQR 5402
            606910
            606910 Mar 23, 2008 6:11 AM (in response to Barry Mcgillin-Oracle)
            I think so. It was made by BRIO software, then acquired by oracle.

            an example of SQR code:
            begin-report
            do P_logs
            end-report

            begin-setup
            page-size 58 132
            end-setup

            begin-procedure P_logs
            print '+P{~' (+5,1)
            print '' (+1)
            print '+P{~' (+1,1)
            ....
            • 3. Re: SQR 5402
              247514
              247514 Mar 24, 2008 6:17 AM (in response to 606910)
              I think so. It was made by BRIO software, then
              acquired by oracle.
              Actually looks like SQR's history is a little complicate than that,

              http://en.wikipedia.org/wiki/SQR

              SQ Software created SQR in the mid 1980s.
              MITI acquired the full rights to SQR in the mid 1990s.
              MITI changed its name to SQRiBE Technologies in 1997.
              Brio Technology acquired SQRiBE in August, 1999.
              Brio Technology later changed its name to Brio Software.
              Hyperion Solutions Corporation acquired Brio Software in October, 2003.
              Oracle Corporation acquired PeopleSoft in December, 2004.
              And as of March 2007 Oracle Corporation has acquired Hyperion Solutions.

              You might want to check your luck in Hyperion Forum, someone there might have experience.