ERROR: Subreport: type

Showing posts with label type. Show all posts

Thursday, March 29, 2012

ETL Guidance

Hi,

We've decided to use SSIS for an ETL type project. We are going to convert some files to our special flat file format. Our special flat file format will not change, but we will need to convert about 40 different style flat files into this format. We will receive any of these files at random intervals. We will likely have to add more file formats to the 40 at some point, too.

I'd like to use a flexible design, but I just started with SSIS and its going to be hard to test all the possible combinations, so I hope I can find some guidance in this forum.

What would be a good approach to allow for the most reuse of work to support these various file formats?

Jamie Thomson's excellent SSIS blog has an "SSIS Best Practices" list that might be a good place to start: http://blogs.conchango.com/jamiethomson/archive/2006/01/05/2554.aspx

|||At worst you'll need to make a converison from each style of incoming file to your formatted style. more details would be helpful|||Thanks, I read Jamie's blog everyday and I recommend it to everyone, too.sql

Monday, March 26, 2012

especial SUM

I wonderin if I can make this type of sum in SQL Reporting Services.

sum( iif(Fields!ESTADO_TRANSAC_POS.Value = "V",Fields!TOTAL_GENERAL.Value,cdbl("0.00")),"source")

i get an error field : (

i dont want to sum all the rows just the ones that where Estado_Transac = "V"

can you help me : )

i found the answer in this thread Conditional Sum/Runnining Total

sql

Sunday, March 11, 2012

Errors in Event Log

