Essentioal Relationship Question(s) [URGENT]!

Hi all;

[In case of creating a PK -FK relation]
When creating a DB cia VS.NET and from "Propert Pages -> on [Relationships] tap" there are many checkboxes (shown bellow), What question(s) should I ask my self in order to check the correct and right checkbox.

[1] Check existing data on creation.

[2] Enforce relationship for replication.

[3] Enforce relationship for INSERTs and UPDATEs.

[4] Cascade Update Related Fields.

[5] Cascade Delete Related Records.

(6) Cascade Update Related Fields.

(7) Cascade Delete Related Records.

Please, help me to under stand what should (to check betwwen thoses checkboxes)..

Thanks in advanced!

NOTE:
---
This is a URGENT messagem beacuse based on your answers or explaination I will build my Project DB. so, plz be coperative as you always..

++++++
~CS4Ever~
++++++Sorry, but have you considered reading the documentation?

You basically ask us to explain you what checkboxes on a SQL Server create relation dialog mean - this is all really well documented in - the documentation.|||I am not asking what those checkboxes do? I am asking who to be confident while checking thoses checkboxes (in otherwords, what should I ask myself to be confident?)?

Sorry for this question, but I am still beginner.

Hope my question is clear!|||Up plz.

I read about them "In a Complete Reference SQL (OSBORBE Book)>
(*) Inserting a new child row.
(*) Updating the forign key in a child row.
(*) Deleting a parent row. I
(*) Updatng the primary key in the parent row.

and I understod them (hopfully), BUT still I am asking about What question that I should ask myself in order to be confident when makeing the decision??

Hope you can help me gays!!

Thanks in advanced.|||plz, help me.

Just remember youself when you were beginner!!

Plz, help me.

Thanks.

Errow whilst initializing report server!

