Sunday, February 26, 2012

Error in execute sql task

I get the following error when trying to execute an sql statement in oracle and returning the results into an object variable with the execute sql task.

Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "select <columnlist> from <tablename>" failed with the following error: "The SelectCommand property has not been initialized before calling 'Fill'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

It executes fine if I select no results or first row but I can't get full result set to work. The query and connection string are valid. Any ideas?

Hi,

Have you selected the "Full Result Set" in the ResultSet option? If so, then create a variable of datatype "Object" and link that variable in the ResultSet tab. In that, enter "0" in the Result Name and in the Variable Name, select the variable you created as Object.

Pls try this and let me know if you have any issues.

Sorry for the delayed response. I just gone thru this issue.

Prakash Srinivasan

|||I have the same issues with the Script task in the control flow. I have the result set to full and assigned to a datatype of object. I also have 0 for the name of the result set but it still give me the same error. " selectcommand was in initialized before Fill" It would be a paid to enter 300 column names in the script component in the data flow side just because this the Script task isnt work. I will be glad if someone could help me.|||

How are you doing this? The Script Task isn't really supposed to be used for extracting SQL data. Why does Execute SQL Task not work for you?

-Jamie

|||

I am pulling data through an ado.net connection connected to a DB/C 4 database (odbc database). I needed to pull data based on the last date run so i need a way to insert a date into my sql command where clause. I am using an expression to set the sqlcommand of the Script task to "select .....from tableA where timestamp > = " @.[datetime::mydate] ". I have the resultset set to Full result set. I also have my resultset variable as Object::rs_data and the name set to 0 for Full resultset. I still get the error so I am think its probably the fact that the script task does not work for ado.net odbc connnections.

|||

I am still left wondering why you are not doing this in an Execute SQL Task. And yet you say "I have the resultset set to Full result set." Are you really using a script task?

-Jamie

|||Sorry, i wasnt paying attention. I meant to say Execute SQL Task instead of Script task. With that said, is there any ideas for fixing the situation and once to assign a resultset to a variable. How do you use that resultset(variable) as datasource in a Data flow.|||Hi,
does anyone have the solution to the error:
The SelectCommand property has not been initialized before calling 'Fill'."
for Execute SQL Task problem? I am also stuck there...
Daren
|||

I'm facing the same problem while I'm extracting data from an "SQL Task" using a result set "full result set".

Also can someone tell me how to read the temp result set created by the SQL task ? The documentation found is very poor for a novice like me and doesn't explain how to read the System.Data.Dataset in order to feed a SQL server destination table.

Thanks

Error in execute sql task

I get the following error when trying to execute an sql statement in oracle and returning the results into an object variable with the execute sql task.

Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "select <columnlist> from <tablename>" failed with the following error: "The SelectCommand property has not been initialized before calling 'Fill'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

It executes fine if I select no results or first row but I can't get full result set to work. The query and connection string are valid. Any ideas?

Hi,

Have you selected the "Full Result Set" in the ResultSet option? If so, then create a variable of datatype "Object" and link that variable in the ResultSet tab. In that, enter "0" in the Result Name and in the Variable Name, select the variable you created as Object.

Pls try this and let me know if you have any issues.

Sorry for the delayed response. I just gone thru this issue.

Prakash Srinivasan

|||I have the same issues with the Script task in the control flow. I have the result set to full and assigned to a datatype of object. I also have 0 for the name of the result set but it still give me the same error. " selectcommand was in initialized before Fill" It would be a paid to enter 300 column names in the script component in the data flow side just because this the Script task isnt work. I will be glad if someone could help me.|||

How are you doing this? The Script Task isn't really supposed to be used for extracting SQL data. Why does Execute SQL Task not work for you?

-Jamie

|||

I am pulling data through an ado.net connection connected to a DB/C 4 database (odbc database). I needed to pull data based on the last date run so i need a way to insert a date into my sql command where clause. I am using an expression to set the sqlcommand of the Script task to "select .....from tableA where timestamp > = " @.[datetime::mydate] ". I have the resultset set to Full result set. I also have my resultset variable as Object::rs_data and the name set to 0 for Full resultset. I still get the error so I am think its probably the fact that the script task does not work for ado.net odbc connnections.

|||

I am still left wondering why you are not doing this in an Execute SQL Task. And yet you say "I have the resultset set to Full result set." Are you really using a script task?

-Jamie

|||Sorry, i wasnt paying attention. I meant to say Execute SQL Task instead of Script task. With that said, is there any ideas for fixing the situation and once to assign a resultset to a variable. How do you use that resultset(variable) as datasource in a Data flow.|||Hi,
does anyone have the solution to the error:
The SelectCommand property has not been initialized before calling 'Fill'."
for Execute SQL Task problem? I am also stuck there...
Daren
|||

I'm facing the same problem while I'm extracting data from an "SQL Task" using a result set "full result set".

Also can someone tell me how to read the temp result set created by the SQL task ? The documentation found is very poor for a novice like me and doesn't explain how to read the System.Data.Dataset in order to feed a SQL server destination table.

Thanks

Error in execute a scheduled package

I'm learning SSIS and ran into this error...

I have a package that has its source as an Oracle DB on another server. This package will feed data from that source to a SQL Server 2005 DB. So far, the package works fine if it is executed manually even in SQL Mgmt Studio. It's only failed when I tried it as a scheduled job. I guess I need to do "Package Configurations" which includes the UserID and password for accessing Oracle DB ... but I don't know how. Please help.

Regards,

dnncpt

-

Here is the error message:

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/08/2007 09:49:00,DataFeed,Error,0,<MyDBServer>,DataFeed,(Job outcome),,The job failed. The Job was invoked by Schedule 8 (Schedule DataFeed Grant Tables). The last step to run was step 1 (DataFeed Grant Tables).,00:00:02,0,0,,,,0
05/08/2007 09:49:00,DataFeed,Error,1,<MyDBServer>,DataFeed,DataFeed Grant Tables,,Executed as user: <MyDBServer>\SYSTEM. ....3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:49:00 AM Error: 2007-05-08 09:49:00.81 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSStick out tongueassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2007-05-08 09:49:01.86 Code: 0xC0202009 Source: AWARDS Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005: null password given; logon denied". End Error Error: 2007-05-08 09:49:01.86 Code: 0xC020801C Source: Feed data t... The package execution fa... The step failed.,00:00:02,0,0,,,,0

For the error, I think this link may be the answer:

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b904800

So the protection level is the reason.

I really love the Microsoft technologies but if MS could provide such a nice software like SQL Server and SSIS why its tech teams don't go a further step as to provide a good how-to document for each application. This could benefit for both MS and its customers. (hope Mr. Gates or Mr. Ballmer read this)

Regards,

dnncpt

Error in Event Viewer

I am having trouble backing up my SQL DBs using Retrospect software to a NAS
box. I am thinking this error might have something to do with it. What does
it mean? Thanks for any help!
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status: Failed -
Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not
obtain information about Windows NT group/user 'PULIZ04\Administrator'.
[SQLSTATE 42000] (Error 8198)).
The maintenance plan has been made with a user who probably doesn't exist
anymore.
You might try to edit the maintenance plan and use a user name and password
with full admin rights at
the database. Simply right click the maintenance plan and choose edit
properties. Within the properties it's possible to edit the user.
Regards,
Johan
"scottdog129" <scottdog129@.discussions.microsoft.com> schreef in bericht
news:6E7E1780-9C65-49F6-AFE1-088266C1920C@.microsoft.com...
> I am having trouble backing up my SQL DBs using Retrospect software to a
NAS
> box. I am thinking this error might have something to do with it. What
does
> it mean? Thanks for any help!
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status:
Failed -
> Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
> determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could
not
> obtain information about Windows NT group/user 'PULIZ04\Administrator'.
> [SQLSTATE 42000] (Error 8198)).
|||Yes, that is the resason for your backup failure. That happens now and then
and there are different causes and fixes. The best way is to avoid such a
problem by changing your job owner to a SQL login such as sa.
Gary
"scottdog129" <scottdog129@.discussions.microsoft.com> wrote in message
news:6E7E1780-9C65-49F6-AFE1-088266C1920C@.microsoft.com...
> I am having trouble backing up my SQL DBs using Retrospect software to a
NAS
> box. I am thinking this error might have something to do with it. What
does
> it mean? Thanks for any help!
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status:
Failed -
> Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
> determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could
not
> obtain information about Windows NT group/user 'PULIZ04\Administrator'.
> [SQLSTATE 42000] (Error 8198)).

Error in event viewer

I saw in the event viewer an error telling me that there are more than 8
connections and that the system performance could get worse.
It isn't a trouble with the number of licenses because there are more than
users.
What's happening?
Thank you very muchYou are running personal edition or MSDE and that is indeed performance
throttled after 5-8 users concurrently executing queries. As you see these
warnings, you see an indication that you will possibly benefit
performance-wise by installing a "proper" SQL Server, like Standard Edition
or Enterprise Edition.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Alberto" <alberto@.nospam.com> wrote in message
news:ewptdhkvDHA.3216@.TK2MSFTNGP11.phx.gbl...
> I saw in the event viewer an error telling me that there are more than 8
> connections and that the system performance could get worse.
> It isn't a trouble with the number of licenses because there are more than
> users.
> What's happening?
> Thank you very much
>

Error in Event Viewer