Hello all,
Not having much joy finding information about the following errors that are
appearing in the Event Viewer under Application:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 04/01/2005
Time: 14:37:09
User: N/A
Computer: SQ01
Description:
17066 :
SQL Server Assertion: File: <proc.c>, line=1576
Failed Assertion = 'm_activeSdesList.Head () == NULL'.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 04/01/2005
Time: 14:37:09
User: N/A
Computer: SQ01
Description:
17310 :
SqlDumpExceptionHandler: Process 3400 generated fatal exception c000001d
EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
Both errors tend to happen quite a bit, and my Application Event log is
chokka with them.
Can anyone assist? If I've got the wrong newsgroup I do apologise, and
please point me to the correct one.
Thanks :-)
PeterThese are either (most likely) SQL Server bugs or data corruption. First step is to search for them
in BK and see if you find anything and also make sure that you are current on service pack etc. IF
that doesn't fix it, open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter Blackwell" <nobody@.home.com> wrote in message news:uBfHnKn8EHA.4072@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> Not having much joy finding information about the following errors that are
> appearing in the Event Viewer under Application:
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 04/01/2005
> Time: 14:37:09
> User: N/A
> Computer: SQ01
> Description:
> 17066 :
> SQL Server Assertion: File: <proc.c>, line=1576
> Failed Assertion = 'm_activeSdesList.Head () == NULL'.
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 04/01/2005
> Time: 14:37:09
> User: N/A
> Computer: SQ01
> Description:
> 17310 :
> SqlDumpExceptionHandler: Process 3400 generated fatal exception c000001d
> EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
> Both errors tend to happen quite a bit, and my Application Event log is
> chokka with them.
> Can anyone assist? If I've got the wrong newsgroup I do apologise, and
> please point me to the correct one.
> Thanks :-)
> Peter
>|||Thanks for posting. Please excuse my ignorance but what is 'BK'?
Many thanks,
Peter
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uVT6SVn8EHA.2568@.TK2MSFTNGP10.phx.gbl...
> These are either (most likely) SQL Server bugs or data corruption. First
step is to search for them
> in BK and see if you find anything and also make sure that you are current
on service pack etc. IF
> that doesn't fix it, open a case with MS Support.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter Blackwell" <nobody@.home.com> wrote in message
news:uBfHnKn8EHA.4072@.TK2MSFTNGP10.phx.gbl...
> > Hello all,
> >
> > Not having much joy finding information about the following errors that
are
> > appearing in the Event Viewer under Application:
> > Event Type: Error
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 04/01/2005
> > Time: 14:37:09
> > User: N/A
> > Computer: SQ01
> > Description:
> > 17066 :
> > SQL Server Assertion: File: <proc.c>, line=1576
> > Failed Assertion = 'm_activeSdesList.Head () == NULL'.
> >
> > Event Type: Error
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 04/01/2005
> > Time: 14:37:09
> > User: N/A
> > Computer: SQ01
> > Description:
> > 17310 :
> > SqlDumpExceptionHandler: Process 3400 generated fatal exception c000001d
> > EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
> >
> > Both errors tend to happen quite a bit, and my Application Event log is
> > chokka with them.
> >
> > Can anyone assist? If I've got the wrong newsgroup I do apologise, and
> > please point me to the correct one.
> >
> > Thanks :-)
> >
> > Peter
> >
> >
>|||I think most of us are just as ignorant about this. It took me a few
moments, but I think he meant KB (KnowledgeBase).
http://support.microsoft.com/search/?adv=1&spid=2852
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Peter Blackwell" <nobody@.home.com> wrote in message
news:%23iuEWYn8EHA.2452@.TK2MSFTNGP14.phx.gbl...
> Thanks for posting. Please excuse my ignorance but what is 'BK'?
> Many thanks,
> Peter
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> message news:uVT6SVn8EHA.2568@.TK2MSFTNGP10.phx.gbl...
>> These are either (most likely) SQL Server bugs or data corruption. First
> step is to search for them
>> in BK and see if you find anything and also make sure that you are
>> current
> on service pack etc. IF
>> that doesn't fix it, open a case with MS Support.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Peter Blackwell" <nobody@.home.com> wrote in message
> news:uBfHnKn8EHA.4072@.TK2MSFTNGP10.phx.gbl...
>> > Hello all,
>> >
>> > Not having much joy finding information about the following errors that
> are
>> > appearing in the Event Viewer under Application:
>> > Event Type: Error
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 04/01/2005
>> > Time: 14:37:09
>> > User: N/A
>> > Computer: SQ01
>> > Description:
>> > 17066 :
>> > SQL Server Assertion: File: <proc.c>, line=1576
>> > Failed Assertion = 'm_activeSdesList.Head () == NULL'.
>> >
>> > Event Type: Error
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 04/01/2005
>> > Time: 14:37:09
>> > User: N/A
>> > Computer: SQ01
>> > Description:
>> > 17310 :
>> > SqlDumpExceptionHandler: Process 3400 generated fatal exception
>> > c000001d
>> > EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
>> >
>> > Both errors tend to happen quite a bit, and my Application Event log is
>> > chokka with them.
>> >
>> > Can anyone assist? If I've got the wrong newsgroup I do apologise, and
>> > please point me to the correct one.
>> >
>> > Thanks :-)
>> >
>> > Peter
>> >
>> >
>>
>|||Indeed I did mean KB as in KnowledgeBase. That for picking up on that Kalen. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eC9D3rn8EHA.1264@.TK2MSFTNGP12.phx.gbl...
>I think most of us are just as ignorant about this. It took me a few moments, but I think he meant
>KB (KnowledgeBase).
> http://support.microsoft.com/search/?adv=1&spid=2852
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Peter Blackwell" <nobody@.home.com> wrote in message
> news:%23iuEWYn8EHA.2452@.TK2MSFTNGP14.phx.gbl...
>> Thanks for posting. Please excuse my ignorance but what is 'BK'?
>> Many thanks,
>> Peter
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>> message news:uVT6SVn8EHA.2568@.TK2MSFTNGP10.phx.gbl...
>> These are either (most likely) SQL Server bugs or data corruption. First
>> step is to search for them
>> in BK and see if you find anything and also make sure that you are current
>> on service pack etc. IF
>> that doesn't fix it, open a case with MS Support.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Peter Blackwell" <nobody@.home.com> wrote in message
>> news:uBfHnKn8EHA.4072@.TK2MSFTNGP10.phx.gbl...
>> > Hello all,
>> >
>> > Not having much joy finding information about the following errors that
>> are
>> > appearing in the Event Viewer under Application:
>> > Event Type: Error
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 04/01/2005
>> > Time: 14:37:09
>> > User: N/A
>> > Computer: SQ01
>> > Description:
>> > 17066 :
>> > SQL Server Assertion: File: <proc.c>, line=1576
>> > Failed Assertion = 'm_activeSdesList.Head () == NULL'.
>> >
>> > Event Type: Error
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 04/01/2005
>> > Time: 14:37:09
>> > User: N/A
>> > Computer: SQ01
>> > Description:
>> > 17310 :
>> > SqlDumpExceptionHandler: Process 3400 generated fatal exception c000001d
>> > EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
>> >
>> > Both errors tend to happen quite a bit, and my Application Event log is
>> > chokka with them.
>> >
>> > Can anyone assist? If I've got the wrong newsgroup I do apologise, and
>> > please point me to the correct one.
>> >
>> > Thanks :-)
>> >
>> > Peter
>> >
>> >
>>
>>
>

