Error Reporting in SSAS...

Is there a way to achieve the following on a UDM:

1) When an error occurs while processing a record
in a dimension, write the primary key of the record
along with the error to a record in a database.

2) Continue on all errors after logging them.

3) Launch a script when cube processing is complete
to notify affected parties of the errors.

Any suggestions to achieve something similar would
be greatly appreciated.

Filip

You can use SSIS package to put all that in one package.

You create a package using Analysis Services Processing Task. Then go to Menu -> SSIS -> Logging... In the Provider Type select SQL Server then check the "Details" tab. You have to try different Events and check it's logging all you want not more or less.

Continue logging on error is the properties setting on cube/dimension side also if you double click Analysis Services Processing Task you can set that in "Change Settings..."

Last one you have to query the log database table and use send email task in SSIS package.

Hope this will help - Ashok

|||

Thanks Ashok, I'll give that a try and report back ;-)

Filip

Error on bcp

Hi again

Sometimes, in some files .dat, thee following error occurs:

#@. Row 1, Column 8: Invalid character value for cast specification @.#
3877 597 2.0 Manual 1C15H4 <NULL> 24590.0000 1 2 G 2.0 ATIVO US$ 2006 2006 2 <NULL>

But the columns are OK.

Somebody can help me?The error indicates that some value in the line could not be converted to the data type of the destination column. It can be due to the format of the specified value. If you post a repro script then it might be easier to tell what the problem might be.|||Hi,

Sorry.. Only today I saw your response.

So, the dat file that I use is something like this:

1;ABADIA;12*
2;ABADIA DOS DOURADOS;18*
3;ABADIANIA;16*
4;ABAETE;18*
5;ABAETETUBA;21*
6;ABAIARA;13*
7;ABAIBA;18*
8;ABAIRA;12*
9;ABARE;12*
10;ABATIA;25*
11;ABELARDO LUZ;31*
12;ABOBORA;12*
13;ABRANTES;12*
14;ABRE CAMPO;18*
15;ABREU E LIMA;23*
16;ABUNA;28*
17;ACAIACA;18*
18;ACAILANDIA;17*
19;ACAJUTIBA;12*
20;ACARA;21*

and the command line that I use is:

bcp cdiretodev5.dbo.cidade in "./loader/dat/cidade.dat" -U sa -P pwd123 -S BART\SQLEXPRESS -c -t; -r * -E -e d:\cidade.log

The table is:

table name: cidade

columns:

id_cidade numeric(10)
no_cidade varchar(50)
id_estado numeric(4)

Thanks!!!!|||Your row terminator seems incorrect. Do you have CR/LF after *? If so, you need to change the -r option to -r "*\n" or -r "*\r\n". See the Books Online topic on BCP utility for details on the options, format files etc.|||Hi,

thank you for your help.. Only now I could see.. sorry...
well, I put the option with -r "*\n", but and some lines, The bcp doesn′t generate the *, like follows:

155;237;SLX;;;R$;;1;5;;1;;;;;;;2;;;2 ou 4;0;007001-7;;*
156;237;SDX;;;R$;;1;5;;1;;;;;;;2;;;2 ou 4;0;007001-7;;*
1317;511;3.0 E;;;R$;;1;5;;1;;;;;;;2;;;2 ou 4;0;021069-2;;*
1318;511;3.0 SL;;;R$;;1;5;;1;;;;;;;2;;;2 ou 4;0;021070-6;;*
1988;46;Sedan Wind 1.0;5C19Z1;SIMP;R$;18486.0000;1;5;;1;Powertech 1.0L M.P.F.I. 4cil.;4056 mm;46 l;8,3 mkgf a 3.000 rpm;14.8 km/l;11.7 km/l;1;2000;2001;4;0;

Is there a limit for number of columns to line?

The new error now is #@. Row 1, Column 27: String data, right truncation @.#

thank you very much.|||The error message indicates that the data in column 27 or row 1 exceeds length of the destination column. So check the length of data against your table's column definition. There is a limit to the number of columns in a table in SQL Server but there is really none in the data file. As long as you have to terminators defined properly BCP should be able to parse the file correctly assuming it is formatted correctly.

Error on bcp

Hi again

Sometimes, in some files .dat, thee following error occurs:

#@. Row 1, Column 8: Invalid character value for cast specification @.#
3877 597 2.0 Manual 1C15H4 <NULL> 24590.0000 1 2 G 2.0 ATIVO US$ 2006 2006 2 <NULL>

But the columns are OK.

Somebody can help me?The error indicates that some value in the line could not be converted to the data type of the destination column. It can be due to the format of the specified value. If you post a repro script then it might be easier to tell what the problem might be.|||Hi,

Sorry.. Only today I saw your response.

So, the dat file that I use is something like this:

1;ABADIA;12*
2;ABADIA DOS DOURADOS;18*
3;ABADIANIA;16*
4;ABAETE;18*
5;ABAETETUBA;21*
6;ABAIARA;13*
7;ABAIBA;18*
8;ABAIRA;12*
9;ABARE;12*
10;ABATIA;25*
11;ABELARDO LUZ;31*
12;ABOBORA;12*
13;ABRANTES;12*
14;ABRE CAMPO;18*
15;ABREU E LIMA;23*
16;ABUNA;28*
17;ACAIACA;18*
18;ACAILANDIA;17*
19;ACAJUTIBA;12*
20;ACARA;21*

and the command line that I use is:

bcp cdiretodev5.dbo.cidade in "./loader/dat/cidade.dat" -U sa -P pwd123 -S BART\SQLEXPRESS -c -t; -r * -E -e d:\cidade.log

The table is:

table name: cidade

columns:

id_cidade numeric(10)
no_cidade varchar(50)
id_estado numeric(4)

Thanks!!!!|||Your row terminator seems incorrect. Do you have CR/LF after *? If so, you need to change the -r option to -r "*\n" or -r "*\r\n". See the Books Online topic on BCP utility for details on the options, format files etc.|||Hi,

thank you for your help.. Only now I could see.. sorry...
well, I put the option with -r "*\n", but and some lines, The bcp doesn′t generate the *, like follows:

155;237;SLX;;;R$;;1;5;;1;;;;;;;2;;;2 ou 4;0;007001-7;;*
156;237;SDX;;;R$;;1;5;;1;;;;;;;2;;;2 ou 4;0;007001-7;;*
1317;511;3.0 E;;;R$;;1;5;;1;;;;;;;2;;;2 ou 4;0;021069-2;;*
1318;511;3.0 SL;;;R$;;1;5;;1;;;;;;;2;;;2 ou 4;0;021070-6;;*
1988;46;Sedan Wind 1.0;5C19Z1;SIMP;R$;18486.0000;1;5;;1;Powertech 1.0L M.P.F.I. 4cil.;4056 mm;46 l;8,3 mkgf a 3.000 rpm;14.8 km/l;11.7 km/l;1;2000;2001;4;0;

Is there a limit for number of columns to line?

The new error now is #@. Row 1, Column 27: String data, right truncation @.#

thank you very much.|||The error message indicates that the data in column 27 or row 1 exceeds length of the destination column. So check the length of data against your table's column definition. There is a limit to the number of columns in a table in SQL Server but there is really none in the data file. As long as you have to terminators defined properly BCP should be able to parse the file correctly assuming it is formatted correctly.

Error occurs when tried to view table design in Enterprise Manager

Dear All,
I have a problem
When I tried to view the table design throught Enterprise Manager's "Design
Table" function
If prompted
Table "XXXXX" could not be loaded
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link fa
ilure
What's happen?
Thanks~~Have both the server instance and your client tools been patched with at
least SP3a? Are you connected to Enterprise Manager on the same machine as
the database, or are you accessing it from a remote machine? Is your server
registration set up using windows auth or sql auth? Have you considered
managing objects using Query Analyzer?
http://www.aspfaq.com/
(Reverse address to reply.)
"Utada P.W. SIU" <wing0508@.hotmail.com> wrote in message
news:OHNwtHV7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> I have a problem
> When I tried to view the table design throught Enterprise Manager's
"Design
> Table" function
> If prompted
> Table "XXXXX" could not be loaded
> ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link
failure
> What's happen?
> Thanks~~
>|||My client pc haven't patch sp3a yet
however, when I using that sql server's Enterprise Manager to view the table
design, it prompt the same error to me...
Any idea'
Thanks~|||> Any idea'
Yes, install SP3a?
http://www.aspfaq.com/
(Reverse address to reply.)|||Installed...but still cannot view table design....
oh!!! how come!!!
it is very hard to create table by using sql statement...change table field
type by sql statement
add/delete/update field info by sql statement...
oh!!!|||> it is very hard to create table by using sql statement...change table
field
> type by sql statement
Have you looked at CREATE TABLE and ALTER TABLE in Books Online?
http://www.aspfaq.com/
(Reverse address to reply.)|||Of course
I mean that it is too trouble to using code to create table or alter table
structure,...
hehe~

Error occurs when tried to view table design in Enterprise Manager

