ERROR: Subreport: project

Showing posts with label project. 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

ETL from multiple Access databases -SSIS?

Howdy Folks,

I have an ETL project that I want to ask a question about. I want to loop through a folder containing several Access databases, and extract and load each one into a single SQL Server 2005 database. The table layout is the same for all the Access dbs, as well as the SQL db. The number of Access dbs in the folder, their records, and their names will change. Is there a way i can use the SSIS Foreach tool to move through the folder and set the connection string inside the loop?

Thanks for your reply,

Chris

Yes, you can do this.

Use the ForEach File Enumerator to enumerate your list of files. you can use wildcards (e.g. *.mdb)

Store the file path of each file in a variable. You can then use the contents of that variable to dynamically build your connection string using an expression.

Lots of information via Google about this stuff if you want to go hunting or ask here with any pertinent questions.

Regards

-Jamie

|||

Thanks Jamie (alot ) for your suggestion. I tried using the Foreach File Enumerator with the root path for the Access files and a *.mdb wildcard. Then I created a mapped string variable varFileNameto hold the file path. Inside the loop i have my Data Flow Task. In the data source for the task, I was using the variable in an expression as the ConnectionSting property which didn't work. So I added an OLE DB connection string in the expression like "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @.[User::varFileName] but i don't think that's the answer.

I've been googling on this but can't find solutions for multiple .mdb's, most of waht i find is dealing with flat files. Great blogs btw.

|||

Should be able to find all you need here: http://www.connectionstrings.com/

-Jamie

|||

Yep, i went there. Thanks Jamie. My string was ok. Actually what got me running was to set the Foreach Loop Container>Properties>Execution>DelayValidation = True. Works great running the SSIS package on the box with SQL server (as opposed to OLE DB) destinations.

Thursday, March 22, 2012

erwin and data modeling

I have just started using erwin on a new database project that would be part
of our existing data warehouse.
Currently, I use sql scripts to create table, stored procs etc. and then I
update the erwin data model. This is not a good idea because I would rather
drive my data model from central location such as erwin tool. I tried to
drive data structure from the tool but its not working
What are some of the best practices to use erwin with regards to data
modeling? Are there any sites, white papers that talk about how to best use
erwin? Online help for erwin is not much useful.
I could not find any articles on google on erwin best practices etc.
Please let me know.
TIA...Didn;t you evaluate these kinds of things / support options prior to
selecting Erwin as the tool of choice? That would be a solid best practise
for a start.
RR
"sqlster" <nospam@.nospam.com> wrote in message
news:8F357659-2CFE-40C5-9779-3D5B769EBE74@.microsoft.com...
> I have just started using erwin on a new database project that would be
part
> of our existing data warehouse.
> Currently, I use sql scripts to create table, stored procs etc. and then I
> update the erwin data model. This is not a good idea because I would
rather
> drive my data model from central location such as erwin tool. I tried to
> drive data structure from the tool but its not working
> What are some of the best practices to use erwin with regards to data
> modeling? Are there any sites, white papers that talk about how to best
use
> erwin? Online help for erwin is not much useful.
> I could not find any articles on google on erwin best practices etc.
> Please let me know.
> TIA...|||head on over to http://www.infoadvisors.com/
they have active newsgroups for many things erwin, and competeing products t
oo
good luck
"sqlster" <nospam@.nospam.com> wrote in message news:8F357659-2CFE-40C5-9779-3D5B769EBE74@.mi
crosoft.com...
>I have just started using erwin on a new database project that would be par
t
> of our existing data warehouse.
> Currently, I use sql scripts to create table, stored procs etc. and then I
> update the erwin data model. This is not a good idea because I would rathe
r
> drive my data model from central location such as erwin tool. I tried to
> drive data structure from the tool but its not working
> What are some of the best practices to use erwin with regards to data
> modeling? Are there any sites, white papers that talk about how to best us
e
> erwin? Online help for erwin is not much useful.
> I could not find any articles on google on erwin best practices etc.
> Please let me know.
> TIA...sql

Wednesday, March 21, 2012

Errors with SRS in Sharepoint Integration Mode

Hi Everyone,

Our project has two servers. One server is running WSS 3.0 and the SQL Reporting Services web front-end. We have a second server that operates all the databases involved (WSS Content, SRS, and our application specific DB).

