Wednesday, March 28, 2012

Problems with SQLH2

Hi friends!
I have installed SQLH2 reporting and collector services and all of them work
fine. I configured IIS WIth Reporting services with SP2 and uploaded the
reports pages, the connection to the database seems to be well, but when i
try to see some data (not happens with all reports) a recieve errors like
this:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'CS'. (rsErrorExecutingCommand) Get
Online Help
Invalid object name 'd_DomainRole'. Invalid object name 'd_DomainRole'.
OR:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'Traces'. (rsErrorExecutingCommand) Get
Online Help
Invalid object name 'd_TraceProperty'.
What'is wrong?
Can anyone help me?
Thanks in advance.
MartinMartin
The errors you see mean your reports connect to the wrong database.
Check your datasource and make sure your reports are using correct
datasource.
You can download 'Additional doc.cab' from
2347b8b5f89&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/...&DisplayLang=en
You can find 'ComprehensiveSQLH2InstallDoc.doc' in the cab. It has a big
section on configuring reports.
"Tinchos" wrote:

> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'CS'. (rsErrorExecutingCommand) Get
> Online Help
> Invalid object name 'd_DomainRole'. Invalid object name 'd_DomainRole'.
> OR:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'Traces'. (rsErrorExecutingCommand) Ge
t
> Online Help
> Invalid object name 'd_TraceProperty'.
>|||Hi,
I have same problem.
'd_DomainRole' is missing in SQLH2Repository database, and in SQLH2setup.sql
script.
'd_DbObjectType', 'd_UserAcces' also.
Most of reports from ReportsV2 are missing some object or procedure.
Scripts and programs are downloaded today.
Thanks,
Don
"Tinchos" wrote:

> Hi friends!
> I have installed SQLH2 reporting and collector services and all of them wo
rk
> fine. I configured IIS WIth Reporting services with SP2 and uploaded the
> reports pages, the connection to the database seems to be well, but when i
> try to see some data (not happens with all reports) a recieve errors like
> this:
>
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'CS'. (rsErrorExecutingCommand) Get
> Online Help
> Invalid object name 'd_DomainRole'. Invalid object name 'd_DomainRole'.
> OR:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'Traces'. (rsErrorExecutingCommand) Ge
t
> Online Help
> Invalid object name 'd_TraceProperty'.
>
> What'is wrong?
> Can anyone help me?
>
> Thanks in advance.
> Martin
>|||Sorry I missed that the first time
Reports package (ReportV2.cab) contains 'New Dictionaries.sql' script, which
creates objects you mention.
"Don" wrote:

> I have same problem.
> 'd_DomainRole' is missing in SQLH2Repository database, and in SQLH2setup.s
ql
> script.
> 'd_DbObjectType', 'd_UserAcces' also.
> Most of reports from ReportsV2 are missing some object or procedure.
> Scripts and programs are downloaded today.

No comments:

Post a Comment