Wednesday, March 7, 2012

Error1'System.Net.NetworkCredential' is a 'type', which is not valid in the given contextC:\

Hello, I got this error when trying to render, in the line of the credentials, how should I solve it.

rs.Credentials = System.Net.NetworkCredential("levalencia", "123", "se");

ReportingService2005 rs;

private void cargarReporteFromWS()

{

rs = new ReportingService2005();

rs.Credentials = System.Net.NetworkCredential("levalencia", "123123123", "se");

}

Hello,

System.Net.NetworkCredential is not a static method, but a constructor, so you need to use the "new" keyword.

rs.Credentials = new System.Net.NetworkCredential("levalencia", "123", "se");

Sunday, February 26, 2012

Error1Dimension '...' : The following attribute(s) form loop(s):

Hello!

I have an error on a dimension, saying
"Error 1 Dimension 'Car Park Type' : The following attribute(s) form loop(s): [Car Park Type], [Car Park Key]. 0 0 "
but I do not have much idea of what it could mean.

This dimension is based on this request :
SELECT 'Inside' AS CarParkType, InsideCount AS CarParkCount, BuildingKey, OfferKey, TransactionKey, CarParkKey
FROM dimCarPark
WHERE (InsideCount > 0)
UNION
SELECT 'Outside' AS CarParkType, OutsideCount AS CarParkCount, BuildingKey, OfferKey, TransactionKey, CarParkKey + 100000 AS Expr1
FROM dimCarPark AS dimCarPark_3
WHERE (OutsideCount > 0)
UNION
SELECT 'Proximity' AS CarParkType, ProximityCount AS CarParkCount, BuildingKey, OfferKey, TransactionKey, CarParkKey + 200000 AS Expr1
FROM dimCarPark AS dimCarPark_2
WHERE (ProximityCount > 0)
UNION
SELECT 'Double' AS CarParkType, DoubleCount AS CarParkCount, BuildingKey, OfferKey, TransactionKey, CarParkKey + 300000 AS Expr1
FROM dimCarPark AS dimCarPark_1
WHERE (DoubleCount > 0)

Does anyone have any idea?

Thanks anyway.I have found. There was an error in the attributes of the dimension.

Bye!

Error:The type initializer for "Microsoft.ReportDesigner.Drawing.Language" threw an except

