Hi All,
I am getting the error(Conection or Sql sentence error: (DA0005);[Exception:DBD,ORA-00942:Table or view does not exist:N/A the following data providers have not been successfully refreshed: DMA0007 ERROR:IF)
while refreshing the reports(Freehand sql based) from Infoview but i am able to run the same set of reports in Deski.
This is happening after changing the database(usr\pwd@database)
Clarifications needed on the following points:
1–>when we change the Connection in freehandsql do we need to export all the reports in to repository?
2–>Any server side Connection change is required?
Any suggesstions or inputs plz share as earliest.
hi,
How to change the existing connection in the server?
if i develop the new report in deski and deploy into the Repository then i am able to refresh it from the Infoview with out any error.Problem with the old reports…i Have tried to edit the connection by following link–>
CMC-Universeconnections-ConnectionName but i am not able to see the database details to which it pointing to.
any idea how to can i edit the connection???
Hi Siva,
Thanks for your input on this issue.i tried like edit the connection and exported to Repository it is working fine for some reports but not all reports.Moreover if this funda is works fine i have 100 reports having the same problem.do i need to export all the 100 reports?? any other solution by changing the connection at server side it will be greate helpfull in this case.
All shared & personal connections (used by freehand SQL) are stored in lsi files pdac.lsi(personal connections) & sdac.lsi(shared connections).
These files can be found in documents and settings folder under application data.
Copy them to the Busobj server and you should be good to go.
HI Haider,
Thanks for prompt response.i am able to see the sdac.lsi file in the following path “C:\Documents and Settings\sysuser1\Application Data\Business Objects\Business Objects 11.5\lsi” this file is in server pc only.i didn’t get you Copy this file into Busobj Server…
Can you please tell me where do i need to copy this file into Busobj Server(path…)
I assume that the freehand SQL reports were created at a client machine, so also the connections.
By copying files I meant to copy them from the client machine to Busobj server in same path mentioned by you.
HI All,
I got the solution on the above Issue but this can be bit time taken process(I have changed the connection in Deski and exported in each and every report) still i am awaiting for any solution by changing the connection at one shot if the same problem comes in the future.
I found pdac and sdac files at below location, because Im using version 5.x and xir2 in same machine. C:\Program Files\Business Objects\BusinessObjects 5.0\LocData.
Please some one can guide me where do I need to place this files on BOXI Server in unix???
(BOB member since 2008-01-10)
(BOB member since 2007-05-31)
(BOB member since 2006-02-08)
(BOB member since 2005-07-18)
(BOB member since 2005-07-18)