I have an urgent problem which I hope someone can help me with.
After installation, I was told by the wizard that I needed to initialize the report server manually...
So I went to:
http://uacl-sql2/reports
It redirects to:
http://uacl-sql2/reports/Pages/Folder.aspx
And I get the following error:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The system cannot find the file specified.
Does anyone know how to fix this...I have ensured that my Reports folder allows everyone to have full access...so I do not believe it is a security issue'?
Help!
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=c26e67c885b3477087ec7fc247396beb
*****************************************I can only think that you may have to use rsactivate (a command line utility
installed with Reporting Services). The syntax would be:
rsactivate -m RSServerName -u Username -p Password.
where username and password is the Windows account with admin priveleges to
the Reporting Services Service. This command would be run on the dbserver.
If this does not work you may need to use rsconfig (another installed
command line tool) prior to using rsactivate. rsconfig sets the connection
to the ReportServer database and the options can be viewed with rsconfig /?.
This should add the symetric keys in and activate or initialize the server.
Hope this helps.
Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
www.apress.com
"Jared Smith via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c26e67c885b3477087ec7fc247396beb@.SQLMonster.com...
>I have an urgent problem which I hope someone can help me with.
> After installation, I was told by the wizard that I needed to initialize
> the report server manually...
> So I went to:
> http://uacl-sql2/reports
> It redirects to:
> http://uacl-sql2/reports/Pages/Folder.aspx
> And I get the following error:
>
> An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help The system cannot find the
> file specified.
>
> Does anyone know how to fix this...I have ensured that my Reports folder
> allows everyone to have full access...so I do not believe it is a
> security issue'?
> Help!
> *****************************************
> * This message was posted via http://www.sqlmonster.com
> *
> * Report spam or abuse by clicking the following URL:
> *
> http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=c26e67c885b3477087ec7fc247396beb
> *****************************************|||I ran the rsactivate utility as you suggested and was returned with:
"Unable to find Reporting Services WMI namespace =on <machinename>. Reporting Services may not be installed"
Very odd...any suggestions?
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=48b8b00053c34af6b32f676a46089d07
*****************************************|||Jared,
I would check the ReportServer service on the Report Server through
Administrative Tools\Services to see if it is started. If not, try to start
it and record any errors. Also, check to see if that service is set to logon
at NT Authority\NetworkService on the Log On ta in the properties of the
ReportServer Service itself. You may need to reinstall and one of the
options during install is how you want the service to start. Have you tried
rsconfig on the Report Server? Also, I assume that the Report Server and
ReportServer database are on the same system (from the name you specified in
the URL it appears to be the case but I am only assuming)?
Rodney Landrum, Author "Pro SQL Server Reporting Services" (Apress)
www.apress.com
"Jared Smith via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:48b8b00053c34af6b32f676a46089d07@.SQLMonster.com...
>I ran the rsactivate utility as you suggested and was returned with:
> "Unable to find Reporting Services WMI namespace => on <machinename>. Reporting Services may not be installed"
> Very odd...any suggestions?
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
> *
> * Report spam or abuse by clicking the following URL:
> *
> http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=48b8b00053c34af6b32f676a46089d07
> *****************************************|||Hi Rodney,
The rsconfig appeares to run fine. The service is also running fine, however I changed the login details to be an administrator, and restarted it....
Something odd i did notice in the logs was the same error I get when attempting to initialize the report server i.e. The system cannot find the file specified.
I have pasted the log details below...any ideas?
<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__11_08_2004_13_41_25.log</Path>
<SystemName>UACL-SQL2</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutilities!c38!11/8/2004-13:41:25:: i
INFO: Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!c38!11/8/2004-13:41:25:: i
INFO: Reporting Services starting SKU: Standard
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Execution Log Entry Expiration timer enabled: Cycle: 44314 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!1140!11/8/2004-13:41:25:: i INFO: Initializing crypto as user: UACL-SQL2\Administrator
ReportingServicesService!crypto!1140!11/8/2004-13:41:25:: i INFO: Exporting public key
ReportingServicesService!library!1140!11/8/2004-13:41:25:: Exception caught while starting service. Error: System.IO.FileNotFoundException: The system cannot find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!1140!11/8/2004-13:41:25:: Attempting to start service again...
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=03200d71bc3149edb4cc19ae7dd1db2f
*****************************************

Errors in OLAP storage Engine: The attribute Key cannot be found: URGENT

Hi,

Okay, I am stuck here with this error and other related errors. before anything I will describe the scenario. Please do tell me What is wrong, How it happened and how to correct it.

Initially I had 3 relational tables in SQL server.
1. Dim_A (col1a, col2a, col3a)
2. Dim_B (col1b, col2b)
3. Fact_data (col1a,Col1b)

There are no Primary keys, foreign keys and relationships defined in the SQL relational database between these tables.

I created a OLAP database by:
1. creating the datasource
2. creating the datasource view and setting the logical primary keys and relationships as follows:
a. Fact_data.col1a references -> Dim_A.col1a
b. Fact_data.col1b references -> Dim_B.col1b
3. Next, I created a Cube, without automatically creating attributes or hierarchies (no auto build)
4. A Measure Group was automatically created, with a measure called Fact_data count (which i think is the count of the number of rows and was equal to 145). I checked the relational table "Fact_data" to find that the fact table had indeed 145 rows.
5. Next I built the project with not errors, then deployed and processed it.
6. I had no errors and I was able to browse the cube in the SQL BI studio.

After all this, I had created a asp.net page to issue the "Process" command to the complete OLAP database. (I had used the Process Script XMLA from the BI studio). This was also running perfectly.

Now the problem, suddeny next day when i ran the Process from my Asp.Net page, it gave me errors saying that there are Errors in the OLAP Storage engine. The attribute Key cannot be found, with the Table name, Column name and the value. It also gave other errors saying: The record was skipped because the attribute key was not found. it gave the info of the attribure, Dimension, database, cube, measure group and Partition.

I checked the SQL relational tables to find a change in the "Fact_data" table structure. Here is the changed structure of the Fact_data table:

Fact_data (col1a,Col1b,colNewC)

A new column "colNewC" was added to the table. Actually this was a new table with the same name as the old one with a new column. the old table was renamed and probably changed by some other person.
so i thought that the change in structure was the problem.

I created a new Analysis services project in the SQL BI studio, repeated the steps stated above to create a OLAP database. Then I built the project with no erros.
Next while trying to deploy and process the project. It is giving me the same errors. Attribute Key not found. I am neither able to deploy only or deploy and process.

Next I changed the error handling settings and set it to convert the not found keys to unknown. now it gave me esactly 145 errors, with the No attribute keys found. but with deployment and processing complete.
Now trying to browse the cube gives no records at all.

I analyzed the tables and its records, I felt that this was because the records present in the Fact_data table had no matching records in the Dim_A table. or specifically there were no matching "col1a" columns between them. thus all the 145 rows of the Fact_data table were shown as errors.

My question is:
1. So is this only a data in-consistency issue?
2. When somebody changed the Fact_data table structure, they also changed the data which had no matching columns with the dim_A table? is this correct? and hence the errors.
3. The only possible way to correct this is to populate the correct records, is this right?

Sorry for the lengthy post, but i thought it would describe the scenario better. Please do give a detailed answer for this and also how to correct it.

Thanks and regards

Try defining primary key-foreign key relationships in your SQL database.

This should help you to deal with referential integrity errors you are seeing.

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

|||

When running the XMLA Script run the default refresh of the dimesions first then process the cube for a full refresh..

The Error means that the Fact tables foriegn key doest match with the Primary key of the Dim Table AKA the lookup table (DIM) doest have a value to match with the DIM Table.Hope this Explains.

If there are lotsa invalidated data in the fact table change the Error procession configuration to notify and continue.

|||

I got exactly the same error message as your post here when I tried to process and deploy the cube in BIDS, did the answer posted here help you solve the problem above?

I want to knwo if that helped solve the problem then I may try this solution.

With best regards,

Yours sincerely,

Errors in OLAP storage Engine: The attribute Key cannot be found: URGENT

Hi,

Okay, I am stuck here with this error and other related errors. before anything I will describe the scenario. Please do tell me What is wrong, How it happened and how to correct it.

Initially I had 3 relational tables in SQL server.
1. Dim_A (col1a, col2a, col3a)
2. Dim_B (col1b, col2b)
3. Fact_data (col1a,Col1b)

There are no Primary keys, foreign keys and relationships defined in the SQL relational database between these tables.

I created a OLAP database by:
1. creating the datasource
2. creating the datasource view and setting the logical primary keys and relationships as follows:
a. Fact_data.col1a references -> Dim_A.col1a
b. Fact_data.col1b references -> Dim_B.col1b
3. Next, I created a Cube, without automatically creating attributes or hierarchies (no auto build)
4. A Measure Group was automatically created, with a measure called Fact_data count (which i think is the count of the number of rows and was equal to 145). I checked the relational table "Fact_data" to find that the fact table had indeed 145 rows.
5. Next I built the project with not errors, then deployed and processed it.
6. I had no errors and I was able to browse the cube in the SQL BI studio.

After all this, I had created a asp.net page to issue the "Process" command to the complete OLAP database. (I had used the Process Script XMLA from the BI studio). This was also running perfectly.

Now the problem, suddeny next day when i ran the Process from my Asp.Net page, it gave me errors saying that there are Errors in the OLAP Storage engine. The attribute Key cannot be found, with the Table name, Column name and the value. It also gave other errors saying: The record was skipped because the attribute key was not found. it gave the info of the attribure, Dimension, database, cube, measure group and Partition.

I checked the SQL relational tables to find a change in the "Fact_data" table structure. Here is the changed structure of the Fact_data table:

Fact_data (col1a,Col1b,colNewC)

A new column "colNewC" was added to the table. Actually this was a new table with the same name as the old one with a new column. the old table was renamed and probably changed by some other person.
so i thought that the change in structure was the problem.