Hi,
I've been trying to get to the bottom of this error it prevents be
from loading the report in Design Mode. As of right now when opening
a report in design mode through the VS .Net 2003 IDE I get the
following:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception.
I've tried uninstall/reinstall, reporting services service pack 1 and
debuging the devenv.exe from another ide instance. Debug error is:
System.ComponentModel.Design.Serialization.CodeDomSerializerException:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
Microsoft.DataWarehouse.Serialization.XmlSerializationException:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
System.TypeInitializationException: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
System.ArgumentException: Culture ID 31770 (0x7C1A) is not a supported
culture.
Parameter name: culture
at System.Globalization.CultureInfo..ctor(Int32 culture, Boolean
useUserOverride)
at System.Globalization.CultureTable.GetCultures(CultureTypes
types)
at Microsoft.ReportDesigner.Drawing.Language.GetStandardValues()
at Microsoft.ReportDesigner.Drawing.Language..cctor()
-- End of inner exception stack trace --
at Microsoft.ReportDesigner.Drawing.Language..ctor(String value)
at Microsoft.ReportDesigner.Drawing.LanguageConverter.CreateObject(String
value)
at Microsoft.ReportDesigner.Drawing.XmlStringListConverter.ConvertFrom(ITypeDescriptorContext
context, CultureInfo culture, Object value)
at System.ComponentModel.DefaultValueAttribute..ctor(Type type,
String value)
-- End of inner exception stack trace --
at Microsoft.ReportDesigner.Serialization.DesignXmlReader.ReadRoot(Type
type)
at Microsoft.ReportDesigner.Serialization.DesignXmlReader.DeserializeComponent(IDesignerSerializationManager
manager, XmlReader reader, Type root)
at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.DeserializeObject(IDesignerSerializationManager
manager, Object serializationStream)
at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.Deserialize(IDesignerSerializationManager
manager, Object serializationStream)
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Deserialize()Hi, I got the same error here, if you already fixed this problem, please post
here waht is going on.
Thanks, Rafael
"Ricardo" wrote:
> Hi,
> I've been trying to get to the bottom of this error it prevents be
> from loading the report in Design Mode. As of right now when opening
> a report in design mode through the VS .Net 2003 IDE I get the
> following:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception.
> I've tried uninstall/reinstall, reporting services service pack 1 and
> debuging the devenv.exe from another ide instance. Debug error is:
> System.ComponentModel.Design.Serialization.CodeDomSerializerException:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> Microsoft.DataWarehouse.Serialization.XmlSerializationException:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> System.TypeInitializationException: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> System.ArgumentException: Culture ID 31770 (0x7C1A) is not a supported
> culture.
> Parameter name: culture
> at System.Globalization.CultureInfo..ctor(Int32 culture, Boolean
> useUserOverride)
> at System.Globalization.CultureTable.GetCultures(CultureTypes
> types)
> at Microsoft.ReportDesigner.Drawing.Language.GetStandardValues()
> at Microsoft.ReportDesigner.Drawing.Language..cctor()
> -- End of inner exception stack trace --
> at Microsoft.ReportDesigner.Drawing.Language..ctor(String value)
> at Microsoft.ReportDesigner.Drawing.LanguageConverter.CreateObject(String
> value)
> at Microsoft.ReportDesigner.Drawing.XmlStringListConverter.ConvertFrom(ITypeDescriptorContext
> context, CultureInfo culture, Object value)
> at System.ComponentModel.DefaultValueAttribute..ctor(Type type,
> String value)
> -- End of inner exception stack trace --
> at Microsoft.ReportDesigner.Serialization.DesignXmlReader.ReadRoot(Type
> type)
> at Microsoft.ReportDesigner.Serialization.DesignXmlReader.DeserializeComponent(IDesignerSerializationManager
> manager, XmlReader reader, Type root)
> at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.DeserializeObject(IDesignerSerializationManager
> manager, Object serializationStream)
> at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.Deserialize(IDesignerSerializationManager
> manager, Object serializationStream)
> at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Deserialize()
>|||I have problem in Reporting Services 2005 with width of report - max. limit is probably 406,34921 cm. Is it possible to increase this limit to for exapmle 450 cm ?
From http://www.developmentnow.com/g/115_2004_11_0_0_453315/ErrorThe-type-initializer-for-Microsoft-ReportDesigner-Drawing-Language-threw-an-exception.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Friday, February 24, 2012