I am having trouble backing up my SQL DBs using Retrospect software to a NAS
box. I am thinking this error might have something to do with it. What doe
s
it mean? Thanks for any help!
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status: Failed -
Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not
obtain information about Windows NT group/user 'PULIZ04\Administrator'.
[SQLSTATE 42000] (Error 8198)).The maintenance plan has been made with a user who probably doesn't exist
anymore.
You might try to edit the maintenance plan and use a user name and password
with full admin rights at
the database. Simply right click the maintenance plan and choose edit
properties. Within the properties it's possible to edit the user.
Regards,
Johan
"scottdog129" <scottdog129@.discussions.microsoft.com> schreef in bericht
news:6E7E1780-9C65-49F6-AFE1-088266C1920C@.microsoft.com...
> I am having trouble backing up my SQL DBs using Retrospect software to a
NAS
> box. I am thinking this error might have something to do with it. What
does
> it mean? Thanks for any help!
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status:
Failed -
> Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
> determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could
not
> obtain information about Windows NT group/user 'PULIZ04\Administrator'.
> [SQLSTATE 42000] (Error 8198)).|||Yes, that is the resason for your backup failure. That happens now and then
and there are different causes and fixes. The best way is to avoid such a
problem by changing your job owner to a SQL login such as sa.
Gary
"scottdog129" <scottdog129@.discussions.microsoft.com> wrote in message
news:6E7E1780-9C65-49F6-AFE1-088266C1920C@.microsoft.com...
> I am having trouble backing up my SQL DBs using Retrospect software to a
NAS
> box. I am thinking this error might have something to do with it. What
does
> it mean? Thanks for any help!
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status:
Failed -
> Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
> determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could
not
> obtain information about Windows NT group/user 'PULIZ04\Administrator'.
> [SQLSTATE 42000] (Error 8198)).

Error In Event Viewer

Hi I am getting the following error:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 4/14/2004
Time: 09:32:05 AM
User: SYSTEM
Computer: BSEW2k01
Description:
Error: 50000, Severity: 5, State: 1
Error Calling StatusToStreet In DCS0 Code 7202

Please help.

ThanksThe error doesn't seems to be a system generated as its a user-defined from the application, check the vendor for that application.|||And I would venture to say that

StatusToStreet

Is the sproc and

DCS0

Is the database

Error in Event Viewer

I am having trouble backing up my SQL DBs using Retrospect software to a NAS
box. I am thinking this error might have something to do with it. What does
it mean? Thanks for any help!
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status: Failed -
Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not
obtain information about Windows NT group/user 'PULIZ04\Administrator'.
[SQLSTATE 42000] (Error 8198)).The maintenance plan has been made with a user who probably doesn't exist
anymore.
You might try to edit the maintenance plan and use a user name and password
with full admin rights at
the database. Simply right click the maintenance plan and choose edit
properties. Within the properties it's possible to edit the user.
Regards,
Johan
"scottdog129" <scottdog129@.discussions.microsoft.com> schreef in bericht
news:6E7E1780-9C65-49F6-AFE1-088266C1920C@.microsoft.com...
> I am having trouble backing up my SQL DBs using Retrospect software to a
NAS
> box. I am thinking this error might have something to do with it. What
does
> it mean? Thanks for any help!
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status:
Failed -
> Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
> determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could
not
> obtain information about Windows NT group/user 'PULIZ04\Administrator'.
> [SQLSTATE 42000] (Error 8198)).|||Yes, that is the resason for your backup failure. That happens now and then
and there are different causes and fixes. The best way is to avoid such a
problem by changing your job owner to a SQL login such as sa.
Gary
"scottdog129" <scottdog129@.discussions.microsoft.com> wrote in message
news:6E7E1780-9C65-49F6-AFE1-088266C1920C@.microsoft.com...
> I am having trouble backing up my SQL DBs using Retrospect software to a
NAS
> box. I am thinking this error might have something to do with it. What
does
> it mean? Thanks for any help!
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status:
Failed -
> Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
> determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could
not
> obtain information about Windows NT group/user 'PULIZ04\Administrator'.
> [SQLSTATE 42000] (Error 8198)).

error in event log

running windows 2003 server, Sql 2000 sp3 and WSS 2.0. I have been getting
the following error. Any ideas on hot to fix it? Also sometimes I cant
connect to the DB using sql mamanger but if I restart the db I can connect.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/9/2004
Time: 3:10:58 PM
User: NA\SqlServerAccount
Computer: CINSQLWSS1
Description:
Error: 17803, Severity: 20, State: 12
Insufficient memory available.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 8b 45 00 00 14 00 00 00 ?E.....
0008: 0b 00 00 00 43 00 49 00 ...C.I.
0010: 4e 00 53 00 51 00 4c 00 N.S.Q.L.
0018: 57 00 53 00 53 00 31 00 W.S.S.1.
0020: 00 00 1a 00 00 00 53 00 .....S.
0028: 54 00 53 00 5f 00 63 00 T.S._.c.
0030: 69 00 6e 00 73 00 71 00 i.n.s.q.
0038: 6c 00 77 00 73 00 73 00 l.w.s.s.
0040: 31 00 5f 00 31 00 35 00 1._.1.5.
0048: 30 00 37 00 32 00 35 00 0.7.2.5.
0050: 31 00 38 00 39 00 33 00 1.8.9.3.
0058: 00 00 ..17803 indicates that you are having memory pressure. Depending on what the
SQL error logs say, the pressure could be in the main area (Buffer pool) or
the MemToLeave area.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

error in event log

running windows 2003 server, Sql 2000 sp3 and WSS 2.0. I have been getting
the following error. Any ideas on hot to fix it? Also sometimes I cant
connect to the DB using sql mamanger but if I restart the db I can connect.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/9/2004
Time: 3:10:58 PM
User: NA\SqlServerAccount
Computer: CINSQLWSS1
Description:
Error: 17803, Severity: 20, State: 12
Insufficient memory available.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 8b 45 00 00 14 00 00 00 E.....
0008: 0b 00 00 00 43 00 49 00 ...C.I.
0010: 4e 00 53 00 51 00 4c 00 N.S.Q.L.
0018: 57 00 53 00 53 00 31 00 W.S.S.1.
0020: 00 00 1a 00 00 00 53 00 .....S.
0028: 54 00 53 00 5f 00 63 00 T.S._.c.
0030: 69 00 6e 00 73 00 71 00 i.n.s.q.
0038: 6c 00 77 00 73 00 73 00 l.w.s.s.
0040: 31 00 5f 00 31 00 35 00 1._.1.5.
0048: 30 00 37 00 32 00 35 00 0.7.2.5.
0050: 31 00 38 00 39 00 33 00 1.8.9.3.
0058: 00 00 ..
17803 indicates that you are having memory pressure. Depending on what the
SQL error logs say, the pressure could be in the main area (Buffer pool) or
the MemToLeave area.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

error in event log

running windows 2003 server, Sql 2000 sp3 and WSS 2.0. I have been getting
the following error. Any ideas on hot to fix it? Also sometimes I cant
connect to the DB using sql mamanger but if I restart the db I can connect.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/9/2004
Time: 3:10:58 PM
User: NA\SqlServerAccount
Computer: CINSQLWSS1
Description:
Error: 17803, Severity: 20, State: 12
Insufficient memory available.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 8b 45 00 00 14 00 00 00 E.....
0008: 0b 00 00 00 43 00 49 00 ...C.I.
0010: 4e 00 53 00 51 00 4c 00 N.S.Q.L.
0018: 57 00 53 00 53 00 31 00 W.S.S.1.
0020: 00 00 1a 00 00 00 53 00 .....S.
0028: 54 00 53 00 5f 00 63 00 T.S._.c.
0030: 69 00 6e 00 73 00 71 00 i.n.s.q.
0038: 6c 00 77 00 73 00 73 00 l.w.s.s.
0040: 31 00 5f 00 31 00 35 00 1._.1.5.
0048: 30 00 37 00 32 00 35 00 0.7.2.5.
0050: 31 00 38 00 39 00 33 00 1.8.9.3.
0058: 00 00 ..17803 indicates that you are having memory pressure. Depending on what the
SQL error logs say, the pressure could be in the main area (Buffer pool) or
the MemToLeave area.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

error in Enterprise Manager while returning all or few rows.

