Error=cantconvertdata

Hi everyone!

When I try to process a cube via DTS or in a Terminal Server window I get the following error message:

DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2147221386 (80040076)
Error string: RECORD=1, _ERROR=CANTCONVERTDATA, COLUMN=30..

The cube runs on:
Win 2000 Advanced SP1 - MS SQL 2000 SP 1

We have found that it works when we keep a user with Admin privileges logged on locally on the server.
Well, it is the solution of the problem but it seems to be a bug anyway.

Has anyone got the same problem or maybe solved the problem another way?

Thanks for your replies

Jacek
:confused:Hello, Can you tell me please how I can solve this problem?? Because I have the same problem. THanks.
Yolanda

Hi everyone!

When I try to process a cube via DTS or in a Terminal Server window I get the following error message:

DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2147221386 (80040076)
Error string: RECORD=1, _ERROR=CANTCONVERTDATA, COLUMN=30..

The cube runs on:
Win 2000 Advanced SP1 - MS SQL 2000 SP 1

We have found that it works when we keep a user with Admin privileges logged on locally on the server.
Well, it is the solution of the problem but it seems to be a bug anyway.

Has anyone got the same problem or maybe solved the problem another way?

Thanks for your replies

Jacek
:confused:

Error: Subreport could not be shown.

I have to print 4 forms one form per page from a datatable generated by
a single query, since on the design window I can see only one page, my
initial solution was to create 4 reports, and they work fine, but the
end user needs to see the 4 forms at once to send it to a pdf.
Now, I created a new report and add the 4 reports as a subreports, but
I am getting the message "Error: Subreport could not be shown. "
I will apreciate any help.
Thank you
GustavoHi,
Just check the right report you have selected from the drop down for sub
reportand most importantly all the parameters are selected propely. I doubt
it should be some missing parameters.
Amarnath.
"gvt99@.hotmail.com" wrote:
> I have to print 4 forms one form per page from a datatable generated by
> a single query, since on the design window I can see only one page, my
> initial solution was to create 4 reports, and they work fine, but the
> end user needs to see the 4 forms at once to send it to a pdf.
> Now, I created a new report and add the 4 reports as a subreports, but
> I am getting the message "Error: Subreport could not be shown. "
> I will apreciate any help.
> Thank you
> Gustavo
>|||Gustavo,
You are probably missing some parameters. You must supply the
subreports with parameters from the Master report.
Also, Amarnath, dont forget that if the report has temp tables, it will
not automatically fill those parameters.
regards,
Stas K.