Program Connection: error

Showing posts with label error. Show all posts

Wednesday, March 28, 2012

Property page giving error

Hi ,
I just deployed a report on a report Server from my Dev m/c...
The Report is running fine except the Property page for the Rpeort shows
the following error
"Unable to generate a temporary class (result=1). error CS1514: { expected
error CS1001: Identifier expected error CS1031: Type expected error CS1519:
Invalid token '{' in class, struct, or interface member declaration error
CS1514: { expected error CS1001: Identifier expected error CS1031: Type
expected error CS1519: Invalid token '{' in class, struct, or interface
member declaration "
I am Using MS RS version 8.00.743.00, My Resporting server is Win 2000 and
My Dev mc is Win XP.
BTW just found a bug with this version of the MSRS as the name of the rdl
file should not contain "Attachment" Key word else the Report can be deployed
but cant be viewed.
any Idea on above issue will be highly aprreciated.
siajDoes this happens to that particular report only?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"siaj" <siaj@.discussions.microsoft.com> wrote in message
news:069A7DCF-3388-40B6-A2E0-51219071C613@.microsoft.com...
> Hi ,
> I just deployed a report on a report Server from my Dev m/c...
> The Report is running fine except the Property page for the Rpeort shows
> the following error
> "Unable to generate a temporary class (result=1). error CS1514: { expected
> error CS1001: Identifier expected error CS1031: Type expected error
> CS1519:
> Invalid token '{' in class, struct, or interface member declaration error
> CS1514: { expected error CS1001: Identifier expected error CS1031: Type
> expected error CS1519: Invalid token '{' in class, struct, or interface
> member declaration "
> I am Using MS RS version 8.00.743.00, My Resporting server is Win 2000 and
> My Dev mc is Win XP.
> BTW just found a bug with this version of the MSRS as the name of the rdl
> file should not contain "Attachment" Key word else the Report can be
> deployed
> but cant be viewed.
> any Idea on above issue will be highly aprreciated.
> siaj
>
>|||No it happens to all the Reports I deploy......
any suggestions will be highly appreciated..
siaj...
"Lev Semenets [MSFT]" wrote:
> Does this happens to that particular report only?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "siaj" <siaj@.discussions.microsoft.com> wrote in message
> news:069A7DCF-3388-40B6-A2E0-51219071C613@.microsoft.com...
> > Hi ,
> > I just deployed a report on a report Server from my Dev m/c...
> >
> > The Report is running fine except the Property page for the Rpeort shows
> > the following error
> > "Unable to generate a temporary class (result=1). error CS1514: { expected
> > error CS1001: Identifier expected error CS1031: Type expected error
> > CS1519:
> > Invalid token '{' in class, struct, or interface member declaration error
> > CS1514: { expected error CS1001: Identifier expected error CS1031: Type
> > expected error CS1519: Invalid token '{' in class, struct, or interface
> > member declaration "
> >
> > I am Using MS RS version 8.00.743.00, My Resporting server is Win 2000 and
> > My Dev mc is Win XP.
> >
> > BTW just found a bug with this version of the MSRS as the name of the rdl
> > file should not contain "Attachment" Key word else the Report can be
> > deployed
> > but cant be viewed.
> >
> > any Idea on above issue will be highly aprreciated.
> >
> > siaj
> >
> >
> >
> >
>
>|||Please check this related posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=41317637-24ab-414b-a650-6d1bb7e55085&sloc=en-us
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"siaj" <siaj@.discussions.microsoft.com> wrote in message
news:38566414-72A9-4F5F-881D-290172AECBDC@.microsoft.com...
> No it happens to all the Reports I deploy......
> any suggestions will be highly appreciated..
> siaj...
>
> "Lev Semenets [MSFT]" wrote:
>> Does this happens to that particular report only?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "siaj" <siaj@.discussions.microsoft.com> wrote in message
>> news:069A7DCF-3388-40B6-A2E0-51219071C613@.microsoft.com...
>> > Hi ,
>> > I just deployed a report on a report Server from my Dev m/c...
>> >
>> > The Report is running fine except the Property page for the Rpeort
>> > shows
>> > the following error
>> > "Unable to generate a temporary class (result=1). error CS1514: {
>> > expected
>> > error CS1001: Identifier expected error CS1031: Type expected error
>> > CS1519:
>> > Invalid token '{' in class, struct, or interface member declaration
>> > error
>> > CS1514: { expected error CS1001: Identifier expected error CS1031: Type
>> > expected error CS1519: Invalid token '{' in class, struct, or interface
>> > member declaration "
>> >
>> > I am Using MS RS version 8.00.743.00, My Resporting server is Win 2000
>> > and
>> > My Dev mc is Win XP.
>> >
>> > BTW just found a bug with this version of the MSRS as the name of the
>> > rdl
>> > file should not contain "Attachment" Key word else the Report can be
>> > deployed
>> > but cant be viewed.
>> >
>> > any Idea on above issue will be highly aprreciated.
>> >
>> > siaj
>> >
>> >
>> >
>> >
>>

Property Owner is not available for Database '[DTA_TaxMan]'. This property may not exist

I get the following error everytime I try to go to the properties of
one of my databases.
The help link was useless.
I am not sure what to do. I am the top level administrator to my
server.
===================================
Cannot show requested dialog.
===================================
Cannot show requested dialog. (SqlMgmt)
Program Location:
at
Microsoft.SqlServer.Management.SqlMgmt.DefaultLaun chFormHostedControlAllocator.AllocateDialog(XmlDoc ument
initializationXml, IServiceProvider dialogServiceProvider,
CDataContainer dc)
at
Microsoft.SqlServer.Management.SqlMgmt.DefaultLaun chFormHostedControlAllocator.Microsoft.SqlServer.M anagement.SqlMgmt.ILaunchFormHostedControlAllocato r.CreateDialog(XmlDocument
initializationXml, IServiceProvider dialogServiceProvider)
at
Microsoft.SqlServer.Management.SqlMgmt.LaunchForm. InitializeForm(XmlDocument
doc, IServiceProvider provider, ISqlControlCollection control)
at
Microsoft.SqlServer.Management.SqlMgmt.LaunchForm. .ctor(XmlDocument
doc, IServiceProvider provider)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ToolsMenuItem.OnCreateAndShowForm(ISe rviceProvider
sp, XmlDocument doc)
at
Microsoft.SqlServer.Management.SqlMgmt.RunningForm sTable.RunningFormsTableImpl.ThreadStarter.StartTh read()
===================================
Property Owner is not available for Database '[DTA_TaxMan]'. This
property may not exist for this object, or may not be retrievable due
to insufficient access rights. (Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.PropertyCannotBeRetrievedExcept ionText&EvtID=Owner&LinkId=20476[/url]
Program Location:
at
Microsoft.SqlServer.Management.Smo.PropertyCollect ion.HandleNullValue(Int32
index)
at Microsoft.SqlServer.Management.Smo.Database.get_Ow ner()
at
Microsoft.SqlServer.Management.SqlManagerUI.Create DatabaseData.DatabasePrototype.DatabaseData..ctor( CDataContainer
context, String databaseName)
at
Microsoft.SqlServer.Management.SqlManagerUI.Create DatabaseData.DatabasePrototype.LoadDefinition(Stri ng
newName)
at
Microsoft.SqlServer.Management.SqlManagerUI.Create DatabaseData.DatabasePrototype..ctor(CDataContaine r
context)
at
Microsoft.SqlServer.Management.SqlManagerUI.DBProp Sheet..ctor(CDataContainer
context)
I have also signed back in with SA, and still having the same problem.
sql

Property Owner is not available for Database '[DTA_TaxMan]'. This property may not exist

I get the following error everytime I try to go to the properties of
one of my databases.
The help link was useless.
I am not sure what to do. I am the top level administrator to my
server.
===================================
Cannot show requested dialog.
===================================
Cannot show requested dialog. (SqlMgmt)
--
Program Location:
at
Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument
initializationXml, IServiceProvider dialogServiceProvider,
CDataContainer dc)
at
Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument
initializationXml, IServiceProvider dialogServiceProvider)
at
Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument
doc, IServiceProvider provider, ISqlControlCollection control)
at
Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument
doc, IServiceProvider provider)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider
sp, XmlDocument doc)
at
Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
===================================
Property Owner is not available for Database '[DTA_TaxMan]'. This
property may not exist for this object, or may not be retrievable due
to insufficient access rights. (Microsoft.SqlServer.Smo)
--
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Owner&LinkId=20476
--
Program Location:
at
Microsoft.SqlServer.Management.Smo.PropertyCollection.HandleNullValue(Int32
index)
at Microsoft.SqlServer.Management.Smo.Database.get_Owner()
at
Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.DatabaseData..ctor(CDataContainer
context, String databaseName)
at
Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.LoadDefinition(String
newName)
at
Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype..ctor(CDataContainer
context)
at
Microsoft.SqlServer.Management.SqlManagerUI.DBPropSheet..ctor(CDataContainer
context)I have also signed back in with SA, and still having the same problem.

Property Owner is not available for Database

I am getting this error while selecting the properties of one database.

Property Owner is not available for Database '[TEST]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Suddently this error started coming ? why ?

Make sure that the database owner is/was not a user / principal which has been deleted in the meantime. Orphaned database owner can be fixed using the sp_changedbowner and assigning a new owner to the database.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thanks..

I am getting this error while executing this.Do you know how to see the current/previous owner in studio ?

USE [TEST]

EXEC sp_changedbowner 'dbo'

Error

Msg 15151, Level 16, State 1, Line 1

Cannot find the principal 'dbo', because it does not exist or you do not have permission.

|||

You will have to provide a server prinicpal like 'sa'

To get the current owners, you will have to use something like the following:

SELECT databases.NAME,server_Principals.NAME

FROM sys.[databases]

INNER JOIN sys.[server_principals]

[databases].owner_sid = [server_principals].sid

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

1) In this database all the tables/views owner is dbo.does that mean dbo should set as database owner ?

Your query is seleted only 7 databases Out of 15 databases . What is that mean ?

Can one database work with out principal login ? What is the default owner of non-system databases ?

Is there any code changes required if any database owner change ?

2) In studio , what is the difference between root--> security-->logins vs root>databases>TEST-->security--> users

Thanks

Julius

|||

That means that a macthing sid is not found int he server principals table, these database seem owner orphaned. Use a left join to find out which ones are not in there.

Databases can work without a principals owner but this should not be a normal state.

The default owner of newly created database is the server principal who created the database.

The are no code changes unless you use something like database ownership chaining.

2) The first path are the server principals (logins who have access to the server), the second path are the database principals (Server principals mapped to database principals) whoc have certain permissions on the database either through individual rights or group memebership.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Property IsLocked is not available

I'm running Vista Ultimate x64 and when I tried to connect to my 2005 database using SQL server authentication it gave me an error. When I went to the management studio to check on the login it said this:

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

Property IsLocked is not available for Login '[sa]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=IsLocked&LinkId=20476

BUTTONS:

Has anyone ever seen this before and know how to solve it?

What build is the server running, and what build is your workstation running?|||Product: Microsoft SQL Server Developer Edition (64-bit)
Operating System: Microsoft Windows NT 6.0 (6000)
Version: 9.00.3054.00

|||Anybody?

I know others are having this problem. I've seen it on a couple of message boards.
|||

I ran into the same issue today when I installed an instance of SQL 2005 using Windows Auth. mode. After the install I switched the server over to SQL and Windows Auth mode and ran into the 'sa' problem. I ran the following command and then could see the properties of 'sa' within mgmt studio.

alter login sa

with password = 'yourpwd' unlock,

check_policy = off,

check_expiration = off

|||Works great... Except now I still can't log in with the sa account that I just unlocked from any machine.

TITLE: Connect to Server

Cannot connect to ANGEL.

ADDITIONAL INFORMATION:

Cannot open user default database. Login failed.
Login failed for user 'sa'. (Microsoft SQL Server, Error: 4064)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476

