Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Unanswered: DTS Olap Task error

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Seattle, WA USA
    Posts
    21
    Have you checked the user permissions under which the SQLServerAgent is running? The agent needs to have adequate permissions to execute the task...
    hth,
    Michael

  3. #3
    Join Date
    Aug 2002
    Posts
    2

    Post

    Originally posted by mhweiss
    Have you checked the user permissions under which the SQLServerAgent is running? The agent needs to have adequate permissions to execute the task...
    hth,
    Michael
    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 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'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •