Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Unanswered: Converting SQLReports from 1.0 to 6i

    Hi,

    How do I convert SQLReports 1.0 to 6i ?
    I tried to convert SQLReports 1.0 to 2.0 using moverep.

    It is giving me the error SRW-2190 ( "Error transferring data from the fr_text to the srw_text table."). How do I get those FR_TEXT tables ?
    I have SRW_TEXT table in the database.

    or is there anyway to convert those old reports ??

    Thanks in advance..

  2. #2
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: Converting SQLReports from 1.0 to 6i

    Originally posted by desai
    Hi,

    How do I convert SQLReports 1.0 to 6i ?
    I tried to convert SQLReports 1.0 to 2.0 using moverep.

    It is giving me the error SRW-2190 ( "Error transferring data from the fr_text to the srw_text table."). How do I get those FR_TEXT tables ?
    I have SRW_TEXT table in the database.

    or is there anyway to convert those old reports ??

    Thanks in advance..
    Hi,
    Use dumprep to convert the report from 1.0 to 2.0. (create a .rex file)
    Converting 2.0 to 6 should not be a problem i guess.
    nn

  3. #3
    Join Date
    Oct 2004
    Posts
    1
    I tried DUMPREP and got SRW-1558: ORACLE error occurred...
    ORA-00942 : table or view does not exist

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by hpn
    I tried DUMPREP and got SRW-1558: ORACLE error occurred...
    ORA-00942 : table or view does not exist
    Does the tables in the query for the report exist in the database?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I guess this won't help much, but ... I'd suggest you to rewrite those reports in Report Builder 6i instead of converting them.

    Yes, I know - why bother and waste time if you can convert those reports? Because you'll probably convert simple reports (which would take no time to write them anyway). Complex reports will look like garbage and you'll spend much more time to fix them than you'd need to rewrite them.

    Anyhow, I'd really like to hear whether the conversion succeeded or not.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •