on 06-11-2019 12:07 PM
I have a webi report with date field in report and is being used in prompt as well with source as SQL Server. When I run the report in UAT, I see no issues; however, the same report is throwing error in PROD.
"Conversion failed when converting date and/or time from charater string."
Date Field: convert(date, getdate())
Can someone advise here.
Also make sure the middleware being used between uat and prd is the same.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ram,
did you check the user used both in the SQL Server and in the Universe Connection are the same?
I would strongly suggest to check also the prm file in the BI server, to check if it's coeherent with your format for the date (usually it's that the problem, see the following SAP Note
https://launchpad.support.sap.com/#/notes/2237919).
HTH
Daniele
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.