BUTTONS:

|||You need to change the default database of the sa login. It should always be set to master to avoide this problem.

Property IsLocked is not available

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

Property IsLocked is not available for Login '[sa]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

BUTTONS:

Has anyone ever seen this before and know how to solve it?

|||Anybody?

I know others are having this problem. I've seen it on a couple of message boards.
|||

alterlogin sa

with password ='yourpwd' unlock,

check_policy =off,

check_expiration =off

|||Works great... Except now I still can't log in with the sa account that I just unlocked from any machine.

TITLE: Connect to Server

Cannot connect to ANGEL.

ADDITIONAL INFORMATION:

Cannot open user default database. Login failed.
Login failed for user 'sa'. (Microsoft SQL Server, Error: 4064)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476

BUTTONS:

|||You need to change the default database of the sa login. It should always be set to master to avoide this problem.sql

Friday, March 23, 2012

Prooblem inserting into a table

Hi! I am currently trying to insert some values into a table. I have a very strange problem. I get the error message that i am trying to insert a null value into one of my colums, the problem is that when I write the value to a label control before I runs the insert method on my SqlDataSource control the value is not NULL. If i push the insert button on my webpage once again everything is ok.

What am I doing wrong? Anyone seen this kind of problem before?

regards,

Lumsen

Hi,

You can use the SQL Profiler to see which sql statement runs on the database after you click the button. If the error message is an sql error then you can see the statement by using the profiler.

Eralper

|||Can't be sure without more details. It could depends on what data control you're using, if any, and posting your code may help people to get better idea.|||without more info, its hard to tell. One thing you can do is add a watch to that variable and see if it is NULL at the wrong time.|||

Thanks for trying to help me out!

Here is the code from my asp page:

<%@. Page Language="VB" AutoEventWireup="false" CodeFile="newassesment.aspx.vb" Inherits="newassesment" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
Add a new assesment 
 
<asp:Label ID="Label1" runat="server" Text="assesment id"></asp:Label>
<asp:TextBox ID="text_assesment_id" runat="server"></asp:TextBox> 
 
<asp:Label ID="Label2" runat="server" Text="primary language"></asp:Label>
<asp:DropDownList ID="prim_lang_DropDownList" runat="server" DataSourceID="SqlDataSource2"
DataTextField="language_id" DataValueField="language_id">
</asp:DropDownList>
 
 
<asp:Label ID="Label3" runat="server" Text="# of answer alternatives"></asp:Label>
<asp:TextBox ID="text_ans_alt" runat="server"></asp:TextBox> 
 
<asp:Label ID="Label4" runat="server" Text="Dont know allowed"></asp:Label>
<asp:CheckBox ID="checkBox_dont_know_allowed" runat="server" /> 
 
<asp:Label ID="Label5" runat="server" Text="Light level"></asp:Label>
<asp:CheckBox ID="checkBox_light_level" runat="server" /> 
 
<asp:Label ID="Label6" runat="server" Text="Medium level"></asp:Label>
<asp:CheckBox ID="checkBox_medium_level" runat="server" /> 
 
<asp:Label ID="Label7" runat="server" Text="Extensive level"></asp:Label>
<asp:CheckBox ID="checkBox_extensive_level" runat="server" /> 
 
<asp:Button ID="button_submit" runat="server" Text="Submit" />
<asp:Label ID="label_error" runat="server" ForeColor="Red"></asp:Label>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AssesmentConnectionString2 %>"
DeleteCommand="DELETE FROM [assesment_definition] WHERE [assesment_id] = @.assesment_id"
InsertCommand="INSERT INTO [assesment_definition] ([assesment_id], [primary_language_id], [number_of_answer_alternatives], [dont_know_answer_accepted], [light_level], [medium_level], [extensive_level]) VALUES (@.assesment_id, @.primary_language_id, @.number_of_answer_alternatives, @.dont_know_answer_accepted, @.light_level, @.medium_level, @.extensive_level)"
SelectCommand="SELECT * FROM [assesment_definition]" UpdateCommand="UPDATE [assesment_definition] SET [primary_language_id] = @.primary_language_id, [number_of_answer_alternatives] = @.number_of_answer_alternatives, [dont_know_answer_accepted] = @.dont_know_answer_accepted, [light_level] = @.light_level, [medium_level] = @.medium_level, [extensive_level] = @.extensive_level WHERE [assesment_id] = @.assesment_id">
<DeleteParameters>
<asp:Parameter Name="assesment_id" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="primary_language_id" Type="String" />
<asp:Parameter Name="number_of_answer_alternatives" Type="Int32" />
<asp:Parameter Name="dont_know_answer_accepted" Type="Boolean" />
<asp:Parameter Name="light_level" Type="Boolean" />
<asp:Parameter Name="medium_level" Type="Boolean" />
<asp:Parameter Name="extensive_level" Type="Boolean" />
<asp:Parameter Name="assesment_id" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:FormParameter FormField="text_assesment_id" Name="assesment_id" Type="String" />
<asp:FormParameter FormField="prim_lang_DropDownList" Name="primary_language_id"
Type="String" />
<asp:FormParameter FormField="text_ans_alt" Name="number_of_answer_alternatives"
Type="Int32" />
<asp:FormParameter FormField="text_dontknowallowed" Name="dont_know_answer_accepted"
Type="Boolean" DefaultValue="" />
<asp:FormParameter FormField="text_lightlevel" Name="light_level" Type="Boolean" DefaultValue="false" />
<asp:FormParameter FormField="text_mediumlevel" Name="medium_level" Type="Boolean" DefaultValue="false" />
<asp:FormParameter FormField="text_extensivelevel" Name="extensive_level" Type="Boolean" DefaultValue="false" />
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:AssesmentConnectionString2 %>"
SelectCommand="SELECT [language_id] FROM [language]"></asp:SqlDataSource>
 
 
 
<asp:TextBox ID="text_dontknowallowed" runat="server" CausesValidation="True"></asp:TextBox> 
<asp:TextBox ID="text_lightlevel" runat="server"></asp:TextBox> 
<asp:TextBox ID="text_mediumlevel" runat="server"></asp:TextBox> 
<asp:TextBox ID="text_extensivelevel" runat="server"></asp:TextBox> 
 
 
<asp:Label ID="testLabel" runat="server" ForeColor="Blue"></asp:Label></div>
</form>
</body>
</html>

And the code when the submit button is clicked:

Partial Class newassesment
Inherits System.Web.UI.Page

Protected Sub button_submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button_submit.Click

text_dontknowallowed.Text = checkBox_dont_know_allowed.Checked
text_lightlevel.Text = checkBox_light_level.Checked
text_mediumlevel.Text = checkBox_medium_level.Checked
text_extensivelevel.Text = checkBox_extensive_level.Checked

testLabel.Text = SqlDataSource1.InsertCommand()

Try

Dim recAff As String

recAff = SqlDataSource1.Insert()

label_error.Text = (recAff & " record inserted successfully!")

Catch SQLExp As System.Data.SqlClient.SqlException

label_error.Text = "An SQL Server Error Occurred: " & SQLExp.Message()

Catch except As Exception

label_error.Text = except.ToString()

End Try

End Sub

Protected Sub checkBox_dont_know_allowed_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles checkBox_dont_know_allowed.CheckedChanged

testLabel.Text = "HALLO"

End Sub
End Class

Do this help?

Thanks

Lumsen

|||

Why aren't you using one of the data controls (DetailsView or FormView) along with your SqlDataSource? They were meant to be used together. I suppose you could somehow make your code work properly, but it may prove difficult to get everything right. Also, FormView/DetailsView allow paging, edit, delete, insert to take place automatically and does data binding for you. By not using these controls, you're choosing to manually handle everything (sort of reinventing the wheel). Finally, I'm not sure if anyone will be willing to help you implement something so out of the ordinary.

So, my advice is for you to go with FormView control for Insert, Edit, Delete of your data. It'll make your project far easier.

|||You shouldn't be using formparameters to pull from ASP.NET controls to start. Either make them Parameters, and set them manually, or make them controlparameters to pull from an ASP.NET control, or change all your textboxes from ASP.NET controls to form controls "<INPUT TYPE=...>" and use formparameters.|||Thanks for guiding me! Works a lot better with the formview control!

Just one problem remains.. I want to make one of the fields in the formview a dropdownlist, where the items are selected from another table than the table associated with the formview. Is that possible?

Thanks!

Lumsen|||Using a DropDownList control within a FormView is possible. That topic has been covered many times before, so rather than describing the whole process again, try searching the forum for the keywords "formview dropdownlist".

Wednesday, March 21, 2012

Project Server 2003 Setup Error 25624

Has anyone seen this one before?
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that creates
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillB
Yes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:

>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have that
>working on a SQL 2005 server without error from a query analyzer that creates
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB
|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Ben

Project Server 2003 Setup Error 25624

Has anyone seen this one before?
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that creates
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillBYes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:
>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have that
>working on a SQL 2005 server without error from a query analyzer that creates
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Bensql

Project Server 2003 Setup Error 25624

Has anyone seen this one before?
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that create
s
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillBYes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:

>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have tha
t
>working on a SQL 2005 server without error from a query analyzer that creat
es
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Ben

project server

I installed SP4 of SQL SERVER 2000 and even so I don't get to install
project server. Somebody knows how I can solve that.. the error message says
that
I have to install the sp3 or superior of the sql server 2000.Based on your comments, I am not sure where you are getting stuck.
You need to install SQL first w/SP3a or SP4.
Then create users as per project server install guide
Then setup sharepoint, including creating a Top Level Site
Then setup Project Server
Then install the Project Server SQL hotfix - see project server website,
then Project Server SP2.
Hope this helps.

Tuesday, March 20, 2012

Project opening - XML Document Error (118, 17)

While openeing the solution file (.sln), I got the following error:
"There is an error in XML document (118, 17)."
I am trying to open a project of SQL Server 2000 - Reporting Services.
Don't know what had happened actually.Hi,
Have you edited or changed anything on the rdl file / sln file.?
Amarnath
"Rohit Jain" wrote:
> While openeing the solution file (.sln), I got the following error:
> "There is an error in XML document (118, 17)."
> I am trying to open a project of SQL Server 2000 - Reporting Services.
> Don't know what had happened actually.|||Thanks Amarnath,
Yeah I have found the solution. Actually the error was occurring due to a
change in .rptproj file, and by this change the file itself got corrupted.
Thanks for your response Amarnath.
But stll I have 1 query - where I can found that XML document for which the
error was displayed.
"Amarnath" wrote:
> Hi,
> Have you edited or changed anything on the rdl file / sln file.?
> Amarnath
> "Rohit Jain" wrote:
> > While openeing the solution file (.sln), I got the following error:
> >
> > "There is an error in XML document (118, 17)."
> >
> > I am trying to open a project of SQL Server 2000 - Reporting Services.
> >
> > Don't know what had happened actually.

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

