a) how do I know which version of SSRS designer I have? how do I know
which version is current?
b) anyone know what this means:
c:\documents and settings\administrator\my documents\visual studio
projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
\takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
Deserialization failed: The element 'http://schemas.microsoft.com/
sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
(571, 23).On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
wrote:
> a) how do I know which version of SSRS designer I have? how do I know
> which version is current?
> b) anyone know what this means:
> c:\documents and settings\administrator\my documents\visual studio
> projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> Deserialization failed: The element 'http://schemas.microsoft.com/
> sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> (571, 23).
In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
Studio' to get the version number, service pack, etc. Don't quote me
on this, but I believe that the latest version is 9.0.3042.
This thread may offer some insight into your error:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/232cb81b9f1f1328/5bb841311ab856ac?lnk=st&q=The+element+%27http%3A%2F%2Fschemas.microsoft.com%2Fsqlserver%2Freporting%2F2003+has+invalid+child+element&rnum=1#5bb841311ab856ac
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I meant for SQL 2000 on the version thing
I've got 8.0.0.760 on the visual studio side.. or something around 700
I assume that this is not SP2 for SSRS 2000?
On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> wrote:
> > a) how do I know which version of SSRS designer I have? how do I know
> > which version is current?
> > b) anyone know what this means:
> > c:\documents and settings\administrator\my documents\visual studio
> > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > Deserialization failed: The element 'http://schemas.microsoft.com/
> > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > (571, 23).
> In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> Studio' to get the version number, service pack, etc. Don't quote me
> on this, but I believe that the latest version is 9.0.3042.
> This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Apr 4, 11:45 am, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
wrote:
> I meant for SQL 2000 on the version thing
> I've got 8.0.0.760 on the visual studio side.. or something around 700
> I assume that this is not SP2 for SSRS 2000?
> On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> > On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> > wrote:
> > > a) how do I know which version of SSRS designer I have? how do I know
> > > which version is current?
> > > b) anyone know what this means:
> > > c:\documents and settings\administrator\my documents\visual studio
> > > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > > Deserialization failed: The element 'http://schemas.microsoft.com/
> > > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > > (571, 23).
> > In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> > Studio' to get the version number, service pack, etc. Don't quote me
> > on this, but I believe that the latest version is 9.0.3042.
> > This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You should be using either SP3 or SP3a, according to your version.
This link should be useful:
http://support.microsoft.com/kb/321185
Regards,
Enrique Martinez
Sr. Software Consultant|||yeah.. but that is the SP for the database-- not for the reporting
services side
I'll find it soon I guess
thanks
On Apr 4, 11:07 am, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Apr 4, 11:45 am, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> wrote:
>
>
> > I meant for SQL 2000 on the version thing
> > I've got 8.0.0.760 on the visual studio side.. or something around 700
> > I assume that this is not SP2 for SSRS 2000?
> > On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> > > On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> > > wrote:
> > > > a) how do I know which version of SSRS designer I have? how do I know
> > > > which version is current?
> > > > b) anyone know what this means:
> > > > c:\documents and settings\administrator\my documents\visual studio
> > > > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > > > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > > > Deserialization failed: The element 'http://schemas.microsoft.com/
> > > > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > > > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > > > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > > > (571, 23).
> > > In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> > > Studio' to get the version number, service pack, etc. Don't quote me
> > > on this, but I believe that the latest version is 9.0.3042.
> > > This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> > > Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
> You should be using either SP3 or SP3a, according to your version.
> This link should be useful:http://support.microsoft.com/kb/321185
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Showing posts with label child. Show all posts
Showing posts with label child. Show all posts
Thursday, March 29, 2012
Deserialization Failed: Parent Columns and Child Columns don't have type-matching columns.
After about an hour and a half of validation, my Analysis Services database has been migrated from 2000 to Analysis Services 2005.
I am now receiving the error in the subject any time I try and access the Data Source View that was created. All dimensions and cubes cannot be processed.
I have tried editing the xml manually to no avail.
Any ideas would be much appreciated!
Would still like to know what the issue is, but I found a workaround in the meantime.
I manually edited the .dsv file, renamed the ids, and restarted OLAP. I then opened the project in Business Intelligence Studio, and manually created the DSV. After a couple of renames of calculated columns the project seems to build properly.
|||I have exactly the same problem (Migration : all OK but I can not open the dsv properties )I don't understand your resolution.
The migration generated a file .dsv.xml
What "Id" did you rename ?
I tried to rename the data source view ID but still cannot open
I cannot open the databases through Visual Studio. Same error message.
Deserialization Failed: Parent Columns and Child Columns don't have type-matching columns.
After about an hour and a half of validation, my Analysis Services database has been migrated from 2000 to Analysis Services 2005.
I am now receiving the error in the subject any time I try and access the Data Source View that was created. All dimensions and cubes cannot be processed.
I have tried editing the xml manually to no avail.
Any ideas would be much appreciated!
Would still like to know what the issue is, but I found a workaround in the meantime.
I manually edited the .dsv file, renamed the ids, and restarted OLAP. I then opened the project in Business Intelligence Studio, and manually created the DSV. After a couple of renames of calculated columns the project seems to build properly.
|||I have exactly the same problem (Migration : all OK but I can not open the dsv properties )I don't understand your resolution.
The migration generated a file .dsv.xml
What "Id" did you rename ?
I tried to rename the data source view ID but still cannot open
I cannot open the databases through Visual Studio. Same error message.
Friday, February 17, 2012
Dependent Records
I want to delete a parent record.
Is there a simple call I could make that would tell me if there are dependent child records, without me having to hard code in all the child tables and manually calling each child table one at a time.
A .net framework call that that returned a Yes/No to a "Are there any dependent records?" sort of query, or better still if it told me the table the dependent record is in.
I would then know if I could delete the record.
I have referential integrity turned on and am using a Access 2000 .mdb, but will soon be upsizeing to SQL Server Express (the MSDE thingy).
I realise I could use the sledge hammer technique and let the Referential Integrity stop me, but a more polite approach would be better, and I am not sure if you can have Referential Integrity in SQL Express like you do in Access.
Warm regards
NeilReferential integrity in SQL Server Express is pretty much the same as Access, although you'll have more methods available for creating and maintaining the constraints (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_04_9183.asp).
If you want to delete all child records associated with a parent record, you can use cascading deletes (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_04_92ib.asp). This is not a good idea as a rule though, since most times you'll want the application to throw an exception if a parent record is deleted before the child records. In a typical application, you'd delete the child records first, then delete the parent record(s).
If this is a UI, I always like it when developers catch the RI exception if a user attempts to delete a parent, then displays a message such as "there are other records associated with the row you want to delete, all associated data will be deleted, are you sure this is OK?".
Hope this helps,
Josh Lindenmuth
Subscribe to:
Comments (Atom)