I created a new Analysis services project in the SQL BI studio, repeated the steps stated above to create a OLAP database. Then I built the project with no erros.
Next while trying to deploy and process the project. It is giving me the same errors. Attribute Key not found. I am neither able to deploy only or deploy and process.

Next I changed the error handling settings and set it to convert the not found keys to unknown. now it gave me esactly 145 errors, with the No attribute keys found. but with deployment and processing complete.
Now trying to browse the cube gives no records at all.

I analyzed the tables and its records, I felt that this was because the records present in the Fact_data table had no matching records in the Dim_A table. or specifically there were no matching "col1a" columns between them. thus all the 145 rows of the Fact_data table were shown as errors.

My question is:
1. So is this only a data in-consistency issue?
2. When somebody changed the Fact_data table structure, they also changed the data which had no matching columns with the dim_A table? is this correct? and hence the errors.
3. The only possible way to correct this is to populate the correct records, is this right?

Sorry for the lengthy post, but i thought it would describe the scenario better. Please do give a detailed answer for this and also how to correct it.

Thanks and regards

Try defining primary key-foreign key relationships in your SQL database.

This should help you to deal with referential integrity errors you are seeing.

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

|||

When running the XMLA Script run the default refresh of the dimesions first then process the cube for a full refresh..

The Error means that the Fact tables foriegn key doest match with the Primary key of the Dim Table AKA the lookup table (DIM) doest have a value to match with the DIM Table.Hope this Explains.

If there are lotsa invalidated data in the fact table change the Error procession configuration to notify and continue.

|||

I got exactly the same error message as your post here when I tried to process and deploy the cube in BIDS, did the answer posted here help you solve the problem above?

I want to knwo if that helped solve the problem then I may try this solution.

With best regards,

Yours sincerely,

error: use trust connect failure -urgent

i use visual studio.net 2003 version and when a progamme run , it told me

do not have trust connect .what is wrong ?how can I do to solute it?

We usually define trusted connection in web.congif like

<appSettings>

<addkey="connectionstring"value="server=localhost;Trusted_Connection=true;database=databaseNamw"/>

</appSettings>

In database users --> Add ServerName\ASPNET account.

That will create trusted connection for the application.

|||

i did as you told me.but it occurs new error as follows:

" database" server of application error.

abnormity particular information: system.data.sqlclient.sqlexception"BUSA_QFDKDIEDKDJ" landing fail.

BUSA_QFDKDIEDKDJ is my server name.

|||

Hi,

I have made little web application to show you how to add user in DB with trusted connection. The DB backup is in the TestDB folder called DB backup. Make Virtual directory and browse it to TestDB folder and Restore backup in MyDB (Create it). Here is link

http://www.riseofkingdoms.com/TestDB.rar

Hope it will work. Change the server name in the string like

<appSettings>

<addkey="connectionstring"value="server=BUSA_QFDKDIEDKDJ;Trusted_Connection=true;database=MyDB"/>

</appSettings>

|||

Hi:

I change the server name ,but it doesn't work. and i am a new proqrammer,and dosen't know much, can you say easily.

|||

i use Query Decomposition to land with trusted connection,and it success.but why

it can't work in the asp.net

|||it occurs the same error.|||

Hi,

You might try checking your SQL Server - make sure you select 'Mixed' security which allows SQL Server login & password to substitute for a trusted connection.

Good luck!

|||

I change the security for 'mixed' security ,but it

occurs error: trusted connection failed.and mayby

sql server's error,because when i use Query Decomposition to land with sa and no password

,bbut it failed .what is wrong?could anyone help?

|||what's wrong ?could anyone help?|||

This problem may be due to the way you have defined your Shared Datasource. Have you stored the login Credentials or used the prompt for login option?

If you used the latter you might want to change to the store credentials option. Hope this helps

|||That's all right.Aftar I select 'Mixed' security ,I didn't restart the computer.