We do not have a domain controller in our architecture. The WSS site is configured to use SQL authentication to connnect and modify the WSS Content database. We installed SRS, SRS service pack 2, and the Sharepoint add-in. We are using forms authentication for our WSS site. We would like to use SRS in Sharepoint Integration mode, but we are unable to create datasources, view reports, etc. SRS is configured to use the "Trusted Account" in WSS Central Admin.

When we attempt to create a new datasource, and we received an error stating the object moved and to check that SRS is in Sharepoint integration mode.

When we attempt to view a report, we get an error stating:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

I have a feeling this has to do with the Windows Service Account and the Web Service Identity for SRS. What type of account should we use since we do not have a domain?

Thank you,

Michael milazzo

As explained here, in Trusted Account mode, WSS sends the requests to the Report Server under the identity of the SharePoint application. By default, the IIS 6.0 application pool runs under NT AUTHORITY\Network Service. Since you don't have a domain setup, try changing the application domain identity to a local Windows user account which has the same name and password as a privileged account on the Report Server that has access to the report catalog. If you had domain setup, the request could have gone under Domain\WSS machine name$ and you could have granted access to that account.

Errors while Deploying Analysis services projects in server

Hi,

I am using Sql server Business Intelligence Development Studio 2005 and SQL server Management studio.

I created a Analysis services project in the BI Dev Studio, and set the correct server attributes in the project properties -> deployment tab.

I have created a data source , then a datasource view and then cube and dimensions.

1) When I tried deploying with the database name as 'xyz'. (again set in the project properties -> database ,target attribute),

and the database 'xyz' is previously created and thus present in the Analysis server 2005. I get the following error:

"The database , 'xyz', contains an ImpersonationMode that is reserved for server administrators."

2.) When i tried deploying with the database name as 'abc'. (again set in the project properties -> database ,target attribute),

but NOTE now there is no analysis server database with the name 'abc' already existing in the analysis server. now I get the following error:

"Either the 'myUserName' user does not have permission to create a new object in 'myServerName', or the object does not exist."

I checked the Sql server management studio and under the 'xyz' analysis database in the 'Roles' Folder my username is a member of the Administrators who have full priliviges.

Please do tell me as to where I am going wrong.

Thanks and regards

Vijay R

Hi Vijay,

I had the same problem as you and found the following on http://www.eggheadcafe.com/forumarchives/SQLServerdatamining/Jun2005/post23396286.asp. Changing the impersonation mode to the service account sorted things out straight away for me, hopefully it'll do the same for you.

"The impersonation mode tells Anaylsis Server what credentials to use when connecting to the database specified in the datasource object. When you create the datasource using the Data Source Wizard, there's an "Impersonation Information" page where you can set this information. If the data source is used for processing (i.e. you are training mining structures/models from that data source), you are not allowed to set the ImpersonationMode to "Use the credentials of the current user" due to security considerations - you must either use the service account or use a specific username/password. You can change the impersonation mode by opening the data source in BI Dev Studio and selecting one of the allowed options above on the "Impersonation Information" tab."

Errors when setting up Cube from Project Server 2007 in Analysis Server

We try to setup a cube from Project Server in our (seperated) Analysis Server.

Even though following all the instructions which can be found and equally we setup the repository in the SQL 2005 Server or use the .mdb, we run into the following errors:

[26.07.2007 12:19 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SERVER. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[26.07.2007 12:19 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SERVER. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

The Project Server Queue Service user is a) SQL sysadmin and b) SQL Server Admin group member - at least it became this after everything else didn't work out..

The correct shares etc. on filebase are given, even it is checked that the Queue Account can connect to the share from another computer, ...

So now I wonder whether someone else had this issue and can help out here?

Thanks in advance.

Hello! In order to set up an SSAS2005 cube you will need to have administrators permissions on SSAS2005.

I assume that SSAS2005 and SQL Server 2005 run on the same server.

Connect to SSAS2005 with Management Studio and right click on the server. Choose properties and the security tab(server wide security privileges) and the add the user who shoul have rights to deploy and process the cube.

HTH

Thomas Ivarsson

|||

I am having similar problems.

I have added the shared service provider to AS box. I restarted AS and I am still gettting the same error.

Any help would be greatly appreciated....

Here is the event log:

"Standard InformationSI Entry Point:
Project User: <domain\server name>
Correlation Id: 4f990c61-13e6-49b3-949e-2867e681c38b
PWA Site URL: <server name>
SSP Name: SharedServices1
PSError: CBSASConnectionFailure (17003)
Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=<IP Address> ASDBName=OLAPCUBE ASExtraNetAddress=<IP Address> RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/01/2007 12:11:58 ToDate=08/01/2007 12:11:58 HighPriority=True

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Monday, March 19, 2012

Errors processing SSAS 2005

Hi,

I am receiving the following error when i try to deploy project.

Error 1 The following system error occurred: .

AS 2005 SP1

Windows Server 2003 Ent. SP1

Make sure Analysis Server is runing. Go to the project's properties and make sure your project points to the Analysis Server.

Can you also describe the error. Is it a single error. Are there more errors? Is this the first time you are trying to deploy?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello Edward!

On your questions: Analysis Server is runing - Yes, project points to the Analysis Server - Yes

Is it a single error - Yes. Is this the first time you are trying to deploy? - No, The error has appeared after the server became DC.

New projects are developed normally, All cubes old and new process is normal.

|||

This could be very much as a result of your computer becoming domaing controller.

Can you connect to Anlaysis Server from SQL Management Studio?

Try deleting everything from the data folder and restarting Analysis Server. This cause you to loose all of your databases, make sure you have you projects saved so you can re-create databases again .

If that doesnt help, the only solution I see is to try and re-install Analysis Services.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Errors in the OLAP storage engine

Error 4

When I am deploying the project I got the following error. Please help me sir

Errors in the OLAP storage engine: An error occurred while processing the 'Product Tran Header' partition of the 'Product Tran Header' measure group for the 'Test' cube from the productreport database. 0 0

I did the following steps

1. added new measure selecting new source table

2. selected one column dateoforder

3. Add new dimension as without using data source

4. selected server time dimension

5. Selected Year/Month/Quarter/date

6 Selected fiscal year

7.Selected dimension usage in cube desgn

8. selected time dimension and selected regular relation, Granulary attribute as Date

9. Measure group table 'Product tran header' new measure group

10 selected measure group column as dateoforder.

after that while deploying the above mentioned error will come

Please help

Polachan,

How many partitions do you have in that measure group? Is it possible that you changed measure group structure, but some partitions have specific query that does not match new structure? If this is the case, review each partition query.

Vidas Matelis

|||

Hi All,

I am also facing the same problem when i process some dimensions with in a Cube Database.

Can Anyone please help me in resolving it .

Thanks,

Prashant

|||run a profiler and check the query that is fired to the DB. That will give you some clues.

Errors in the metadata manager

Hello,
I'm trying to process a cube and i'm getting the following error message. I'm not working in Analysis Services Project 4, i created another project. I deleted Analysis Services Project 4 and every project i try to execute i get this error message.

"Error 1 File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the TBLE~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. . 0 0 "

Any ideas how to solve this problem?

Thank you in advance.

Looks like the data folder is corrupted. Could you please try the following steps:

1. Stop the Analysis Services service
2. Delete everything in your C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\%YOUR_PROJECTNAME% folder
3. Restart the Analysis Services service
4. Re-deploy your project

Hope this helps,

Artur

|||

I already try this but without stopping the analysis services and didn't work.

I will try it again... thanks for the help:)

|||

You should really stop Analysis Server :)

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Friday, March 9, 2012

Errors during building project with Deployment utility and configuration file

I am getting following error when "CreateDeploymentUtility" is set to true and I try building the solution. It tries to copy a file that already exits in \bin\Deployment folder. I am using Sept. CTP.

If I set "CreateDeploymentUtility" to false, there are no errors since it doesn't try copying the file. Any reason why this happens?
Error 1 System.ApplicationException: Could not copy file "C:\test\Source\ETLProcessing\PackageProject\test.dtsconfig" to the deployment utility output directory "C:\test\Source\ETLProcessing\PackageProject\bin\Deployment". > System.IO.IOException: The file 'C:\test\Source\ETLProcessing\PackageProject\bin\Deployment\test.dtsconfig' already exists. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) End of inner exception stack trace at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CreateDeploymentUtility(IOutputWindow outputWindow) 0 0

Ignore the message above. The issue was related to having config file referenced in misc. folder within the project so when the project tries to rebuild it will try to copy config file twice. BIDS should add config file to project instead of just having it in file sytem. It's becomes an issue when you try to use source safe and the file is not part of the project.

