cancel
Showing results for 
Search instead for 
Did you mean: 

After migration of reports getting database error

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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