Dear All,
I have a problem
When I tried to view the table design throught Enterprise Manager's "Design
Table" function
If prompted
Table "XXXXX" could not be loaded
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
What's happen?
Thanks~~Have both the server instance and your client tools been patched with at
least SP3a? Are you connected to Enterprise Manager on the same machine as
the database, or are you accessing it from a remote machine? Is your server
registration set up using windows auth or sql auth? Have you considered
managing objects using Query Analyzer?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Utada P.W. SIU" <wing0508@.hotmail.com> wrote in message
news:OHNwtHV7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> I have a problem
> When I tried to view the table design throught Enterprise Manager's
"Design
> Table" function
> If prompted
> Table "XXXXX" could not be loaded
> ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
> What's happen?
> Thanks~~
>|||My client pc haven't patch sp3a yet
however, when I using that sql server's Enterprise Manager to view the table
design, it prompt the same error to me...
Any idea'
Thanks~|||> Any idea'
Yes, install SP3a?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Installed...but still cannot view table design....
oh!!! how come!!!
it is very hard to create table by using sql statement...change table field
type by sql statement
add/delete/update field info by sql statement...
oh!!!|||> it is very hard to create table by using sql statement...change table
field
> type by sql statement
Have you looked at CREATE TABLE and ALTER TABLE in Books Online?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Of course
I mean that it is too trouble to using code to create table or alter table
structure,...
hehe~

Error message occurs when closing IE7 tabs

Ever since I installed Internet Explorer 7 I have recieved an error message when closing the browser tabs. It doesn't matter if I am closing one or all of the open tabs. Here is the message I recieve,

"Access violation at address 02050200 in module iesdsg.dll Read of address 25202E67"

This message didn't occur until I installed IE7. When I uninstall IE7 the message does not show up. Any insight would be appreciated.

I have the same issue. And it is totally driving me nuts! It has effected all the computers I have whether HP or DELL that I have IE 7 on. MS must know about the problem but is too pre-occupied with the Vista shipwreck.

|||I just installed IE7 and I'm getting this error as well. Is Microsoft looking into it?|||

I kept getting this error also, "Access violation at address 02050200 in module iesdsg.dll Read of address 25202E67". I downloaded RegCure which is free, but only fixes File Associations and Font Entries for free, you have to register (and pay) for it to fix more.

It removed the following entries:

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.alx]

[HKEY_CLASSES_ROOT\.alx]
@.="ALTOOLS.alx"
[HKEY_CLASSES_ROOT\.uip]

[HKEY_CLASSES_ROOT\.uip]
@.="uipfile"

I tested IE and no error. I restored the registry, and the error came back. Removed the same entries from the registry and no error.

Hope this helps!

Error message occurs when closing IE7 tabs

Ever since I installed Internet Explorer 7 I have recieved an error message when closing the browser tabs. It doesn't matter if I am closing one or all of the open tabs. Here is the message I recieve,

"Access violation at address 02050200 in module iesdsg.dll Read of address 25202E67"

This message didn't occur until I installed IE7. When I uninstall IE7 the message does not show up. Any insight would be appreciated.

I have the same issue. And it is totally driving me nuts! It has effected all the computers I have whether HP or DELL that I have IE 7 on. MS must know about the problem but is too pre-occupied with the Vista shipwreck.

|||I just installed IE7 and I'm getting this error as well. Is Microsoft looking into it?|||

I kept getting this error also, "Access violation at address 02050200 in module iesdsg.dll Read of address 25202E67". I downloaded RegCure which is free, but only fixes File Associations and Font Entries for free, you have to register (and pay) for it to fix more.

It removed the following entries:

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.alx]

[HKEY_CLASSES_ROOT\.alx]
@.="ALTOOLS.alx"
[HKEY_CLASSES_ROOT\.uip]

[HKEY_CLASSES_ROOT\.uip]
@.="uipfile"

I tested IE and no error. I restored the registry, and the error came back. Removed the same entries from the registry and no error.

Hope this helps!

Error message occurs when closing IE7 tabs

Ever since I installed Internet Explorer 7 I have recieved an error message when closing the browser tabs. It doesn't matter if I am closing one or all of the open tabs. Here is the message I recieve,

"Access violation at address 02050200 in module iesdsg.dll Read of address 25202E67"

This message didn't occur until I installed IE7. When I uninstall IE7 the message does not show up. Any insight would be appreciated.

I have the same issue. And it is totally driving me nuts! It has effected all the computers I have whether HP or DELL that I have IE 7 on. MS must know about the problem but is too pre-occupied with the Vista shipwreck.

|||I just installed IE7 and I'm getting this error as well. Is Microsoft looking into it?|||

I kept getting this error also, "Access violation at address 02050200 in module iesdsg.dll Read of address 25202E67". I downloaded RegCure which is free, but only fixes File Associations and Font Entries for free, you have to register (and pay) for it to fix more.

It removed the following entries:

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.alx]

[HKEY_CLASSES_ROOT\.alx]
@.="ALTOOLS.alx"
[HKEY_CLASSES_ROOT\.uip]

[HKEY_CLASSES_ROOT\.uip]
@.="uipfile"

I tested IE and no error. I restored the registry, and the error came back. Removed the same entries from the registry and no error.

Hope this helps!