Error: The type or namespace name DataReader could not be found

In my DAL:

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public DataReader getPersonList2() {
using (SqlConnection conn = getConnection())
{
SqlCommand cmd = new SqlCommand("PERSON_SP_getPersonList", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
return cmd.ExecuteReader();
}
}

In my BLL:

DAL d = new DAL();

public DataReader getPersonList2(){
return d.getPersonList2();
}

I get the following error in my BLL:

Compiler Error Message:CS0246: The type or namespace name 'DataReader' could not be found (are you missing a using directive or an assembly reference?)

Source Error:

Line 34: }
Line 35:
Line 36: public DataReader getPersonList2(){
Line 37: return d.getPersonList2();
Line 38: }

Source File: c:\Inetpub\wwwroot\study\App_Code\BLL.cs Line: 36

Just wondering if someone could tell me why this is happening? I have the same namespaces that I have in the DAL in my BLL.

Puzzled.That should likely be SqlDataReader, not DataReader.|||public SqlDataReader getOUDetails(int SMU_Id) { SqlDataReader dr; string Qry = ""; con.Open(); cmd1 = new SqlCommand(Qry, con); return cmd.ExecuteReader(); cmd.Dispose(); con.Close(); }try do this way

Sunday, February 19, 2012

Error: The count aggregate operation cannot take a void type data type as an argument.

TITLE: Microsoft Visual Studio

An error occurred while executing a command.
Message: The count aggregate operation cannot take a void type data type as an argument.
The count-unique aggregate operation cannot take a void type data type as an argument.
The count aggregate operation cannot take a void type data type as an argument.
The count-unique aggregate operation cannot take a void type data type as an argument.

I'm getting this error message when trying to create a model for an entire database. Anyone know there is a specific reason why? The data type in the database is not void. Each of the items that were referanced in the error message have valid data types.

Thanks in advance.

What datatype causes this error?

Friday, February 17, 2012

ERROR: System.OutOfMemoryException

How should I resolve the following error message when running report?
ERROR:
Exception of type 'System.OutOfMemoryException' was thrownBuy more RAM Â¬Â¬
No, I'm kidding. Well, what are you exactly doing? Are you running a report
that accesses many tables or tables with many rows?|||What a great sense of humor!
However, I am just running a report via Report Manager.
http://reportserv/reports
TABLE ROWS below:
6,683
QUERY below:
SELECT Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group,
List_Codes_Table.LIST_Name, Lists_Members.LSTM_Name_ID
FROM Lists_Members AS Lists_Members INNER JOIN
List_Codes_Table AS List_Codes_Table ON
Lists_Members.LSTM_Lists_ID = List_Codes_Table.LIST_Id
GROUP BY Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group,
List_Codes_Table.LIST_Name, Lists_Members.LSTM_Name_ID
ORDER BY Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group
"F. Dwarf" wrote:
> Buy more RAM Â¬Â¬
> No, I'm kidding. Well, what are you exactly doing? Are you running a report
> that accesses many tables or tables with many rows?|||Well, I'm still puzzled. I don't figure out what could be the problem

Thursday, March 29, 2012

ETL Guidance

Monday, March 26, 2012

especial SUM

Sunday, March 11, 2012

Errors in Event Log

Errors in Event Log

Errors in Event Log

Wednesday, March 7, 2012

Error1'System.Net.NetworkCredential' is a 'type', which is not valid in the given contextC:\

Sunday, February 26, 2012

Error1Dimension '...' : The following attribute(s) form loop(s):

Error:The type initializer for "Microsoft.ReportDesigner.Drawing.Language" threw an except

Friday, February 24, 2012

Error: The type or namespace name DataReader could not be found

Sunday, February 19, 2012

Error: The count aggregate operation cannot take a void type data type as an argument.

Friday, February 17, 2012

ERROR: System.OutOfMemoryException

ERROR: Subreport

Blog Archive

About Me