You’re offline. This is a read only version of the page.
330
We are trying to view a report through the Report Viewer in Business Portal. We have gotten two specific errors. They are:
We understand what is wrong, but not sure where to correct it. Instead of finding the table in the Application database where it exists and it should look for it, it is looking for it in the System database. Obviously, there is a view or procedure that is incorrectly pointed to the wrong database. We have tried a "SQL Trace" but that did not seem to work (at least we did not find the answer).
Does anyone know where or what we need to change?
*This post is locked for comments
Hi Jen,
Currently there is no solution to resolve it, I had provided a workaround to my client. The issue my client encountered seem like a bug in BP itself. Not sure it is due to IE version, as most of the user is using IE10 & IE 11. Even using compatibility view, issue still happened.
I had advised my customer to wait for the data to load/change before making any changes. So far, there is no further complaint from my client.
Hope this help.
Regards,
Teh
Ya Teh - how did you resolve? I have a client experiencing the same thing.
Hi,
I managed to figure out what's the issue on my client side. It seem like a bug in the dialog box. When changing the Role from default Back Office to Project Employee list, the detail grid on the dialog box was not refresh correctly. It is still showing Back Office user list in the detail instead of Project Employee list, that's why when trying to add, not manage to find the userrec from the application database.
We had to uninstall and reinstall to resolve the issue. That resolved the issue. Something must have happened on the installation that we were unaware of.
Hi,
Are you able to solve the issue? I had a customer having similar issue but the other way round.
When the administrator trying to add modify the user role, it prompt invalid object name userrec, but it was trying to search the table in the app db instead of system db.
Regards,
Teh
Obviously this was unclear: "Instead of finding the table in the Application database where it exists and it should look for it, it is looking for it in the System database."
The issue here is that the process is looking for the table in the System database and not in the Application database. The table is in the application database. The table is not in the System database. The table should not be in the system database. It should only reside in the application database.
So, do anyone know what procedure or xml file needs to be corrected so that is looks in the correct place (the place where the table does exists)?
Philippe
Hi Philippe,
I just realized you said the table is in the application database. Is that correct?
Hi Philippe,
If you check in SQL, is the ReportCatalog table there? You can check this by running the following in SQL against the SL Application DB:
select * from reportcatalog
If this returns an invalid object or other error, the table is most likely not there at all.
Did you recently upgrade to suddenly have this error? Usually if objects are missing we recommend an uninstall and reinstall of BP.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (