Erro ao excluir, incluir registro no Sharepoint

Danilo Almeida Silva 0 Reputation points
2023-02-06T11:54:34.1533333+00:00

Bom dia Comunidade!

Estamos com problema em nosso portal, quando um usuário inclui imagens ou noticias na pagina é apresentado erro:

"Exceção de HRESULT: 0x80131904"

Pesquisei e identifiquei que é pelo fato de que o banco está cheio, contudo limpei logs, realizei shrink das tabelas e nada funcionou.

Tentei limpar registros, imagens, artigos e noticias, quase limpei o site, mas a tabela "dbo.DocsToStreams" nem se mexeu... a exclusão dos indices não ajudaria já que são poucos utilizados.

Alguém poderia me ajudar em uma solução? Como limpar essa tabela já que a maioria dos registros contidos nela, não existem mais no servidor, ambos foram apagados tanto do site, quanto da lixeira.

Observações:

Microsoft SQL Server Management Studio 11.0.5058.0

Microsoft Analysis Services Client Tools 11.0.5058.0

Microsoft Data Access Components (MDAC) 6.3.9600.16384

Microsoft MSXML 3.0 6.0

Microsoft Internet Explorer 9.11.9600.18036

Microsoft .NET Framework 4.0.30319.34014

Operating System 6.3.9600

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,607 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,664 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 21,371 Reputation points Microsoft Vendor
    2023-02-07T10:17:46.28+00:00

    Hi @Danilo Almeida Silva ,

    First of all, the forum currently provides English support, please post questions in English.

    For your question, I performed a simple mechanical translation and the results are as follows:

    02071

    What version of SharePoint are you using?

    According to my research, this can happen for two reasons:

    This issue appears from SQL, please do the following:

    1. Please confirm there is enough space on the SQL Server .If not then extend the DB space and check.
    2. Please confirm if there had been changes to the SQL that is Binding etc.
    3. Please check if there had been any changes to the user role on the SQL DB.
    4. Please request the event logs and core logs for the same.

    The item-level permissions in lists referred to in lookup columns in other lists.

    If the list referred to in the lookup column has its item-level permissions set to “Read items that were created by the user”…and one of the items in the list has unique permissions…

    Then the error message will appear in the list with the corresponding lookup column. In the SharePoint ULS log you may see the following error, followed by a massive SQL command:

    System.Data.SqlClient.SqlException (0x80131904): Invalid column name ‘tp_Author’.

    If this error occurs, you should check the item-level permissions in the advanced list settings and also for the item itself.

    For more information, please refer to:

    https://social.technet.microsoft.com/wiki/contents/articles/37416.sharepoint-20132010-troubleshooting-exception-hresult-0x80131904.aspx

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Jaine Adriana Silva 0 Reputation points
    2023-03-15T07:57:03.6366667+00:00

    Olá, você pode está alterando o tipo da sua coluna, algum dado engasgado, que foi incluído, um tipo de dados incorreto, você deverá saber as alterações recente que efetuou.

    Exemplo: Um numero, que foi informado como texto. Mude o tipo da sua coluna para numero.

    Enfrentei esse problema e é essa a resolução.

    0 comments