Hi, Everyone
I use SQL Server Enterprise Manager to access DB server.
I can connect and see the tables fine. But when i tried
to open table returen all rows or open design table, I
got an error saying:
An unexpected error happend during this operation.
[MS Desgin Tools] -- Not enough storage is available to
complete this operation.
Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
Thanks
Adi ..adi wrote:
> Hi, Everyone
> I use SQL Server Enterprise Manager to access DB server.
> I can connect and see the tables fine. But when i tried
> to open table returen all rows or open design table, I
> got an error saying:
> An unexpected error happend during this operation.
> [MS Desgin Tools] -- Not enough storage is available to
> complete this operation.
> Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> Thanks
> Adi ..
>
Don't use Enterprise Manager to view or modify data - use Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I appreciate your advice. But what I am looking for is a solution for the
problem I mentioned.
"Tracy McKibben" wrote:
> adi wrote:
> > Hi, Everyone
> >
> > I use SQL Server Enterprise Manager to access DB server.
> > I can connect and see the tables fine. But when i tried
> > to open table returen all rows or open design table, I
> > got an error saying:
> >
> > An unexpected error happend during this operation.
> > [MS Desgin Tools] -- Not enough storage is available to
> > complete this operation.
> >
> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> >
> > Thanks
> > Adi ..
> >
> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||adi wrote:
> I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
>
Start reading:
http://www.google.com/search?q=%22enterprise+manager%22+%22Not+enough+storage+is+available+to%22
You could avoid the whole mess by using the proper tools, i.e. using
Query Analyzer instead of Enterprise Manager.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Adi,
The nature of the problem mentioned is using the wrong tool for the job.
Enterprise Manager is NOT the 'right' tool to use for table alteration, data
manipulation, or, as you noticed, even viewing large amounts of data.
Tracy's advise is good advise. Continuing to use EM sets you up for
numerous, as of yet, inexperienced, problems -of which this is just the tip
of the iceberg.
Your question is like asking how to hammer a nail with a screwdriver. And
when someone mentions that a hammer would be better, your response is like
saying "I don't care, I am going to hammer the nail with the screwdriver."
You won't find many skilled SQL Server folks actively encouraging or
abetting the use of Enterprise Mangler.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"adi" <adi@.discussions.microsoft.com> wrote in message
news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
>I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
> "Tracy McKibben" wrote:
>> adi wrote:
>> > Hi, Everyone
>> >
>> > I use SQL Server Enterprise Manager to access DB server.
>> > I can connect and see the tables fine. But when i tried
>> > to open table returen all rows or open design table, I
>> > got an error saying:
>> >
>> > An unexpected error happend during this operation.
>> > [MS Desgin Tools] -- Not enough storage is available to
>> > complete this operation.
>> >
>> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
>> >
>> > Thanks
>> > Adi ..
>> >
>> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com|||Arnie,
Now, I'm not against your advice or anyones for that matter. In fact that's
what we are looking for through these forums. I agree with what you said as
I've been managing SQL Servers since v6.5 days. But if I come accross this
problem and google or MS KB not being able to shortlist the problem
resolution then my search is always for the possible answer to the question.
Thanks again for your wise words. have a good day.
Adi ..
"Arnie Rowland" wrote:
> Adi,
> The nature of the problem mentioned is using the wrong tool for the job.
> Enterprise Manager is NOT the 'right' tool to use for table alteration, data
> manipulation, or, as you noticed, even viewing large amounts of data.
> Tracy's advise is good advise. Continuing to use EM sets you up for
> numerous, as of yet, inexperienced, problems -of which this is just the tip
> of the iceberg.
> Your question is like asking how to hammer a nail with a screwdriver. And
> when someone mentions that a hammer would be better, your response is like
> saying "I don't care, I am going to hammer the nail with the screwdriver."
> You won't find many skilled SQL Server folks actively encouraging or
> abetting the use of Enterprise Mangler.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "adi" <adi@.discussions.microsoft.com> wrote in message
> news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
> >I appreciate your advice. But what I am looking for is a solution for the
> > problem I mentioned.
> >
> > "Tracy McKibben" wrote:
> >
> >> adi wrote:
> >> > Hi, Everyone
> >> >
> >> > I use SQL Server Enterprise Manager to access DB server.
> >> > I can connect and see the tables fine. But when i tried
> >> > to open table returen all rows or open design table, I
> >> > got an error saying:
> >> >
> >> > An unexpected error happend during this operation.
> >> > [MS Desgin Tools] -- Not enough storage is available to
> >> > complete this operation.
> >> >
> >> > Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> >> >
> >> > Thanks
> >> > Adi ..
> >> >
> >>
> >> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
> >>
> >>
> >> --
> >> Tracy McKibben
> >> MCDBA
> >> http://www.realsqlguy.com
> >>
>
>

error in Enterprise Manager while returning all or few rows.

Hi, Everyone
I use SQL Server Enterprise Manager to access DB server.
I can connect and see the tables fine. But when i tried
to open table returen all rows or open design table, I
got an error saying:
An unexpected error happend during this operation.
[MS Desgin Tools] -- Not enough storage is available to
complete this operation.
Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
Thanks
Adi ..adi wrote:
> Hi, Everyone
> I use SQL Server Enterprise Manager to access DB server.
> I can connect and see the tables fine. But when i tried
> to open table returen all rows or open design table, I
> got an error saying:
> An unexpected error happend during this operation.
> [MS Desgin Tools] -- Not enough storage is available to
> complete this operation.
> Any idea how to fix this? This is SQL2K SP4 on WIN2K SP4.
> Thanks
> Adi ..
>
Don't use Enterprise Manager to view or modify data - use Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I appreciate your advice. But what I am looking for is a solution for the
problem I mentioned.
"Tracy McKibben" wrote:

> adi wrote:
> Don't use Enterprise Manager to view or modify data - use Query Analyzer.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||adi wrote:
> I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
>
Start reading:
http://www.google.com/search? q=%22...
vailable+to%22
You could avoid the whole mess by using the proper tools, i.e. using
Query Analyzer instead of Enterprise Manager.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Adi,
The nature of the problem mentioned is using the wrong tool for the job.
Enterprise Manager is NOT the 'right' tool to use for table alteration, data
manipulation, or, as you noticed, even viewing large amounts of data.
Tracy's advise is good advise. Continuing to use EM sets you up for
numerous, as of yet, inexperienced, problems -of which this is just the tip
of the iceberg.
Your question is like asking how to hammer a nail with a screwdriver. And
when someone mentions that a hammer would be better, your response is like
saying "I don't care, I am going to hammer the nail with the screwdriver."
You won't find many skilled SQL Server folks actively encouraging or
abetting the use of Enterprise Mangler.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"adi" <adi@.discussions.microsoft.com> wrote in message
news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...[vbcol=seagreen]
>I appreciate your advice. But what I am looking for is a solution for the
> problem I mentioned.
> "Tracy McKibben" wrote:
>|||Arnie,
Now, I'm not against your advice or anyones for that matter. In fact that's
what we are looking for through these forums. I agree with what you said as
I've been managing SQL Servers since v6.5 days. But if I come accross this
problem and google or MS KB not being able to shortlist the problem
resolution then my search is always for the possible answer to the question.
Thanks again for your wise words. have a good day.
Adi ..
"Arnie Rowland" wrote:

> Adi,
> The nature of the problem mentioned is using the wrong tool for the job.
> Enterprise Manager is NOT the 'right' tool to use for table alteration, da
ta
> manipulation, or, as you noticed, even viewing large amounts of data.
> Tracy's advise is good advise. Continuing to use EM sets you up for
> numerous, as of yet, inexperienced, problems -of which this is just the ti
p
> of the iceberg.
> Your question is like asking how to hammer a nail with a screwdriver. And
> when someone mentions that a hammer would be better, your response is like
> saying "I don't care, I am going to hammer the nail with the screwdriver."
> You won't find many skilled SQL Server folks actively encouraging or
> abetting the use of Enterprise Mangler.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "adi" <adi@.discussions.microsoft.com> wrote in message
> news:4BFDAB54-4ED5-48C7-A19A-2CEAFBA31E02@.microsoft.com...
>
>

Error in Enterprise Manager

Hi,
I have SQL Server Developer edition running on Windows XP, and when I open
SQL Enterprise manager and right click on any table on the master database
and select "Open Table" and then "Return all Rows" i got this error:
"An unexpected error occurred during this operation"...
Any ideas how to troubleshoot this issue is highly welcomed!
Thanks a lot!
Hi
You may want to try and re-install the client tools!
If you want to see the SQL then use profiler to capture it.
John
"martino" wrote:

> Hi,
> I have SQL Server Developer edition running on Windows XP, and when I open
> SQL Enterprise manager and right click on any table on the master database
> and select "Open Table" and then "Return all Rows" i got this error:
> "An unexpected error occurred during this operation"...
> Any ideas how to troubleshoot this issue is highly welcomed!
> Thanks a lot!
>

Error in Enterprise Manager

In Enterprise Manager, when I expand the objects and click on the database
object for my live system I get the following error message:
Title bar: "Internet Explorer Script Error"
An error has occurred in the script on this page.
Line: 307
Char: 2
Error: Unspecified error.
Code: 0
URL:
res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Too ls\Binn\Resources\1033\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?
Yes/NO.
Whether I press Yes or No the right pane say the database is undefined.
All other database work fine and the system seems to be running fine.
Any Ideas?
Dan
Is this in the taskpad view? If so, it happens to me a lot. A
workaround is to change the View to Large icons, Small icons, or
something besides taskpad. Then close EM, then open it back, and you
can then change the view back to taskpad. Not exactly sure why it
happens.
DG wrote:
> In Enterprise Manager, when I expand the objects and click on the database
> object for my live system I get the following error message:
> Title bar: "Internet Explorer Script Error"
> An error has occurred in the script on this page.
> Line: 307
> Char: 2
> Error: Unspecified error.
> Code: 0
> URL:
> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Too ls\Binn\Resources\1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?
> Yes/NO.
> Whether I press Yes or No the right pane say the database is undefined.
> All other database work fine and the system seems to be running fine.
> Any Ideas?
> Dan
|||That did not work. I don't know what taskpad view is, but I changed view to
small icons then exited EM. Then re-opened EM and change back to Large
Icons, then open all objects and clickd on the database and got the same
error.
Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegr oups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>
|||I see the taskpad now...duh.
That worked the second time.
Thanks, Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegr oups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>
|||Sorry that didn't work for you - I searched briefly and got several
other responses similar to mine... here's one...
http://www.sqlnewsgroups.net/group/m...topic4742.aspx
If this doesn't work, then I'm not sure....

Error in Enterprise Manager

In Enterprise Manager, when I expand the objects and click on the database
object for my live system I get the following error message:
Title bar: "Internet Explorer Script Error"
An error has occurred in the script on this page.
Line: 307
Char: 2
Error: Unspecified error.
Code: 0
URL:
res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?
Yes/NO.
Whether I press Yes or No the right pane say the database is undefined.
All other database work fine and the system seems to be running fine.
Any Ideas?
DanIs this in the taskpad view? If so, it happens to me a lot. A
workaround is to change the View to Large icons, Small icons, or
something besides taskpad. Then close EM, then open it back, and you
can then change the view back to taskpad. Not exactly sure why it
happens.
DG wrote:
> In Enterprise Manager, when I expand the objects and click on the database
> object for my live system I get the following error message:
> Title bar: "Internet Explorer Script Error"
> An error has occurred in the script on this page.
> Line: 307
> Char: 2
> Error: Unspecified error.
> Code: 0
> URL:
> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?
> Yes/NO.
> Whether I press Yes or No the right pane say the database is undefined.
> All other database work fine and the system seems to be running fine.
> Any Ideas?
> Dan|||That did not work. I don't know what taskpad view is, but I changed view to
small icons then exited EM. Then re-opened EM and change back to Large
Icons, then open all objects and clickd on the database and got the same
error.
Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegroups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>> In Enterprise Manager, when I expand the objects and click on the
>> database
>> object for my live system I get the following error message:
>> Title bar: "Internet Explorer Script Error"
>> An error has occurred in the script on this page.
>> Line: 307
>> Char: 2
>> Error: Unspecified error.
>> Code: 0
>> URL:
>> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
>> Do you want to continue running scripts on this page?
>> Yes/NO.
>> Whether I press Yes or No the right pane say the database is undefined.
>> All other database work fine and the system seems to be running fine.
>> Any Ideas?
>> Dan
>|||I see the taskpad now...duh.
That worked the second time.
Thanks, Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegroups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>> In Enterprise Manager, when I expand the objects and click on the
>> database
>> object for my live system I get the following error message:
>> Title bar: "Internet Explorer Script Error"
>> An error has occurred in the script on this page.
>> Line: 307
>> Char: 2
>> Error: Unspecified error.
>> Code: 0
>> URL:
>> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
>> Do you want to continue running scripts on this page?
>> Yes/NO.
>> Whether I press Yes or No the right pane say the database is undefined.
>> All other database work fine and the system seems to be running fine.
>> Any Ideas?
>> Dan
>|||Sorry that didn't work for you - I searched briefly and got several
other responses similar to mine... here's one...
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic4742.aspx
If this doesn't work, then I'm not sure....

Error in Enterprise Manager

Hi,
I have SQL Server Developer edition running on Windows XP, and when I open
SQL Enterprise manager and right click on any table on the master database
and select "Open Table" and then "Return all Rows" i got this error:
"An unexpected error occurred during this operation"...
Any ideas how to troubleshoot this issue is highly welcomed!
Thanks a lot!Hi
You may want to try and re-install the client tools!
If you want to see the SQL then use profiler to capture it.
John
"martino" wrote:
> Hi,
> I have SQL Server Developer edition running on Windows XP, and when I open
> SQL Enterprise manager and right click on any table on the master database
> and select "Open Table" and then "Return all Rows" i got this error:
> "An unexpected error occurred during this operation"...
> Any ideas how to troubleshoot this issue is highly welcomed!
> Thanks a lot!
>

Error in Enterprise Manager

In Enterprise Manager, when I expand the objects and click on the database
object for my live system I get the following error message:
Title bar: "Internet Explorer Script Error"
An error has occurred in the script on this page.
Line: 307
Char: 2
Error: Unspecified error.
Code: 0
URL:
res:// C:\Program%20Files\Microsoft%20SQL%20Ser
ver\80\Tools\Binn\Resources\10
33\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?
Yes/NO.
Whether I press Yes or No the right pane say the database is undefined.
All other database work fine and the system seems to be running fine.
Any Ideas?
DanIs this in the taskpad view? If so, it happens to me a lot. A
workaround is to change the View to Large icons, Small icons, or
something besides taskpad. Then close EM, then open it back, and you
can then change the view back to taskpad. Not exactly sure why it
happens.
DG wrote:
> In Enterprise Manager, when I expand the objects and click on the database
> object for my live system I get the following error message:
> Title bar: "Internet Explorer Script Error"
> An error has occurred in the script on this page.
> Line: 307
> Char: 2
> Error: Unspecified error.
> Code: 0
> URL:
> res:// C:\Program%20Files\Microsoft%20SQL%20Ser
ver\80\Tools\Binn\Resources\
1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?
> Yes/NO.
> Whether I press Yes or No the right pane say the database is undefined.
> All other database work fine and the system seems to be running fine.
> Any Ideas?
> Dan|||That did not work. I don't know what taskpad view is, but I changed view to
small icons then exited EM. Then re-opened EM and change back to Large
Icons, then open all objects and clickd on the database and got the same
error.
Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegroups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>|||I see the taskpad now...duh.
That worked the second time.
Thanks, Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegroups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>|||Sorry that didn't work for you - I searched briefly and got several
other responses similar to mine... here's one...
http://www.sqlnewsgroups.net/group/...42.asp
x
If this doesn't work, then I'm not sure....

Error in Enterprise Manager

Hi,
I have SQL Server Developer edition running on Windows XP, and when I open
SQL Enterprise manager and right click on any table on the master database
and select "Open Table" and then "Return all Rows" i got this error:
"An unexpected error occurred during this operation"...
Any ideas how to troubleshoot this issue is highly welcomed!
Thanks a lot!Hi
You may want to try and re-install the client tools!
If you want to see the SQL then use profiler to capture it.
John
"martino" wrote:

> Hi,
> I have SQL Server Developer edition running on Windows XP, and when I open
> SQL Enterprise manager and right click on any table on the master database
> and select "Open Table" and then "Return all Rows" i got this error:
> "An unexpected error occurred during this operation"...
> Any ideas how to troubleshoot this issue is highly welcomed!
> Thanks a lot!
>

error in EM

When I click on property of Db in EM on a sql server EM
quit.
I have installed the sp3 recently.
Anyone has the same problem?
How to fix?
Thank you
Have you tried installing the security patch MS03-031? It
includes a fix for an issue similar to what you are
describing. You can find more details in the following
article:
http://support.microsoft.com/?id=814113
-Sue
On Mon, 11 Oct 2004 09:24:46 -0700, "Gianluca Danielli"
<gianluca.danielli@.tin.it> wrote:

>When I click on property of Db in EM on a sql server EM
>quit.
>I have installed the sp3 recently.
>Anyone has the same problem?
>How to fix?
>Thank you

Error in Dynamic SQL.....help!!

Can someone please help me in troubleshooting the code below. I have a table called credit_app_table_status which is based on the following create statement:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[credit_app_table_status]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[credit_app_table_status]
GO

CREATE TABLE [dbo].[credit_app_table_status] (
[table_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[bill_period_start] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[bill_period_end] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

When I run the code below, it gives me the following error message. I have tried to change the data types of bill_period_start and bill_period_end apart from changing the code, but it doesn't work. Instead of @.bill_period_start and @.bill_period_end, if I have actual dates, it works. Can someone pleaseeeee help.

/* Error Message
Server: Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '1'.
Server: Msg 156, Level 15, State 1, Line 27
Incorrect syntax near the keyword 'and'.
*/

--Code

Declare
@.SQL VarChar(2000),
@.tablename varchar (20),
@.bill_period_start varchar (20),
@.bill_period_end varchar (20)

SELECT @.tablename = table_name from credit_app_table_status
SELECT @.bill_period_start = bill_period_start from credit_app_table_status
SELECT @.bill_period_end = bill_period_end from credit_app_table_status

SELECT @.SQL = 'insert into ' + @.TableName + ' (
bill_period_begin,
bill_period_end,
org_id,
bill_type_cn,
qty,
rate,
total_amt,
add_user_id,
add_date
)
select '
+ @.bill_period_start +
','
+ @.bill_period_end +
',
a.org_id,
14,
sum(a.orders)as qty,
-.75 as rate,
sum(a.orders) * -.75,
1493,
getdate()
from cph..tblPkgFlatDaily a
where a.priority_cn = 0
and a.org_id in
(select org_id
from csorg_ins_group where
group_type_cn not in (7,8,9,10)
)
and a.ship_date between '
+ @.bill_period_start +
' and '
+ @.bill_period_end +
'group by a.org_id order by a.org_id'

Exec ( @.SQL)

GO+ @.bill_period_end +
'group by a.org_id order by a.org_id'


Exec ( @.SQL)

GO
It looks like your group by does not have a space preceeding it.

In your testing, why don't you select @.sql and view it first, and then when it looks good try the execution?|||It looks like your group by does not have a space preceeding it.

In your testing, why don't you select @.sql and view it first, and then when it looks good try the execution?
Thanks for the information Tomh3. The problem that I saw was that
@.bill_period_start and @.bill_period_end didn't have the single quotes such as in:
'Sep 1 2004 12:00AM'. Can you please let me know how I can get single quotes in @.bill_period_start and @.bill_period_end.

Thank you so much!!

Below is the code I received using select @.sql:

insert into csorg_billing_flash
(bill_period_begin,
bill_period_end,
org_id,
bill_type_cn,
qty,
rate,
total_amt,
add_user_id,
add_date)
select
Sep 1 2004 12:00AM,
Oct 31 2004 12:00AM ,
a.org_id,
14,
sum(a.orders)as qty,
-.75 as rate,
sum(a.orders) * -.75,
1493,
getdate()
from cph..tblPkgFlatDaily a
where a.priority_cn = 0
and a.org_id in
(select org_id
from csorg_ins_group
where group_type_cn not in (7,8,9,10)
)
and a.ship_date between
Sep 1 2004 12:00AM and Oct 31 2004 12:00AM
group by a.org_id
order by a.org_id|||DECLARE @.bill_period_start datetime
SELECT @.bill_period_start = 'Sep 1 2004 12:00AM'
SELECT ''''+CONVERT(varchar(25),@.bill_period_start)+''''|||Thanks for the reply, Brett.

I think I am very close to getting query in shape. However, when I use
SELECT @.bill_period_start = ''''+CONVERT(varchar(25),@.bill_period_start)+''''

I receive the following error:
Server: Msg 241, Level 16, State 1, Line 24
Syntax error converting datetime from character string.

I will really appreciate if you could please help in troubleshooting this piece of code:

Declare
@.SQL VarChar(2000),
@.tablename varchar (20),
@.bill_period_start datetime,
@.bill_period_end datetime

SELECT @.tablename = table_name from credit_app_table_status
SELECT @.bill_period_start = ''''+CONVERT(varchar(25),@.bill_period_start)+'''' from credit_app_table_status
SELECT @.bill_period_end = ''''+CONVERT(varchar(25),@.bill_period_end)+'''' from credit_app_table_status

SELECT @.SQL = 'insert into ' + @.TableName + ' (
bill_period_begin,
bill_period_end,
org_id,
bill_type_cn,
qty,
rate,
total_amt,
add_user_id,
add_date
)
select '
+ @.bill_period_start +
', '
+ @.bill_period_end +
',
a.org_id,
14,
sum(a.orders)as qty,
-.75 as rate,
sum(a.orders) * -.75,
1493,
getdate()
from cph..tblPkgFlatDaily a
where a.priority_cn = 0
and a.org_id in
(select org_id
from csorg_ins_group where
group_type_cn not in (7,8,9,10)
)
and a.ship_date between '
+ @.bill_period_start +
'and '
+ @.bill_period_end +
'group by a.org_id order by a.org_id'

SELECT (@.SQL)

GO|||Thanks for the reply, Brett.

I think I am very close to getting query in shape. However, when I use
SELECT @.bill_period_start = ''''+CONVERT(varchar(25),@.bill_period_start)+''''

I receive the following error:
Server: Msg 241, Level 16, State 1, Line 24
Syntax error converting datetime from character string.

I will really appreciate if you could please help in troubleshooting this piece of code:

SELECT @.tablename = table_name from credit_app_table_status
SELECT @.bill_period_start = ''''+CONVERT(varchar(25),@.bill_period_start)+'''' from credit_app_table_status
SELECT @.bill_period_end = ''''+CONVERT(varchar(25),@.bill_period_end)+'''' from credit_app_table_status


Oh so close. Try this

SELECT @.bill_period_start = ''''+CONVERT(varchar(25),@.bill_period_start,120)+' ''' from credit_app_table_status
SELECT @.bill_period_end = ''''+CONVERT(varchar(25),@.bill_period_end,120)+''' ' from credit_app_table_status

That will force the string into yyyy-mm-dd format instead of the default presentation format you showed us in the previous output.

And don't forget to keep Brett's additional apostrophes.

FYI, when I do something like this I create a variable named @.apos and populate it with a single apostrophe. So my string concatenation would read like ... + @.apos + @.string_variable + @.apos + ... it makes it easier for me to separate double apostrophe ('') from quote(").|||Oh so close. Try this

SELECT @.bill_period_start = ''''+CONVERT(varchar(25),@.bill_period_start,120)+' ''' from credit_app_table_status
SELECT @.bill_period_end = ''''+CONVERT(varchar(25),@.bill_period_end,120)+''' ' from credit_app_table_status

That will force the string into yyyy-mm-dd format instead of the default presentation format you showed us in the previous output.

And don't forget to keep Brett's additional apostrophes.

FYI, when I do something like this I create a variable named @.apos and populate it with a single apostrophe. So my string concatenation would read like ... + @.apos + @.string_variable + @.apos + ... it makes it easier for me to separate double apostrophe ('') from quote(").
Sorry, but I am still getting the same error message. Also I tried to run it having an apostrophe around @.bill_period_start and @.bill_period_end and still it doesn't work.
For example:

+ ' @.bill_period_start ' +
'and '
+ ' @.bill_period_end ' +|||SELECT @.bill_period_start = ''''+CONVERT(varchar(25),@.bill_period_start)+''''

I receive the following error:
Server: Msg 241, Level 16, State 1, Line 24
Syntax error converting datetime from character string.

That doesn't make sense...

Can you post the DDL of the Table...

And do this as well...

SELECT * FROM cph..tblPkgFlatDaily
WHERE ISNULL(ship_date)=0

If you get anything back from that, you have data problems...|||--Here is the DDL for credit_app_table_status

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[credit_app_table_status]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[credit_app_table_status]
GO

CREATE TABLE [dbo].[credit_app_table_status] (
[table_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[bill_period_start] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[bill_period_end] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

--Here is the DDL for tblPkgFlatDaily

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblPkgFlatDaily]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblPkgFlatDaily]
GO

CREATE TABLE [dbo].[tblPkgFlatDaily] (
[org_id] [int] NULL ,
[Orders] [int] NULL ,
[priority_cn] [int] NOT NULL ,
[ship_date] [datetime] NULL
) ON [PRIMARY]
GO|||SELECT @.bill_period_start = ''''+CONVERT(varchar(25),@.bill_period_start)+''''

I receive the following error:
Server: Msg 241, Level 16, State 1, Line 24
Syntax error converting datetime from character string.

That doesn't make sense...

Can you post the DDL of the Table...

And do this as well...

SELECT * FROM cph..tblPkgFlatDaily
WHERE ISNULL(ship_date)=0

If you get anything back from that, you have data problems...
--Here is the DDL for credit_app_table_status

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[credit_app_table_status]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[credit_app_table_status]
GO

CREATE TABLE [dbo].[credit_app_table_status] (
[table_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[bill_period_start] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[bill_period_end] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

--Here is the DDL for tblPkgFlatDaily

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblPkgFlatDaily]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblPkgFlatDaily]
GO

CREATE TABLE [dbo].[tblPkgFlatDaily] (
[org_id] [int] NULL ,
[Orders] [int] NULL ,
[priority_cn] [int] NOT NULL ,
[ship_date] [datetime] NULL
) ON [PRIMARY]
GO

Error in DTS

Hi When I try to convert from Prervasive V8 to SQL using an ODBC connection. I receive the error message..

ParseDisplayName failed: The specified module could not be found.

Could anyone advise what this error is? And/Or how it could be resloved. This is happing when I press actualy try to convert. The wizard will go to that point then stop.

Thanks!

DTS or SSIS? This is an SSIS forum. For DTS questions, please visit:

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

Error in DMX query

Hi

I have the following query used to predict the values in 2006 based on cluster model built using 2004 and 2005 data. I'm using a prediction join on a cube containing the data. I can join a single dimension from the cube to a column in a the data mining model. However when I try to join to a column in a nested table I get this error:

Executing the query ...

Obtained object of type: Microsoft.AnalysisServices.AdomdClient.AdomdDataReader

Internal error: An unexpected exception occured.

Execution complete

The query I'm running is this

select t.*

, Predict([Time].[Deal Count])as predicted_deal_count

, Predict([Time].[Deal Revenue])as predicted_deal_revenue

, Cluster()

From

[Time]

prediction join

(

select {[Measures].[Deal Count], [Measures].[Deal Revenue]} on 0,

non empty {{[Time].[Month Number Of Year].[Month Number Of Year].members} *

{[Country].[KeyCountry].[KeyCountry].members} * {[Country].[Region].[Region].members}} on 1

from [DM]

where ([Time].[Year].&[2006-01-01T00:00:00])) as t

on

[Time].[Month Number Of Year] = t.[[Time]].[Month Number Of Year]].[Month Number Of Year]].[MEMBER_CAPTION]]]

and [Time].[Country].[KeyCountry] = t.[[Country]].[KeyCountry]].[KeyCountry]].[MEMBER_CAPTION]]]

and [Time].[Country].[Region] = t.[[Country]].[Region]].[Region]].[MEMBER_CAPTION]]]

I'm running SQL Server 2005 with SP2 CTP2.

Thanks

Sanjay

Given the limited error message - we need to try additional queries to see if we can narrow the problem down. Alternatively, you could send us a backup of your database - let me know if this is an option.

Can you see if this query works? Does it return what you expect?

select t.*

From

[Time]

NATURAL prediction join

(

select {[Measures].[Deal Count], [Measures].[Deal Revenue]} on 0,

non empty {{[Time].[Month Number Of Year].[Month Number Of Year].members} *

{[Country].[KeyCountry].[KeyCountry].members} * {[Country].[Region].[Region].members}} on 1

from [DM]

where ([Time].[Year].&[2006-01-01T00:00:00])) as t

|||

Hi,

Your query works as expected, all the selected data from the cube is return. It would be possible to send you the cube offline, do you need the just the cube or the relational db as well?

Thanks

Sanjay

|||

A backup of AS database with the cube and model is enough. Please remove any additional objects (e.g. cubes or mining structures) to reduce the database size. You can also do a process clear structure only on the Mining Structure to reduce the size even further. Try compressing it as well (although it should be compressed already).

You can send the data to jamie "at" sqlserverdatamining.com and we'll look into the issue

Thanks!

|||We are still looking into this issue - thanks for your patience.

Error in Distribution Clean Up Agent

