SAP Knowledge Base Article - Preview

2845510 - Error: Cannot import the metadata table <name=AL_SETOPTIONS>.

Symptom

  • Error: Cannot import the metadata table <name=AL_SETOPTIONS>.
  • Migration from Oracle to SQL Server
  • Table <Table Name.AL_SETOPTIONS> cannot be import for datastore <Datastore Name>. Possible causes: (1) Table do not exist in the database; (2) Information for import was specified incorrectly. Check the import information and try again. If the name is case-sensitive in the database (and not all uppercase), enter the name as it appears in the database and use double-quotation marks around the name to preserve the case. (BODI-1112339)
  • (14.2) 10-01-19 08:18:04 (R) (0640:3424) DBS-070404: |Data flow DF_Intro_collection|Reader AL_SETOPTIONS2
    SQL submitted to ODBC data source <Data Source> resulted in error <[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid
    object name '<Object>.AL_SETOPTIONS'.>. The SQL submitted is <SELECT "AL_SETOPTIONS"."PARENT_OBJID" FROM
    "<Object>"."AL_SETOPTIONS" "AL_SETOPTIONS" WHERE ((((((( "AL_SETOPTIONS"."OPTION_NAME" = 'job_monitor_sample_rate') or (
    "AL_SETOPTIONS"."OPTION_NAME" = 'Parallelism_degree')) or ( "AL_SETOPTIONS"."OPTION_NAME" = 'Cache_type')) or (
    "AL_SETOPTIONS"."OPTION_NAME" = 'job_collect_statistics')) or ( "AL_SETOPTIONS"."OPTION_NAME" =
    'job_collect_statistics_monitor')) or ( "AL_SETOPTIONS"."OPTION_NAME" = 'job_use_statistics')) or (
    "AL_SETOPTIONS"."OPTION_NAME" = 'job_enable_dataquality')) >.


Read more...

Environment

  • SAP Information Platform Services 4.x
  • SAP Data Services 4.x
  • Oracle 
  • SQL Server

Product

SAP Data Services 4.2

Keywords

bods, ds, sql, queries, changes, migration, DB, AL_, jobs, ATL, copied , KBA , EIM-DS-SVR , Administration/Server , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.