error [BC30494] Line is too long

Hi,
I have a problem with a report in SSRS 2005. I tried to add some custom code to a report.
The code is absolutely simple and correct.
But when trying to show the report the debugger shows the following error message:
error [BC30494] Line is too long.

When I remove the code the report works again.

The code is about 12 words and could not be the problem.

Could anyone help please?

Best regards,
Stefoon

Can you post the code so everyone might have a better idea as to what you are seeing?

Jarret

|||

This is the text in the Code Section of the report.

It it doing nothing spectacular, only deviding Numerator by Denominator by avoiding a divide by 0 in the first section.

Function Divide(Numerator as Double, Denominator as Double)
If Denominator = 0 Then
Return Nothing
Else
Return Numerator/Denominator*100
End If
End Function

Best regards,

Stefoon

|||

I don't see anything wrong with it and it worked fine for me in a test report. Are there any other custom functions in your Code window?

What is the expression you are using to call the function?

Jarret

|||

Hi,

I use

= code.Divide((sum(Fields!Measures_1.Value)),(sum(Fields!Measures_2.Value)))

in the fields of a table. The measures are from the recordset.

Best regards,

Stefoon

error [BC30494] Line is too long

Hi,
I have a problem with a report in SSRS 2005. I tried to add some custom code
to a report.
The code is absolutely simple and correct.
But when trying to show the report the debugger shows the following error
message:
error [BC30494] Line is too long.
When I remove the code the report works again.
The code is about 12 words and could not be the problem.
Could anyone help please?
Best regards,
StefoonOn Jul 25, 6:54 am, Stefoon23 <Stefoo...@.discussions.microsoft.com>
wrote:
> Hi,
> I have a problem with a report in SSRS 2005. I tried to add some custom code
> to a report.
> The code is absolutely simple and correct.
> But when trying to show the report the debugger shows the following error
> message:
> error [BC30494] Line is too long.
> When I remove the code the report works again.
> The code is about 12 words and could not be the problem.
> Could anyone help please?
> Best regards,
> Stefoon
Maybe you could post the code?|||The code is trivial and has nothing to do with the problem. Thus I did not
post it.
Function Divide(Numerator as Double, Denominator as Double)
If Denominator = 0 Then
Return Nothing
Else
Return Numerator/Denominator*100
End If
End Function
I use it in a table with values from a dataset:
code.Divide((sum(Fields!Measures1.Value)),(sum(Fields!Measures2.Value)))
I was told that the problem could be that a request could only be 4 MBytes
big in asp. The report's rdl file is only about 3 MB big. I changed the size
of maxRequestLength in machine.config to 20000 instead of 4000 Bytes, but it
did not help.
When I remove these 7 lines of code the reports works without problems. But
I want to centralize this function.
Best regards,
Stefan
"toolman" wrote:
> On Jul 25, 6:54 am, Stefoon23 <Stefoo...@.discussions.microsoft.com>
> wrote:
> > Hi,
> > I have a problem with a report in SSRS 2005. I tried to add some custom code
> > to a report.
> > The code is absolutely simple and correct.
> > But when trying to show the report the debugger shows the following error
> > message:
> > error [BC30494] Line is too long.
> >
> > When I remove the code the report works again.
> >
> > The code is about 12 words and could not be the problem.
> >
> > Could anyone help please?
> >
> > Best regards,
> > Stefoon
> Maybe you could post the code?
>

Error "Logon failed" - SSRS Service user account rights

I am facing a problem which is based on the restrictions on the domain of the customer. After deplyoing the report on the server we are getting the following error message in the report manager after executing (clicking) a report link:

Logon failed.

Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)

I googled for that and it seems to be an authentication issue where some user / account is not granted to log on as service / locally, but the problems is better described than the solutions. Did anyone faced that problem so far ? Which account has to be granted what priviledges or permissions in Windows. We are using a SQL Server 2005 / Reporting Services 2005 running on the same machine whereas the virtual directories Reports and Reportserver are running in a separate Application Pool

Thanks,

Thomas

I 've exactly the same issue.

I thought that it's a delegation problem, because we work on different machines for SSRS and SSAS.

But it really looks like having a problem with the windows authenitcation on the SSAS server.