Server 1 SQL 2000 (SP4) Distributor, Publisher
Server 2 SQL 2000 (SP4) Subscriber
Transactional Replication set up between Server 1 and 2.
All the agents are running successfully (Log Reader, Snapshot, Other
Miscellenaous agent...except the Distribution Clean Up Agent
error
Executed as user: COOP\sqladmin. Could not remove directory
'\\ALXCONTGC\ReplData\unc\ALXCONTGC_sales_Pub_Alxo ffc_Anualtrans\20061119100406\'.
Check the security context of xp_cmdshell and close other processes
that may be accessing the directory. [SQLSTATE 42000] (Error 20015)
Replication-@.rowcount_only parameter must be the value 0,1, or 2. 0=7.0
compatible checksum. 1=only check rowcou: agent
distribution@.rowcount_only parameter must be the value 0,1, or 2. 0=7.0
compatible checksum. 1=only scheduled for retry. Could not clean up
the distribution transaction tables. [SQLSTATE 01000] (Message 14152).
The step failed.
?
can you make sure xp_cmdshell is enabled? Do this:
exec master.dbo.sp_configure 'xp_cmdshell'
If run value is 0, do this
exec master.dbo.sp_configure 'xp_cmdshell',1
reconfigure with override
Then start up your distribution clean up task.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"noda" <hend_g@.hotmail.com> wrote in message
news:1164102353.485024.276880@.j44g2000cwa.googlegr oups.com...
Server 1 SQL 2000 (SP4) Distributor, Publisher
Server 2 SQL 2000 (SP4) Subscriber
Transactional Replication set up between Server 1 and 2.
All the agents are running successfully (Log Reader, Snapshot, Other
Miscellenaous agent...except the Distribution Clean Up Agent
error
Executed as user: COOP\sqladmin. Could not remove directory
'\\ALXCONTGC\ReplData\unc\ALXCONTGC_sales_Pub_Alxo ffc_Anualtrans\20061119100406\'.
Check the security context of xp_cmdshell and close other processes
that may be accessing the directory. [SQLSTATE 42000] (Error 20015)
Replication-@.rowcount_only parameter must be the value 0,1, or 2. 0=7.0
compatible checksum. 1=only check rowcou: agent
distribution@.rowcount_only parameter must be the value 0,1, or 2. 0=7.0
compatible checksum. 1=only scheduled for retry. Could not clean up
the distribution transaction tables. [SQLSTATE 01000] (Message 14152).
The step failed.
?
|||Is your sql server agent running as an account that is in the sysadmin role?
If not it'll try to use the proxy account that might not have been
configured.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Error in Distribution Agent

Hello.
We're running SQL Server 2000.
I've created a transactional publication with queued updating at server
"DATASERVER1" .
When I attempt to push a subscription I receive an error in the Distribution
Agent, as follows:
Server 'DATASERVER1' is not configured for DATA ACCESS
Can anyone tell me what this means? I cannot find anything on MSDN.
Thank you in advance,
Mike
Can you check the value of sp_configure 'remote access' on the subscriber.
Also, please check select @.@.servername to ensure the name is the
netbiosname.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi, Paul. Thanks for the response.
I ran "sp_configure 'remote access'" and got: minimum=1, maximum=1,
config_value=1, run_value=1.
The name is the NetBios name.
Does it matter that the subscriber and distributor is the same machine?
Thanks again,
Mike
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uO6qyNGPFHA.1884@.TK2MSFTNGP15.phx.gbl...
> Can you check the value of sp_configure 'remote access' on the subscriber.
> Also, please check select @.@.servername to ensure the name is the
> netbiosname.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Mike,
this is not a problem. Usually it is the other way round - publisher and
distributor on the same box, though - is there a particular reason you are
implementing it this way? As for the message, I'm not sure what the problem
is . Is there connectivity between the servers? Can you open a QA windon
on the publisher and connect to the subscriber ok? What if you try setting
up a linked server on the subscriber to the publisher as a separate test -
do you get the same error?
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Error in Derived Column component

I am getting this error,

[Derived Column [192]] Error: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column.

But I don really understand y there is a attempt to type cast at all ?

Please advise ....

thanks in advance

The expression evaluator almost always implicitly converts DT_STR columns to DT_WSTR, because all string functions are implemented for Unicode only. There are only a couple very specific exceptions.

You might try to putting a data conversion transform in your flow and doing an explicit convert from DT_STR to DT_WSTR for that column and see if you get a more helpful error message. Or, redirect that row to an error output, and inspect the data and post it here.

Thanks
Mark

|||

Mark Durley wrote:

You might try to putting a data conversion transform in your flow and doing an explicit convert from DT_STR to DT_WSTR for that column and see if you get a more helpful error message.

I thought of this earlier and when I tried with a Data Conversion Component, I was not able to locate an option as DT_WSTR. Am I missing something here?

thanks for the Help so far...

|||

In the Data Conversion transform UI, in the Data Type drop down, you should see an option:

Unicode string [DT_WSTR]

Mark

|||

In the column marked Data Type in your Derived Column Shape change the value from Unicode [DT_WSTR] to string [DT_STR]

Does this answer your question?

|||Thx for the reply :)

Error in deployment.

<I hope this doesn't post twice but the 1st one never showed up>

I'm not sure why this is happening because the cube was working for weeks now, but it just now stopped and i'm having some issues reading the error. I'm hoping someone here can point me in the right direction. I'm getting 3 errors and 2 warnings.

Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idh_sod_sales, Value: 0. 0 0

Warning 2 Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Rpt Vr Flat Cmb Ih So of Dimension: Rpt Vr Flat Cmb Ih So from Database: sdw4, Record: 232495. 0 0

Error 3 Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. 0 0

Error 4 Errors in the OLAP storage engine: An error occurred while the 'Rpt Vr Flat Cmb Ih So' attribute of the 'Rpt Vr Flat Cmb Ih So' dimension from the 'sdw4' database was being processed. 0 0

Error 5 Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. 0 0

Here is the all query details:

sdw4

http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
sdw4
sdw4

Default


http://schemas.microsoft.com/analysisservices/2003/engine">

ProcessDefault

sdw4


Processing Database 'sdw4' failed.

Start time: 4/30/2007 9:24:32 AM; End time: 4/30/2007 9:45:07 AM; Duration: 0:20:35
Processing Dimension 'Rpt Vr Flat Cmb Ih So' failed.
Start time: 4/30/2007 9:24:32 AM; End time: 4/30/2007 9:45:07 AM; Duration: 0:20:35
Processing Dimension Attribute '(All)' completed successfully.

Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:33 AM; Duration: 0:00:00
Processing Dimension Attribute 'Site Nbr' completed successfully. 6 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:34 AM; Duration: 0:00:01
SQL queries 1

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[site_nbr] AS [dbo_rpt_vr_flat_cmb_ih_sosite_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Static Data Flag' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:03
SQL queries 1

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[static_data_flag] AS [dbo_rpt_vr_flat_cmb_ih_sostatic_data_flag0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Flag' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:03
SQL queries 1

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_flag] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_flag0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Site Db' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:03
SQL queries 1

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[site_db] AS [dbo_rpt_vr_flat_cmb_ih_sosite_db0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Nbr' completed successfully. 110693 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:25:09 AM; Duration: 0:00:36
SQL queries 1

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Cm Nbr' completed successfully. 1967 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:03
SQL queries 1

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[cm_nbr] AS [dbo_rpt_vr_flat_cmb_ih_socm_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Cm Name' completed successfully. 1571 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:37 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[cm_name] AS [dbo_rpt_vr_flat_cmb_ih_socm_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Cust Po' completed successfully. 99607 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:49 AM; Duration: 0:00:16
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_cust_po] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_cust_po0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Due Date' completed successfully. 724 rows have been read.
Start time: 4/30/2007 9:24:34 AM; End time: 4/30/2007 9:24:38 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_due_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_due_date0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Ship Date' completed successfully. 638 rows have been read.
Start time: 4/30/2007 9:24:34 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_ship_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_ship_date0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Inv Date' completed successfully. 506 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:38 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_inv_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_inv_date0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Loc Nbr' completed successfully. 51 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:39 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_loc_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_loc_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Brk Nbr' completed successfully. 368 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:38 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_brk_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Nbr' completed successfully. 3404 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:40 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Name' completed successfully. 3071 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:39 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Add Line1' completed successfully. 2533 rows have been read.
Start time: 4/30/2007 9:24:37 AM; End time: 4/30/2007 9:24:40 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line1] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line10_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Add Line2' completed successfully. 1089 rows have been read.
Start time: 4/30/2007 9:24:38 AM; End time: 4/30/2007 9:24:41 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line2] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line20_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp State' completed successfully. 113 rows have been read.
Start time: 4/30/2007 9:24:38 AM; End time: 4/30/2007 9:24:39 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_state] AS [dbo_rpt_vr_flat_cmb_ih_soshp_state0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp City' completed successfully. 1180 rows have been read.
Start time: 4/30/2007 9:24:38 AM; End time: 4/30/2007 9:24:40 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_city] AS [dbo_rpt_vr_flat_cmb_ih_soshp_city0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Zip' completed successfully. 1793 rows have been read.
Start time: 4/30/2007 9:24:39 AM; End time: 4/30/2007 9:24:41 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_zip] AS [dbo_rpt_vr_flat_cmb_ih_soshp_zip0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Xref Nbr' completed successfully. 2166 rows have been read.
Start time: 4/30/2007 9:24:39 AM; End time: 4/30/2007 9:24:41 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Xref Name' completed successfully. 1938 rows have been read.
Start time: 4/30/2007 9:24:40 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Channel Market Id' completed successfully. 18 rows have been read.
Start time: 4/30/2007 9:24:40 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Channel Market Name' completed successfully. 18 rows have been read.
Start time: 4/30/2007 9:24:40 AM; End time: 4/30/2007 9:24:41 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Corp Id' completed successfully. 148 rows have been read.
Start time: 4/30/2007 9:24:40 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Corp Name' completed successfully. 148 rows have been read.
Start time: 4/30/2007 9:24:41 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Reg Id' completed successfully. 30 rows have been read.
Start time: 4/30/2007 9:24:41 AM; End time: 4/30/2007 9:24:44 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Reg Name' completed successfully. 29 rows have been read.
Start time: 4/30/2007 9:24:41 AM; End time: 4/30/2007 9:24:43 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Cur Brk Nbr' completed successfully. 199 rows have been read.
Start time: 4/30/2007 9:24:41 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Cur Brk Name' completed successfully. 191 rows have been read.
Start time: 4/30/2007 9:24:42 AM; End time: 4/30/2007 9:24:44 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Accounting Channel Id' completed successfully. 8 rows have been read.
Start time: 4/30/2007 9:24:42 AM; End time: 4/30/2007 9:24:44 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Accounting Channel Name' completed successfully. 8 rows have been read.
Start time: 4/30/2007 9:24:42 AM; End time: 4/30/2007 9:24:45 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Chn Type Nbr' completed successfully. 7 rows have been read.
Start time: 4/30/2007 9:24:42 AM; End time: 4/30/2007 9:24:45 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_chn_type_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_chn_type_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Chn Type Desc' completed successfully. 7 rows have been read.
Start time: 4/30/2007 9:24:43 AM; End time: 4/30/2007 9:24:44 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[chn_type_desc] AS [dbo_rpt_vr_flat_cmb_ih_sochn_type_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Div Nbr' completed successfully. 7 rows have been read.
Start time: 4/30/2007 9:24:43 AM; End time: 4/30/2007 9:24:45 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_div_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_div_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Div Desc' completed successfully. 7 rows have been read.
Start time: 4/30/2007 9:24:44 AM; End time: 4/30/2007 9:24:46 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[div_desc] AS [dbo_rpt_vr_flat_cmb_ih_sodiv_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Part' completed successfully. 3030 rows have been read.
Start time: 4/30/2007 9:24:44 AM; End time: 4/30/2007 9:24:48 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_part] AS [dbo_rpt_vr_flat_cmb_ih_sopt_part0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Desc' completed successfully. 3073 rows have been read.
Start time: 4/30/2007 9:24:44 AM; End time: 4/30/2007 9:24:49 AM; Duration: 0:00:05
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Um' completed successfully. 97 rows have been read.
Start time: 4/30/2007 9:24:44 AM; End time: 4/30/2007 9:24:47 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_um] AS [dbo_rpt_vr_flat_cmb_ih_sopt_um0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Qty Ord' completed successfully. 1998 rows have been read.
Start time: 4/30/2007 9:24:45 AM; End time: 4/30/2007 9:24:50 AM; Duration: 0:00:05
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ord] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ord0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Qty Ship' completed successfully. 2005 rows have been read.
Start time: 4/30/2007 9:24:45 AM; End time: 4/30/2007 9:24:50 AM; Duration: 0:00:05
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ship] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ship0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Sales' completed successfully. 54958 rows have been read.
Start time: 4/30/2007 9:24:46 AM; End time: 4/30/2007 9:24:59 AM; Duration: 0:00:13
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Sales Rolling Fx' completed successfully. 59546 rows have been read.
Start time: 4/30/2007 9:24:46 AM; End time: 4/30/2007 9:25:05 AM; Duration: 0:00:19
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_rolling_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_rolling_fx0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Sales Raw Wout Fx' completed successfully. 57840 rows have been read.
Start time: 4/30/2007 9:24:47 AM; End time: 4/30/2007 9:25:05 AM; Duration: 0:00:18
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_raw_wout_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_raw_wout_fx0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Category Id' completed successfully. 9 rows have been read.
Start time: 4/30/2007 9:24:48 AM; End time: 4/30/2007 9:24:49 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_category_id] AS [dbo_rpt_vr_flat_cmb_ih_sopt_category_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Cat Desc' completed successfully. 9 rows have been read.
Start time: 4/30/2007 9:24:49 AM; End time: 4/30/2007 9:24:50 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_socat_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Label Nbr' completed successfully. 89 rows have been read.
Start time: 4/30/2007 9:24:49 AM; End time: 4/30/2007 9:24:50 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_label_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_label_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Label Desc' completed successfully. 87 rows have been read.
Start time: 4/30/2007 9:24:50 AM; End time: 4/30/2007 9:24:51 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_label_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_label_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Sub Cat Nbr' completed successfully. 16 rows have been read.
Start time: 4/30/2007 9:24:50 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_cat_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_cat_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Sub Cat Desc' completed successfully. 16 rows have been read.
Start time: 4/30/2007 9:24:50 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[sub_cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_sosub_cat_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Group Nbr' completed successfully. 61 rows have been read.
Start time: 4/30/2007 9:24:50 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_group_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Group Desc' completed successfully. 60 rows have been read.
Start time: 4/30/2007 9:24:51 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_group_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_group_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Sub Group Nbr' completed successfully. 138 rows have been read.
Start time: 4/30/2007 9:24:51 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_group_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Sub Group Name' completed successfully. 133 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:53 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_sub_group_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_sub_group_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Season' completed successfully. 42 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:53 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_season] AS [dbo_rpt_vr_flat_cmb_ih_sopt_season0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Hgpl' completed successfully. 6 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:55 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_hgpl] AS [dbo_rpt_vr_flat_cmb_ih_sopt_hgpl0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Size' completed successfully. 100 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:55 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_size] AS [dbo_rpt_vr_flat_cmb_ih_sopt_size0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Count' completed successfully. 71 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:54 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_count] AS [dbo_rpt_vr_flat_cmb_ih_sopt_count0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Pt Xref Nbr' completed successfully. 2835 rows have been read.
Start time: 4/30/2007 9:24:53 AM; End time: 4/30/2007 9:24:55 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_pt_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_pt_xref_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Xref Name' completed successfully. 2633 rows have been read.
Start time: 4/30/2007 9:24:53 AM; End time: 4/30/2007 9:24:57 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_xref_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Pm Code' completed successfully. 6 rows have been read.
Start time: 4/30/2007 9:24:54 AM; End time: 4/30/2007 9:24:56 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_pm_code] AS [dbo_rpt_vr_flat_cmb_ih_sopt_pm_code0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Prod Line' completed successfully. 9 rows have been read.
Start time: 4/30/2007 9:24:55 AM; End time: 4/30/2007 9:24:56 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_prod_line] AS [dbo_rpt_vr_flat_cmb_ih_sopt_prod_line0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Mfg Site' completed successfully. 16 rows have been read.
Start time: 4/30/2007 9:24:55 AM; End time: 4/30/2007 9:24:56 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_mfg_site] AS [dbo_rpt_vr_flat_cmb_ih_sopt_mfg_site0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Forecast Group' completed successfully. 129 rows have been read.
Start time: 4/30/2007 9:24:55 AM; End time: 4/30/2007 9:24:56 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_forecast_group] AS [dbo_rpt_vr_flat_cmb_ih_soapm_forecast_group0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Net Wt' completed successfully. 273 rows have been read.
Start time: 4/30/2007 9:24:56 AM; End time: 4/30/2007 9:24:57 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_net_wt] AS [dbo_rpt_vr_flat_cmb_ih_sopt_net_wt0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Project' completed successfully. 22 rows have been read.
Start time: 4/30/2007 9:24:56 AM; End time: 4/30/2007 9:24:57 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_project] AS [dbo_rpt_vr_flat_cmb_ih_soidh_project0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Samp Flag' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:56 AM; End time: 4/30/2007 9:24:57 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_samp_flag] AS [dbo_rpt_vr_flat_cmb_ih_soidh_samp_flag0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Curr' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:56 AM; End time: 4/30/2007 9:24:58 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_curr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_curr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'So Nbr' completed successfully. 111624 rows have been read.
Start time: 4/30/2007 9:24:57 AM; End time: 4/30/2007 9:25:14 AM; Duration: 0:00:17
SQL queries 1

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soso_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Rpt Vr Flat Cmb Ih So' failed. 230000 rows have been read.
Start time: 4/30/2007 9:25:12 AM; End time: 4/30/2007 9:45:07 AM; Duration: 0:19:55
SQL queries 1

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idcol] AS [dbo_rpt_vr_flat_cmb_ih_soidcol0_0],[dbo_rpt_vr_flat_cmb_ih_so].[site_nbr] AS [dbo_rpt_vr_flat_cmb_ih_sosite_nbr0_1],[dbo_rpt_vr_flat_cmb_ih_so].[static_data_flag] AS [dbo_rpt_vr_flat_cmb_ih_sostatic_data_flag0_2],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_flag] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_flag0_3],[dbo_rpt_vr_flat_cmb_ih_so].[site_db] AS [dbo_rpt_vr_flat_cmb_ih_sosite_db0_4],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_nbr0_5],[dbo_rpt_vr_flat_cmb_ih_so].[cm_nbr] AS [dbo_rpt_vr_flat_cmb_ih_socm_nbr0_6],[dbo_rpt_vr_flat_cmb_ih_so].[cm_name] AS [dbo_rpt_vr_flat_cmb_ih_socm_name0_7],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_cust_po] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_cust_po0_8],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_due_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_due_date0_9],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_ship_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_ship_date0_10],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_inv_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_inv_date0_11],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_loc_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_loc_nbr0_12],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_brk_nbr0_13],[dbo_rpt_vr_flat_cmb_ih_so].[shp_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_nbr0_14],[dbo_rpt_vr_flat_cmb_ih_so].[shp_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_name0_15],[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line1] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line10_16],[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line2] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line20_17],[dbo_rpt_vr_flat_cmb_ih_so].[shp_state] AS [dbo_rpt_vr_flat_cmb_ih_soshp_state0_18],[dbo_rpt_vr_flat_cmb_ih_so].[shp_city] AS [dbo_rpt_vr_flat_cmb_ih_soshp_city0_19],[dbo_rpt_vr_flat_cmb_ih_so].[shp_zip] AS [dbo_rpt_vr_flat_cmb_ih_soshp_zip0_20],[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_nbr0_21],[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_name0_22],[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_id0_23],[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_name0_24],[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_id0_25],[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_name0_26],[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_id0_27],[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_name0_28],[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_nbr0_29],[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_name0_30],[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_id0_31],[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_name0_32],[dbo_rpt_vr_flat_cmb_ih_so].[apm_chn_type_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_chn_type_nbr0_33],[dbo_rpt_vr_flat_cmb_ih_so].[chn_type_desc] AS [dbo_rpt_vr_flat_cmb_ih_sochn_type_desc0_34],[dbo_rpt_vr_flat_cmb_ih_so].[apm_div_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_div_nbr0_35],[dbo_rpt_vr_flat_cmb_ih_so].[div_desc] AS [dbo_rpt_vr_flat_cmb_ih_sodiv_desc0_36],[dbo_rpt_vr_flat_cmb_ih_so].[pt_part] AS [dbo_rpt_vr_flat_cmb_ih_sopt_part0_37],[dbo_rpt_vr_flat_cmb_ih_so].[pt_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_desc0_38],[dbo_rpt_vr_flat_cmb_ih_so].[pt_um] AS [dbo_rpt_vr_flat_cmb_ih_sopt_um0_39],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ord] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ord0_40],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ship] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ship0_41],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales0_42],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_rolling_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_rolling_fx0_43],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_raw_wout_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_raw_wout_fx0_44],[dbo_rpt_vr_flat_cmb_ih_so].[pt_category_id] AS [dbo_rpt_vr_flat_cmb_ih_sopt_category_id0_45],[dbo_rpt_vr_flat_cmb_ih_so].[cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_socat_desc0_46],[dbo_rpt_vr_flat_cmb_ih_so].[apm_label_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_label_nbr0_47],[dbo_rpt_vr_flat_cmb_ih_so].[pt_label_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_label_desc0_48],[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_cat_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_cat_nbr0_49],[dbo_rpt_vr_flat_cmb_ih_so].[sub_cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_sosub_cat_desc0_50],[dbo_rpt_vr_flat_cmb_ih_so].[apm_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_group_nbr0_51],[dbo_rpt_vr_flat_cmb_ih_so].[pt_group_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_group_desc0_52],[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_group_nbr0_53],[dbo_rpt_vr_flat_cmb_ih_so].[pt_sub_group_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_sub_group_name0_54],[dbo_rpt_vr_flat_cmb_ih_so].[pt_season] AS [dbo_rpt_vr_flat_cmb_ih_sopt_season0_55],[dbo_rpt_vr_flat_cmb_ih_so].[pt_hgpl] AS [dbo_rpt_vr_flat_cmb_ih_sopt_hgpl0_56],[dbo_rpt_vr_flat_cmb_ih_so].[pt_size] AS [dbo_rpt_vr_flat_cmb_ih_sopt_size0_57],[dbo_rpt_vr_flat_cmb_ih_so].[pt_count] AS [dbo_rpt_vr_flat_cmb_ih_sopt_count0_58],[dbo_rpt_vr_flat_cmb_ih_so].[apm_pt_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_pt_xref_nbr0_59],[dbo_rpt_vr_flat_cmb_ih_so].[pt_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_xref_name0_60],[dbo_rpt_vr_flat_cmb_ih_so].[pt_pm_code] AS [dbo_rpt_vr_flat_cmb_ih_sopt_pm_code0_61],[dbo_rpt_vr_flat_cmb_ih_so].[pt_prod_line] AS [dbo_rpt_vr_flat_cmb_ih_sopt_prod_line0_62],[dbo_rpt_vr_flat_cmb_ih_so].[pt_mfg_site] AS [dbo_rpt_vr_flat_cmb_ih_sopt_mfg_site0_63],[dbo_rpt_vr_flat_cmb_ih_so].[apm_forecast_group] AS [dbo_rpt_vr_flat_cmb_ih_soapm_forecast_group0_64],[dbo_rpt_vr_flat_cmb_ih_so].[pt_net_wt] AS [dbo_rpt_vr_flat_cmb_ih_sopt_net_wt0_65],[dbo_rpt_vr_flat_cmb_ih_so].[idh_project] AS [dbo_rpt_vr_flat_cmb_ih_soidh_project0_66],[dbo_rpt_vr_flat_cmb_ih_so].[idh_samp_flag] AS [dbo_rpt_vr_flat_cmb_ih_soidh_samp_flag0_67],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_curr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_curr0_68],[dbo_rpt_vr_flat_cmb_ih_so].[so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soso_nbr0_69]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Error Messages 2

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idh_sod_sales, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Rpt Vr Flat Cmb Ih So of Dimension: Rpt Vr Flat Cmb Ih So from Database: sdw4, Record: 232495.
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idh_sod_sales, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Rpt Vr Flat Cmb Ih So of Dimension: Rpt Vr Flat Cmb Ih So from Database: sdw4, Record: 232495. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while the 'Rpt Vr Flat Cmb Ih So' attribute of the 'Rpt Vr Flat Cmb Ih So' dimension from the 'sdw4' database was being processed.