|||I have had the same problem recently, and although the packages and configs are fine, the deployment manifest file is not created....at least in my case. This prevents easy deployment. Any reason for this? Workarounds?
Thanks,
Adrian Crawford|||The problem I had was relating to adding Config to a Misc folder. To solve the problem, I removed the config reference from Misc folder and rebuild the solution. I would suggest, deleting bin folder, making sure the config is not referenced within the project, and try rebuilding. This should solve your problem. Also make sure the config file is not locked, readonly, or opened by another process.|||

What do you mean by "make sure the config file is not referenced within the project"? I have created configurations and need to use them, but the manifest file isn't created...

Pedro Martins

Errors during building project with Deployment utility and configuration file

I am getting following error when "CreateDeploymentUtility" is set to true and I try building the solution. It tries to copy a file that already exits in \bin\Deployment folder. I am using Sept. CTP.

|||I have had the same problem recently, and although the packages and configs are fine, the deployment manifest file is not created....at least in my case. This prevents easy deployment. Any reason for this? Workarounds?
Thanks,
Adrian Crawford
|||The problem I had was relating to adding Config to a Misc folder. To solve the problem, I removed the config reference from Misc folder and rebuild the solution. I would suggest, deleting bin folder, making sure the config is not referenced within the project, and try rebuilding. This should solve your problem. Also make sure the config file is not locked, readonly, or opened by another process.
|||

What do you mean by "make sure the config file is not referenced within the project"? I have created configurations and need to use them, but the manifest file isn't created...

Pedro Martins

Errors during building project with Deployment utility and configuration file

I am getting following error when "CreateDeploymentUtility" is set to true and I try building the solution. It tries to copy a file that already exits in \bin\Deployment folder. I am using Sept. CTP.

|||I have had the same problem recently, and although the packages and configs are fine, the deployment manifest file is not created....at least in my case. This prevents easy deployment. Any reason for this? Workarounds?
Thanks,
Adrian Crawford
|||The problem I had was relating to adding Config to a Misc folder. To solve the problem, I removed the config reference from Misc folder and rebuild the solution. I would suggest, deleting bin folder, making sure the config is not referenced within the project, and try rebuilding. This should solve your problem. Also make sure the config file is not locked, readonly, or opened by another process.
|||

What do you mean by "make sure the config file is not referenced within the project"? I have created configurations and need to use them, but the manifest file isn't created...

Pedro Martins

Errors Connecting...

-- EDIT --
I'd like to add that I've updated all the references in my project to SQL 10.0
-

Hello,

I am just getting started evaluating 2008 (July CTP) with our existing codebase. When I connect to the server to initiate the process of installing our database, I get the following exception:
{"This SQL Server version (10.0) is not supported."}. Could this be related to my workstation not having an up to date .NET framework?

The code to connect is:

.....
Microsoft.SqlServer.Management.Smo.Server server = null;
try
{
SqlConnection sqlConnection = new SqlConnection(@."Integrated Security=SSPI; Data Source=" + tserver);

//build a "serverConnection" with the information of the "sqlConnection"
Microsoft.SqlServer.Management.Common.ServerConnection serverConnection =
new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConnection);

//The "serverConnection is used in the ctor of the Server.
server = new Server(serverConnection);

// The actual connection is made when a property is retrieved so try to get version.
// an error means could not connect, most likely due to security
//string x = server.Information.Version.ToString();
System.Version x = server.Information.Version;
}
catch(Exception ex)
{
server = null;
Errors = "Unable to connect to the " + tserver + " server.\r\n" + ex.Message;
}
......
You probably need to use the updated assemblies. After installing SQL Server 2008, you will find them in C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies.

In particular Microsoft.SQLServer.Smo.dll|||My problem was that I missed updating the assemblies in a couple of the DLL's in the project, which caused the problem.

Sunday, February 26, 2012

Error:User does not have permission to perfor this action.

I just installled the Visual web developer - express addition. When I try to add aSQL database to my project it gives the following error - "User does not have permission to perfor this action" . Can someone please help?

If this is a Visual Web Developer issue, then you should try posting on the following forums: http://forums.asp.net/.

Is there any other information provided besides the error message, like an error code? If you have no additional information, can you describe the steps that you followed before you encountered the error?

Thanks
Laurentiu

|||

This is what I am doing

I am adding a new item to my project by selecting <Add New Item>. I select the SQL Database. After clicking Ok for creating the database in <App_Data> folder, I get the above stated error.

I have a similar install on my home PC. I do not get any error. It seems that the permision on SQL express needs to be changed. I am nor sure how I mange the users on sql express? I have uninstalled and re-installed the Web Developer express version.

As you suggested I will try to post this issue on the asp.net forum.

Thanks for getting back to me.

|||

Here are some ideas on a what you might do to get more information on this:

- check whether you have access to the folder where you're attempting to create the database (also check that the account that SQL Server runs as has access)
- check the SQL Server errorlog to see if there are any errors logged there
- If you have SQL Server Profiler, connect it to the server, retry the operation and see if any errors appear in the trace

Unfortunately, it's not clear whether the message you receive is from Web Developer or SQL Server. SQL Server error messages are usually accompanied by an error number and an error state, but this information is not always shown by clients.

If you can isolate the issue as happening in SQL Server, let us know.

Thanks
Laurentiu

error:an item with the same key has already been added

hi.
i just moved to the april ctp beta 2 version of dts(i know it's already late to do that). i created a new project and moved the packages i did on beta 1 into it. after building it, and when i run the dtsintall.exe, it got this error : an item with the same key has already been added (mscorlib).
what i did is excluded all the packages from the project and ran it for one package it worked..gradually i added a package after the other and build it and it worked..then suddenly the error appeared again and i can't get rid of it even when i go back to my initial state of 2 packages.. i can't understand why it's giving it.

i'm sure someone must have faced this problem. please help!

Thanks
ChristinaHi Christina,

One of the problems could have been that the packages use XML configurations that have the same file name.

This has been addressed for CTP16.

regards,
ash|||Hi Ash. Thanks for your reply.
Is it the file name or the configuration name?
If i change the configuration type will it work?

Thanks
Christina

Friday, February 24, 2012

Error:20533.Unable to Open Database

In my project I have used VB 6 and CR 8. In my machine the application is working fine. When it was loaded in the customer machine with windows 98 OS, when the report is clicked, it shows the error 'Error:20533 Unable to Open Database'. The Back end used is MS Access. Anybody pl. guide me to install my project? What to do and how to do?

Pl. post your reply due to urgency.Case 1)If u r running ur exe at client side u must place ur Database at the location u have given to ur DSN
Case 2)If u have installed ur setup at client side and just want to replace exe then check whethere u r replacing ur exe in the folder that has been installed on m/c|||Tried. But getting the same error.|||Open the Report and Do verify Database and map the columns if any|||Verify database. In my machine it works. I haven't installed the CR in the client machine. HOw to set right this problem. Is it necessary to load the CR in the client side? Pl. help
Meenakshi.R|||Did you use DSN to connect to CR?|||I haven't used any DSN for CR inthe client side. How to create that DSN for CR? pl. explain.|||How do you connect CR to database? Did you use OLE DB?
Create a DSN pointing to that DB and design reports. In the Client system create the same DSN and point it to that DB.

Otherwise refer this
http://www.businessobjects.com/support/default.asp

Wednesday, February 15, 2012

Error: SSIS Runtime Object could not be created.

I am using SQL Server 2005 Version 9.00.1399.06 (Intel X86).

Whether I try to start a new Integration Services project in Visual Studio or try to import data into a database I receive the following error:

SSIS Runtime Object could not be created. Verify the DTS.dll is available and registered. The wizard can not continue and will terminate.

Unable to cast COM of type 'Microsoft.SqlServer.DTS.Runtime.Wrapper.PackageNeutralClass' to interface type
'Microsoft .SqlServer.DTS.Runtime.Wrapper.IDTSContainer90'
This operation failed because the QueryInterface call on the COM component for the interface failed due to the following error: Library not registered. (Exception from HRESULT: 0X80028010) (TYPE_E_LIBNOTREGISTERED)).

I have no idea why I am getting this error and would appreciate any help. I'm sure some of you SQL Server Gurus will know right away.

This is setup problem, please reinstal the product or consult SQL Setup forum.

You can also try running 'regsvr32 dts.dll', which will probably fix this particular problem.|||

I had the same problem and I tried running regsvr32 dts.dll and I got this error.

dts.dll in not an executable file and no registration helper is registered for this file type.

Please advise.

i also tried to re-install SP1 but Integration Services and Reporting Services were greyed out. I wonder if I had to re-install everything all over again..please advise.

|||

Running resvr32 dts.dll from the dos command prompt worked for me.

Kim