===== Initiating cube build process =====
[8/21/2007 12:45 PM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[8/21/2007 12:45 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[8/21/2007 12:45 PM] Cube build initialization started
[8/21/2007 12:45 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[8/21/2007 12:45 PM] Cube build session started
[8/21/2007 12:45 PM] Analysis Services session started
[8/21/2007 12:45 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[8/21/2007 12:45 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

To get more information about the job failure, please go to Project Web Access. Select Personal Settings from the left menu. Then select My Queued Jobs.

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure" uid="159956a3-840b-84af-9b29-dccf8649c22c" QueueMessageBody="Setting UID=00007829-4392-84b3-b533-5a5a4977e3c9 ASServerName=sql2005 ASDBName=ProjectServer_Repository ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/21/2007 12:28:15 ToDate=08/21/2007 12:28:15 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server. 
 
Error: " />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="cd4cb275-d48f-4a1e-bf43-0a3ccccd629a" JobUID="b4c3228f-97c1-5c39-9606-d32bbc423198" ComputerName="PROJECT" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

I have the same issue and have also went through the Microsoft configuration, step-by-step “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service”. http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true

My error displays as:

===== Process Completed ============================================

[8/21/2007 11:01 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server MYSERVERNAME Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

This problem was killing us as well, we followed all of the Microsoft documentation and nothing worked till this morning. You have to set the DSO\RemoteLocksDirectory value on the analysis server to \\yourserver\MSOlapRepository$\ and it should go. We spent hours trying every which way going as far as giving everyone permission to everything. Once I set this it went all the way. The document that gave me the hint is the following:

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

Today I found the cause of the problem we were having. The account we were using for the SSP had limited privileges on the domain. I replaced the SSP account with an elevated account, re-tested the OLAP and the build was successful.

|||

Help! I've given my SSP account every permission under the sun. (domain admin, local domain admin, analysis services repository db_owner, sql server db admin. Can you specify a) how to check to see that it is indeed the SSP account that is failing to access the server and b) what are the elevated permissions to give this user to get the cube to build?

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

One difference I noticed was, when the OLAP build was failing, the account being used for SSP was a “Domain User” level account that I had added to the local administrators group on both the SQL and Applications servers. When I changed the SSP account, I changed it to a “Domain Admin” account. This user was not added to the local admins group on the servers, because the “Domain Admin” group was already a member of the administrators group on both servers since they are members of the domain.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Analysis Services session failed with the following error: Failed to delete the Olap database: EPM2007_2. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

Second time, it works fine (nothing changed in any settings, just re-build again)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

To get more information about the job failure, please go to Project Web Access. Select Personal Settings from the left menu. Then select My Queued Jobs.

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed troubleshooting.

My error displays as:

===== Process Completed ============================================

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

|||

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Second time, it works fine (nothing changed in any settings, just re-build again)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

To get more information about the job failure, please go to Project Web Access. Select Personal Settings from the left menu. Then select My Queued Jobs.

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed troubleshooting.

My error displays as:

===== Process Completed ============================================

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

|||

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Second time, it works fine (nothing changed in any settings, just re-build again)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

To get more information about the job failure, please go to Project Web Access. Select Personal Settings from the left menu. Then select My Queued Jobs.

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed troubleshooting.

My error displays as:

===== Process Completed ============================================

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

|||

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Second time, it works fine (nothing changed in any settings, just re-build again)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Have spent days on this. Followed install guides and troubleshooting thouroughly.

Here are the error messages I get when trying to build a cube.

THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE:

THE EMAILED ERROR:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was 0% complete.

To get more information about the job failure, please go to Project Web Access. Select Personal Settings from the left menu. Then select My Queued Jobs.

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed troubleshooting.

My error displays as:

===== Process Completed ============================================

Take a look at the link that I’ve included above. Maybe it will help you.

I’ll post the solution if I find it, please do the same.

|||

thanks, yeah I followed that page completly.

What other possible users aside from the SPPAdmin user could it possibly be trying to use. The project server and the sql server are on the same domain.

|||

http://msdn2.microsoft.com/en-us/library/ms403370.aspx

|||

The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods.

Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database

Option 2: Create the repository by creating a SQL Server 2005 database

It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two.

|||

Thanks so much!

|||

I’m not for sure what the specific permission or group membership was that allowed the SSP account to begin working. I can tell you what groups this user is a member of.

The account I’m using for the SSP is a member of our Organizational Unit (OU) administrator group and a member of our domain users group.

|||

Anyone to know how to solve this one:

To refresh the cube, I always get first time the following:

Second time, it works fine (nothing changed in any settings, just re-build again)

PROGRAMTICALLY ACCESS SQLDATASOURCE !

I am trying to acces an SQLDatasource in the code page, I have the following code but get the error as below, any one help please

The SQLDataSource returns 1 value named [ShippingRegion], I think that has somethjing to do with it ??!!

dsShippingRegion.Select(DataSourceSelectArguments.Empty)

Dim myReaderAs Data.IDataReader =CType(dsShippingRegion.Select(DataSourceSelectArguments.Empty), Data.IDataReader)
If myReader.ReadThen
If Convert.IsDBNull(myReader("ShippingRegion"))Then
Beep()
Else
Beep()
EndIf
EndIf

System.InvalidCastException was unhandled by user code
Message="Unable to cast object of type 'System.Data.DataView' to type 'System.Data.IDataReader'."
Source="App_Web_rd5quiy1"
StackTrace:
at admin_administer_shop_productaddnew.Page_Load(Object sender, EventArgs e) in E:\Web Development\WebSites\AJAX_sirs2hers\admin\administer_shop\productaddnew.aspx.vb:line 25
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

dsShippingRegion.Select(DataSourceSelectArguments.Empty)

In the SqlDataSource markup, set DataSourceMode="DataReader". If the DataSourceMode is DataSet (or is not set, since DataSet is the default), a DataView object is returned from Select, which is what you're seeing. If the DataSourceMode is DataReader, an IDataReader object is returned. Seehttp://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.select.aspx for more details.

Hope that helps.

Aaron

|||

Aaron

this is the code for adding a product, what and where would i place to retrieve the returned value from the SPROC, insert is marked at the bottom with HERE IS THE INSERT

Thanks for the help, changed datasourcemode as above

Steve

ProtectedSub Button1_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles Button1.Click

If Trim(FCKeditor1.Value) =""Then

Dim AlertMSG ="Please enter product description"

ShrekGlobal.GlobalFunctions.CreateMessageAlert(Me, AlertMSG,"strKey1")

ExitSub

EndIf

Dim UploadImageAsBoolean =True

dsProduct.InsertParameters.Clear()

Dim ShopIDAsNew ControlParameter("ShopID","hfShopID","Value")

dsProduct.InsertParameters.Add(ShopID)

Dim CategoryIDAsNew ControlParameter("CategoryID","ddlCategories","SelectedValue")

dsProduct.InsertParameters.Add(CategoryID)

Dim ModelNumberAsNew ControlParameter("ModelNumber","txtModelNumber","Text")

dsProduct.InsertParameters.Add(ModelNumber)

Dim ModelNameAsNew ControlParameter("ModelName","txtModelName","Text")

dsProduct.InsertParameters.Add(ModelName)

Dim UnitCostAsNew ControlParameter("UnitCost","txtUnitCost","Text")

dsProduct.InsertParameters.Add(UnitCost)

Dim StockAsNew ControlParameter("Stock","txtStock","Text")

dsProduct.InsertParameters.Add(Stock)

Dim ProductDescriptionAsNew ControlParameter("ProductDescription","FCKeditor1","Value")

dsProduct.InsertParameters.Add(ProductDescription)

Dim ImageFilenameAsString

If ddlMainImage.SelectedIndex = 0Then

ImageFilename =""

Else

ImageFilename =String.Format("{0}.jpg", ddlMainImage.SelectedValue)

EndIf

dsProduct.InsertParameters.Add("ProductImage", ImageFilename)Dim ShippingIDUK1AsNew ControlParameter("ShippingID1","ddlUKShipping1","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDUK1)

Dim ShippingAmountUK1AsNew ControlParameter("ShippingAmount1","txtUKShipping1","Text")

dsProduct.InsertParameters.Add(ShippingAmountUK1)

Dim ShippingIDUK2AsNew ControlParameter("ShippingID2","ddlUKShipping2","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDUK2)

Dim ShippingAmountUK2AsNew ControlParameter("ShippingAmount2","txtUKShipping2","Text")

dsProduct.InsertParameters.Add(ShippingAmountUK2)

Dim ShippingIDUK3AsNew ControlParameter("ShippingID3","ddlUKShipping3","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDUK3)

Dim ShippingAmountUK3AsNew ControlParameter("ShippingAmount3","txtUKShipping3","Text")

dsProduct.InsertParameters.Add(ShippingAmountUK3)

Dim ShippingIDUK4AsNew ControlParameter("ShippingID4","ddlUKShipping4","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDUK4)

Dim ShippingAmountUK4AsNew ControlParameter("ShippingAmount4","txtUKShipping4","Text")

dsProduct.InsertParameters.Add(ShippingAmountUK4)

Dim ShippingIDUK5AsNew ControlParameter("ShippingID5","ddlUKShipping5","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDUK5)

Dim ShippingAmountUK5AsNew ControlParameter("ShippingAmount5","txtUKShipping5","Text")

dsProduct.InsertParameters.Add(ShippingAmountUK5)

Dim ShippingIDInt1AsNew ControlParameter("ShippingID6","ddlIntShipping1","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDInt1)

Dim ShippingAmountInt1AsNew ControlParameter("ShippingAmount6","txtIntShipping1","Text")

dsProduct.InsertParameters.Add(ShippingAmountInt1)

Dim ShippingIDInt2AsNew ControlParameter("ShippingID7","ddlIntShipping2","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDInt2)

Dim ShippingAmountInt2AsNew ControlParameter("ShippingAmount7","txtIntShipping2","Text")

dsProduct.InsertParameters.Add(ShippingAmountInt2)

Dim ShippingIDInt3AsNew ControlParameter("ShippingID8","ddlIntShipping3","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDInt3)

Dim ShippingAmountInt3AsNew ControlParameter("ShippingAmount8","txtIntShipping3","Text")

dsProduct.InsertParameters.Add(ShippingAmountInt3)

Dim ShippingIDInt4AsNew ControlParameter("ShippingID9","ddlIntShipping4","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDInt4)

Dim ShippingAmountInt4AsNew ControlParameter("ShippingAmount9","txtIntShipping4","Text")

dsProduct.InsertParameters.Add(ShippingAmountInt4)

Dim ShippingIDInt5AsNew ControlParameter("ShippingID10","ddlIntShipping5","SelectedValue")

dsProduct.InsertParameters.Add(ShippingIDInt5)

Dim ShippingAmountInt5AsNew ControlParameter("ShippingAmount10","txtIntShipping5","Text")

dsProduct.InsertParameters.Add(ShippingAmountInt5)

'Dim ProductImage As New ControlParameter("ProductImage", "siProductImage", "NewFileName")

'dsProduct.InsertParameters.Add(ProductImage)

Try

dsProduct.Insert() HERE IS THE INSERT

Dim xAsInteger

For x = 1To 8

'Dim SaveDirectory As String = String.Format("{0}\", Server.MapPath(TemporarySaveDirectory), x)

MsgBox(ddlCategories.SelectedValue)

Dim ProductIDAsInteger = 1

Dim SaveDirectoryAsString =String.Format("~\shopping_mall\images\shops\{0}\{1}\{2}\", Session("ShopID"), ddlCategories.SelectedValue, ProductID)

If ShrekGlobal.GlobalFunctions.FileMove(String.Format("{0}.jpg", x), Server.MapPath(TemporarySaveDirectory), Server.MapPath(SaveDirectory))Then

Beep()

Else

Beep()

EndIf

'siProductImage.TemporarySaveDirectory = String.Format("~\shopping_mall\images\shops\{0}\{1}", hfShopID.Value, ddlCategories.SelectedValue)

'siProductImage.Upload()

ClearPage()

Catch exAs Exception

'UploadImage = False

DeleteImage(0)

MsgBox(String.Format("{0} ~ {1}","Error", ex.Message.ToString()))

'_lblInfo1.Text = sb.ToString

' Consider customizing the message for the EmailNotSentPanel in the ShowAds page.

'Beep()

'_lblInfo1.Text = Now + " :: " + sb.ToString

EndTry

'If UploadImage Then

'Dim TemporarySaveDirectory As String

'aveDirectory =

'End If

EndSub

|||

Try this article:http://aspnet.4guysfromrolla.com/articles/050207-1.aspx

Hope that helps.

Aaron

Wednesday, March 7, 2012

Programmatically configuring error and truncation dispositions for row redirection

Hi,

I have created a SSIS package programmatically using C#.

The package should do the following take data from source A, and place rows into destination B, if there are any error rows then redirect the rows to destination C. In my package I have the following components:

DTSAdapter.OLEDBSource.1 - Used as the Source

DTSAdapter.OLEDBDestination.1 - Used for the Destination Output - (let me call this normalOutput)

DTSAdapter.OLEDBDestination.1 - Used for the Destination Error Output - (let me call this errorOutput)

All my mappings appear to be correct, I build and save the package and receive a Successful validation and Success on Execution.

However, When I open the application using the Execute Package Utility I get the warning:

Warning:No rows will be sent to the error output(s). Configure error or truncation dispositions to redirect rows to the error output(s), or delete data flow transformations or destinations that are attached to the error output(s)

How do I get around this?

I have placed on the DTSAdapter.OLEDBDestination.1 (Used for the Destination Output), on the input collection I have placed:

normalOutput.InputCollection[0].ErrorRowDisposition = DTSRowDisposition.RD_RedirectRow;

normalOutput.InputCollection[0].TruncationRowDisposition = DTSRowDisposition.RD_RedirectRow;

normalOutput.OutputCollection[0].ExclusionGroup = 1;

on the DTSAdapter.OLEDBDestination.1 (Used for the Destination Error Output) I have placed:

errorOutput.OutputCollection[0].ExclusionGroup = 1;

However this does not work, I just get the wanring displayed above.

I have also tried to set the

OutputCollection[0].SynchronousInputID for both the error output and the normal output to the same values

so that:

normalOutput.OutputCollection[0].SynchronousInputID = normalOutput.InputCollection[0].ID

errorOutput.OutputCollection[0].SynchronousInputID = normalOutput.InputCollection[0].ID

However, the above scenario does not pass the package validation, in the Execute Package Utiltity, I get the wanring mentioned above and also the error:

Error: The input "OLE DB Destination Input" (16) has an invalid error or truncation row disposition.

So my question is what are the correct configuration settings to have in this scenario?

Thanks

Just looking at your code, I see a couple things to suggest. Where you are setting the Error and Truncation dispositions to redirect, I think that needs to be done on every item in the OutputCollection and not on the InputCollection. I also think you should not be setting anything for the ExclusionGroup.

I suggest you mock up what you're trying to create manually in BIDS and look at the Advanced Editor for OLE DB to get an idea for what properties need to be set where.

Also, in the beginning of your message you listed the same component for the normal and error outputs. Was that a typo?
|||

Thanks JayH, I ended up setting the ErrorRowDisposition to redirect on the InputCollection[0] of the NormalDestination (OLE DB Destination) and then creating an error path from the NormalDestination to the ErrorDestination (OLE DB Destination) .

This works for errors such as trying to place a varchar(20) column into a float column, but for some reason you are not allowed to set the TruncationRowDisposition to redirect at this level.

So, I went ahead a created a package on the VS IDE and set the TruncationRow dispositions to redirect on every column in the Source (OLE DB Source), and made a path from the error output to a ErrorDestination (OLE DB Destination).

and then... nothing...no redirection, when running the package using the Execute Package Utility, I see the warnings that a truncation will occur, but it just goes ahead and truncates the data in the column and placing the row into the NormalDestination and I get no rows redirecting to my ErrorDestination.

Is there something I am missing? Should be using a transformation component?

|||I think I'm missing the bigger picture. I'm not sure how a transformation component could help you. I'm imagining a single source OLE DB and two destination OLE DBs, one "normal" and the other "error".

You are correct that you can't set truncation disposition on an OLE DB destination. You can set an error disposition to redirect, but only if you're not fastloading. If there is an error when fastloading, the entire load will fail.

Your pipeline metadata should have the correct column definitions, and they should match your destination. Thus you should have no truncations or type mismatches detected at the destination. The place to detect truncations is on the source when the data is read and put into the pipeline. The only errors that should get detected at the destination are constraint violations.

If you'd like to send me code, my email is jay underscore hackney at hotmail dot com.
|||

No your spot on that is the final setup I had on Friday.

Point to note: I currently have my MaxInsertCommitSize set to 1000 which allows the fast loading.

Now back to the matter at hand, so, my package now has all the output columns on the source have both the ErrorRowDispositions and TruncationRowDispositions set to redirect and I've removed the ErrorDisposition from the "nomal" destination.

Now when I run the package I receive a truncation error, it should then perform the redirect but no rows are inserted and I get the following error message:

Error: There was an error with input column "City" (109) on input "OLE DB Destination Input" (16). The column status returned was "Text was truncated or one or more characters had no match in the target code page"

Let me break down the City column:

On the OLE DB Source is varchar(50)

On the "normal" destination is varchar(20)

On the "error" destination is varchar(MAX)

I want the truncation error to occur and redirect into the "error" destination where it should be inserted without any issues.

|||Regarding the MaximumInsertCommitSize, this does not enable any type of error redirection when fastloading. All it means is that instead of your whole load failing due to an error, only that 1,000 row chunk containing the error fails, and the rest of the load is considered successful.

Everything you're describing sounds correct to me. Have you saved the programmatically generated package and viewed it in the IDE to verify that everything was created correctly? Have you set the IsErrorOut on your error output?

|||Sorry. Have to correct myself. The failed chunks do get redirected.
|||

Thanks for the information on the fastloading, for the time being I have switched it off...

Regarding the the IsErrorOut field on the error output that is... (source.OutputCollection[1].IsErrorOut), it is already set to true by the framework.

Yes, the package is saved and i've looked at it in the IDE to check it and everything is fine:

However on executing the package I am left with:

Error: An OLE DB error has occurred. Error code 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Descriptioni "Invalid character value for cast specification" Information: The final commit for the data insertion has ended.

Error: There was an error with input column "City" (108) on input "OLE DB Destination Input" (29). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".

Error: the "input "OLE DB Destination Input" (29)" failed because error code 0xC0209078 occurred, and the error row disposition on "input "OLE DB Destination Input" (29)" specifies failure on error. An error occurred on the specified object of the specified component.

The strange thing is the "OLE DB Destination Input" the error refers to in the last line belongs to the "source" component. However, this should be left to "Fail component", because the redirections have been set on the output items.

Looking at the External and Input columns, on the error destination the DataTypes for the External columns are DT_TEXT and on the Input columns they match the type and length of the "normal" Destination OutputColumns which seems correct to me.

I'm at a loss....

Can you advise of any good books on programming SSIS (and handling error outputs!) using C#?

|||

Ok, I remade the new package with the VS IDE, with only one mapping on the City column.

I map the "source" city (varchar(50)) to "destination" city (varchar(5))

I map the "source" city (Error output - varchar(50)) to "error destination" city (varchar(MAX))

I set the the errorRow and truncationRow dispositions on the "source" on the city column to RedirectRow.

I then run the package and get the warning that a truncation could occur on the column city, but the package just runs through and places all the rows into the destination table, no rows are redirected - (Note that there are is data in the source which should be redirected).

Looking at the "destination" all the truncations have gone ahead leaving me with 5 character strings in the City column.

Surely I must be doing something wrong here?

|||No books that I know of. Darren probably has the most experience doing this type of stuff, but he apparently hasn't seen fit to comment.

Are you controlling your source data for the testing? Do you know that there aren't some invalid characters causing this error?

I think the best way to determine what your code should be doing is by comparing it to the XML of a package created in the IDE. You may also need to simplify your package so you can isolate components until they are working correctly. Maybe you should consider just using dead end components like Unions instead of OLE DB destinations for your normal and error outputs.

These are the disposition-related settings I think you should be using for your Source component. Are you setting the UsesDispositions on your source component?

OLE DB Source Component
UsesDispositions=True

NormalOutput
IsErrorOut=False
ErrorOrTruncationOperation=""
ErrorRowDisposition=RD_NotUsed
TruncationRowDisposition=RD_NotUsed

Normal OutputColumn
ErrorOrTruncationOperation="Conversion"
ErrorRowDisposition=RD_RedirectRow
TruncationRowDisposition=RD_RedirectRow

ErrorOutput
IsErrorOut=True
ErrorOrTruncationOperation=""
ErrorRowDisposition=RD_NotUsed
TruncationRowDisposition=RD_NotUsed

Error OutputColumn
ErrorOrTruncationOperation=""
ErrorRowDisposition=RD_NotUsed
TruncationRowDisposition=RD_NotUsed

|||

Yep, I already had a windiff moment with it to find any differences between a IDE made package and a dynamically created one, thats how I've ironed out initial issues.

I've also used the example shown here:

http://blogs.conchango.com/jamiethomson/archive/2005/08/08/1969.aspx

Setting up the whole package in the IDE and using my database tables instead, mapping just the city column and no other columns, and all the happens is I get a warning about the imminent truncation and the truncation goes ahead. So I get nothing in my error destination.

This is getting me extremely fustrated, is there anyone who has an example of setting up a simple TruncationRow redirect?

Jamie Thompson could you knock one up?

|||I think you just said that if you create a package in the IDE (using your tables), that you can't get the redirection to work there either? That's the second indication I've heard that this may be a different problem.

Let's try to establish a baseline of functionality by creating a simple package in the IDE. If you have AdventureWorks installed, try it with that database first to take your data out of the equation. If not then just use your own table.
OLE DB Source in table mode that loads the Person.Address table from the AdventureWorks database. On the columns tab, select only the City column (it is an nvarchar(30))
On the Error Output tab, set the error and truncation dispostions to redirect row Close the Source, right-click it, and select "Show Advanced Editor" On the "Input and Output Properties" tab, open "OLE DB Source Output", open "Output Columns" Select the City column and change the Length property to 10 and click OK. The Source will now warn about truncation.
Drop two Union All components on the data flow surface, connect one to the normal (green) output from the source, and the other to the error (red) output.|||

Mr JayH you are a godsend.

From reading your points the problem with the my package was made clear in the line:

Select the City column and change the Length property to 10 and click OK. The Source will now warn about truncation.
|||

Just incase anyone else runs into this problem here is my final mappings code for the "Source".

private void CreateMappings()

{

// Map OutColumns to there external metadata columns for my mappings

foreach (SSISMapping mapping in dtsMappings)

{

IDTSOutputColumn90 outputColumn = component.OutputCollection[0].OutputColumnCollection[mapping.ToColumn.Name];

IDTSExternalMetadataColumn90 exMetaDataColumn = component.OutputCollection[0].ExternalMetadataColumnCollection[mapping.FromColumn.Name];

componentInstance.MapOutputColumn(component.OutputCollection[0].ID, outputColumn.ID, exMetaDataColumn.ID, true);

outputColumn.TruncationRowDisposition = DTSRowDisposition.RD_RedirectRow;

outputColumn.ErrorRowDisposition = DTSRowDisposition.RD_RedirectRow;

// Note that this must come AFTER the mapping because otherwise the properties will

//be mapped to the ExternalMetaColumn's properties

outputColumn.SetDataTypeProperties(SSISUtilities.GetDataType(mapping.ToColumn.DataType),

mapping.ToColumn.Length,

mapping.ToColumn.Precision,

mapping.ToColumn.Scale,

SSISUtilities.DEFAULTCODEPAGE);

}

}

Note that SSISUtilities and SSISMapping are not part of the framework.

Wednesday, March 28, 2012

Property page giving error

Property Owner is not available for Database '[DTA_TaxMan]'. This property may not exist

Property Owner is not available for Database '[DTA_TaxMan]'. This property may not exist

Property Owner is not available for Database

Property IsLocked is not available

Property IsLocked is not available

Friday, March 23, 2012

Prooblem inserting into a table

Wednesday, March 21, 2012

Project Server 2003 Setup Error 25624

Project Server 2003 Setup Error 25624

Project Server 2003 Setup Error 25624

project server

Tuesday, March 20, 2012

Project opening - XML Document Error (118, 17)

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server

PROGRAMTICALLY ACCESS SQLDATASOURCE !

Wednesday, March 7, 2012

Programmatically configuring error and truncation dispositions for row redirection

Program Connection

Blog Archive

About Me