So is this saying if i run this query in sql server and read the result set of 232495 I should find my error? or is it saying something else?

Code Snippet

SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idcol] AS [dbo_rpt_vr_flat_cmb_ih_soidcol0_0],[dbo_rpt_vr_flat_cmb_ih_so].[site_nbr] AS [dbo_rpt_vr_flat_cmb_ih_sosite_nbr0_1],[dbo_rpt_vr_flat_cmb_ih_so].[static_data_flag] AS [dbo_rpt_vr_flat_cmb_ih_sostatic_data_flag0_2],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_flag] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_flag0_3],[dbo_rpt_vr_flat_cmb_ih_so].[site_db] AS [dbo_rpt_vr_flat_cmb_ih_sosite_db0_4],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_nbr0_5],[dbo_rpt_vr_flat_cmb_ih_so].[cm_nbr] AS [dbo_rpt_vr_flat_cmb_ih_socm_nbr0_6],[dbo_rpt_vr_flat_cmb_ih_so].[cm_name] AS [dbo_rpt_vr_flat_cmb_ih_socm_name0_7],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_cust_po] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_cust_po0_8],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_due_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_due_date0_9],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_ship_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_ship_date0_10],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_inv_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_inv_date0_11],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_loc_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_loc_nbr0_12],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_brk_nbr0_13],[dbo_rpt_vr_flat_cmb_ih_so].[shp_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_nbr0_14],[dbo_rpt_vr_flat_cmb_ih_so].[shp_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_name0_15],[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line1] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line10_16],[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line2] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line20_17],[dbo_rpt_vr_flat_cmb_ih_so].[shp_state] AS [dbo_rpt_vr_flat_cmb_ih_soshp_state0_18],[dbo_rpt_vr_flat_cmb_ih_so].[shp_city] AS [dbo_rpt_vr_flat_cmb_ih_soshp_city0_19],[dbo_rpt_vr_flat_cmb_ih_so].[shp_zip] AS [dbo_rpt_vr_flat_cmb_ih_soshp_zip0_20],[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_nbr0_21],[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_name0_22],[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_id0_23],[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_name0_24],[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_id0_25],[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_name0_26],[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_id0_27],[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_name0_28],[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_nbr0_29],[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_name0_30],[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_id0_31],[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_name0_32],[dbo_rpt_vr_flat_cmb_ih_so].[apm_chn_type_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_chn_type_nbr0_33],[dbo_rpt_vr_flat_cmb_ih_so].[chn_type_desc] AS [dbo_rpt_vr_flat_cmb_ih_sochn_type_desc0_34],[dbo_rpt_vr_flat_cmb_ih_so].[apm_div_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_div_nbr0_35],[dbo_rpt_vr_flat_cmb_ih_so].[div_desc] AS [dbo_rpt_vr_flat_cmb_ih_sodiv_desc0_36],[dbo_rpt_vr_flat_cmb_ih_so].[pt_part] AS [dbo_rpt_vr_flat_cmb_ih_sopt_part0_37],[dbo_rpt_vr_flat_cmb_ih_so].[pt_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_desc0_38],[dbo_rpt_vr_flat_cmb_ih_so].[pt_um] AS [dbo_rpt_vr_flat_cmb_ih_sopt_um0_39],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ord] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ord0_40],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ship] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ship0_41],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales0_42],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_rolling_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_rolling_fx0_43],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_raw_wout_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_raw_wout_fx0_44],[dbo_rpt_vr_flat_cmb_ih_so].[pt_category_id] AS [dbo_rpt_vr_flat_cmb_ih_sopt_category_id0_45],[dbo_rpt_vr_flat_cmb_ih_so].[cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_socat_desc0_46],[dbo_rpt_vr_flat_cmb_ih_so].[apm_label_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_label_nbr0_47],[dbo_rpt_vr_flat_cmb_ih_so].[pt_label_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_label_desc0_48],[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_cat_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_cat_nbr0_49],[dbo_rpt_vr_flat_cmb_ih_so].[sub_cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_sosub_cat_desc0_50],[dbo_rpt_vr_flat_cmb_ih_so].[apm_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_group_nbr0_51],[dbo_rpt_vr_flat_cmb_ih_so].[pt_group_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_group_desc0_52],[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_group_nbr0_53],[dbo_rpt_vr_flat_cmb_ih_so].[pt_sub_group_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_sub_group_name0_54],[dbo_rpt_vr_flat_cmb_ih_so].[pt_season] AS [dbo_rpt_vr_flat_cmb_ih_sopt_season0_55],[dbo_rpt_vr_flat_cmb_ih_so].[pt_hgpl] AS [dbo_rpt_vr_flat_cmb_ih_sopt_hgpl0_56],[dbo_rpt_vr_flat_cmb_ih_so].[pt_size] AS [dbo_rpt_vr_flat_cmb_ih_sopt_size0_57],[dbo_rpt_vr_flat_cmb_ih_so].[pt_count] AS [dbo_rpt_vr_flat_cmb_ih_sopt_count0_58],[dbo_rpt_vr_flat_cmb_ih_so].[apm_pt_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_pt_xref_nbr0_59],[dbo_rpt_vr_flat_cmb_ih_so].[pt_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_xref_name0_60],[dbo_rpt_vr_flat_cmb_ih_so].[pt_pm_code] AS [dbo_rpt_vr_flat_cmb_ih_sopt_pm_code0_61],[dbo_rpt_vr_flat_cmb_ih_so].[pt_prod_line] AS [dbo_rpt_vr_flat_cmb_ih_sopt_prod_line0_62],[dbo_rpt_vr_flat_cmb_ih_so].[pt_mfg_site] AS [dbo_rpt_vr_flat_cmb_ih_sopt_mfg_site0_63],[dbo_rpt_vr_flat_cmb_ih_so].[apm_forecast_group] AS [dbo_rpt_vr_flat_cmb_ih_soapm_forecast_group0_64],[dbo_rpt_vr_flat_cmb_ih_so].[pt_net_wt] AS [dbo_rpt_vr_flat_cmb_ih_sopt_net_wt0_65],[dbo_rpt_vr_flat_cmb_ih_so].[idh_project] AS [dbo_rpt_vr_flat_cmb_ih_soidh_project0_66],[dbo_rpt_vr_flat_cmb_ih_so].[idh_samp_flag] AS [dbo_rpt_vr_flat_cmb_ih_soidh_samp_flag0_67],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_curr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_curr0_68],[dbo_rpt_vr_flat_cmb_ih_so].[so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soso_nbr0_69]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]

There has been quite a few posts on this forum regarding similar situations. The most improtant error you got is the first one:

Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idh_sod_sales, Value: 0. 0 0

Try to search for "The attribute key cannot be found" , you will get muliple threads describing the problem and the way to fix it. For instance this one http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=737482&SiteID=1

HTH

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