Error cargas rdls reporting services - hexadecimal 0x00

Juan Esteban Berrio 1 Reputation point

Actualmente tengo un error en carga automáticas de .rdl a un caperta en repositorio de reporting services.
Tengo varios rdl, los cuales debo cargar al reporting services, en su portal web.


> Blockquote

'Script Starting Point
' Script to deploy report to report server

DIM definition As Byte = Nothing
DIM warnings As Warning() = Nothing

Public Sub Main()

' Variable Declaration
Dim TextLine As String = ""
Dim LocalDir As String = ""
Dim ServerDir As String = ""
Dim definition As Byte = Nothing
'Dim warnings As Warning() = Nothing

' Lectura del archivo de texto de configuración y asignación de valores a variables
If System.IO.File.Exists(FILE_NAME) = True Then
Dim objReader As New System.IO.StreamReader(FILE_NAME)
Do While objReader.Peek() <> -1
TextLine = objReader.ReadLine()
Dim parts As String() = TextLine.Split(New Char() {","c})
'TextLine & objReader.ReadLine() '& vbNewLine
LocalDir = parts(0)
ServerDir = parts(1)

            Dim path As String = LocalDir  
            Dim fileEntries As String() = Directory.GetFiles(path)  
            Dim fileFullPath As String = &#34;&#34;  
            For Each fileFullPath In fileEntries  

                    Dim stream As FileStream = File.OpenRead(fileFullPath)  
                    Dim NameWithExt As String = fileFullPath.Replace(path, &#34;&#34;)  
                    Dim NameOnly As String = NameWithExt.Replace(&#34;.rdl&#34;, &#34;&#34;)  
                    definition = New [Byte](stream.Length) {}  
                    stream.Read(definition, 0, CInt(stream.Length))  

  warnings = rs.CreateReport(NameOnly, ServerDir, True, definition, Nothing)  

  If Not (warnings Is Nothing) Then  
   DIM warning As Warning  
   For Each warning In warnings  
   Next warning  
   Console.WriteLine(&#34;Report: {0} CARGADO CORRECTAMENTE!&#34;, NameOnly)  
  End If  

 Catch e As IOException  
 End Try  
Next fileFullPath  


        Dim MsgBox as String = &#34;El archivo no existe o la ruta esta mal configurada en los archivos de configuracion&#34;  

    End If  

End Sub

'End of the Script

tengo un archivo de texto donde coloco las rutas de donde estan los rdl en mi equipo y la carpeta donde los deseo almacenar en el web services.



creo la carpeta en el portal


Donde la primera ruta corresponde al lugar en mi equipo y la segunda a donde lo deseo guardar en portal web.
Utilizo un .bat para invocar el rs.exe del reporting services, la rutina arriba indicada, y el archivo de configuracion.
Con la siguiente instrucción:
"C:\Program Files\Microsoft SQL Server Reporting Services\Shared Tools\RS.exe" -i C:\Report\Upload_Multiple_RDL_files.rss -s "http://equipoX/ReportServer" -v FILE_NAME="C:\Report\ConfigurationFile.txt"



Todo funciona bien si es reporting services 2016 o superior, pero en 2008, 2012 y 2014 me genera el siguiente error.


Unhandled exception:
The report definition is not valid or supported by this version of Reporting Ser
vices. This could be the result of publishing a report definition of a later ver
sion of Reporting Services, or that the report definition contains XML that is n
ot well-formed or the XML is not valid based on the Report Definition schema. De
tails: '.', hexadecimal value 0x00, is an invalid character. Line 1239, position

He esta investigando y no logro dar con la solución, me pueden por favor ayudar, para poder hacerlo compatible con versiones inferiores a 2016 de reporting services, ya que debo cargar mas de 100 .rdl en varios reportings y es muy tedioso, ya que no ofrece la opcion de cargar varios sino de uno en uno.

Mil gracias.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
27,074 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Dave Patrick 352.9K Reputation points MVP

    SSRS is not currently supported here on QnA. I'd try asking for help in dedicated forums here.

    --please don't forget to Accept as answer if the reply is helpful--

    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    0 comments No comments

  2. Leon Laude 85,221 Reputation points


    Q&A currently supports the products listed over here (more to be added later on).

    You can reach the experts in the dedicated SQL Server Reporting Services forum over here:

    (Please don't forget to accept helpful replies as answer)

    Best regards,

    0 comments No comments