Skip to Content
avatar image
Former Member

After migration of reports getting database error

Hi,

I have migrated 2 universe & 25 reports from DEV to PROD environment successfully.

While testing reports on PROD among 25 reports 2 reports giving below error. However the field/object which is giving error is also present in other reports and all other reports are working fine. please help.

Thanks in advance.

Priyanka

1.jpg (196.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 05, 2016 at 10:38 AM

    Hello Priyanka,

    This error is a run time error and probably a data situation has arise that is causing the error message to pop up.

    Could you please share the details about the Field/Object that is causing the issue?

    Meanwhile please go through below thread that may help you.

    Error : Conversion failed when converting the n... | SCN

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2016 at 12:34 PM

    Hi,

    Do you have same database version in both DEV and PROD?

    Did you try an integrity check of the universe in PROD before checking the reports?

    You can try below at report level:

    - First check from which data provider this error is coming. In case this object is used in all data providers in WHERE clause then run them one by one and check.

    - After narrowing down, edit the data provider in which you get the error , go to SQL tab and get the SQL.

    - Run this SQL against SQL Analyzer i.e. directly against SQL Server bypassing Webi and check.

    Try to find the particular condition in WHERE by commenting each condition one by one and share with us.

    Regards,

    Yuvraj

    Add comment
    10|10000 characters needed characters exceeded