Error "Logon failed" - SSRS Service user account rights

I am facing a problem which is based on the restrictions on the domain of the customer. After deplyoing the report on the server we are getting the following error message in the report manager after executing (clicking) a report link:

Logon failed.

Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)

I googled for that and it seems to be an authentication issue where some user / account is not granted to log on as service / locally, but the problems is better described than the solutions. Did anyone faced that problem so far ? Which account has to be granted what priviledges or permissions in Windows. We are using a SQL Server 2005 / Reporting Services 2005 running on the same machine whereas the virtual directories Reports and Reportserver are running in a separate Application Pool

Thanks,

Thomas

I 've exactly the same issue.

I thought that it's a delegation problem, because we work on different machines for SSRS and SSAS.

But it really looks like having a problem with the windows authenitcation on the SSAS server.

Error - The report server cannot decrypt the symmetric key?

SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

Why does this error cropped and how can i fix it? I am using SQL Server 2000.

Thanks

It cropped because VS.NET 2005 did aspnet_regiis.exe. Assuming that you have backed up your encryption key (you did right?), you can use the Reporting Services Configuration utility to restore it. If no backup, do:

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\RsKeyMgmt.exe" -d

Then, go to the Report Manager and reset the connection string in all data sources.

|||if the above command is executed, it seems like it will delete all the reporting data also.
is that correct?|||Incorrect. Only the ecrypted information will be nuked, i.e. connection credentials, connection strings, and any secure information stored in subscriptions – by default this is only username & password in File Share delivery extension.|||So the actual data is never encrypted in the Reporting Services db? Then in case I never made a backup of the encryption keys, and I have to delete it now, I wouldn't be losing any data; just
connection strings etc. Where do I go about changing these connection strings? Again a newbie question for you, what is the File Share delivery extension?

Thanks|||Excluding snapshots, the actual data is not stored in the report catalog. Yes, you will loose only the data source credentials. You can go to the Report Manager to change them. FSE is about delivering subsribed reports (users can subscribe to reports believe it or not) to a network file share.

Error - The report server cannot decrypt the symmetric key?

SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

Why does this error cropped and how can i fix it? I am using SQL Server 2000.

Thanks

It cropped because VS.NET 2005 did aspnet_regiis.exe. Assuming that you have backed up your encryption key (you did right?), you can use the Reporting Services Configuration utility to restore it. If no backup, do:

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\RsKeyMgmt.exe" -d

Then, go to the Report Manager and reset the connection string in all data sources.

|||if the above command is executed, it seems like it will delete all the reporting data also.
is that correct?

|||Incorrect. Only the ecrypted information will be nuked, i.e. connection credentials, connection strings, and any secure information stored in subscriptions – by default this is only username & password in File Share delivery extension.|||So the actual data is never encrypted in the Reporting Services db? Then in case I never made a backup of the encryption keys, and I have to delete it now, I wouldn't be losing any data; just
connection strings etc. Where do I go about changing these connection strings? Again a newbie question for you, what is the File Share delivery extension?

Thanks
|||Excluding snapshots, the actual data is not stored in the report catalog. Yes, you will loose only the data source credentials. You can go to the Report Manager to change them. FSE is about delivering subsribed reports (users can subscribe to reports believe it or not) to a network file share.

Error - Attempted to read or write protected memory

Hi,

I am back with one more problem..

I have created few reports using SSRS 2005. I am using Oracle database in Data Source to fetch my data. It is working fine and showing me report correctly. But after running the report 8 to 10 times, it starts giving me Memory error. To get rid of that, I need to recycle (stop-start) ReportingService from IIS.

I am exactly getting following error...

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

I am not getting the actual problem, why is it giving memory error only after running few times? Please let me know if anyone facing same problem or knowing the solution for the problem.

Thanks,

HMaheta

Dear HMaheta,

Check the DTC (Distributed Transaction Coordinator) service. It should be set up to to start automatically.

HTH,

Suprotim Agarwal

|||

Hi Suprotim,

Thanks for your reply.

I checked for the DTC. It is running on the server and also marked for auto start up.

Is there any other thing, which I am missing?

Thanks,

HMaheta