DTS OLAP TASK ERROR

Question

DTS OLAP TASK ERROR

tfcarlos

SSC Journeyman

Points: 92
More actions
August 23, 2002 at 1:58 pm

#158672

DTS Olap Task, when i execute a package containing an Olap Task from the Enterprise Manager, it runs ok, but when i schedule this task, it fails. That Olap Task process a cube, updating incrementally its dimensions. When this Task need to process a dimension, it fails and the error is
Error Source: dst_flia_prodto.espesor
Error Description:RECORD=1, ERROR=CANTCONVERTDATA, COLUMN=0, NAME=espesor
Error code: 80040076
\Error Help File:
Error Help Context ID:1000440
Dimension 'dst_flia_prodto.espesor' Execute : SELECT DISTINCT "dbo"."dim_familia_producto"."espesor", "dbo"."dim_familia_producto"."espesor" FROM "dbo"."dim_familia_producto"
Error = 1 (00000001), Description = 23/08/2002 08:02:04 a.m. 3804 Data source provider error: Errors occurred while reading one or more columns; Time:23/08/2002 08:02:04 a.m.
But when i run this task from the enterprise manager, it succeeds.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 1

Have you checked the permissions of the user account that SQLServerAgent is running under? Seems like a lot of these issues are centered around proper access permissions of the service involved...

hth,

Michael

Michael Weiss

tfcarlos SSC Journeyman Points: 92 More actions · Answer 2

Incremental process of other dimensions works fine. The following log could be a good example :

28332 Initiating transaction in Database 'dm_gego'

28332 Processing Dimension 'dst_mercados' Start time: 08:42:32 a.m.

28332 Process information for Dimension 'dst_mercados': An incremental dimension update is performed

28332 Initializing Level 'Unidad Negocio'

28332 Initializing Level 'Sector Mercado'

28332 Initializing Dimension 'dst_mercados'

28332 Dimension 'dst_mercados' Execute : SELECT DISTINCT "dbo"."dim_mercados"."direccion", "dbo"."dim_mercados"."mercado", "dbo"."dim_mercados"."unidad_negocio", "dbo"."dim_mercados"."sub_unidad_negocio", "dbo"."dim_mercados"."sector_mercado" FROM "dbo"."dim_mercados"

28332 Dimension 'dst_mercados' Execute : SELECT DISTINCT "dbo"."dim_mercados"."direccion", "dbo"."dim_mercados"."mercado", "dbo"."dim_mercados"."unidad_negocio", "dbo"."dim_mercados"."codigo_unidad_negocio" FROM "dbo"."dim_mercados"

28332 Dimension 'dst_mercados' Execute : SELECT DISTINCT "dbo"."dim_mercados"."sector_mercado", "dbo"."dim_mercados"."codigo_sec_mercado" FROM "dbo"."dim_mercados"

28332 Completed Processing Dimension 'dst_mercados'. End time: 08:42:33 a.m. Duration: 0:00:01 Rows processed: 101

28332 Processing Dimension 'dst_clientes' Start time: 08:42:33 a.m.

28332 Process information for Dimension 'dst_clientes': An incremental dimension update is performed

28332 Initializing Level 'Cliente'

28332 Initializing Dimension 'dst_clientes'

28332 Dimension 'dst_clientes' Execute : SELECT DISTINCT "dbo"."dim_clientes"."grupo_economico", "dbo"."dim_clientes"."cliente" FROM "dbo"."dim_clientes"

28332 Dimension 'dst_clientes' Execute : SELECT DISTINCT "dbo"."dim_clientes"."grupo_economico", "dbo"."dim_clientes"."cliente", "dbo"."dim_clientes"."codigo_cliente" FROM "dbo"."dim_clientes"

28332 Completed Processing Dimension 'dst_clientes'. End time: 08:42:34 a.m. Duration: 0:00:01 Rows processed: 4704

28332 Processing Dimension 'dst_flia_prodto.ancho' Start time: 08:42:36 a.m.

28332 Process information for Dimension 'dst_flia_prodto.ancho': An incremental dimension update is performed

28332 Initializing Dimension 'dst_flia_prodto.ancho'

28332 Dimension 'dst_flia_prodto.ancho' Execute : SELECT DISTINCT "dbo"."dim_familia_producto"."ancho", "dbo"."dim_familia_producto"."ancho" FROM "dbo"."dim_familia_producto"

28332 Data source provider error: Errors occurred while reading one or more columns; Time:24/08/2002 08:42:37 a.m.

28332 Processing Dimension 'dst_flia_prodto.ancho' failed. No changes have been made to the database.

28332 Rolling back transaction in Database 'dm_gego'

tfcarlos SSC Journeyman Points: 92 More actions · Answer 3

quote:
Have you checked the permissions of the user account that SQLServerAgent is running under? Seems like a lot of these issues are centered around proper access permissions of the service involved...
hth,
Michael
Michael Weiss