Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL forum / System.Data.SqlClient....
Microsoft Dynamics SL forum
Unanswered

System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

(0) ShareShare
ReportReport
Posted on by Philippe Boulos 330

We are trying to view a report through the Report Viewer in Business Portal.  We have gotten two specific errors.  They are:

  1. An exception has occurred and been written to the Application Event Viewer.  Contact your System Administration.
  2. Invalid object name 'SLSystem..ReportCatalog'.

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?

 

Categories:
Business Portal
  • YA TEH Profile Picture
    YA TEH 1,217 on at
    RE: System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

    Ya Teh - how did you resolve?  I have a client experiencing the same thing.  

  • YA TEH Profile Picture
    YA TEH 1,217 on at
    RE: System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

    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.

  • Philippe Boulos Profile Picture
    Philippe Boulos 330 on at
    RE: System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

    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.

  • YA TEH Profile Picture
    YA TEH 1,217 on at
    RE: System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

    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

  • Philippe Boulos Profile Picture
    Philippe Boulos 330 on at
    RE: System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

    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

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

    Hi Philippe,

    I just realized you said the table is in the application database.  Is that correct?

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: System.Data.SqlClient.SqlException: Invalid object name 'SLSystem..ReportCatalog'.

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans